PREVIEW / stock_5min / 2023-06-26
file: by_date/stock_5min/2023/2023-06-26.parquet size: 6.7 MB rows: 410,289 symbols: 1,601
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-06-26 04:00:00 | AAPL | Stock | 186.55 | 186.79 | 186.54 | 186.78 | 2756.0 |
| 2023-06-26 04:05:00 | AAPL | Stock | 186.77 | 186.78 | 186.59 | 186.6 | 5211.0 |
| 2023-06-26 04:10:00 | AAPL | Stock | 186.73 | 186.73 | 186.67 | 186.67 | 329.0 |
| 2023-06-26 04:15:00 | AAPL | Stock | 186.73 | 186.73 | 186.73 | 186.73 | 209.0 |
| 2023-06-26 04:20:00 | AAPL | Stock | 186.7 | 186.8 | 186.7 | 186.7 | 2127.0 |
| 2023-06-26 04:25:00 | AAPL | Stock | 186.77 | 186.85 | 186.7 | 186.7 | 3833.0 |
| 2023-06-26 04:30:00 | AAPL | Stock | 186.7 | 186.7 | 186.51 | 186.61 | 10509.0 |
| 2023-06-26 04:35:00 | AAPL | Stock | 186.64 | 186.64 | 186.53 | 186.53 | 7083.0 |
| 2023-06-26 04:40:00 | AAPL | Stock | 186.58 | 186.58 | 186.3 | 186.3 | 2645.0 |
| 2023-06-26 04:45:00 | AAPL | Stock | 186.21 | 186.21 | 186.0 | 186.01 | 2890.0 |
| 2023-06-26 04:50:00 | AAPL | Stock | 186.14 | 186.2 | 186.14 | 186.15 | 1533.0 |
| 2023-06-26 04:55:00 | AAPL | Stock | 186.29 | 186.31 | 186.22 | 186.22 | 475.0 |
| 2023-06-26 05:00:00 | AAPL | Stock | 186.37 | 186.37 | 186.37 | 186.37 | 144.0 |
| 2023-06-26 05:15:00 | AAPL | Stock | 186.34 | 186.34 | 186.3 | 186.3 | 1139.0 |
| 2023-06-26 05:20:00 | AAPL | Stock | 186.33 | 186.36 | 186.33 | 186.36 | 200.0 |
| 2023-06-26 05:25:00 | AAPL | Stock | 186.38 | 186.4 | 186.38 | 186.4 | 277.0 |
| 2023-06-26 05:30:00 | AAPL | Stock | 186.35 | 186.35 | 186.35 | 186.35 | 100.0 |
| 2023-06-26 05:35:00 | AAPL | Stock | 186.38 | 186.38 | 186.38 | 186.38 | 209.0 |
| 2023-06-26 05:50:00 | AAPL | Stock | 186.43 | 186.43 | 186.43 | 186.43 | 100.0 |
| 2023-06-26 06:00:00 | AAPL | Stock | 186.34 | 186.34 | 186.34 | 186.34 | 500.0 |
| 2023-06-26 06:10:00 | AAPL | Stock | 186.34 | 186.35 | 186.34 | 186.35 | 300.0 |
| 2023-06-26 06:25:00 | AAPL | Stock | 186.33 | 186.33 | 186.33 | 186.33 | 100.0 |
| 2023-06-26 06:50:00 | AAPL | Stock | 186.2 | 186.2 | 186.2 | 186.2 | 100.0 |
| 2023-06-26 07:00:00 | AAPL | Stock | 186.25 | 186.43 | 186.25 | 186.31 | 4372.0 |
| 2023-06-26 07:05:00 | AAPL | Stock | 186.3 | 186.43 | 186.3 | 186.43 | 2408.0 |
| 2023-06-26 07:10:00 | AAPL | Stock | 186.44 | 186.49 | 186.44 | 186.46 | 1818.0 |
| 2023-06-26 07:15:00 | AAPL | Stock | 186.53 | 186.53 | 186.5 | 186.5 | 600.0 |
| 2023-06-26 07:25:00 | AAPL | Stock | 186.49 | 186.54 | 186.45 | 186.45 | 1650.0 |
| 2023-06-26 07:30:00 | AAPL | Stock | 186.45 | 186.5 | 186.45 | 186.5 | 900.0 |
| 2023-06-26 07:35:00 | AAPL | Stock | 186.42 | 186.47 | 186.41 | 186.45 | 681.0 |
| 2023-06-26 07:40:00 | AAPL | Stock | 186.5 | 186.6 | 186.5 | 186.6 | 2740.0 |
| 2023-06-26 07:45:00 | AAPL | Stock | 186.58 | 186.62 | 186.53 | 186.58 | 1729.0 |
| 2023-06-26 07:50:00 | AAPL | Stock | 186.51 | 186.62 | 186.46 | 186.57 | 3534.0 |
| 2023-06-26 07:55:00 | AAPL | Stock | 186.63 | 186.63 | 186.55 | 186.6 | 1745.0 |
| 2023-06-26 08:00:00 | AAPL | Stock | 186.3318 | 187.45 | 186.3 | 186.52 | 29679.0 |
| 2023-06-26 08:05:00 | AAPL | Stock | 186.45 | 186.45 | 186.41 | 186.44 | 890.0 |
| 2023-06-26 08:10:00 | AAPL | Stock | 186.59 | 186.59 | 186.47 | 186.57 | 2235.0 |
| 2023-06-26 08:15:00 | AAPL | Stock | 186.56 | 186.57 | 186.46 | 186.52 | 4362.0 |
| 2023-06-26 08:20:00 | AAPL | Stock | 186.52 | 186.78 | 186.52 | 186.77 | 6375.0 |
| 2023-06-26 08:25:00 | AAPL | Stock | 186.71 | 186.8 | 186.65 | 186.8 | 3412.0 |
| 2023-06-26 08:30:00 | AAPL | Stock | 186.81 | 187.0 | 186.8 | 186.98 | 11963.0 |
| 2023-06-26 08:35:00 | AAPL | Stock | 186.95 | 186.95 | 186.77 | 186.82 | 5265.0 |
| 2023-06-26 08:40:00 | AAPL | Stock | 186.81 | 186.9799 | 186.79 | 186.86 | 7893.0 |
| 2023-06-26 08:45:00 | AAPL | Stock | 186.86 | 186.86 | 186.69 | 186.78 | 9831.0 |
| 2023-06-26 08:50:00 | AAPL | Stock | 186.85 | 186.87 | 186.77 | 186.85 | 3647.0 |
| 2023-06-26 08:55:00 | AAPL | Stock | 186.85 | 186.92 | 186.8 | 186.91 | 3665.0 |
| 2023-06-26 09:00:00 | AAPL | Stock | 186.89 | 187.0 | 186.8708 | 186.99 | 15913.0 |
| 2023-06-26 09:05:00 | AAPL | Stock | 186.98 | 187.0 | 186.84 | 186.84 | 4919.0 |
| 2023-06-26 09:10:00 | AAPL | Stock | 186.87 | 186.93 | 186.85 | 186.93 | 8562.0 |
| 2023-06-26 09:15:00 | AAPL | Stock | 186.93 | 186.95 | 186.89 | 186.9 | 6068.0 |
> showing 50 of 410,289 rows — these rows as CSV