par_rnOlas 03
Updated 2025-01-21
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
›
⌄
WITH main AS (
SELECT
TX_HASH,
ORIGIN_FROM_ADDRESS AS user,
BLOCK_TIMESTAMP,
CASE
WHEN is_redeemed = 'TRUE' THEN 'Redeem'
ELSE 'Deposit'
END AS event_name,
olas_amount,
olas_amount_usd
FROM
crosschain.olas.ez_olas_bonding
)
SELECT
DATE_TRUNC('month',BLOCK_TIMESTAMP) AS date,
event_name,
COUNT(DISTINCT TX_HASH) AS total_transactions,
COUNT(DISTINCT user) AS unique_users,
SUM(OLAS_AMOUNT) AS total_volume_olas,
AVG(OLAS_AMOUNT) AS average_volume_olas,
SUM(OLAS_AMOUNT_USD) AS total_volume_usd,
AVG(OLAS_AMOUNT_USD) AS average_volume_usd,
MAX(OLAS_AMOUNT_USD) AS max_volume_usd,
SUM(CASE WHEN event_name = 'Redeem' THEN olas_amount END) AS total_redeemed_olas,
SUM(CASE WHEN event_name = 'Redeem' THEN olas_amount_usd END) AS total_redeemed_usd,
SUM(CASE WHEN event_name = 'Deposit' THEN olas_amount END) AS total_deposit_olas,
SUM(CASE WHEN event_name = 'Deposit' THEN olas_amount_usd END) AS total_deposit_usd
FROM
main
GROUP BY
1,2
ORDER BY
1
QueryRunArchived: QueryRun has been archived