Data

/toc Onchain strategy at terminallyonchain.xyz | co-host /latenightcrew

Interested! It’s my dune account: https://dune.com/yulia_is_here

Does anyone know how dashboards are ranked on @dune.eth? In both screenshots, the first dashboard doesn’t have the ‘popular🔥’ tag and has fewer likes than the dashboards below

Hey👋🏻 To filter by the method_id - find it on etherscan in the transaction details. There is a column in ethereum.transactions table on Dune that is responsible for method_id. 

So, you can write smth like that: 
select *
from ethereum.transactions
where CAST(data AS VARCHAR) LIKE '0xf25efffc%’

Building @kiwi 
Writing @ https://kanfa.macbudkowski.com/

headmaster @duneanalytics, previously mirror and consensys

Initially I found it on Twitter; soon it was also posted in discord bounty/job channels of Dune and Flipside

The first one for me was analyzing the activity of specific addresses on TRON. It was my first time writing a python script and using Tronscan API to extract the data; after that started working a lot with Python, API’s, and RPC 👩🏼‍💻

I’ve got an access to beta and read the smart contract function “total supply”. Http_get() is really cool but need some improvements, like hiding sensitive variables (api key 🔑)

Yulia

@yulia