adriaparcerisasflow defi swaps
    Updated 16 hours ago
    WITH swaps AS (
    SELECT x.tx_hash,
    x.origin_from_address,
    x.contract_address,
    y.tx_fee,
    x.block_timestamp,
    CASE
    WHEN lower(x.contract_address) = LOWER('0x1b97100ea1d7126c4d60027e231ea4cb25314bdb') THEN 'ankrFLOWEVM'
    WHEN lower(x.contract_address) = LOWER('0x7f27352d5f83db87a5a3e00f4b07cc2138d8ee52') THEN 'USDC.e'
    WHEN lower(x.contract_address) = LOWER('0x5598c0652b899eb40f169dd5949bdbe0bf36ffde') THEN 'stFlow'
    WHEN lower(x.contract_address) = LOWER('0xd3bf53dac106a0290b0483ecbc89d40fcc961f3e') THEN 'WFLOW'
    ELSE 'FLOW'
    END AS asset,
    x.event_index,
    x.data,
    CASE
    WHEN lower(x.contract_address) = LOWER('0x1b97100ea1d7126c4d60027e231ea4cb25314bdb') THEN 18
    WHEN lower(x.contract_address) = LOWER('0x7f27352d5f83db87a5a3e00f4b07cc2138d8ee52') THEN 6
    WHEN lower(x.contract_address) = LOWER('0x5598c0652b899eb40f169dd5949bdbe0bf36ffde') THEN 18
    WHEN lower(x.contract_address) = LOWER('0xd3bf53dac106a0290b0483ecbc89d40fcc961f3e') THEN 18
    ELSE '18'
    END AS decimals,
    FROM flow.core_evm.fact_event_logs x
    JOIN flow.core_evm.fact_transactions y
    ON x.tx_hash = y.tx_hash
    WHERE (lower(y.to_address) = lower('0x3EF68D3f7664b2805D4E88381b64868a56f88bC4')
    AND x.origin_function_signature = '0xac9650d8')
    AND x.tx_succeeded = 'TRUE'
    AND LOWER(x.contract_address) IN (
    '0x1b97100ea1d7126c4d60027e231ea4cb25314bdb',
    '0x7f27352d5f83db87a5a3e00f4b07cc2138d8ee52',
    '0xd3bf53dac106a0290b0483ecbc89d40fcc961f3e',
    '0x5598c0652b899eb40f169dd5949bdbe0bf36ffde',
    '0x9c7efd8ecd7c5e8b51a3833f6fb67c6e2f4f4a9b',
    '0x68eb683a393c8a1c816255b4fc4b89d73c52ad4b',
    '0xd8ad8ae8375aa31bff541e17dc4b4917014ebdaa',
    Last run: about 16 hours ago
    WEEK
    PROTOCOL
    AVG_VOLUME_SWAPPED
    VOLUME_SWAPPED
    TOTAL_VOLUME
    SWAPS
    TOTAL_SWAPS
    ACTIVE_TRADERS
    1
    2025-04-13 00:00:00.000Increment Finance78.5334094592748.66933105124844063.2365121445132020
    2
    2025-04-13 00:00:00.000Punchswap1102.338497713371488.07372939942330118.29747943379333410
    3
    2025-04-13 00:00:00.000Trado562.49718549246124.76921035515253775.63362682466073
    4
    2025-04-12 00:00:00.000Increment Finance1843.3790961957144.75198187924841314.567181435127617
    5
    2025-04-12 00:00:00.000Punchswap610.560559615125775.47528077841958630.223752069299712
    6
    2025-04-12 00:00:00.000Trado519.52246848325976.12342415715207650.864415750465253
    7
    2025-04-11 00:00:00.000Increment Finance192.5395157188086.65966016924784169.8151992425123320
    8
    2025-04-11 00:00:00.000Others0.37735124780.3773512478311396235.56074678391206
    9
    2025-04-11 00:00:00.000Punchswap1071.044395538281684.67602652641832854.74846922639279111
    10
    2025-04-11 00:00:00.000Trado391.84161531130171.80437892915181674.740991577464753
    11
    2025-04-10 00:00:00.000Increment Finance839.35266209852039.86505010524776083.155539705119127
    12
    2025-04-10 00:00:00.000Punchswap768.628914772388926.23087438441551170.07244275069252811
    13
    2025-04-10 00:00:00.000Trado270.19528339744312.02647715115151502.9366126164463983
    14
    2025-04-09 00:00:00.000Increment Finance152.8330729915349.15755468224724043.2904889415112121
    15
    2025-04-09 00:00:00.000Punchswap716.113448803560716.83041284641162243.84156837839202219
    16
    2025-04-09 00:00:00.000Trado413.03871035791694.59369926915107190.9101354222462343
    17
    2025-04-08 00:00:00.000Increment Finance49.2638003312167.60721454524718694.1329342535108015
    18
    2025-04-08 00:00:00.000Others348.586615348.586615311396235.18339518391131
    19
    2025-04-08 00:00:00.000Punchswap889.136371867577049.50534145440601527.01115556499123912
    20
    2025-04-08 00:00:00.000Trado319.60222869574147.71705723615015496.3164362232460123
    ...
    383
    37KB
    11s