Avalanche L1 Data

This listing provides the full historical blockchain activity by block, transaction, event logs, etc. for several Avalanche L1 blockchains.

Blockchain analysts can uses these tables to explore gaming activity, and NFT trading on Gunzilla and DeFi Kingdoms; or investigate trading activity on the Dexalot exchange.

These datasets allow analysts to assess the historical demand for blockspace for each blockchain, evaluate the gas token expenditure, and study activity on each L1.

A data_dictionary table is provided for more detailed column descriptions. The respective L1 tables can be joined to each other based on specific identifiers, e.g. block_hash and transaction_hash.

Sample Tables:

- gunzilla_transactions
- gunzilla_blocks
- dfk_receipts
- dexalot_transactions
- dexalot_logs
- ...

Sample Fields:

- blockhash
- blocknumber
- blocktimestamp
- transactionhash
- transactionfrom
- transactionto
- transactioninput
- transactioncost
- logaddress
- topichex_0
- partition_date

原始信息汇总

Avalanche L1 Data 数据集概述

数据集基本信息

• 提供商: Ava Labs, Inc.
• 费用: 免费
• 访问权限: 无限制
• 刷新频率: 每日
• 云区域可用性:
  • AWS:
    • US East (N. Virginia)
    • US East (Ohio)

数据集描述

• 该数据集提供了多个Avalanche L1区块链的完整历史区块链活动，包括区块、交易、事件日志等。
• 区块链分析师可以使用这些表格探索Gunzilla和DeFi Kingdoms上的游戏活动和NFT交易，或研究Dexalot交易所的交易活动。
• 数据集允许分析师评估每个区块链的历史区块空间需求、gas代币支出以及每个L1上的活动。

数据表样例

• gunzilla_transactions
• gunzilla_blocks
• dfk_receipts
• dexalot_transactions
• dexalot_logs

数据字段样例

• blockhash
• blocknumber
• blocktimestamp
• transactionhash
• transactionfrom
• transactionto
• transactioninput
• transactioncost
• logaddress
• topichex_0
• partition_date

业务需求

区块链分析

• 计算每个L1在区块或交易级别上支付的gas费用。
• 调查这些L1的历史活动，识别大量交易活动的时期。
• 识别与各自L1区块链交互的唯一钱包地址数量。

数据字典

• 表名: DATA_DICTIONARY
• 描述: 包含该数据列表中表格的列描述。
• 列名:
  • TABLE_NAME
  • TABLE_DESCRIPTION
  • COLUMN_NAME
  • COLUMN_TYPE
  • COLUMN_DESCRIPTION
  • ORDINAL_POSITION

使用示例

Gunzilla地址按月发起交易

sql select date_trunc(month,cast(blocktimestamp as timestamp)) as month, count(distinct transactionfrom) as initiating_addresses from layerone.gunzilla_transactions group by 1 order by 1 desc

其他信息

• 类别: 分析工具, 区块链分析
• 联系方式:
  • 销售: [e-mail]
  • 支持: [e-mail]