flipside

    Neptune Metrics copy copy copy
    Pine AnalyticsNeptune Metrics copy copy copy
    Updated 5 days ago
    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: 5 days ago
    OWNER
    USDN_BALANCE
    1
    BuN6mPQ1qV7ELEazPG1zxsTdVGBSxETCZWPX68bm2Gzz
    		39623.243439539
    2
    2y5w8GgBx2kWev4hy9Su7M2ik1y4cH487RRJZm7Mv3da
    		18836.756221235
    3
    E48MaLaXGEY5UQHEtkLser71CY7YvUhmXzwhZVNSZBtw
    		8858.639297365
    4
    2pnAKJ9Eohj47ZhEtc4DveWjdtbZLDLBTb4Gybm6J8T9
    		1555.870395699
    5
    AEBrTtMAjEZijFYTsEWrYwM2Z9wDaGjRYExuTm6yaatS
    		318.66274892
    6
    AeWzVMmNt9Gu5LMWG9B7eQvba8bhcuMTy97Ycci4jcSx
    		280.59
    7
    4MMb5bm3Zts4q3vUFJKHYQiSD3iATFjq3Kd3qcogy3w2
    		224.73
    8
    5RCRPi4TnfyWHLoD2r4Lj6D41z4XPQDAsu2WPZA3mi1u
    		220.954022298
    9
    5Dw3DsJ6Mz7938omDedXe1wU18yBCCraRAYYPBpLruf1
    		217.8
    10
    DADGdag54sh2CAGKUuJXg2dL327bg7nNrhX7rnuDqJ7C
    		206.553793729
    11
    DF2hxjmF5HFS4LF4F7kcwcS9H9q9q2zuwBv6K3VbZ9Nq
    		203.31
    12
    A5sh23UnvA1mEgkoEDoMGPDPy2VCgGJ4EHo6N5cmKZ3V
    		200
    13
    5cYvjJqi9LpR6i9X2ZLyKAfJASdwW72kYG9rSWNCM5hj
    		181.945898874
    14
    J65Qf42RSvrfQyUBWgyjCWLLX2GBE89LYQrreUUjU7TE
    		167.485553248
    15
    74k9vQDzJbcVaoH9t6mSj1Z9Md6bVdiwv9QMuW7ZHBvK
    		127.068513079
    16
    9L9Ne5LTwd84gR9xL5hqx63C5QApsuYoMrSUGaRx6eHX
    		126.005055177
    17
    GVJMHLPsXsCxreG3hYTk8d7i99CmeS2stL3tm79EWvnc
    		125.78
    18
    FnZsQvjdsYtnoqRUgePJ4bcTEmKrztQjiY5bEUGACVdK
    		111.041128977
    19
    6trGQCZFJiwPE8FFPGx7tsXMtQS9ZrWGrmPqHzSqUkUf
    		109.258233808
    20
    F3Eh5oY5p94Sw1xbpmSCFTNDGFxEns52rrGSrELsEppr
    		108.862700841
    ...
    6412
    337KB
    684s