flipside

    colossal-blush
    slimeeeeecolossal-blush
    Updated 2025-03-24
    SELECT
    trader,
    SUM(COALESCE(amount_in_usd, amount_out_usd)) as total_volume_usd,
    COUNT(*) as num_trades,
    (SUM(COALESCE(amount_in_usd, amount_out_usd)) / SUM(SUM(COALESCE(amount_in_usd, amount_out_usd))) OVER()) * 100 as volume_percentage
    FROM near.defi.ez_dex_swaps
    WHERE
    (
    token_in_contract = 'blackdragon.tkn.near' OR token_out_contract = 'blackdragon.tkn.near'
    )
    AND trader LIKE '%.user.intear.near'
    AND block_timestamp >= '2024-12-20'
    AND block_timestamp < '2024-12-27'
    GROUP BY 1
    ORDER BY 2 DESC

    Last run: about 1 month ago
    TRADER
    TOTAL_VOLUME_USD
    NUM_TRADES
    VOLUME_PERCENTAGE
    1
    		metallic_degen0.user.intear.near324.2445790241025.229152588
    2
    		electric_degen.user.intear.near265.262526853220.639816974
    3
    		fiery_overlord7.user.intear.near248219.296636696
    4
    		green_spire3.user.intear.near108.08240266528.409785715
    5
    		electric_blob.user.intear.near56.40299132824.38866142
    6
    		sneering_enigma.user.intear.near53.54197929424.166048881
    7
    		metallic_blob.user.intear.near51.11822609623.977459022
    8
    		electric_contraption4.user.intear.near45.05183199643.505438849
    9
    		frozen_blob.user.intear.near39.7005576823.089061444
    10
    		green_bot.user.intear.near25.6521.995801336
    11
    		shadowy_sentinel8.user.intear.near24.402352512121.898723109
    12
    		fiery_virus6.user.intear.near17.2746326141.344122216
    13
    		chaotic_parasite.user.intear.near11.03072348510.8582897725
    14
    		green_overlord.user.intear.near9.7750735920.760588886
    15
    		green_blob6.user.intear.near5.1310.3991602671
    16
    		unfair_degen.user.intear.near0.333369017310.02593911618
    17
    		metallic_dog1.user.intear.near0.1875910.01459619386
    18
    		creepy_blob.user.intear.near0.00922148455610.0007175146664
    18
    1KB
    366s