PREVIEW / stock_1min / 2009-08-11
file: by_date/stock_1min/2009/2009-08-11.parquet size: 12.6 MB rows: 961,403 symbols: 2,727
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 |
|---|---|---|---|---|---|---|---|
| 2009-08-11 06:15:00 | AAPL | Stock | 5.8932 | 5.8932 | 5.8932 | 5.8932 | 14000.0 |
| 2009-08-11 08:00:00 | AAPL | Stock | 5.8875 | 5.8875 | 5.8768 | 5.8768 | 12348.0 |
| 2009-08-11 08:04:00 | AAPL | Stock | 5.8768 | 5.8829 | 5.8761 | 5.8761 | 19320.0 |
| 2009-08-11 08:06:00 | AAPL | Stock | 5.8757 | 5.8757 | 5.8757 | 5.8757 | 5068.0 |
| 2009-08-11 08:13:00 | AAPL | Stock | 5.8757 | 5.8757 | 5.8757 | 5.8757 | 10500.0 |
| 2009-08-11 08:14:00 | AAPL | Stock | 5.8754 | 5.8754 | 5.875 | 5.875 | 8400.0 |
| 2009-08-11 08:16:00 | AAPL | Stock | 5.875 | 5.875 | 5.875 | 5.875 | 26796.0 |
| 2009-08-11 08:22:00 | AAPL | Stock | 5.8782 | 5.8782 | 5.8782 | 5.8782 | 2800.0 |
| 2009-08-11 08:35:00 | AAPL | Stock | 5.8804 | 5.8804 | 5.8804 | 5.8804 | 5600.0 |
| 2009-08-11 08:36:00 | AAPL | Stock | 5.8764 | 5.8764 | 5.8757 | 5.8757 | 22260.0 |
| 2009-08-11 08:38:00 | AAPL | Stock | 5.8757 | 5.8757 | 5.8757 | 5.8757 | 5600.0 |
| 2009-08-11 08:41:00 | AAPL | Stock | 5.8761 | 5.8761 | 5.8757 | 5.8757 | 12040.0 |
| 2009-08-11 08:47:00 | AAPL | Stock | 5.88 | 5.88 | 5.875 | 5.8757 | 49560.0 |
| 2009-08-11 08:48:00 | AAPL | Stock | 5.875 | 5.875 | 5.875 | 5.875 | 22400.0 |
| 2009-08-11 08:50:00 | AAPL | Stock | 5.875 | 5.875 | 5.875 | 5.875 | 13916.0 |
| 2009-08-11 08:53:00 | AAPL | Stock | 5.875 | 5.8782 | 5.875 | 5.8782 | 13748.0 |
| 2009-08-11 08:56:00 | AAPL | Stock | 5.8714 | 5.8714 | 5.8714 | 5.8714 | 13160.0 |
| 2009-08-11 08:57:00 | AAPL | Stock | 5.8686 | 5.8686 | 5.8686 | 5.8686 | 11200.0 |
| 2009-08-11 08:59:00 | AAPL | Stock | 5.8636 | 5.8636 | 5.8579 | 5.8579 | 28000.0 |
| 2009-08-11 09:00:00 | AAPL | Stock | 5.8579 | 5.8579 | 5.8571 | 5.8571 | 126840.0 |
| 2009-08-11 09:01:00 | AAPL | Stock | 5.8582 | 5.8582 | 5.8571 | 5.8571 | 44800.0 |
| 2009-08-11 09:02:00 | AAPL | Stock | 5.8571 | 5.8586 | 5.8571 | 5.8586 | 28000.0 |
| 2009-08-11 09:03:00 | AAPL | Stock | 5.8582 | 5.8586 | 5.8571 | 5.8575 | 139860.0 |
| 2009-08-11 09:04:00 | AAPL | Stock | 5.8571 | 5.8625 | 5.8536 | 5.8625 | 693896.0 |
| 2009-08-11 09:05:00 | AAPL | Stock | 5.8579 | 5.8579 | 5.8536 | 5.8536 | 266840.0 |
| 2009-08-11 09:06:00 | AAPL | Stock | 5.8536 | 5.8539 | 5.85 | 5.8536 | 355600.0 |
| 2009-08-11 09:07:00 | AAPL | Stock | 5.8536 | 5.8536 | 5.8518 | 5.8518 | 128912.0 |
| 2009-08-11 09:08:00 | AAPL | Stock | 5.8518 | 5.8518 | 5.85 | 5.85 | 128800.0 |
| 2009-08-11 09:09:00 | AAPL | Stock | 5.85 | 5.8504 | 5.85 | 5.85 | 72800.0 |
| 2009-08-11 09:10:00 | AAPL | Stock | 5.8496 | 5.8496 | 5.8482 | 5.8496 | 44800.0 |
| 2009-08-11 09:11:00 | AAPL | Stock | 5.8489 | 5.8489 | 5.8482 | 5.8482 | 73920.0 |
| 2009-08-11 09:12:00 | AAPL | Stock | 5.8482 | 5.8493 | 5.8464 | 5.8464 | 634200.0 |
| 2009-08-11 09:13:00 | AAPL | Stock | 5.8468 | 5.8468 | 5.8461 | 5.8461 | 173600.0 |
| 2009-08-11 09:14:00 | AAPL | Stock | 5.8461 | 5.8464 | 5.8457 | 5.8457 | 98000.0 |
| 2009-08-11 09:15:00 | AAPL | Stock | 5.8461 | 5.8464 | 5.8461 | 5.8464 | 28000.0 |
| 2009-08-11 09:16:00 | AAPL | Stock | 5.8461 | 5.8586 | 5.8432 | 5.8579 | 380828.0 |
| 2009-08-11 09:17:00 | AAPL | Stock | 5.8554 | 5.8711 | 5.8546 | 5.8593 | 197400.0 |
| 2009-08-11 09:18:00 | AAPL | Stock | 5.8604 | 5.8604 | 5.8554 | 5.8589 | 269668.0 |
| 2009-08-11 09:19:00 | AAPL | Stock | 5.8571 | 5.8589 | 5.8557 | 5.8557 | 33600.0 |
| 2009-08-11 09:20:00 | AAPL | Stock | 5.8586 | 5.8607 | 5.8586 | 5.8586 | 22400.0 |
| 2009-08-11 09:21:00 | AAPL | Stock | 5.8554 | 5.8554 | 5.8532 | 5.8532 | 8400.0 |
| 2009-08-11 09:22:00 | AAPL | Stock | 5.8539 | 5.8539 | 5.8539 | 5.8539 | 2800.0 |
| 2009-08-11 09:23:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8571 | 5.8571 | 5936.0 |
| 2009-08-11 09:24:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8539 | 5.8571 | 22400.0 |
| 2009-08-11 09:25:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8554 | 5.8554 | 65240.0 |
| 2009-08-11 09:26:00 | AAPL | Stock | 5.8539 | 5.8539 | 5.8489 | 5.8489 | 12600.0 |
| 2009-08-11 09:27:00 | AAPL | Stock | 5.8493 | 5.8518 | 5.8468 | 5.8471 | 36764.0 |
| 2009-08-11 09:28:00 | AAPL | Stock | 5.8464 | 5.8471 | 5.8361 | 5.8457 | 238000.0 |
| 2009-08-11 09:29:00 | AAPL | Stock | 5.8421 | 5.8475 | 5.8421 | 5.8446 | 70000.0 |
| 2009-08-11 09:30:00 | AAPL | Stock | 5.8461 | 5.848 | 5.8339 | 5.8421 | 4294248.0 |
> showing 50 of 961,403 rows — these rows as CSV