select hour::date as price_date,

token_address,

symbol,

avg(price) as price

from solana.price.ez_prices_hourly

-- where price_date = Current_date

group by all

count(distinct user_address) as user_count,

sum(case when platform = 'deBridge' then amount * price end) as debridge,

sum(case when platform = 'mayan finance' then amount * price end) as mayan,

sum(case when platform = 'wormhole' then amount * price end) as wormhole

from solana.defi.fact_bridge_activity

join price on (

block_timestamp::date = price_date and

token_address = mint)

where succeeded

and block_timestamp >= CURRENT_DATE - {{lookback_days}}

AND user_address IN (

'4GQeEya6ZTwvXre4Br6ZfDyfe2WQMkcDz2QbkJZazVqS',

'JD25qVdtd65FoiXNmR89JjmoJdYk9sjYQeSTZAALFiMy',

'Hq8MmCBFavX2GooSCk9XFp4Whue3wmC3jaZqk1zDgSXx',

'HBGdumkxEsZUsWz2sbg4GvHqJW9wA7CTa5sN9pn6pGMB',

'Fw5RSJEAqoUEY6rr4AAjN8UFCSsZCSqF42ndRjin1TFA',

'6n9VGHytR4SPBZQSoWVLgH2hLHmfXSSFJsbHAdMr5zzE',

'GCvHhEUYQwTJ8jyf8Lc4bv8jBXyZU4LMMsZCobwEPzvM',

'MfDuWeqSHEqTFVYZ7LoexgAK9dxk7cy4DFJWjWMGVWa',

'7of9rX4qvtMQFYKi3x64PPzC3EqY1759bJENHzSp4BMU',

'DEiDqiiBQi54ZdVXKcq2sP5TobTWH258JL3gZgDYE6oD',

'4Pwm4H7HKJonHSy9drWqdz4ij584jRidQAMVCSGwk2Ms',

'9rx2sFooy7kJXXFBAS1hJJekEhhtDQPyEpEpogdjnit1',

'664yPUmgPqFcjTjCsRQRXZ4rAKDkF2vSwhyndeBgsYJy',

'HmdyD9rq4MZAWkec8i7E7PDWJbB6TrWpEvbHUueqcRc8',