hrst79dimension x main
Updated 2023-03-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
with base as (
select
block_timestamp ,
proposer ,
tx_id
from flow.core.fact_transactions
where tx_id in (select TX_ID
from flow.core.fact_events
where EVENT_CONTRACT ilike '%Dimension%'
group by 1)
and TX_SUCCEEDED = 'true'
group by 1 ,2,3
)
select
--date_trunc('month',block_timestamp) as date,
count (distinct proposer) as users,
count (distinct tx_id) as txs,
txs/users as txn_per_user
from base
--group by 1
Run a query to Download Data