Multipartite2022-06-02 Locked balance record
Updated 2022-06-02
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
supplystats AS
(
SELECT
500000000 AS maxsupply,
61,994.68108194 as rolledback,
--Based on measurements at https://gist.github.com/Multipartite/84976c3351dde465f42dc87f56e09999 .
--Don't forget about the IOU.RUNE killswitches, later.
--Also don't forget about the THOR.USD minting/burning-of-THOR.RUNE with THORFi later.
maxsupply - rolledback AS effectivesupply
),
lockedaddresses AS
(
SELECT
'thor1g98cy3n9mmjrpn0sxmn63lztelera37n8n67c0' AS pool_module,
'thor17gw75axcnr8747pkanye45pnrwk7p9c3cqncsv' AS bond_module,
'thor1dheycdevq39qlkxs2a6wuuzyn4aqxhve4qxtxt' AS reserve_module,
'thor1lj62pg6ryxv2htekqx04nv7wd3g98qf9gfvamy' AS standby_reserve_address,
'thor1lrnrawjlfp6jyrzf39r740ymnuk9qgdgp29rqv' AS team_address, --Vested (note mainnet 12-month unlock schedule; gradual transfers out then?).
'thor16qnm285eez48r4u9whedq4qunydu2ucmzchz7p' AS seed_address --Vested; note pivot to Bond.
),
--Treasury addresses are available to go into LPs at will, so don't count as 'locked' in the same sense(s).
balance_changes AS
(
SELECT block_timestamp, block_id,
(CASE WHEN to_address = lockedaddresses.pool_module THEN CAST(POWER(10,-8) * amount_e8 AS DECIMAL(28,8)) ELSE 0 END)
- (CASE WHEN from_address = lockedaddresses.pool_module THEN CAST(POWER(10,-8) * amount_e8 AS DECIMAL(28,8)) ELSE 0 END)
AS pool,
(CASE WHEN to_address = lockedaddresses.bond_module THEN CAST(POWER(10,-8) * amount_e8 AS DECIMAL(28,8)) ELSE 0 END)
- (CASE WHEN from_address = lockedaddresses.bond_module THEN CAST(POWER(10,-8) * amount_e8 AS DECIMAL(28,8)) ELSE 0 END)
AS bond,
(CASE WHEN to_address = lockedaddresses.reserve_module THEN CAST(POWER(10,-8) * amount_e8 AS DECIMAL(28,8)) ELSE 0 END)
- (CASE WHEN from_address = lockedaddresses.reserve_module THEN CAST(POWER(10,-8) * amount_e8 AS DECIMAL(28,8)) ELSE 0 END)
AS reserve,
Run a query to Download Data