(select * from

polygon.core.fact_token_transfers

where origin_to_address = '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d' and to_address in ('0x8de9c5a032463c561423387a9648c5c7bcc5bc90', '0x5b3256965e7c3cf26e11fcaf296dfc8807c01073')

and origin_function_signature = '0xbbbfa60c' and contract_address in ('0x2791bca1f2de4661ed88a30c99a7a9449aa84174'

,'0x8f3cf7ad23cd3cadbd9735aff958023239c6a063',

'0x7ceb23fd6bc0add59e62ac25578270cff1b9f619'

)),

prices as

(SELECT date(hour) as day_, avg(price) as avg_price from ethereum.core.fact_hourly_token_prices

where symbol = 'WETH'

GROUP by 1 )

SELECT date(block_timestamp) as day,contract_name, from

(SELECT *,

case when contract_address = '0x2791bca1f2de4661ed88a30c99a7a9449aa84174' then raw_amount/pow(10,6)

when contract_address = '0x7ceb23fd6bc0add59e62ac25578270cff1b9f619' then raw_amount/pow(10,18)*avg_price

when contract_address = '0x8f3cf7ad23cd3cadbd9735aff958023239c6a063'then raw_amount/pow(10,18) end as price_usd ,

case when contract_address = '0x2791bca1f2de4661ed88a30c99a7a9449aa84174' then 'USDC'

when contract_address = '0x7ceb23fd6bc0add59e62ac25578270cff1b9f619' then 'WETH'

when contract_address = '0x8f3cf7ad23cd3cadbd9735aff958023239c6a063'then 'DAI' end as contract_name

from sales

left join prices on date(block_timestamp) = day_ )

GROUP by 1