Description of the avalanche_c.transactions table on Dune
The avalanche_c.transactions
table contains information about all transactions on the avalanche_c 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 avalanche_c blockchain. Transactions are created by users and are used to send value, deploy smart contracts, and interact with smart contracts.
SELECT *
FROM avalanche_c.transactions WHERE "from" = '0x50A1b5c358F8D34F0d35aA2f10742c46054E247e'
SELECT
block_number,
COUNT(*)
FROM avalanche_c.transactions
GROUP BY 1
ORDER BY 1 DESC
LIMIT 10
SELECT
hash,
gas_price
FROM avalanche_c.transactions
ORDER BY gas_price DESC
LIMIT 10
Description of the avalanche_c.transactions table on Dune
The avalanche_c.transactions
table contains information about all transactions on the avalanche_c 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 avalanche_c blockchain. Transactions are created by users and are used to send value, deploy smart contracts, and interact with smart contracts.
SELECT *
FROM avalanche_c.transactions WHERE "from" = '0x50A1b5c358F8D34F0d35aA2f10742c46054E247e'
SELECT
block_number,
COUNT(*)
FROM avalanche_c.transactions
GROUP BY 1
ORDER BY 1 DESC
LIMIT 10
SELECT
hash,
gas_price
FROM avalanche_c.transactions
ORDER BY gas_price DESC
LIMIT 10