mucrypto2023-03-05 06:57 AM
    with wallets_from as (select
    date_trunc('day', block_timestamp) as day,
    from_address as sending,
    count(tx_hash) as sending_wallets
    from ethereum.core.fact_transactions
    where block_timestamp::date between '2022-05-04' and '2022-05-15'
    group by 1,2
    qualify row_number() over (partition by day order by sending_wallets desc) <= 5),

    wallets_to as (select
    date_trunc('day', block_timestamp) as day,
    to_address as receiving,
    count(tx_hash) as r
    from ethereum.core.fact_transactions
    where block_timestamp::date between '2022-05-04' and '2022-05-15'
    group by 1,2
    qualify row_number() over (partition by day order by r desc) <= 5),

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

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

    select wallets_from.day,
    wallets_from.sending_wallets,
    labels_from.sending_name,
    wallets_to.r
    from wallets_from
    join labels_from
    Run a query to Download Data