zhanyusnail-final
    Updated 2024-03-28
    --
    SELECT
    sender user,
    count(*) cnt,
    sum(AMOUNT) amount
    FROM
    sei.core.fact_transfers
    WHERE
    -- sei token
    CURRENCY = 'usei'
    -- meme launch address
    AND RECEIVER = 'sei1xkkcf0nyhxn05za3e9uccu0rvultg69afsua53'
    AND not SENDER = 'sei1xkkcf0nyhxn05za3e9uccu0rvultg69afsua53'
    AND TX_SUCCEEDED = TRUE
    AND TRANSFER_TYPE = 'SEI'
    -- start block number / 2024-03-26 10:00pm
    AND BLOCK_ID >= 66032690
    -- end block number
    AND BLOCK_ID <= 66447111
    GROUP BY
    1
    ORDER BY
    3 DESC

    -- select *
    -- from sei.core.fact_transfers
    -- WHERE BLOCK_ID >= 66447111
    -- LIMIT 10
    QueryRunArchived: QueryRun has been archived