PREVIEW / stock_5min / 2018-05-04
file: by_date/stock_5min/2018/2018-05-04.parquet size: 5.5 MB rows: 351,981 symbols: 2,842
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-05-04 04:00:00 | AAPL | Stock | 44.375 | 44.4975 | 44.375 | 44.45 | 3600.0 |
| 2018-05-04 04:05:00 | AAPL | Stock | 44.45 | 44.45 | 44.4125 | 44.4125 | 1512.0 |
| 2018-05-04 04:10:00 | AAPL | Stock | 44.48 | 44.48 | 44.3875 | 44.3875 | 4800.0 |
| 2018-05-04 04:15:00 | AAPL | Stock | 44.4125 | 44.4125 | 44.4125 | 44.4125 | 400.0 |
| 2018-05-04 04:20:00 | AAPL | Stock | 44.3875 | 44.3875 | 44.375 | 44.375 | 2100.0 |
| 2018-05-04 04:25:00 | AAPL | Stock | 44.3675 | 44.435 | 44.3675 | 44.375 | 10052.0 |
| 2018-05-04 04:30:00 | AAPL | Stock | 44.4125 | 44.4125 | 44.4125 | 44.4125 | 400.0 |
| 2018-05-04 04:35:00 | AAPL | Stock | 44.4025 | 44.4025 | 44.4025 | 44.4025 | 800.0 |
| 2018-05-04 04:40:00 | AAPL | Stock | 44.435 | 44.435 | 44.375 | 44.375 | 5284.0 |
| 2018-05-04 04:50:00 | AAPL | Stock | 44.375 | 44.545 | 44.37 | 44.4375 | 22732.0 |
| 2018-05-04 05:05:00 | AAPL | Stock | 44.4125 | 44.4125 | 44.4125 | 44.4125 | 3552.0 |
| 2018-05-04 05:20:00 | AAPL | Stock | 44.425 | 44.435 | 44.425 | 44.435 | 2400.0 |
| 2018-05-04 05:25:00 | AAPL | Stock | 44.435 | 44.4375 | 44.435 | 44.4375 | 3668.0 |
| 2018-05-04 05:30:00 | AAPL | Stock | 44.405 | 44.435 | 44.405 | 44.435 | 2068.0 |
| 2018-05-04 05:40:00 | AAPL | Stock | 44.4125 | 44.425 | 44.4125 | 44.425 | 800.0 |
| 2018-05-04 05:45:00 | AAPL | Stock | 44.4375 | 44.4375 | 44.43 | 44.43 | 4800.0 |
| 2018-05-04 05:50:00 | AAPL | Stock | 44.425 | 44.425 | 44.425 | 44.425 | 1200.0 |
| 2018-05-04 05:55:00 | AAPL | Stock | 44.4525 | 44.475 | 44.4525 | 44.4525 | 6200.0 |
| 2018-05-04 06:00:00 | AAPL | Stock | 44.4625 | 44.4725 | 44.4625 | 44.4725 | 2424.0 |
| 2018-05-04 06:05:00 | AAPL | Stock | 44.47 | 44.5125 | 44.47 | 44.5125 | 8576.0 |
| 2018-05-04 06:15:00 | AAPL | Stock | 44.55 | 44.55 | 44.5375 | 44.5375 | 6096.0 |
| 2018-05-04 06:20:00 | AAPL | Stock | 44.55 | 44.5575 | 44.5325 | 44.5575 | 8804.0 |
| 2018-05-04 06:25:00 | AAPL | Stock | 44.555 | 44.595 | 44.55 | 44.595 | 18940.0 |
| 2018-05-04 06:30:00 | AAPL | Stock | 44.595 | 44.65 | 44.575 | 44.65 | 16508.0 |
| 2018-05-04 06:35:00 | AAPL | Stock | 44.65 | 44.7 | 44.65 | 44.7 | 66584.0 |
| 2018-05-04 06:45:00 | AAPL | Stock | 44.7 | 44.7375 | 44.695 | 44.7375 | 17712.0 |
| 2018-05-04 06:50:00 | AAPL | Stock | 44.7 | 44.725 | 44.695 | 44.695 | 14372.0 |
| 2018-05-04 06:55:00 | AAPL | Stock | 44.6875 | 44.6875 | 44.675 | 44.6775 | 5600.0 |
| 2018-05-04 07:00:00 | AAPL | Stock | 44.675 | 44.8175 | 44.6575 | 44.7775 | 182780.0 |
| 2018-05-04 07:05:00 | AAPL | Stock | 44.7875 | 44.7975 | 44.715 | 44.725 | 74032.0 |
| 2018-05-04 07:10:00 | AAPL | Stock | 44.725 | 44.7275 | 44.6875 | 44.695 | 34972.0 |
| 2018-05-04 07:15:00 | AAPL | Stock | 44.6875 | 44.6875 | 44.64 | 44.665 | 32516.0 |
| 2018-05-04 07:20:00 | AAPL | Stock | 44.665 | 44.675 | 44.6375 | 44.65 | 47100.0 |
| 2018-05-04 07:25:00 | AAPL | Stock | 44.65 | 44.6725 | 44.6475 | 44.6525 | 29600.0 |
| 2018-05-04 07:30:00 | AAPL | Stock | 44.675 | 44.775 | 44.675 | 44.775 | 43768.0 |
| 2018-05-04 07:35:00 | AAPL | Stock | 44.775 | 44.775 | 44.725 | 44.725 | 46780.0 |
| 2018-05-04 07:40:00 | AAPL | Stock | 44.73 | 44.73 | 44.67 | 44.67 | 18392.0 |
| 2018-05-04 07:45:00 | AAPL | Stock | 44.675 | 44.72 | 44.675 | 44.7125 | 11000.0 |
| 2018-05-04 07:50:00 | AAPL | Stock | 44.7225 | 44.725 | 44.7125 | 44.725 | 11540.0 |
| 2018-05-04 07:55:00 | AAPL | Stock | 44.7125 | 44.7225 | 44.6625 | 44.7 | 57208.0 |
| 2018-05-04 08:00:00 | AAPL | Stock | 44.7025 | 44.8175 | 44.65 | 44.7475 | 255600.0 |
| 2018-05-04 08:05:00 | AAPL | Stock | 44.7475 | 44.7875 | 44.7 | 44.7 | 180736.0 |
| 2018-05-04 08:10:00 | AAPL | Stock | 44.7 | 44.7125 | 44.6875 | 44.695 | 45480.0 |
| 2018-05-04 08:15:00 | AAPL | Stock | 44.675 | 44.7125 | 44.6525 | 44.675 | 71828.0 |
| 2018-05-04 08:20:00 | AAPL | Stock | 44.675 | 44.675 | 44.625 | 44.6725 | 86668.0 |
| 2018-05-04 08:25:00 | AAPL | Stock | 44.685 | 44.71 | 44.685 | 44.7 | 37444.0 |
| 2018-05-04 08:30:00 | AAPL | Stock | 44.7075 | 44.7875 | 44.675 | 44.745 | 219540.0 |
| 2018-05-04 08:35:00 | AAPL | Stock | 44.75 | 44.775 | 44.705 | 44.725 | 71624.0 |
| 2018-05-04 08:40:00 | AAPL | Stock | 44.7125 | 44.715 | 44.625 | 44.7 | 194680.0 |
| 2018-05-04 08:45:00 | AAPL | Stock | 44.7 | 44.75 | 44.7 | 44.7375 | 70424.0 |
> showing 50 of 351,981 rows — these rows as CSV