0xbrun0test-smart-guys-akro_20230201
Updated 2023-02-27
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
30
31
32
33
34
35
36
›
⌄
-- Find people who brought $AKRO between 2023-02-01 and 2023-02-15
-- before the surge in price
with
gen as (
SELECT
tb.user_address,
(
ARRAY_AGG(tb.balance) WITHIN GROUP (
ORDER BY
tb.block_timestamp
)
) [0] AS balance_gen
from
ethereum.core.fact_token_balances tb
where
tb.block_timestamp <= '2021-1-01'
and tb.contract_address = '0x9D65fF81a3c488d585bBfb0Bfe3c7707c7917f54'
group by
tb.user_address
),
feb as (
SELECT
tb.user_address,
(
ARRAY_AGG(tb.balance) WITHIN GROUP (
ORDER BY
tb.block_timestamp
)
) [0] AS balance_feb
from
ethereum.core.fact_token_balances tb
where
tb.block_timestamp <= '2023-02-25'
and tb.contract_address = '0x9D65fF81a3c488d585bBfb0Bfe3c7707c7917f54'
group by
tb.user_address
Run a query to Download Data