PREVIEW / stock_1min / 2008-01-16
file: by_date/stock_1min/2008/2008-01-16.parquet size: 13.6 MB rows: 1,087,687 symbols: 2,666
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-16 04:27:00 | AAPL | Stock | 5.7893 | 5.7893 | 5.7893 | 5.7893 | 7000.0 |
| 2008-01-16 04:36:00 | AAPL | Stock | 5.8032 | 5.8032 | 5.8032 | 5.8032 | 2800.0 |
| 2008-01-16 04:38:00 | AAPL | Stock | 5.7936 | 5.7936 | 5.7936 | 5.7936 | 2800.0 |
| 2008-01-16 05:23:00 | AAPL | Stock | 5.8036 | 5.8036 | 5.8036 | 5.8036 | 14000.0 |
| 2008-01-16 05:26:00 | AAPL | Stock | 5.8036 | 5.8036 | 5.8036 | 5.8036 | 5600.0 |
| 2008-01-16 05:29:00 | AAPL | Stock | 5.7914 | 5.7914 | 5.7914 | 5.7914 | 2800.0 |
| 2008-01-16 05:54:00 | AAPL | Stock | 5.8161 | 5.8161 | 5.8161 | 5.8161 | 2800.0 |
| 2008-01-16 06:47:00 | AAPL | Stock | 5.815 | 5.815 | 5.815 | 5.815 | 53564.0 |
| 2008-01-16 06:50:00 | AAPL | Stock | 5.8107 | 5.8107 | 5.8107 | 5.8107 | 28000.0 |
| 2008-01-16 06:51:00 | AAPL | Stock | 5.8107 | 5.8107 | 5.8071 | 5.8071 | 78764.0 |
| 2008-01-16 06:54:00 | AAPL | Stock | 5.8071 | 5.8071 | 5.8071 | 5.8071 | 2800.0 |
| 2008-01-16 06:56:00 | AAPL | Stock | 5.8054 | 5.8054 | 5.8054 | 5.8054 | 11200.0 |
| 2008-01-16 06:57:00 | AAPL | Stock | 5.8018 | 5.8018 | 5.8018 | 5.8018 | 5600.0 |
| 2008-01-16 06:58:00 | AAPL | Stock | 5.8071 | 5.8071 | 5.8071 | 5.8071 | 11200.0 |
| 2008-01-16 07:00:00 | AAPL | Stock | 5.8125 | 5.8125 | 5.8 | 5.8125 | 64400.0 |
| 2008-01-16 07:01:00 | AAPL | Stock | 5.8121 | 5.8121 | 5.8032 | 5.8032 | 25200.0 |
| 2008-01-16 07:02:00 | AAPL | Stock | 5.8032 | 5.8429 | 5.8032 | 5.8429 | 45388.0 |
| 2008-01-16 07:03:00 | AAPL | Stock | 5.8425 | 5.8429 | 5.8389 | 5.8393 | 49924.0 |
| 2008-01-16 07:05:00 | AAPL | Stock | 5.8325 | 5.8393 | 5.8325 | 5.8393 | 16800.0 |
| 2008-01-16 07:08:00 | AAPL | Stock | 5.8393 | 5.8425 | 5.8393 | 5.8425 | 29876.0 |
| 2008-01-16 07:09:00 | AAPL | Stock | 5.85 | 5.8507 | 5.85 | 5.8507 | 11200.0 |
| 2008-01-16 07:10:00 | AAPL | Stock | 5.8561 | 5.8571 | 5.8482 | 5.8557 | 37800.0 |
| 2008-01-16 07:11:00 | AAPL | Stock | 5.8557 | 5.8568 | 5.8557 | 5.8568 | 47600.0 |
| 2008-01-16 07:12:00 | AAPL | Stock | 5.85 | 5.85 | 5.8464 | 5.8464 | 58800.0 |
| 2008-01-16 07:13:00 | AAPL | Stock | 5.8464 | 5.8464 | 5.8393 | 5.8464 | 59696.0 |
| 2008-01-16 07:20:00 | AAPL | Stock | 5.8489 | 5.8489 | 5.8489 | 5.8489 | 2800.0 |
| 2008-01-16 07:23:00 | AAPL | Stock | 5.8493 | 5.8493 | 5.8493 | 5.8493 | 58800.0 |
| 2008-01-16 07:24:00 | AAPL | Stock | 5.8493 | 5.8554 | 5.8493 | 5.8554 | 68600.0 |
| 2008-01-16 07:25:00 | AAPL | Stock | 5.8536 | 5.8536 | 5.8536 | 5.8536 | 14000.0 |
| 2008-01-16 07:28:00 | AAPL | Stock | 5.8568 | 5.8746 | 5.8536 | 5.8746 | 74200.0 |
| 2008-01-16 07:29:00 | AAPL | Stock | 5.8707 | 5.8782 | 5.8707 | 5.8782 | 25200.0 |
| 2008-01-16 07:30:00 | AAPL | Stock | 5.8711 | 5.8711 | 5.8711 | 5.8711 | 7280.0 |
| 2008-01-16 07:31:00 | AAPL | Stock | 5.8746 | 5.875 | 5.8643 | 5.8643 | 70028.0 |
| 2008-01-16 07:32:00 | AAPL | Stock | 5.875 | 5.875 | 5.875 | 5.875 | 14000.0 |
| 2008-01-16 07:33:00 | AAPL | Stock | 5.88 | 5.88 | 5.875 | 5.875 | 43400.0 |
| 2008-01-16 07:34:00 | AAPL | Stock | 5.875 | 5.875 | 5.8575 | 5.8575 | 15260.0 |
| 2008-01-16 07:37:00 | AAPL | Stock | 5.8596 | 5.8596 | 5.8575 | 5.8575 | 49504.0 |
| 2008-01-16 07:38:00 | AAPL | Stock | 5.8732 | 5.875 | 5.8732 | 5.875 | 63140.0 |
| 2008-01-16 07:41:00 | AAPL | Stock | 5.875 | 5.8821 | 5.875 | 5.8818 | 24920.0 |
| 2008-01-16 07:42:00 | AAPL | Stock | 5.8818 | 5.8907 | 5.8818 | 5.8907 | 41020.0 |
| 2008-01-16 07:43:00 | AAPL | Stock | 5.8904 | 5.8921 | 5.8839 | 5.8921 | 41132.0 |
| 2008-01-16 07:45:00 | AAPL | Stock | 5.8921 | 5.8921 | 5.8911 | 5.8911 | 73640.0 |
| 2008-01-16 07:46:00 | AAPL | Stock | 5.8907 | 5.9018 | 5.8907 | 5.9007 | 272580.0 |
| 2008-01-16 07:47:00 | AAPL | Stock | 5.9007 | 5.9007 | 5.8964 | 5.8968 | 44800.0 |
| 2008-01-16 07:48:00 | AAPL | Stock | 5.8971 | 5.9018 | 5.8929 | 5.9014 | 78400.0 |
| 2008-01-16 07:49:00 | AAPL | Stock | 5.9029 | 5.9071 | 5.9014 | 5.9029 | 182000.0 |
| 2008-01-16 07:50:00 | AAPL | Stock | 5.9029 | 5.9029 | 5.9029 | 5.9029 | 126000.0 |
| 2008-01-16 07:51:00 | AAPL | Stock | 5.8893 | 5.9 | 5.8893 | 5.9 | 19292.0 |
| 2008-01-16 07:52:00 | AAPL | Stock | 5.8996 | 5.9007 | 5.8861 | 5.8929 | 36400.0 |
| 2008-01-16 07:53:00 | AAPL | Stock | 5.8861 | 5.8861 | 5.8839 | 5.8839 | 184800.0 |
> showing 50 of 1,087,687 rows — these rows as CSV