PREVIEW / stock_1min / 2010-07-14
file: by_date/stock_1min/2010/2010-07-14.parquet size: 12.2 MB rows: 936,292 symbols: 2,780
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 |
|---|---|---|---|---|---|---|---|
| 2010-07-14 05:40:00 | AAPL | Stock | 9.0714 | 9.0714 | 9.0714 | 9.0714 | 2800.0 |
| 2010-07-14 05:49:00 | AAPL | Stock | 9.0657 | 9.0657 | 9.0657 | 9.0657 | 2800.0 |
| 2010-07-14 05:51:00 | AAPL | Stock | 9.0657 | 9.0657 | 9.0657 | 9.0657 | 2800.0 |
| 2010-07-14 06:00:00 | AAPL | Stock | 9.0536 | 9.0536 | 9.0536 | 9.0536 | 8400.0 |
| 2010-07-14 06:38:00 | AAPL | Stock | 9.0429 | 9.0429 | 9.0429 | 9.0429 | 14000.0 |
| 2010-07-14 06:56:00 | AAPL | Stock | 9.0446 | 9.0446 | 9.0446 | 9.0446 | 2800.0 |
| 2010-07-14 07:01:00 | AAPL | Stock | 9.0446 | 9.0446 | 9.0429 | 9.0429 | 10220.0 |
| 2010-07-14 07:02:00 | AAPL | Stock | 9.0429 | 9.0429 | 9.0411 | 9.0411 | 17500.0 |
| 2010-07-14 07:03:00 | AAPL | Stock | 9.0429 | 9.0432 | 9.0429 | 9.0432 | 14000.0 |
| 2010-07-14 07:05:00 | AAPL | Stock | 9.0286 | 9.0286 | 9.0286 | 9.0286 | 5600.0 |
| 2010-07-14 07:09:00 | AAPL | Stock | 9.0179 | 9.0179 | 9.0179 | 9.0179 | 2800.0 |
| 2010-07-14 07:10:00 | AAPL | Stock | 9.0111 | 9.0111 | 9.0111 | 9.0111 | 2800.0 |
| 2010-07-14 07:14:00 | AAPL | Stock | 9.0254 | 9.0254 | 9.0254 | 9.0254 | 2800.0 |
| 2010-07-14 07:15:00 | AAPL | Stock | 9.0107 | 9.0111 | 9.0107 | 9.0107 | 11200.0 |
| 2010-07-14 07:25:00 | AAPL | Stock | 9.0179 | 9.0179 | 9.0179 | 9.0179 | 5600.0 |
| 2010-07-14 07:26:00 | AAPL | Stock | 9.0179 | 9.0179 | 9.0179 | 9.0179 | 5600.0 |
| 2010-07-14 07:31:00 | AAPL | Stock | 9.0182 | 9.0264 | 9.0182 | 9.0264 | 8400.0 |
| 2010-07-14 07:35:00 | AAPL | Stock | 9.0268 | 9.0268 | 9.0268 | 9.0268 | 2800.0 |
| 2010-07-14 07:38:00 | AAPL | Stock | 9.0268 | 9.0286 | 9.0268 | 9.0286 | 5600.0 |
| 2010-07-14 07:39:00 | AAPL | Stock | 9.0279 | 9.0286 | 9.0279 | 9.0286 | 19600.0 |
| 2010-07-14 07:40:00 | AAPL | Stock | 9.0286 | 9.0286 | 9.0286 | 9.0286 | 5600.0 |
| 2010-07-14 07:41:00 | AAPL | Stock | 9.0282 | 9.0286 | 9.0282 | 9.0286 | 5600.0 |
| 2010-07-14 07:45:00 | AAPL | Stock | 9.0268 | 9.0268 | 9.0236 | 9.0239 | 16800.0 |
| 2010-07-14 07:46:00 | AAPL | Stock | 9.0236 | 9.0236 | 9.0236 | 9.0236 | 2800.0 |
| 2010-07-14 07:47:00 | AAPL | Stock | 9.0268 | 9.0268 | 9.0246 | 9.0246 | 8400.0 |
| 2010-07-14 07:49:00 | AAPL | Stock | 9.0214 | 9.0214 | 9.0214 | 9.0214 | 8400.0 |
| 2010-07-14 07:50:00 | AAPL | Stock | 9.0218 | 9.0218 | 9.0218 | 9.0218 | 8400.0 |
| 2010-07-14 07:51:00 | AAPL | Stock | 9.0218 | 9.0246 | 9.0193 | 9.0218 | 28000.0 |
| 2010-07-14 07:52:00 | AAPL | Stock | 9.0218 | 9.0218 | 9.0218 | 9.0218 | 2800.0 |
| 2010-07-14 07:54:00 | AAPL | Stock | 9.02 | 9.02 | 9.0196 | 9.0196 | 8400.0 |
| 2010-07-14 07:55:00 | AAPL | Stock | 9.0246 | 9.0246 | 9.0246 | 9.0246 | 2800.0 |
| 2010-07-14 07:56:00 | AAPL | Stock | 9.0189 | 9.0189 | 9.0179 | 9.0179 | 124740.0 |
| 2010-07-14 07:57:00 | AAPL | Stock | 9.0121 | 9.0121 | 9.0 | 9.0 | 128800.0 |
| 2010-07-14 07:58:00 | AAPL | Stock | 8.9993 | 9.0 | 8.9725 | 8.9825 | 78596.0 |
| 2010-07-14 07:59:00 | AAPL | Stock | 8.9832 | 8.9871 | 8.9832 | 8.9871 | 5600.0 |
| 2010-07-14 08:00:00 | AAPL | Stock | 8.9871 | 9.0125 | 8.9861 | 9.0 | 331324.0 |
| 2010-07-14 08:01:00 | AAPL | Stock | 8.9975 | 8.9975 | 8.9975 | 8.9975 | 5600.0 |
| 2010-07-14 08:02:00 | AAPL | Stock | 8.9975 | 9.0 | 8.9964 | 8.9975 | 82880.0 |
| 2010-07-14 08:03:00 | AAPL | Stock | 8.9975 | 9.0004 | 8.9964 | 9.0004 | 47600.0 |
| 2010-07-14 08:04:00 | AAPL | Stock | 9.0 | 9.0004 | 8.9932 | 8.9964 | 33936.0 |
| 2010-07-14 08:05:00 | AAPL | Stock | 8.9896 | 8.9896 | 8.9736 | 8.9736 | 85400.0 |
| 2010-07-14 08:06:00 | AAPL | Stock | 8.9821 | 8.9871 | 8.9661 | 8.98 | 49448.0 |
| 2010-07-14 08:07:00 | AAPL | Stock | 8.9732 | 8.9821 | 8.9643 | 8.9714 | 267064.0 |
| 2010-07-14 08:08:00 | AAPL | Stock | 8.9718 | 8.9786 | 8.9661 | 8.9782 | 55048.0 |
| 2010-07-14 08:09:00 | AAPL | Stock | 8.9786 | 8.9821 | 8.9771 | 8.9821 | 61040.0 |
| 2010-07-14 08:10:00 | AAPL | Stock | 8.9821 | 8.9893 | 8.9786 | 8.9786 | 158508.0 |
| 2010-07-14 08:11:00 | AAPL | Stock | 8.975 | 8.975 | 8.9482 | 8.9625 | 148400.0 |
| 2010-07-14 08:12:00 | AAPL | Stock | 8.9518 | 8.9518 | 8.9364 | 8.9429 | 98700.0 |
| 2010-07-14 08:13:00 | AAPL | Stock | 8.9339 | 8.9429 | 8.9321 | 8.9357 | 116452.0 |
| 2010-07-14 08:14:00 | AAPL | Stock | 8.9336 | 8.9343 | 8.9286 | 8.9293 | 95200.0 |
> showing 50 of 936,292 rows — these rows as CSV