Mrfti2023-07-20 01:56 AM
Updated 2025-01-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
(
SELECT 'before halving' as halving,
date_trunc (hour, block_timestamp) as date2,
count (DISTINCT tx_hash) as "Total transactions"
from bitcoin.core.fact_transactions
where date2 BETWEEN '2020-05-05 00:00:00.000' AND '2020-05-11 18:00:00.000'
GROUP by 2
order by 2
)
UNION
(
SELECT 'after halving' as halving,
date_trunc (hour, block_timestamp) as date2,
count (DISTINCT tx_hash) as "Total transactions"
from bitcoin.core.fact_transactions
where date2 BETWEEN '2020-05-11 18:00:00.000' AND '2020-05-20 00:00:00.000'
GROUP by 2
order by 2
)
QueryRunArchived: QueryRun has been archived