This repo is a source for anyone looking to construct user metrics or scores for blockchain users. User metrics are grouped into six categories:
- General Activity
- DeFi
- Governance
- NFTs
- Bags
- Airdrops
Each of these categories contain standard metrics that are applied across chains to the extent that metric is applicable to the given blockchain.
This repo contains user metric SQL queries for the following blockchains:
- Algorand
- Axelar
- Cosmos
- Ethereum
- Flow
- NEAR
- Osmosis
- Solana
Additional blockchains will be supported in the future as their data is ingested into the Flipside Crypto data warehouses.
The main folder of this repo contains two primary folders, sql and apps. The sql folder contains queries used to power applications and has the following folder structure:
SQL Folder Structure:
category
chain
metric
metric_name.sql chain metric metric_name.sql
Apps Folder Structure:
chain
www