dune

HAM 🍖

Ham Season 2 is almost done cooking and ready to come out of the oven. 

$HAM is on chain and ready to be distributed. If you've made bots or frames for Ham tips and want to get a jump on season 2 here is the $HAM smart contract. Real-time balances and app approvals built in ✨

https://explorer.ham.fun/address/0x7a6B7Ad9259c57fD599E1162c6375B7eA63864e4?tab=read_contract

I'm looking at you @nikolaiii @edit @downshift.eth 

Lmk if you have any questions!

@afl @rchen8 what’s the process to add a new L3 chain to dune? would love to see hamchain added and would love to help if possible (though not sure i have the requisite skillz). would be willing to sponsor a bounty tho!

Founder at Varrock. Previously General Partner at 1confirmation
https://showerthoughts.substack.com/

You'll need to have a Dune Enterprise account to access the hosted blockchain endpoints. You can see the docs here:

enjoy cats, running, bread, and a bit of w̶e̶b̶3̶ onchain data

You'll need to have a Dune Enterprise account to access the hosted blockchain endpoints. You can see the docs here:
https://docs.dune.com/api-reference/tables/blockchain/insert#blocks

thank you! yeah, def over my head a bit 😅 

i’d imagine this work is generally done by the core team, or close collaborators?

You'll need access to an RPC endpoint for the chain and can use a tool like cryo to get the raw data, then write a script to transform the data into Dune's schema to upload into their tables.

You'll need access to an RPC endpoint for the chain and can use a tool like cryo to get the raw data, then write a script to transform the data into Dune's schema to upload into their tables.
https://github.com/paradigmxyz/cryo