The avatar for @adityawarmanfw
Fidocia Wima Adityawarman
Product, analytics, viz. Product analyst @ShowwcaseHQ.
Published
Blockchain Analytics: Ghozali Everyday
Edited
Mar 4, 2022
3
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
db.describe()
Insert cell
db.describe("ghozaliEverydayTransfer20220221")
Insert cell
Insert cell
viewof tableGhozaliEverydayTransfer = Inputs.table(ghozaliEverydayTransfer, {})
Insert cell
Insert cell
viewof table = Inputs.table(owners, {})
Insert cell
owners = db.query(`
WITH latest_block AS (
SELECT token_id, MAX(block_timestamp) AS block_timestamp
FROM ghozaliEverydayTransfer20220221
GROUP BY 1
)
SELECT trf_to AS address,
COUNT(DISTINCT token_id) AS nfts
FROM ghozaliEverydayTransfer20220221
JOIN latest_block USING (block_timestamp, token_id)
GROUP BY 1 ORDER BY 2 DESC
`)
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
dbClient.describe()
Insert cell
FileAttachment("bquxjob_25997e28_17f2b7a6067.csv").csv()
Insert cell
import {DuckDBClient} from '@cmudig/duckdb'
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more