GetstanTotal APT distributed DOD
Updated 2024-12-06
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
›
⌄
---2.Total APT distributed DOD
select
-- ACCOUNT_ADDRESS,
date(BLOCK_TIMESTAMP) as Date,
-- month(BLOCK_TIMESTAMP) as Month,
count(distinct VERSION) as count,
sum(EVENT_DATA:amount) / 100000000 AS APT
from
aptos.core.fact_events
where
ACCOUNT_ADDRESS in (
'0xa36a6931005aa20a57fa58000c648d3b0b53b0a354354d7f81515f47cd9a7a81',
'0xc94e16736910cc160347d01de345407fe2d350fce5635ac1150319b0fbf5630e',
'0xd667a331f8ddb2f02200c8ec8396c57cb2ec9b7f66b8d228d58d4ddef1ec04e0',
'0x1291608dbd5c59a3b7719e48f78af89eda28aa9b15ffdcb6e1421900b64eaf89',
'0x5040fa223f564e4ec24c3750186beab697f542e56edbd6fc234fdfc23ea8067c',
'0xb5e1cc180e603037887c9e9eb4a8a06774ebcddafac37ceea9e33f3b6552bb25',
'0x24e31431ca604bd24c5cc8424d3a895b15a910d5ece00fe98fe6d7c6a026f60a',
'0x6de4fb960cb70ce522da0a39e51e93d9399f767eb6e173993e99572b972c39a3',
'0xad4aa57fd878819a0248c11875df84f781335a4dd437ff21bf132ae5f8e14662',
'0x811c12a7ed028a9969b71f86689bcf42ca50144f3b6008bd8cdb550c0e2fffe6',
'0xe6a9ec8e5c0ef2e5670ab3e7fd86c5af7098a9a9893cc254e893ee3c87f99a61',
'0x23e89c5073173b21cc30e6949b34608f0ff8b90c6ea7fa1b58831c8d89ce54d8',
'0xef82b1d818007db4f3c45874706374553a34ae84181396bac8950023af7dea4e',
'0xd2d637ef890f8472a0b6798098a35f10e19a95fff0a46b4bdc360cd70d80dc10',
'0xcd9eb9ba34a6e28826aa6c434dbca38d6f9bdaa109cd359a396e8a77539c31eb',
'0x6e2f14bca17268ff0fedc4e7aa3e34274f21dc75d0c567368e4d704476a6d97b',
'0x45c798416c158c1fd93fed2e40fbc2cd9f27bd640e6a6ed7ce58c9e4f413695b',
'0xbe54ed8012d6b7701a88a4d156032b8222d65d447b47ce22657e44b06a3ea7dc',
'0x172ce5c92cd7b757735ed163cd657c820aa4e028bb43270975759c0038f1f8d6',
'0x562c0f6141a4665821231b84c489fb55700c802b5fbf7751bc3f4b2fa671b61f'
)
and EVENT_TYPE = '0x1::coin::WithdrawEvent' -- '0x1::coin::DepositEvent'
and date(BLOCK_TIMESTAMP) >= current_date() -20
group by
1
QueryRunArchived: QueryRun has been archived