Query: Price of XRP vs. US money supply by Jeff

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

date	xrp_price	US_money_supply
2018-02-01	0.9625	3855100
2018-03-01	0.9283	3800600
2018-04-01	0.4851	3727100
2018-05-01	0.8414	3674800
2018-06-01	0.6234	3650500
2018-07-01	0.4614	3618300
2018-08-01	0.4459	3584500
2018-09-01	0.3477	3559800
2018-10-01	0.5765	3520900
2018-11-01	0.4557	3476300
2018-12-01	0.3729	3400700
2019-01-01	0.3648	3346900
2019-02-01	0.3085	3353500
2019-03-01	0.3173	3381500
2019-04-01	0.3127	3286700
2019-05-01	0.3047	3244500
2019-06-01	0.4306	3274800
2019-07-01	0.4069	3260300
2019-08-01	0.3179	3271400
2019-09-01	0.2581	3202700
2019-10-01	0.2496	3252800
2019-11-01	0.2926	3315600
2019-12-01	0.2253	3426500
2020-01-01	0.1927	3442600
2020-02-01	0.2415	3454500
2020-03-01	0.2288	3883100
2020-04-01	0.1753	4844900
2020-05-01	0.2192	5149400
2020-06-01	0.2102	5001800
2020-07-01	0.177	4700300
2020-08-01	0.2895	4807400
2020-09-01	0.2957	4880300
2020-10-01	0.2382	4917100
2020-11-01	0.2398	5093000
2020-12-01	0.6129	5206600
2021-01-01	0.2374	5248000