flipside

    Base Query 4 - BitFLUX Swaps Size Over Time
    Zanyar_98Base Query 4 - BitFLUX Swaps Size Over Time
    Updated 9 hours ago
    WITH BTC_PRICE AS (
    (
    SELECT
    HOUR::DATE AS DATE,
    AVG(PRICE) AS PRICE_USD
    FROM
    bitcoin.price.ez_prices_hourly
    WHERE
    DATE > '2024-11-01'
    AND DATE < CURRENT_DATE
    AND SYMBOL = 'BTC'
    AND IS_NATIVE = TRUE
    GROUP BY DATE
    )
    UNION ALL
    (
    SELECT
    CURRENT_DATE AS DATE,
    VALUE[1]::FLOAT AS PRICE_USD
    FROM
    (SELECT LIVEQUERY.LIVE.UDF_API('GET', 'https://api.coingecko.com/api/v3/coins/bitcoin/market_chart?vs_currency=usd&days=1&interval=daily&precision=10', {'accept': 'application/json', 'x-cg-demo-api-key': 'CG-9moWcKkAVDcd6W1DzJrc3Ux6'}, {}) AS RESP), LATERAL FLATTEN (INPUT => RESP:data:prices)
    ORDER BY DATE_TRUNC('HOUR',TO_TIMESTAMP(VALUE[0]::STRING)) DESC
    LIMIT 1
    )
    ),

    BITFLUX_CURRENT_POOLS_ADDRESS AS (
    SELECT 'solvBTC.b / solvBTC.core / WBTC' AS POOL_NAME, '0x4bcb9ea3dacb8ffe623317e0b102393a3976053c' AS POOL_ADDRESS
    UNION ALL
    SELECT 'nBTC / BTCB / pumpBTC' AS POOL_NAME, '0x6a63cbf00d15137756189c29496b14998b259254' AS POOL_ADDRESS
    UNION ALL
    SELECT 'solvBTC.m / suBTC / BTCB' AS POOL_NAME, '0xe7e1b1f216d81a4b2c018657f26eda8fe2f91e26' AS POOL_ADDRESS
    UNION ALL
    SELECT 'uBTC / oBTC / WBTC' AS POOL_NAME, '0xec938bc5b201e96b6afe97070a8ea967e0dcae96' AS POOL_ADDRESS
    UNION ALL
    SELECT 'WBTC / BTCB' AS POOL_NAME, '0x7c59fd4348261348de72be3e40fa87252e778ca3' AS POOL_ADDRESS
    Last run: about 9 hours agoAuto-refreshes every 24 hours
    Date
    POOL_ADDRESS
    POOL_NAME
    PAIR
    DAILY_SWAP_VOLUME
    COMMUTATIVE_SWAP_VOLUME
    DAILY_SWAP_VOLUME_USD
    COMMUTATIVE_SWAP_VOLUME_USD
    DAILY_TRADING_FEE_AMOUNT
    COMMUTATIVE_TRADING_FEE_AMOUNT
    DAILY_TRADING_FEE_AMOUNT_USD
    COMMUTATIVE_TRADING_FEE_AMOUNT_USD
    1
    		2025-06-18 00:00:00.0000xec938bc5b201e96b6afe97070a8ea967e0dcae96uBTC / oBTC / WBTCoBTC / uBTC00.1649644733014645.7107399400.000191966663016.607090039
    2
    		2025-06-18 00:00:00.0000xec938bc5b201e96b6afe97070a8ea967e0dcae96uBTC / oBTC / WBTCuBTC / WBTC02.604961640265031.62996734100.0007390094652072.005091339
    3
    		2025-06-18 00:00:00.0000x4bcb9ea3dacb8ffe623317e0b102393a3976053csolvBTC.b / solvBTC.core / WBTCWBTC / SolvBTC.CORE0.001096408653168.427841003115.60044435716972685.24866465.313471e-70.076034829090.0560228697783.392619573
    4
    		2025-06-18 00:00:00.0000xec938bc5b201e96b6afe97070a8ea967e0dcae96uBTC / oBTC / WBTCuBTC / oBTC00.94889606095548.58170588800.000017185234801.789608718
    5
    		2025-06-18 00:00:00.0000x4bcb9ea3dacb8ffe623317e0b102393a3976053csolvBTC.b / solvBTC.core / WBTCSolvBTC.CORE / SolvBTC.b0104.33947440109251051.8073787200.0674076894605938.511138475
    6
    		2025-06-18 00:00:00.0000xec938bc5b201e96b6afe97070a8ea967e0dcae96uBTC / oBTC / WBTCoBTC / WBTC00.32619664031117.86578079100.005736220567.223096098
    7
    		2025-06-18 00:00:00.0000x4bcb9ea3dacb8ffe623317e0b102393a3976053csolvBTC.b / solvBTC.core / WBTCSolvBTC.b / WBTC0.01183459121.988391561247.78645182511507617.12057620.00000543325190.071683407150.57285796471.079258961
    8
    		2025-06-18 00:00:00.0000xe7e1b1f216d81a4b2c018657f26eda8fe2f91e26solvBTC.m / suBTC / BTCBsuBTC / SolvBTC.m011.74647427701017174.5852554700.0019453132790174.963236734
    9
    		2025-06-18 00:00:00.0000x6a63cbf00d15137756189c29496b14998b259254nBTC / BTCB / pumpBTCBTCB / pumpBTC01.10218527094165.35348806300.0001482902373015.630360278
    10
    		2025-06-18 00:00:00.0000xe7e1b1f216d81a4b2c018657f26eda8fe2f91e26solvBTC.m / suBTC / BTCBSolvBTC.m / BTCB018.45541795301860766.1746388200.0481610342904295.192819911
    11
    		2025-06-18 00:00:00.0000xe7e1b1f216d81a4b2c018657f26eda8fe2f91e26solvBTC.m / suBTC / BTCBsuBTC / BTCB05.2443278770479305.13032027100.0714266673206283.624469738
    12
    		2025-06-18 00:00:00.0000x4bcb9ea3dacb8ffe623317e0b102393a3976053csolvBTC.b / solvBTC.core / WBTCWBTC / SolvBTC.b0.01202690084135.7783756111268.0628497912637800.32409150.000006759163450.067162299070.7126560686422.928019368
    13
    		2025-06-18 00:00:00.0000x7c59fd4348261348de72be3e40fa87252e778ca3WBTC / BTCBWBTC / BTCB01.9381960160193777.39395583700.0133891879801410.756701012
    14
    		2025-06-18 00:00:00.0000x4bcb9ea3dacb8ffe623317e0b102393a3976053csolvBTC.b / solvBTC.core / WBTCSolvBTC.b / SolvBTC.CORE0110.35618788209743976.114075800.038486920503446.366453878
    15
    		2025-06-18 00:00:00.0000x7c59fd4348261348de72be3e40fa87252e778ca3WBTC / BTCBBTCB / WBTC01.853258440183762.68440323900.0005268019321048.856143694
    16
    		2025-06-18 00:00:00.0000xe7e1b1f216d81a4b2c018657f26eda8fe2f91e26solvBTC.m / suBTC / BTCBBTCB / suBTC03.5623867370311689.61930152900.00003869684703.995591827
    17
    		2025-06-18 00:00:00.0000xec938bc5b201e96b6afe97070a8ea967e0dcae96uBTC / oBTC / WBTCWBTC / oBTC00.82861306083493.49017048200.0000340703.548645762
    18
    		2025-06-18 00:00:00.0000x6a63cbf00d15137756189c29496b14998b259254nBTC / BTCB / pumpBTCpumpBTC / BTCB05.0749384970474827.31742815100.0238684423902136.961978327
    19
    		2025-06-18 00:00:00.0000x4bcb9ea3dacb8ffe623317e0b102393a3976053csolvBTC.b / solvBTC.core / WBTCSolvBTC.CORE / WBTC0.00609636173.15838506642.7730418617599276.67783080.0000031623230.094868696050.3334212559517.981789218
    20
    		2025-06-18 00:00:00.0000xe7e1b1f216d81a4b2c018657f26eda8fe2f91e26solvBTC.m / suBTC / BTCBSolvBTC.m / suBTC02.8655019360256294.58112996400.0023925888170210.707644059
    ...
    4055
    788KB
    127s