anomonevVISr staked amount daily
Updated 2022-02-03
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
⌄
SELECT BALANCE_DATE AS "Date" ,
sum(NON_ADJUSTED_BALANCE/1e18) as adjusted_balance, sum(AMOUNT_USD) as "Staked Amount in USD"
FROM ethereum.erc20_balances
WHERE (contract_address = LOWER('0x3a84aD5d16aDBE566BAA6b3DafE39Db3D5E261E5'))
GROUP BY BALANCE_DATE
/*
SELECT *, (NON_ADJUSTED_BALANCE/1e18) as adjusted_balance FROM ethereum.erc20_balances
WHERE ( balance_date like '2021-12-20%' ) AND (contract_address = LOWER('0x3a84aD5d16aDBE566BAA6b3DafE39Db3D5E261E5') )
ORDER BY adjusted_balance desc
*/
Run a query to Download Data