ãªã³ãã§ãŒã³åæãšã¯
ðãªã³ãã§ãŒã³ã®åæ, çžå Žã®éèŠã®æµãããã¯ããªèŠç¹ããåæãã.
ðãããã¯ãã§ãŒã³ã誰ã§ãã¢ã¯ã»ã¹ã§ããå ¬éããŒã¿ããŒã¹ã ãšããããã®ãã§ãŒã³ã®åæããã話é¡.
ãªã³ãã§ãŒã³ããŒã¿
- ååŒæããŒã¿
- ãããã¯ãŒã¯ããŒã¿
- ãã€ããŒã®ããŒã¿
Services
ðThe Graph
GraphQLãªãšãããç¹åŸŽã®ãµãŒãã¹.
Bitquery
ããã°å人åãã§ã¯ãªã.
ðScopescapn
Scopescapn(0xWatchers), VC fundã®ãªã³ãã§ãŒã³åæ, web3ã§ã®å€§å£æ³šææ€åº.
ðBigQuery Public CryptoCurrency Data
ðGoogle Cloud BigQueryã䜿ã£ããã§ãŒã³ã®ãªã¢ã«ã¿ã€ã åæå¯èœ.
BigQueryã§ã¯ãšãªäžæã§29äžå溶ããããã©å©ãã£ã人ã®é¡ | Futurismo, æ»ã«ãŸããðŒ
- Bitcoin
- Ethereum
- Solana: Solana Blockchain (Community Dataset)
åæãã¥ãŒããªã¢ã«
- The fastest way to learn SQL with Bitcoin data on a live database from Google - Part 1 | by Rif Kiamil | Google Cloud - Community | Medium
- The fastest way to learn SQL with Bitcoin data on a live database from Google â Part 2 | by Rif Kiamil | Google Cloud - Community | Medium
- Ethereum in BigQuery: a Public Dataset for smart contract analytics | Google Cloud Blog
- BigQueryã®ãããã¯ãã§ãŒã³äžè¬å ¬éããŒã¿ã»ããã䜿ã #ããŒã¿åæ - Qiita
ãã¬ãŒãã³ã°ã³ãŒã¹
- Introducing six new cryptocurrencies in BigQuery Public Datasetsâand how to analyze them | Google Cloud Blog
- Tracking Cryptocurrency Exchange Trades with Google Cloud Platform in Real-Time | Google Cloud Skills Boost
Solana Blockchain Datasets
Solana Blockchain (Community Dataset)
- ãµã³ãã«ã®ãªã³ã¯ãã¯ãªãã¯ãããšãµã³ãã«ã¯ãšãªã衚瀺ããã.
- dataset: bigquery-public-data.crypto_solana_mainnet_us
- ããŒã¿ã®è©³çްã確èªããã«ã¯ãããŒã¿ã»ããã衚瀺ã.
- ããŒãã«ãéžæ(bigquery-public-data.crypto_solana_mainnet_us.Transactions)
- ã¹ããŒã: ã«ã©ã åã衚瀺
- ãã¬ãã¥ãŒ: ãµã³ãã«ããŒã¿è¡šç€º
- monthlyã®ããŒãã£ã·ã§ã³åå²ããŒãã«, block_timestamp
- Google CloudæäŸã®ããŒã¿åæãµãŒãã¹ãBigQueryãã11ã®ãããã¯ãã§ãŒã³è¿œå | ãããããçµæž
- Solanaã®ããŒã¿ãGoogle Cloud BigQueryã§çšŒåéå§ïœSolana Japan
-
Transactions
- block_slot
- block_hash
- block_timestamp
- recent_block_hash
- signature
- index
- fee
- status
- err
- compute_units_consumed
- accounts
- log_messages
- balance_changes
- pre_token_balances
- post_token_balances
Blockchain ETL
BigQueryã¯OSSã®Blockchain ETLãå©çšããŠãã.
- https://github.com/blockchain-etl
- Ethereum in BigQuery: âhow we built this dataset | Google Cloud Blog
ðflipside
ãã¬ãŒãã£ã³ã°ããã·ã¥ããŒã.
References
- ãªã³ãã§ãŒã³åæå ¥éïœã²ãã£ãïœnote
- ãä»®æ³é貚ããªã³ãã§ãŒã³åæ Cryptoquant & @ki_young_juãonChain AnalysisãïœãŠã
- L1ãåæããããã®ãã¬ãŒã ã¯ãŒã¯ - vitaâs Newsletter
- https://twitter.com/0xShini_/status/1663220407326085121
- 䟿å©ããŒã«ã®ç޹ä»ã¹ã¬ãã, 2023/05