more CEX spot volume for ETH than BTC for the first time in at least 5 years

RT @antoniogm: Listen to @base Ads data scientist @juicemanjamez discuss what we're doing with ads at @coinbase, alongside onchain data cel….

RT @tomwanhh: From Curve to Fluid, the shift in the primary liquidity hub for Stablecoins on Ethereum. Curve's Dominance from 2020 to 2024….

Bitcoin’s on fire at $112K! Time to flip the charts on BTCC!.Exploring Cryptocurrency with Jaren Jackson Jr.🏀.

gmonad

4/ here's the final 3 line query, just note that dune currently limits fetched file size to 4.19mb.

3/ it creates a map of the data and works with any column amount/names, simply map the columns you need to SQL. here i used:.SELECT row_map['time'] AS time., row_map['CapMrktEstUSD'] AS mcap.

2/ all you need for CSVs is to source like this:.FROM "query_5656621(csv='csv_link')". for TSVs, use:.FROM "query_5656621(tsv='tsv_link')".

Zohran Mamdani: He votes for activists, not you

1/ i made a simple query you can use to fetch CSVs and TSVs from @dune. as an example, here's a 3 lines query for ENA's market cap sourced from @coinmetrics

at current pace, % of ETH in ETFs will exceed BTC's in september. srcs:

5% of ETH supply is now in ETFs. src:

a record $3b ETH flowed into ETF last week. src:

same for ethereum ETFs

A new proposal from @CMSgov under @DrOz wants to add catheters, ostomy & trach supplies to Medicare’s competitive bidding program. This is a bad idea and will worsen outcomes for seniors & Medicare recipients. My latest in @MedPageToday explains why ⬇️

bitcoin ETFs went live 20 months ago and @BitwiseInvest remains the only issuer with proof of reserves. it would be cool to see more issuers embracing crypto's transparency benefits

RT @herd_eco: Making a crypto app is usually a whole song and dance, but it doesn't have to be that hard!. Today, we're releasing "Trails",….

RT @ethanyish: 1/8.📊 Just launched: a real-time dashboard to track Hyperliquid trading volumes, builder and referral metrics, profit & loss….

RT @mhonkasalo: USDe supply has grown from 5.31bn to 9.08bn (+70.9%) in just the past month.

RT @trent_vanepps: some blob TA 3 months post-Pectra. 1. there is clear demand for the additional resource supply, rough guess is saturatio….

It's almost time for some new faces to take the stage in our upcoming collab with Ensemble Stars!! Music. Which duo are you excited to see?. Collaboration starts September 4~

RT @_sophiagold_: 0/ L1 zkEVMs are coming soon to Ethereum mainnet. They will allow us to significantly scale the gas limit and enable nati….

RT @DefiIgnas: Bullish $ETH: L1 is scaling and users are coming back. - Ethereum active addresses are nearing ATH, exceeding DeFi summer l….

RT @0x_vcharles: If you haven’t already, check out @indexed_pod hosted by legends like @hildobby, @0xBoxer and @sui414 . They dive into mar….