elvisSOL Q6.2.1 veSBR Analysis II: Total Supply breakdown by HODLer address at the end of Epoch 4
Updated 2022-02-28
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
›
⌄
⌄
⌄
⌄
/*What was the total supply of veSBR at the end of each of the last two Epochs (4 & 5)?
Create a pie chart showing the distribution of veSBR (top 20 wallets) for Epochs 4 & 5.
Epoch 0 2022-01-13 01:11:59 - 2022-01-20 01:11:59 -- There was indeed an EPOCH 0
Epoch 1 2022-01-20 01:11:59 - 2022-01-27 01:11:59
Epoch 2 2022-01-27 01:11:59 - 2022-02-03 01:11:59
Epoch 3 2022-02-03 01:11:59 - 2022-02-10 01:11:59
------
Epoch 4 2022-02-10 01:11:59 - 2022-02-17 01:11:59
Epoch 5 2022-02-17 01:11:59 - 2022-02-24 01:11:59
Epoch 6 2022-02-24 01:11:59 - 2022-03-03 01:11:59
How did these wallets vote? Did they vote for the same gauges? Or did they choose to send SBR rewards to different pools?*/
/*
inner_instruction:instructions[0]:parsed:info:amount/1e6 as amount
*/
WITH SBRLocks AS (
SELECT block_timestamp as dt, tx_id, to_varchar(inner_instruction:instructions[0]:parsed:info:destination) as HODLer_account, inner_instruction:instructions[0]:parsed:info:amount/1e6 as amount
FROM solana.events
WHERE block_timestamp > '2022-01-13 01:11:59'
AND block_timestamp < '2022-02-17 01:11:59' -- Epoch 4
AND succeeded = TRUE
AND instruction:programId = 'LocktDzaV1W2Bm9DeZeiyz4J9zs4fRqNiYqQyracRXw'
AND pretokenbalances[0]:mint = 'Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1'
AND inner_instruction:instructions[0]:parsed:type = 'transfer'
)
-- Total Supply Epoch 4: 69963041.664181
-- TOP 20 Holdings Epoch 4: 63833007.536091
-- Rest: 6130034.12809
-- Top 20 SBR escrow accounts
/*Top20_SBR AS (
(*/
(
SELECT sum(amount) AS SBR_Holdings, HODLer_account
FROM SBRLocks
GROUP BY HODLer_account
ORDER BY 1 DESC
LIMIT 20)
Run a query to Download Data