with trx_price as (
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