DAILY_DEPOSIT_DATE | DAILY_DEPOSIT_TRANSACTIONS | CUMULATIVE_DEPOSIT_TRANSACTIONS | DAILY_DEPOSIT_VALUE_IN_ETHER | CUMULATIVE_DEPOSIT_VALUE_IN_ETHER | DAILY_DEPOSIT_USERS | DEPOSIT_AMOUNT_CATEGORY | |
|---|---|---|---|---|---|---|---|
1 | 2025-02-09 00:00:00.000 | 11 | 571 | 44.805592 | 10194.415502 | 7 | Medium |
2 | 2025-02-08 00:00:00.000 | 15 | 560 | 276.849061 | 10149.60991 | 8 | Very High |
3 | 2025-02-07 00:00:00.000 | 19 | 545 | 635.472753 | 9872.760849 | 8 | Very High |
4 | 2025-02-06 00:00:00.000 | 26 | 526 | 333.225294 | 9237.288096 | 14 | Very High |
5 | 2025-02-05 00:00:00.000 | 38 | 500 | 410.291236 | 8904.062802 | 21 | Very High |
6 | 2025-02-04 00:00:00.000 | 33 | 462 | 97.455638 | 8493.771566 | 9 | High |
7 | 2025-02-03 00:00:00.000 | 14 | 429 | 50.177932 | 8396.315928 | 9 | High |
8 | 2025-02-02 00:00:00.000 | 10 | 415 | 22.367103 | 8346.137996 | 7 | Medium |
9 | 2025-02-01 00:00:00.000 | 41 | 405 | 1224.302266 | 8323.770893 | 15 | Very High |
10 | 2025-01-31 00:00:00.000 | 30 | 364 | 139.619416 | 7099.468627 | 22 | Very High |
11 | 2025-01-30 00:00:00.000 | 72 | 334 | 1213.821391 | 6959.849211 | 21 | Very High |
12 | 2025-01-29 00:00:00.000 | 147 | 262 | 4426.087926 | 5746.02782 | 46 | Very High |
13 | 2025-01-28 00:00:00.000 | 110 | 115 | 1319.883032 | 1319.939894 | 22 | Very High |
14 | 2025-01-23 00:00:00.000 | 2 | 5 | 0.0002 | 0.056862 | 1 | Very Low |
15 | 2025-01-22 00:00:00.000 | 3 | 3 | 0.056662 | 0.056662 | 3 | Very Low |
picasomain deposite
Updated 2025-02-09
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 Deposit_events AS (
SELECT
BLOCK_TIMESTAMP,
TX_HASH,
EVENT_INDEX,
CONTRACT_ADDRESS,
ORIGIN_FROM_ADDRESS,
ORIGIN_TO_ADDRESS,
ORIGIN_FUNCTION_SIGNATURE,
TX_SUCCEEDED,
EVENT_NAME,
FULL_DECODED_LOG,
DECODED_LOG:sender::TEXT AS sender,
(DECODED_LOG:assets::NUMERIC) / 1e18 AS value_in_ether, -- Converting to Ether (ETH)
CONTRACT_NAME,
DATE(BLOCK_TIMESTAMP) AS deposit_date
FROM
swell.core.ez_decoded_event_logs
WHERE
EVENT_NAME = 'Deposit'
AND ORIGIN_FUNCTION_SIGNATURE = '0xc16ae7a4'
),
-- Daily Deposit Transactions
Daily_Deposit_Transactions AS (
SELECT
deposit_date AS daily_deposit_date,
COUNT(DISTINCT TX_HASH) AS daily_deposit_transactions
FROM
Deposit_events
GROUP BY
deposit_date
),
-- Daily Deposit Value
Daily_Deposit_Value AS (
Last run: 2 months ago
15
1KB
2s