rw2023$MSU Quickswap address
Updated 2023-10-04
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
›
⌄
-- 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 '0x24c8cdea5097fe32f0dccd176bc5b651f2f1138d'
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 '0x24c8cdea5097fe32f0dccd176bc5b651f2f1138d'
AND block_timestamp >= '2021-01-23'
GROUP BY 1
),
usdc_in AS (
SELECT
date_trunc('day', block_timestamp) as date,
SUM(amount) AS volume_in_usdc
FROM polygon.core.ez_token_transfers
WHERE contract_address ilike '0x2791bca1f2de4661ed88a30c99a7a9449aa84174'
AND to_address ilike '0x24c8cdea5097fe32f0dccd176bc5b651f2f1138d'
AND block_timestamp >= '2021-01-23'
GROUP BY 1
Run a query to Download Data