PREVIEW / stock_5min / 2020-11-13
file: by_date/stock_5min/2020/2020-11-13.parquet size: 6.6 MB rows: 409,599 symbols: 2,540
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-13 04:00:00 | AAPL | Stock | 119.8 | 119.83 | 119.6 | 119.64 | 4163.0 |
| 2020-11-13 04:05:00 | AAPL | Stock | 119.66 | 119.78 | 119.6 | 119.72 | 5207.0 |
| 2020-11-13 04:10:00 | AAPL | Stock | 119.73 | 119.73 | 119.65 | 119.69 | 4103.0 |
| 2020-11-13 04:15:00 | AAPL | Stock | 119.74 | 119.75 | 119.67 | 119.67 | 1989.0 |
| 2020-11-13 04:20:00 | AAPL | Stock | 119.83 | 119.83 | 119.68 | 119.79 | 3961.0 |
| 2020-11-13 04:25:00 | AAPL | Stock | 119.78 | 119.79 | 119.63 | 119.63 | 838.0 |
| 2020-11-13 04:30:00 | AAPL | Stock | 119.66 | 119.85 | 119.66 | 119.8 | 4022.0 |
| 2020-11-13 04:35:00 | AAPL | Stock | 119.9 | 119.91 | 119.65 | 119.7 | 3140.0 |
| 2020-11-13 04:40:00 | AAPL | Stock | 119.7 | 119.77 | 119.7 | 119.76 | 2338.0 |
| 2020-11-13 04:45:00 | AAPL | Stock | 119.77 | 119.97 | 119.74 | 119.92 | 4041.0 |
| 2020-11-13 04:50:00 | AAPL | Stock | 119.97 | 120.1 | 119.97 | 120.03 | 3240.0 |
| 2020-11-13 04:55:00 | AAPL | Stock | 120.05 | 120.09 | 119.8 | 119.81 | 1678.0 |
| 2020-11-13 05:00:00 | AAPL | Stock | 119.88 | 119.99 | 119.88 | 119.96 | 817.0 |
| 2020-11-13 05:05:00 | AAPL | Stock | 119.95 | 120.09 | 119.95 | 120.09 | 2164.0 |
| 2020-11-13 05:10:00 | AAPL | Stock | 119.94 | 120.07 | 119.94 | 120.07 | 770.0 |
| 2020-11-13 05:15:00 | AAPL | Stock | 120.0 | 120.0 | 119.9 | 120.0 | 1966.0 |
| 2020-11-13 05:20:00 | AAPL | Stock | 119.97 | 120.07 | 119.88 | 120.07 | 1667.0 |
| 2020-11-13 05:25:00 | AAPL | Stock | 120.05 | 120.05 | 119.92 | 119.92 | 947.0 |
| 2020-11-13 05:30:00 | AAPL | Stock | 119.99 | 120.02 | 119.95 | 119.95 | 6380.0 |
| 2020-11-13 05:35:00 | AAPL | Stock | 119.99 | 120.02 | 119.99 | 120.0 | 3588.0 |
| 2020-11-13 05:40:00 | AAPL | Stock | 120.02 | 120.06 | 120.0 | 120.06 | 2793.0 |
| 2020-11-13 05:45:00 | AAPL | Stock | 120.08 | 120.08 | 120.05 | 120.06 | 1699.0 |
| 2020-11-13 05:50:00 | AAPL | Stock | 120.08 | 120.08 | 120.08 | 120.08 | 100.0 |
| 2020-11-13 05:55:00 | AAPL | Stock | 120.1 | 120.1 | 120.0 | 120.0 | 1920.0 |
| 2020-11-13 06:00:00 | AAPL | Stock | 119.94 | 120.0 | 119.94 | 119.99 | 691.0 |
| 2020-11-13 06:05:00 | AAPL | Stock | 119.85 | 119.93 | 119.85 | 119.9 | 2546.0 |
| 2020-11-13 06:10:00 | AAPL | Stock | 119.86 | 119.87 | 119.86 | 119.87 | 685.0 |
| 2020-11-13 06:15:00 | AAPL | Stock | 119.83 | 119.83 | 119.83 | 119.83 | 100.0 |
| 2020-11-13 06:20:00 | AAPL | Stock | 119.88 | 119.88 | 119.8 | 119.8 | 1474.0 |
| 2020-11-13 06:25:00 | AAPL | Stock | 119.79 | 119.79 | 119.79 | 119.79 | 250.0 |
| 2020-11-13 06:30:00 | AAPL | Stock | 119.85 | 119.96 | 119.85 | 119.96 | 1293.0 |
| 2020-11-13 06:35:00 | AAPL | Stock | 119.92 | 119.94 | 119.92 | 119.94 | 944.0 |
| 2020-11-13 06:40:00 | AAPL | Stock | 119.93 | 119.95 | 119.83 | 119.83 | 1500.0 |
| 2020-11-13 06:45:00 | AAPL | Stock | 119.8 | 119.8 | 119.79 | 119.79 | 600.0 |
| 2020-11-13 06:50:00 | AAPL | Stock | 119.79 | 119.99 | 119.74 | 119.97 | 4660.0 |
| 2020-11-13 06:55:00 | AAPL | Stock | 119.97 | 120.05 | 119.87 | 119.92 | 27414.0 |
| 2020-11-13 07:00:00 | AAPL | Stock | 120.02 | 120.02 | 119.62 | 119.82 | 50704.0 |
| 2020-11-13 07:05:00 | AAPL | Stock | 119.84 | 119.84 | 119.75 | 119.75 | 13654.0 |
| 2020-11-13 07:10:00 | AAPL | Stock | 119.76 | 119.83 | 119.73 | 119.79 | 13131.0 |
| 2020-11-13 07:15:00 | AAPL | Stock | 119.8 | 119.82 | 119.77 | 119.82 | 6802.0 |
| 2020-11-13 07:20:00 | AAPL | Stock | 119.83 | 119.91 | 119.83 | 119.91 | 12463.0 |
| 2020-11-13 07:25:00 | AAPL | Stock | 119.94 | 119.95 | 119.9 | 119.93 | 8652.0 |
| 2020-11-13 07:30:00 | AAPL | Stock | 119.93 | 119.98 | 119.9 | 119.95 | 17287.0 |
| 2020-11-13 07:35:00 | AAPL | Stock | 119.94 | 119.95 | 119.88 | 119.88 | 3424.0 |
| 2020-11-13 07:40:00 | AAPL | Stock | 119.86 | 119.909 | 119.84 | 119.9 | 5996.0 |
| 2020-11-13 07:45:00 | AAPL | Stock | 119.89 | 119.89 | 119.7 | 119.72 | 17421.0 |
| 2020-11-13 07:50:00 | AAPL | Stock | 119.72 | 119.75 | 119.65 | 119.72 | 13931.0 |
| 2020-11-13 07:55:00 | AAPL | Stock | 119.73 | 119.75 | 119.65 | 119.69 | 8572.0 |
| 2020-11-13 08:00:00 | AAPL | Stock | 119.82 | 119.97 | 119.5 | 119.72 | 157285.0 |
| 2020-11-13 08:05:00 | AAPL | Stock | 119.71 | 119.75 | 119.69 | 119.69 | 22068.0 |
> showing 50 of 409,599 rows — these rows as CSV