PREVIEW / stock_1min / 2009-10-28
file: by_date/stock_1min/2009/2009-10-28.parquet size: 13.7 MB rows: 1,020,495 symbols: 2,773
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-10-28 04:19:00 | AAPL | Stock | 7.0 | 7.0 | 7.0 | 7.0 | 2800.0 |
| 2009-10-28 04:26:00 | AAPL | Stock | 6.9957 | 6.9957 | 6.9957 | 6.9957 | 25284.0 |
| 2009-10-28 04:38:00 | AAPL | Stock | 7.0304 | 7.0304 | 7.0304 | 7.0304 | 4312.0 |
| 2009-10-28 04:57:00 | AAPL | Stock | 6.995 | 6.995 | 6.995 | 6.995 | 8400.0 |
| 2009-10-28 05:24:00 | AAPL | Stock | 6.9929 | 6.9929 | 6.9929 | 6.9929 | 2800.0 |
| 2009-10-28 05:25:00 | AAPL | Stock | 7.0229 | 7.0229 | 6.9929 | 6.9929 | 13300.0 |
| 2009-10-28 06:11:00 | AAPL | Stock | 6.9857 | 6.9857 | 6.9857 | 6.9857 | 15400.0 |
| 2009-10-28 06:27:00 | AAPL | Stock | 6.9857 | 6.9857 | 6.9857 | 6.9857 | 6720.0 |
| 2009-10-28 06:30:00 | AAPL | Stock | 6.9857 | 6.9857 | 6.9857 | 6.9857 | 2800.0 |
| 2009-10-28 06:36:00 | AAPL | Stock | 6.9996 | 7.0 | 6.9996 | 7.0 | 11200.0 |
| 2009-10-28 06:37:00 | AAPL | Stock | 7.0032 | 7.0054 | 7.0032 | 7.0054 | 9940.0 |
| 2009-10-28 06:48:00 | AAPL | Stock | 7.0054 | 7.0054 | 7.0054 | 7.0054 | 2800.0 |
| 2009-10-28 06:53:00 | AAPL | Stock | 7.0054 | 7.0054 | 7.0054 | 7.0054 | 2800.0 |
| 2009-10-28 06:59:00 | AAPL | Stock | 7.0071 | 7.0071 | 6.9982 | 6.9982 | 8624.0 |
| 2009-10-28 07:01:00 | AAPL | Stock | 7.0211 | 7.0211 | 7.0211 | 7.0211 | 2800.0 |
| 2009-10-28 07:02:00 | AAPL | Stock | 7.0214 | 7.0214 | 7.0214 | 7.0214 | 2800.0 |
| 2009-10-28 07:03:00 | AAPL | Stock | 7.0214 | 7.0214 | 7.0214 | 7.0214 | 5600.0 |
| 2009-10-28 07:07:00 | AAPL | Stock | 7.0075 | 7.0075 | 7.0071 | 7.0071 | 8400.0 |
| 2009-10-28 07:08:00 | AAPL | Stock | 7.0 | 7.0018 | 6.9921 | 6.9932 | 31920.0 |
| 2009-10-28 07:16:00 | AAPL | Stock | 7.0 | 7.0 | 7.0 | 7.0 | 8400.0 |
| 2009-10-28 07:21:00 | AAPL | Stock | 7.0 | 7.0071 | 7.0 | 7.0071 | 5600.0 |
| 2009-10-28 07:29:00 | AAPL | Stock | 6.995 | 6.995 | 6.995 | 6.995 | 2800.0 |
| 2009-10-28 07:35:00 | AAPL | Stock | 6.9936 | 7.0 | 6.9932 | 6.9932 | 33600.0 |
| 2009-10-28 07:36:00 | AAPL | Stock | 6.9918 | 6.9918 | 6.9918 | 6.9918 | 2828.0 |
| 2009-10-28 07:39:00 | AAPL | Stock | 6.9921 | 6.9921 | 6.9921 | 6.9921 | 2800.0 |
| 2009-10-28 07:43:00 | AAPL | Stock | 6.9939 | 6.9939 | 6.9929 | 6.9932 | 16800.0 |
| 2009-10-28 07:48:00 | AAPL | Stock | 7.0 | 7.0 | 7.0 | 7.0 | 5600.0 |
| 2009-10-28 07:51:00 | AAPL | Stock | 7.0089 | 7.0089 | 7.0086 | 7.0086 | 13076.0 |
| 2009-10-28 07:52:00 | AAPL | Stock | 7.0071 | 7.0071 | 7.0071 | 7.0071 | 2800.0 |
| 2009-10-28 07:53:00 | AAPL | Stock | 7.0043 | 7.0043 | 7.0043 | 7.0043 | 5600.0 |
| 2009-10-28 07:54:00 | AAPL | Stock | 7.0132 | 7.0132 | 7.0132 | 7.0132 | 2800.0 |
| 2009-10-28 07:55:00 | AAPL | Stock | 7.0143 | 7.0182 | 7.0143 | 7.0182 | 11200.0 |
| 2009-10-28 07:56:00 | AAPL | Stock | 7.0179 | 7.0179 | 7.0179 | 7.0179 | 2912.0 |
| 2009-10-28 07:57:00 | AAPL | Stock | 7.0182 | 7.0182 | 7.0179 | 7.0179 | 39200.0 |
| 2009-10-28 07:58:00 | AAPL | Stock | 7.0268 | 7.0268 | 7.0268 | 7.0268 | 2800.0 |
| 2009-10-28 08:00:00 | AAPL | Stock | 7.0282 | 7.0357 | 7.02 | 7.0357 | 61628.0 |
| 2009-10-28 08:01:00 | AAPL | Stock | 7.0357 | 7.0361 | 7.0357 | 7.0361 | 7504.0 |
| 2009-10-28 08:02:00 | AAPL | Stock | 7.0429 | 7.0429 | 7.0429 | 7.0429 | 8400.0 |
| 2009-10-28 08:03:00 | AAPL | Stock | 7.0361 | 7.0429 | 7.0357 | 7.0393 | 42000.0 |
| 2009-10-28 08:04:00 | AAPL | Stock | 7.0429 | 7.0432 | 7.0429 | 7.0429 | 33600.0 |
| 2009-10-28 08:06:00 | AAPL | Stock | 7.0429 | 7.0429 | 7.0286 | 7.0286 | 56308.0 |
| 2009-10-28 08:08:00 | AAPL | Stock | 7.0357 | 7.0357 | 7.0304 | 7.0304 | 15400.0 |
| 2009-10-28 08:09:00 | AAPL | Stock | 7.0304 | 7.0304 | 7.0304 | 7.0304 | 2800.0 |
| 2009-10-28 08:10:00 | AAPL | Stock | 7.0304 | 7.0304 | 7.0304 | 7.0304 | 18312.0 |
| 2009-10-28 08:11:00 | AAPL | Stock | 7.0304 | 7.0304 | 7.0286 | 7.0286 | 43792.0 |
| 2009-10-28 08:13:00 | AAPL | Stock | 7.0289 | 7.0289 | 7.0286 | 7.0286 | 11200.0 |
| 2009-10-28 08:14:00 | AAPL | Stock | 7.0312 | 7.0312 | 7.0312 | 7.0312 | 5600.0 |
| 2009-10-28 08:15:00 | AAPL | Stock | 7.0289 | 7.0289 | 7.0286 | 7.0286 | 10500.0 |
| 2009-10-28 08:16:00 | AAPL | Stock | 7.0314 | 7.0314 | 7.0286 | 7.0286 | 16520.0 |
| 2009-10-28 08:17:00 | AAPL | Stock | 7.0254 | 7.0254 | 7.0254 | 7.0254 | 2800.0 |
> showing 50 of 1,020,495 rows — these rows as CSV