DATE | Chain | W Tokens | Active Stake | |
|---|---|---|---|---|
1 | 2024-06-06 00:00:00.000 | Optimism | 779049.20933 | 805853.320970839 |
2 | 2024-06-07 00:00:00.000 | Optimism | 1116148.344001 | 1922001.66497184 |
3 | 2024-06-08 00:00:00.000 | Optimism | 1264572.046491 | 3186573.71146284 |
4 | 2024-06-09 00:00:00.000 | Optimism | 1109503.238576 | 4296076.95003884 |
5 | 2024-06-10 00:00:00.000 | Optimism | 1597843.72402726 | 5893920.6740661 |
6 | 2024-06-11 00:00:00.000 | Optimism | -89395.473944529 | 5804525.20012157 |
7 | 2024-06-12 00:00:00.000 | Optimism | 310891.740300661 | 6115416.94042223 |
8 | 2024-06-13 00:00:00.000 | Optimism | 176910.293195997 | 6292327.23361823 |
9 | 2024-06-14 00:00:00.000 | Optimism | 83956.640768857 | 6376283.87438709 |
10 | 2024-06-15 00:00:00.000 | Optimism | 54085.350465539 | 6430369.22485263 |
11 | 2024-06-16 00:00:00.000 | Optimism | 97355.037683211 | 6527724.26253584 |
12 | 2024-06-17 00:00:00.000 | Optimism | -110130.952732439 | 6417593.3098034 |
13 | 2024-06-18 00:00:00.000 | Optimism | 128403.999109041 | 6545997.30891244 |
14 | 2024-06-19 00:00:00.000 | Optimism | 194334.015708651 | 6740331.32462109 |
15 | 2024-06-20 00:00:00.000 | Optimism | 63144.999651978 | 6803476.32427307 |
16 | 2024-06-21 00:00:00.000 | Optimism | 52754.972035428 | 6856231.2963085 |
17 | 2024-06-22 00:00:00.000 | Optimism | 35580.213079369 | 6891811.50938786 |
18 | 2024-06-23 00:00:00.000 | Optimism | 28694.085474429 | 6920505.59486229 |
19 | 2024-06-24 00:00:00.000 | Optimism | 196.228685927 | 6920701.82354822 |
20 | 2024-06-25 00:00:00.000 | Optimism | 21632.789835356 | 6942334.61338358 |
marquw gov - voting power over time
Updated 2025-03-28
999
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
delegateVotesChanged_txs as (
select
block_timestamp
, tx_hash
, concat('0x', right(topics[1], 40)) as delegate
, utils.udf_hex_to_int(substr(data, 67, 64)) ::int / pow(10, 18) as new_votes
, utils.udf_hex_to_int(substr(data, 3, 64)) ::int / pow(10, 18) as previous_votes
, new_votes - previous_votes as change_votes
, 'Ethereum' as chain
from ethereum.core.fact_event_logs
where tx_status = 'SUCCESS'
and contract_address = '0xb0ffa8000886e57f86dd5264b9582b2ad87b2b91'
and topics[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' -- DelegateVotesChanged
and block_timestamp >= '2024-04-17'
-- qualify row_number() over (partition by delegate order by block_timestamp desc) = 1
union all
select
block_timestamp
, tx_hash
, concat('0x', right(topics[1], 40)) as delegate
, utils.udf_hex_to_int(substr(data, 67, 64)) ::int / pow(10, 18) as new_votes
, utils.udf_hex_to_int(substr(data, 3, 64)) ::int / pow(10, 18) as previous_votes
, new_votes - previous_votes as change_votes
, 'Arbitrum' as chain
from arbitrum.core.fact_event_logs
where tx_status = 'SUCCESS'
and contract_address = '0xb0ffa8000886e57f86dd5264b9582b2ad87b2b91'
Last run: about 1 month ago
...
1184
82KB
213s