RayyykFLOW Whales 4
Updated 2022-11-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
›
⌄
with nov_1 as (select recipient as wallets,
sum(amount) as amount_deposited
from flow.core.ez_token_transfers
where tx_succeeded = 'TRUE'
and token_contract = 'A.1654653399040a61.FlowToken'
group by 1),
nov_2 as (select sender as wallets,
sum(amount) as amount_withdrew
from flow.core.ez_token_transfers
where tx_succeeded = 'TRUE'
and token_contract = 'A.1654653399040a61.FlowToken'
group by 1),
nov_3 as (select a.wallets,
amount_deposited - amount_withdrew as flow_holdings
from nov_1 a
join nov_2 b on a.wallets = b.wallets
having flow_holdings > 10000),
jan_1 as (select recipient as wallets,
sum(amount) as amount_deposited
from flow.core.ez_token_transfers
where tx_succeeded = 'TRUE'
and token_contract = 'A.1654653399040a61.FlowToken'
and block_timestamp <= '2022-02-01'
group by 1),
jan_2 as (select sender as wallets,
sum(amount) as amount_withdrew
from flow.core.ez_token_transfers
where tx_succeeded = 'TRUE'
and token_contract = 'A.1654653399040a61.FlowToken'
and block_timestamp <= '2022-02-01'
group by 1),
Run a query to Download Data