Ecosystem Analytics

Real-time on-chain transparency for the StrataFi ecosystem. Powered by Dune Analytics.

Contract: 0xdd73111b...88594fView on Explorer →

Pools Created

PoolCreatedEvent

Pool Creation Events

All pools created on the StrataFi protocol with their creation timestamps and details.

Investment Activity

InvestmentEvent

Tranche Subscriptions

Investment activity across Senior, Mezzanine, and Junior tranches.

⚠️ Using SQL fallback (may require Dune Plus)

Waterfall Distributions

DistributionEvent

Payment Priority

Tracks Senior → Mezzanine → Junior payment waterfall.

⚠️ Using SQL fallback (may require Dune Plus)

Oracle Attestations

AttestationEvent

Cashflow Attestations

Off-chain cashflow data attested by authorized oracles.

⚠️ Using SQL fallback (may require Dune Plus)

SQL Query Templates

Use these templates to create your own Dune queries. Each query is designed to parse the contract events emitted by the StrataFi modules.

Pools Created

SELECT 
  block_height,
  block_time,
  tx_version,
  json_extract_scalar("data", '$.pool_id') as pool_id,
  json_extract_scalar("data", '$.asset_crea...

Investments

SELECT 
  block_height,
  block_time,
  tx_version,
  json_extract_scalar("data", '$.pool_id') as pool_id,
  json_extract_scalar("data", '$.investor')...

Pool Securitization

SELECT 
  block_height,
  block_time,
  tx_version,
  json_extract_scalar("data", '$.pool_id') as pool_id,
  CAST(json_extract_scalar("data", '$.senio...

Distributions

SELECT 
  block_height,
  block_time,
  tx_version,
  json_extract_scalar("data", '$.pool_id') as pool_id,
  CAST(json_extract_scalar("data", '$.senio...

Oracle Attestations

SELECT 
  block_height,
  block_time,
  tx_version,
  json_extract_scalar("data", '$.pool_id') as pool_id,
  CAST(json_extract_scalar("data", '$.cash_...

Protocol Metrics

WITH pools AS (
  SELECT COUNT(*) as pool_count
  FROM aptos.events 
  WHERE block_time >= NOW() - INTERVAL '365' DAY
    AND (event_type = '0xdd73111...

All Events

SELECT 
  block_height,
  block_time,
  tx_version,
  event_type,
  json_extract_scalar("data", '$.pool_id') as pool_id
FROM aptos.events 
WHERE block...

Transparency Report

Access detailed audit logs and proof of reserves for all institutional grade pools.

View All Pools →

Developer API

Integrate StrataFi analytics directly into your application using our public API endpoints.

Dune API Docs →

Data is fetched directly from the Aptos blockchain and indexed via Dune Analytics. Standard delay is approximately 1-5 minutes depending on network finality.

Contract: 0xdd73111bf78e58b0aa650914cf21d5daaa0f8dce5783f164d0cb0ff5dd88594f