adriaparcerisasPunchswap trump swaps
    Updated 2025-04-07
    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('0x9C7Efd8ecD7C5e8b51a3833F6FB67c6E2F4f4a9B') THEN 'FROTH'
    WHEN lower(x.contract_address) = LOWER('0x68eb683a393C8a1C816255b4FC4B89d73C52AD4b') THEN 'PUMP'
    WHEN lower(x.contract_address) = LOWER('0xd8Ad8AE8375aa31BFF541e17dC4b4917014EbDAa') THEN 'BETA'
    WHEN lower(x.contract_address) = LOWER('0x995258Cea49C25595CD94407FaD9E99B81406A84') THEN 'AVO'
    WHEN lower(x.contract_address) = LOWER('0xEC0F7E75128781c2924Ad907A379909Ae531d050') THEN 'LOPPY'
    WHEN lower(x.contract_address) = LOWER('0x6a2cD141d75864944318acf272443FEBC54855a9') THEN 'VINYL'
    WHEN lower(x.contract_address) = LOWER('0x4DcDd1b9A5103fA5F13CC4c3b758E05FFaccb4DD') THEN 'MVP'
    WHEN lower(x.contract_address) = LOWER('0x169bb04590fbF18B09739f951274Aa5650DFcCdE') THEN 'TSR'
    WHEN lower(x.contract_address) = LOWER('0xD59D7c7F4D063A707a021C7c49c5cFb4fAF94cB0') THEN 'PEPE'
    WHEN lower(x.contract_address) = LOWER('0x40b0f603Fd1165db32AF769771428Be100f8434E') THEN 'COON'
    when lower(x.contract_address)=lower('0x8b2f3a6e7ad5f971ff5d4e597a4ebc58b2d2758e') then 'DUCAT'
    when lower(x.contract_address)=lower('0xd3378b419feae4e3a4bb4f3349dba43a1b511760') then 'TRUMP'
    ELSE 'wFLOW'
    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('0x9C7Efd8ecD7C5e8b51a3833F6FB67c6E2F4f4a9B') THEN 18
    WHEN lower(x.contract_address) = LOWER('0x68eb683a393C8a1C816255b4FC4B89d73C52AD4b') THEN 18
    WHEN lower(x.contract_address) = LOWER('0xd8Ad8AE8375aa31BFF541e17dC4b4917014EbDAa') THEN 18
    WHEN lower(x.contract_address) = LOWER('0x995258Cea49C25595CD94407FaD9E99B81406A84') THEN 18
    WHEN lower(x.contract_address) = LOWER('0xEC0F7E75128781c2924Ad907A379909Ae531d050') THEN 18
    WHEN lower(x.contract_address) = LOWER('0x6a2cD141d75864944318acf272443FEBC54855a9') THEN 18
    Last run: 22 days ago
    DATE
    PRICE
    VOLUME_USD
    TOTAL_VOLUME_USD
    SWAPS
    TOTAL_SWAPS
    SWAPPERS
    AVG_VOLUME
    1
    2025-02-20 00:00:00.00053166.231540892304806.63692538211741166.231540892
    2
    2025-02-17 00:00:00.0005363.451079153304640.405384492173231.725539576
    3
    2025-02-16 00:00:00.00053120.80875996304576.9543053382171260.40437998
    4
    2025-02-15 00:00:00.00053186.432893288304456.14554537811691186.432893288
    5
    2025-02-10 00:00:00.0005310680.897635381304269.71265209216825340.448817691
    6
    2025-02-09 00:00:00.000530.4774679919293588.815016709316610.1591559973
    7
    2025-02-08 00:00:00.000532.693180647293588.337548717116312.693180647
    8
    2025-02-06 00:00:00.0005383.95670175293585.644368072162241.978350875
    9
    2025-02-03 00:00:00.000535.764653401293501.68766632116015.764653401
    10
    2025-02-02 00:00:00.0005327450.557394531293495.923012919315929150.185798177
    11
    2025-02-01 00:00:00.000532061.997858497266045.365618388215611030.998929248
    12
    2025-01-30 00:00:00.0005359.228623435263983.3677598913154119.742874478
    13
    2025-01-29 00:00:00.0005317.471818945263924.139136456415134.367954736
    14
    2025-01-28 00:00:00.0005317437.866579071263906.667317512314735812.622193024
    15
    2025-01-27 00:00:00.000531249.620824335246468.80073844161446208.270137389
    16
    2025-01-26 00:00:00.000536570.040676417245219.17991410581385821.255084552
    17
    2025-01-25 00:00:00.000531755.111964675238649.139237688101305175.511196467
    18
    2025-01-24 00:00:00.0005313361.942105756236894.027273013412033340.485526439
    19
    2025-01-23 00:00:00.0005339270.31200007223532.08516725618116122181.684000004
    20
    2025-01-22 00:00:00.0005331910.011507551184261.7731671861998131679.474289871
    21
    2KB
    15s