SELECT

Hour

, symbol

, price AS t_price

FROM avalanche.price.ez_prices_hourly

WHERE 1=1

AND token_address = lower('0x87bbFc9DCB66Caa8ce7582A3F17B60a25cd8A248') -- $Td CA

ORDER BY 1 DESC

date_trunc(day, Hour) as day

, avg(t_price) as Price

, 1000000000000 as Circulating_Supply

, Price * Circulating_Supply as Market_Cap

, lag(Market_Cap, 1 , Market_Cap) over(order by day) as Prev_MC

, (Market_Cap - Prev_MC)/Prev_MC * 100 as "MC CHANGE %"

FROM TdPrice

GROUP BY

1

ORDER BY

1 DESC