PREVIEW / stock_5min / 2023-10-04
file: by_date/stock_5min/2023/2023-10-04.parquet size: 6.4 MB rows: 395,308 symbols: 1,385
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-04 04:00:00 | AAPL | Stock | 170.48 | 170.48 | 169.26 | 169.75 | 16819.0 |
| 2023-10-04 04:05:00 | AAPL | Stock | 169.6 | 170.05 | 169.58 | 170.05 | 5788.0 |
| 2023-10-04 04:10:00 | AAPL | Stock | 169.99 | 170.07 | 169.97 | 170.07 | 1695.0 |
| 2023-10-04 04:15:00 | AAPL | Stock | 170.19 | 170.2 | 169.82 | 169.82 | 5576.0 |
| 2023-10-04 04:20:00 | AAPL | Stock | 169.86 | 169.95 | 169.84 | 169.95 | 1314.0 |
| 2023-10-04 04:25:00 | AAPL | Stock | 170.0 | 170.27 | 170.0 | 170.22 | 9983.0 |
| 2023-10-04 04:30:00 | AAPL | Stock | 170.22 | 170.23 | 170.1 | 170.1 | 875.0 |
| 2023-10-04 04:35:00 | AAPL | Stock | 170.17 | 170.2 | 170.0 | 170.2 | 3789.0 |
| 2023-10-04 04:40:00 | AAPL | Stock | 170.23 | 170.24 | 169.8 | 169.8 | 23661.0 |
| 2023-10-04 04:45:00 | AAPL | Stock | 169.95 | 170.15 | 169.95 | 170.15 | 5686.0 |
| 2023-10-04 04:50:00 | AAPL | Stock | 170.18 | 170.19 | 170.11 | 170.18 | 1667.0 |
| 2023-10-04 04:55:00 | AAPL | Stock | 170.18 | 170.35 | 170.18 | 170.35 | 6212.0 |
| 2023-10-04 05:00:00 | AAPL | Stock | 170.23 | 170.24 | 170.0 | 170.0 | 6262.0 |
| 2023-10-04 05:05:00 | AAPL | Stock | 170.01 | 170.2 | 170.01 | 170.2 | 508.0 |
| 2023-10-04 05:10:00 | AAPL | Stock | 170.27 | 170.34 | 170.27 | 170.33 | 3305.0 |
| 2023-10-04 05:15:00 | AAPL | Stock | 170.33 | 170.35 | 170.28 | 170.33 | 2439.0 |
| 2023-10-04 05:20:00 | AAPL | Stock | 170.32 | 170.38 | 170.23 | 170.38 | 520.0 |
| 2023-10-04 05:25:00 | AAPL | Stock | 170.43 | 170.47 | 170.43 | 170.47 | 886.0 |
| 2023-10-04 05:30:00 | AAPL | Stock | 170.46 | 170.62 | 170.46 | 170.58 | 3426.0 |
| 2023-10-04 05:35:00 | AAPL | Stock | 170.57 | 170.63 | 170.57 | 170.57 | 2595.0 |
| 2023-10-04 05:40:00 | AAPL | Stock | 170.64 | 170.69 | 170.5 | 170.6 | 2886.0 |
| 2023-10-04 05:45:00 | AAPL | Stock | 170.41 | 170.41 | 170.39 | 170.4 | 2564.0 |
| 2023-10-04 05:50:00 | AAPL | Stock | 170.5 | 170.6 | 170.36 | 170.6 | 782.0 |
| 2023-10-04 05:55:00 | AAPL | Stock | 170.55 | 170.57 | 170.54 | 170.57 | 750.0 |
| 2023-10-04 06:00:00 | AAPL | Stock | 170.6 | 170.6 | 170.55 | 170.55 | 813.0 |
| 2023-10-04 06:05:00 | AAPL | Stock | 170.53 | 170.53 | 170.53 | 170.53 | 100.0 |
| 2023-10-04 06:10:00 | AAPL | Stock | 170.45 | 170.79 | 170.45 | 170.76 | 4994.0 |
| 2023-10-04 06:15:00 | AAPL | Stock | 170.75 | 170.75 | 170.72 | 170.72 | 775.0 |
| 2023-10-04 06:20:00 | AAPL | Stock | 170.7 | 170.9 | 170.7 | 170.9 | 1154.0 |
| 2023-10-04 06:25:00 | AAPL | Stock | 170.9 | 170.9 | 170.85 | 170.85 | 3050.0 |
| 2023-10-04 06:35:00 | AAPL | Stock | 170.6 | 170.67 | 170.6 | 170.67 | 323.0 |
| 2023-10-04 06:40:00 | AAPL | Stock | 170.7 | 170.71 | 170.41 | 170.5 | 4610.0 |
| 2023-10-04 06:45:00 | AAPL | Stock | 170.36 | 170.36 | 170.35 | 170.35 | 824.0 |
| 2023-10-04 06:50:00 | AAPL | Stock | 170.37 | 170.55 | 170.37 | 170.55 | 1233.0 |
| 2023-10-04 06:55:00 | AAPL | Stock | 170.6 | 170.72 | 170.6 | 170.72 | 1262.0 |
| 2023-10-04 07:00:00 | AAPL | Stock | 170.71 | 170.85 | 170.68 | 170.82 | 6227.0 |
| 2023-10-04 07:05:00 | AAPL | Stock | 170.82 | 171.25 | 170.82 | 171.1 | 21662.0 |
| 2023-10-04 07:10:00 | AAPL | Stock | 171.05 | 171.16 | 170.9 | 170.98 | 5254.0 |
| 2023-10-04 07:15:00 | AAPL | Stock | 170.98 | 171.09 | 170.93 | 170.94 | 17477.0 |
| 2023-10-04 07:20:00 | AAPL | Stock | 170.93 | 170.93 | 170.76 | 170.88 | 11980.0 |
| 2023-10-04 07:25:00 | AAPL | Stock | 170.93 | 170.93 | 170.74 | 170.77 | 7344.0 |
| 2023-10-04 07:30:00 | AAPL | Stock | 170.76 | 170.85 | 170.74 | 170.85 | 2933.0 |
| 2023-10-04 07:35:00 | AAPL | Stock | 170.83 | 170.83 | 170.66 | 170.8 | 5561.0 |
| 2023-10-04 07:40:00 | AAPL | Stock | 170.76 | 170.86 | 170.76 | 170.82 | 9220.0 |
| 2023-10-04 07:45:00 | AAPL | Stock | 170.85 | 171.0 | 170.85 | 170.93 | 6421.0 |
| 2023-10-04 07:50:00 | AAPL | Stock | 170.96 | 170.99 | 170.9 | 170.99 | 5016.0 |
| 2023-10-04 07:55:00 | AAPL | Stock | 170.91 | 170.99 | 170.8 | 170.9 | 4922.0 |
| 2023-10-04 08:00:00 | AAPL | Stock | 170.72 | 171.26 | 169.57 | 171.05 | 72517.0 |
| 2023-10-04 08:05:00 | AAPL | Stock | 171.1 | 171.24 | 171.1 | 171.2 | 15609.0 |
| 2023-10-04 08:10:00 | AAPL | Stock | 171.2 | 171.24 | 171.13 | 171.15 | 6285.0 |
> showing 50 of 395,308 rows — these rows as CSV