0x_jeanTransactions at the time of the pump
Updated 2023-01-17
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
›
⌄
⌄
-- Return transaction data where LUNA is swapped for another asset
with tx_data as (
SELECT date_trunc('min', block_timestamp) as time,
tx_id,
tx:tx_result:log[0]:events[5]:attributes[2]:value as sender,
tx:tx_result:log[0]:events[5]:attributes[6]:value/1e6 as amount_luna
FROM terra.core.fact_transactions
WHERE block_timestamp::DATE BETWEEN '2023-01-09 16:00:00' AND '2023-01-09 18:00:00'
AND tx:tx_result:log[0]:events[5]:attributes[4]:key = 'offer_asset'
AND tx:tx_result:log[0]:events[5]:attributes[4]:value = 'uluna'
UNION ALL
SELECT date_trunc('min', block_timestamp) as time,
tx_id,
tx:tx_result:log[0]:events[5]:attributes[2]:value as sender,
tx:tx_result:log[0]:events[5]:attributes[7]:value/1e6 as amount_luna
FROM terra.core.fact_transactions
WHERE block_timestamp::DATE BETWEEN '2023-01-09 16:00:00' AND '2023-01-09 18:00:00'
AND tx:tx_result:log[0]:events[5]:attributes[5]:key = 'ask_asset'
AND tx:tx_result:log[0]:events[5]:attributes[5]:value = 'uluna'
)
SELECT time,
sum(amount_luna),
count(DISTINCT tx_id)
FROM tx_data
GROUP BY 1
/* SELECT date,
sum(offer_amount)
FROM tx_data
-- WHERE sender='terra19hz374h6ruwtzrnm8ytkae782uv79h9yt9tuytgvt94t26c4793qnfg7vn'
GROUP BY 1
ORDER BY 2 DESC */
Run a query to Download Data