PREVIEW / stock_5min / 2013-08-30
file: by_date/stock_5min/2013/2013-08-30.parquet size: 5.0 MB rows: 335,016 symbols: 3,486
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 |
|---|---|---|---|---|---|---|---|
| 2013-08-30 04:25:00 | AAPL | Stock | 17.5893 | 17.5893 | 17.5893 | 17.5893 | 8400.0 |
| 2013-08-30 05:25:00 | AAPL | Stock | 17.5864 | 17.5864 | 17.5864 | 17.5864 | 3360.0 |
| 2013-08-30 05:45:00 | AAPL | Stock | 17.6071 | 17.6071 | 17.6071 | 17.6071 | 2800.0 |
| 2013-08-30 07:10:00 | AAPL | Stock | 17.6107 | 17.6321 | 17.6107 | 17.6321 | 28896.0 |
| 2013-08-30 07:15:00 | AAPL | Stock | 17.6357 | 17.6393 | 17.625 | 17.625 | 40852.0 |
| 2013-08-30 07:20:00 | AAPL | Stock | 17.625 | 17.625 | 17.625 | 17.625 | 28700.0 |
| 2013-08-30 07:25:00 | AAPL | Stock | 17.6107 | 17.6107 | 17.6089 | 17.6089 | 6188.0 |
| 2013-08-30 07:30:00 | AAPL | Stock | 17.5861 | 17.5861 | 17.5714 | 17.5843 | 36708.0 |
| 2013-08-30 07:35:00 | AAPL | Stock | 17.5804 | 17.5804 | 17.5804 | 17.5804 | 9016.0 |
| 2013-08-30 07:45:00 | AAPL | Stock | 17.5804 | 17.5804 | 17.5714 | 17.5714 | 8400.0 |
| 2013-08-30 07:50:00 | AAPL | Stock | 17.5929 | 17.6036 | 17.5929 | 17.5964 | 47040.0 |
| 2013-08-30 07:55:00 | AAPL | Stock | 17.6014 | 17.6036 | 17.6014 | 17.6036 | 17640.0 |
| 2013-08-30 08:00:00 | AAPL | Stock | 17.6018 | 17.625 | 17.5846 | 17.6032 | 76972.0 |
| 2013-08-30 08:05:00 | AAPL | Stock | 17.6032 | 17.6068 | 17.5929 | 17.5929 | 137172.0 |
| 2013-08-30 08:10:00 | AAPL | Stock | 17.6036 | 17.6061 | 17.6036 | 17.6036 | 51800.0 |
| 2013-08-30 08:15:00 | AAPL | Stock | 17.5961 | 17.6 | 17.5961 | 17.5964 | 71176.0 |
| 2013-08-30 08:20:00 | AAPL | Stock | 17.5964 | 17.6036 | 17.5893 | 17.5911 | 305564.0 |
| 2013-08-30 08:25:00 | AAPL | Stock | 17.6007 | 17.6007 | 17.5907 | 17.5914 | 31024.0 |
| 2013-08-30 08:30:00 | AAPL | Stock | 17.5954 | 17.5982 | 17.5954 | 17.5964 | 30800.0 |
| 2013-08-30 08:35:00 | AAPL | Stock | 17.5993 | 17.5993 | 17.5814 | 17.5814 | 151200.0 |
| 2013-08-30 08:40:00 | AAPL | Stock | 17.5814 | 17.5904 | 17.5732 | 17.5739 | 80472.0 |
| 2013-08-30 08:45:00 | AAPL | Stock | 17.5796 | 17.5829 | 17.5786 | 17.5786 | 89600.0 |
| 2013-08-30 08:50:00 | AAPL | Stock | 17.5786 | 17.5821 | 17.575 | 17.5779 | 72968.0 |
| 2013-08-30 08:55:00 | AAPL | Stock | 17.5796 | 17.5811 | 17.5757 | 17.5811 | 49672.0 |
| 2013-08-30 09:00:00 | AAPL | Stock | 17.5864 | 17.5964 | 17.5821 | 17.5821 | 74172.0 |
| 2013-08-30 09:05:00 | AAPL | Stock | 17.5875 | 17.5893 | 17.5829 | 17.5893 | 38584.0 |
| 2013-08-30 09:10:00 | AAPL | Stock | 17.5893 | 17.5946 | 17.5889 | 17.59 | 44100.0 |
| 2013-08-30 09:15:00 | AAPL | Stock | 17.5921 | 17.595 | 17.5921 | 17.5929 | 28000.0 |
| 2013-08-30 09:20:00 | AAPL | Stock | 17.5964 | 17.5982 | 17.5911 | 17.5964 | 119616.0 |
| 2013-08-30 09:25:00 | AAPL | Stock | 17.5911 | 17.5911 | 17.5714 | 17.5714 | 19936.0 |
| 2013-08-30 09:30:00 | AAPL | Stock | 17.5714 | 17.6054 | 17.5464 | 17.5764 | 8986180.0 |
| 2013-08-30 09:35:00 | AAPL | Stock | 17.5768 | 17.5768 | 17.5125 | 17.5278 | 7752136.0 |
| 2013-08-30 09:40:00 | AAPL | Stock | 17.5261 | 17.545 | 17.5179 | 17.5195 | 5320896.0 |
| 2013-08-30 09:45:00 | AAPL | Stock | 17.5211 | 17.5664 | 17.5143 | 17.5161 | 10818052.0 |
| 2013-08-30 09:50:00 | AAPL | Stock | 17.5186 | 17.5589 | 17.515 | 17.5421 | 5015640.0 |
| 2013-08-30 09:55:00 | AAPL | Stock | 17.5436 | 17.5573 | 17.5279 | 17.5404 | 2773764.0 |
| 2013-08-30 10:00:00 | AAPL | Stock | 17.5404 | 17.5404 | 17.4643 | 17.4646 | 7124040.0 |
| 2013-08-30 10:05:00 | AAPL | Stock | 17.4646 | 17.4818 | 17.4468 | 17.4618 | 6728988.0 |
| 2013-08-30 10:10:00 | AAPL | Stock | 17.4571 | 17.4714 | 17.4411 | 17.4411 | 5519836.0 |
| 2013-08-30 10:15:00 | AAPL | Stock | 17.4411 | 17.4596 | 17.4214 | 17.4568 | 6083308.0 |
| 2013-08-30 10:20:00 | AAPL | Stock | 17.4536 | 17.4714 | 17.4397 | 17.4457 | 4527992.0 |
| 2013-08-30 10:25:00 | AAPL | Stock | 17.4482 | 17.4682 | 17.4314 | 17.4457 | 4106452.0 |
| 2013-08-30 10:30:00 | AAPL | Stock | 17.4446 | 17.4918 | 17.4432 | 17.4779 | 4918088.0 |
| 2013-08-30 10:35:00 | AAPL | Stock | 17.481 | 17.5036 | 17.4771 | 17.4879 | 4913720.0 |
| 2013-08-30 10:40:00 | AAPL | Stock | 17.4891 | 17.4936 | 17.4561 | 17.4604 | 3262224.0 |
| 2013-08-30 10:45:00 | AAPL | Stock | 17.4582 | 17.4582 | 17.4321 | 17.4446 | 2959208.0 |
| 2013-08-30 10:50:00 | AAPL | Stock | 17.443 | 17.4461 | 17.4111 | 17.4129 | 4120508.0 |
| 2013-08-30 10:55:00 | AAPL | Stock | 17.4129 | 17.4357 | 17.4129 | 17.4218 | 2409848.0 |
| 2013-08-30 11:00:00 | AAPL | Stock | 17.42 | 17.4407 | 17.3936 | 17.4354 | 4118772.0 |
| 2013-08-30 11:05:00 | AAPL | Stock | 17.435 | 17.4514 | 17.4304 | 17.4414 | 2576504.0 |
> showing 50 of 335,016 rows — these rows as CSV