Query editor
withlast_created_pools as (selectp.evt_block_time,t0.symbol as token0_symbol,p.token0,t1.symbol as token1_symbol,p.token1,p.fee,p.pool,p.evt_tx_hashfromuniswap_v3_ethereum.Factory_evt_PoolCreated pinner join tokens.erc20 t0 on p.token0 = t0.contract_addressand t0.blockchain = 'ethereum'inner join tokens.erc20 t1 on p.token1 = t1.contract_addressand t1.blockchain = 'ethereum'order byp.evt_block_time desclimit100)selectevt_block_time,token0_symbol || '-' || token1_symbol || format('%,.2f', fee / 1e4) || '%' as pool_name,'<a href=https://etherscan.io/address/' || cast(pool as varchar) || ' target=_blank>' || cast(pool as varchar) || '</a>' as pool_link,token0,token1,fee,evt_tx_hashfromlast_created_poolsorder byevt_block_time desc