freemartianDaily Staking Stats
Updated 2022-07-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select
sum(raw_amount)/pow(10,9) as amount,
count(distinct from_address) as count,
date_trunc('day', block_timestamp::date) as TIME,
'Staked' as Label
from ethereum.core.ez_token_transfers
where to_address = '0x759c6de5bca9ade8a1a2719a31553c4b7de02539'
and contract_address = '0xf59257e961883636290411c11ec5ae622d19455e'
and origin_to_address = '0x759c6de5bca9ade8a1a2719a31553c4b7de02539'
and block_timestamp > CURRENT_DATE - 91
group by TIME
UNION
select
sum(raw_amount)/pow(10,9) as amount,
count(distinct to_address) as count,
date_trunc('day', block_timestamp::date) as TIME,
'unstaked' as Label
from ethereum.core.ez_token_transfers
where from_address = '0x759c6de5bca9ade8a1a2719a31553c4b7de02539'
and contract_address = '0xf59257e961883636290411c11ec5ae622d19455e'
and origin_to_address = '0x759c6de5bca9ade8a1a2719a31553c4b7de02539'
and block_timestamp > CURRENT_DATE - 91
group by TIME
Run a query to Download Data