crypto_edgar2023-12-12 09:49 PM
Updated 2023-12-12
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
›
⌄
WITH WOLF_CAPITAL_NFTS AS (
SELECT
MINT
FROM
solana.nft.dim_nft_metadata
WHERE
COLLECTION_ID = '5ucdKHbPfmsWowXSNfHoiYEJ55kfFmvEdHii5RtjHpiH'
),
FROZEN_WOLVES AS (
SELECT
BLOCK_TIMESTAMP,
TX_ID,
SIGNERS [0] as WALLET
FROM
solana.core.fact_events
WHERE
SUCCEEDED
AND BLOCK_TIMESTAMP >= '2023-07-01'
AND PROGRAM_ID = 'metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s'
AND INSTRUCTION:data = 'T'
AND INSTRUCTION:accounts [3] IN (
SELECT
MINT
FROM
WOLF_CAPITAL_NFTS
)
)
SELECT COUNT(TX_ID), WALLET
from FROZEN_WOLVES
GROUP BY WALLET
Run a query to Download Data