DATE | NET_DEPOSITS_ETH | TOTAL_DEPOSITS_ETH | |
|---|---|---|---|
1 | 2024-12-29 00:00:00.000 | 635.574334084 | 10776.683378989 |
2 | 2025-02-03 00:00:00.000 | 521.239341282 | 22029.25438604 |
3 | 2025-02-21 00:00:00.000 | 86.937905033 | 24637.414307652 |
4 | 2025-03-12 00:00:00.000 | 14.21693163 | 26698.25688825 |
5 | 2024-10-26 00:00:00.000 | 46.655494438 | 1629.051677181 |
6 | 2024-12-24 00:00:00.000 | 701.772772928 | 8421.402243876 |
7 | 2024-11-12 00:00:00.000 | 140.513350222 | 3241.485146989 |
8 | 2025-01-21 00:00:00.000 | 1279.151932334 | 17264.164346898 |
9 | 2024-12-17 00:00:00.000 | 244.274611976 | 6323.259257154 |
10 | 2025-01-07 00:00:00.000 | 223.916617196 | 12627.947469521 |
11 | 2024-11-20 00:00:00.000 | 39.700218458 | 3731.449982171 |
12 | 2025-01-30 00:00:00.000 | 237.917056503 | 20721.15606314 |
13 | 2024-10-04 00:00:00.000 | 4.265295692 | 211.353102916 |
14 | 2024-11-08 00:00:00.000 | 87.163357532 | 2858.955733607 |
15 | 2025-03-25 00:00:00.000 | 119.615842679 | 27608.362119759 |
16 | 2024-08-22 00:00:00.000 | 0.3267 | 104.599092524 |
17 | 2024-11-04 00:00:00.000 | 70.060523901 | 2066.066110404 |
18 | 2025-03-04 00:00:00.000 | 66.253725832 | 26063.642986951 |
19 | 2024-11-26 00:00:00.000 | 310.174477722 | 4258.086978744 |
20 | 2024-10-11 00:00:00.000 | 4.82734329 | 233.349141075 |
Pine Analyticsdark-rose copy
Updated 2025-03-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
-- forked from dark-rose @ https://flipsidecrypto.xyz/studio/queries/c5a480ec-ab52-49d2-b59e-b12761360710
SELECT
date(block_timestamp) as date,
sum(case when To_address LIKE lower('0xD7E4b67E735733aC98a88F13d087D8aac670E644') then amount else -amount end) as net_deposits_eth,
sum(net_deposits_eth) over (order by date) as total_deposits_eth
FROM ethereum.core.ez_native_transfers
where To_address LIKE lower('0xD7E4b67E735733aC98a88F13d087D8aac670E644')
OR from_address LIKE lower('0xD7E4b67E735733aC98a88F13d087D8aac670E644')
group BY 1
Last run: about 1 month ago
...
259
14KB
523s