PREVIEW / stock_1min / 2008-09-25
file: by_date/stock_1min/2008/2008-09-25.parquet size: 12.4 MB rows: 1,000,896 symbols: 2,717
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-09-25 05:53:00 | AAPL | Stock | 4.6425 | 4.6425 | 4.6425 | 4.6425 | 28000.0 |
| 2008-09-25 06:30:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6429 | 4.6429 | 2800.0 |
| 2008-09-25 06:54:00 | AAPL | Stock | 4.6071 | 4.6071 | 4.6071 | 4.6071 | 11200.0 |
| 2008-09-25 07:04:00 | AAPL | Stock | 4.6082 | 4.6082 | 4.6082 | 4.6082 | 2800.0 |
| 2008-09-25 07:10:00 | AAPL | Stock | 4.6339 | 4.6339 | 4.6339 | 4.6339 | 8400.0 |
| 2008-09-25 07:12:00 | AAPL | Stock | 4.6107 | 4.6107 | 4.6107 | 4.6107 | 2800.0 |
| 2008-09-25 07:14:00 | AAPL | Stock | 4.625 | 4.625 | 4.625 | 4.625 | 5600.0 |
| 2008-09-25 07:18:00 | AAPL | Stock | 4.6207 | 4.6207 | 4.6207 | 4.6207 | 2800.0 |
| 2008-09-25 07:23:00 | AAPL | Stock | 4.6107 | 4.6107 | 4.6107 | 4.6107 | 19796.0 |
| 2008-09-25 07:24:00 | AAPL | Stock | 4.6107 | 4.6107 | 4.6107 | 4.6107 | 11200.0 |
| 2008-09-25 07:25:00 | AAPL | Stock | 4.6071 | 4.6071 | 4.6071 | 4.6071 | 64400.0 |
| 2008-09-25 07:28:00 | AAPL | Stock | 4.6071 | 4.6071 | 4.6064 | 4.6064 | 36624.0 |
| 2008-09-25 07:29:00 | AAPL | Stock | 4.6064 | 4.6064 | 4.6064 | 4.6064 | 4200.0 |
| 2008-09-25 07:33:00 | AAPL | Stock | 4.5893 | 4.5893 | 4.5893 | 4.5893 | 2800.0 |
| 2008-09-25 07:38:00 | AAPL | Stock | 4.5893 | 4.5893 | 4.5893 | 4.5893 | 30800.0 |
| 2008-09-25 07:39:00 | AAPL | Stock | 4.5754 | 4.5754 | 4.5714 | 4.5754 | 86940.0 |
| 2008-09-25 07:40:00 | AAPL | Stock | 4.5736 | 4.5736 | 4.5714 | 4.5714 | 29680.0 |
| 2008-09-25 07:41:00 | AAPL | Stock | 4.5725 | 4.5725 | 4.5725 | 4.5725 | 2800.0 |
| 2008-09-25 07:43:00 | AAPL | Stock | 4.5732 | 4.5739 | 4.5714 | 4.5732 | 68824.0 |
| 2008-09-25 07:44:00 | AAPL | Stock | 4.5714 | 4.5732 | 4.5714 | 4.5732 | 28000.0 |
| 2008-09-25 07:47:00 | AAPL | Stock | 4.5732 | 4.5732 | 4.5732 | 4.5732 | 14000.0 |
| 2008-09-25 07:49:00 | AAPL | Stock | 4.5714 | 4.5714 | 4.5679 | 4.5679 | 22960.0 |
| 2008-09-25 07:50:00 | AAPL | Stock | 4.5664 | 4.5664 | 4.5536 | 4.5536 | 44660.0 |
| 2008-09-25 07:52:00 | AAPL | Stock | 4.5664 | 4.5664 | 4.5536 | 4.5536 | 14000.0 |
| 2008-09-25 07:53:00 | AAPL | Stock | 4.5657 | 4.5661 | 4.5657 | 4.5661 | 11200.0 |
| 2008-09-25 07:54:00 | AAPL | Stock | 4.5507 | 4.5507 | 4.5489 | 4.5489 | 22400.0 |
| 2008-09-25 07:56:00 | AAPL | Stock | 4.5661 | 4.5661 | 4.5571 | 4.5571 | 14000.0 |
| 2008-09-25 07:57:00 | AAPL | Stock | 4.5564 | 4.5564 | 4.5564 | 4.5564 | 28000.0 |
| 2008-09-25 07:58:00 | AAPL | Stock | 4.5607 | 4.5614 | 4.5607 | 4.5614 | 11200.0 |
| 2008-09-25 07:59:00 | AAPL | Stock | 4.5661 | 4.5661 | 4.5661 | 4.5661 | 8400.0 |
| 2008-09-25 08:00:00 | AAPL | Stock | 4.5711 | 4.6046 | 4.5696 | 4.5893 | 251496.0 |
| 2008-09-25 08:01:00 | AAPL | Stock | 4.5879 | 4.5904 | 4.5775 | 4.5871 | 51212.0 |
| 2008-09-25 08:02:00 | AAPL | Stock | 4.5811 | 4.5857 | 4.5811 | 4.5818 | 16996.0 |
| 2008-09-25 08:03:00 | AAPL | Stock | 4.5786 | 4.5821 | 4.5768 | 4.5768 | 64204.0 |
| 2008-09-25 08:04:00 | AAPL | Stock | 4.585 | 4.6018 | 4.5846 | 4.6018 | 64736.0 |
| 2008-09-25 08:05:00 | AAPL | Stock | 4.5861 | 4.6 | 4.5861 | 4.5946 | 22400.0 |
| 2008-09-25 08:06:00 | AAPL | Stock | 4.5996 | 4.5996 | 4.5996 | 4.5996 | 2800.0 |
| 2008-09-25 08:07:00 | AAPL | Stock | 4.6007 | 4.6007 | 4.5996 | 4.6 | 47600.0 |
| 2008-09-25 08:08:00 | AAPL | Stock | 4.5936 | 4.5982 | 4.5929 | 4.5982 | 38500.0 |
| 2008-09-25 08:09:00 | AAPL | Stock | 4.5968 | 4.6036 | 4.5968 | 4.6 | 47600.0 |
| 2008-09-25 08:10:00 | AAPL | Stock | 4.5989 | 4.6 | 4.5936 | 4.5936 | 56560.0 |
| 2008-09-25 08:11:00 | AAPL | Stock | 4.595 | 4.5982 | 4.595 | 4.5982 | 5600.0 |
| 2008-09-25 08:12:00 | AAPL | Stock | 4.5989 | 4.61 | 4.5989 | 4.6071 | 145600.0 |
| 2008-09-25 08:13:00 | AAPL | Stock | 4.6071 | 4.6071 | 4.6025 | 4.6025 | 14000.0 |
| 2008-09-25 08:14:00 | AAPL | Stock | 4.6029 | 4.6125 | 4.6029 | 4.6125 | 95480.0 |
| 2008-09-25 08:15:00 | AAPL | Stock | 4.6143 | 4.62 | 4.6143 | 4.6161 | 31444.0 |
| 2008-09-25 08:16:00 | AAPL | Stock | 4.6175 | 4.6296 | 4.6175 | 4.625 | 85204.0 |
| 2008-09-25 08:17:00 | AAPL | Stock | 4.625 | 4.625 | 4.6221 | 4.625 | 119840.0 |
| 2008-09-25 08:18:00 | AAPL | Stock | 4.6182 | 4.6186 | 4.6143 | 4.6143 | 222908.0 |
| 2008-09-25 08:19:00 | AAPL | Stock | 4.6175 | 4.6179 | 4.6175 | 4.6179 | 424760.0 |
> showing 50 of 1,000,896 rows — these rows as CSV