LTirrell2023-08-29 04:19 PM
    Updated 2023-08-29
    select
    block_timestamp,
    tx_id,
    purchaser,
    seller,
    mint,
    sales_amount
    from
    solana.core.fact_votes_agg_block
    where
    PROGRAM_ID = 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K'
    and succeeded = 'True'
    and date_trunc('hour', block_timestamp) = {{ date }}
    Run a query to Download Data