Halaman ini memberikan contoh kueri Blockchain Analytics untuk Fantom.
Lihat dokumentasi BigQuery untuk mengetahui petunjuk tentang cara menggunakan BigQuery.
Melihat blok yang diindeks paling awal dan terbaru
Di konsol Google Cloud , buka halaman BigQuery.
Kueri berikut dimuat ke dalam kolom Editor:
SELECT
MIN(block_number) AS `First block`,
MAX(block_number) AS `Newest block`,
COUNT(1) AS `Total number of blocks`
FROM
bigquery-public-data.goog_blockchain_fantom_opera_us.blocks;
Contoh hasil:
| Blok pertama | Blokir terbaru | Jumlah total blok |
|---|---|---|
| 0 | 68125012 | 68125013 |
10 wallet teratas berdasarkan jumlah transaksi
Di konsol Google Cloud , buka halaman BigQuery.
Kueri berikut dimuat ke dalam kolom Editor:
SELECT
from_address,
COUNT(*) AS num_transactions
FROM `bigquery-public-data.goog_blockchain_fantom_opera_us.transactions`
GROUP BY from_address
ORDER BY num_transactions DESC
LIMIT 10;
Contoh hasil
| Alamat "Dari" | Jumlah Transaksi |
|---|---|
| 0xe93685f3bba03016f02bd1828badd6195988d950 | 2278761 |
| 0xb8ff877ed78ba520ece21b1de7843a8a57ca47cb | 1607685 |
| 0x88888846b627c2405c4b8963e45d731b7cdda406 | 1585298 |
| 0x26cf0b614df78bc4ec744f3703a9337a651acf74 | 1375400 |
| 0xebf4fbb9c81b84dd5cf89bc75588e5d0018501b3 | 1306694 |
| 0x9d945d909ca91937d19563e30bb4dac12c860189 | 847169 |
| 0x70ecc7fecaea8d67e820035ed48c53706e7f2079 | 830320 |
| 0x657439ed989b0ec28a09b592fda8c61ebd434b6a | 806376 |
| 0x9d7593003c0d48014a38be07ca8c312e6d32f17d | 804562 |
| 0xd968665350a0bb7d487aadba94d920d8890ee06f | 804225 |