rain_syndicadeBridge FINAL QUERY CORRECT
    Updated 2024-01-23
    with

    -- base_sol_tx as (
    -- select distinct tx_id, index
    -- from solana.core.fact_events
    -- where block_timestamp >= '2023-07-01' and block_timestamp < CURRENT_DATE
    -- and program_id = 'src5qyZHqTqecJV4aY6Cb6zDZLMDzrDKKezs22MPHr4'
    -- )
    base_sol_to as (
    select distinct tx_id, index
    from solana.core.fact_events
    where block_timestamp >= '2023-07-01' and block_timestamp < CURRENT_DATE
    and program_id = 'dst5MGcFPoBeREFAA5E3tU5ij8m5uVYwkzkSAbsLbNo'
    and signers[0] in ('7FfB2zQRYUQwpPzkRxAeg2mCBGeCRKp4PCEeULJA9xTo', '2r8DCWwEeaUHNMoDzTPj7v2qnT5jtw4U4UiKu1aMXyVG', 'EePcPwmz8o2jxNd1xqyfzn2TwKN6gZv6TfAtEVi94M2u', 'BWf3qqNtJoAQxVvpggn8yW1HXXfZ4Rxc6dwYADUBEHme', '4pfzS9HmDxs4AMbbAUYjWvpfLoNKYMk4B75nerNZC2bB', '6qPkNbWQmyufAtgKD37NFTRzBomd4pMav35ia3xUzsYe', 'E3Z9rpFKgBU7dAUixHccdHkMM6H2FfBdeMHANVP7brA5')
    )
    , solana_price as (
    select recorded_hour::date as price_date,
    upper(symbol) as symbol,
    token_address,
    avg(close) as price
    from solana.price.ez_token_prices_hourly
    group by 1,2,3
    )
    , sol_price as (
    select recorded_hour::date as price_date,
    upper(symbol) as symbol,
    token_address,
    avg(close) as sol_price
    from solana.price.ez_token_prices_hourly
    where upper(symbol) = 'SOL'
    group by 1,2,3
    )
    -- , from_solana as (
    -- select block_timestamp::date as date,
    -- 'From' as route_type,
    -- 'Solana' as chain,
    Last run: about 1 year ago
    SUM(VOLUME_USD)
    1
    80513202.664364
    1
    19B
    54s