I will provide an SQL query for Dune Analytics so that you can get the data you need.
Dune is a web-based platform that allows you to query public blockchain data and aggregate it into beautiful dashboards.
Supported blockchains:
- abstract
- apechain
- arbitrum
- avalanche_c
- b3
- base
- blast
- bnb
- bob
- celo
- corn
- degen
- ethereum
- fantom
- flare
- gnosis
- ink
- kaia
- linea
- mantle
- nova
- opbnb
- optimism
- polygon
- ronin
- berachain
- boba
- NEAR
- Solana
- Stellar
- starknet
- fuel
- aptos
- beacon
- polkadot
- ton
- tron
bitcoin
