PREVIEW / stock_1min / 2012-10-24
file: by_date/stock_1min/2012/2012-10-24.parquet size: 12.1 MB rows: 901,900 symbols: 2,799
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-10-24 04:41:00 | AAPL | Stock | 21.9732 | 21.9732 | 21.9732 | 21.9732 | 2800.0 |
| 2012-10-24 04:47:00 | AAPL | Stock | 22.0536 | 22.0536 | 22.0536 | 22.0536 | 2800.0 |
| 2012-10-24 04:49:00 | AAPL | Stock | 22.04 | 22.04 | 22.04 | 22.04 | 5600.0 |
| 2012-10-24 06:03:00 | AAPL | Stock | 22.0357 | 22.0357 | 22.0357 | 22.0357 | 2800.0 |
| 2012-10-24 06:07:00 | AAPL | Stock | 22.0357 | 22.0357 | 22.0357 | 22.0357 | 2800.0 |
| 2012-10-24 06:14:00 | AAPL | Stock | 22.0286 | 22.0286 | 22.0286 | 22.0286 | 2800.0 |
| 2012-10-24 06:28:00 | AAPL | Stock | 22.0357 | 22.0357 | 22.0357 | 22.0357 | 5600.0 |
| 2012-10-24 06:29:00 | AAPL | Stock | 22.0357 | 22.0357 | 22.0357 | 22.0357 | 2800.0 |
| 2012-10-24 06:30:00 | AAPL | Stock | 22.0357 | 22.0357 | 22.0357 | 22.0357 | 5600.0 |
| 2012-10-24 06:32:00 | AAPL | Stock | 22.0379 | 22.0379 | 22.0379 | 22.0379 | 2800.0 |
| 2012-10-24 07:02:00 | AAPL | Stock | 22.0357 | 22.0357 | 22.0357 | 22.0357 | 3836.0 |
| 2012-10-24 07:03:00 | AAPL | Stock | 22.0357 | 22.0357 | 22.0357 | 22.0357 | 5600.0 |
| 2012-10-24 07:06:00 | AAPL | Stock | 22.0643 | 22.0643 | 22.0643 | 22.0643 | 3696.0 |
| 2012-10-24 07:09:00 | AAPL | Stock | 22.0832 | 22.0857 | 22.0832 | 22.0857 | 19600.0 |
| 2012-10-24 07:10:00 | AAPL | Stock | 22.0575 | 22.0693 | 22.0468 | 22.0693 | 31388.0 |
| 2012-10-24 07:11:00 | AAPL | Stock | 22.0643 | 22.0714 | 22.0643 | 22.0714 | 22400.0 |
| 2012-10-24 07:13:00 | AAPL | Stock | 22.0718 | 22.0718 | 22.0714 | 22.0714 | 7000.0 |
| 2012-10-24 07:14:00 | AAPL | Stock | 22.0643 | 22.0711 | 22.0575 | 22.0711 | 16800.0 |
| 2012-10-24 07:21:00 | AAPL | Stock | 22.0364 | 22.0364 | 22.0357 | 22.0357 | 21896.0 |
| 2012-10-24 07:23:00 | AAPL | Stock | 22.0446 | 22.0446 | 22.0357 | 22.0357 | 5600.0 |
| 2012-10-24 07:25:00 | AAPL | Stock | 22.0357 | 22.0357 | 22.0357 | 22.0357 | 2800.0 |
| 2012-10-24 07:31:00 | AAPL | Stock | 22.0375 | 22.0443 | 22.0214 | 22.0214 | 58100.0 |
| 2012-10-24 07:32:00 | AAPL | Stock | 22.0146 | 22.0586 | 22.0146 | 22.0393 | 30800.0 |
| 2012-10-24 07:33:00 | AAPL | Stock | 22.0357 | 22.0357 | 22.0357 | 22.0357 | 25256.0 |
| 2012-10-24 07:34:00 | AAPL | Stock | 22.0129 | 22.0129 | 21.9686 | 21.9818 | 119672.0 |
| 2012-10-24 07:35:00 | AAPL | Stock | 21.9696 | 21.9696 | 21.9507 | 21.9507 | 39200.0 |
| 2012-10-24 07:36:00 | AAPL | Stock | 21.9954 | 22.0064 | 21.9664 | 22.0064 | 35420.0 |
| 2012-10-24 07:37:00 | AAPL | Stock | 21.975 | 21.9857 | 21.9643 | 21.9732 | 56000.0 |
| 2012-10-24 07:39:00 | AAPL | Stock | 21.9804 | 21.9957 | 21.9804 | 21.9957 | 8400.0 |
| 2012-10-24 07:41:00 | AAPL | Stock | 21.9825 | 21.9825 | 21.9754 | 21.9821 | 14000.0 |
| 2012-10-24 07:42:00 | AAPL | Stock | 21.975 | 21.975 | 21.975 | 21.975 | 5600.0 |
| 2012-10-24 07:43:00 | AAPL | Stock | 21.975 | 21.9768 | 21.9557 | 21.9557 | 69888.0 |
| 2012-10-24 07:44:00 | AAPL | Stock | 21.9639 | 21.9639 | 21.9589 | 21.9589 | 7840.0 |
| 2012-10-24 07:45:00 | AAPL | Stock | 21.9554 | 21.9554 | 21.9554 | 21.9554 | 4032.0 |
| 2012-10-24 07:46:00 | AAPL | Stock | 21.95 | 21.9504 | 21.9464 | 21.9464 | 20720.0 |
| 2012-10-24 07:47:00 | AAPL | Stock | 21.9739 | 21.9739 | 21.9739 | 21.9739 | 2800.0 |
| 2012-10-24 07:50:00 | AAPL | Stock | 21.975 | 21.975 | 21.975 | 21.975 | 15400.0 |
| 2012-10-24 07:51:00 | AAPL | Stock | 21.9729 | 21.9821 | 21.9729 | 21.9814 | 34048.0 |
| 2012-10-24 07:52:00 | AAPL | Stock | 21.9821 | 21.9857 | 21.9818 | 21.9857 | 14000.0 |
| 2012-10-24 07:53:00 | AAPL | Stock | 21.9993 | 21.9993 | 21.9993 | 21.9993 | 2800.0 |
| 2012-10-24 07:54:00 | AAPL | Stock | 22.0082 | 22.0082 | 22.0082 | 22.0082 | 2800.0 |
| 2012-10-24 07:55:00 | AAPL | Stock | 22.0086 | 22.0086 | 22.0086 | 22.0086 | 14000.0 |
| 2012-10-24 07:57:00 | AAPL | Stock | 22.0139 | 22.0179 | 22.0139 | 22.0139 | 44716.0 |
| 2012-10-24 07:59:00 | AAPL | Stock | 22.0168 | 22.0189 | 22.0168 | 22.0189 | 14000.0 |
| 2012-10-24 08:00:00 | AAPL | Stock | 22.0189 | 22.0536 | 21.9536 | 22.0318 | 108136.0 |
| 2012-10-24 08:01:00 | AAPL | Stock | 22.035 | 22.035 | 22.0179 | 22.035 | 34412.0 |
| 2012-10-24 08:02:00 | AAPL | Stock | 22.0357 | 22.0429 | 22.0357 | 22.0429 | 106708.0 |
| 2012-10-24 08:03:00 | AAPL | Stock | 22.0429 | 22.0679 | 22.0375 | 22.0679 | 128968.0 |
| 2012-10-24 08:04:00 | AAPL | Stock | 22.0714 | 22.0786 | 22.0643 | 22.0671 | 109228.0 |
| 2012-10-24 08:05:00 | AAPL | Stock | 22.0711 | 22.0711 | 22.0536 | 22.0536 | 20132.0 |
> showing 50 of 901,900 rows — these rows as CSV