PREVIEW / stock_5min / 2020-11-17
file: by_date/stock_5min/2020/2020-11-17.parquet size: 6.8 MB rows: 423,832 symbols: 2,551
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-11-17 04:00:00 | AAPL | Stock | 119.99 | 119.99 | 119.49 | 119.86 | 3164.0 |
| 2020-11-17 04:05:00 | AAPL | Stock | 119.88 | 119.9 | 119.85 | 119.85 | 2235.0 |
| 2020-11-17 04:10:00 | AAPL | Stock | 119.87 | 119.89 | 119.8 | 119.89 | 1372.0 |
| 2020-11-17 04:15:00 | AAPL | Stock | 119.93 | 119.93 | 119.85 | 119.85 | 922.0 |
| 2020-11-17 04:25:00 | AAPL | Stock | 119.85 | 119.85 | 119.85 | 119.85 | 660.0 |
| 2020-11-17 04:30:00 | AAPL | Stock | 119.77 | 119.77 | 119.75 | 119.75 | 1063.0 |
| 2020-11-17 04:35:00 | AAPL | Stock | 119.8 | 119.85 | 119.8 | 119.85 | 889.0 |
| 2020-11-17 04:40:00 | AAPL | Stock | 119.81 | 119.81 | 119.79 | 119.79 | 1657.0 |
| 2020-11-17 04:50:00 | AAPL | Stock | 119.8 | 119.8 | 119.8 | 119.8 | 120.0 |
| 2020-11-17 04:55:00 | AAPL | Stock | 119.72 | 119.79 | 119.72 | 119.79 | 370.0 |
| 2020-11-17 05:00:00 | AAPL | Stock | 119.73 | 119.73 | 119.63 | 119.63 | 1437.0 |
| 2020-11-17 05:05:00 | AAPL | Stock | 119.61 | 119.61 | 119.61 | 119.61 | 100.0 |
| 2020-11-17 05:15:00 | AAPL | Stock | 119.66 | 119.66 | 119.66 | 119.66 | 1644.0 |
| 2020-11-17 05:25:00 | AAPL | Stock | 119.69 | 119.69 | 119.69 | 119.69 | 300.0 |
| 2020-11-17 05:30:00 | AAPL | Stock | 119.69 | 119.72 | 119.6 | 119.69 | 1721.0 |
| 2020-11-17 05:35:00 | AAPL | Stock | 119.67 | 119.67 | 119.66 | 119.66 | 2173.0 |
| 2020-11-17 05:40:00 | AAPL | Stock | 119.66 | 119.7 | 119.66 | 119.7 | 3907.0 |
| 2020-11-17 05:45:00 | AAPL | Stock | 119.74 | 119.74 | 119.74 | 119.74 | 100.0 |
| 2020-11-17 05:50:00 | AAPL | Stock | 119.7 | 119.7 | 119.52 | 119.6 | 1890.0 |
| 2020-11-17 05:55:00 | AAPL | Stock | 119.52 | 119.6 | 119.47 | 119.6 | 1263.0 |
| 2020-11-17 06:00:00 | AAPL | Stock | 119.6 | 119.6 | 119.51 | 119.51 | 3794.0 |
| 2020-11-17 06:05:00 | AAPL | Stock | 119.6 | 119.6 | 119.6 | 119.6 | 492.0 |
| 2020-11-17 06:10:00 | AAPL | Stock | 119.56 | 119.56 | 119.4 | 119.41 | 3008.0 |
| 2020-11-17 06:15:00 | AAPL | Stock | 119.52 | 119.52 | 119.51 | 119.51 | 200.0 |
| 2020-11-17 06:20:00 | AAPL | Stock | 119.59 | 119.59 | 119.56 | 119.56 | 949.0 |
| 2020-11-17 06:25:00 | AAPL | Stock | 119.58 | 119.6 | 119.58 | 119.6 | 844.0 |
| 2020-11-17 06:30:00 | AAPL | Stock | 119.61 | 119.69 | 119.6 | 119.69 | 971.0 |
| 2020-11-17 06:40:00 | AAPL | Stock | 119.55 | 119.59 | 119.55 | 119.59 | 259.0 |
| 2020-11-17 06:45:00 | AAPL | Stock | 119.59 | 119.59 | 119.59 | 119.59 | 704.0 |
| 2020-11-17 06:50:00 | AAPL | Stock | 119.56 | 119.59 | 119.56 | 119.59 | 252.0 |
| 2020-11-17 06:55:00 | AAPL | Stock | 119.65 | 119.65 | 119.65 | 119.65 | 732.0 |
| 2020-11-17 07:00:00 | AAPL | Stock | 119.68 | 119.86 | 119.63 | 119.82 | 21404.0 |
| 2020-11-17 07:05:00 | AAPL | Stock | 119.8 | 119.81 | 119.75 | 119.75 | 10017.0 |
| 2020-11-17 07:10:00 | AAPL | Stock | 119.71 | 119.71 | 119.6 | 119.7 | 6015.0 |
| 2020-11-17 07:15:00 | AAPL | Stock | 119.71 | 119.85 | 119.61 | 119.65 | 9953.0 |
| 2020-11-17 07:20:00 | AAPL | Stock | 119.66 | 119.75 | 119.63 | 119.65 | 9700.0 |
| 2020-11-17 07:25:00 | AAPL | Stock | 119.65 | 119.65 | 119.42 | 119.5 | 36715.0 |
| 2020-11-17 07:30:00 | AAPL | Stock | 119.53 | 119.57 | 119.5 | 119.5 | 11045.0 |
| 2020-11-17 07:35:00 | AAPL | Stock | 119.5 | 119.61 | 119.5 | 119.6 | 12266.0 |
| 2020-11-17 07:40:00 | AAPL | Stock | 119.61 | 119.74 | 119.6 | 119.7 | 16141.0 |
| 2020-11-17 07:45:00 | AAPL | Stock | 119.71 | 119.72 | 119.67 | 119.69 | 9946.0 |
| 2020-11-17 07:50:00 | AAPL | Stock | 119.68 | 119.78 | 119.65 | 119.73 | 20441.0 |
| 2020-11-17 07:55:00 | AAPL | Stock | 119.7 | 119.78 | 119.7 | 119.76 | 7616.0 |
| 2020-11-17 08:00:00 | AAPL | Stock | 119.8 | 119.88 | 119.45 | 119.77 | 85193.0 |
| 2020-11-17 08:05:00 | AAPL | Stock | 119.77 | 119.77 | 119.54 | 119.62 | 25929.0 |
| 2020-11-17 08:10:00 | AAPL | Stock | 119.62 | 119.69 | 119.55 | 119.64 | 18333.0 |
| 2020-11-17 08:15:00 | AAPL | Stock | 119.68 | 119.76 | 119.65 | 119.74 | 12719.0 |
| 2020-11-17 08:20:00 | AAPL | Stock | 119.73 | 119.749 | 119.67 | 119.68 | 9667.0 |
| 2020-11-17 08:25:00 | AAPL | Stock | 119.65 | 119.7 | 119.64 | 119.7 | 2812.0 |
| 2020-11-17 08:30:00 | AAPL | Stock | 119.69 | 119.72 | 119.5 | 119.63 | 51317.0 |
> showing 50 of 423,832 rows — these rows as CSV