# Disconnect between daily and minute-bar data returned via v2/stocks/bars

**URL:** <https://forum.alpaca.markets/t/disconnect-between-daily-and-minute-bar-data-returned-via-v2-stocks-bars/16605>\
**Category:** Alpaca Market Data\
**Created:** [March 28, 2025, 10:13pm UTC](https://forum.alpaca.markets/t/disconnect-between-daily-and-minute-bar-data-returned-via-v2-stocks-bars/16605 "2025-03-28T22:13:17Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![largess21](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.alpaca.markets/largess21/32/7015_2.png) [@largess21](https://forum.alpaca.markets/u/largess21)\
**Post date:** [March 28, 2025, 10:13pm UTC](https://forum.alpaca.markets/t/disconnect-between-daily-and-minute-bar-data-returned-via-v2-stocks-bars/16605/1 "2025-03-28T22:13:17Z")

</div>

Attempting to compare daily ohlc data to the same for minute bars on a single day for ticker SPY. Would expect some portion of the two to overlap (ie, open for daily to match open for 0930ET bar) but not able to reconcile.

Running these API calls:  
**(1min):**  
import requests

url = “[https://data.alpaca.markets/v2/stocks/SPY/bars?timeframe=1Min&start=2022-01-31&end=2022-01-31&limit=10000&adjustment=split&feed=sip&sort=asc](https://data.alpaca.markets/v2/stocks/SPY/bars?timeframe=1Min&start=2022-01-31&end=2022-01-31&limit=10000&adjustment=split&feed=sip&sort=asc)”

headers = {  
“accept”: “application/json”,  
“APCA-API-KEY-ID”:  
“APCA-API-SECRET-KEY”:  
}

response = requests.get(url, headers=headers)

**(1day):**  
import requests

url = “[https://data.alpaca.markets/v2/stocks/SPY/bars?timeframe=1Day&start=2022-01-31&end=2022-01-31&limit=10000&adjustment=split&feed=sip&sort=asc](https://data.alpaca.markets/v2/stocks/SPY/bars?timeframe=1Day&start=2022-01-31&end=2022-01-31&limit=10000&adjustment=split&feed=sip&sort=asc)”

headers = {  
“accept”: “application/json”,  
“APCA-API-KEY-ID”:  
“APCA-API-SECRET-KEY”:  
}

response = requests.get(url, headers=headers)

I don’t see the daily open price (441.24) returned anywhere by the 1min API call that would seem related, and the place I’d expect it (ie, 09:30+/-) there appear to be missing bars (I presumed due to no trading reported, but that seems unlikely for SPY at market open).

Can anyone explain why that is?

---

<div class="post-metadata">

**Author:** ![sarahvignale](https://avatars.discourse-cdn.com/v4/letter/s/8e8cbc/32.png) [@sarahvignale](https://forum.alpaca.markets/u/sarahvignale)\
**Post date:** [March 29, 2025, 8:58am UTC](https://forum.alpaca.markets/t/disconnect-between-daily-and-minute-bar-data-returned-via-v2-stocks-bars/16605/2 "2025-03-29T08:58:59Z")

</div>

Are you on the free ‘Basic’ plan or ‘Algo trader plus’ plan? See [this](https://forum.alpaca.markets/t/limit-sell-order-not-executed-despite-being-below-bid/16604/2)

---

<div class="post-metadata">

**Author:** ![Gergely\_Alpaca](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.alpaca.markets/gergely_alpaca/32/3210_2.png) [@Gergely\_Alpaca](https://forum.alpaca.markets/u/Gergely_Alpaca)\
**Post date:** [March 31, 2025, 5:12am UTC](https://forum.alpaca.markets/t/disconnect-between-daily-and-minute-bar-data-returned-via-v2-stocks-bars/16605/3 "2025-03-31T05:12:28Z")

</div>

Hi 👋

I’m guessing you’re missing that the bar timestamps are in UTC timezone. This is the 09:30 (ET) = 14:30 (UTC) minute bar:

```auto
$ curl -s -H "APCA-API-KEY-ID: ${APCA_API_KEY_ID}" -H "APCA-API-SECRET-KEY: ${APCA_API_SECRET_KEY}" \
"https://data.alpaca.markets/v2/stocks/SPY/bars?timeframe=1Min&start=2022-01-31T14:30:00Z&limit=1" | jq .
{
  "bars": [
    {
      "c": 441.15,
      "h": 441.44,
      "l": 440.57,
      "n": 8047,
      "o": 441.24,
      "t": "2022-01-31T14:30:00Z",
      "v": 1283016,
      "vw": 441.132744
    }
  ],
  "next_page_token": "U1BZfE18MTY0MzYzOTQ2MDAwMDAwMDAwMA==",
  "symbol": "SPY"
}

```

As you expected, it’s open is $441.24.

Maybe it’s worth mentioning however, that this is not always neccessarily the case. Since the aggregating rules for minute and daily bars are different (see [this FAQ](https://docs.alpaca.markets/docs/market-data-faq#how-are-bars-aggregated) for details), it is very possible that the opening price of the 9:30 minute bar won’t match the daily bar’s.

---

<div class="post-metadata">

**Author:** ![largess21](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.alpaca.markets/largess21/32/7015_2.png) [@largess21](https://forum.alpaca.markets/u/largess21)\
**Post date:** [April 2, 2025, 12:01am UTC](https://forum.alpaca.markets/t/disconnect-between-daily-and-minute-bar-data-returned-via-v2-stocks-bars/16605/4 "2025-04-02T00:01:07Z")

</div>

ah, thanks for this…thought I’d dealt with this in my script but wasn’t working properly.

appreciate link to details