flipside

    transaction activity swaps
    permarytransaction activity swaps
    Updated 2025-03-17
    SELECT
    'Ethereum' AS chain,
    DATE_TRUNC('day', block_timestamp) AS date,
    COUNT(*) AS daily_tx_count
    FROM ethereum.defi.ez_dex_swaps
    WHERE (SYMBOL_IN = 'XSGD' OR SYMBOL_OUT = 'XSGD')
    AND block_timestamp >= '2024-09-01'
    GROUP BY 1, 2

    UNION ALL

    SELECT
    'Polygon' AS chain,
    DATE_TRUNC('day', block_timestamp) AS date,
    COUNT(*) AS daily_tx_count
    FROM polygon.defi.ez_dex_swaps
    WHERE (SYMBOL_IN = 'XSGD' OR SYMBOL_OUT = 'XSGD')
    AND block_timestamp >= '2024-09-01'
    GROUP BY 1, 2

    UNION ALL

    SELECT
    'Avalanche' AS chain,
    DATE_TRUNC('day', block_timestamp) AS date,
    COUNT(*) AS daily_tx_count
    FROM avalanche.defi.ez_dex_swaps
    WHERE (SYMBOL_IN = 'XSGD' OR SYMBOL_OUT = 'XSGD')
    AND block_timestamp >= '2024-09-01'
    GROUP BY 1, 2
    ORDER BY date ASC;


    Last run: 21 days ago
    CHAIN
    DATE
    DAILY_TX_COUNT
    1
    		Ethereum2024-09-01 00:00:00.00017
    2
    		Polygon2024-09-01 00:00:00.000752
    3
    		Ethereum2024-09-02 00:00:00.00023
    4
    		Polygon2024-09-02 00:00:00.000694
    5
    		Ethereum2024-09-03 00:00:00.00011
    6
    		Polygon2024-09-03 00:00:00.000587
    7
    		Polygon2024-09-04 00:00:00.000783
    8
    		Ethereum2024-09-04 00:00:00.00021
    9
    		Ethereum2024-09-05 00:00:00.00017
    10
    		Polygon2024-09-05 00:00:00.000697
    11
    		Polygon2024-09-06 00:00:00.0001013
    12
    		Ethereum2024-09-06 00:00:00.00019
    13
    		Ethereum2024-09-07 00:00:00.00024
    14
    		Polygon2024-09-07 00:00:00.000294
    15
    		Ethereum2024-09-08 00:00:00.00027
    16
    		Polygon2024-09-08 00:00:00.000281
    17
    		Polygon2024-09-09 00:00:00.000604
    18
    		Ethereum2024-09-09 00:00:00.00014
    19
    		Avalanche2024-09-09 00:00:00.0005
    20
    		Polygon2024-09-10 00:00:00.000685
    ...
    584
    24KB
    9s