lj1024wormhole
    Updated 2024-11-04
    select
    date_trunc('month', block_timestamp) date,
    sum(amount) volume,
    count(*) count


    from solana.defi.fact_bridge_activity
    where 1 = 1
    and succeeded = true
    and date_trunc('day', block_timestamp) between '2024-01-01' and '2024-11-01'
    and mint = 'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn'

    group by date_trunc('month', block_timestamp)
    order by date_trunc('month', block_timestamp) desc
    limit 10
    QueryRunArchived: QueryRun has been archived