KaskoazulMARS UST Locked
Updated 2022-03-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
block_timestamp::date as fecha,
sum (amount),
count (tx_id)
FROM
terra.transfer_events
WHERE
--tx_id = '840078A179B58F9D5407236B49C9A6F9BF28CCC2FDB7E6D37060CEF53855EB1E'
recipient = 'terra1hgyamk2kcy3stqx82wrnsklw9aq7rask5dxfds' --Mars Protocol
--contract_address = 'terra1hgyamk2kcy3stqx82wrnsklw9aq7rask5dxfds'
AND fecha >= CURRENT_DATE - 20
GROUP BY 1
ORDER BY 1
Run a query to Download Data