MuzeJupiter Routes Pools
    Updated 2023-05-13
    -- forked from Jupiter Routers Volume @ https://flipsidecrypto.xyz/edit/queries/7c32f153-501d-4598-9513-697fb4a31f4c

    -- forked from Jupiter Routers Total @ https://flipsidecrypto.xyz/edit/queries/cb51c164-f959-418d-8c9e-e69b752c6619

    -- forked from Jupiter Routers @ https://flipsidecrypto.xyz/edit/queries/ee760154-fa3d-4fa9-9ff5-a1088a7e1751

    -- forked from Volume @ https://flipsidecrypto.xyz/edit/queries/bd0285ba-7d5a-44de-9bd7-0e8c2932aeb3

    with prices as (
    select
    date_trunc('day', recorded_hour) as day,
    avg( close ) as price,
    token_address,
    token_name

    from solana.core.ez_token_prices_hourly
    where token_name not in ( 'Cope Token', 'Solminter' ) -- skewing data
    group by 1,3,4
    ),

    base as (
    select
    date_trunc('{{Date_Trunc}}', a.block_timestamp) as date,
    instruction :accounts[0] ::string as dex,
    a.tx_id,
    swap_from_mint,
    swap_to_mint
    -- concat(swap_from_mint, ' - ', swap_to_mint) as symbol

    from solana.core.fact_events a
    left join solana.core.fact_swaps b on a.tx_id = b.tx_id
    and a.block_timestamp = b.block_timestamp
    where a.program_id in (
    -- 'JUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB',
    'JUP3c2Uh3WA4Ng34tw6kPd2G4C5BB21Xo36Je1s32Ph',
    'JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo'
    Run a query to Download Data