SELECT
CAST(xrp.date AS DATE) AS date,
xrp.close AS xrp_price,
money.bogmbase AS US_money_supply
FROM
@kaggle.nward7_popular_cryptocurrency_historical_data.xrp AS xrp
JOIN
@kaggle.rishabhab_treasury_yields_money_data_united_states.monetary_base AS money
ON
CAST(xrp.date AS DATE) = CAST(money.date AS DATE)
ORDER BY
date ASC