Description of the zksync.transactions table on Dune
The zksync.transactions
table contains information about all transactions on the zksync blockchain. Each row represents a single transaction and includes information such as block number, hash, timestamp, sender, recipient, value, gas, gas price, and more. Transactions are the fundamental unit of interaction with the zksync blockchain. Transactions are created by users and are used to send value, deploy smart contracts, and interact with smart contracts.
SELECT *
FROM zksync.transactions WHERE "from" = '0x50A1b5c358F8D34F0d35aA2f10742c46054E247e'
SELECT
block_number,
COUNT(*)
FROM zksync.transactions
GROUP BY 1
ORDER BY 1 DESC
LIMIT 10
SELECT
hash,
gas_price
FROM zksync.transactions
ORDER BY gas_price DESC
LIMIT 10
Description of the zksync.transactions table on Dune
The zksync.transactions
table contains information about all transactions on the zksync blockchain. Each row represents a single transaction and includes information such as block number, hash, timestamp, sender, recipient, value, gas, gas price, and more. Transactions are the fundamental unit of interaction with the zksync blockchain. Transactions are created by users and are used to send value, deploy smart contracts, and interact with smart contracts.
SELECT *
FROM zksync.transactions WHERE "from" = '0x50A1b5c358F8D34F0d35aA2f10742c46054E247e'
SELECT
block_number,
COUNT(*)
FROM zksync.transactions
GROUP BY 1
ORDER BY 1 DESC
LIMIT 10
SELECT
hash,
gas_price
FROM zksync.transactions
ORDER BY gas_price DESC
LIMIT 10