PREVIEW / stock_1min / 2010-03-08
file: by_date/stock_1min/2010/2010-03-08.parquet size: 12.6 MB rows: 948,070 symbols: 2,820
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-08 04:15:00 | AAPL | Stock | 7.8268 | 7.8268 | 7.8268 | 7.8268 | 2800.0 |
| 2010-03-08 04:16:00 | AAPL | Stock | 7.8279 | 7.8279 | 7.8279 | 7.8279 | 2800.0 |
| 2010-03-08 04:17:00 | AAPL | Stock | 7.8286 | 7.8286 | 7.8286 | 7.8286 | 2800.0 |
| 2010-03-08 04:21:00 | AAPL | Stock | 7.8339 | 7.8339 | 7.8339 | 7.8339 | 2800.0 |
| 2010-03-08 04:31:00 | AAPL | Stock | 7.8386 | 7.85 | 7.8386 | 7.85 | 5600.0 |
| 2010-03-08 04:43:00 | AAPL | Stock | 7.8539 | 7.8539 | 7.8539 | 7.8539 | 2800.0 |
| 2010-03-08 04:52:00 | AAPL | Stock | 7.8539 | 7.8539 | 7.8539 | 7.8539 | 5600.0 |
| 2010-03-08 05:15:00 | AAPL | Stock | 7.8411 | 7.8411 | 7.8411 | 7.8411 | 2800.0 |
| 2010-03-08 05:17:00 | AAPL | Stock | 7.8411 | 7.8411 | 7.8411 | 7.8411 | 2800.0 |
| 2010-03-08 05:25:00 | AAPL | Stock | 7.8464 | 7.8464 | 7.8464 | 7.8464 | 2800.0 |
| 2010-03-08 05:28:00 | AAPL | Stock | 7.8464 | 7.8464 | 7.8464 | 7.8464 | 2800.0 |
| 2010-03-08 07:02:00 | AAPL | Stock | 7.8329 | 7.8329 | 7.8329 | 7.8329 | 2800.0 |
| 2010-03-08 07:03:00 | AAPL | Stock | 7.8286 | 7.8286 | 7.8286 | 7.8286 | 5600.0 |
| 2010-03-08 07:04:00 | AAPL | Stock | 7.8282 | 7.8286 | 7.8243 | 7.8243 | 22540.0 |
| 2010-03-08 07:06:00 | AAPL | Stock | 7.8318 | 7.8318 | 7.8318 | 7.8318 | 8400.0 |
| 2010-03-08 07:14:00 | AAPL | Stock | 7.8393 | 7.8393 | 7.8393 | 7.8393 | 2800.0 |
| 2010-03-08 07:18:00 | AAPL | Stock | 7.8296 | 7.8296 | 7.8296 | 7.8296 | 5600.0 |
| 2010-03-08 07:25:00 | AAPL | Stock | 7.8368 | 7.8368 | 7.8368 | 7.8368 | 2800.0 |
| 2010-03-08 07:26:00 | AAPL | Stock | 7.8321 | 7.8321 | 7.8321 | 7.8321 | 2800.0 |
| 2010-03-08 07:27:00 | AAPL | Stock | 7.8375 | 7.8411 | 7.8375 | 7.8411 | 25200.0 |
| 2010-03-08 07:29:00 | AAPL | Stock | 7.8389 | 7.8389 | 7.8389 | 7.8389 | 2800.0 |
| 2010-03-08 07:31:00 | AAPL | Stock | 7.8425 | 7.8425 | 7.8425 | 7.8425 | 5600.0 |
| 2010-03-08 07:32:00 | AAPL | Stock | 7.8454 | 7.8454 | 7.8454 | 7.8454 | 5600.0 |
| 2010-03-08 07:33:00 | AAPL | Stock | 7.8375 | 7.8375 | 7.8375 | 7.8375 | 5600.0 |
| 2010-03-08 07:34:00 | AAPL | Stock | 7.8457 | 7.8457 | 7.8457 | 7.8457 | 2800.0 |
| 2010-03-08 07:35:00 | AAPL | Stock | 7.8389 | 7.8389 | 7.8375 | 7.8375 | 11200.0 |
| 2010-03-08 07:36:00 | AAPL | Stock | 7.8389 | 7.8393 | 7.8389 | 7.8393 | 27160.0 |
| 2010-03-08 07:38:00 | AAPL | Stock | 7.8393 | 7.8393 | 7.8393 | 7.8393 | 14840.0 |
| 2010-03-08 07:40:00 | AAPL | Stock | 7.8389 | 7.8393 | 7.8389 | 7.8393 | 13636.0 |
| 2010-03-08 07:41:00 | AAPL | Stock | 7.8396 | 7.8396 | 7.8389 | 7.8389 | 18004.0 |
| 2010-03-08 07:42:00 | AAPL | Stock | 7.8364 | 7.8393 | 7.8357 | 7.8393 | 27720.0 |
| 2010-03-08 07:44:00 | AAPL | Stock | 7.8393 | 7.8393 | 7.8393 | 7.8393 | 8400.0 |
| 2010-03-08 07:46:00 | AAPL | Stock | 7.8454 | 7.8454 | 7.8454 | 7.8454 | 2800.0 |
| 2010-03-08 07:48:00 | AAPL | Stock | 7.8464 | 7.8464 | 7.8464 | 7.8464 | 2800.0 |
| 2010-03-08 07:49:00 | AAPL | Stock | 7.8404 | 7.8404 | 7.8404 | 7.8404 | 11200.0 |
| 2010-03-08 07:50:00 | AAPL | Stock | 7.8393 | 7.8393 | 7.8393 | 7.8393 | 5600.0 |
| 2010-03-08 07:53:00 | AAPL | Stock | 7.8429 | 7.8461 | 7.8429 | 7.8461 | 42700.0 |
| 2010-03-08 07:54:00 | AAPL | Stock | 7.8446 | 7.8446 | 7.8446 | 7.8446 | 2800.0 |
| 2010-03-08 07:55:00 | AAPL | Stock | 7.8464 | 7.8464 | 7.8464 | 7.8464 | 16800.0 |
| 2010-03-08 07:59:00 | AAPL | Stock | 7.8429 | 7.8464 | 7.8429 | 7.8464 | 20272.0 |
| 2010-03-08 08:00:00 | AAPL | Stock | 7.8446 | 7.8536 | 7.8429 | 7.8536 | 174020.0 |
| 2010-03-08 08:01:00 | AAPL | Stock | 7.8543 | 7.8643 | 7.8536 | 7.8614 | 353304.0 |
| 2010-03-08 08:02:00 | AAPL | Stock | 7.8643 | 7.8679 | 7.8636 | 7.8661 | 215740.0 |
| 2010-03-08 08:03:00 | AAPL | Stock | 7.8657 | 7.8732 | 7.865 | 7.8714 | 158704.0 |
| 2010-03-08 08:04:00 | AAPL | Stock | 7.8732 | 7.8786 | 7.8714 | 7.8786 | 172480.0 |
| 2010-03-08 08:05:00 | AAPL | Stock | 7.8782 | 7.8804 | 7.8714 | 7.8714 | 159040.0 |
| 2010-03-08 08:06:00 | AAPL | Stock | 7.8754 | 7.8757 | 7.8714 | 7.8721 | 187320.0 |
| 2010-03-08 08:07:00 | AAPL | Stock | 7.8743 | 7.8775 | 7.8714 | 7.8761 | 242200.0 |
| 2010-03-08 08:08:00 | AAPL | Stock | 7.8757 | 7.8786 | 7.8757 | 7.8782 | 82740.0 |
| 2010-03-08 08:09:00 | AAPL | Stock | 7.8786 | 7.8807 | 7.8786 | 7.8807 | 101920.0 |
> showing 50 of 948,070 rows — these rows as CSV