select

value:PLATFORM::string as platform,

value:POOL_ADDRESS::string as pool_address,

value:TOKEN_NAME::string as name,

value:TICKER::string as ticker,

value:TOKEN_ADDRESS::string as token_address,

value:DECIMALS::numeric as decimals,

value:SUPPLY::numeric as supply

from (

select

livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/7aa557ad-d182-4403-b9ca-8a4b774530a3/data/latest') as response

), lateral FLATTEN (input => response:data)

order by 1 desc

)

, table_in as (

select

date_trunc('day', block_timestamp) as date,

platform,

sum(amount_in) as volume

from base.defi.ez_dex_swaps

where token_in in (select token_address from token_meta)

and date_trunc('day', block_timestamp)>= '2024-10-17'

group by 1,2

, table_out as (

select

date_trunc('day', block_timestamp) as date,

platform,

sum(amount_out) as volume

from base.defi.ez_dex_swaps

where token_out in (select token_address from token_meta)

and date_trunc('day', block_timestamp)>= '2024-10-17'

group by 1,2