Products
Docs
Company
The capture-server-received timestamp expressed as the number of nanoseconds since the UNIX epoch.
The book level where the update event occurred.
The matching-engine-received timestamp expressed as the number of nanoseconds since the UNIX epoch.
The order price expressed as a signed integer where every 1 unit corresponds to 1e-9, i.e. 1/1,000,000,000 or 0.000000001.
The record type. Each schema corresponds with a single rtype value.
The order quantity.
The publisher ID assigned by Databento, which denotes dataset and venue.
A bit field indicating event end, message characteristics, and data quality.
The numeric instrument ID.
The matching-engine-sending timestamp expressed as the number of nanoseconds before ts_recv.
The event action. Will always be Trade in the trades schema.
The message sequence number assigned at the venue.
The side that initiates the event. Can be Ask for a sell aggressor, Bid for a buy aggressor, or None where no side is specified by the original trade.
The requested symbol for the instrument.
ts_recv | ts_event | rtype | publisher_id | instrument_id | action | side | depth | price | size | flags | ts_in_delta | sequence | symbol |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2023-09-29T11:13:16.183203192Z | 2023-09-29T11:13:16.182973421Z | 0 | 45 | 15144 | T | N | 0 | 430.400000000 | 300 | 130 | 207798 | 5185 | SPY |
2023-09-29T12:00:00.252419677Z | 2023-09-29T12:00:00.250233946Z | 0 | 19 | 15144 | T | N | 0 | 430.770000000 | 1 | 128 | 207226 | 11478 | SPY |
2023-09-29T12:00:00.272419618Z | 2023-09-29T12:00:00.271540667Z | 0 | 19 | 15144 | T | N | 0 | 430.500000000 | 1 | 0 | 207294 | 11511 | SPY |
2023-09-29T12:00:00.272419618Z | 2023-09-29T12:00:00.272008631Z | 0 | 19 | 15144 | T | N | 0 | 430.480000000 | 10 | 130 | 207294 | 11513 | SPY |
2023-09-29T12:00:00.507428331Z | 2023-09-29T12:00:00.506441525Z | 0 | 19 | 15144 | T | N | 0 | 430.210000000 | 1 | 128 | 206961 | 11838 | SPY |
2023-09-29T12:00:00.612439310Z | 2023-09-29T12:00:00.610611128Z | 0 | 19 | 15144 | T | N | 0 | 429.970000000 | 5 | 128 | 207100 | 11993 | SPY |
2023-09-29T12:00:00.619938083Z | 2023-09-29T12:00:00.619502844Z | 0 | 19 | 15144 | T | N | 0 | 430.700000000 | 1 | 130 | 206635 | 12016 | SPY |
2023-09-29T12:00:00.652438329Z | 2023-09-29T12:00:00.651073115Z | 0 | 19 | 15144 | T | N | 0 | 430.740000000 | 1 | 128 | 206843 | 12059 | SPY |
2023-09-29T12:00:00.742438689Z | 2023-09-29T12:00:00.740030355Z | 0 | 19 | 15144 | T | N | 0 | 430.470000000 | 16 | 128 | 207265 | 12178 | SPY |
2023-09-29T12:00:00.762439746Z | 2023-09-29T12:00:00.760265216Z | 0 | 19 | 15144 | T | N | 0 | 430.540000000 | 4 | 128 | 208353 | 12301 | SPY |
2023-09-29T12:00:00.764938758Z | 2023-09-29T12:00:00.763170422Z | 0 | 19 | 15144 | T | N | 0 | 430.630000000 | 1 | 128 | 207340 | 12329 | SPY |
2023-09-29T12:00:00.769939332Z | 2023-09-29T12:00:00.768557378Z | 0 | 19 | 15144 | T | N | 0 | 430.700000000 | 1 | 128 | 207858 | 12362 | SPY |
2023-09-29T12:00:00.789941115Z | 2023-09-29T12:00:00.787518059Z | 0 | 19 | 15144 | T | N | 0 | 430.730000000 | 3 | 0 | 207765 | 12467 | SPY |
2023-09-29T12:00:00.789941115Z | 2023-09-29T12:00:00.787832826Z | 0 | 19 | 15144 | T | N | 0 | 430.600000000 | 14 | 128 | 207765 | 12469 | SPY |
2023-09-29T12:00:00.799940948Z | 2023-09-29T12:00:00.799320230Z | 0 | 19 | 15144 | T | N | 0 | 430.420000000 | 1 | 128 | 207581 | 12569 | SPY |
2023-09-29T12:00:00.807441510Z | 2023-09-29T12:00:00.806622998Z | 0 | 19 | 15144 | T | N | 0 | 430.320000000 | 1 | 128 | 208138 | 12614 | SPY |
2023-09-29T12:00:00.809941276Z | 2023-09-29T12:00:00.808302452Z | 0 | 19 | 15144 | T | N | 0 | 430.700000000 | 21 | 0 | 207761 | 12622 | SPY |
2023-09-29T12:00:00.809941276Z | 2023-09-29T12:00:00.808585331Z | 0 | 19 | 15144 | T | N | 0 | 430.690000000 | 30 | 0 | 207761 | 12624 | SPY |
2023-09-29T12:00:00.809941276Z | 2023-09-29T12:00:00.809067619Z | 0 | 19 | 15144 | T | N | 0 | 430.670000000 | 3 | 128 | 207761 | 12629 | SPY |
2023-09-29T12:00:00.812441141Z | 2023-09-29T12:00:00.809910113Z | 0 | 19 | 15144 | T | N | 0 | 430.350000000 | 1 | 128 | 207809 | 12634 | SPY |
Need to see more data for State Street SPDR S&P 500 ETF Trust? You can extract historical data and save it as a DBN, CSV, JSON, or Parquet file. Read our API guide ->
UTC