h4wkPrice
    Updated 2024-08-05
    select hour::date as price_date,
    avg(case when symbol = 'BONKSOL' then price end) as "BonkSOL",
    avg(case when symbol = 'BONK' then price end) as "BONK"
    from solana.price.ez_prices_hourly
    where token_address in ('BonK1YhkXEGLZzwtcvRTip3gAL9nCeQD7ppZBLXhtTs', 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263')
    and price_date >= '2024-05-01'
    group by 1
    QueryRunArchived: QueryRun has been archived