fanta4opeth
Updated 2023-04-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with table_50signers as (select count(*) , FROM_ADDRESS from ethereum.core.fact_transactions
group by 2
order by 1 DESC
limit 50)
(select 'transactions' as title , count(*) , dayofmonth(block_timestamp) from ethereum.core.fact_transactions
where FROM_ADDRESS in (select FROM_ADDRESS from table_50signers) and dayofmonth(block_timestamp) is not null
group by 3)
UNION
(select 'transfers' as title , count(*) , dayofmonth(block_timestamp) from ethereum.core.ez_eth_transfers
where ETH_FROM_ADDRESS in (select FROM_ADDRESS from table_50signers) and dayofmonth(block_timestamp) is not null
group by 3)
Run a query to Download Data