---
title: "Get Funding Amount Report File"
method: GET
path: "/v1/fundingamountreport/records.xlsx"
tags: ["Market Data"]
---

# Get Funding Amount Report File

`GET /v1/fundingamountreport/records.xlsx`

## Request

- Base URL: `https://api.gemini.com`
- URL: `https://api.gemini.com/v1/fundingamountreport/records.xlsx`
- Auth: none declared

### Examples
- `symbol=BTCGUSDPERP&fromDate=2024-04-10&toDate=2024-04-25&numRows=1000` </br>
Compare and obtain the minimum records between (2024-04-10 to 2024-04-25) and 1000. If (2024-04-10 to 2024-04-25) contains 360 records. Then fetch the minimum between 360 and 1000 records only.

- `symbol=BTCGUSDPERP&numRows=2024-04-10&toDate=2024-04-25` </br>
If (2024-04-10 to 2024-04-25) contains 360 records. Then fetch 360 records only.

- `symbol=BTCGUSDPERP&numRows=1000` </br>
Fetch maximum 1000 records starting from Now to a historical date

- `symbol=BTCGUSDPERP` </br>
Fetch maximum 8760 records starting from Now to a historical date

## Query parameters

- `symbol` string, required
- `fromDate` string, date
- `toDate` string, date
- `numRows` integer

## Response `200`

The response will be an excel / csv file. filename=FundingAmount_{SYMBOL}.{xlsx,csv}

## Other responses

- `400`: Bad request - malformed request or invalid parameters
- `404`: Resource not found
- `429`: Too many requests - you have exceeded the rate limit
- `500`: Internal server error

---

[API](https://skmtc.dev/gemini/apis/rest-api.md) - [All operations](https://skmtc.dev/gemini/apis/rest-api/llms.txt) - [OpenAPI document](https://skmtc.dev/gemini/apis/rest-api/revisions/24979792d748?raw)