AntonidasSmartContract Creation - Monthly
Updated 2023-03-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
⌄
-- forked from 57249c84-de8d-449a-9543-8a0f4f4706df
select
date_trunc('month', block_timestamp) as day_date,
event_type,
count(1) as num_count,
IFF(day_date = '2023-02-01 00:00:00.000', 'NumberOfContractsModifiedInFeb', 'NumberOfContractsModified') as color,
sum(num_count) over (order by day_date) as CumulativeNumberOfContractsModified
from flow.core.fact_events
where 1=1 --tx_id = '61134389d5438e563bc3e954f61f9c75b8c2d83c0747ca9e255f5d7e0b7484c3'
and event_type in ('AccountContractAdded')
and block_timestamp > current_date - 400
group by 1,2
/*
select * from flow.core.dim_contract_labels
limit 10
*/
Run a query to Download Data