PREVIEW / stock_5min / 2006-11-06
file: by_date/stock_5min/2006/2006-11-06.parquet size: 3.2 MB rows: 237,743 symbols: 2,433
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2006-11-06 07:00:00 | AAPL | Stock | 2.81 | 2.81 | 2.81 | 2.81 | 14000.0 |
| 2006-11-06 07:15:00 | AAPL | Stock | 2.8054 | 2.8054 | 2.8054 | 2.8054 | 2800.0 |
| 2006-11-06 07:30:00 | AAPL | Stock | 2.815 | 2.815 | 2.815 | 2.815 | 50960.0 |
| 2006-11-06 08:00:00 | AAPL | Stock | 2.8157 | 2.8161 | 2.81 | 2.8161 | 201040.0 |
| 2006-11-06 08:05:00 | AAPL | Stock | 2.8154 | 2.8154 | 2.8125 | 2.8125 | 52640.0 |
| 2006-11-06 08:10:00 | AAPL | Stock | 2.8107 | 2.8136 | 2.8107 | 2.8136 | 93856.0 |
| 2006-11-06 08:15:00 | AAPL | Stock | 2.8143 | 2.8246 | 2.8143 | 2.8246 | 135800.0 |
| 2006-11-06 08:20:00 | AAPL | Stock | 2.8239 | 2.8271 | 2.8239 | 2.8268 | 254828.0 |
| 2006-11-06 08:25:00 | AAPL | Stock | 2.8214 | 2.8268 | 2.8182 | 2.8264 | 241976.0 |
| 2006-11-06 08:30:00 | AAPL | Stock | 2.8218 | 2.825 | 2.8121 | 2.825 | 275912.0 |
| 2006-11-06 08:35:00 | AAPL | Stock | 2.8232 | 2.825 | 2.8221 | 2.8221 | 192752.0 |
| 2006-11-06 08:40:00 | AAPL | Stock | 2.8221 | 2.8221 | 2.8204 | 2.8204 | 50512.0 |
| 2006-11-06 08:45:00 | AAPL | Stock | 2.8196 | 2.8196 | 2.8193 | 2.8193 | 14000.0 |
| 2006-11-06 08:50:00 | AAPL | Stock | 2.8204 | 2.8214 | 2.8204 | 2.8214 | 115500.0 |
| 2006-11-06 08:55:00 | AAPL | Stock | 2.8189 | 2.8214 | 2.8182 | 2.8182 | 17500.0 |
| 2006-11-06 09:00:00 | AAPL | Stock | 2.8182 | 2.8182 | 2.8182 | 2.8182 | 28000.0 |
| 2006-11-06 09:05:00 | AAPL | Stock | 2.8182 | 2.8182 | 2.8179 | 2.8179 | 14000.0 |
| 2006-11-06 09:10:00 | AAPL | Stock | 2.8182 | 2.8189 | 2.8182 | 2.8182 | 19936.0 |
| 2006-11-06 09:15:00 | AAPL | Stock | 2.8189 | 2.8196 | 2.8189 | 2.8196 | 16800.0 |
| 2006-11-06 09:20:00 | AAPL | Stock | 2.8214 | 2.8214 | 2.8214 | 2.8214 | 61880.0 |
| 2006-11-06 09:25:00 | AAPL | Stock | 2.8229 | 2.8232 | 2.8179 | 2.8186 | 282492.0 |
| 2006-11-06 09:30:00 | AAPL | Stock | 2.8196 | 2.8229 | 2.8043 | 2.8071 | 14563332.0 |
| 2006-11-06 09:35:00 | AAPL | Stock | 2.8068 | 2.8121 | 2.8011 | 2.8121 | 11851168.0 |
| 2006-11-06 09:40:00 | AAPL | Stock | 2.8114 | 2.8207 | 2.8089 | 2.815 | 10119900.0 |
| 2006-11-06 09:45:00 | AAPL | Stock | 2.8143 | 2.8264 | 2.8139 | 2.8261 | 10444700.0 |
| 2006-11-06 09:50:00 | AAPL | Stock | 2.8264 | 2.8307 | 2.8246 | 2.8282 | 14389088.0 |
| 2006-11-06 09:55:00 | AAPL | Stock | 2.8282 | 2.8304 | 2.8271 | 2.8279 | 7561764.0 |
| 2006-11-06 10:00:00 | AAPL | Stock | 2.8279 | 2.8404 | 2.8239 | 2.8404 | 16773036.0 |
| 2006-11-06 10:05:00 | AAPL | Stock | 2.8404 | 2.8532 | 2.84 | 2.8461 | 20998432.0 |
| 2006-11-06 10:10:00 | AAPL | Stock | 2.8461 | 2.8511 | 2.8439 | 2.85 | 12953304.0 |
| 2006-11-06 10:15:00 | AAPL | Stock | 2.8504 | 2.8554 | 2.8496 | 2.8529 | 10568404.0 |
| 2006-11-06 10:20:00 | AAPL | Stock | 2.8521 | 2.8536 | 2.8482 | 2.85 | 6845888.0 |
| 2006-11-06 10:25:00 | AAPL | Stock | 2.8504 | 2.8525 | 2.8468 | 2.8504 | 7525000.0 |
| 2006-11-06 10:30:00 | AAPL | Stock | 2.85 | 2.8518 | 2.8479 | 2.8511 | 3849804.0 |
| 2006-11-06 10:35:00 | AAPL | Stock | 2.8511 | 2.8525 | 2.8421 | 2.8446 | 8853376.0 |
| 2006-11-06 10:40:00 | AAPL | Stock | 2.8443 | 2.8493 | 2.8414 | 2.8493 | 5955936.0 |
| 2006-11-06 10:45:00 | AAPL | Stock | 2.8489 | 2.8561 | 2.8489 | 2.8554 | 8260672.0 |
| 2006-11-06 10:50:00 | AAPL | Stock | 2.8554 | 2.8568 | 2.8486 | 2.8486 | 10465728.0 |
| 2006-11-06 10:55:00 | AAPL | Stock | 2.8484 | 2.8511 | 2.8464 | 2.8471 | 5049128.0 |
| 2006-11-06 11:00:00 | AAPL | Stock | 2.8481 | 2.8489 | 2.8443 | 2.8474 | 3262028.0 |
| 2006-11-06 11:05:00 | AAPL | Stock | 2.8479 | 2.8482 | 2.8429 | 2.8446 | 3115336.0 |
| 2006-11-06 11:10:00 | AAPL | Stock | 2.8446 | 2.8461 | 2.8425 | 2.8429 | 2876440.0 |
| 2006-11-06 11:15:00 | AAPL | Stock | 2.8429 | 2.8471 | 2.8429 | 2.8471 | 3743488.0 |
| 2006-11-06 11:20:00 | AAPL | Stock | 2.8471 | 2.8518 | 2.8471 | 2.8514 | 3236828.0 |
| 2006-11-06 11:25:00 | AAPL | Stock | 2.8514 | 2.8557 | 2.85 | 2.8539 | 5161996.0 |
| 2006-11-06 11:30:00 | AAPL | Stock | 2.8539 | 2.855 | 2.8504 | 2.8532 | 3420816.0 |
| 2006-11-06 11:35:00 | AAPL | Stock | 2.8514 | 2.8518 | 2.8489 | 2.8504 | 2609068.0 |
| 2006-11-06 11:40:00 | AAPL | Stock | 2.8504 | 2.855 | 2.8489 | 2.855 | 3216500.0 |
| 2006-11-06 11:45:00 | AAPL | Stock | 2.855 | 2.8561 | 2.8521 | 2.8543 | 6604164.0 |
| 2006-11-06 11:50:00 | AAPL | Stock | 2.8543 | 2.8561 | 2.8507 | 2.8529 | 4079348.0 |
> showing 50 of 237,743 rows — these rows as CSV