PREVIEW / stock_5min / 2023-04-05
file: by_date/stock_5min/2023/2023-04-05.parquet size: 6.5 MB rows: 403,478 symbols: 1,703
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-04-05 04:00:00 | AAPL | Stock | 165.68 | 165.68 | 165.29 | 165.33 | 3472.0 |
| 2023-04-05 04:05:00 | AAPL | Stock | 165.4 | 165.55 | 165.4 | 165.48 | 4020.0 |
| 2023-04-05 04:15:00 | AAPL | Stock | 165.32 | 165.32 | 165.3 | 165.3 | 2745.0 |
| 2023-04-05 04:20:00 | AAPL | Stock | 165.31 | 165.31 | 165.31 | 165.31 | 237.0 |
| 2023-04-05 04:25:00 | AAPL | Stock | 165.32 | 165.32 | 165.32 | 165.32 | 100.0 |
| 2023-04-05 04:30:00 | AAPL | Stock | 165.31 | 165.32 | 165.28 | 165.28 | 869.0 |
| 2023-04-05 04:45:00 | AAPL | Stock | 165.12 | 165.12 | 165.1 | 165.12 | 727.0 |
| 2023-04-05 04:50:00 | AAPL | Stock | 165.14 | 165.35 | 165.14 | 165.35 | 650.0 |
| 2023-04-05 04:55:00 | AAPL | Stock | 165.34 | 165.34 | 165.34 | 165.34 | 197.0 |
| 2023-04-05 05:00:00 | AAPL | Stock | 165.29 | 165.32 | 165.29 | 165.32 | 1030.0 |
| 2023-04-05 05:05:00 | AAPL | Stock | 165.32 | 165.35 | 165.29 | 165.35 | 5903.0 |
| 2023-04-05 05:10:00 | AAPL | Stock | 165.23 | 165.34 | 165.23 | 165.34 | 850.0 |
| 2023-04-05 05:15:00 | AAPL | Stock | 165.34 | 165.34 | 165.34 | 165.34 | 329.0 |
| 2023-04-05 05:25:00 | AAPL | Stock | 165.24 | 165.24 | 165.24 | 165.24 | 100.0 |
| 2023-04-05 05:30:00 | AAPL | Stock | 165.24 | 165.24 | 165.23 | 165.23 | 3007.0 |
| 2023-04-05 05:35:00 | AAPL | Stock | 165.26 | 165.28 | 165.26 | 165.28 | 324.0 |
| 2023-04-05 05:40:00 | AAPL | Stock | 165.27 | 165.33 | 165.26 | 165.26 | 609.0 |
| 2023-04-05 05:45:00 | AAPL | Stock | 165.26 | 165.32 | 165.26 | 165.32 | 467.0 |
| 2023-04-05 05:50:00 | AAPL | Stock | 165.26 | 165.26 | 165.2 | 165.2 | 3354.0 |
| 2023-04-05 05:55:00 | AAPL | Stock | 165.19 | 165.2 | 165.17 | 165.2 | 860.0 |
| 2023-04-05 06:00:00 | AAPL | Stock | 165.25 | 165.3 | 165.24 | 165.24 | 2311.0 |
| 2023-04-05 06:15:00 | AAPL | Stock | 165.3 | 165.37 | 165.3 | 165.35 | 5262.0 |
| 2023-04-05 06:30:00 | AAPL | Stock | 165.38 | 165.38 | 165.22 | 165.22 | 2528.0 |
| 2023-04-05 06:40:00 | AAPL | Stock | 165.33 | 165.37 | 165.33 | 165.33 | 795.0 |
| 2023-04-05 06:45:00 | AAPL | Stock | 165.33 | 165.38 | 165.33 | 165.38 | 3787.0 |
| 2023-04-05 06:50:00 | AAPL | Stock | 165.39 | 165.39 | 165.36 | 165.36 | 600.0 |
| 2023-04-05 06:55:00 | AAPL | Stock | 165.32 | 165.38 | 165.32 | 165.38 | 621.0 |
| 2023-04-05 07:00:00 | AAPL | Stock | 165.32 | 165.6 | 165.3 | 165.35 | 11505.0 |
| 2023-04-05 07:05:00 | AAPL | Stock | 165.39 | 165.46 | 165.38 | 165.46 | 7928.0 |
| 2023-04-05 07:10:00 | AAPL | Stock | 165.4 | 165.4 | 165.4 | 165.4 | 2374.0 |
| 2023-04-05 07:15:00 | AAPL | Stock | 165.47 | 165.49 | 165.47 | 165.49 | 400.0 |
| 2023-04-05 07:20:00 | AAPL | Stock | 165.51 | 165.71 | 165.5 | 165.7 | 2438.0 |
| 2023-04-05 07:25:00 | AAPL | Stock | 165.7 | 165.79 | 165.64 | 165.65 | 8036.0 |
| 2023-04-05 07:30:00 | AAPL | Stock | 165.69 | 165.75 | 165.68 | 165.68 | 1894.0 |
| 2023-04-05 07:35:00 | AAPL | Stock | 165.68 | 165.77 | 165.63 | 165.63 | 4065.0 |
| 2023-04-05 07:40:00 | AAPL | Stock | 165.59 | 165.59 | 165.52 | 165.55 | 9182.0 |
| 2023-04-05 07:45:00 | AAPL | Stock | 165.58 | 165.7 | 165.58 | 165.7 | 4312.0 |
| 2023-04-05 07:50:00 | AAPL | Stock | 165.73 | 165.75 | 165.7 | 165.75 | 3079.0 |
| 2023-04-05 07:55:00 | AAPL | Stock | 165.7 | 165.7 | 165.6 | 165.6 | 4433.0 |
| 2023-04-05 08:00:00 | AAPL | Stock | 165.46 | 165.8 | 165.06 | 165.69 | 49262.0 |
| 2023-04-05 08:05:00 | AAPL | Stock | 165.67 | 165.67 | 165.55 | 165.56 | 2550.0 |
| 2023-04-05 08:10:00 | AAPL | Stock | 165.51 | 165.54 | 165.3 | 165.35 | 17878.0 |
| 2023-04-05 08:15:00 | AAPL | Stock | 165.4 | 165.6 | 165.35 | 165.5 | 4518.0 |
| 2023-04-05 08:20:00 | AAPL | Stock | 165.52 | 165.8 | 165.52 | 165.61 | 7973.0 |
| 2023-04-05 08:25:00 | AAPL | Stock | 165.75 | 165.75 | 165.31 | 165.43 | 12160.0 |
| 2023-04-05 08:30:00 | AAPL | Stock | 165.465 | 165.5 | 165.15 | 165.17 | 20222.0 |
| 2023-04-05 08:35:00 | AAPL | Stock | 165.16 | 165.25 | 165.13 | 165.22 | 18841.0 |
| 2023-04-05 08:40:00 | AAPL | Stock | 165.25 | 165.41 | 165.25 | 165.26 | 12804.0 |
| 2023-04-05 08:45:00 | AAPL | Stock | 165.25 | 165.35 | 165.19 | 165.35 | 4888.0 |
| 2023-04-05 08:50:00 | AAPL | Stock | 165.38 | 165.38 | 165.12 | 165.2 | 12206.0 |
> showing 50 of 403,478 rows — these rows as CSV