PREVIEW / stock_5min / 2023-11-03
file: by_date/stock_5min/2023/2023-11-03.parquet size: 6.6 MB rows: 405,460 symbols: 1,341
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-03 04:00:00 | AAPL | Stock | 172.08 | 172.5 | 172.04 | 172.41 | 9428.0 |
| 2023-11-03 04:05:00 | AAPL | Stock | 172.4 | 172.5 | 172.1 | 172.1 | 14074.0 |
| 2023-11-03 04:10:00 | AAPL | Stock | 172.11 | 172.2 | 171.93 | 172.13 | 11993.0 |
| 2023-11-03 04:15:00 | AAPL | Stock | 172.23 | 172.25 | 172.01 | 172.01 | 3970.0 |
| 2023-11-03 04:20:00 | AAPL | Stock | 172.23 | 172.25 | 172.2 | 172.2 | 2694.0 |
| 2023-11-03 04:25:00 | AAPL | Stock | 172.28 | 172.31 | 172.27 | 172.27 | 700.0 |
| 2023-11-03 04:30:00 | AAPL | Stock | 172.3 | 172.57 | 172.3 | 172.57 | 4452.0 |
| 2023-11-03 04:35:00 | AAPL | Stock | 172.59 | 172.63 | 172.4 | 172.4 | 2844.0 |
| 2023-11-03 04:40:00 | AAPL | Stock | 172.39 | 172.43 | 172.37 | 172.4 | 1998.0 |
| 2023-11-03 04:45:00 | AAPL | Stock | 172.51 | 172.55 | 171.99 | 172.1 | 12828.0 |
| 2023-11-03 04:50:00 | AAPL | Stock | 172.3 | 172.3 | 171.9 | 171.9 | 11638.0 |
| 2023-11-03 04:55:00 | AAPL | Stock | 171.9 | 171.9 | 171.51 | 171.6 | 10623.0 |
| 2023-11-03 05:00:00 | AAPL | Stock | 171.52 | 171.6 | 171.51 | 171.6 | 3388.0 |
| 2023-11-03 05:05:00 | AAPL | Stock | 171.74 | 171.8 | 171.62 | 171.8 | 1973.0 |
| 2023-11-03 05:10:00 | AAPL | Stock | 171.8 | 171.95 | 171.78 | 171.95 | 2782.0 |
| 2023-11-03 05:15:00 | AAPL | Stock | 171.99 | 171.99 | 171.76 | 171.8 | 1772.0 |
| 2023-11-03 05:20:00 | AAPL | Stock | 171.73 | 171.73 | 171.53 | 171.54 | 3981.0 |
| 2023-11-03 05:25:00 | AAPL | Stock | 171.52 | 171.65 | 171.5 | 171.6 | 5415.0 |
| 2023-11-03 05:30:00 | AAPL | Stock | 171.6 | 171.62 | 171.6 | 171.62 | 1240.0 |
| 2023-11-03 05:35:00 | AAPL | Stock | 171.62 | 171.65 | 171.62 | 171.65 | 967.0 |
| 2023-11-03 05:40:00 | AAPL | Stock | 171.64 | 171.64 | 171.6 | 171.6 | 1833.0 |
| 2023-11-03 05:45:00 | AAPL | Stock | 171.6 | 171.6 | 171.54 | 171.6 | 2371.0 |
| 2023-11-03 05:50:00 | AAPL | Stock | 171.64 | 171.88 | 171.64 | 171.85 | 14397.0 |
| 2023-11-03 05:55:00 | AAPL | Stock | 171.88 | 172.11 | 171.85 | 172.02 | 4844.0 |
| 2023-11-03 06:00:00 | AAPL | Stock | 172.09 | 172.09 | 172.09 | 172.09 | 781.0 |
| 2023-11-03 06:05:00 | AAPL | Stock | 172.19 | 172.2 | 172.0 | 172.2 | 3374.0 |
| 2023-11-03 06:10:00 | AAPL | Stock | 172.2 | 172.3 | 172.15 | 172.21 | 2989.0 |
| 2023-11-03 06:15:00 | AAPL | Stock | 172.22 | 172.22 | 172.0 | 172.0 | 4546.0 |
| 2023-11-03 06:20:00 | AAPL | Stock | 172.01 | 172.05 | 172.01 | 172.05 | 417.0 |
| 2023-11-03 06:25:00 | AAPL | Stock | 172.06 | 172.06 | 172.06 | 172.06 | 234.0 |
| 2023-11-03 06:30:00 | AAPL | Stock | 172.05 | 172.12 | 172.05 | 172.11 | 4334.0 |
| 2023-11-03 06:35:00 | AAPL | Stock | 172.08 | 172.11 | 172.07 | 172.11 | 1446.0 |
| 2023-11-03 06:40:00 | AAPL | Stock | 172.11 | 172.11 | 171.88 | 171.96 | 17803.0 |
| 2023-11-03 06:45:00 | AAPL | Stock | 171.96 | 172.05 | 171.9 | 172.05 | 4067.0 |
| 2023-11-03 06:50:00 | AAPL | Stock | 172.05 | 172.13 | 172.05 | 172.13 | 436.0 |
| 2023-11-03 07:00:00 | AAPL | Stock | 172.02 | 172.34 | 172.0 | 172.34 | 27024.0 |
| 2023-11-03 07:05:00 | AAPL | Stock | 172.27 | 172.4 | 172.1 | 172.15 | 17632.0 |
| 2023-11-03 07:10:00 | AAPL | Stock | 172.15 | 172.2 | 172.05 | 172.05 | 21802.0 |
| 2023-11-03 07:15:00 | AAPL | Stock | 172.08 | 172.55 | 172.01 | 172.44 | 12917.0 |
| 2023-11-03 07:20:00 | AAPL | Stock | 172.49 | 172.7 | 172.4 | 172.69 | 25519.0 |
| 2023-11-03 07:25:00 | AAPL | Stock | 172.69 | 172.79 | 172.56 | 172.74 | 23446.0 |
| 2023-11-03 07:30:00 | AAPL | Stock | 172.75 | 173.3 | 172.67 | 173.3 | 76152.0 |
| 2023-11-03 07:35:00 | AAPL | Stock | 173.29 | 173.49 | 173.06 | 173.49 | 51381.0 |
| 2023-11-03 07:40:00 | AAPL | Stock | 173.49 | 173.82 | 173.38 | 173.62 | 46376.0 |
| 2023-11-03 07:45:00 | AAPL | Stock | 173.6 | 173.62 | 173.45 | 173.62 | 19268.0 |
| 2023-11-03 07:50:00 | AAPL | Stock | 173.6 | 173.75 | 173.42 | 173.63 | 20622.0 |
| 2023-11-03 07:55:00 | AAPL | Stock | 173.63 | 174.53 | 173.57 | 174.01 | 100856.0 |
| 2023-11-03 08:00:00 | AAPL | Stock | 172.02 | 174.5397 | 171.89 | 173.55 | 315776.0 |
| 2023-11-03 08:05:00 | AAPL | Stock | 173.55 | 173.7 | 173.55 | 173.6 | 37705.0 |
| 2023-11-03 08:10:00 | AAPL | Stock | 173.6 | 173.9 | 173.6 | 173.85 | 26784.0 |
> showing 50 of 405,460 rows — these rows as CSV