adriaparcerisasflow defi swaps
    Updated 15 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 15 hours ago
    WEEK
    PROTOCOL
    AVG_VOLUME_SWAPPED
    VOLUME_SWAPPED
    TOTAL_VOLUME
    SWAPS
    TOTAL_SWAPS
    ACTIVE_TRADERS
    1
    2025-04-21 00:00:00.000Increment Finance64.8325690333954.78671099925297288.528208655202829
    2
    2025-04-21 00:00:00.000Punchswap704.056119662233746.63172770244375523.96647373329602710
    3
    2025-04-21 00:00:00.000Trado358.47040362222942.10583179315491815.684401564472453
    4
    2025-04-20 00:00:00.000Increment Finance87.5797405414816.88572975925293333.741497515196324
    5
    2025-04-20 00:00:00.000Punchswap880.169546596181314.92659867844141777.3347462069569512
    6
    2025-04-20 00:00:00.000Trado309.41993944525372.43503445415468873.578569782471813
    7
    2025-04-19 00:00:00.000Increment Finance839.46337651864638.67999190525288516.8557673775191232
    8
    2025-04-19 00:00:00.000Others0.39584488860.3958448886311397195.65126828391362
    9
    2025-04-19 00:00:00.000Punchswap602.924690187180877.40705602143960462.40814733009548915
    10
    2025-04-19 00:00:00.000Trado408.90843354821263.23854451515443501.143535252470993
    11
    2025-04-18 00:00:00.000Increment Finance259.01049249913986.56659494625223878.1757754525183530
    12
    2025-04-18 00:00:00.000Punchswap756.475370611115740.73170347543779585.00109131539518914
    13
    2025-04-18 00:00:00.000Trado560.52335133720739.36399947215422237.904990737470473
    14
    2025-04-17 00:00:00.000Increment Finance691.41120941523507.98112009325209891.6091804485178329
    15
    2025-04-17 00:00:00.000Others58.84896694658.848966946311397195.25542318391341
    16
    2025-04-17 00:00:00.000Punchswap736.895330728166538.34474455943663844.26938792269503614
    17
    2025-04-17 00:00:00.000Trado251.96739871114614.10912521415401498.540991358470102
    18
    2025-04-16 00:00:00.000Increment Finance77.1526528792391.73223925625186383.6280603385173522
    19
    2025-04-16 00:00:00.000Others311397136.40645618391331
    20
    2025-04-16 00:00:00.000Punchswap928.813135073415179.47137757343497305.92464334479481016
    ...
    417
    40KB
    7s