PREVIEW / stock_5min / 2018-12-07
file: by_date/stock_5min/2018/2018-12-07.parquet size: 5.7 MB rows: 364,950 symbols: 2,720
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-12-07 04:00:00 | AAPL | Stock | 43.4375 | 43.4375 | 43.2375 | 43.2375 | 5784.0 |
| 2018-12-07 04:25:00 | AAPL | Stock | 43.3025 | 43.3025 | 43.3025 | 43.3025 | 800.0 |
| 2018-12-07 04:30:00 | AAPL | Stock | 43.3375 | 43.3875 | 43.3375 | 43.3875 | 800.0 |
| 2018-12-07 04:45:00 | AAPL | Stock | 43.35 | 43.35 | 43.35 | 43.35 | 400.0 |
| 2018-12-07 04:50:00 | AAPL | Stock | 43.41 | 43.4675 | 43.4025 | 43.4025 | 4760.0 |
| 2018-12-07 04:55:00 | AAPL | Stock | 43.4025 | 43.4025 | 43.4025 | 43.4025 | 3728.0 |
| 2018-12-07 05:00:00 | AAPL | Stock | 43.3825 | 43.3825 | 43.3825 | 43.3825 | 400.0 |
| 2018-12-07 05:15:00 | AAPL | Stock | 43.4675 | 43.4675 | 43.4675 | 43.4675 | 800.0 |
| 2018-12-07 05:20:00 | AAPL | Stock | 43.3825 | 43.3825 | 43.3825 | 43.3825 | 1600.0 |
| 2018-12-07 05:25:00 | AAPL | Stock | 43.4125 | 43.42 | 43.4125 | 43.42 | 4000.0 |
| 2018-12-07 05:40:00 | AAPL | Stock | 43.485 | 43.485 | 43.445 | 43.445 | 1976.0 |
| 2018-12-07 05:50:00 | AAPL | Stock | 43.4275 | 43.4275 | 43.4275 | 43.4275 | 400.0 |
| 2018-12-07 05:55:00 | AAPL | Stock | 43.475 | 43.475 | 43.475 | 43.475 | 444.0 |
| 2018-12-07 06:20:00 | AAPL | Stock | 43.4275 | 43.4275 | 43.425 | 43.425 | 4628.0 |
| 2018-12-07 06:25:00 | AAPL | Stock | 43.4 | 43.4 | 43.4 | 43.4 | 2000.0 |
| 2018-12-07 06:30:00 | AAPL | Stock | 43.375 | 43.375 | 43.375 | 43.375 | 688.0 |
| 2018-12-07 06:40:00 | AAPL | Stock | 43.35 | 43.35 | 43.35 | 43.35 | 716.0 |
| 2018-12-07 06:55:00 | AAPL | Stock | 43.3425 | 43.3425 | 43.3375 | 43.3375 | 800.0 |
| 2018-12-07 07:00:00 | AAPL | Stock | 43.3375 | 43.41 | 43.315 | 43.315 | 49728.0 |
| 2018-12-07 07:05:00 | AAPL | Stock | 43.3625 | 43.3625 | 43.32 | 43.36 | 6672.0 |
| 2018-12-07 07:10:00 | AAPL | Stock | 43.395 | 43.395 | 43.325 | 43.375 | 12012.0 |
| 2018-12-07 07:15:00 | AAPL | Stock | 43.375 | 43.375 | 43.355 | 43.355 | 800.0 |
| 2018-12-07 07:20:00 | AAPL | Stock | 43.375 | 43.375 | 43.355 | 43.3675 | 3032.0 |
| 2018-12-07 07:25:00 | AAPL | Stock | 43.34 | 43.4 | 43.3375 | 43.4 | 3600.0 |
| 2018-12-07 07:30:00 | AAPL | Stock | 43.3875 | 43.3875 | 43.37 | 43.37 | 1600.0 |
| 2018-12-07 07:35:00 | AAPL | Stock | 43.375 | 43.3875 | 43.375 | 43.3875 | 1700.0 |
| 2018-12-07 07:40:00 | AAPL | Stock | 43.375 | 43.4 | 43.365 | 43.4 | 19376.0 |
| 2018-12-07 07:45:00 | AAPL | Stock | 43.4125 | 43.4125 | 43.375 | 43.375 | 2948.0 |
| 2018-12-07 07:55:00 | AAPL | Stock | 43.385 | 43.4075 | 43.3825 | 43.4075 | 6236.0 |
| 2018-12-07 08:00:00 | AAPL | Stock | 43.35 | 43.5 | 43.315 | 43.475 | 41624.0 |
| 2018-12-07 08:05:00 | AAPL | Stock | 43.48 | 43.48 | 43.4275 | 43.4275 | 9496.0 |
| 2018-12-07 08:10:00 | AAPL | Stock | 43.425 | 43.5 | 43.4 | 43.5 | 23208.0 |
| 2018-12-07 08:15:00 | AAPL | Stock | 43.495 | 43.525 | 43.425 | 43.4925 | 22616.0 |
| 2018-12-07 08:20:00 | AAPL | Stock | 43.4925 | 43.5375 | 43.4925 | 43.5 | 13120.0 |
| 2018-12-07 08:25:00 | AAPL | Stock | 43.515 | 43.55 | 43.5 | 43.55 | 11936.0 |
| 2018-12-07 08:30:00 | AAPL | Stock | 43.55 | 43.625 | 43.5325 | 43.6 | 41148.0 |
| 2018-12-07 08:35:00 | AAPL | Stock | 43.575 | 43.7475 | 43.575 | 43.7125 | 65568.0 |
| 2018-12-07 08:40:00 | AAPL | Stock | 43.7175 | 43.8 | 43.7125 | 43.75 | 137316.0 |
| 2018-12-07 08:45:00 | AAPL | Stock | 43.75 | 43.7775 | 43.72 | 43.7625 | 185284.0 |
| 2018-12-07 08:50:00 | AAPL | Stock | 43.75 | 43.775 | 43.685 | 43.685 | 50764.0 |
| 2018-12-07 08:55:00 | AAPL | Stock | 43.6875 | 43.6875 | 43.5975 | 43.6 | 29568.0 |
| 2018-12-07 09:00:00 | AAPL | Stock | 43.5875 | 43.6625 | 43.5875 | 43.605 | 27368.0 |
| 2018-12-07 09:05:00 | AAPL | Stock | 43.635 | 43.6475 | 43.615 | 43.6275 | 39732.0 |
| 2018-12-07 09:10:00 | AAPL | Stock | 43.6375 | 43.645 | 43.5425 | 43.5425 | 35596.0 |
| 2018-12-07 09:15:00 | AAPL | Stock | 43.5625 | 43.61 | 43.5375 | 43.55 | 44192.0 |
| 2018-12-07 09:20:00 | AAPL | Stock | 43.55 | 43.55 | 43.5 | 43.515 | 51620.0 |
| 2018-12-07 09:25:00 | AAPL | Stock | 43.5025 | 43.5025 | 43.2625 | 43.3775 | 167720.0 |
| 2018-12-07 09:30:00 | AAPL | Stock | 43.3775 | 43.435 | 43.14 | 43.3138 | 4554372.0 |
| 2018-12-07 09:35:00 | AAPL | Stock | 43.3155 | 43.5 | 43.24 | 43.4825 | 2653880.0 |
| 2018-12-07 09:40:00 | AAPL | Stock | 43.4775 | 43.5575 | 43.435 | 43.525 | 2357604.0 |
> showing 50 of 364,950 rows — these rows as CSV