sunny-fuchsia

freemartiansunny-fuchsia

Updated 2025-01-08

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

Last run: 3 months ago

...

450

26KB

20s

flipside