Kruys-Collins$MOD token holders copy copy
Updated 2025-03-09Copy Reference Fork
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 base AS (
SELECT
date_trunc('hour',block_timestamp) as hour,
AMOUNT / 1e8 AS amount
FROM
aptos.core.fact_transfers
WHERE
token_address = '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::mod_coin::MOD'
AND TRANSFER_EVENT = 'DepositEvent'
UNION ALL
SELECT
date_trunc('hour',block_timestamp) as hour,
-AMOUNT / 1e8 AS amount
FROM
aptos.core.fact_transfers
WHERE
token_address = '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::mod_coin::MOD'
AND TRANSFER_EVENT = 'WithdrawEvent'
),
hourly_balances AS (
SELECT
hour,
SUM(amount) AS balance
FROM
base
GROUP BY
hour
),
cumulative_supply AS (
SELECT
hour,
SUM(balance) OVER (ORDER BY hour) AS total_supply
QueryRunArchived: QueryRun has been archived