Hessishbrav- stake daily
Updated 2023-10-25
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT TIMESTAMP::date as date, count(DISTINCT CALLER) as users,
count(DISTINCT TX_HASH) as stakes ,
sum(INPUTS[0]:value[0]:value/pow(10,18)) as volume
from external.tokenflow_starknet.decoded_traces
where TIMESTAMP::date >= '2023-06-22' and
FUNCTION = 'stake'
and contract = '0x05abfa46fe9bf3323dfe801da51174729c2b3dd060b80575b29c015245899d74'
GROUP by 1
Run a query to Download Data