Muzeprep volume daily
    Updated 2023-04-21
    -- forked from prep activity @ https://flipsidecrypto.xyz/edit/queries/306f03f7-a9b4-42a4-a631-6b42d5a9968f

    -- forked from Total prep activity @ https://flipsidecrypto.xyz/edit/queries/7e381f18-d4f6-4a84-b454-a730985c7e5b

    -- forked from prep activity @ https://flipsidecrypto.xyz/edit/queries/306f03f7-a9b4-42a4-a631-6b42d5a9968f

    with volume as (
    select
    tx_id as transactions

    from solana.core.fact_events
    where program_id = 'ZETAxsqBRek56DhiGXrn75yj2NHU3aYUnxvHXpkf3aD'
    and succeeded
    and block_timestamp >= '2023-01-01'
    ),

    prices as (
    select
    date_trunc('day', recorded_hour) as day,
    symbol,
    avg( close ) as price

    from solana.core.ez_token_prices_hourly
    group by 1,2
    ),

    zeta as (
    select
    substring(date_trunc('day', a.block_timestamp), 1, 10) as day,
    sum( a.amount * c.price ) as volume,
    'Zeta Markets' as program

    from solana.core.fact_transfers a
    left join solana.core.dim_tokens b on a.mint = b.token_address
    Run a query to Download Data