DB_value claimed
Updated 2024-06-15
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 w_price AS (
SELECT
RECORDED_HOUR AS hour,
PRICE
FROM
osmosis.PRICE.EZ_PRICES
WHERE
symbol = 'WHALE'
AND hour > CURRENT_DATE - 30
ORDER BY
1 DESC
),
claimed AS (
SELECT
date_trunc(day, block_timestamp) AS day,
COUNT(DISTINCT tx_id) AS claim_count,
SUM(COUNT(DISTINCT tx_id)) OVER (ORDER BY day) AS cumulative_claims,
SUM(amount) / 1000000 AS amount_claimed,
SUM(SUM(amount) / 1000000) OVER (ORDER BY day) AS cumulative_amount
FROM
terra.core.ez_transfers
WHERE
sender = 'terra1xm0yh8cv8rww6g87h3q0megt6ntxqzw6p6hgh5l4jrhed4fe7hnq9cvzm5'
AND day > CURRENT_DATE - 30
GROUP BY
1
ORDER BY
1 DESC
)
SELECT
c.day,
c.claim_count,
c.cumulative_claims,
c.amount_claimed,
c.cumulative_amount,
Auto-refreshes every 6 hours
QueryRunArchived: QueryRun has been archived