flipside

    $MOON holders
    csp88g$MOON holders
    Updated 2025-04-20
    WITH mint as (select BLOCK_TIMESTAMP,
    TX_HASH,
    MEMO,
    AMOUNT_PRECISE as mint_moon_amount,
    to_address as player,
    from near.core.ez_token_transfers
    where block_timestamp::date >= '2024-04-01'
    and CONTRACT_ADDRESS = 'aa-harvest-moon.near'
    ),

    mint_harvest as (select *,
    from mint
    where memo = 'Harvest'
    ),

    mint_referral as (select *,
    from mint
    where memo = 'Referral'
    ),

    mint_migration as (select *,
    from mint
    where memo in ('Migration','Migrate')
    ),

    mint_exchange as (select *,
    from mint
    where memo LIKE 'Exchanged%Moon'
    ),

    mint_reward as (select *,
    from mint
    where memo LIKE 'Claiming reward%'
    ),

    mint_staking as (select *,
    Last run: about 2 months ago
    PLAYER
    MOON
    1
    		uae8899.tg297518.888004
    2
    		interstellarmeteor.near258439.919209
    3
    		magiccall.near245726.881476
    4
    		within4d45.near216204.497228
    5
    		csp88.near202400.087195
    6
    		br1dge.near187530.22191
    7
    		aisthetic.near180240.316326
    8
    		b0hannon.tg167358.034449
    9
    		sashurick.tg164721.992687
    10
    		romanf01.near159151.296513
    11
    		boar00.near128414.835434
    12
    		bigtinker.near128209.864268
    13
    		betterinvest.near111111.023004
    14
    		odminushka-hot.tg107729.550251
    15
    		jehoti.near101946.786461
    16
    		pa3uk34.tg96910.659457
    17
    		i6339773329.tg93311.44125
    18
    		ogcommunity.near92873.619343
    19
    		aea3d73ce0e29d0b7f9a4becaa36f0a83e4376dfcb4422a53164da654639702291874.547744
    20
    		pppii.near88205.636658
    ...
    100000
    3MB
    526s