flipside

    Neptune Metrics copy copy copy
    Pine AnalyticsNeptune Metrics copy copy copy
    Updated 2025-03-19
    WITH tab1 as (
    SELECT
    tx.tx_id,
    block_timestamp,
    pre_bal.index,
    pre_bal.value AS pre_token_balance,
    pre_token_balance['mint'] as token,
    pre_token_balance['owner'] as owner,
    pre_token_balance['uiTokenAmount']['amount'] / power(10, 9) as pre_balance
    FROM
    eclipse.core.fact_transactions tx,
    LATERAL FLATTEN(input => tx.PRE_TOKEN_BALANCES) pre_bal
    WHERE token like 'FATF66HHhz8Yf2zxMXZXjmzu8NFArwtCJGEsj7rHC8i4'
    and SUCCEEDED
    and block_timestamp > '2024-01-20'
    ), tab2 as (
    SELECT
    tx.tx_id,
    block_timestamp,
    post_bal.index,
    post_bal.value AS post_token_balance,
    post_token_balance['mint'] as token,
    post_token_balance['owner'] as owner,
    post_token_balance['uiTokenAmount']['amount'] / power(10, 9) as post_balance
    FROM
    eclipse.core.fact_transactions tx,
    LATERAL FLATTEN(input => tx.post_TOKEN_BALANCES) post_bal
    WHERE token like 'FATF66HHhz8Yf2zxMXZXjmzu8NFArwtCJGEsj7rHC8i4'
    and SUCCEEDED
    and block_timestamp > '2024-01-10'
    )

    SELECT
    owner,
    post_balance as usdn_balance

    Last run: about 2 months ago
    OWNER
    USDN_BALANCE
    1
    BuN6mPQ1qV7ELEazPG1zxsTdVGBSxETCZWPX68bm2Gzz
    		132780.075577228
    2
    2y5w8GgBx2kWev4hy9Su7M2ik1y4cH487RRJZm7Mv3da
    		35483.334457605
    3
    E48MaLaXGEY5UQHEtkLser71CY7YvUhmXzwhZVNSZBtw
    		8858.639297365
    4
    2pnAKJ9Eohj47ZhEtc4DveWjdtbZLDLBTb4Gybm6J8T9
    		1554.269550749
    5
    7Y852diVsehkdPtXBtPnfFuV5T7omLko26S1bWs9L5au
    		762.3621561
    6
    AEBrTtMAjEZijFYTsEWrYwM2Z9wDaGjRYExuTm6yaatS
    		318.66274892
    7
    AeWzVMmNt9Gu5LMWG9B7eQvba8bhcuMTy97Ycci4jcSx
    		280.59
    8
    7mTuJscmdvwexPNT4HjVxrmiQzv1P4Bgcx5VJxDoXyVb
    		229.367303383
    9
    89hsVpmErvxShH3Rq5demp8h55PSg55S8sAj2N1HxFUx
    		221.798853863
    10
    5Dw3DsJ6Mz7938omDedXe1wU18yBCCraRAYYPBpLruf1
    		217.8
    11
    A5sh23UnvA1mEgkoEDoMGPDPy2VCgGJ4EHo6N5cmKZ3V
    		200
    12
    5cYvjJqi9LpR6i9X2ZLyKAfJASdwW72kYG9rSWNCM5hj
    		181.945898874
    13
    DhdMBVK3GxNBMGiMSAs62ZXrMgDR4WbounzkHWss8gtn
    		173.847582962
    14
    CjXuBaE8J6k1yNJX5nMD5Gc7A7RmMd51WUDrE5uixZKe
    		155.327066372
    15
    74k9vQDzJbcVaoH9t6mSj1Z9Md6bVdiwv9QMuW7ZHBvK
    		127.068513079
    16
    9L9Ne5LTwd84gR9xL5hqx63C5QApsuYoMrSUGaRx6eHX
    		126.005055177
    17
    GVJMHLPsXsCxreG3hYTk8d7i99CmeS2stL3tm79EWvnc
    		125.78
    18
    6m7DKG8YuGmECTTi7c6ddpRP3HFkU3YCeBBE25EPitks
    		114.613427242
    19
    BYABYBManv3jwndghHY8tQjCaeVobGSYAMyKsvLBEXZf
    		113.837464722
    20
    6trGQCZFJiwPE8FFPGx7tsXMtQS9ZrWGrmPqHzSqUkUf
    		109.258233808
    ...
    4726
    250KB
    236s