PREVIEW / stock_5min / 2018-09-26
file: by_date/stock_5min/2018/2018-09-26.parquet size: 5.7 MB rows: 358,296 symbols: 2,789
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-26 04:00:00 | AAPL | Stock | 55.675 | 55.745 | 55.675 | 55.745 | 872.0 |
| 2018-09-26 04:05:00 | AAPL | Stock | 55.6875 | 55.6875 | 55.6875 | 55.6875 | 400.0 |
| 2018-09-26 04:30:00 | AAPL | Stock | 55.7 | 55.7 | 55.7 | 55.7 | 2600.0 |
| 2018-09-26 04:35:00 | AAPL | Stock | 55.6775 | 55.6775 | 55.6775 | 55.6775 | 400.0 |
| 2018-09-26 04:40:00 | AAPL | Stock | 55.7375 | 55.7375 | 55.7375 | 55.7375 | 400.0 |
| 2018-09-26 05:00:00 | AAPL | Stock | 55.6625 | 55.6625 | 55.6625 | 55.6625 | 400.0 |
| 2018-09-26 05:25:00 | AAPL | Stock | 55.665 | 55.665 | 55.665 | 55.665 | 1600.0 |
| 2018-09-26 06:05:00 | AAPL | Stock | 55.7375 | 55.7475 | 55.7375 | 55.7425 | 1600.0 |
| 2018-09-26 06:15:00 | AAPL | Stock | 55.7475 | 55.7475 | 55.7475 | 55.7475 | 1800.0 |
| 2018-09-26 06:35:00 | AAPL | Stock | 55.7 | 55.7 | 55.7 | 55.7 | 400.0 |
| 2018-09-26 06:45:00 | AAPL | Stock | 55.695 | 55.7 | 55.58 | 55.58 | 18008.0 |
| 2018-09-26 06:50:00 | AAPL | Stock | 55.58 | 55.58 | 55.5075 | 55.5075 | 4400.0 |
| 2018-09-26 06:55:00 | AAPL | Stock | 55.495 | 55.495 | 55.495 | 55.495 | 400.0 |
| 2018-09-26 07:00:00 | AAPL | Stock | 55.4975 | 55.5725 | 55.4975 | 55.5075 | 34952.0 |
| 2018-09-26 07:05:00 | AAPL | Stock | 55.5075 | 55.53 | 55.5025 | 55.525 | 9312.0 |
| 2018-09-26 07:10:00 | AAPL | Stock | 55.525 | 55.57 | 55.525 | 55.57 | 1700.0 |
| 2018-09-26 07:15:00 | AAPL | Stock | 55.5375 | 55.56 | 55.47 | 55.515 | 25752.0 |
| 2018-09-26 07:20:00 | AAPL | Stock | 55.515 | 55.53 | 55.5125 | 55.53 | 6208.0 |
| 2018-09-26 07:25:00 | AAPL | Stock | 55.53 | 55.5325 | 55.505 | 55.505 | 2112.0 |
| 2018-09-26 07:30:00 | AAPL | Stock | 55.51 | 55.53 | 55.5 | 55.5025 | 8464.0 |
| 2018-09-26 07:35:00 | AAPL | Stock | 55.5 | 55.5 | 55.5 | 55.5 | 6112.0 |
| 2018-09-26 07:40:00 | AAPL | Stock | 55.52 | 55.5225 | 55.475 | 55.475 | 8876.0 |
| 2018-09-26 07:45:00 | AAPL | Stock | 55.4725 | 55.475 | 55.44 | 55.44 | 13628.0 |
| 2018-09-26 07:50:00 | AAPL | Stock | 55.4375 | 55.475 | 55.4125 | 55.475 | 20884.0 |
| 2018-09-26 07:55:00 | AAPL | Stock | 55.475 | 55.475 | 55.455 | 55.455 | 5064.0 |
| 2018-09-26 08:00:00 | AAPL | Stock | 55.5625 | 55.575 | 55.4325 | 55.4875 | 83820.0 |
| 2018-09-26 08:05:00 | AAPL | Stock | 55.4875 | 55.5 | 55.455 | 55.46 | 36052.0 |
| 2018-09-26 08:10:00 | AAPL | Stock | 55.4725 | 55.4725 | 55.44 | 55.47 | 9592.0 |
| 2018-09-26 08:15:00 | AAPL | Stock | 55.4675 | 55.5 | 55.4625 | 55.495 | 12608.0 |
| 2018-09-26 08:20:00 | AAPL | Stock | 55.495 | 55.535 | 55.4875 | 55.535 | 36252.0 |
| 2018-09-26 08:25:00 | AAPL | Stock | 55.5375 | 55.59 | 55.5375 | 55.575 | 30476.0 |
| 2018-09-26 08:30:00 | AAPL | Stock | 55.5725 | 55.575 | 55.5125 | 55.545 | 37356.0 |
| 2018-09-26 08:35:00 | AAPL | Stock | 55.5475 | 55.575 | 55.54 | 55.55 | 46324.0 |
| 2018-09-26 08:40:00 | AAPL | Stock | 55.54 | 55.5575 | 55.54 | 55.55 | 8000.0 |
| 2018-09-26 08:45:00 | AAPL | Stock | 55.55 | 55.55 | 55.55 | 55.55 | 5100.0 |
| 2018-09-26 08:50:00 | AAPL | Stock | 55.555 | 55.56 | 55.545 | 55.56 | 4400.0 |
| 2018-09-26 08:55:00 | AAPL | Stock | 55.545 | 55.55 | 55.5275 | 55.5375 | 17200.0 |
| 2018-09-26 09:00:00 | AAPL | Stock | 55.55 | 55.55 | 55.5 | 55.5 | 14888.0 |
| 2018-09-26 09:05:00 | AAPL | Stock | 55.5 | 55.5225 | 55.475 | 55.495 | 54752.0 |
| 2018-09-26 09:10:00 | AAPL | Stock | 55.4975 | 55.4975 | 55.4625 | 55.4775 | 9032.0 |
| 2018-09-26 09:15:00 | AAPL | Stock | 55.4925 | 55.4925 | 55.475 | 55.49 | 6804.0 |
| 2018-09-26 09:20:00 | AAPL | Stock | 55.4625 | 55.485 | 55.4525 | 55.4525 | 62096.0 |
| 2018-09-26 09:25:00 | AAPL | Stock | 55.45 | 55.45 | 55.25 | 55.2675 | 126772.0 |
| 2018-09-26 09:30:00 | AAPL | Stock | 55.25 | 55.685 | 55.25 | 55.6775 | 4386408.0 |
| 2018-09-26 09:35:00 | AAPL | Stock | 55.685 | 55.7038 | 55.43 | 55.47 | 1806600.0 |
| 2018-09-26 09:40:00 | AAPL | Stock | 55.4625 | 55.595 | 55.4575 | 55.585 | 1239536.0 |
| 2018-09-26 09:45:00 | AAPL | Stock | 55.5825 | 55.685 | 55.525 | 55.652 | 1191312.0 |
| 2018-09-26 09:50:00 | AAPL | Stock | 55.65 | 55.665 | 55.57 | 55.655 | 869956.0 |
| 2018-09-26 09:55:00 | AAPL | Stock | 55.6592 | 55.81 | 55.655 | 55.775 | 1905316.0 |
| 2018-09-26 10:00:00 | AAPL | Stock | 55.7775 | 55.9325 | 55.755 | 55.9225 | 1892280.0 |
> showing 50 of 358,296 rows — these rows as CSV