from crosschain.core.ez_hourly_prices

where token_address in ('0x6982508145454ce325ddbe47a25d4ec3d2311933',

lower('0x6B89B97169a797d94F057F4a0B01E2cA303155e4'),'0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce',

'0xcf0c122c6b73ff809c693db761e7baebe62b6a2e',

lower('0x7D8146cf21e8D7cbe46054e01588207b51198729'),

and date >= '2023-04-15'

group by 1,2,3

select RECORDED_HOUR as date, 'Bonk' as token_address, symbol, avg(close) as avg_price

from solana.core.fact_token_prices_hourly

where symbol = 'BONK'

and date >= '2023-04-15'

group by 1,2,3)

,

transfers as ( select date(a.block_timestamp) as date, project_name , symbol, tx_hash, to_address, amount_usd

from ethereum.core.ez_token_transfers a join crosschain.core.address_labels c on a.from_address = c.address

where label_type = 'cex'

and block_timestamp::date >= '2023-04-15' and symbol in ('CHAD','PEPE','SHIB','BOB','TURBO'))

select date,concat(symbol,' Users') as user, count(DISTINCT(tx_hash)) as total_tx, count(DISTINCT(to_address)) as users, sum(amount_usd) as volume

from transfers

group by 1,2