adam10UST Deposits on ANC
Updated 2021-08-01
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
trunc(block_timestamp, 'day') as day,
SUM(msg_value:coins[0]:amount/POW (10,6)) as AMOUNT_deposited
FROM terra.msgs
WHERE msg_value:contract = 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s'
AND msg_value:execute_msg:deposit_stable IS NOT NULL
and block_timestamp >= CURRENT_DATE - 60
GROUP BY 1
ORDER BY 1 DESC, 2 DESC
limit 100
Run a query to Download Data