Description
Describe the bug
The bitcoin dataset provided in the cryptocurrency tutorials claim the dataset is updated daily, see here. However, when I downloaded the dataset it seems to have last been updated on 2023-11-21. I've downloaded the dataset on a couple of machines to verify that it's not some issue related to a single machine (but all of the machines I've downloaded on are on the same network). Link to the dataset is here, would be nice for a reviewer to sanity check that the dataset is truly out of date.
The second part of the tutorial uses quite a few NOW() calls, so all of these are broken if the dataset isn't kept up to date.
What do the docs say now?
SELECT
bucket AS "time",
tx_count as "tx volume",
average(stats_fee_sat) as fees
FROM one_hour_transactions
WHERE bucket > NOW() - INTERVAL '2 days'
ORDER BY 1;What should the docs say?
SELECT
bucket AS "time",
tx_count as "tx volume",
average(stats_fee_sat) as fees
FROM one_hour_transactions
WHERE bucket > date_add('2023-11-22 00:00:00+00', INTERVAL '-2 days')
ORDER BY 1;(or something along those lines, I'm not experienced with SQL :) ).
Alternatively, y'all could just fix the dataset to be kept up to date. But I figure that it'd be less work to just keep the dataset in november of 2023.
Page affected
Subject matter expert (SME)
[If known, who is a good person to ask about this topic]
Screenshots
[Attach images of screenshots showing the bug]
Any further info
[Anything else you want to add, or further links]
Contributing to documentation
We welcome documentation contributions!
- For information about how to propose a change, see the contributing guide in our GitHub repository.
- For information on style and word usage, see the style guide