Dataset: Portals.fi Crypto Tokens

About this Dataset

Portals.fi Crypto Tokens

This dataset provides detailed information about cryptocurrency tokens sourced from the Portals.fi API, which aggregates data across multiple blockchain networks and DeFi protocols. It serves as a rich resource for researchers, developers, and analysts in the cryptocurrency and decentralized finance (DeFi) space.

Key Features

1. Token Identification

Unique identifiers for each token, including keys that combine network and token addresses.
Platform and network information, such as Ethereum, Polygon, and Arbitrum.

2. Token Metadata

Token names, symbols, and decimals for standardization.
Addresses for tokens across supported networks.

3. Pricing and Liquidity

Current token prices in USD.
Liquidity metrics for tokens in various pools and protocols.

4. Market Metrics

APY (Annual Percentage Yield) and base APY for tokens in pools.
Daily and weekly trading volumes in USD.

5. Pool-Specific Data

Reserve balances for each token in liquidity pools.
Total supply of tokens in pools.

6. Visual Representations

URLs for token and pool-related images for visualization in dashboards and applications.

7. Timestamps

Creation and last updated timestamps for all token entries.

Use Cases

DeFi Protocol Analysis: Analyze liquidity, trading volumes, and yields for tokens across different blockchain networks.
Portfolio Management: Track token prices and pool reserves to optimize crypto investments.
Market Research: Gain insights into the most active tokens and pools in the DeFi ecosystem.
Application Development: Integrate rich token data into blockchain analytics tools, trading platforms, or DeFi applications.

Tables

Token Data

@portals.tokens.tokens

16.32 GB
60015658 rows
86 columns


CREATE TABLE tokens (
  "key" VARCHAR,
  "name" VARCHAR,
  "decimals" INTEGER,
  "symbol" VARCHAR,
  "price" DOUBLE,
  "address" VARCHAR,
  "platform" VARCHAR,
  "network" VARCHAR,
  "updatedat" TIMESTAMP,
  "createdat" TIMESTAMP,
  "tokens" VARCHAR,
  "liquidity" DOUBLE,
  "image" VARCHAR,
  "tokenid" VARCHAR,
  "totalsupply" DOUBLE,
  "circulatingsupply" VARCHAR,
  "addresses_bsc" VARCHAR,
  "metrics_volumeusd1d" DOUBLE,
  "addresses_ethereum" VARCHAR,
  "addresses_avalanche" VARCHAR,
  "addresses_base" VARCHAR,
  "addresses_optimism" VARCHAR,
  "addresses_arbitrum" VARCHAR,
  "addresses_polygon" VARCHAR,
  "addresses_gnosis" VARCHAR,
  "images" VARCHAR,
  "pooladdress" VARCHAR,
  "metrics_apy" DOUBLE,
  "metrics_baseapy" DOUBLE,
  "metrics_volumeusd7d" DOUBLE,
  "metadata_tags" VARCHAR,
  "reserves" VARCHAR,
  "metadata_poolid" VARCHAR,
  "metadata_weights" VARCHAR,
  "metadata_pooltype" VARCHAR,
  "metadata_feepercentage" VARCHAR,
  "metadata_pooltypeversion" DOUBLE,
  "metadata_protocolversion" DOUBLE,
  "metadata_amp" VARCHAR,
  "metadata_ismetapool" VARCHAR,
  "metadata_implementation" VARCHAR,
  "metadata_offpegfeemultiplier" VARCHAR,
  "metadata_implementationaddress" VARCHAR,
  "metadata_amplificationcoefficient" VARCHAR,
  "addresses_sonic" VARCHAR,
  "addresses_mode" VARCHAR,
  "metrics_stakedapy" DOUBLE,
  "metadata_isstable" VARCHAR,
  "metadata_d" VARCHAR,
  "metadata_gamma" VARCHAR,
  "metadata_futureagamma" VARCHAR,
  "metadata_initialagamma" VARCHAR,
  "metadata_futureagammatime" VARCHAR,
  "metadata_midfeepercentage" VARCHAR,
  "metadata_outfeepercentage" VARCHAR,
  "metadata_initialagammatime" VARCHAR,
  "metadata_feegammapercentage" VARCHAR,
  "pricepershare" DOUBLE,
  "addresses_fraxtal" VARCHAR,
  "metadata_c" VARCHAR,
  "metadata_s" VARCHAR,
  "metadata_u" VARCHAR,
  "metadata_v" VARCHAR,
  "metadata_w" VARCHAR,
  "metadata_z" VARCHAR,
  "metadata_dsq" VARCHAR,
  "metadata_beta" VARCHAR,
  "metadata_alpha" VARCHAR,
  "metadata_lambda" VARCHAR,
  "metadata_sqrtbeta" VARCHAR,
  "metadata_taubetax" VARCHAR,
  "metadata_taubetay" VARCHAR,
  "metadata_sqrtalpha" VARCHAR,
  "metadata_taualphax" VARCHAR,
  "metadata_taualphay" VARCHAR,
  "metadata_root3alpha" VARCHAR,
  "metadata_marketaddress" VARCHAR,
  "metadata_description" VARCHAR,
  "metadata_isiporvault" VARCHAR,
  "metadata_redemptionvault" VARCHAR,
  "metadata_expiry" DOUBLE,
  "metadata_expired" VARCHAR,
  "year" INTEGER,
  "month" INTEGER,
  "day" INTEGER,
  "hour" INTEGER
);