NatYet another acme question | Daily
Updated 2022-04-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
›
⌄
WITH deposits as (
SELECT
TRUNC(block_timestamp, 'day') as date,
SUM(AMOUNT_USD) as amount_usd
FROM terra.transfer_events
WHERE TX_ID = ANY(
SELECT
TX_ID
FROM terra.msgs
WHERE MSG_VALUE:contract ='terra19dtgj9j5j7kyf3pmejqv8vzfpxtejaypgzkz5u'
AND TX_STATUS = 'SUCCEEDED')
AND INITIAL_ACTION='deposit_native'
GROUP BY 1
),
withdraws as (
SELECT
TRUNC(block_timestamp, 'day') as date,
SUM(AMOUNT_USD) as amount_usd
FROM terra.transfer_events
WHERE TX_ID = ANY(
SELECT
TX_ID
FROM terra.msgs
WHERE MSG_VALUE:contract ='terra19dtgj9j5j7kyf3pmejqv8vzfpxtejaypgzkz5u'
AND TX_STATUS = 'SUCCEEDED')
AND INITIAL_ACTION='withdraw'
GROUP BY 1
),
repays as (
SELECT
TRUNC(block_timestamp, 'day') as date,
SUM(AMOUNT_USD) as amount_usd
FROM terra.transfer_events
WHERE TX_ID = ANY(
SELECT
TX_ID
Run a query to Download Data