TheLaughingManVRTX Staking Burns test
Updated 2025-01-14
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
›
⌄
-- forked from VRTX Staking Totals FINAL @ https://flipsidecrypto.xyz/studio/queries/d21a2b3a-091e-4a6d-b141-d9406615b208
-- forked from VRTX Staking Totals (updated contracts) @ https://flipsidecrypto.xyz/studio/queries/38f4e527-d13d-401b-a707-e6f240f8cdf8
-- forked from VRTX Staking @ https://flipsidecrypto.xyz/studio/queries/efaed75a-c622-40cb-bf13-c162ebbcec5f
with base as (
SELECT tx_hash
from arbitrum.vertex.ez_staking_actions
WHERE 1=1
AND stake_action NOT in ('migrate-stake', 'stake')
AND symbol = 'VRTX'
AND block_timestamp>='2024-12-01'
ANd from_address!='0x5be754ad77766089c4284d914f0cc37e8e3f669a'
)
SELECT
tx_hash
, COUNT(*) as totals
from arbitrum.core.fact_event_logs
WHERE 1=1
AND tx_hash in (select * from base)
GROUP BY 1
QueryRunArchived: QueryRun has been archived