Query editor
-- Get Swap interactions with MoonFee hook, which dynamically changes the swap based on moon waning and waxing-- linearly increases to a 5% fee when the moon is waxing to a full moon, then it linearly decreases from 5% if its waning to a new moonwith selected_pools as (select id as pool_id -- 28, currency0, currency1, fee / 1e4 as pool_fee_pct, hooksfrom uniswap_v4_sepolia.PoolManager_evt_Initializewhere hooks = 0x9067ABa6C8D31113910B41e386c4Ea52bAFBC080 -- MoonFee)select evt_block_time, evt_tx_hash, id as pool_id, sender, amount0, amount1, sqrtPriceX96, liquidity, fee / 1e4 as swap_fee_pctfrom uniswap_v4_sepolia.PoolManager_evt_Swapwhere id in (select pool_id from selected_pools)order by 1 desc