0-MIDdaily users and txs by time
Updated 2024-08-02
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select BLOCK_TIMESTAMP::date as day
,case
when BLOCK_TIMESTAMP::date>='2024-01-01' and BLOCK_TIMESTAMP::date<='2024-03-31' then 'Q1'
when BLOCK_TIMESTAMP::date>='2024-04-01' and BLOCK_TIMESTAMP::date<='2024-06-30' then 'Q2' end as time_period
,count(distinct PROPOSER)as users
,count(distinct TX_ID) as txs
from flow.core.fact_transactions
where BLOCK_TIMESTAMP::date>='2024-01-01' and BLOCK_TIMESTAMP::date<='2024-06-30'
and TX_SUCCEEDED='true'
group by 1
QueryRunArchived: QueryRun has been archived