PREVIEW / stock_5min / 2018-10-10
file: by_date/stock_5min/2018/2018-10-10.parquet size: 6.0 MB rows: 371,152 symbols: 2,797
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-10-10 04:00:00 | AAPL | Stock | 56.78 | 56.78 | 56.78 | 56.78 | 520.0 |
| 2018-10-10 04:05:00 | AAPL | Stock | 56.7125 | 56.78 | 56.7125 | 56.78 | 9080.0 |
| 2018-10-10 04:10:00 | AAPL | Stock | 56.735 | 56.735 | 56.735 | 56.735 | 4800.0 |
| 2018-10-10 04:15:00 | AAPL | Stock | 56.7125 | 56.7125 | 56.7125 | 56.7125 | 1920.0 |
| 2018-10-10 04:50:00 | AAPL | Stock | 56.7 | 56.7 | 56.7 | 56.7 | 1200.0 |
| 2018-10-10 05:00:00 | AAPL | Stock | 56.735 | 56.75 | 56.735 | 56.75 | 4040.0 |
| 2018-10-10 05:25:00 | AAPL | Stock | 56.705 | 56.7075 | 56.7 | 56.705 | 6064.0 |
| 2018-10-10 05:50:00 | AAPL | Stock | 56.705 | 56.705 | 56.705 | 56.705 | 400.0 |
| 2018-10-10 06:00:00 | AAPL | Stock | 56.7175 | 56.7175 | 56.7175 | 56.7175 | 624.0 |
| 2018-10-10 06:05:00 | AAPL | Stock | 56.7175 | 56.7175 | 56.7175 | 56.7175 | 3128.0 |
| 2018-10-10 06:15:00 | AAPL | Stock | 56.7175 | 56.7175 | 56.7175 | 56.7175 | 1840.0 |
| 2018-10-10 06:20:00 | AAPL | Stock | 56.7175 | 56.7175 | 56.7175 | 56.7175 | 400.0 |
| 2018-10-10 06:25:00 | AAPL | Stock | 56.7175 | 56.7175 | 56.7175 | 56.7175 | 608.0 |
| 2018-10-10 07:00:00 | AAPL | Stock | 56.725 | 56.725 | 56.655 | 56.7075 | 16656.0 |
| 2018-10-10 07:05:00 | AAPL | Stock | 56.6875 | 56.7075 | 56.6875 | 56.7075 | 6000.0 |
| 2018-10-10 07:10:00 | AAPL | Stock | 56.72 | 56.7425 | 56.72 | 56.735 | 6520.0 |
| 2018-10-10 07:15:00 | AAPL | Stock | 56.7375 | 56.7825 | 56.7375 | 56.7825 | 17640.0 |
| 2018-10-10 07:20:00 | AAPL | Stock | 56.8125 | 56.84 | 56.7675 | 56.84 | 47684.0 |
| 2018-10-10 07:25:00 | AAPL | Stock | 56.8575 | 56.8575 | 56.8575 | 56.8575 | 20340.0 |
| 2018-10-10 07:30:00 | AAPL | Stock | 56.855 | 56.855 | 56.7625 | 56.7625 | 21012.0 |
| 2018-10-10 07:35:00 | AAPL | Stock | 56.7575 | 56.77 | 56.7375 | 56.74 | 16592.0 |
| 2018-10-10 07:40:00 | AAPL | Stock | 56.75 | 56.75 | 56.7475 | 56.7475 | 984.0 |
| 2018-10-10 07:45:00 | AAPL | Stock | 56.7375 | 56.7375 | 56.69 | 56.7 | 14088.0 |
| 2018-10-10 07:50:00 | AAPL | Stock | 56.705 | 56.705 | 56.575 | 56.575 | 15516.0 |
| 2018-10-10 07:55:00 | AAPL | Stock | 56.6125 | 56.6475 | 56.6125 | 56.625 | 7040.0 |
| 2018-10-10 08:00:00 | AAPL | Stock | 56.745 | 56.87 | 56.53 | 56.56 | 145728.0 |
| 2018-10-10 08:05:00 | AAPL | Stock | 56.56 | 56.5625 | 56.5 | 56.5325 | 58932.0 |
| 2018-10-10 08:10:00 | AAPL | Stock | 56.5425 | 56.56 | 56.53 | 56.5575 | 13440.0 |
| 2018-10-10 08:15:00 | AAPL | Stock | 56.555 | 56.575 | 56.525 | 56.5325 | 12896.0 |
| 2018-10-10 08:20:00 | AAPL | Stock | 56.575 | 56.605 | 56.5125 | 56.5125 | 25496.0 |
| 2018-10-10 08:25:00 | AAPL | Stock | 56.5125 | 56.5125 | 56.375 | 56.495 | 41580.0 |
| 2018-10-10 08:30:00 | AAPL | Stock | 56.5125 | 56.5125 | 56.375 | 56.4025 | 56652.0 |
| 2018-10-10 08:35:00 | AAPL | Stock | 56.4175 | 56.475 | 56.41 | 56.425 | 26376.0 |
| 2018-10-10 08:40:00 | AAPL | Stock | 56.425 | 56.45 | 56.425 | 56.4375 | 22736.0 |
| 2018-10-10 08:45:00 | AAPL | Stock | 56.4425 | 56.4925 | 56.425 | 56.49 | 8980.0 |
| 2018-10-10 08:50:00 | AAPL | Stock | 56.475 | 56.475 | 56.4125 | 56.4225 | 20140.0 |
| 2018-10-10 08:55:00 | AAPL | Stock | 56.46 | 56.47 | 56.4375 | 56.47 | 7600.0 |
| 2018-10-10 09:00:00 | AAPL | Stock | 56.475 | 56.5 | 56.405 | 56.405 | 65356.0 |
| 2018-10-10 09:05:00 | AAPL | Stock | 56.4075 | 56.475 | 56.3875 | 56.415 | 23000.0 |
| 2018-10-10 09:10:00 | AAPL | Stock | 56.4275 | 56.46 | 56.4125 | 56.4575 | 39908.0 |
| 2018-10-10 09:15:00 | AAPL | Stock | 56.44 | 56.475 | 56.4175 | 56.475 | 24544.0 |
| 2018-10-10 09:20:00 | AAPL | Stock | 56.495 | 56.4975 | 56.4425 | 56.4425 | 14812.0 |
| 2018-10-10 09:25:00 | AAPL | Stock | 56.445 | 56.4625 | 56.32 | 56.345 | 51172.0 |
| 2018-10-10 09:30:00 | AAPL | Stock | 56.3425 | 56.5875 | 56.3425 | 56.4675 | 3109344.0 |
| 2018-10-10 09:35:00 | AAPL | Stock | 56.465 | 56.5 | 56.0625 | 56.1225 | 2598664.0 |
| 2018-10-10 09:40:00 | AAPL | Stock | 56.1262 | 56.4125 | 56.12 | 56.2225 | 2024864.0 |
| 2018-10-10 09:45:00 | AAPL | Stock | 56.2275 | 56.33 | 56.075 | 56.0775 | 1605076.0 |
| 2018-10-10 09:50:00 | AAPL | Stock | 56.0845 | 56.0875 | 55.8575 | 55.905 | 2682048.0 |
| 2018-10-10 09:55:00 | AAPL | Stock | 55.8925 | 55.9025 | 55.72 | 55.8975 | 2319220.0 |
| 2018-10-10 10:00:00 | AAPL | Stock | 55.8975 | 55.9775 | 55.64 | 55.85 | 2213252.0 |
> showing 50 of 371,152 rows — these rows as CSV