PREVIEW / stock_5min / 2023-07-10
file: by_date/stock_5min/2023/2023-07-10.parquet size: 6.6 MB rows: 401,012 symbols: 1,543
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-10 04:00:00 | AAPL | Stock | 189.9 | 190.07 | 189.5 | 189.5 | 8875.0 |
| 2023-07-10 04:05:00 | AAPL | Stock | 189.62 | 189.63 | 189.34 | 189.35 | 7732.0 |
| 2023-07-10 04:10:00 | AAPL | Stock | 189.35 | 189.4 | 189.28 | 189.4 | 9782.0 |
| 2023-07-10 04:15:00 | AAPL | Stock | 189.46 | 189.5 | 189.4 | 189.49 | 5445.0 |
| 2023-07-10 04:20:00 | AAPL | Stock | 189.49 | 189.77 | 189.44 | 189.77 | 5525.0 |
| 2023-07-10 04:25:00 | AAPL | Stock | 189.6 | 189.6 | 189.4 | 189.4 | 10364.0 |
| 2023-07-10 04:30:00 | AAPL | Stock | 189.4 | 189.5 | 189.32 | 189.49 | 13571.0 |
| 2023-07-10 04:35:00 | AAPL | Stock | 189.46 | 189.46 | 189.45 | 189.45 | 200.0 |
| 2023-07-10 04:40:00 | AAPL | Stock | 189.4 | 189.4 | 189.36 | 189.4 | 2010.0 |
| 2023-07-10 04:45:00 | AAPL | Stock | 189.36 | 189.39 | 189.2 | 189.2 | 7053.0 |
| 2023-07-10 04:50:00 | AAPL | Stock | 189.2 | 189.2 | 189.2 | 189.2 | 998.0 |
| 2023-07-10 04:55:00 | AAPL | Stock | 189.22 | 189.22 | 189.22 | 189.22 | 1695.0 |
| 2023-07-10 05:00:00 | AAPL | Stock | 189.44 | 189.46 | 189.35 | 189.35 | 2860.0 |
| 2023-07-10 05:05:00 | AAPL | Stock | 189.47 | 189.5 | 189.42 | 189.42 | 2435.0 |
| 2023-07-10 05:10:00 | AAPL | Stock | 189.42 | 189.5 | 189.42 | 189.45 | 3861.0 |
| 2023-07-10 05:15:00 | AAPL | Stock | 189.42 | 189.42 | 189.18 | 189.2 | 5148.0 |
| 2023-07-10 05:20:00 | AAPL | Stock | 189.2 | 189.23 | 189.2 | 189.22 | 3798.0 |
| 2023-07-10 05:25:00 | AAPL | Stock | 189.36 | 189.36 | 189.2 | 189.2 | 4547.0 |
| 2023-07-10 05:30:00 | AAPL | Stock | 189.2 | 189.2 | 189.01 | 189.01 | 4413.0 |
| 2023-07-10 05:35:00 | AAPL | Stock | 189.02 | 189.1 | 189.0 | 189.1 | 3320.0 |
| 2023-07-10 05:40:00 | AAPL | Stock | 189.01 | 189.15 | 188.99 | 189.11 | 3724.0 |
| 2023-07-10 05:45:00 | AAPL | Stock | 189.15 | 189.24 | 189.07 | 189.07 | 632.0 |
| 2023-07-10 05:55:00 | AAPL | Stock | 189.18 | 189.19 | 189.18 | 189.19 | 838.0 |
| 2023-07-10 06:00:00 | AAPL | Stock | 189.13 | 189.13 | 188.99 | 188.99 | 4707.0 |
| 2023-07-10 06:05:00 | AAPL | Stock | 188.93 | 189.07 | 188.91 | 189.07 | 1327.0 |
| 2023-07-10 06:10:00 | AAPL | Stock | 189.06 | 189.12 | 189.0 | 189.0 | 3920.0 |
| 2023-07-10 06:15:00 | AAPL | Stock | 189.02 | 189.02 | 189.0 | 189.0 | 5674.0 |
| 2023-07-10 06:20:00 | AAPL | Stock | 189.03 | 189.03 | 188.94 | 188.95 | 12237.0 |
| 2023-07-10 06:25:00 | AAPL | Stock | 188.96 | 189.09 | 188.96 | 189.09 | 9681.0 |
| 2023-07-10 06:30:00 | AAPL | Stock | 189.06 | 189.06 | 188.96 | 188.96 | 4881.0 |
| 2023-07-10 06:35:00 | AAPL | Stock | 189.0 | 189.0 | 188.88 | 188.91 | 4126.0 |
| 2023-07-10 06:40:00 | AAPL | Stock | 188.91 | 188.91 | 188.88 | 188.91 | 7857.0 |
| 2023-07-10 06:45:00 | AAPL | Stock | 188.91 | 188.91 | 188.8 | 188.82 | 6534.0 |
| 2023-07-10 06:50:00 | AAPL | Stock | 188.98 | 189.08 | 188.97 | 189.08 | 3036.0 |
| 2023-07-10 06:55:00 | AAPL | Stock | 189.08 | 189.16 | 189.02 | 189.16 | 10189.0 |
| 2023-07-10 07:00:00 | AAPL | Stock | 189.12 | 189.36 | 189.12 | 189.3 | 30827.0 |
| 2023-07-10 07:05:00 | AAPL | Stock | 189.26 | 189.35 | 189.25 | 189.27 | 10630.0 |
| 2023-07-10 07:10:00 | AAPL | Stock | 189.28 | 189.37 | 189.2 | 189.22 | 23055.0 |
| 2023-07-10 07:15:00 | AAPL | Stock | 189.27 | 189.5 | 189.27 | 189.48 | 5783.0 |
| 2023-07-10 07:20:00 | AAPL | Stock | 189.5 | 189.55 | 189.4 | 189.43 | 7252.0 |
| 2023-07-10 07:25:00 | AAPL | Stock | 189.41 | 189.57 | 189.4 | 189.57 | 4874.0 |
| 2023-07-10 07:30:00 | AAPL | Stock | 189.54 | 189.65 | 189.54 | 189.63 | 3151.0 |
| 2023-07-10 07:35:00 | AAPL | Stock | 189.68 | 190.0 | 189.68 | 189.99 | 9944.0 |
| 2023-07-10 07:40:00 | AAPL | Stock | 189.99 | 189.99 | 189.89 | 189.93 | 4714.0 |
| 2023-07-10 07:45:00 | AAPL | Stock | 189.95 | 189.97 | 189.85 | 189.97 | 1918.0 |
| 2023-07-10 07:50:00 | AAPL | Stock | 189.96 | 190.07 | 189.96 | 190.06 | 4720.0 |
| 2023-07-10 07:55:00 | AAPL | Stock | 190.1 | 190.38 | 190.1 | 190.19 | 15349.0 |
| 2023-07-10 08:00:00 | AAPL | Stock | 189.27 | 190.35 | 189.15 | 190.11 | 56201.0 |
| 2023-07-10 08:05:00 | AAPL | Stock | 190.19 | 190.42 | 190.16 | 190.3 | 19215.0 |
| 2023-07-10 08:10:00 | AAPL | Stock | 190.31 | 190.327 | 190.12 | 190.14 | 13631.0 |
> showing 50 of 401,012 rows — these rows as CSV