PREVIEW / stock_5min / 2015-02-12
file: by_date/stock_5min/2015/2015-02-12.parquet size: 5.4 MB rows: 353,121 symbols: 3,526
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 |
|---|---|---|---|---|---|---|---|
| 2015-02-12 04:00:00 | AAPL | Stock | 31.375 | 31.4375 | 31.375 | 31.4325 | 2400.0 |
| 2015-02-12 04:05:00 | AAPL | Stock | 31.4475 | 31.5 | 31.425 | 31.5 | 6300.0 |
| 2015-02-12 04:10:00 | AAPL | Stock | 31.4625 | 31.6225 | 31.4625 | 31.5625 | 27196.0 |
| 2015-02-12 04:15:00 | AAPL | Stock | 31.53 | 31.5375 | 31.53 | 31.5375 | 15288.0 |
| 2015-02-12 04:20:00 | AAPL | Stock | 31.5375 | 31.5975 | 31.5375 | 31.5975 | 47952.0 |
| 2015-02-12 04:25:00 | AAPL | Stock | 31.595 | 31.595 | 31.5475 | 31.5475 | 16800.0 |
| 2015-02-12 04:30:00 | AAPL | Stock | 31.5475 | 31.55 | 31.5475 | 31.55 | 6108.0 |
| 2015-02-12 04:35:00 | AAPL | Stock | 31.5375 | 31.5375 | 31.4775 | 31.4775 | 15680.0 |
| 2015-02-12 04:40:00 | AAPL | Stock | 31.5 | 31.515 | 31.5 | 31.5075 | 8028.0 |
| 2015-02-12 04:45:00 | AAPL | Stock | 31.5075 | 31.55 | 31.5075 | 31.54 | 9120.0 |
| 2015-02-12 04:50:00 | AAPL | Stock | 31.525 | 31.575 | 31.525 | 31.575 | 13340.0 |
| 2015-02-12 04:55:00 | AAPL | Stock | 31.5725 | 31.575 | 31.5475 | 31.57 | 23840.0 |
| 2015-02-12 05:00:00 | AAPL | Stock | 31.57 | 31.575 | 31.57 | 31.575 | 28000.0 |
| 2015-02-12 05:05:00 | AAPL | Stock | 31.595 | 31.595 | 31.525 | 31.535 | 28000.0 |
| 2015-02-12 05:10:00 | AAPL | Stock | 31.54 | 31.54 | 31.525 | 31.5375 | 22400.0 |
| 2015-02-12 05:15:00 | AAPL | Stock | 31.5375 | 31.5375 | 31.5125 | 31.5125 | 23200.0 |
| 2015-02-12 05:20:00 | AAPL | Stock | 31.52 | 31.5425 | 31.5125 | 31.52 | 8476.0 |
| 2015-02-12 05:25:00 | AAPL | Stock | 31.545 | 31.545 | 31.545 | 31.545 | 400.0 |
| 2015-02-12 05:30:00 | AAPL | Stock | 31.545 | 31.545 | 31.545 | 31.545 | 10072.0 |
| 2015-02-12 05:35:00 | AAPL | Stock | 31.545 | 31.55 | 31.545 | 31.55 | 9616.0 |
| 2015-02-12 05:40:00 | AAPL | Stock | 31.545 | 31.5625 | 31.545 | 31.5625 | 5960.0 |
| 2015-02-12 05:45:00 | AAPL | Stock | 31.5725 | 31.575 | 31.55 | 31.55 | 18060.0 |
| 2015-02-12 05:50:00 | AAPL | Stock | 31.565 | 31.575 | 31.565 | 31.565 | 6400.0 |
| 2015-02-12 05:55:00 | AAPL | Stock | 31.565 | 31.575 | 31.55 | 31.575 | 3884.0 |
| 2015-02-12 06:00:00 | AAPL | Stock | 31.5725 | 31.58 | 31.5725 | 31.58 | 19816.0 |
| 2015-02-12 06:05:00 | AAPL | Stock | 31.58 | 31.5975 | 31.575 | 31.5975 | 24436.0 |
| 2015-02-12 06:10:00 | AAPL | Stock | 31.58 | 31.58 | 31.55 | 31.55 | 35940.0 |
| 2015-02-12 06:15:00 | AAPL | Stock | 31.55 | 31.5625 | 31.5375 | 31.5375 | 30764.0 |
| 2015-02-12 06:20:00 | AAPL | Stock | 31.5375 | 31.5375 | 31.5 | 31.5 | 47380.0 |
| 2015-02-12 06:25:00 | AAPL | Stock | 31.5075 | 31.535 | 31.5 | 31.535 | 43640.0 |
| 2015-02-12 06:30:00 | AAPL | Stock | 31.505 | 31.5875 | 31.505 | 31.535 | 21176.0 |
| 2015-02-12 06:35:00 | AAPL | Stock | 31.515 | 31.5225 | 31.5 | 31.51 | 16500.0 |
| 2015-02-12 06:40:00 | AAPL | Stock | 31.5275 | 31.5375 | 31.5025 | 31.52 | 9540.0 |
| 2015-02-12 06:45:00 | AAPL | Stock | 31.51 | 31.51 | 31.51 | 31.51 | 2644.0 |
| 2015-02-12 06:50:00 | AAPL | Stock | 31.51 | 31.515 | 31.5 | 31.5 | 14300.0 |
| 2015-02-12 06:55:00 | AAPL | Stock | 31.515 | 31.515 | 31.4975 | 31.5075 | 13600.0 |
| 2015-02-12 07:00:00 | AAPL | Stock | 31.5 | 31.5075 | 31.475 | 31.475 | 46940.0 |
| 2015-02-12 07:05:00 | AAPL | Stock | 31.4725 | 31.48 | 31.45 | 31.48 | 42700.0 |
| 2015-02-12 07:10:00 | AAPL | Stock | 31.475 | 31.475 | 31.45 | 31.4625 | 50440.0 |
| 2015-02-12 07:15:00 | AAPL | Stock | 31.4625 | 31.475 | 31.4575 | 31.4625 | 19288.0 |
| 2015-02-12 07:20:00 | AAPL | Stock | 31.4625 | 31.485 | 31.46 | 31.485 | 33940.0 |
| 2015-02-12 07:25:00 | AAPL | Stock | 31.485 | 31.485 | 31.475 | 31.485 | 19244.0 |
| 2015-02-12 07:30:00 | AAPL | Stock | 31.48 | 31.48 | 31.4275 | 31.4375 | 50284.0 |
| 2015-02-12 07:35:00 | AAPL | Stock | 31.435 | 31.45 | 31.4125 | 31.45 | 30112.0 |
| 2015-02-12 07:40:00 | AAPL | Stock | 31.4625 | 31.4625 | 31.45 | 31.4525 | 19140.0 |
| 2015-02-12 07:45:00 | AAPL | Stock | 31.45 | 31.4625 | 31.45 | 31.4625 | 47992.0 |
| 2015-02-12 07:50:00 | AAPL | Stock | 31.4625 | 31.5 | 31.4625 | 31.5 | 50176.0 |
| 2015-02-12 07:55:00 | AAPL | Stock | 31.485 | 31.52 | 31.48 | 31.52 | 72576.0 |
| 2015-02-12 08:00:00 | AAPL | Stock | 31.51 | 31.575 | 31.2 | 31.545 | 559876.0 |
| 2015-02-12 08:05:00 | AAPL | Stock | 31.545 | 31.545 | 31.4875 | 31.525 | 326004.0 |
> showing 50 of 353,121 rows — these rows as CSV