KaskoazulGraph_viz
    Updated 2023-01-08
    with
    BONK_transfers as (
    select
    tx_from as source,
    tx_to as target,
    amount,
    tx_id,
    block_timestamp as fecha
    from
    solana.core.fact_transfers tf
    where
    mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'
    )
    select
    date_trunc('hour', fecha) as hora,
    count(distinct source) as unique_hourly_senders,
    count(distinct target) as unique_hourly_receivers,
    count(distinct tx_id) as unique_hourly_transfers,
    sum(amount) as hourly_volume
    from
    BONK_transfers
    group by
    1
    order by
    1 desc
    Run a query to Download Data