SELECT tx_hash, event_name, contract_address, date_trunc('day', block_timestamp) as date, event_inputs

FROM ETHEREUM.CORE.FACT_EVENT_LOGS

WHERE event_name = 'Swap'

AND contract_address = lower('0xceff51756c56ceffca006cd410b03ffc46dd3a58')

AND date >= '2022-04-01'

AND date <= '2022-04-15'

),

pools AS (

SELECT pool_name, pool_address, token0, token1

FROM ETHEREUM.CORE.DIM_DEX_LIQUIDITY_POOLS

WHERE pool_address = lower('0xceff51756c56ceffca006cd410b03ffc46dd3a58')

),

decimals AS (

SELECT address, decimals, symbol

FROM ETHEREUM.CORE.DIM_CONTRACTS

WHERE ADDRESS = (

SELECT token0

FROM pools

OR ADDRESS = (

SELECT token1

FROM pools

),

pools_token_details AS (

SELECT pool_name, pool_address, token0, token1,

token0.symbol AS token0symbol,

token1.symbol AS token1symbol,

token0.decimals AS token0decimals,