with raw_transfers as (
SELECT
livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/2d132eb6-7524-4853-994f-8d7f91097edc/latest-run')
as response
) ,
flattened_transfers as (
select
value[0]::string as tx_hash,
to_timestamp(value[1]::string) as day,
value[2]::string as from_address,
value[3]::string as to_address,
value[4]::int as amount,
value[5]::string as symbol
from raw_transfers , lateral FLATTEN (input => response:data:data)
),
stables_prices as (
select
hour::date as day,
symbol,
avg(price) as daily_price
from ethereum.price.ez_hourly_token_prices
where hour::date >= '2021-09-23'
and token_address IN (
'0xdac17f958d2ee523a2206206994597c13d831ec7', --usdt
'0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' --usdc
)
group by day, symbol
),
raw_tron_price as (
select