Kaskoazul2023-01-08 11:06 PM
    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