flipside

    new vs existing Traders
    datavortexnew vs existing Traders
    Updated 2025-03-02
    WITH all_trades AS (
    SELECT
    'Ethereum' AS chain,
    DATE_TRUNC('week', block_timestamp) AS date,
    origin_from_address
    FROM ethereum.defi.ez_dex_swaps
    WHERE pool_name IN (
    'USD0-LBTC 3000 60 UNI-V3 LP',
    'WBTC-LBTC 100 1 UNI-V3 LP',
    'eBTC-LBTC 500 10 UNI-V3 LP',
    'LBTC-WETH',
    'LBTC-cbBTC 500 10 UNI-V3 LP',
    'WBTC-LBTC 500 10 UNI-V3 LP'
    )
    UNION ALL
    SELECT
    'Base' AS chain,
    DATE_TRUNC('week', block_timestamp) AS date,
    origin_from_address
    FROM base.defi.ez_dex_swaps
    WHERE pool_name IN (
    'cbBTC-LBTC 3000 60 UNI-V3 LP',
    'cbBTC-0xeca...11c1 0 1 ASLP',
    'Balancer LBTC/cbBTC',
    'cbBTC-LBTC'
    )
    UNION ALL
    SELECT
    'BSC' AS chain,
    DATE_TRUNC('week', block_timestamp) AS date,
    origin_from_address
    FROM bsc.defi.ez_dex_swaps
    WHERE pool_name IN (
    'BTCB-LBTC 500 10 PCS-V3 LP',
    '0xad3...15ff-WBNB',
    'LBTC-WBNB',
    Last run: 2 months ago
    CHAIN
    DATE
    TOTAL_TRADERS
    NEW_TRADERS
    EXISTING_TRADERS
    1
    		BSC2021-06-07 00:00:00.000180718070
    2
    		BSC2021-06-14 00:00:00.000541220321
    3
    		BSC2021-06-21 00:00:00.000396215181
    4
    		BSC2021-06-28 00:00:00.00018371112
    5
    		BSC2021-07-05 00:00:00.000622240
    6
    		BSC2021-07-12 00:00:00.000763442
    7
    		BSC2021-07-19 00:00:00.000261016
    8
    		BSC2021-07-26 00:00:00.0001679
    9
    		BSC2021-08-02 00:00:00.0001358
    10
    		BSC2021-08-09 00:00:00.000552431
    11
    		BSC2021-08-16 00:00:00.000863650
    12
    		BSC2021-08-23 00:00:00.000601743
    13
    		BSC2021-08-30 00:00:00.00030228
    14
    		BSC2021-09-06 00:00:00.00016515312
    15
    		BSC2021-09-13 00:00:00.00036432
    16
    		BSC2021-09-20 00:00:00.000927
    17
    		BSC2021-09-27 00:00:00.00013211
    18
    		BSC2021-10-04 00:00:00.00023518
    19
    		BSC2021-10-11 00:00:00.00015510
    20
    		BSC2021-10-18 00:00:00.0001129
    ...
    177
    8KB
    3s