flipside

    Holders Positions
    freemartianHolders Positions
    Updated 8 days ago
    WITH positions_api AS (
    SELECT
    value AS temp_value
    FROM (
    SELECT
    livequery.live.udf_api(
    'https://raw.githubusercontent.com/mehdimarjan/Opensea/refs/heads/main/positions.json'
    ) AS response
    ),
    LATERAL FLATTEN(input => response:data)
    ),
    datas AS(
    SELECT
    value:user_address AS user,
    value:id AS position_id,
    value:wallet_position_asset AS position_asset,
    value:wallet_position_amount AS position_amount,
    value:chain_position AS chain
    FROM
    positions_api, LATERAL FLATTEN(input => temp_value)
    WHERE position_amount <> ''
    AND position_amount > 1
    )

    SELECT
    user,
    -- position_asset,
    -- chain,
    sum(position_amount) AS amount
    FROM datas
    GROUP BY 1
    -- GROUP BY 1,2,3




    Last run: 8 days agoAuto-refreshes every 1 hour
    USER
    AMOUNT
    1
    0xe5e83c2347be43eb917715c7385ae2a2cf95453c
    		29442.855355701
    2
    0xe922a0bc44210f97aa6a38fe1ad7f6b8d3b23dec
    		8638.985755038
    3
    0x0ae87d9ec2c6ddd30f61935b0c323fd08cebbdf2
    		144335.315379665
    4
    0x7decd0770371096f135547bdbdf3831799239ccf
    		2114895.96021679
    5
    0x0871deb34bfd2052b1c10dc4f6c0912a2a47e927
    		725629.78234868
    6
    0x96ef7cf2f781579aa499e9e04f6f1ce6244149ac
    		4844265.00908698
    7
    0x512e3eb472d53df71db0252cb8dccd25cd05e9e9
    		36215.388518963
    8
    0x66362b929c1a9aaf14c51aab9b455ad7fb8268c4
    		733950.394174762
    9
    0xa65ce1d604fa901c13aa29f2126a57d9032e412b
    		1968122.63749191
    10
    0xe6c4f3f937b961e621d021d9d9e7deadeac9c934
    		99265.494921449
    11
    0x75d415edcb3c3782e5952470821e983f9053a209
    		1071751.06313735
    12
    0x5c8413d0d908c9caa91ac36f60affab023ddf88a
    		15948.739181031
    13
    0x9b864dde6ed1c21608b1665a0ac0faa4f7e36e6e
    		2072167.02934063
    14
    0xfd211ee23506e82938c88dc140e2d88f851e2039
    		1148637.76281865
    15
    0xe1412eb3a56502c5322eddf4fd6b63097fe9f08e
    		188262.372337434
    16
    0xbc293ac23c1dae43b015172761c57589716712e6
    		215163.368830318
    17
    0x6ce466a21f6ff3136c0a707f27ac4c07f49bbabb
    		1757.925814707
    18
    0x1811cfd037a33d65e7e75e1aa6cd0d6c6ea67141
    		7739.640927172
    19
    0x3e516cf3c9d4f29fae6c1324c2414dc872fc9c09
    		2414716.84624281
    20
    0x67f72412a592d066a2e688e62664116deabeab29
    		7282.757604186
    30
    2KB
    2s