DECODED_ACCOUNTS[7]:PUBKEY | |
---|---|
1 | BC5xAUpEbfeSWi5fJdvhFQhM3eMbTok2c7SY62daB3da |
2 | 7b2jY9CeCWCnyKBvaLSnsV7qwUhbJGsJTPdyCsspPY7Q |
crypto_edgar2024-02-16 03:39 PM
Updated 2024-02-17
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 FLP AS (
SELECT
-- COUNT(DISTINCT DECODED_ACCOUNTS[3]:pubkey),
-- DISTINCT DECODED_ACCOUNTS[4]:pubkey
-- DISTINCT DECODED_ACCOUNTS[5]:pubkey
DISTINCT DECODED_ACCOUNTS[7]:pubkey
-- COUNT(DISTINCT DECODED_ACCOUNTS[4]:pubkey),
-- COUNT(DISTINCT DECODED_ACCOUNTS[5]:pubkey),
-- COUNT(DISTINCT DECODED_ACCOUNTS[7]:pubkey)
-- DECODED_ACCOUNTS
FROM
solana.core.ez_events_decoded
WHERE
BLOCK_TIMESTAMP >= '2023-12-28'
AND PROGRAM_ID = 'FLASH6Lo6h3iasJKWDs2F8TkW2UKf3s15C8PMGuVfgBn'
AND SUCCEEDED
AND EVENT_TYPE = 'collectStakeFees'
)
-- TOKEN_PRICES AS (
-- SELECT
-- RECORDED_HOUR :: date as DAY,
-- TOKEN_ADDRESS,
-- AVG(CLOSE) AS PRICE
-- FROM
-- solana.price.ez_token_prices_hourly
-- WHERE
-- RECORDED_HOUR >= '2023-12-28'
-- GROUP BY
-- DAY,
-- TOKEN_ADDRESS
-- ),
-- Final_Table AS (
-- SELECT
-- DATE_TRUNC('Day', TRANSFERS.BLOCK_TIMESTAMP) AS TRANSFERS_DAY,
-- SUM(AMOUNT * PRICE) AS VOLUME,
-- AVG(AMOUNT * PRICE) AS AVG_VOLUME,
Last run: about 1 year ago
2
99B
0s