with Price as (select date_trunc('day',RECORDED_HOUR) as ddate

, avg(CLOSE) as Price

from solana.price.fact_token_prices_hourly

where SYMBOL = 'WIF'

and ddate >= '2024-01-01'

group by 1)

, swaps as (

select date_trunc('day', BLOCK_TIMESTAMP) as date

, sum(SWAP_FROM_AMOUNT)*-1 as volume

, count(TX_ID)*-1 as transactions

, count(distinct SWAPPER)*-1 as swappers

, 'swap from' as action

from solana.defi.fact_swaps

where SWAP_FROM_MINT = 'EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm'

and SUCCEEDED = 'TRUE'

and date >= '2024-01-01'

group by 1

select date_trunc('day',BLOCK_TIMESTAMP) as date

, sum(SWAP_TO_AMOUNT) as volume

, count(TX_ID) as transactions

, count(distinct SWAPPER) as swappers

, 'swap to' as action

from solana.defi.fact_swaps

where SWAP_TO_MINT = 'EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm'

and SUCCEEDED = 'TRUE'

and date >= '2024-01-01'

group by 1)

select s.date

, s.volume*p.price as volume