flipside

    swaps
    datavortexswaps
    Updated 2025-05-11
    WITH recent_swaps AS (
    SELECT origin_from_address, tx_hash
    FROM base.defi.ez_dex_swaps
    WHERE block_timestamp >= CURRENT_DATE - INTERVAL '6 months'
    )

    SELECT
    origin_from_address AS address,
    COUNT(DISTINCT tx_hash) AS swap_count
    FROM recent_swaps
    GROUP BY origin_from_address
    ORDER BY swap_count DESC
    LIMIT 100;

    Last run: about 1 month ago
    ADDRESS
    SWAP_COUNT
    1
    		0x53881155498cae8660195670591f1e23ae81431f2128826
    2
    		0xd5676ef8bc02b986e6f066c08341300541e3e9e61251717
    3
    		0xd0adade7cf2b6dd8b2f673c1b699dd21062a15ea1251132
    4
    		0xc1ecfe1d7f51674c6e7baf421bf9cf14e75f6d431228284
    5
    		0xa1c9e0381150eb24d164ef0db18e606e65f751af1138987
    6
    		0xf70da97812cb96acdf810712aa562db8dfa3dbef980216
    7
    		0xa9044701b6edecfc61c70842ebe21088c75e94c1916934
    8
    		0xa55c5950f7a3c42fa5799b2cac0e455774a07382910864
    9
    		0x2c1064f5139931021ae70df545349a36d937da25825033
    10
    		0xbb338992e6821a3befc4246c9a890f14047b0e63811283
    11
    		0xa1df8d5b6a432eaf9dd2a2eb268d0958a9bd889f752915
    12
    		0xecf4c7629d81c61f2a8babaca60a42d63dbfc0c0746862
    13
    		0x5e2af6acf8845def688926e6530c9e74c6f406d8697037
    14
    		0x5475ec93b04cc3babfbf4eddabb9b84cb5ba149d688142
    15
    		0xd13d8de21be3326ef81f368de0cea3a3e1d283e9670424
    16
    		0x9eaec213439eef944836b8c1f19e4121f64fc27c647004
    17
    		0x407510ca5c5531337207bf46a819f7a8db210c25625621
    18
    		0xd59109357e5533d7b272cdfd52a9e1ff634c471c622179
    19
    		0xfb1c505c975e229a7c9746141971abdab71f46c4613004
    20
    		0xff3dc8a691446d97b2af6711f61b5f30519780ec581333
    100
    5KB
    281s