mucrypto2023-03-02 09:54 AM
    Updated 2023-03-02
    with transfers as (select
    date_trunc('day', block_timestamp) as day,
    contract_address,
    count(tx_hash) as n_of_transfers
    from ethereum.core.fact_token_transfers
    where block_timestamp::date between '2023-01-01' and '2023-03-01'
    group by 1,2
    qualify row_number() over (partition by day order by n_of_transfers desc) <= 5),

    labels as (select
    address,
    address_name
    from ethereum.core.dim_labels
    group by 1,2)

    select transfers.day, transfers.n_of_transfers, labels.address, labels.address_name
    from transfers
    join labels
    on transfers.contract_address=labels.address
    Run a query to Download Data