EVENT_NAME | TOTAL_AMOUNT | AVERAGE_TRANSACTION_SIZE | UNIQUE_USERS_COUNT | NUMBER_OF_TRANSACTIONS | TOTAL_VALUE_USD | |
|---|---|---|---|---|---|---|
1 | Deposit | 4686072.743451 | 3003.892784263462 | 1151 | 1560 | 3285761.741962 |
2 | Withdraw | 133164.326737 | 643.3059262657 | 141 | 207 | 93371.629964143 |
Updated 8 days ago
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
-- Combined deposits and withdrawals based on event_name
transactions AS (
SELECT
block_timestamp,
tx_hash,
contract_address,
event_name,
CASE
WHEN event_name = 'Deposit' THEN decoded_log:assets::int
WHEN event_name = 'Withdraw' THEN decoded_log:assets::int
END AS amount,
origin_from_address AS user_address
FROM ronin.core.ez_decoded_event_logs
WHERE
contract_address = LOWER('0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2')
AND event_name IN ('Deposit', 'Withdraw')
),
-- Calculate token price in USD (getting the latest price)
token_prices AS (
SELECT
token_price_usd
FROM (
SELECT
hour::date AS date,
token_address,
symbol,
decimals,
median(price) AS token_price_usd,
ROW_NUMBER() OVER (ORDER BY hour::date DESC) as rn
FROM
ronin.price.ez_prices_hourly
WHERE
SYMBOL = 'WRON'
GROUP BY
hour::date,
Last run: 8 days ago
2
137B
3s