PREVIEW / stock_5min / 2023-11-21
file: by_date/stock_5min/2023/2023-11-21.parquet size: 6.4 MB rows: 392,845 symbols: 1,306
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 |
|---|---|---|---|---|---|---|---|
| 2023-11-21 04:05:00 | AAPL | Stock | 191.41 | 191.41 | 191.41 | 191.41 | 163.0 |
| 2023-11-21 04:15:00 | AAPL | Stock | 191.34 | 191.35 | 191.34 | 191.35 | 397.0 |
| 2023-11-21 04:20:00 | AAPL | Stock | 191.4 | 191.4 | 191.4 | 191.4 | 123.0 |
| 2023-11-21 04:30:00 | AAPL | Stock | 191.32 | 191.32 | 191.32 | 191.32 | 138.0 |
| 2023-11-21 04:35:00 | AAPL | Stock | 191.33 | 191.33 | 191.33 | 191.33 | 100.0 |
| 2023-11-21 04:40:00 | AAPL | Stock | 191.3 | 191.3 | 191.1 | 191.1 | 3466.0 |
| 2023-11-21 04:45:00 | AAPL | Stock | 191.13 | 191.13 | 191.12 | 191.12 | 263.0 |
| 2023-11-21 05:10:00 | AAPL | Stock | 191.2 | 191.2 | 191.2 | 191.2 | 204.0 |
| 2023-11-21 05:30:00 | AAPL | Stock | 191.18 | 191.18 | 191.18 | 191.18 | 150.0 |
| 2023-11-21 06:00:00 | AAPL | Stock | 191.2 | 191.2 | 191.17 | 191.17 | 1118.0 |
| 2023-11-21 06:05:00 | AAPL | Stock | 191.2 | 191.2 | 191.15 | 191.15 | 593.0 |
| 2023-11-21 06:10:00 | AAPL | Stock | 191.12 | 191.12 | 191.02 | 191.11 | 1593.0 |
| 2023-11-21 06:15:00 | AAPL | Stock | 191.01 | 191.01 | 190.92 | 190.92 | 1500.0 |
| 2023-11-21 06:20:00 | AAPL | Stock | 191.0 | 191.0 | 191.0 | 191.0 | 520.0 |
| 2023-11-21 06:35:00 | AAPL | Stock | 191.05 | 191.06 | 191.0 | 191.02 | 2502.0 |
| 2023-11-21 06:40:00 | AAPL | Stock | 191.1 | 191.13 | 191.1 | 191.13 | 848.0 |
| 2023-11-21 06:45:00 | AAPL | Stock | 191.18 | 191.18 | 191.13 | 191.16 | 682.0 |
| 2023-11-21 06:50:00 | AAPL | Stock | 191.08 | 191.25 | 191.08 | 191.25 | 518.0 |
| 2023-11-21 06:55:00 | AAPL | Stock | 191.25 | 191.25 | 191.13 | 191.13 | 1579.0 |
| 2023-11-21 07:00:00 | AAPL | Stock | 191.15 | 191.23 | 191.05 | 191.22 | 1887.0 |
| 2023-11-21 07:05:00 | AAPL | Stock | 191.23 | 191.29 | 191.21 | 191.21 | 2255.0 |
| 2023-11-21 07:10:00 | AAPL | Stock | 191.21 | 191.21 | 191.21 | 191.21 | 197.0 |
| 2023-11-21 07:15:00 | AAPL | Stock | 191.21 | 191.27 | 191.21 | 191.27 | 3858.0 |
| 2023-11-21 07:20:00 | AAPL | Stock | 191.26 | 191.26 | 191.26 | 191.26 | 1100.0 |
| 2023-11-21 07:25:00 | AAPL | Stock | 191.33 | 191.36 | 191.27 | 191.27 | 960.0 |
| 2023-11-21 07:30:00 | AAPL | Stock | 191.31 | 191.36 | 191.24 | 191.36 | 4750.0 |
| 2023-11-21 07:35:00 | AAPL | Stock | 191.44 | 191.44 | 191.33 | 191.37 | 2620.0 |
| 2023-11-21 07:40:00 | AAPL | Stock | 191.4 | 191.4 | 191.33 | 191.33 | 1671.0 |
| 2023-11-21 07:45:00 | AAPL | Stock | 191.3 | 191.31 | 191.26 | 191.26 | 459.0 |
| 2023-11-21 07:50:00 | AAPL | Stock | 191.21 | 191.21 | 191.2 | 191.2 | 600.0 |
| 2023-11-21 07:55:00 | AAPL | Stock | 191.25 | 191.25 | 191.15 | 191.15 | 1391.0 |
| 2023-11-21 08:00:00 | AAPL | Stock | 191.15 | 191.54 | 191.05 | 191.1 | 30237.0 |
| 2023-11-21 08:05:00 | AAPL | Stock | 191.1 | 191.12 | 191.052 | 191.052 | 3277.0 |
| 2023-11-21 08:10:00 | AAPL | Stock | 191.06 | 191.0988 | 191.01 | 191.0988 | 5233.0 |
| 2023-11-21 08:15:00 | AAPL | Stock | 191.06 | 191.07 | 190.85 | 190.9542 | 11659.0 |
| 2023-11-21 08:20:00 | AAPL | Stock | 190.96 | 191.14 | 190.9594 | 191.05 | 11583.0 |
| 2023-11-21 08:25:00 | AAPL | Stock | 191.0009 | 191.0811 | 190.9405 | 191.0 | 5819.0 |
| 2023-11-21 08:30:00 | AAPL | Stock | 191.0 | 191.095 | 191.0 | 191.0 | 10453.0 |
| 2023-11-21 08:35:00 | AAPL | Stock | 191.0 | 191.0 | 190.8292 | 190.87 | 9051.0 |
| 2023-11-21 08:40:00 | AAPL | Stock | 190.81 | 190.87 | 190.7121 | 190.8 | 19324.0 |
| 2023-11-21 08:45:00 | AAPL | Stock | 190.7707 | 190.85 | 190.77 | 190.77 | 4656.0 |
| 2023-11-21 08:50:00 | AAPL | Stock | 190.75 | 190.87 | 190.71 | 190.86 | 11881.0 |
| 2023-11-21 08:55:00 | AAPL | Stock | 190.84 | 190.84 | 190.59 | 190.6 | 21929.0 |
| 2023-11-21 09:00:00 | AAPL | Stock | 190.58 | 190.7 | 190.57 | 190.62 | 12744.0 |
| 2023-11-21 09:05:00 | AAPL | Stock | 190.62 | 190.8 | 190.6 | 190.79 | 14280.0 |
| 2023-11-21 09:10:00 | AAPL | Stock | 190.8 | 190.94 | 190.8 | 190.86 | 10514.0 |
| 2023-11-21 09:15:00 | AAPL | Stock | 190.86 | 190.87 | 190.75 | 190.8 | 9491.0 |
| 2023-11-21 09:20:00 | AAPL | Stock | 190.7994 | 190.84 | 190.79 | 190.8 | 8695.0 |
| 2023-11-21 09:25:00 | AAPL | Stock | 190.8 | 191.49 | 190.61 | 191.47 | 77269.0 |
| 2023-11-21 09:30:00 | AAPL | Stock | 191.46 | 191.52 | 190.92 | 191.21 | 1442008.0 |
> showing 50 of 392,845 rows — these rows as CSV