flipside

    native-gold
    datavortexnative-gold
    Updated 3 days ago
    WITH initial_balances AS (
    SELECT
    s.trader,
    SUM(s.amount_in_usd) AS initial_wnear_balance
    FROM
    near.defi.ez_dex_swaps s
    WHERE
    s.block_timestamp < '2024-01-01'
    AND s.symbol_in = 'wNEAR'
    GROUP BY
    s.trader
    HAVING
    SUM(s.amount_in_usd) BETWEEN 10000 AND 99999
    ),
    near_swaps_2024 AS (
    SELECT
    s.trader,
    s.block_timestamp::DATE AS swap_date,
    CONCAT(s.symbol_in, ' -> ', s.symbol_out) AS token_pair,
    s.amount_in_usd AS token_swap_value_usd,
    s.amount_out_usd AS usd_received
    FROM
    near.defi.ez_dex_swaps s
    WHERE
    s.block_timestamp >= '2024-01-01'
    AND s.block_timestamp <= '2024-12-31'
    AND s.symbol_in = 'wNEAR'
    AND s.symbol_out != 'wNEAR'
    AND s.symbol_in IS NOT NULL
    AND s.amount_in_usd IS NOT NULL
    ),
    tracked_traders AS (
    SELECT
    ns.trader,
    ns.swap_date,
    ns.token_pair,
    Last run: 3 days ago
    TRADER
    SWAP_DATE
    TOKEN_PAIR
    TOKEN_SWAP_VALUE_USD
    USD_RECEIVED
    1
    		16686c851c8791038207e95b92d05f8c172cc8bff7598b2122700f5b56de1aa22024-01-10 00:00:00.000wNEAR -> REF21109.84346404120370.151264033
    2
    		16686c851c8791038207e95b92d05f8c172cc8bff7598b2122700f5b56de1aa22024-01-09 00:00:00.000wNEAR -> REF17204.91420954716957.180795334
    3
    		16686c851c8791038207e95b92d05f8c172cc8bff7598b2122700f5b56de1aa22024-01-09 00:00:00.000wNEAR -> REF16686.88833622316185.220756541
    4
    		16686c851c8791038207e95b92d05f8c172cc8bff7598b2122700f5b56de1aa22024-01-09 00:00:00.000wNEAR -> REF16209.87733909415402.180177029
    5
    		ab54c1b5f4c528e74a2a4a13ecb7cbb6976049d4ed5b72e7bd4934447d951f1a2024-04-26 00:00:00.000wNEAR -> USDC33724.38337195133394.977481381
    6
    		ab54c1b5f4c528e74a2a4a13ecb7cbb6976049d4ed5b72e7bd4934447d951f1a2024-03-28 00:00:00.000wNEAR -> USDC11977.46872159912046.946307555
    7
    		ab54c1b5f4c528e74a2a4a13ecb7cbb6976049d4ed5b72e7bd4934447d951f1a2024-04-27 00:00:00.000wNEAR -> USDC8233.8279989518608.527438818
    8
    		ab54c1b5f4c528e74a2a4a13ecb7cbb6976049d4ed5b72e7bd4934447d951f1a2024-01-25 00:00:00.000wNEAR -> GEAR8971.4771342695947.839516913
    9
    		ab54c1b5f4c528e74a2a4a13ecb7cbb6976049d4ed5b72e7bd4934447d951f1a2024-04-27 00:00:00.000wNEAR -> USDC3194.1574133863347.79060405
    10
    		benjiman.near2024-03-17 00:00:00.000wNEAR -> USDC24324.42573001124247.282617863
    11
    		benjiman.near2024-05-15 00:00:00.000wNEAR -> USDC1920019304.649642224
    12
    		benjiman.near2024-04-24 00:00:00.000wNEAR -> USDC14062.28435166214103.334584161
    13
    		benjiman.near2024-04-07 00:00:00.000wNEAR -> BRRR10418.61830436912538.642067605
    14
    		benjiman.near2024-01-03 00:00:00.000wNEAR -> USDC.e3535.4903412443632.018287043
    15
    		lewis1973_hot.near2024-06-01 00:00:00.000wNEAR -> STNEAR37891.787437785.653467571
    16
    		lewis1973_hot.near2024-05-30 00:00:00.000wNEAR -> STNEAR19851.80419863.88240192
    17
    		lewis1973_hot.near2024-05-29 00:00:00.000wNEAR -> STNEAR19552.855819724.286127012
    18
    		n4.near2024-03-18 00:00:00.000wNEAR -> USDC40526.06229575241438.493280854
    19
    		n4.near2024-03-18 00:00:00.000wNEAR -> USDC.e17882.52749462717763.523544829
    20
    		n4.near2024-03-03 00:00:00.000wNEAR -> REF4766.791398814798.033246017
    22
    2KB
    300s