SELECT

block_timestamp,

tx_hash,

origin_from_address,

origin_to_address,

decoded_log:recipient AS recipient,

decoded_log:amount0 AS amount0,

decoded_log:amount1 AS amount1,

contract_address AS pool_address

FROM base.core.ez_decoded_event_logs

WHERE contract_address = '0x0fac819628a7f612abac1cad939768058cc0170c' -- ION/WETH Pool

AND event_name = 'Claim'

AND block_timestamp > '2024-04-01'

),

pool_info AS (

SELECT

pool_address,

tokens:token0::string AS token0_address,

tokens:token1::string AS token1_address

FROM base.defi.dim_dex_liquidity_pools

WHERE pool_address = '0x0fac819628a7f612abac1cad939768058cc0170c'

DATE_TRUNC('hour', ce.block_timestamp) AS claim_hour,

ce.tx_hash,

ce.origin_from_address,

ce.origin_to_address,

ce.recipient,

t0.symbol AS token0_symbol,

t0.name AS token0_name,

ce.amount0 / POWER(10, t0.decimals) AS amount_token0,

t1.symbol AS token1_symbol,

t1.name AS token1_name,

ce.amount1 / POWER(10, t1.decimals) AS amount_token1

FROM claim_events ce