How many Tx on Ethereum?

daniel_onchainHow many Tx on Ethereum?

Updated 2024-08-29

--select

--platform_name,

--count(*) as sales_count

--from ethereum.nft.ez_nft_sales

--where block_timestamp > current_date - interval '30 days'

--group by platform_name

--order by sales_count desc

--limit 8

------------------------------------

--SELECT *

--from ethereum.core.fact_transactions

--where block_timestamp :: DATE = '2024-01-01'

--Limit 100

----------------------------------------------------------

--SELECT tx_hash

--from ethereum.core.fact_transactions

--where block_timestamp :: DATE = '2024-01-01'

--Limit 100

---------------------------------------------------------------------------

--SELECT COUNT(tx_hash)

--from ethereum.core.fact_transactions

--where block_timestamp :: DATE = '2024-01-01'

-----------------------------------------------------

--SELECT COUNT(tx_hash), COUNT(distinct tx_hash)

--from ethereum.core.fact_transactions

--where block_timestamp :: DATE = '2024-01-0'

--------------------------------------------------------------

--SELECT

--block_timestamp :: DATE as date,

QueryRunArchived: QueryRun has been archived

flipside