select date_trunc(day,hour) as day, avg(price) as price

from crosschain.price.ez_hourly_token_prices

where symbol='TRX' and TOKEN_ADDRESS='0xce7de646e7208a4ef112cb6ed5038fa6cc6b12e3'

group by 1

),

raw_inflow_transfers as (

--S1 34-23

select

livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/be347279-70e6-45e5-b751-bd30ccb0124a/latest-run')

as response

union

select

livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/9f50b519-1a8e-42fe-8d6b-fe7f130e8a3f/latest-run')

union

select

livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/56fa8745-600b-4a4f-a4f1-de1676f9b64b/latest-run')

union

select

livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/59e63f4c-3a49-4f6b-8dd4-6a12d0e57315/latest-run')

union

select

livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/de7fd6bf-a79e-4ebe-9e5b-2db53799ff6d/latest-run')

union

select

livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/5f1b3872-4069-4b59-9325-689cfb1f9410/latest-run')

--S2 19-23

union

select