Examples

Scenario inform...

Related scenari...

Resources

>  Get daily Historical BTC Spreads By Trade Lot Size for Coinbase including block, round lot, small or odd lot, average spread across sizes and the ratio of spread for small or odd lot vs block size trades

[![button](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/scenarios/try-it-now.png)](https://app.cryptosheets.com/#/browse/Paradigm/Historical%20Spread?scenarioId=422)

**Tags:** `spreads,liquidity,depth,resilience,otc,breadth,transaction cost,hui-heuble`

![IMG](https://res.cloudinary.com/cryptosheets/image/upload/l_logos:paradigm-300x300,w_0.2,fl_relative,co_black,e_shadow:90,c_thumb,g_north_east,x_25,y_25,o_90/l_text:twitter.otf_125:Coinbase%20Historical%20BTC%20Spreads%20By%20Trade%20Lot%20Size,co_rgb:006630,e_shadow:40,c_fit,g_west,x_100,h_400,w_1300,g_south_west,x_25,y_250,g_north_west,x_25,y_150/l_text:twitter.otf_60_light:Get%20daily%20Historical%20BTC%20Spreads%20By%20Trade%20Lot%20Size%20for%20Coinbase%20including%20block%20round%20lot%20small%20or%20odd%20lot%20average%20spread%20across%20sizes%20and%20the%20ratio%20of%20spread%20for%20small%20or%20odd%20lot%20vs%20block%20size%20trades,co_black,c_fit,g_west,x_100,h_400,w_1500,g_south_west,x_25,y_50/twitter/twitter-base-scenario4.png)


### Examples

Try the click + copy + paste spreadsheet formulas below: 

**Excel:**

<inline-code functionvalue='=CS.QUERY("Paradigm","Historical Spread",{"_limit","500";"_fields","DatetimeUTC,Coinbase Block,Coinbase Round Lot,Coinbase Small Lot,Coinbase Avg,Coinbase Small/Block Ratio";"_formatDates","MM-DD-YYYY"})'> =CS.QUERY("Paradigm","Historical Spread",{"_limit","500";"_fields","DatetimeUTC,Coinbase Block,Coinbase Round Lot,Coinbase Small Lot,Coinbase Avg,Coinbase Small/Block Ratio";"_formatDates","MM-DD-YYYY"})</inline-code>

**Google Sheets:**

<inline-code functionvalue='=CSQUERY("Paradigm","Historical Spread",{"_limit","500";"_fields","DatetimeUTC,Coinbase Block,Coinbase Round Lot,Coinbase Small Lot,Coinbase Avg,Coinbase Small/Block Ratio";"_formatDates","MM-DD-YYYY"})'> =CSQUERY("Paradigm","Historical Spread",{"_limit","500";"_fields","DatetimeUTC,Coinbase Block,Coinbase Round Lot,Coinbase Small Lot,Coinbase Avg,Coinbase Small/Block Ratio";"_formatDates","MM-DD-YYYY"})</inline-code>




### Scenario information

**Provider:** [Paradigm](https://app.cryptosheets.com/#/browse/Paradigm) **Endpoint:** [Historical Spread](https://docs.cryptosheets.com/providers/paradigm) 

**Category:** `historical` **Type:** `liquidity`

**Last Updated:** 2020-11-17 12:09:34.2130000 | **ScenarioId:** 422 | **Parameters:** 3

### Related scenarios & content

  - Browse all of our scenarios **[WebApp](https://app.cryptosheets.com/#/browse)**  |  **[Docs Portal](https://docs.cryptosheets.com/scenarios/)**
  - Browse other endpoints from [Paradigm](https://app.cryptosheets.com/#/browse/Paradigm) **[WebApp](https://app.cryptosheets.com/#/browse/Paradigm)**  |  **[Docs Portal](https://docs.cryptosheets.com/providers/paradigm)**

### Resources

Cryptosheets scenarios are dynamic combinations of pre-configured queries, transformations and filters easily searchable & accessible with one click. Scenarios are a gamechanger for the way you access and use crypto data inside a spreadsheet. Start saving time today and explore our tutorials, examples  & other resources below.

- [**How to use Cryptosheets Scenarios**](https://medium.com/cryptosheets/introducing-cryptosheets-scenarios-6a69d9e19886)
- [**Help Center**](https://intercom.help/cryptosheets/en/)
- [**Scenario Guides**](https://intercom.help/cryptosheets/en/articles/4571225-how-to-use-cryptosheets-scenarios)
- [**Scenario Tutorial Blog**](https://medium.com/cryptosheets/introducing-cryptosheets-scenarios-6a69d9e19886)
- [**Scenario YouTube Examples**](https://www.youtube.com/channel/UCReKkrBSlgKgNJlWHLASiPQ)

Example tutorials for using the Coinbase Historical BTC Spreads By Trade Lot Size spreadsheet scenario in Excel and Google Sheets