zhanyusnail-final
Updated 2024-03-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
›
⌄
--
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