rw2023$MSC # Holders
Updated 2023-10-04
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
›
⌄
-- forked from $MSU # Holders @ https://flipsidecrypto.xyz/edit/queries/34cdff57-8c26-474e-b9c7-394a4012985a
-- forked from $MSU Top Holders @ https://flipsidecrypto.xyz/edit/queries/60941a6a-0be8-4b11-ae1f-f5f64ab15c6f
-- forked from $AURY Mint Address @ https://flipsidecrypto.xyz/edit/queries/f8c72d64-9530-4da5-8af2-b0d982100aee
WITH token_msu_in AS (
SELECT
to_address as owner,
SUM(amount) AS volume_in
FROM polygon.core.ez_token_transfers
WHERE contract_address ilike '0x5d2375C6af4b7dE4e395ADa20aab937895B4fa70'
AND block_timestamp >= '2021-01-23'
GROUP BY 1
),
token_msu_out AS (
SELECT
from_address as owner,
- SUM(amount) AS volume_out
FROM polygon.core.ez_token_transfers
WHERE contract_address ilike '0x5d2375C6af4b7dE4e395ADa20aab937895B4fa70'
AND block_timestamp >= '2021-01-23'
GROUP BY 1
),
token_msu_balance AS (
SELECT
COALESCE(token_msu_in.owner, token_msu_out.owner) AS owner,
COALESCE(token_msu_in.volume_in, 0) AS volume_in,
COALESCE(token_msu_out.volume_out, 0) AS volume_out,
(COALESCE(token_msu_in.volume_in, 0) + COALESCE(token_msu_out.volume_out, 0)) AS total_balance
FROM token_msu_in
FULL OUTER JOIN token_msu_out ON token_msu_in.owner = token_msu_out.owner
)
SELECT COUNT(*)
Run a query to Download Data