Comparision Blockchain by Date

rajsComparision Blockchain by Date

Updated 2023-01-23

with txs as

(

SELECT

'terra' as blockchain,

date_trunc('{{Granularity}}', block_timestamp) as date,

case when ('{{Granularity}}' = 'day' and date_trunc('{{Granularity}}', block_timestamp) = '2023-01-14') or

('{{Granularity}}' = 'hour' and date_trunc('{{Granularity}}', block_timestamp) = '2023-01-14 18:00:00.000')

then '2. Announcement Date'

when ('{{Granularity}}' = 'day' and date_trunc('{{Granularity}}', block_timestamp) < '2023-01-14') or

('{{Granularity}}' = 'hour' and date_trunc('{{Granularity}}', block_timestamp) < '2023-01-14 18:00:00.000')

then '1. Before Announcement Date'

when ('{{Granularity}}' = 'day' and date_trunc('{{Granularity}}', block_timestamp) > '2023-01-14') or

('{{Granularity}}' = 'hour' and date_trunc('{{Granularity}}', block_timestamp) > '2023-01-14 18:00:00.000')

then '3. After Announcement Date'

end as period,

count(tx_id) as no_of_txs,

count(distinct tx_sender) as no_of_users

from terra.core.fact_transactions

where block_timestamp between '{{StartDate}}' and '{{EndDate}}'

group by 1,2,3

-- order by 1

-- )

union all

-- (