PREVIEW / stock_5min / 2021-12-03
file: by_date/stock_5min/2021/2021-12-03.parquet size: 7.8 MB rows: 477,442 symbols: 2,676
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 |
|---|---|---|---|---|---|---|---|
| 2021-12-03 04:00:00 | AAPL | Stock | 162.53 | 162.92 | 162.51 | 162.75 | 4020.0 |
| 2021-12-03 04:05:00 | AAPL | Stock | 162.76 | 162.76 | 162.56 | 162.56 | 2137.0 |
| 2021-12-03 04:10:00 | AAPL | Stock | 162.64 | 162.79 | 162.64 | 162.79 | 2363.0 |
| 2021-12-03 04:15:00 | AAPL | Stock | 162.8 | 163.02 | 162.8 | 163.02 | 3811.0 |
| 2021-12-03 04:20:00 | AAPL | Stock | 162.98 | 163.06 | 162.97 | 163.06 | 372.0 |
| 2021-12-03 04:25:00 | AAPL | Stock | 162.93 | 162.93 | 162.92 | 162.92 | 422.0 |
| 2021-12-03 04:30:00 | AAPL | Stock | 162.95 | 162.95 | 162.9 | 162.9 | 345.0 |
| 2021-12-03 04:35:00 | AAPL | Stock | 162.83 | 162.85 | 162.71 | 162.71 | 867.0 |
| 2021-12-03 04:40:00 | AAPL | Stock | 162.66 | 162.66 | 162.57 | 162.57 | 314.0 |
| 2021-12-03 04:45:00 | AAPL | Stock | 162.8 | 162.8 | 162.75 | 162.8 | 641.0 |
| 2021-12-03 04:50:00 | AAPL | Stock | 162.66 | 162.73 | 162.66 | 162.73 | 413.0 |
| 2021-12-03 05:00:00 | AAPL | Stock | 162.79 | 162.8 | 162.75 | 162.75 | 891.0 |
| 2021-12-03 05:05:00 | AAPL | Stock | 162.82 | 162.82 | 162.82 | 162.82 | 120.0 |
| 2021-12-03 05:10:00 | AAPL | Stock | 162.88 | 162.94 | 162.0 | 162.23 | 14137.0 |
| 2021-12-03 05:15:00 | AAPL | Stock | 162.65 | 162.67 | 162.64 | 162.67 | 354.0 |
| 2021-12-03 05:20:00 | AAPL | Stock | 162.61 | 162.61 | 162.44 | 162.44 | 431.0 |
| 2021-12-03 05:25:00 | AAPL | Stock | 162.47 | 162.7 | 162.47 | 162.7 | 857.0 |
| 2021-12-03 05:30:00 | AAPL | Stock | 162.8 | 162.86 | 162.79 | 162.86 | 1707.0 |
| 2021-12-03 05:35:00 | AAPL | Stock | 162.67 | 162.67 | 162.58 | 162.58 | 337.0 |
| 2021-12-03 05:40:00 | AAPL | Stock | 162.47 | 162.6 | 162.47 | 162.6 | 674.0 |
| 2021-12-03 05:45:00 | AAPL | Stock | 162.38 | 162.38 | 162.38 | 162.38 | 940.0 |
| 2021-12-03 05:55:00 | AAPL | Stock | 162.6 | 162.6 | 162.6 | 162.6 | 133.0 |
| 2021-12-03 06:00:00 | AAPL | Stock | 162.75 | 162.8 | 162.75 | 162.8 | 375.0 |
| 2021-12-03 06:05:00 | AAPL | Stock | 162.81 | 162.81 | 162.81 | 162.81 | 307.0 |
| 2021-12-03 06:10:00 | AAPL | Stock | 162.76 | 162.78 | 162.76 | 162.78 | 705.0 |
| 2021-12-03 06:20:00 | AAPL | Stock | 162.84 | 162.84 | 162.83 | 162.83 | 1184.0 |
| 2021-12-03 06:25:00 | AAPL | Stock | 162.84 | 162.98 | 162.84 | 162.98 | 11119.0 |
| 2021-12-03 06:30:00 | AAPL | Stock | 162.88 | 162.97 | 162.88 | 162.97 | 245.0 |
| 2021-12-03 06:40:00 | AAPL | Stock | 162.98 | 163.13 | 162.98 | 163.13 | 4595.0 |
| 2021-12-03 06:45:00 | AAPL | Stock | 163.09 | 163.11 | 163.0 | 163.11 | 1370.0 |
| 2021-12-03 06:50:00 | AAPL | Stock | 163.11 | 163.11 | 163.11 | 163.11 | 300.0 |
| 2021-12-03 06:55:00 | AAPL | Stock | 163.17 | 163.18 | 163.15 | 163.15 | 1892.0 |
| 2021-12-03 07:00:00 | AAPL | Stock | 163.17 | 163.41 | 163.06 | 163.4 | 16970.0 |
| 2021-12-03 07:05:00 | AAPL | Stock | 163.42 | 163.44 | 163.16 | 163.16 | 13491.0 |
| 2021-12-03 07:10:00 | AAPL | Stock | 163.17 | 163.46 | 163.12 | 163.44 | 9765.0 |
| 2021-12-03 07:15:00 | AAPL | Stock | 163.42 | 163.42 | 163.21 | 163.28 | 9412.0 |
| 2021-12-03 07:20:00 | AAPL | Stock | 163.28 | 163.6 | 163.23 | 163.49 | 15193.0 |
| 2021-12-03 07:25:00 | AAPL | Stock | 163.48 | 163.57 | 163.44 | 163.45 | 3737.0 |
| 2021-12-03 07:30:00 | AAPL | Stock | 163.44 | 163.64 | 163.35 | 163.62 | 7922.0 |
| 2021-12-03 07:35:00 | AAPL | Stock | 163.57 | 163.57 | 163.48 | 163.5 | 2837.0 |
| 2021-12-03 07:40:00 | AAPL | Stock | 163.54 | 163.58 | 163.49 | 163.52 | 18466.0 |
| 2021-12-03 07:45:00 | AAPL | Stock | 163.51 | 163.79 | 163.51 | 163.66 | 12631.0 |
| 2021-12-03 07:50:00 | AAPL | Stock | 163.71 | 163.79 | 163.71 | 163.78 | 7866.0 |
| 2021-12-03 07:55:00 | AAPL | Stock | 163.75 | 163.78 | 163.7 | 163.76 | 6052.0 |
| 2021-12-03 08:00:00 | AAPL | Stock | 163.17 | 163.8 | 163.12 | 163.78 | 128239.0 |
| 2021-12-03 08:05:00 | AAPL | Stock | 163.76 | 164.16 | 163.76 | 163.9799 | 55189.0 |
| 2021-12-03 08:10:00 | AAPL | Stock | 163.9109 | 164.06 | 163.91 | 164.0499 | 23155.0 |
| 2021-12-03 08:15:00 | AAPL | Stock | 164.04 | 164.05 | 163.9 | 163.91 | 31211.0 |
| 2021-12-03 08:20:00 | AAPL | Stock | 163.93 | 163.9799 | 163.8 | 163.9 | 18532.0 |
| 2021-12-03 08:25:00 | AAPL | Stock | 163.9 | 164.1 | 163.89 | 164.01 | 33998.0 |
> showing 50 of 477,442 rows — these rows as CSV