BlockTrackeroverall metrics by platform
    Updated 2025-03-02
    WITH token_info AS (
    SELECT token_address,
    symbol,
    name,
    decimals
    FROM avalanche.price.ez_prices_hourly
    WHERE token_address IN (
    '0x440abbf18c54b2782a4917b80a1746d3a2c2cce1',
    '0x96e1056a8814de39c8c3cd0176042d6cecd807d7',
    '0xffff003a6bad9b743d658048742935fffe2b6ed7',
    '0x2d0afed89a6d6a100273db377dba7a32c739e314',
    '0x3cc96f3cb4f45b5b5cdbce61faee8ae80d805c65',
    '0x420fca0121dc28039145009570975747295f2329',
    '0x184ff13b3ebcb25be44e860163a5d8391dd568c1',
    '0xacfb898cff266e53278cc0124fc2c7c94c8cb9a5',
    '0x8ad25b0083c9879942a64f00f20a70d3278f6187',
    '0x87bbfc9dcb66caa8ce7582a3f17b60a25cd8a248',
    '0x4f94b8aef08c92fefe416af073f1df1e284438ec',
    '0x65378b697853568da9ff8eab60c13e1ee9f4a654',
    '0xe8385cecb013561b69beb63ff59f4d10734881f3',
    '0xebb5d4959b2fba6318fbda7d03cd44ae771fc999',
    '0x47c3118ad183712acd42648e9e522e13690f29a0',
    '0x79ea4e536f598dcd67c76ee3829f84ab9e72a558',
    '0xff24003428fb2e969c39edee4e9f464b0b78313d',
    '0x73831e7c5577859fb0583af97c9c68f96a43fcb6',
    '0x1c7c53aa86b49a28c627b6450091998e447a42f9',
    '0xe7d69acbc00d0ec5d9c02162310ee21daa77f69c',
    '0x68e551e7ef4bf59bf55b233bb6bea104b168ee24',
    '0xc654721fbf1f374fd9ffa3385bba2f4932a6af55',
    '0x48f88a3fe843ccb0b5003e70b4192c1d7448bef0',
    '0x2598c30330d5771ae9f983979209486ae26de875',
    '0x7698a5311da174a95253ce86c21ca7272b9b05f8'
    )
    GROUP BY ALL
    ),
    swap_data AS (
    Last run: 13 days ago
    DATE
    PLATFORM_
    SWAPPER
    TXNS
    CUMU_XNS
    SWAP_VOLUME
    CUMU_SWAP_VOLUME
    AVG_PER_TXNS
    DAILY_AVG_SWAP_VOLUME
    MA_7
    1
    2025-02-24 00:00:00.000Balancer2918673438425122.594715937.2528.8765402392469.35784313755554.988571429
    2
    2025-02-24 00:00:00.000Sushiswap48113104889.51782.890.76495726520.0324719158.502857143
    3
    2025-02-24 00:00:00.000Pharaoh53258137958928758858776.88529462920.24620.7945922468272858.1287567468852.7485714
    4
    2025-02-24 00:00:00.000Trader Joe7841104967329230631753466.722332826576.04231.5590919512150138.41687536503622.2571428
    5
    2025-02-24 00:00:00.000Uniswap10313466247176148277.9465368105.739.848949207895453.502739726503372.169999999
    6
    2025-02-24 00:00:00.000Pangolin1369532921702894734.6544449867.8716.44127907223366.170201005111754.011428572
    7
    2025-02-17 00:00:00.000Pangolin221910594211699163812.9244355133.2214.002301051224015.824343434105634.465714286
    8
    2025-02-17 00:00:00.000Trader Joe8762129520318733958862470.732301073109.32320.01430234312047503.190157134670600.1842857
    9
    2025-02-17 00:00:00.000Balancer62622613351786876.414690814.6637.88766245193816.293254637.794285714
    10
    2025-02-17 00:00:00.000Uniswap18488362243710490475.1565219827.7652.295036784905830.941111111595846.098571428
    11
    2025-02-17 00:00:00.000Pharaoh573410694750790894938825.96470604143.36790.0771109487469907.0374603260272693.2114286
    12
    2025-02-17 00:00:00.000Sushiswap62235935261.311693.391.07979338819.24306818247.001428571
    13
    2025-02-17 00:00:00.000Woofi1196520915839.942021805.71285714378549.25
    14
    2025-02-10 00:00:00.000Sushiswap204270023.331432.080.555476190516.46068965510.734285714
    15
    2025-02-10 00:00:00.000Trader Joe11932136997305781991763288.432242210638.59480.21732734311801108.624157928950028.5471428
    16
    2025-02-10 00:00:00.000Balancer67422223125678922.24603938.2534.99875831593957.92346938846659.882857143
    17
    2025-02-10 00:00:00.000Uniswap203510100235348499548.8764729352.6144.301957254911681.022676056588589.188571428
    18
    2025-02-10 00:00:00.000Pharaoh8860118021400961136526349.91375665317.41040.3117278036059118.0225806547245280.2871429
    19
    2025-02-10 00:00:00.000Pangolin260314829201105210239.244191320.312.939389463224321.4228426489429.902857143
    20
    2025-02-03 00:00:00.000Trader Joe816857955292082215585264.142150447350.16173.63455631211378028.307724917113027.7471428
    ...
    545
    61KB
    11s