flipside

    Meteor vs HERE vs other wallets weekly trading volume
    csp88gMeteor vs HERE vs other wallets weekly trading volume
    Updated 2025-03-29
    WITH T1 AS
    (SELECT
    CASE
    WHEN SIGNER_ID IN ('free-name.herewallet.near', 'herewallet.near') THEN 'here wallet'
    WHEN SIGNER_ID IN ('meteor-relayer.near', 'meteor-gastank.near' , 'aa-meteor-relayer-1.near', 'aa-meteor-relayer-2.near') THEN 'meteor wallet'
    ELSE 'other wallets'
    END AS Wallet_label
    , ARGS['new_account_id'] AS WALLET_ADDRESS
    FROM
    near.core.fact_actions_events_function_call
    WHERE
    METHOD_NAME = 'create_account'

    UNION ALL

    (SELECT
    'here wallet' AS Wallet_label
    , value[0] as WALLET_ADDRESS

    FROM near.core.fact_actions_events_function_call
    , lateral FLATTEN (input => args:accounts)
    where METHOD_NAME='create_accounts'
    and RECEIVER_ID='tg'))

    SELECT
    DATE_TRUNC('WEEK' , BLOCK_TIMESTAMP) AS Date
    , Wallet_label
    , SUM(CASE WHEN AMOUNT_OUT_USD IS NULL THEN AMOUNT_IN_USD ELSE AMOUNT_OUT_USD END) AS "trading volume"
    , SUM("trading volume") OVER (PARTITION BY Wallet_label ORDER BY DATE) AS "Total trading volume"
    , count(*) AS "Trades number"
    , SUM("Trades number") OVER (PARTITION BY Wallet_label ORDER BY Date) AS "Total trades"
    FROM T1 A INNER JOIN near.defi.ez_dex_swaps B ON A.WALLET_ADDRESS=B.TRADER
    GROUP BY 1,2
    ORDER BY 1 DESC

    /*all_trades as(
    Last run: 3 months ago
    DATE
    WALLET_LABEL
    trading volume
    Total trading volume
    Trades number
    Total trades
    1
    		meteor wallet340096547.6667852691421
    2
    		2025-03-24 00:00:00.000here wallet444511.585394421118817773.745104207109772332
    3
    		2025-03-24 00:00:00.000other wallets1785207.924414223409643430.56972217639289236
    4
    		2025-03-24 00:00:00.000meteor wallet765008.326992136340096547.66678396392691416
    5
    		2025-03-17 00:00:00.000meteor wallet1234866.14128845339331539.339787576282651777
    6
    		2025-03-17 00:00:00.000other wallets34943607.11420263407858222.64531106839267473
    7
    		2025-03-17 00:00:00.000here wallet550620.908423151118373262.15971302169751622
    8
    		2025-03-10 00:00:00.000here wallet1782776.70670959117822641.251287598989721406
    9
    		2025-03-10 00:00:00.000meteor wallet5310565.17569172338096673.198499740412594149
    10
    		2025-03-10 00:00:00.000other wallets161009167.2369053372914615.53114438459156790
    11
    		2025-03-03 00:00:00.000here wallet1005622.75281018116039864.544577380649661508
    12
    		2025-03-03 00:00:00.000other wallets165271518.1428823211905448.294194406068712945
    13
    		2025-03-03 00:00:00.000meteor wallet7614180.6824292332786108.0228071027632520108
    14
    		2025-02-24 00:00:00.000meteor wallet5699087.30358871325171927.3403781025222417345
    15
    		2025-02-24 00:00:00.000here wallet699760.087838372115034241.791767226859623444
    16
    		2025-02-24 00:00:00.000other wallets132324912.3735033046633930.151313089588272339
    17
    		2025-02-17 00:00:00.000other wallets116278238.8793482914309017.777812877507963381
    18
    		2025-02-17 00:00:00.000here wallet587397.924380479114334481.703929262579600759
    19
    		2025-02-17 00:00:00.000meteor wallet2921027.16527405319472840.0367891079132314823
    20
    		2025-02-10 00:00:00.000other wallets51727987.14265152798030778.898462694977675631
    ...
    448
    39KB
    553s