,

price as ( select * from $query('a9173a1d-ac70-4146-9495-6467fee7100c'))

,

price_daily as ( select * from $query('56b70976-21df-422a-babe-abec9b569921'))

,

supply_ez as ( select ifnull(block_timestamp,INSERTED_TIMESTAMP) as block_time,

tx_hash,

INSERTED_TIMESTAMP,

token_price_address as token_address,

ORIGIN_FROM_ADDRESS as user_address,

b.symbol as token_name,

amount,

amount as amt

from sei.core_evm.ez_token_transfers a join token_bonk b on a.contract_address = b.yei_address

where from_address = '0x0000000000000000000000000000000000000000'

,

supply as (select block_time::date as date,

tx_hash,

token_address,

user_address,

token_name,

amt,

case when token_name in ('FRAX','sFRAX','fastUSD','USDT','USDT0','USDC','sfastUSD') then amt else amt*avg_price end as amount_usd

from supply_ez a left outer join price b on a.token_address = b.address

where date >= '2024-05-27'

,

withdraw_ez as ( select ifnull(block_timestamp,inserted_timestamp) as block_time,

tx_hash,

token_price_address as token_address,