DEPOSIT_DATE | TOTAL_DEPOSIT_TRANSACTIONS | TOTAL_DEPOSITORS | TOTAL_DEPOSITS_USD | |
|---|---|---|---|---|
1 | 2024-12-02 00:00:00.000 | 5 | 1 | 0.00007334876132 |
2 | 2024-12-03 00:00:00.000 | 391 | 190 | 218529.721206512 |
3 | 2024-12-04 00:00:00.000 | 1 | 1 | 962.0175 |
4 | 2024-12-05 00:00:00.000 | 1 | 1 | 67.8071633 |
5 | 2024-12-06 00:00:00.000 | 3 | 3 | 1227.08992 |
6 | 2024-12-07 00:00:00.000 | 2 | 2 | 220.7799 |
7 | 2024-12-09 00:00:00.000 | 1 | 1 | 0.361736525 |
8 | 2024-12-10 00:00:00.000 | 1 | 1 | 912.8375 |
9 | 2024-12-11 00:00:00.000 | 1 | 1 | 1914.84 |
10 | 2024-12-12 00:00:00.000 | 19 | 3 | 139.959366172 |
11 | 2024-12-13 00:00:00.000 | 1 | 1 | 0.0390075 |
12 | 2024-12-17 00:00:00.000 | 3 | 3 | 0.6195480598 |
13 | 2024-12-18 00:00:00.000 | 2 | 2 | 1.66643993 |
14 | 2024-12-19 00:00:00.000 | 24 | 12 | 142487.87552452 |
15 | 2024-12-20 00:00:00.000 | 20 | 14 | 5218.680231617 |
16 | 2024-12-21 00:00:00.000 | 13 | 10 | 2741.55418218 |
17 | 2024-12-22 00:00:00.000 | 13 | 9 | 1441.522288298 |
18 | 2024-12-23 00:00:00.000 | 51 | 32 | 142962.542504248 |
19 | 2024-12-24 00:00:00.000 | 18 | 12 | 376864.281745431 |
20 | 2024-12-25 00:00:00.000 | 41 | 13 | 38833.5020993 |
cryptodatadiveDaily Deposits
Updated 2025-04-06
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
›
⌄
WITH D1 AS (
SELECT DISTINCT
contract_name,
contract_address,
origin_from_address AS depositor,
CASE
WHEN decoded_log:wad IS NOT NULL
THEN (decoded_log:wad::int)
ELSE (decoded_log:assets::int)
END AS deposit_amount,
tx_hash,
DATE_TRUNC('day', block_timestamp) AS deposit_date
FROM swell.core.ez_decoded_event_logs
WHERE event_name = 'Deposit'
),
D2 AS (
SELECT DISTINCT
contract_name,
contract_address,
origin_from_address AS depositor,
(decoded_log:assets[1]::int) AS deposit_amount,
tx_hash,
DATE_TRUNC('day', block_timestamp) AS deposit_date
FROM swell.core.ez_decoded_event_logs
WHERE event_name = 'Deposits'
),
-- Deduplicate prices to ensure only one price per token per day
prices AS (
SELECT
LOWER(name) AS name,
LOWER(symbol) AS symbol,
DATE_TRUNC('day', hour) AS price_date,
price,
decimals,
Last run: 20 days ago
...
122
6KB
2s