flipside

    top_pools
    maybeyonastop_pools
    Updated 9 days ago
    with
    trades as (
    select *
    from $query('c8fb0520-bd83-437f-808a-87f9b0ec8d1e')
    )

    select
    dex,
    pool_name as pool,
    count(*) as swaps,
    sum(coalesce(amount_sold_usd,-amount_bought_usd)) as volume,
    avg(coalesce(amount_sold_usd,-amount_bought_usd)) as avg_volume,
    min(block_timestamp) as first_appearance,
    max(block_timestamp) as last_appearance,
    from trades
    group by 1,2
    order by volume desc
    Last run: 9 days ago
    DEX
    POOL
    SWAPS
    VOLUME
    AVG_VOLUME
    FIRST_APPEARANCE
    LAST_APPEARANCE
    1
    		ambientETH/USDe3144732345413.35542881028.5691275932024-12-19 15:29:01.0002025-03-04 14:11:53.000
    2
    		ambientETH/SWELL87074066160.143129466.9989827872024-12-24 17:21:45.0002025-03-04 13:36:17.000
    3
    		ambientENA/USDe195422436068.56388936124.6580986542025-01-14 14:27:33.0002025-03-04 14:11:23.000
    4
    		ambientrswETH/weETH256718088.7349357412805.0341208432025-01-06 21:48:59.0002025-03-04 13:40:47.000
    5
    		neptuneSWELL/WETH2468473408.386495616191.8186331022024-12-31 00:51:43.0002025-03-05 08:18:09.000
    6
    		ambientezETH/pzETH80348996.1543976194362.451929972025-01-14 22:48:37.0002025-03-02 10:44:21.000
    7
    		neptune0xea34/WETH2011309201.54796606153.7551208192024-12-26 08:25:29.0002025-03-05 08:22:15.000
    8
    		ambientrsETH/weETH89129235.7568109991452.087155182025-01-14 10:57:01.0002025-03-04 03:01:13.000
    9
    		ambientSWELL/rSWELL35286303.508367598245.1804214992025-01-04 07:51:27.0002025-03-04 09:08:17.000
    10
    		ambientETH/KING10251211.219933695502.0707836642025-02-14 15:01:19.0002025-03-04 11:30:45.000
    11
    		ambientETH/ezETH80643779.40371343254.3168780562025-01-01 09:05:59.0002025-03-04 12:06:25.000
    12
    		neptune0x8169/WETH10730356.563270938283.7061987942024-12-23 20:22:41.0002025-03-03 15:10:47.000
    13
    		neptune0x4661/WETH6430339.020797549474.0471999622024-12-25 14:38:19.0002025-03-04 02:47:25.000
    14
    		ambientETH/rswETH31921289.52036119866.7383083422024-12-19 15:29:23.0002025-03-04 13:40:37.000
    15
    		velodromeUSDe/WETH95514839.02368860415.53824472025-02-25 00:26:05.0002025-03-04 12:09:35.000
    16
    		neptuneWETH/weETH25012532.51906876950.1300762752025-01-15 04:14:01.0002025-03-04 13:40:33.000
    17
    		ambientETH/swETH456618.080645916147.0684587982024-12-23 08:58:37.0002025-03-03 17:50:57.000
    18
    		ambientETH/weETH2845659.87643815819.9291423882024-12-19 15:29:47.0002025-03-04 13:39:53.000
    19
    		velodromeSWELL/USDe2024286.73740148321.2214722852025-02-25 00:26:11.0002025-03-04 09:20:29.000
    20
    		neptuneUSDe/WETH17813063.0727835191.7198611922024-12-20 06:43:25.0002025-03-05 09:13:45.000
    46
    5KB
    1s