PREVIEW / stock_5min / 2021-07-09
file: by_date/stock_5min/2021/2021-07-09.parquet size: 7.3 MB rows: 448,362 symbols: 2,901
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-07-09 04:00:00 | AAPL | Stock | 143.24 | 143.89 | 143.24 | 143.66 | 4047.0 |
| 2021-07-09 04:05:00 | AAPL | Stock | 143.62 | 143.82 | 143.51 | 143.7 | 10293.0 |
| 2021-07-09 04:10:00 | AAPL | Stock | 143.7 | 143.75 | 143.7 | 143.74 | 1863.0 |
| 2021-07-09 04:15:00 | AAPL | Stock | 143.74 | 143.75 | 143.59 | 143.59 | 6313.0 |
| 2021-07-09 04:20:00 | AAPL | Stock | 143.6 | 143.64 | 143.6 | 143.6 | 1883.0 |
| 2021-07-09 04:25:00 | AAPL | Stock | 143.57 | 143.57 | 143.3 | 143.3 | 3063.0 |
| 2021-07-09 04:35:00 | AAPL | Stock | 143.49 | 143.51 | 143.49 | 143.5 | 2116.0 |
| 2021-07-09 04:40:00 | AAPL | Stock | 143.5 | 143.56 | 143.46 | 143.56 | 1433.0 |
| 2021-07-09 04:45:00 | AAPL | Stock | 143.46 | 143.55 | 143.46 | 143.54 | 644.0 |
| 2021-07-09 04:50:00 | AAPL | Stock | 143.55 | 143.55 | 143.45 | 143.5 | 2073.0 |
| 2021-07-09 04:55:00 | AAPL | Stock | 143.46 | 143.5 | 143.45 | 143.5 | 2886.0 |
| 2021-07-09 05:00:00 | AAPL | Stock | 143.51 | 143.59 | 143.51 | 143.59 | 300.0 |
| 2021-07-09 05:05:00 | AAPL | Stock | 143.6 | 143.6 | 143.6 | 143.6 | 532.0 |
| 2021-07-09 05:10:00 | AAPL | Stock | 143.52 | 143.52 | 143.43 | 143.43 | 2319.0 |
| 2021-07-09 05:15:00 | AAPL | Stock | 143.56 | 143.59 | 143.46 | 143.55 | 2644.0 |
| 2021-07-09 05:20:00 | AAPL | Stock | 143.59 | 143.6 | 143.59 | 143.6 | 218.0 |
| 2021-07-09 05:25:00 | AAPL | Stock | 143.6 | 143.6 | 143.51 | 143.51 | 1100.0 |
| 2021-07-09 05:30:00 | AAPL | Stock | 143.5 | 143.59 | 143.42 | 143.59 | 2361.0 |
| 2021-07-09 05:35:00 | AAPL | Stock | 143.44 | 143.44 | 143.3 | 143.39 | 2247.0 |
| 2021-07-09 05:40:00 | AAPL | Stock | 143.26 | 143.26 | 143.01 | 143.2 | 1808.0 |
| 2021-07-09 05:45:00 | AAPL | Stock | 143.18 | 143.18 | 143.0 | 143.0 | 11318.0 |
| 2021-07-09 05:50:00 | AAPL | Stock | 143.01 | 143.01 | 142.86 | 143.0 | 14084.0 |
| 2021-07-09 05:55:00 | AAPL | Stock | 143.13 | 143.13 | 143.0 | 143.0 | 423.0 |
| 2021-07-09 06:00:00 | AAPL | Stock | 143.0 | 143.0 | 142.55 | 142.8 | 6117.0 |
| 2021-07-09 06:05:00 | AAPL | Stock | 142.79 | 142.85 | 142.7 | 142.85 | 1553.0 |
| 2021-07-09 06:10:00 | AAPL | Stock | 142.72 | 142.72 | 142.68 | 142.72 | 1969.0 |
| 2021-07-09 06:15:00 | AAPL | Stock | 142.83 | 142.9 | 142.75 | 142.87 | 5011.0 |
| 2021-07-09 06:20:00 | AAPL | Stock | 142.85 | 142.85 | 142.84 | 142.84 | 1521.0 |
| 2021-07-09 06:25:00 | AAPL | Stock | 142.95 | 142.95 | 142.95 | 142.95 | 634.0 |
| 2021-07-09 06:30:00 | AAPL | Stock | 142.95 | 142.95 | 142.95 | 142.95 | 1447.0 |
| 2021-07-09 06:35:00 | AAPL | Stock | 142.95 | 143.0 | 142.94 | 142.94 | 1718.0 |
| 2021-07-09 06:40:00 | AAPL | Stock | 142.9 | 142.9 | 142.85 | 142.85 | 1399.0 |
| 2021-07-09 06:45:00 | AAPL | Stock | 142.81 | 142.81 | 142.81 | 142.81 | 503.0 |
| 2021-07-09 06:50:00 | AAPL | Stock | 142.95 | 142.95 | 142.83 | 142.84 | 2200.0 |
| 2021-07-09 06:55:00 | AAPL | Stock | 142.84 | 142.93 | 142.8 | 142.9 | 2505.0 |
| 2021-07-09 07:00:00 | AAPL | Stock | 142.95 | 143.44 | 142.92 | 143.25 | 25045.0 |
| 2021-07-09 07:05:00 | AAPL | Stock | 143.25 | 143.31 | 143.01 | 143.13 | 21165.0 |
| 2021-07-09 07:10:00 | AAPL | Stock | 143.16 | 143.23 | 143.13 | 143.2 | 11291.0 |
| 2021-07-09 07:15:00 | AAPL | Stock | 143.19 | 143.23 | 143.17 | 143.18 | 7699.0 |
| 2021-07-09 07:20:00 | AAPL | Stock | 143.17 | 143.17 | 142.82 | 143.05 | 40196.0 |
| 2021-07-09 07:25:00 | AAPL | Stock | 143.05 | 143.08 | 142.92 | 142.92 | 13544.0 |
| 2021-07-09 07:30:00 | AAPL | Stock | 142.95 | 143.08 | 142.81 | 143.07 | 36822.0 |
| 2021-07-09 07:35:00 | AAPL | Stock | 143.0 | 143.0 | 142.83 | 142.94 | 3937.0 |
| 2021-07-09 07:40:00 | AAPL | Stock | 142.92 | 143.07 | 142.9 | 143.03 | 14474.0 |
| 2021-07-09 07:45:00 | AAPL | Stock | 143.05 | 143.05 | 142.94 | 143.02 | 7429.0 |
| 2021-07-09 07:50:00 | AAPL | Stock | 143.02 | 143.03 | 142.95 | 142.98 | 4049.0 |
| 2021-07-09 07:55:00 | AAPL | Stock | 142.97 | 143.04 | 142.97 | 143.03 | 3797.0 |
| 2021-07-09 08:00:00 | AAPL | Stock | 143.12 | 143.25 | 142.86 | 143.19 | 85031.0 |
| 2021-07-09 08:05:00 | AAPL | Stock | 143.2 | 143.23 | 143.0 | 143.18 | 50324.0 |
| 2021-07-09 08:10:00 | AAPL | Stock | 143.19 | 143.35 | 143.19 | 143.29 | 52991.0 |
> showing 50 of 448,362 rows — these rows as CSV