Dataset: Portals.fi Token Transactions

About this Dataset

Portals.fi Token Transactions

This dataset provides detailed information about token transactions 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. Transaction Categories, each stored in its own table:

Deposits: Information about token deposits, including amounts, USD equivalent, transaction hash, and timestamp.
Swaps: Insights into token swaps, including input and output tokens, amounts, and corresponding transaction details.
Withdrawals: Detailed data about token amounts, USD value, transaction hash, and timestamp.

2. Token Identification

Tokens are identified using the [network]:[address] format.
- Example: ethereum:0x06325440D014e39736583c165C2963BA99fAf14E
Supports multiple blockchain networks, including Ethereum, Polygon, and others.

3. Request Parameters

id: Required parameter specifying the token in the [network]:[address] format.

4. Response Structure

The API response provides a comprehensive breakdown of transactions for the specified token:

Deposits and Withdrawals:
- key: Unique identifier for the token.
- symbol: Token symbol (e.g., steCRV).
- amount: Number of tokens involved in the transaction.
- amountUsd: USD value of the token amount.
- transactionHash: Unique hash for the transaction.
- time: Timestamp of the transaction in ISO 8601 format.
Swaps:
- inputAmount and outputAmount: Amount of input and output tokens.
- inputToken and outputToken: Identifiers for the input and output tokens.
- transactionHash: Unique hash for the swap transaction.
- time: Timestamp of the transaction in ISO 8601 format.

Use Cases

Transaction Tracking: Monitor token movements across supported blockchain networks.
Trading Pattern Analysis: Gain insights into trading volumes and swap activity.
Application Development: Integrate transaction data into DeFi tools or dashboards.
Market Research: Identify trends in token activity for portfolio optimization.

Tables

Token Deposits

@portals.transactions.deposits

3.62 MB
46546 rows
8 columns


CREATE TABLE deposits (
  "transactionhash" VARCHAR,
  "key" VARCHAR,
  "symbol" VARCHAR,
  "amount" DOUBLE,
  "time" TIMESTAMP,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT
);

Token Swaps

@portals.transactions.swaps

24.54 MB
275257 rows
9 columns


CREATE TABLE swaps (
  "inputamount" DOUBLE,
  "inputtoken" VARCHAR,
  "outputamount" DOUBLE,
  "outputtoken" VARCHAR,
  "transactionhash" VARCHAR,
  "time" TIMESTAMP,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT
);

Token Withdraws

@portals.transactions.withdraws

2.16 MB
27024 rows
8 columns


CREATE TABLE withdraws (
  "transactionhash" VARCHAR,
  "key" VARCHAR,
  "symbol" VARCHAR,
  "amount" DOUBLE,
  "time" TIMESTAMP,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT
);