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

)

, sell_table as (

select

date_trunc('hour', block_timestamp) as date,

origin_from_address as trader,

- amount_in as volume

from base.defi.ez_dex_swaps

where token_in= (select token_address from token_meta where ticker = '{{Ticker_list}}')

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

, buy_table as (

select

date_trunc('hour', block_timestamp) as date,

origin_from_address as trader,

amount_out as volume

from base.defi.ez_dex_swaps

where token_out= (select token_address from token_meta where ticker = '{{Ticker_list}}')

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