kgmm2019hist_sig
    Updated 2025-03-15
    -- forked from all_data @ https://flipsidecrypto.xyz/studio/queries/4ee7dc90-c622-4860-b92c-f0cf5d25f470

    -- forked from of2_rolling_usd_val copy @ https://flipsidecrypto.xyz/studio/queries/0bbed8e4-22da-4b78-9d4a-f8dc1384a4f6

    -- forked from of2_rolling_usd_val @ https://flipsidecrypto.xyz/studio/queries/a5daca41-618d-4da6-bf20-e7d6fd02c8f7

    -- forked from of2 @ https://flipsidecrypto.xyz/studio/queries/7b73360d-c132-449e-adf9-68b9bb31292e

    --select block_timestamp,tx_id,swapper,swap_from_mint,swap_from_symbol,swap_from_amount,swap_from_amount_usd,swap_to_symbol,swap_to_amount,swap_to_amount_usd
    --from solana.defi.ez_dex_swaps where tx_id = '4bQ3FzkEoQ1Bny9rz6my4yKN9hUHyghy8NYsHth5bKLc2ajkHghwcfTrMNhkTcs2oqnCx6SGMyiiZptxyohywhks'




    WITH cte_ca as (

    select '9m3nh7YDoF1WSYpNxCjKVU8D1MrXsWRic4HqRaTdcTYB' as ca

    ),
    cte_start_ts as (

    select '2025-03-12 13:37:00' as start_ts
    ),
    cte_end_ts as (

    select '2025-03-13 16:10:00' as end_ts
    ),
    cte_amm as (
    --select 'GpMZbSM2GgvTKHJirzeGfMFoaZ8UR2X7F4v8vHTvxFbL' as amm --'5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1'
    -- union all
    select '5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1' as amm

    ),
    QueryRunArchived: QueryRun has been archived