PREVIEW / stock_5min / 2023-10-05
file: by_date/stock_5min/2023/2023-10-05.parquet size: 6.3 MB rows: 387,219 symbols: 1,396
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-10-05 04:00:00 | AAPL | Stock | 173.23 | 173.31 | 173.23 | 173.26 | 1268.0 |
| 2023-10-05 04:05:00 | AAPL | Stock | 173.2 | 173.25 | 173.2 | 173.25 | 300.0 |
| 2023-10-05 04:15:00 | AAPL | Stock | 173.2 | 173.2 | 173.2 | 173.2 | 200.0 |
| 2023-10-05 04:20:00 | AAPL | Stock | 173.22 | 173.3 | 173.22 | 173.3 | 437.0 |
| 2023-10-05 04:25:00 | AAPL | Stock | 173.34 | 173.34 | 173.34 | 173.34 | 166.0 |
| 2023-10-05 04:30:00 | AAPL | Stock | 173.39 | 173.4 | 173.39 | 173.4 | 353.0 |
| 2023-10-05 04:40:00 | AAPL | Stock | 173.36 | 173.36 | 173.36 | 173.36 | 350.0 |
| 2023-10-05 04:50:00 | AAPL | Stock | 173.1 | 173.1 | 173.09 | 173.09 | 368.0 |
| 2023-10-05 04:55:00 | AAPL | Stock | 173.08 | 173.08 | 172.92 | 172.92 | 1588.0 |
| 2023-10-05 05:00:00 | AAPL | Stock | 172.9 | 172.9 | 172.9 | 172.9 | 100.0 |
| 2023-10-05 05:05:00 | AAPL | Stock | 173.0 | 173.0 | 173.0 | 173.0 | 110.0 |
| 2023-10-05 05:10:00 | AAPL | Stock | 173.0 | 173.0 | 172.98 | 173.0 | 1496.0 |
| 2023-10-05 05:15:00 | AAPL | Stock | 172.92 | 173.0 | 172.8 | 173.0 | 5474.0 |
| 2023-10-05 05:20:00 | AAPL | Stock | 173.01 | 173.09 | 173.0 | 173.09 | 4745.0 |
| 2023-10-05 05:25:00 | AAPL | Stock | 173.0 | 173.01 | 173.0 | 173.0 | 14999.0 |
| 2023-10-05 05:40:00 | AAPL | Stock | 172.9 | 172.92 | 172.9 | 172.92 | 335.0 |
| 2023-10-05 05:45:00 | AAPL | Stock | 172.94 | 172.95 | 172.94 | 172.95 | 260.0 |
| 2023-10-05 05:50:00 | AAPL | Stock | 173.0 | 173.0 | 173.0 | 173.0 | 100.0 |
| 2023-10-05 05:55:00 | AAPL | Stock | 173.05 | 173.05 | 173.05 | 173.05 | 100.0 |
| 2023-10-05 06:05:00 | AAPL | Stock | 173.08 | 173.15 | 173.08 | 173.15 | 960.0 |
| 2023-10-05 06:10:00 | AAPL | Stock | 173.22 | 173.35 | 173.22 | 173.35 | 1536.0 |
| 2023-10-05 06:15:00 | AAPL | Stock | 173.26 | 173.26 | 173.26 | 173.26 | 100.0 |
| 2023-10-05 06:25:00 | AAPL | Stock | 173.26 | 173.3 | 173.26 | 173.3 | 297.0 |
| 2023-10-05 06:30:00 | AAPL | Stock | 173.3 | 173.32 | 173.3 | 173.3 | 838.0 |
| 2023-10-05 06:35:00 | AAPL | Stock | 173.37 | 173.51 | 173.37 | 173.5 | 1593.0 |
| 2023-10-05 06:45:00 | AAPL | Stock | 173.38 | 173.38 | 173.38 | 173.38 | 400.0 |
| 2023-10-05 06:55:00 | AAPL | Stock | 173.41 | 173.48 | 173.41 | 173.48 | 208.0 |
| 2023-10-05 07:00:00 | AAPL | Stock | 173.41 | 173.68 | 173.41 | 173.63 | 7383.0 |
| 2023-10-05 07:05:00 | AAPL | Stock | 173.6 | 173.6 | 173.46 | 173.46 | 413.0 |
| 2023-10-05 07:10:00 | AAPL | Stock | 173.51 | 173.51 | 173.51 | 173.51 | 100.0 |
| 2023-10-05 07:15:00 | AAPL | Stock | 173.5 | 173.5 | 173.34 | 173.34 | 6532.0 |
| 2023-10-05 07:20:00 | AAPL | Stock | 173.35 | 173.53 | 173.35 | 173.49 | 2025.0 |
| 2023-10-05 07:25:00 | AAPL | Stock | 173.5 | 173.5 | 173.5 | 173.5 | 474.0 |
| 2023-10-05 07:30:00 | AAPL | Stock | 173.52 | 173.6 | 173.52 | 173.6 | 300.0 |
| 2023-10-05 07:35:00 | AAPL | Stock | 173.59 | 173.75 | 173.59 | 173.75 | 1450.0 |
| 2023-10-05 07:40:00 | AAPL | Stock | 173.71 | 173.73 | 173.7 | 173.73 | 889.0 |
| 2023-10-05 07:45:00 | AAPL | Stock | 173.69 | 173.77 | 173.69 | 173.77 | 1504.0 |
| 2023-10-05 07:50:00 | AAPL | Stock | 173.8 | 173.85 | 173.77 | 173.77 | 9799.0 |
| 2023-10-05 08:00:00 | AAPL | Stock | 173.69 | 174.0 | 172.805 | 174.0 | 31662.0 |
| 2023-10-05 08:05:00 | AAPL | Stock | 174.0 | 174.1106 | 173.83 | 173.83 | 14990.0 |
| 2023-10-05 08:10:00 | AAPL | Stock | 173.89 | 173.9 | 173.65 | 173.65 | 15385.0 |
| 2023-10-05 08:15:00 | AAPL | Stock | 173.72 | 173.79 | 173.5905 | 173.5905 | 5979.0 |
| 2023-10-05 08:20:00 | AAPL | Stock | 173.6 | 173.65 | 173.56 | 173.59 | 2802.0 |
| 2023-10-05 08:25:00 | AAPL | Stock | 173.55 | 173.6 | 173.5 | 173.6 | 3920.0 |
| 2023-10-05 08:30:00 | AAPL | Stock | 173.66 | 173.67 | 173.02 | 173.19 | 16296.0 |
| 2023-10-05 08:35:00 | AAPL | Stock | 173.17 | 173.2 | 172.8 | 172.9201 | 28836.0 |
| 2023-10-05 08:40:00 | AAPL | Stock | 172.9216 | 173.0 | 172.82 | 172.94 | 12639.0 |
| 2023-10-05 08:45:00 | AAPL | Stock | 172.9399 | 173.259 | 172.91 | 173.15 | 9219.0 |
| 2023-10-05 08:50:00 | AAPL | Stock | 173.14 | 173.23 | 173.05 | 173.12 | 4922.0 |
| 2023-10-05 08:55:00 | AAPL | Stock | 173.11 | 173.3 | 173.11 | 173.3 | 2704.0 |
> showing 50 of 387,219 rows — these rows as CSV