FatemeTheLadyFLow
Updated 2022-05-31Copy Reference Fork
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
›
⌄
with l as (select * from flow.core.dim_contract_labels )
,t as (select * from flow.core.fact_transactions where BLOCK_TIMESTAMP::date>='2022-05-09' and BLOCK_TIMESTAMP::date<='2022-05-27' )
,f as (
SELECT
l.EVENT_CONTRACT,
l.CONTRACT_NAME,
count(distinct proposer) as num_proposer,
count(distinct e.tx_id) as num_txs
from flow.core.fact_events e
left join l on lower(e.EVENT_CONTRACT)=lower(l.EVENT_CONTRACT)
left join t on e.tx_id=t.tx_id
where e.TX_SUCCEEDED='1' and e.BLOCK_TIMESTAMP::date>='2022-05-09' and e.BLOCK_TIMESTAMP::date<='2022-05-27'
group by 1,2
order by 3 desc
limit 10)
select e.BLOCK_TIMESTAMP::date as days,
e.EVENT_CONTRACT,
l.CONTRACT_NAME,
count(distinct proposer) as daily_num_proposer,
count(distinct e.tx_id) as daily_num_txs
from flow.core.fact_events e
left join t on e.tx_id=t.tx_id
left join l on e.EVENT_CONTRACT=l.EVENT_CONTRACT
where lower(e.EVENT_CONTRACT) in (select lower(EVENT_CONTRACT) from f) and e.BLOCK_TIMESTAMP::date>='2022-05-09' and e.BLOCK_TIMESTAMP::date<='2022-05-27'
group by 1,2,3 order by 1 asc
Run a query to Download Data