DAY | DAILY_BALANCE | USD_BALANCE | PRICE | |
|---|---|---|---|---|
1 | 2020-11-18 00:00:00.000 | 0.09504 | 45.480711883 | 478.542843891 |
2 | 2020-11-19 00:00:00.000 | 0.6846 | 324.938611233 | 474.640098207 |
3 | 2020-11-20 00:00:00.000 | 1.14444 | 567.160388399 | 495.578962986 |
4 | 2020-11-21 00:00:00.000 | 1.45908 | 759.488179349 | 520.525385413 |
5 | 2020-11-22 00:00:00.000 | 1.78308 | 972.345041185 | 545.317675699 |
6 | 2020-11-23 00:00:00.000 | 2.24916 | 1315.459044237 | 584.866814383 |
7 | 2020-11-24 00:00:00.000 | 2.44716 | 1488.666444019 | 608.324116126 |
8 | 2020-11-25 00:00:00.000 | 2.68452 | 1594.762715891 | 594.058794828 |
9 | 2020-11-26 00:00:00.000 | 2.9064 | 1518.151640803 | 522.347798239 |
10 | 2020-11-27 00:00:00.000 | 3.21312 | 1652.724815926 | 514.367597826 |
11 | 2020-11-28 00:00:00.000 | 3.36156 | 1762.696190601 | 524.368504683 |
12 | 2020-11-29 00:00:00.000 | 3.50916 | 1924.41763279 | 548.398372485 |
13 | 2020-11-30 00:00:00.000 | 3.78144 | 2237.532740263 | 591.714463343 |
14 | 2020-12-01 00:00:00.000 | 4.13664 | 2497.391489334 | 603.724638676 |
15 | 2020-12-02 00:00:00.000 | 4.4208 | 2621.224448894 | 592.929888005 |
16 | 2020-12-03 00:00:00.000 | 4.72704 | 2855.573635463 | 604.093393638 |
17 | 2020-12-04 00:00:00.000 | 4.92624 | 2953.062809556 | 599.455732883 |
18 | 2020-12-05 00:00:00.000 | 6.97624 | 4088.3547937 | 586.039871578 |
19 | 2020-12-06 00:00:00.000 | 4.35292 | 2593.845153047 | 595.886244876 |
20 | 2020-12-07 00:00:00.000 | 4.7428 | 2820.497422849 | 594.690356509 |
bg_altZED treasury
Updated 2025-02-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
›
⌄
WITH inflows AS (
SELECT
DATE_TRUNC('day', t.block_timestamp) AS day,
SUM(t.amount) AS inflow
FROM
polygon.core.ez_token_transfers t
WHERE
t.to_address = '0xd9952dc091e7cf5ec199c431c69cec8573710333'
AND t.contract_address = '0x7ceb23fd6bc0add59e62ac25578270cff1b9f619'
GROUP BY
day
),
outflows AS (
SELECT
DATE_TRUNC('day', t.block_timestamp) AS day,
SUM(t.amount) AS outflow
FROM
polygon.core.ez_token_transfers t
WHERE
t.from_address = '0xd9952dc091e7cf5ec199c431c69cec8573710333'
AND t.contract_address = '0x7ceb23fd6bc0add59e62ac25578270cff1b9f619'
GROUP BY
day
),
daily_transactions AS (
SELECT
COALESCE(i.day, o.day) AS day,
COALESCE(i.inflow, 0) - COALESCE(o.outflow, 0) AS net_amount
FROM
inflows i FULL
OUTER JOIN outflows o ON i.day = o.day
),
daily_prices AS (
SELECT
DATE_TRUNC('day', hour) AS day,
AVG(price) AS price
Last run: about 2 months agoAuto-refreshes every 12 hours
...
250
17KB
33s