PREVIEW / stock_5min / 2023-10-09
file: by_date/stock_5min/2023/2023-10-09.parquet size: 6.2 MB rows: 378,183 symbols: 1,360
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-09 04:00:00 | AAPL | Stock | 176.0 | 176.3 | 175.73 | 176.02 | 7480.0 |
| 2023-10-09 04:05:00 | AAPL | Stock | 176.02 | 176.02 | 175.75 | 175.75 | 2062.0 |
| 2023-10-09 04:10:00 | AAPL | Stock | 175.91 | 175.91 | 175.77 | 175.78 | 1100.0 |
| 2023-10-09 04:15:00 | AAPL | Stock | 175.88 | 175.95 | 175.78 | 175.89 | 522.0 |
| 2023-10-09 04:20:00 | AAPL | Stock | 175.85 | 175.85 | 175.8 | 175.8 | 1144.0 |
| 2023-10-09 04:25:00 | AAPL | Stock | 175.8 | 175.8 | 175.78 | 175.8 | 1331.0 |
| 2023-10-09 04:30:00 | AAPL | Stock | 175.81 | 175.94 | 175.81 | 175.94 | 420.0 |
| 2023-10-09 04:35:00 | AAPL | Stock | 175.95 | 176.07 | 175.93 | 176.07 | 2751.0 |
| 2023-10-09 04:40:00 | AAPL | Stock | 176.07 | 176.08 | 176.04 | 176.04 | 1100.0 |
| 2023-10-09 04:45:00 | AAPL | Stock | 176.08 | 176.08 | 176.0 | 176.07 | 1892.0 |
| 2023-10-09 04:50:00 | AAPL | Stock | 176.07 | 176.15 | 176.07 | 176.14 | 1366.0 |
| 2023-10-09 04:55:00 | AAPL | Stock | 176.14 | 176.18 | 176.14 | 176.18 | 499.0 |
| 2023-10-09 05:00:00 | AAPL | Stock | 176.1 | 176.1 | 176.04 | 176.04 | 781.0 |
| 2023-10-09 05:05:00 | AAPL | Stock | 176.15 | 176.17 | 176.15 | 176.17 | 300.0 |
| 2023-10-09 05:10:00 | AAPL | Stock | 176.15 | 176.15 | 176.05 | 176.06 | 1500.0 |
| 2023-10-09 05:15:00 | AAPL | Stock | 176.1 | 176.11 | 176.09 | 176.11 | 1257.0 |
| 2023-10-09 05:35:00 | AAPL | Stock | 176.01 | 176.01 | 176.0 | 176.0 | 883.0 |
| 2023-10-09 05:40:00 | AAPL | Stock | 175.9 | 175.9 | 175.9 | 175.9 | 688.0 |
| 2023-10-09 05:50:00 | AAPL | Stock | 175.86 | 175.88 | 175.84 | 175.88 | 4979.0 |
| 2023-10-09 06:00:00 | AAPL | Stock | 175.99 | 176.04 | 175.99 | 176.04 | 1207.0 |
| 2023-10-09 06:05:00 | AAPL | Stock | 176.06 | 176.15 | 176.05 | 176.14 | 5465.0 |
| 2023-10-09 06:10:00 | AAPL | Stock | 176.13 | 176.2 | 176.13 | 176.2 | 2114.0 |
| 2023-10-09 06:15:00 | AAPL | Stock | 176.28 | 176.3 | 176.26 | 176.28 | 1881.0 |
| 2023-10-09 06:20:00 | AAPL | Stock | 176.28 | 176.35 | 176.28 | 176.35 | 920.0 |
| 2023-10-09 06:25:00 | AAPL | Stock | 176.22 | 176.22 | 176.15 | 176.16 | 600.0 |
| 2023-10-09 06:30:00 | AAPL | Stock | 176.18 | 176.18 | 176.14 | 176.15 | 591.0 |
| 2023-10-09 06:35:00 | AAPL | Stock | 176.2 | 176.21 | 176.18 | 176.18 | 925.0 |
| 2023-10-09 06:40:00 | AAPL | Stock | 176.16 | 176.16 | 176.15 | 176.15 | 869.0 |
| 2023-10-09 06:45:00 | AAPL | Stock | 176.15 | 176.15 | 176.1 | 176.1 | 6550.0 |
| 2023-10-09 06:50:00 | AAPL | Stock | 176.09 | 176.1 | 176.03 | 176.03 | 4230.0 |
| 2023-10-09 06:55:00 | AAPL | Stock | 176.07 | 176.07 | 176.0 | 176.0 | 3396.0 |
| 2023-10-09 07:00:00 | AAPL | Stock | 175.98 | 176.08 | 175.98 | 176.0 | 6054.0 |
| 2023-10-09 07:05:00 | AAPL | Stock | 175.95 | 176.03 | 175.88 | 175.98 | 17075.0 |
| 2023-10-09 07:10:00 | AAPL | Stock | 176.06 | 176.06 | 176.01 | 176.05 | 2289.0 |
| 2023-10-09 07:15:00 | AAPL | Stock | 176.06 | 176.06 | 175.85 | 175.85 | 7946.0 |
| 2023-10-09 07:20:00 | AAPL | Stock | 175.89 | 176.03 | 175.85 | 175.98 | 3406.0 |
| 2023-10-09 07:25:00 | AAPL | Stock | 176.0 | 176.0 | 175.95 | 175.99 | 1835.0 |
| 2023-10-09 07:30:00 | AAPL | Stock | 175.99 | 175.99 | 175.9 | 175.95 | 1153.0 |
| 2023-10-09 07:35:00 | AAPL | Stock | 176.0 | 176.0 | 175.92 | 175.92 | 702.0 |
| 2023-10-09 07:40:00 | AAPL | Stock | 175.92 | 175.92 | 175.85 | 175.85 | 4117.0 |
| 2023-10-09 07:50:00 | AAPL | Stock | 175.9 | 175.95 | 175.89 | 175.93 | 3247.0 |
| 2023-10-09 07:55:00 | AAPL | Stock | 175.98 | 176.03 | 175.98 | 176.01 | 2160.0 |
| 2023-10-09 08:00:00 | AAPL | Stock | 175.94 | 176.19 | 175.5 | 176.15 | 70847.0 |
| 2023-10-09 08:05:00 | AAPL | Stock | 176.15 | 176.315 | 176.02 | 176.315 | 5458.0 |
| 2023-10-09 08:10:00 | AAPL | Stock | 176.28 | 176.4 | 176.25 | 176.36 | 9399.0 |
| 2023-10-09 08:15:00 | AAPL | Stock | 176.36 | 176.36 | 176.2123 | 176.34 | 4270.0 |
| 2023-10-09 08:20:00 | AAPL | Stock | 176.3 | 176.3 | 176.0 | 176.0101 | 15006.0 |
| 2023-10-09 08:25:00 | AAPL | Stock | 176.05 | 176.3497 | 176.0 | 176.24 | 8578.0 |
| 2023-10-09 08:30:00 | AAPL | Stock | 176.22 | 176.4899 | 176.2 | 176.38 | 46891.0 |
| 2023-10-09 08:35:00 | AAPL | Stock | 176.33 | 176.35 | 176.14 | 176.14 | 7710.0 |
> showing 50 of 378,183 rows — these rows as CSV