PREVIEW / stock_1min / 2000-06-29
file: by_date/stock_1min/2000/2000-06-29.parquet size: 2.5 MB rows: 223,352 symbols: 971
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 |
|---|---|---|---|---|---|---|---|
| 2000-06-29 08:03:00 | AAPL | Stock | 0.9721 | 0.9721 | 0.9721 | 0.9721 | 39200.0 |
| 2000-06-29 09:12:00 | AAPL | Stock | 0.9554 | 0.9576 | 0.9554 | 0.9576 | 16800.0 |
| 2000-06-29 09:15:00 | AAPL | Stock | 0.9554 | 0.9554 | 0.9554 | 0.9554 | 22400.0 |
| 2000-06-29 09:16:00 | AAPL | Stock | 0.9587 | 0.9587 | 0.9587 | 0.9587 | 5600.0 |
| 2000-06-29 09:18:00 | AAPL | Stock | 0.9554 | 0.9554 | 0.9554 | 0.9554 | 16800.0 |
| 2000-06-29 09:20:00 | AAPL | Stock | 0.9576 | 0.9576 | 0.9576 | 0.9576 | 11200.0 |
| 2000-06-29 09:29:00 | AAPL | Stock | 0.9509 | 0.9509 | 0.9509 | 0.9509 | 16800.0 |
| 2000-06-29 09:30:00 | AAPL | Stock | 0.9475 | 0.9554 | 0.9475 | 0.9554 | 1663200.0 |
| 2000-06-29 09:31:00 | AAPL | Stock | 0.9498 | 0.9576 | 0.9475 | 0.9475 | 459200.0 |
| 2000-06-29 09:32:00 | AAPL | Stock | 0.9475 | 0.9554 | 0.9464 | 0.9464 | 1332800.0 |
| 2000-06-29 09:33:00 | AAPL | Stock | 0.9475 | 0.9509 | 0.9464 | 0.9509 | 1276800.0 |
| 2000-06-29 09:34:00 | AAPL | Stock | 0.952 | 0.952 | 0.9464 | 0.9492 | 1310400.0 |
| 2000-06-29 09:35:00 | AAPL | Stock | 0.9492 | 0.9492 | 0.942 | 0.9464 | 772800.0 |
| 2000-06-29 09:36:00 | AAPL | Stock | 0.9431 | 0.9464 | 0.942 | 0.942 | 420000.0 |
| 2000-06-29 09:37:00 | AAPL | Stock | 0.9464 | 0.9531 | 0.9464 | 0.9531 | 554400.0 |
| 2000-06-29 09:38:00 | AAPL | Stock | 0.9526 | 0.9542 | 0.9475 | 0.9475 | 173600.0 |
| 2000-06-29 09:39:00 | AAPL | Stock | 0.9537 | 0.9598 | 0.9487 | 0.9587 | 1092000.0 |
| 2000-06-29 09:40:00 | AAPL | Stock | 0.9604 | 0.9632 | 0.9554 | 0.9621 | 1444800.0 |
| 2000-06-29 09:41:00 | AAPL | Stock | 0.9626 | 0.9632 | 0.9542 | 0.9609 | 1349600.0 |
| 2000-06-29 09:42:00 | AAPL | Stock | 0.9598 | 0.9609 | 0.9554 | 0.9576 | 453600.0 |
| 2000-06-29 09:43:00 | AAPL | Stock | 0.9554 | 0.9621 | 0.9554 | 0.9576 | 392000.0 |
| 2000-06-29 09:44:00 | AAPL | Stock | 0.9576 | 0.9609 | 0.9576 | 0.9576 | 364000.0 |
| 2000-06-29 09:45:00 | AAPL | Stock | 0.9576 | 0.9576 | 0.9554 | 0.9554 | 268800.0 |
| 2000-06-29 09:46:00 | AAPL | Stock | 0.9559 | 0.9587 | 0.9542 | 0.9554 | 4631200.0 |
| 2000-06-29 09:47:00 | AAPL | Stock | 0.9554 | 0.9587 | 0.9554 | 0.9581 | 1097600.0 |
| 2000-06-29 09:48:00 | AAPL | Stock | 0.9554 | 0.9576 | 0.9554 | 0.9565 | 1870400.0 |
| 2000-06-29 09:49:00 | AAPL | Stock | 0.9554 | 0.9565 | 0.952 | 0.9531 | 2184000.0 |
| 2000-06-29 09:50:00 | AAPL | Stock | 0.952 | 0.9576 | 0.9509 | 0.9515 | 812000.0 |
| 2000-06-29 09:51:00 | AAPL | Stock | 0.952 | 0.952 | 0.942 | 0.9431 | 666400.0 |
| 2000-06-29 09:52:00 | AAPL | Stock | 0.942 | 0.9565 | 0.942 | 0.9509 | 498400.0 |
| 2000-06-29 09:53:00 | AAPL | Stock | 0.9509 | 0.9509 | 0.9498 | 0.9509 | 683200.0 |
| 2000-06-29 09:54:00 | AAPL | Stock | 0.9503 | 0.9509 | 0.9431 | 0.9431 | 683200.0 |
| 2000-06-29 09:55:00 | AAPL | Stock | 0.9431 | 0.9442 | 0.942 | 0.942 | 504000.0 |
| 2000-06-29 09:56:00 | AAPL | Stock | 0.9408 | 0.9464 | 0.9386 | 0.9464 | 711200.0 |
| 2000-06-29 09:57:00 | AAPL | Stock | 0.9392 | 0.9464 | 0.9386 | 0.9459 | 291200.0 |
| 2000-06-29 09:58:00 | AAPL | Stock | 0.9459 | 0.9487 | 0.9453 | 0.9464 | 257600.0 |
| 2000-06-29 09:59:00 | AAPL | Stock | 0.9475 | 0.9487 | 0.9464 | 0.9475 | 453600.0 |
| 2000-06-29 10:00:00 | AAPL | Stock | 0.9464 | 0.9481 | 0.9386 | 0.9464 | 929600.0 |
| 2000-06-29 10:01:00 | AAPL | Stock | 0.9464 | 0.9487 | 0.9442 | 0.9487 | 268800.0 |
| 2000-06-29 10:02:00 | AAPL | Stock | 0.9492 | 0.9531 | 0.9475 | 0.9531 | 632800.0 |
| 2000-06-29 10:03:00 | AAPL | Stock | 0.9531 | 0.9531 | 0.9464 | 0.9464 | 414400.0 |
| 2000-06-29 10:04:00 | AAPL | Stock | 0.9453 | 0.9487 | 0.9453 | 0.9487 | 515200.0 |
| 2000-06-29 10:05:00 | AAPL | Stock | 0.9475 | 0.9492 | 0.9475 | 0.9475 | 117600.0 |
| 2000-06-29 10:06:00 | AAPL | Stock | 0.9464 | 0.9487 | 0.9464 | 0.9475 | 442400.0 |
| 2000-06-29 10:07:00 | AAPL | Stock | 0.9453 | 0.9475 | 0.9453 | 0.9475 | 952000.0 |
| 2000-06-29 10:08:00 | AAPL | Stock | 0.9475 | 0.9487 | 0.9475 | 0.9487 | 504000.0 |
| 2000-06-29 10:09:00 | AAPL | Stock | 0.9475 | 0.9531 | 0.9475 | 0.9531 | 212800.0 |
| 2000-06-29 10:10:00 | AAPL | Stock | 0.9531 | 0.9576 | 0.9487 | 0.9531 | 1915200.0 |
| 2000-06-29 10:11:00 | AAPL | Stock | 0.9576 | 0.9576 | 0.9531 | 0.9565 | 201600.0 |
| 2000-06-29 10:12:00 | AAPL | Stock | 0.9554 | 0.9576 | 0.9531 | 0.9554 | 744800.0 |
> showing 50 of 223,352 rows — these rows as CSV