fanta3opeth
    Updated 2023-04-07
    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(*) , dayname(block_timestamp) from ethereum.core.fact_transactions
    where FROM_ADDRESS in (select FROM_ADDRESS from table_50signers) and dayname(block_timestamp) is not null
    group by 3)

    UNION

    (select 'transfers' as title , count(*) , dayname(block_timestamp) from ethereum.core.ez_eth_transfers
    where ETH_FROM_ADDRESS in (select FROM_ADDRESS from table_50signers) and dayname(block_timestamp) is not null
    group by 3)
    Run a query to Download Data