PREVIEW / stock_5min / 2016-08-31
file: by_date/stock_5min/2016/2016-08-31.parquet size: 5.3 MB rows: 348,886 symbols: 3,269
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 |
|---|---|---|---|---|---|---|---|
| 2016-08-31 04:00:00 | AAPL | Stock | 26.48 | 26.48 | 26.48 | 26.48 | 800.0 |
| 2016-08-31 04:30:00 | AAPL | Stock | 26.455 | 26.455 | 26.455 | 26.455 | 488.0 |
| 2016-08-31 04:35:00 | AAPL | Stock | 26.455 | 26.455 | 26.455 | 26.455 | 20000.0 |
| 2016-08-31 05:15:00 | AAPL | Stock | 26.4825 | 26.4875 | 26.4825 | 26.4875 | 1616.0 |
| 2016-08-31 05:25:00 | AAPL | Stock | 26.4975 | 26.4975 | 26.4975 | 26.4975 | 400.0 |
| 2016-08-31 05:35:00 | AAPL | Stock | 26.4825 | 26.4825 | 26.4825 | 26.4825 | 400.0 |
| 2016-08-31 05:40:00 | AAPL | Stock | 26.4925 | 26.5 | 26.4925 | 26.5 | 6548.0 |
| 2016-08-31 05:50:00 | AAPL | Stock | 26.545 | 26.5525 | 26.545 | 26.55 | 14400.0 |
| 2016-08-31 05:55:00 | AAPL | Stock | 26.525 | 26.525 | 26.525 | 26.525 | 1200.0 |
| 2016-08-31 06:20:00 | AAPL | Stock | 26.4875 | 26.4875 | 26.4875 | 26.4875 | 432.0 |
| 2016-08-31 06:30:00 | AAPL | Stock | 26.4825 | 26.4825 | 26.4825 | 26.4825 | 6000.0 |
| 2016-08-31 06:45:00 | AAPL | Stock | 26.5 | 26.5 | 26.5 | 26.5 | 800.0 |
| 2016-08-31 06:50:00 | AAPL | Stock | 26.5125 | 26.5125 | 26.5125 | 26.5125 | 400.0 |
| 2016-08-31 07:00:00 | AAPL | Stock | 26.505 | 26.505 | 26.505 | 26.505 | 800.0 |
| 2016-08-31 07:05:00 | AAPL | Stock | 26.5125 | 26.5125 | 26.51 | 26.51 | 812.0 |
| 2016-08-31 07:10:00 | AAPL | Stock | 26.5075 | 26.5125 | 26.5075 | 26.5125 | 4848.0 |
| 2016-08-31 07:15:00 | AAPL | Stock | 26.525 | 26.525 | 26.525 | 26.525 | 1600.0 |
| 2016-08-31 07:30:00 | AAPL | Stock | 26.525 | 26.525 | 26.525 | 26.525 | 7524.0 |
| 2016-08-31 07:35:00 | AAPL | Stock | 26.5375 | 26.5375 | 26.5375 | 26.5375 | 400.0 |
| 2016-08-31 07:40:00 | AAPL | Stock | 26.5375 | 26.5375 | 26.5375 | 26.5375 | 800.0 |
| 2016-08-31 07:45:00 | AAPL | Stock | 26.525 | 26.525 | 26.525 | 26.525 | 400.0 |
| 2016-08-31 07:50:00 | AAPL | Stock | 26.5275 | 26.5275 | 26.5275 | 26.5275 | 400.0 |
| 2016-08-31 07:55:00 | AAPL | Stock | 26.54 | 26.54 | 26.54 | 26.54 | 400.0 |
| 2016-08-31 08:00:00 | AAPL | Stock | 26.5375 | 26.5375 | 26.5125 | 26.53 | 18896.0 |
| 2016-08-31 08:05:00 | AAPL | Stock | 26.5375 | 26.55 | 26.5375 | 26.55 | 10200.0 |
| 2016-08-31 08:10:00 | AAPL | Stock | 26.55 | 26.5525 | 26.5475 | 26.5525 | 3200.0 |
| 2016-08-31 08:15:00 | AAPL | Stock | 26.5525 | 26.5525 | 26.5325 | 26.5375 | 6460.0 |
| 2016-08-31 08:20:00 | AAPL | Stock | 26.53 | 26.53 | 26.5125 | 26.5125 | 16960.0 |
| 2016-08-31 08:25:00 | AAPL | Stock | 26.5125 | 26.5225 | 26.5025 | 26.5225 | 19864.0 |
| 2016-08-31 08:30:00 | AAPL | Stock | 26.51 | 26.51 | 26.51 | 26.51 | 400.0 |
| 2016-08-31 08:35:00 | AAPL | Stock | 26.5225 | 26.532 | 26.5 | 26.5075 | 13720.0 |
| 2016-08-31 08:40:00 | AAPL | Stock | 26.505 | 26.5175 | 26.5 | 26.515 | 20000.0 |
| 2016-08-31 08:45:00 | AAPL | Stock | 26.5025 | 26.5025 | 26.5 | 26.5 | 8800.0 |
| 2016-08-31 08:50:00 | AAPL | Stock | 26.5 | 26.51 | 26.4825 | 26.4825 | 35788.0 |
| 2016-08-31 08:55:00 | AAPL | Stock | 26.485 | 26.49 | 26.475 | 26.475 | 25868.0 |
| 2016-08-31 09:00:00 | AAPL | Stock | 26.475 | 26.475 | 26.4625 | 26.4625 | 7200.0 |
| 2016-08-31 09:05:00 | AAPL | Stock | 26.4725 | 26.5075 | 26.4725 | 26.5 | 21996.0 |
| 2016-08-31 09:10:00 | AAPL | Stock | 26.5 | 26.5025 | 26.5 | 26.5 | 9000.0 |
| 2016-08-31 09:15:00 | AAPL | Stock | 26.5 | 26.5 | 26.4925 | 26.4925 | 21232.0 |
| 2016-08-31 09:20:00 | AAPL | Stock | 26.4925 | 26.4925 | 26.49 | 26.49 | 7156.0 |
| 2016-08-31 09:25:00 | AAPL | Stock | 26.475 | 26.475 | 26.415 | 26.42 | 121976.0 |
| 2016-08-31 09:30:00 | AAPL | Stock | 26.4175 | 26.555 | 26.41 | 26.5125 | 4481204.0 |
| 2016-08-31 09:35:00 | AAPL | Stock | 26.515 | 26.555 | 26.5075 | 26.535 | 2169944.0 |
| 2016-08-31 09:40:00 | AAPL | Stock | 26.5375 | 26.5975 | 26.535 | 26.565 | 1740092.0 |
| 2016-08-31 09:45:00 | AAPL | Stock | 26.565 | 26.5725 | 26.53 | 26.5575 | 1445616.0 |
| 2016-08-31 09:50:00 | AAPL | Stock | 26.5575 | 26.57 | 26.545 | 26.565 | 1743620.0 |
| 2016-08-31 09:55:00 | AAPL | Stock | 26.565 | 26.6 | 26.56 | 26.5875 | 1881480.0 |
| 2016-08-31 10:00:00 | AAPL | Stock | 26.59 | 26.6162 | 26.5725 | 26.5925 | 1509220.0 |
| 2016-08-31 10:05:00 | AAPL | Stock | 26.595 | 26.6038 | 26.56 | 26.5712 | 906488.0 |
| 2016-08-31 10:10:00 | AAPL | Stock | 26.57 | 26.5725 | 26.535 | 26.5488 | 1431992.0 |
> showing 50 of 348,886 rows — these rows as CSV