from $query('ea03a1b6-f263-4068-a664-4b66a50adef9')

),

price_tab as (select

HOUR::date as day,

TOKEN_ADDRESS,

SYMBOL,

DECIMALS,

avg(PRICE) as price

from ethereum.price.ez_prices_hourly

where HOUR >= '2024-06-10'

group by 1,2,3,4

),

add_liquidity as (select

from ethereum.core.fact_event_logs

where TOPICS[0]= '0x16768f4ecc93786618270641524e6209d40480302598062adee1bf55a3e7da29'

and CONTRACT_ADDRESS in (select POOL from pools)

and CONTRACT_ADDRESS = '{{Liquidity_pool_address}}'

),

add_liquidity1 as (select

t.block_timestamp,

t.tx_hash,

FROM_ADDRESS as pool,

token_pair as pool_name,

s.origin_from_address as user,

DECODED_INPUT_DATA:tokenA as tokenA,

DECODED_INPUT_DATA:amountA as amountA,

DECODED_INPUT_DATA:tokenB as tokenB,

DECODED_INPUT_DATA:amountB as amountB