PREVIEW / stock_5min / 2023-07-21
file: by_date/stock_5min/2023/2023-07-21.parquet size: 6.5 MB rows: 397,063 symbols: 1,549
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-07-21 04:00:00 | AAPL | Stock | 193.13 | 193.36 | 193.13 | 193.22 | 1099.0 |
| 2023-07-21 04:05:00 | AAPL | Stock | 193.3 | 193.3 | 193.13 | 193.2 | 2947.0 |
| 2023-07-21 04:10:00 | AAPL | Stock | 193.13 | 193.13 | 193.04 | 193.04 | 766.0 |
| 2023-07-21 04:15:00 | AAPL | Stock | 193.13 | 193.13 | 193.07 | 193.08 | 437.0 |
| 2023-07-21 04:20:00 | AAPL | Stock | 193.15 | 193.15 | 193.14 | 193.14 | 692.0 |
| 2023-07-21 04:25:00 | AAPL | Stock | 193.15 | 193.26 | 193.15 | 193.26 | 944.0 |
| 2023-07-21 04:30:00 | AAPL | Stock | 193.16 | 193.16 | 193.16 | 193.16 | 1131.0 |
| 2023-07-21 04:35:00 | AAPL | Stock | 193.22 | 193.23 | 193.16 | 193.16 | 2141.0 |
| 2023-07-21 04:40:00 | AAPL | Stock | 193.19 | 193.21 | 193.19 | 193.21 | 450.0 |
| 2023-07-21 04:45:00 | AAPL | Stock | 193.2 | 193.21 | 193.12 | 193.12 | 1263.0 |
| 2023-07-21 04:55:00 | AAPL | Stock | 193.18 | 193.18 | 193.18 | 193.18 | 220.0 |
| 2023-07-21 05:00:00 | AAPL | Stock | 193.01 | 193.01 | 193.01 | 193.01 | 131.0 |
| 2023-07-21 05:05:00 | AAPL | Stock | 193.01 | 193.08 | 193.01 | 193.08 | 200.0 |
| 2023-07-21 05:10:00 | AAPL | Stock | 193.05 | 193.05 | 193.05 | 193.05 | 101.0 |
| 2023-07-21 05:15:00 | AAPL | Stock | 193.01 | 193.01 | 193.01 | 193.01 | 200.0 |
| 2023-07-21 05:20:00 | AAPL | Stock | 193.06 | 193.07 | 193.06 | 193.07 | 200.0 |
| 2023-07-21 05:30:00 | AAPL | Stock | 193.01 | 193.01 | 193.0 | 193.0 | 741.0 |
| 2023-07-21 05:35:00 | AAPL | Stock | 192.91 | 192.94 | 192.89 | 192.89 | 521.0 |
| 2023-07-21 05:40:00 | AAPL | Stock | 192.78 | 192.78 | 192.78 | 192.78 | 100.0 |
| 2023-07-21 05:50:00 | AAPL | Stock | 193.03 | 193.03 | 192.91 | 192.91 | 436.0 |
| 2023-07-21 05:55:00 | AAPL | Stock | 192.9 | 193.0 | 192.9 | 192.96 | 650.0 |
| 2023-07-21 06:00:00 | AAPL | Stock | 192.94 | 193.0 | 192.94 | 193.0 | 1167.0 |
| 2023-07-21 06:05:00 | AAPL | Stock | 193.1 | 193.11 | 193.1 | 193.11 | 323.0 |
| 2023-07-21 06:15:00 | AAPL | Stock | 193.13 | 193.13 | 193.13 | 193.13 | 112.0 |
| 2023-07-21 06:20:00 | AAPL | Stock | 193.24 | 193.3 | 193.24 | 193.3 | 950.0 |
| 2023-07-21 06:25:00 | AAPL | Stock | 193.21 | 193.21 | 193.21 | 193.21 | 100.0 |
| 2023-07-21 06:30:00 | AAPL | Stock | 193.32 | 193.32 | 193.32 | 193.32 | 662.0 |
| 2023-07-21 06:40:00 | AAPL | Stock | 193.4 | 193.4 | 193.38 | 193.39 | 1684.0 |
| 2023-07-21 06:45:00 | AAPL | Stock | 193.39 | 193.39 | 193.2 | 193.2 | 380.0 |
| 2023-07-21 06:55:00 | AAPL | Stock | 193.38 | 193.38 | 193.38 | 193.38 | 100.0 |
| 2023-07-21 07:00:00 | AAPL | Stock | 193.35 | 193.7 | 193.3 | 193.65 | 7288.0 |
| 2023-07-21 07:05:00 | AAPL | Stock | 193.61 | 193.61 | 193.46 | 193.59 | 5264.0 |
| 2023-07-21 07:10:00 | AAPL | Stock | 193.55 | 193.59 | 193.5 | 193.5 | 1757.0 |
| 2023-07-21 07:15:00 | AAPL | Stock | 193.56 | 193.56 | 193.46 | 193.47 | 1062.0 |
| 2023-07-21 07:20:00 | AAPL | Stock | 193.5 | 193.5 | 193.48 | 193.5 | 1527.0 |
| 2023-07-21 07:25:00 | AAPL | Stock | 193.53 | 193.55 | 193.47 | 193.47 | 2303.0 |
| 2023-07-21 07:30:00 | AAPL | Stock | 193.48 | 193.48 | 193.31 | 193.31 | 3480.0 |
| 2023-07-21 07:35:00 | AAPL | Stock | 193.4 | 193.44 | 193.4 | 193.42 | 2028.0 |
| 2023-07-21 07:40:00 | AAPL | Stock | 193.44 | 193.44 | 193.32 | 193.33 | 1790.0 |
| 2023-07-21 07:45:00 | AAPL | Stock | 193.49 | 193.49 | 193.41 | 193.41 | 400.0 |
| 2023-07-21 07:50:00 | AAPL | Stock | 193.45 | 193.49 | 193.36 | 193.36 | 1618.0 |
| 2023-07-21 07:55:00 | AAPL | Stock | 193.42 | 193.47 | 193.33 | 193.33 | 3072.0 |
| 2023-07-21 08:00:00 | AAPL | Stock | 193.335 | 193.7 | 193.0 | 193.49 | 51497.0 |
| 2023-07-21 08:05:00 | AAPL | Stock | 193.495 | 193.65 | 193.495 | 193.63 | 5063.0 |
| 2023-07-21 08:10:00 | AAPL | Stock | 193.64 | 193.68 | 193.6 | 193.68 | 3932.0 |
| 2023-07-21 08:15:00 | AAPL | Stock | 193.69 | 193.88 | 193.69 | 193.8601 | 11347.0 |
| 2023-07-21 08:20:00 | AAPL | Stock | 193.86 | 193.89 | 193.7201 | 193.89 | 14408.0 |
| 2023-07-21 08:25:00 | AAPL | Stock | 193.87 | 193.8899 | 193.81 | 193.8892 | 5898.0 |
| 2023-07-21 08:30:00 | AAPL | Stock | 193.84 | 193.87 | 193.72 | 193.75 | 5507.0 |
| 2023-07-21 08:35:00 | AAPL | Stock | 193.8 | 193.9 | 193.79 | 193.87 | 2461.0 |
> showing 50 of 397,063 rows — these rows as CSV