PREVIEW / stock_5min / 2023-05-24
file: by_date/stock_5min/2023/2023-05-24.parquet size: 6.7 MB rows: 413,803 symbols: 1,641
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-05-24 04:00:00 | AAPL | Stock | 171.49 | 171.49 | 171.08 | 171.14 | 6678.0 |
| 2023-05-24 04:05:00 | AAPL | Stock | 171.3 | 171.33 | 171.28 | 171.3 | 3002.0 |
| 2023-05-24 04:10:00 | AAPL | Stock | 171.2 | 171.2 | 171.1 | 171.13 | 2058.0 |
| 2023-05-24 04:15:00 | AAPL | Stock | 171.13 | 171.19 | 171.13 | 171.15 | 1074.0 |
| 2023-05-24 04:20:00 | AAPL | Stock | 171.13 | 171.2 | 171.13 | 171.19 | 2755.0 |
| 2023-05-24 04:25:00 | AAPL | Stock | 171.12 | 171.15 | 171.1 | 171.15 | 3346.0 |
| 2023-05-24 04:30:00 | AAPL | Stock | 171.2 | 171.39 | 171.2 | 171.29 | 1622.0 |
| 2023-05-24 04:35:00 | AAPL | Stock | 171.29 | 171.29 | 171.29 | 171.29 | 216.0 |
| 2023-05-24 04:45:00 | AAPL | Stock | 171.28 | 171.29 | 171.25 | 171.25 | 1690.0 |
| 2023-05-24 04:50:00 | AAPL | Stock | 171.25 | 171.33 | 171.25 | 171.33 | 416.0 |
| 2023-05-24 04:55:00 | AAPL | Stock | 171.33 | 171.33 | 171.32 | 171.32 | 800.0 |
| 2023-05-24 05:00:00 | AAPL | Stock | 171.25 | 171.44 | 171.25 | 171.39 | 2320.0 |
| 2023-05-24 05:05:00 | AAPL | Stock | 171.43 | 171.43 | 171.4 | 171.42 | 800.0 |
| 2023-05-24 05:10:00 | AAPL | Stock | 171.39 | 171.39 | 171.39 | 171.39 | 200.0 |
| 2023-05-24 05:15:00 | AAPL | Stock | 171.36 | 171.38 | 171.34 | 171.36 | 1006.0 |
| 2023-05-24 05:20:00 | AAPL | Stock | 171.35 | 171.35 | 171.3 | 171.3 | 408.0 |
| 2023-05-24 05:25:00 | AAPL | Stock | 171.39 | 171.39 | 171.39 | 171.39 | 500.0 |
| 2023-05-24 05:35:00 | AAPL | Stock | 171.37 | 171.37 | 171.37 | 171.37 | 100.0 |
| 2023-05-24 05:50:00 | AAPL | Stock | 171.32 | 171.38 | 171.32 | 171.38 | 432.0 |
| 2023-05-24 05:55:00 | AAPL | Stock | 171.35 | 171.38 | 171.34 | 171.34 | 308.0 |
| 2023-05-24 06:00:00 | AAPL | Stock | 171.21 | 171.33 | 171.19 | 171.33 | 3686.0 |
| 2023-05-24 06:05:00 | AAPL | Stock | 171.19 | 171.19 | 171.12 | 171.12 | 534.0 |
| 2023-05-24 06:10:00 | AAPL | Stock | 171.13 | 171.13 | 171.08 | 171.12 | 3418.0 |
| 2023-05-24 06:15:00 | AAPL | Stock | 171.09 | 171.1 | 170.97 | 171.0 | 6006.0 |
| 2023-05-24 06:20:00 | AAPL | Stock | 171.0 | 171.0 | 170.87 | 170.91 | 1396.0 |
| 2023-05-24 06:25:00 | AAPL | Stock | 170.92 | 170.92 | 170.87 | 170.87 | 300.0 |
| 2023-05-24 06:30:00 | AAPL | Stock | 170.92 | 170.92 | 170.88 | 170.88 | 2469.0 |
| 2023-05-24 06:35:00 | AAPL | Stock | 170.91 | 170.97 | 170.89 | 170.97 | 6895.0 |
| 2023-05-24 06:40:00 | AAPL | Stock | 171.0 | 171.0 | 171.0 | 171.0 | 1679.0 |
| 2023-05-24 06:45:00 | AAPL | Stock | 171.0 | 171.09 | 171.0 | 171.01 | 1482.0 |
| 2023-05-24 06:50:00 | AAPL | Stock | 170.92 | 170.97 | 170.91 | 170.91 | 550.0 |
| 2023-05-24 06:55:00 | AAPL | Stock | 170.95 | 170.95 | 170.95 | 170.95 | 225.0 |
| 2023-05-24 07:00:00 | AAPL | Stock | 170.98 | 171.15 | 170.98 | 171.1 | 12962.0 |
| 2023-05-24 07:05:00 | AAPL | Stock | 171.1 | 171.1 | 170.9 | 170.9 | 3951.0 |
| 2023-05-24 07:10:00 | AAPL | Stock | 170.9 | 170.9 | 170.59 | 170.6 | 7413.0 |
| 2023-05-24 07:15:00 | AAPL | Stock | 170.57 | 170.86 | 170.57 | 170.75 | 5167.0 |
| 2023-05-24 07:20:00 | AAPL | Stock | 170.66 | 170.74 | 170.6 | 170.74 | 6608.0 |
| 2023-05-24 07:25:00 | AAPL | Stock | 170.65 | 170.65 | 170.65 | 170.65 | 300.0 |
| 2023-05-24 07:30:00 | AAPL | Stock | 170.68 | 170.74 | 170.64 | 170.68 | 1903.0 |
| 2023-05-24 07:35:00 | AAPL | Stock | 170.73 | 170.73 | 170.7 | 170.73 | 1435.0 |
| 2023-05-24 07:40:00 | AAPL | Stock | 170.73 | 170.82 | 170.71 | 170.81 | 5325.0 |
| 2023-05-24 07:45:00 | AAPL | Stock | 170.79 | 170.79 | 170.65 | 170.65 | 8643.0 |
| 2023-05-24 07:50:00 | AAPL | Stock | 170.63 | 170.68 | 170.41 | 170.41 | 17592.0 |
| 2023-05-24 07:55:00 | AAPL | Stock | 170.45 | 170.5 | 170.43 | 170.5 | 4188.0 |
| 2023-05-24 08:00:00 | AAPL | Stock | 171.0983 | 171.57 | 170.4 | 170.57 | 33622.0 |
| 2023-05-24 08:05:00 | AAPL | Stock | 170.63 | 170.69 | 170.6 | 170.65 | 7936.0 |
| 2023-05-24 08:10:00 | AAPL | Stock | 170.65 | 170.67 | 170.52 | 170.52 | 6579.0 |
| 2023-05-24 08:15:00 | AAPL | Stock | 170.5499 | 170.58 | 170.41 | 170.52 | 8445.0 |
| 2023-05-24 08:20:00 | AAPL | Stock | 170.5 | 170.65 | 170.45 | 170.6499 | 10402.0 |
| 2023-05-24 08:25:00 | AAPL | Stock | 170.6 | 170.62 | 170.55 | 170.55 | 3357.0 |
> showing 50 of 413,803 rows — these rows as CSV