PREVIEW / stock_5min / 2023-03-16
file: by_date/stock_5min/2023/2023-03-16.parquet size: 6.9 MB rows: 428,114 symbols: 1,743
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-03-16 04:00:00 | AAPL | Stock | 152.88 | 153.36 | 152.85 | 153.36 | 4299.0 |
| 2023-03-16 04:05:00 | AAPL | Stock | 153.36 | 153.44 | 153.2 | 153.3 | 2127.0 |
| 2023-03-16 04:10:00 | AAPL | Stock | 153.25 | 153.25 | 153.15 | 153.15 | 1420.0 |
| 2023-03-16 04:15:00 | AAPL | Stock | 153.08 | 153.08 | 153.0 | 153.0 | 1011.0 |
| 2023-03-16 04:20:00 | AAPL | Stock | 153.14 | 153.15 | 153.1 | 153.1 | 1567.0 |
| 2023-03-16 04:25:00 | AAPL | Stock | 153.15 | 153.25 | 153.15 | 153.25 | 1008.0 |
| 2023-03-16 04:30:00 | AAPL | Stock | 153.29 | 153.29 | 153.29 | 153.29 | 517.0 |
| 2023-03-16 04:35:00 | AAPL | Stock | 153.25 | 153.27 | 153.25 | 153.27 | 595.0 |
| 2023-03-16 04:40:00 | AAPL | Stock | 153.2 | 153.35 | 153.2 | 153.35 | 3202.0 |
| 2023-03-16 04:45:00 | AAPL | Stock | 153.32 | 153.32 | 153.27 | 153.27 | 269.0 |
| 2023-03-16 04:50:00 | AAPL | Stock | 153.17 | 153.17 | 153.15 | 153.16 | 353.0 |
| 2023-03-16 04:55:00 | AAPL | Stock | 153.02 | 153.03 | 153.02 | 153.02 | 1865.0 |
| 2023-03-16 05:00:00 | AAPL | Stock | 153.15 | 153.15 | 153.03 | 153.03 | 981.0 |
| 2023-03-16 05:05:00 | AAPL | Stock | 153.03 | 153.03 | 153.0 | 153.0 | 597.0 |
| 2023-03-16 05:10:00 | AAPL | Stock | 153.2 | 153.2 | 153.17 | 153.17 | 308.0 |
| 2023-03-16 05:15:00 | AAPL | Stock | 152.93 | 152.96 | 152.93 | 152.96 | 468.0 |
| 2023-03-16 05:20:00 | AAPL | Stock | 152.9 | 152.9 | 152.76 | 152.76 | 800.0 |
| 2023-03-16 05:25:00 | AAPL | Stock | 152.95 | 153.02 | 152.94 | 153.02 | 2751.0 |
| 2023-03-16 05:30:00 | AAPL | Stock | 153.02 | 153.02 | 153.02 | 153.02 | 336.0 |
| 2023-03-16 05:35:00 | AAPL | Stock | 152.95 | 152.95 | 152.95 | 152.95 | 100.0 |
| 2023-03-16 05:40:00 | AAPL | Stock | 152.99 | 152.99 | 152.86 | 152.86 | 1727.0 |
| 2023-03-16 05:45:00 | AAPL | Stock | 152.9 | 152.9 | 152.9 | 152.9 | 200.0 |
| 2023-03-16 05:50:00 | AAPL | Stock | 152.81 | 152.82 | 152.69 | 152.81 | 4500.0 |
| 2023-03-16 05:55:00 | AAPL | Stock | 152.9 | 152.99 | 152.9 | 152.99 | 1283.0 |
| 2023-03-16 06:00:00 | AAPL | Stock | 152.94 | 152.94 | 152.94 | 152.94 | 980.0 |
| 2023-03-16 06:05:00 | AAPL | Stock | 152.99 | 152.99 | 152.95 | 152.95 | 300.0 |
| 2023-03-16 06:10:00 | AAPL | Stock | 152.9 | 152.9 | 152.87 | 152.87 | 676.0 |
| 2023-03-16 06:15:00 | AAPL | Stock | 152.87 | 152.94 | 152.87 | 152.94 | 516.0 |
| 2023-03-16 06:20:00 | AAPL | Stock | 152.93 | 153.03 | 152.93 | 153.03 | 2061.0 |
| 2023-03-16 06:25:00 | AAPL | Stock | 152.84 | 152.93 | 152.84 | 152.93 | 777.0 |
| 2023-03-16 06:30:00 | AAPL | Stock | 152.99 | 152.99 | 152.99 | 152.99 | 1025.0 |
| 2023-03-16 06:35:00 | AAPL | Stock | 153.0 | 153.03 | 153.0 | 153.03 | 1648.0 |
| 2023-03-16 06:40:00 | AAPL | Stock | 153.03 | 153.03 | 152.96 | 152.96 | 1109.0 |
| 2023-03-16 06:45:00 | AAPL | Stock | 152.99 | 152.99 | 152.91 | 152.91 | 908.0 |
| 2023-03-16 06:50:00 | AAPL | Stock | 152.88 | 152.88 | 152.71 | 152.71 | 861.0 |
| 2023-03-16 06:55:00 | AAPL | Stock | 152.75 | 152.76 | 152.75 | 152.76 | 630.0 |
| 2023-03-16 07:00:00 | AAPL | Stock | 152.9 | 152.9 | 152.68 | 152.8 | 4624.0 |
| 2023-03-16 07:05:00 | AAPL | Stock | 152.7 | 152.72 | 152.51 | 152.54 | 1893.0 |
| 2023-03-16 07:10:00 | AAPL | Stock | 152.63 | 152.63 | 152.53 | 152.56 | 1524.0 |
| 2023-03-16 07:20:00 | AAPL | Stock | 152.55 | 152.61 | 152.54 | 152.61 | 1112.0 |
| 2023-03-16 07:25:00 | AAPL | Stock | 152.6 | 152.6 | 152.6 | 152.6 | 900.0 |
| 2023-03-16 07:30:00 | AAPL | Stock | 152.69 | 152.9 | 152.69 | 152.84 | 996.0 |
| 2023-03-16 07:35:00 | AAPL | Stock | 152.81 | 152.88 | 152.81 | 152.87 | 794.0 |
| 2023-03-16 07:40:00 | AAPL | Stock | 152.89 | 152.9 | 152.83 | 152.9 | 900.0 |
| 2023-03-16 07:45:00 | AAPL | Stock | 152.92 | 153.21 | 152.92 | 153.21 | 12569.0 |
| 2023-03-16 07:50:00 | AAPL | Stock | 153.21 | 153.25 | 152.99 | 152.99 | 2702.0 |
| 2023-03-16 07:55:00 | AAPL | Stock | 152.95 | 152.98 | 152.91 | 152.96 | 1429.0 |
| 2023-03-16 08:00:00 | AAPL | Stock | 152.55 | 153.22 | 152.28 | 153.03 | 31293.0 |
| 2023-03-16 08:05:00 | AAPL | Stock | 152.99 | 152.99 | 152.8 | 152.8 | 4779.0 |
| 2023-03-16 08:10:00 | AAPL | Stock | 152.8 | 153.09 | 152.8 | 153.09 | 6829.0 |
> showing 50 of 428,114 rows — these rows as CSV