freemartiansunny-fuchsia
Updated 2025-01-08
999
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
30
31
32
33
34
35
36
›
⌄
WITH first_dist AS(
SELECT block_timestamp, tx_hash, to_address AS user, amount AS first_amount_received,
FROM base.core.ez_token_transfers
WHERE contract_address = '0x0521aaa7c96e25afee79fdd4f1bb48f008ae4eac'
AND tx_hash = '0xe930bba69e4c165a44197088b25f890b37de23c182f992c0834fa8843407c9f0'
AND to_address not in ('0x0ebcee3165654d9c52dd6d438423be76f2df1b0e', '0xb8745dec73f81ea366d7cc672438053c0e97de51')
ORDER BY event_index ASC
)
-- token_in_out AS(
-- SELECT
-- to_address AS user,
-- SUM(amount) AS amount,
-- FROM base.core.ez_token_transfers
-- WHERE contract_address = '0x0521aaa7c96e25afee79fdd4f1bb48f008ae4eac'
-- GROUP BY 1
-- UNION ALL
-- SELECT
-- from_address AS user,
-- SUM(-amount) AS amount,
-- FROM base.core.ez_token_transfers
-- WHERE contract_address = '0x0521aaa7c96e25afee79fdd4f1bb48f008ae4eac'
-- GROUP BY 1
-- ),
-- current_user_amount AS(
-- SELECT
-- user,
-- sum(amount) AS current_ballance
-- FROM token_in_out
-- GROUP BY 1
-- ),
-- stake AS(
-- -- stake
-- SELECT
QueryRunArchived: QueryRun has been archived