DATE | NET_DEPOSITS_ETH | TOTAL_DEPOSITS_ETH | |
|---|---|---|---|
1 | 2024-09-14 00:00:00.000 | 0.40378 | 122.837596184 |
2 | 2024-12-26 00:00:00.000 | 397.622773634 | 9215.431328845 |
3 | 2024-08-17 00:00:00.000 | 5.150896 | 101.668993524 |
4 | 2024-10-30 00:00:00.000 | 30.136514123 | 1758.858156821 |
5 | 2024-10-09 00:00:00.000 | 3.05468245 | 226.122810095 |
6 | 2024-10-12 00:00:00.000 | 5.82635465 | 239.175495725 |
7 | 2025-03-11 00:00:00.000 | 32.344257866 | 26684.039956619 |
8 | 2024-09-27 00:00:00.000 | 3.777426585 | 156.543518009 |
9 | 2024-08-05 00:00:00.000 | 0.92172 | 37.7637129 |
10 | 2025-02-01 00:00:00.000 | 152.210343241 | 21136.008343479 |
11 | 2024-08-14 00:00:00.000 | 1.840890378 | 94.79105853 |
12 | 2024-10-02 00:00:00.000 | 5.218034996 | 202.157134488 |
13 | 2024-09-10 00:00:00.000 | 5.6845682 | 119.508937684 |
14 | 2025-02-28 00:00:00.000 | 121.5857342 | 25546.414277565 |
15 | 2025-03-10 00:00:00.000 | 83.870294455 | 26651.695698754 |
16 | 2024-12-15 00:00:00.000 | 256.301485603 | 5924.524532558 |
17 | 2024-12-12 00:00:00.000 | 86.679832136 | 5201.857493549 |
18 | 2025-02-20 00:00:00.000 | 121.091416629 | 24550.476402619 |
19 | 2024-09-21 00:00:00.000 | 1.45952 | 130.244320184 |
20 | 2025-01-09 00:00:00.000 | 376.274581486 | 13069.757448731 |
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: 15 days ago
...
235
13KB
7s