PREVIEW / stock_5min / 2018-09-11
file: by_date/stock_5min/2018/2018-09-11.parquet size: 5.6 MB rows: 359,886 symbols: 2,781
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 |
|---|---|---|---|---|---|---|---|
| 2018-09-11 04:30:00 | AAPL | Stock | 54.8425 | 54.8425 | 54.8425 | 54.8425 | 2700.0 |
| 2018-09-11 04:35:00 | AAPL | Stock | 54.8125 | 54.8125 | 54.8125 | 54.8125 | 2000.0 |
| 2018-09-11 04:40:00 | AAPL | Stock | 54.75 | 54.7725 | 54.75 | 54.7725 | 4032.0 |
| 2018-09-11 04:45:00 | AAPL | Stock | 54.75 | 54.75 | 54.725 | 54.725 | 5052.0 |
| 2018-09-11 04:50:00 | AAPL | Stock | 54.625 | 54.625 | 54.625 | 54.625 | 1200.0 |
| 2018-09-11 05:00:00 | AAPL | Stock | 54.65 | 54.65 | 54.6 | 54.6 | 3516.0 |
| 2018-09-11 05:05:00 | AAPL | Stock | 54.53 | 54.535 | 54.525 | 54.525 | 8192.0 |
| 2018-09-11 05:30:00 | AAPL | Stock | 54.575 | 54.575 | 54.575 | 54.575 | 400.0 |
| 2018-09-11 05:35:00 | AAPL | Stock | 54.6 | 54.6 | 54.6 | 54.6 | 1200.0 |
| 2018-09-11 05:40:00 | AAPL | Stock | 54.6 | 54.6 | 54.6 | 54.6 | 8000.0 |
| 2018-09-11 05:45:00 | AAPL | Stock | 54.6 | 54.6 | 54.6 | 54.6 | 2360.0 |
| 2018-09-11 05:50:00 | AAPL | Stock | 54.625 | 54.625 | 54.625 | 54.625 | 808.0 |
| 2018-09-11 06:00:00 | AAPL | Stock | 54.62 | 54.62 | 54.6025 | 54.6025 | 2756.0 |
| 2018-09-11 06:10:00 | AAPL | Stock | 54.64 | 54.64 | 54.64 | 54.64 | 780.0 |
| 2018-09-11 06:20:00 | AAPL | Stock | 54.7 | 54.8125 | 54.7 | 54.79 | 9144.0 |
| 2018-09-11 06:25:00 | AAPL | Stock | 54.7125 | 54.7125 | 54.7 | 54.7 | 6800.0 |
| 2018-09-11 06:30:00 | AAPL | Stock | 54.7 | 54.7 | 54.7 | 54.7 | 1200.0 |
| 2018-09-11 06:35:00 | AAPL | Stock | 54.6625 | 54.6625 | 54.625 | 54.6325 | 15268.0 |
| 2018-09-11 06:40:00 | AAPL | Stock | 54.625 | 54.625 | 54.625 | 54.625 | 1496.0 |
| 2018-09-11 06:55:00 | AAPL | Stock | 54.6875 | 54.7 | 54.6875 | 54.695 | 8472.0 |
| 2018-09-11 07:00:00 | AAPL | Stock | 54.7275 | 54.7275 | 54.6525 | 54.6525 | 21220.0 |
| 2018-09-11 07:05:00 | AAPL | Stock | 54.6725 | 54.675 | 54.65 | 54.65 | 17836.0 |
| 2018-09-11 07:10:00 | AAPL | Stock | 54.6375 | 54.6375 | 54.6275 | 54.6275 | 1200.0 |
| 2018-09-11 07:15:00 | AAPL | Stock | 54.625 | 54.625 | 54.6125 | 54.6125 | 5216.0 |
| 2018-09-11 07:20:00 | AAPL | Stock | 54.615 | 54.6325 | 54.5825 | 54.625 | 24636.0 |
| 2018-09-11 07:25:00 | AAPL | Stock | 54.625 | 54.625 | 54.5875 | 54.6175 | 21732.0 |
| 2018-09-11 07:30:00 | AAPL | Stock | 54.6275 | 54.66 | 54.55 | 54.55 | 20540.0 |
| 2018-09-11 07:35:00 | AAPL | Stock | 54.5625 | 54.5775 | 54.5625 | 54.5775 | 1400.0 |
| 2018-09-11 07:40:00 | AAPL | Stock | 54.59 | 54.6125 | 54.59 | 54.6125 | 16236.0 |
| 2018-09-11 07:45:00 | AAPL | Stock | 54.6 | 54.6 | 54.5825 | 54.5825 | 3552.0 |
| 2018-09-11 07:50:00 | AAPL | Stock | 54.6125 | 54.6125 | 54.59 | 54.59 | 2400.0 |
| 2018-09-11 07:55:00 | AAPL | Stock | 54.6225 | 54.645 | 54.6225 | 54.63 | 9160.0 |
| 2018-09-11 08:00:00 | AAPL | Stock | 54.675 | 54.75 | 54.55 | 54.59 | 89176.0 |
| 2018-09-11 08:05:00 | AAPL | Stock | 54.59 | 54.6 | 54.535 | 54.55 | 36672.0 |
| 2018-09-11 08:10:00 | AAPL | Stock | 54.54 | 54.5725 | 54.5 | 54.5075 | 19960.0 |
| 2018-09-11 08:15:00 | AAPL | Stock | 54.56 | 54.61 | 54.545 | 54.5975 | 11336.0 |
| 2018-09-11 08:20:00 | AAPL | Stock | 54.5802 | 54.61 | 54.5802 | 54.61 | 13916.0 |
| 2018-09-11 08:25:00 | AAPL | Stock | 54.6 | 54.625 | 54.5875 | 54.625 | 28308.0 |
| 2018-09-11 08:30:00 | AAPL | Stock | 54.61 | 54.625 | 54.6025 | 54.6225 | 21120.0 |
| 2018-09-11 08:35:00 | AAPL | Stock | 54.6175 | 54.6325 | 54.6175 | 54.6325 | 8552.0 |
| 2018-09-11 08:40:00 | AAPL | Stock | 54.6325 | 54.635 | 54.6 | 54.6 | 14912.0 |
| 2018-09-11 08:45:00 | AAPL | Stock | 54.6 | 54.6175 | 54.5875 | 54.6175 | 18068.0 |
| 2018-09-11 08:50:00 | AAPL | Stock | 54.6025 | 54.6025 | 54.5425 | 54.5775 | 32500.0 |
| 2018-09-11 08:55:00 | AAPL | Stock | 54.5875 | 54.5875 | 54.5 | 54.53 | 58368.0 |
| 2018-09-11 09:00:00 | AAPL | Stock | 54.5275 | 54.5625 | 54.5275 | 54.5625 | 5860.0 |
| 2018-09-11 09:05:00 | AAPL | Stock | 54.56 | 54.585 | 54.5 | 54.575 | 29008.0 |
| 2018-09-11 09:10:00 | AAPL | Stock | 54.5975 | 54.62 | 54.575 | 54.595 | 53296.0 |
| 2018-09-11 09:15:00 | AAPL | Stock | 54.5975 | 54.6 | 54.575 | 54.575 | 22360.0 |
| 2018-09-11 09:20:00 | AAPL | Stock | 54.575 | 54.575 | 54.5325 | 54.5325 | 29196.0 |
| 2018-09-11 09:25:00 | AAPL | Stock | 54.54 | 54.55 | 54.475 | 54.525 | 81504.0 |
> showing 50 of 359,886 rows — these rows as CSV