msafadoostContracts used by whales
Updated 2022-07-18
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 whales1 AS (
SELECT SELLER,
COUNT(SELLER) as counts,
'Flow' AS label
FROM flow.core.fact_nft_sales
WHERE BLOCK_TIMESTAMP >= '2022-04-20'
AND TX_SUCCEEDED = 'TRUE'
AND PRICE > 0
GROUP by 1 HAVING counts >= 500
),
whales2 AS (
SELECT BUYER,
COUNT(BUYER) as counts,
'Flow' AS label
FROM flow.core.fact_nft_sales
WHERE BLOCK_TIMESTAMP >= '2022-04-20'
AND TX_SUCCEEDED = 'TRUE'
AND PRICE > 0
GROUP by 1 HAVING counts >= 500
),
whales AS (
SELECT SELLER
FROM whales1 JOIN whales2 ON SELLER = BUYER
GROUP by 1
)
SELECT CONTRACT_NAME,
COUNT(CONTRACT_NAME)
FROM flow.core.fact_events JOIN flow.core.dim_contract_labels USING(EVENT_CONTRACT)
WHERE TX_ID IN (
SELECT TX_ID
FROM flow.core.fact_transactions
WHERE PROPOSER IN (
SELECT SELLER FROM whales
)
)
GROUP by 1
Run a query to Download Data