Updated code to retain only 48 hours' worth of data

richardogoma / bitcoin-rate-etl

An ETL pipeline to ingest near-real time data of Bitcoin rates across major currencies (USD/GBP/EUR) from the CoinDesk Bitcoin Price Index API.

MIT License

0 stars 1 forks source link

Updated code to retain only 48 hours' worth of data #5

Closed richardogoma closed 1 year ago

richardogoma commented 1 year ago

This issue #4 has been resolved

Closes #4

sqlite> select * from bitcoin_rates limit 1;
980|2023-06-14T11:30:00+00:00|Bitcoin|25980.3902|21709.0062|25308.6932
sqlite> select * from bitcoin_rates order by unique_number desc limit 1;
2765|2023-06-16T11:30:00+00:00|Bitcoin|25453.3984|21268.6561|24795.3262