PREVIEW / stock_1min / 2012-05-03
file: by_date/stock_1min/2012/2012-05-03.parquet size: 13.5 MB rows: 1,005,018 symbols: 2,860
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 |
|---|---|---|---|---|---|---|---|
| 2012-05-03 04:02:00 | AAPL | Stock | 20.9546 | 20.9546 | 20.9546 | 20.9546 | 5600.0 |
| 2012-05-03 04:03:00 | AAPL | Stock | 20.9607 | 20.9607 | 20.9607 | 20.9607 | 2800.0 |
| 2012-05-03 04:04:00 | AAPL | Stock | 20.9643 | 20.9643 | 20.9643 | 20.9643 | 14000.0 |
| 2012-05-03 04:23:00 | AAPL | Stock | 20.9643 | 20.9643 | 20.9643 | 20.9643 | 2800.0 |
| 2012-05-03 04:28:00 | AAPL | Stock | 20.9821 | 20.9821 | 20.9821 | 20.9821 | 11200.0 |
| 2012-05-03 04:36:00 | AAPL | Stock | 20.9643 | 20.9643 | 20.9643 | 20.9643 | 5600.0 |
| 2012-05-03 04:37:00 | AAPL | Stock | 20.9643 | 20.9643 | 20.9643 | 20.9643 | 7700.0 |
| 2012-05-03 04:47:00 | AAPL | Stock | 20.9643 | 20.9643 | 20.9643 | 20.9643 | 8400.0 |
| 2012-05-03 05:23:00 | AAPL | Stock | 20.9639 | 20.9639 | 20.9639 | 20.9639 | 14000.0 |
| 2012-05-03 05:57:00 | AAPL | Stock | 20.9464 | 20.9464 | 20.9464 | 20.9464 | 13580.0 |
| 2012-05-03 06:46:00 | AAPL | Stock | 20.9468 | 20.9468 | 20.9464 | 20.9464 | 11200.0 |
| 2012-05-03 07:00:00 | AAPL | Stock | 20.9643 | 20.9643 | 20.9643 | 20.9643 | 3920.0 |
| 2012-05-03 07:01:00 | AAPL | Stock | 20.9464 | 20.9464 | 20.9461 | 20.9464 | 11200.0 |
| 2012-05-03 07:02:00 | AAPL | Stock | 20.9482 | 20.9482 | 20.9482 | 20.9482 | 2800.0 |
| 2012-05-03 07:03:00 | AAPL | Stock | 20.9625 | 20.9643 | 20.9625 | 20.9643 | 5600.0 |
| 2012-05-03 07:07:00 | AAPL | Stock | 20.9643 | 20.9643 | 20.9643 | 20.9643 | 10360.0 |
| 2012-05-03 07:08:00 | AAPL | Stock | 20.9643 | 20.9643 | 20.9643 | 20.9643 | 2800.0 |
| 2012-05-03 07:11:00 | AAPL | Stock | 20.9729 | 20.9729 | 20.9729 | 20.9729 | 2800.0 |
| 2012-05-03 07:12:00 | AAPL | Stock | 20.9821 | 20.9821 | 20.9821 | 20.9821 | 2800.0 |
| 2012-05-03 07:13:00 | AAPL | Stock | 20.9982 | 21.0 | 20.9982 | 21.0 | 32424.0 |
| 2012-05-03 07:14:00 | AAPL | Stock | 21.0 | 21.0 | 21.0 | 21.0 | 8400.0 |
| 2012-05-03 07:17:00 | AAPL | Stock | 21.0 | 21.0 | 21.0 | 21.0 | 2800.0 |
| 2012-05-03 07:18:00 | AAPL | Stock | 20.9921 | 20.9921 | 20.9921 | 20.9921 | 2800.0 |
| 2012-05-03 07:19:00 | AAPL | Stock | 20.9921 | 20.9921 | 20.9921 | 20.9921 | 5600.0 |
| 2012-05-03 07:26:00 | AAPL | Stock | 20.9804 | 20.9911 | 20.9804 | 20.9911 | 5600.0 |
| 2012-05-03 07:27:00 | AAPL | Stock | 21.0 | 21.0 | 21.0 | 21.0 | 2800.0 |
| 2012-05-03 07:28:00 | AAPL | Stock | 21.0 | 21.0068 | 21.0 | 21.0 | 11200.0 |
| 2012-05-03 07:29:00 | AAPL | Stock | 21.0189 | 21.0189 | 21.0186 | 21.0186 | 5600.0 |
| 2012-05-03 07:30:00 | AAPL | Stock | 21.0354 | 21.0354 | 21.0336 | 21.0339 | 8400.0 |
| 2012-05-03 07:31:00 | AAPL | Stock | 21.0214 | 21.025 | 21.0214 | 21.025 | 5600.0 |
| 2012-05-03 07:35:00 | AAPL | Stock | 21.0179 | 21.0179 | 21.0179 | 21.0179 | 8400.0 |
| 2012-05-03 07:38:00 | AAPL | Stock | 21.0164 | 21.0164 | 21.0164 | 21.0164 | 5600.0 |
| 2012-05-03 07:41:00 | AAPL | Stock | 21.0232 | 21.0232 | 21.0232 | 21.0232 | 5600.0 |
| 2012-05-03 07:42:00 | AAPL | Stock | 21.0161 | 21.0161 | 21.0071 | 21.0071 | 28000.0 |
| 2012-05-03 07:43:00 | AAPL | Stock | 21.0071 | 21.0071 | 21.0071 | 21.0071 | 19600.0 |
| 2012-05-03 07:45:00 | AAPL | Stock | 21.0 | 21.0 | 21.0 | 21.0 | 7700.0 |
| 2012-05-03 07:48:00 | AAPL | Stock | 20.9861 | 20.9911 | 20.9861 | 20.9911 | 8400.0 |
| 2012-05-03 07:49:00 | AAPL | Stock | 20.9996 | 20.9996 | 20.9996 | 20.9996 | 8400.0 |
| 2012-05-03 07:50:00 | AAPL | Stock | 21.0 | 21.0 | 21.0 | 21.0 | 22596.0 |
| 2012-05-03 07:52:00 | AAPL | Stock | 20.9964 | 21.0 | 20.9964 | 21.0 | 14672.0 |
| 2012-05-03 07:54:00 | AAPL | Stock | 21.0 | 21.0 | 21.0 | 21.0 | 19600.0 |
| 2012-05-03 07:55:00 | AAPL | Stock | 21.0068 | 21.0068 | 21.0 | 21.0 | 8400.0 |
| 2012-05-03 07:58:00 | AAPL | Stock | 20.9964 | 20.9964 | 20.9932 | 20.9932 | 11200.0 |
| 2012-05-03 07:59:00 | AAPL | Stock | 20.9825 | 20.9825 | 20.9825 | 20.9825 | 2800.0 |
| 2012-05-03 08:00:00 | AAPL | Stock | 20.9861 | 21.0321 | 20.9379 | 20.9936 | 64120.0 |
| 2012-05-03 08:01:00 | AAPL | Stock | 20.9946 | 20.9996 | 20.9946 | 20.9996 | 30800.0 |
| 2012-05-03 08:02:00 | AAPL | Stock | 20.9989 | 21.0 | 20.9964 | 21.0 | 24780.0 |
| 2012-05-03 08:03:00 | AAPL | Stock | 20.9993 | 21.0036 | 20.9993 | 21.0 | 28980.0 |
| 2012-05-03 08:04:00 | AAPL | Stock | 21.0 | 21.0004 | 20.9732 | 20.9793 | 239708.0 |
| 2012-05-03 08:05:00 | AAPL | Stock | 20.9814 | 20.9814 | 20.975 | 20.9786 | 8400.0 |
> showing 50 of 1,005,018 rows — these rows as CSV