SpecterStakers leaderboard (TOP 20)
Updated 2024-07-11Copy 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 Parclstaking AS(
select DATE_TRUNC('DAY',BLOCK_TIMESTAMP) AS Date,
TX_ID,
Instruction:parsed:info:amount / 1000000 AS Adjusted_amount,
SIGNERS [0] AS stakers
from solana.core.fact_events
WHERE event_type = 'transfer'
AND BLOCK_TIMESTAMP >= '2024-07-05'
AND INDEX = 0
AND SUCCEEDED = 'TRUE'
),
parclfilter AS (
SELECT
tx_id
FROM
solana.core.fact_events
WHERE program_id = '2gWf5xLAzZaKX9tQj9vuXsaxTWtzTZDFRn21J3zjNVgu'
and index = 1
),
ParclPrice AS (
SELECT
TRUNC(hour, 'day') AS day,
AVG(price) AS price_usd
FROM
solana.price.ez_prices_hourly
WHERE
token_address = '4LLbsb5ReP3yEtYzmXewyGjcir5uXtKFURtaEUVC2AHs'
AND Symbol = 'PRCL'
GROUP BY
day
),
Filteredout AS (
SELECT
ps.tx_Id, ps.date,
ps.Adjusted_amount,
stakers
QueryRunArchived: QueryRun has been archived