Mrftispiritual-black copy
Updated 2024-11-24
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 spiritual-black @ https://flipsidecrypto.xyz/studio/queries/d901923a-84ab-4c24-b31c-3f9d78038c27
WITH transfers AS (
WITH tbl3 AS (
WITH tbl AS (
SELECT
to_address AS "Address",
SUM(amount) AS "Input"
FROM
ethereum.core.ez_token_transfers
WHERE
contract_address = LOWER('0x358d94b5b2F147D741088803d932Acb566acB7B6') --rSWELL
GROUP BY 1
),
tbl2 AS (
SELECT
from_address AS "Address",
SUM(amount) AS "Output"
FROM
ethereum.core.ez_token_transfers
WHERE
contract_address = LOWER('0x358d94b5b2F147D741088803d932Acb566acB7B6') --rSWELL
GROUP BY 1
)
SELECT
tbl."Address",
COALESCE(tbl."Input", 0) AS "Input tokens",
COALESCE(tbl2."Output", 0) AS "Output tokens"
FROM
tbl
LEFT JOIN tbl2 ON tbl."Address" = tbl2."Address"
)
SELECT
"Address",
"Input tokens" - "Output tokens" AS "Token Balance",
MIN(DATE_TRUNC('day', block_timestamp)) AS first_transaction_date
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived