Start free

Polygon.io connector · Market data reports

Read & reportRead-only source

Keep a daily price table for your watchlist without copying quotes.

Bring market data from Massive, formerly Polygon.io, into your reports and AI assistants: daily open, high, low, close, volume and VWAP for up to 20 tickers, ticker details such as exchange and market cap, and the previous close.

  • Keep daily closes and volume for your watchlist in a sheet
  • Compare peers or a benchmark over a month
  • Ask ChatGPT or Claude which ticker moved most this week
Polygon.ioSheetsData StudioChatGPTClaude

Start free Explore the data

Updated November 2026

Polygon.io reportSample data
TickerTrading dateClose price
AAPL2026-11-13228.41
MSFT2026-11-13431.07
SPY2026-11-13598.12
Refreshes on your schedule in Google Sheets

What Datapipe reads for your Polygon.io tickers

Your Massive account, formerly Polygon.io, and up to 20 tickers you list make the data source. Daily bars are trading days in Eastern Time; report dates are UTC days.

Daily price bars

Read open, high, low, close, volume, VWAP and number of trades for each ticker and trading day, adjusted for splits.

Ticker details

See each ticker’s name, market, exchange, type, currency, market cap and list date.

Previous close

Get the last trading day’s open, high, low, close and volume for every ticker.

Stocks, crypto and currencies

List stock tickers or prefixed symbols for crypto, currency pairs and indices your plan covers.

Report datasets and details

Reports you can build

3 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.

  • Daily price bars
  • Ticker details
  • Previous close
What each dataset reports
  • Daily price bars

    One row per ticker and trading day in the report dates: open, high, low, close, volume, volume-weighted average price and trade count, adjusted for splits.

  • Ticker details

    Current reference details for each ticker on this data source: name, market, exchange, type, currency, listing status, market cap and list date.

  • Previous close

    The most recent full trading day for each ticker on this data source: open, high, low, close, volume and volume-weighted average price.

Metrics and dimensions

27 report fields across 3 datasets.

Search the available fields. Hover or tap a field to see what it means.

Send Polygon.io data anywhere

Google SheetsGoogle SheetsA sheet that refreshes every morning.
Data StudioData StudioCharts that read the same numbers.
BigQueryBigQueryA warehouse table for the same columns.
ClickHouseClickHousePush rows into ClickHouse over HTTPS with an API key.
AWS S3AWS S3Write report files to your S3 bucket with IAM access keys.
Amazon RedshiftAmazon RedshiftLoad rows into Redshift via the Data API with IAM keys.
FireboltFireboltPush rows into Firebolt over HTTPS with a Service Account.
PostgreSQLPostgreSQLWrite report rows into PostgreSQL with database credentials.
MySQLMySQLWrite report rows into MySQL with database credentials.
SnowflakeSnowflakePush rows into Snowflake over HTTPS with a PAT token.
Databricks SQLDatabricks SQLLoad rows into Databricks SQL with a Personal Access Token.
Cloudflare R2Cloudflare R2Write report files to your R2 bucket with access keys.
Excel / CSVExcel / CSVA Drive file you can open in Excel.
ClaudeClaudeAdd Datapipe's MCP connector, then ask Claude in a sentence.
ChatGPTChatGPTAdd Datapipe's MCP connector, then ask ChatGPT in a sentence.
APIAPIRead the same rows from your own tool.
Don't see yours? Use CSV or APIDownload the rows, or read them from your own tool.

Connect Polygon.io to ChatGPT or Claude for market data questions

Through MCP, ChatGPT can line up daily closes and volume for your tickers and say which ones broke away from your benchmark this week.

Example

Which of my tickers rose or fell most against SPY over the last month?

Compare each ticker’s close at the start and end of the last month with SPY’s change over the same days, and rank tickers by the difference.

Set up the Polygon.io MCP connector

Datapipe is a hosted MCP server. Add it once as a custom connector in Claude, ChatGPT or Grok, and your assistant can work with Polygon.io alongside the other data sources in your project.

  1. Add Polygon.ioAdd it as a data source in Datapipe.
  2. Add the connectorPaste https://trydatapipe.com/mcp as a custom connector in your assistant.
  3. Sign inSign in to Datapipe and choose the project your assistant can use.

Daily open, high, low, close, volume and VWAP for your listed tickers, their exchange, type and market cap, and each ticker’s previous close. Polygon.io is read-only in Datapipe.

Start with Polygon.io

What you need

A Massive API key from API Keys in your Massive dashboard (formerly Polygon.io), and the ticker symbols you want, up to 20.

What to know

Read-only. How far back daily bars go depends on your Massive plan, and the free plan allows 5 requests a minute. Up to 20,000 rows per report.

How it works

  1. Copy your key from API Keys in the Massive dashboard, then add Polygon.io under Data sources.

  2. Paste your key and list up to 20 ticker symbols.

  3. Send daily closes for your watchlist to a sheet, or ask ChatGPT which ticker fell furthest this month.

Works well with Polygon.io

Add both to the same project. Each keeps its own report, so you can check them side by side or ask ChatGPT or Claude a question that needs both.

Questions

Daily price bars, ticker details with market cap, and the previous close for up to 20 tickers.

Yes. Polygon.io became Massive in 2025. Use the key from your Massive dashboard.

No. Reports use daily bars and the previous close.

Yes, with the prefixed symbols Massive uses, if your plan includes them.

Yes. Datapipe is a hosted MCP server that covers Polygon.io and the other data sources in your project. Add https://trydatapipe.com/mcp as a custom connector in Claude, ChatGPT or Grok, then sign in to Datapipe. Daily open, high, low, close, volume and VWAP for your listed tickers, their exchange, type and market cap, and each ticker’s previous close. Polygon.io is read-only in Datapipe.

Free to start. Paid plans add more data sources and refresh faster.

Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 data sources.

One for each Polygon.io account you add to a project. Adding the same account to another project counts again. Reports and destinations do not use extra data sources.

Keep your watchlist current.

Put daily closes next to your own targets and benchmarks without pasting quotes each morning.

Start free See setup requirements