price AS

SELECT

date_trunc( 'day' , a.hour ) AS date

, avg( a.price ) AS price

, a.token_address AS tkn_address

, a.decimals AS tkn_decimal

, a.symbol AS tkn_symbol

FROM

polygon.price.ez_hourly_token_prices a

GROUP BY 1 , 3 , 4 , 5

ORDER BY 1 DESC

,

final AS

SELECT

a.block_timestamp AS dt

, a.tx_hash AS tx

, a.origin_from_address AS bu

, b.nft_from_address AS se

, b.nft_address AS na

, b.project_name AS pj

, ( ( a.raw_amount_precise / power( 10 , c.tkn_decimal ) ) * c.price ) AS us

, c.tkn_symbol AS sb

FROM

polygon.core.fact_token_transfers a

JOIN

polygon.nft.ez_nft_transfers b

ON a.block_timestamp::date = b.block_timestamp::date

AND a.tx_hash = b.tx_hash

AND a.to_address = b.nft_from_address

JOIN