scottincryptoFinding Community Treasury
Updated 2021-07-16
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
›
⌄
⌄
⌄
⌄
--select distinct msg_type from terra.msg_events
select
*
from terra.msgs
where msg_type like 'distribution/MsgFundCommunityPool'
--order by block_timestamp
limit 100
/*select * from terra.gov_submit_proposal
where proposal_id = 100*/
/*select
*
from terra.daily_balances
where address = 'terra17h9mgy45yht6eg9mvyna52e05nfh8slg6s8tse'
and currency = 'LUNA'
and balance_type = 'liquid'
-- suspected pool address ----> where address = 'terra1jv65s3grqf6v6jl3dp4t6c9t9rk99cd8pm7utl'
*/
--2021.04.22 18:46:05 (GMT+10)
/* This query shows that there are no msgs when the propsal balance is executed
select
block_timestamp,
-- event_type,
msg_type,
msg_value,
cast (msg_value as string) as msg_txt
from terra.msgs
where block_timestamp > '2021-06-01T00:00:00Z'
--and block_timestamp < '2021-04-28T00:00:00Z'
and msg_module not in ('oracle')
and msg_txt like '%wrrdd5wa3c%'
order by block_timestamp
Run a query to Download Data