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

from_address as holder,

- amount as amount

from base.core.ez_token_transfers

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

)

, table_out as (

select

to_address as holder,

amount as amount

from base.core.ez_token_transfers

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

, swap_table as (

select * from table_in

union all

select * from table_out