PREVIEW / stock_5min / 2020-06-19
file: by_date/stock_5min/2020/2020-06-19.parquet size: 6.8 MB rows: 431,634 symbols: 2,446
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 |
|---|---|---|---|---|---|---|---|
| 2020-06-19 04:00:00 | AAPL | Stock | 88.5125 | 88.6 | 88.5 | 88.5 | 6916.0 |
| 2020-06-19 04:15:00 | AAPL | Stock | 88.39 | 88.39 | 88.39 | 88.39 | 400.0 |
| 2020-06-19 04:30:00 | AAPL | Stock | 88.3375 | 88.3375 | 88.3375 | 88.3375 | 800.0 |
| 2020-06-19 04:50:00 | AAPL | Stock | 88.475 | 88.475 | 88.475 | 88.475 | 772.0 |
| 2020-06-19 05:10:00 | AAPL | Stock | 88.575 | 88.575 | 88.575 | 88.575 | 400.0 |
| 2020-06-19 05:15:00 | AAPL | Stock | 88.6 | 88.6 | 88.495 | 88.5 | 11928.0 |
| 2020-06-19 05:40:00 | AAPL | Stock | 88.625 | 88.625 | 88.625 | 88.625 | 740.0 |
| 2020-06-19 05:45:00 | AAPL | Stock | 88.55 | 88.55 | 88.4975 | 88.4975 | 5304.0 |
| 2020-06-19 05:50:00 | AAPL | Stock | 88.55 | 88.55 | 88.5 | 88.5 | 6100.0 |
| 2020-06-19 05:55:00 | AAPL | Stock | 88.455 | 88.455 | 88.455 | 88.455 | 448.0 |
| 2020-06-19 06:05:00 | AAPL | Stock | 88.475 | 88.5725 | 88.475 | 88.5 | 7972.0 |
| 2020-06-19 06:10:00 | AAPL | Stock | 88.4925 | 88.4925 | 88.4875 | 88.49 | 3080.0 |
| 2020-06-19 06:25:00 | AAPL | Stock | 88.48 | 88.49 | 88.48 | 88.49 | 4504.0 |
| 2020-06-19 06:30:00 | AAPL | Stock | 88.4875 | 88.4875 | 88.4375 | 88.4375 | 1600.0 |
| 2020-06-19 06:35:00 | AAPL | Stock | 88.4375 | 88.47 | 88.3925 | 88.3925 | 5624.0 |
| 2020-06-19 06:40:00 | AAPL | Stock | 88.3875 | 88.3875 | 88.3875 | 88.3875 | 1200.0 |
| 2020-06-19 06:50:00 | AAPL | Stock | 88.42 | 88.44 | 88.39 | 88.39 | 2000.0 |
| 2020-06-19 06:55:00 | AAPL | Stock | 88.3875 | 88.47 | 88.3875 | 88.47 | 6540.0 |
| 2020-06-19 07:00:00 | AAPL | Stock | 88.47 | 88.595 | 88.3875 | 88.425 | 66372.0 |
| 2020-06-19 07:05:00 | AAPL | Stock | 88.4475 | 88.5 | 88.4225 | 88.5 | 43512.0 |
| 2020-06-19 07:10:00 | AAPL | Stock | 88.5025 | 88.5875 | 88.405 | 88.445 | 21700.0 |
| 2020-06-19 07:15:00 | AAPL | Stock | 88.4125 | 88.455 | 88.3525 | 88.455 | 16864.0 |
| 2020-06-19 07:20:00 | AAPL | Stock | 88.4925 | 88.515 | 88.4725 | 88.5125 | 25740.0 |
| 2020-06-19 07:25:00 | AAPL | Stock | 88.525 | 88.565 | 88.51 | 88.51 | 20020.0 |
| 2020-06-19 07:30:00 | AAPL | Stock | 88.5125 | 88.5625 | 88.5125 | 88.5625 | 7012.0 |
| 2020-06-19 07:35:00 | AAPL | Stock | 88.55 | 88.55 | 88.55 | 88.55 | 5308.0 |
| 2020-06-19 07:40:00 | AAPL | Stock | 88.55 | 88.55 | 88.495 | 88.525 | 14600.0 |
| 2020-06-19 07:45:00 | AAPL | Stock | 88.5 | 88.5625 | 88.5 | 88.5625 | 9740.0 |
| 2020-06-19 07:50:00 | AAPL | Stock | 88.5625 | 88.6725 | 88.55 | 88.67 | 59748.0 |
| 2020-06-19 07:55:00 | AAPL | Stock | 88.6625 | 88.7125 | 88.6425 | 88.7125 | 17832.0 |
| 2020-06-19 08:00:00 | AAPL | Stock | 88.715 | 88.775 | 88.375 | 88.775 | 175236.0 |
| 2020-06-19 08:05:00 | AAPL | Stock | 88.775 | 88.8425 | 88.715 | 88.8425 | 65740.0 |
| 2020-06-19 08:10:00 | AAPL | Stock | 88.8375 | 88.8875 | 88.8 | 88.825 | 48236.0 |
| 2020-06-19 08:15:00 | AAPL | Stock | 88.81 | 88.8125 | 88.715 | 88.7375 | 32124.0 |
| 2020-06-19 08:20:00 | AAPL | Stock | 88.7175 | 88.7375 | 88.64 | 88.72 | 42040.0 |
| 2020-06-19 08:25:00 | AAPL | Stock | 88.6975 | 88.74 | 88.64 | 88.68 | 17064.0 |
| 2020-06-19 08:30:00 | AAPL | Stock | 88.715 | 88.8 | 88.68 | 88.7525 | 36328.0 |
| 2020-06-19 08:35:00 | AAPL | Stock | 88.75 | 88.825 | 88.725 | 88.775 | 82400.0 |
| 2020-06-19 08:40:00 | AAPL | Stock | 88.75 | 88.81 | 88.725 | 88.81 | 37456.0 |
| 2020-06-19 08:45:00 | AAPL | Stock | 88.7825 | 88.8725 | 88.7825 | 88.8525 | 54928.0 |
| 2020-06-19 08:50:00 | AAPL | Stock | 88.8525 | 88.89 | 88.8275 | 88.875 | 56324.0 |
| 2020-06-19 08:55:00 | AAPL | Stock | 88.8675 | 88.9125 | 88.85 | 88.9 | 81400.0 |
| 2020-06-19 09:00:00 | AAPL | Stock | 88.9 | 88.9175 | 88.755 | 88.8225 | 154012.0 |
| 2020-06-19 09:05:00 | AAPL | Stock | 88.8225 | 88.85 | 88.75 | 88.7975 | 35852.0 |
| 2020-06-19 09:10:00 | AAPL | Stock | 88.7975 | 88.9375 | 88.7625 | 88.925 | 115156.0 |
| 2020-06-19 09:15:00 | AAPL | Stock | 88.9 | 89.075 | 88.9 | 89.0725 | 127036.0 |
| 2020-06-19 09:20:00 | AAPL | Stock | 89.025 | 89.0625 | 88.9125 | 88.995 | 104988.0 |
| 2020-06-19 09:25:00 | AAPL | Stock | 89.0 | 89.2375 | 88.61 | 88.635 | 794208.0 |
| 2020-06-19 09:30:00 | AAPL | Stock | 88.635 | 89.0575 | 88.6125 | 89.005 | 19877388.0 |
| 2020-06-19 09:35:00 | AAPL | Stock | 89.0048 | 89.05 | 88.725 | 89.0472 | 2818680.0 |
> showing 50 of 431,634 rows — these rows as CSV