hanerOwned_Fairies
Updated 2023-07-27
999
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
collectors AS (
SELECT
BUYER AS ACCOUNT,
SUM(COLLECTED) AS COLLECTED,
CONCAT(
ROUND(
100 * (SUM(COLLECTED)) / (
SELECT
COUNT(DISTINCT PARAMETERS[2]:"value" [0]:"value")
FROM
external.tokenflow_starknet.decoded_events
WHERE
CONTRACT IN (
'0x012f8e318fe04a1fe8bffe005ea4bbd19cb77a656b4f42682aab8a0ed20702f0'
)
),
2
),
'%'
) AS PERCENTAGE
FROM
(
(
SELECT
PARAMETERS[1]:"value" AS BUYER,
PARAMETERS[2]:"value" [0]:"value" AS NFT_ID,
COUNT(BUYER) AS COLLECTED
FROM
external.tokenflow_starknet.decoded_events
WHERE
CONTRACT = '0x012f8e318fe04a1fe8bffe005ea4bbd19cb77a656b4f42682aab8a0ed20702f0'
AND NAME = 'Transfer'
GROUP BY
BUYER,
NFT_ID
Run a query to Download Data