rw2023$MSU Scouting
Updated 2023-05-23
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 Team @ https://flipsidecrypto.xyz/edit/queries/d98d44d6-135c-439a-9167-1394cbd746ca
-- forked from $MSU Private Sale @ https://flipsidecrypto.xyz/edit/queries/0a3a5bd1-b1ed-4353-92d1-78e04d9c4603
-- forked from $MSU Ecosystem @ https://flipsidecrypto.xyz/edit/queries/62deb06f-9d62-473c-91bb-f1fa18fbd79e
-- forked from $MSU Rewards @ https://flipsidecrypto.xyz/edit/queries/1fabafa4-bf18-4c5e-9aa1-2fa76c86eeb8
-- forked from $MSU Gate address @ https://flipsidecrypto.xyz/edit/queries/8a2f0d0b-d558-48d0-8589-da97921a2101
-- forked from $MSU Quickswap address @ https://flipsidecrypto.xyz/edit/queries/bb5271d2-ad14-406a-a43c-46d548f5c2e8
-- 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
msu_in AS (
SELECT
date_trunc('day', block_timestamp) as date,
SUM(amount) AS volume_in
FROM polygon.core.ez_token_transfers
WHERE contract_address ilike '0xe8377A076adAbb3F9838afB77Bee96Eac101ffB1'
AND to_address ilike '0x3317b22aD951EdA895897FcD7866Da7755867784'
AND block_timestamp >= '2021-01-23'
GROUP BY 1
),
msu_out AS (
SELECT
date_trunc('day', block_timestamp) as date,
- SUM(amount) AS volume_out
FROM polygon.core.ez_token_transfers
WHERE contract_address ilike '0xe8377A076adAbb3F9838afB77Bee96Eac101ffB1'
AND from_address ilike '0x3317b22aD951EdA895897FcD7866Da7755867784'
AND block_timestamp >= '2021-01-23'
GROUP BY 1
Run a query to Download Data