staderUntitled Query
Updated 2022-08-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 liquid_delegations as (
SELECT
--date(block_timestamp) as date,
msg_value:sender::string as user_ls,
sum((msg_value:coins[0]:amount::float)/POW(10,6)) as ls_staked
FROM
flipside_prod_db.terra.msgs
WHERE
msg_value:contract::string in ('terra1xacqx447msqp46qmv8k2sq6v5jh9fdj37az898')
and msg_value:execute_msg:deposit is not null
and tx_status = 'SUCCEEDED'
--and date(block_timestamp) >= current_date - INTERVAL '30 days'
and date(block_timestamp) >= date('2021-11-20')
and date(block_timestamp) <= date('2022-05-08')
group by 1
),
liquid_undelegations as (
SELECT
--date(block_timestamp) as date,
msg_value:sender::string as user_lu,
(sum(msg_value:execute_msg:send:amount::float)/POW(10,6)) as ls_unstaked
FROM
flipside_prod_db.terra.msgs
WHERE
msg_value:contract::string in ('terra17y9qkl8dfkeg4py7n0g5407emqnemc3yqk5rup')
and msg_value:execute_msg:send:contract::string in ('terra1xacqx447msqp46qmv8k2sq6v5jh9fdj37az898')
and msg_value:execute_msg:send:msg::string in ('eyJxdWV1ZV91bmRlbGVnYXRlIjp7fX0=')
and tx_status = 'SUCCEEDED'
--and date(block_timestamp) >= current_date - INTERVAL '30 days'
and date(block_timestamp) >= date('2021-11-20')
and date(block_timestamp) <= date('2022-05-08')
group by 1
),
consolidated as (
Run a query to Download Data