SELECT

block_timestamp,

swap_program,

swapper,

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 (swap_from_symbol = 'JUP'

OR swap_to_symbol = 'JUP')

AND block_timestamp >= '2024-01-31' -- Jupiter airdrop occurred on Jan 31, 2024

AND block_timestamp < '2024-05-31'

SELECT

DATE_TRUNC('hour', block_timestamp) as hour,

COUNT(*) as num_swaps,

COUNT(CASE WHEN swap_from_symbol = 'JUP' THEN 1 END) as num_sells,

COUNT(CASE WHEN swap_to_symbol = 'JUP' THEN 1 END) as num_buys,

SUM(CASE

WHEN swap_from_symbol = 'JUP' THEN swap_from_amount_usd

ELSE 0

END) as total_sell_volume_usd,

SUM(CASE

WHEN swap_to_symbol = 'JUP' THEN swap_to_amount_usd

ELSE 0

END) as total_buy_volume_usd,

SUM(CASE

WHEN swap_from_symbol = 'JUP' THEN swap_from_amount

ELSE 0

END) as total_jup_sold,

SUM(CASE