Questions tagged [dune]
The dune tag has no usage guidance.
6
questions
0
votes
0
answers
7
views
How to calculate ETH percentage supply in profit?
I'm trying to calculate the ETH percentage supply in profit.
Definition is: The percentage of circulating supply in profit, i.e. the percentage of existing coins whose price at the time they last ...
3
votes
1
answer
86
views
Do dune analytics `creation_traces` data include contracts created by other contracts?
Or do they only check to see for a to address to be blank in a transaction.
Does it find all CREATE/CREATE2 opcodes -> meaning an EoA or contract deployment?
- 10.5k
0
votes
0
answers
16
views
Calculating number of validators on dune
to find total validators on eth , i am using below logics >>
SELECT sum(amount_staked) FROM staking_ethereum.deposits as a,
SELECT sum(amount)/1e9 FROM ethereum.withdrawals as b ,
and my output ...
0
votes
1
answer
338
views
How to delete a dune dashboard I created?
How to delete a dune dashboard I created? cannot find any solution or docs on this.
- 55
1
vote
0
answers
161
views
convert time to utc in Dune Query
I can create a query on the DuneAnalytics site, but the default date format for a field is "2022-02-08 02:44", which downloads to csv as "2022-02-08T02:44:46+00:00". Does anyone ...
- 701
0
votes
1
answer
422
views
Convert address to string in Dune dashboard
I am playing with a query that does the job (not optimized yet), but I need some formatting in the sender column.
This is what I need:
Get rid of the initial '\' returned as sender
Append a 0 on ...
- 193