PREVIEW / stock_5min / 2022-09-15
file: by_date/stock_5min/2022/2022-09-15.parquet size: 6.9 MB rows: 429,831 symbols: 2,216
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 |
|---|---|---|---|---|---|---|---|
| 2022-09-15 04:00:00 | AAPL | Stock | 156.0 | 156.15 | 155.71 | 155.71 | 9714.0 |
| 2022-09-15 04:05:00 | AAPL | Stock | 155.66 | 155.79 | 155.66 | 155.67 | 1746.0 |
| 2022-09-15 04:10:00 | AAPL | Stock | 155.66 | 155.66 | 155.49 | 155.49 | 2111.0 |
| 2022-09-15 04:15:00 | AAPL | Stock | 155.47 | 155.47 | 155.35 | 155.36 | 2394.0 |
| 2022-09-15 04:20:00 | AAPL | Stock | 155.37 | 155.62 | 155.36 | 155.55 | 4274.0 |
| 2022-09-15 04:25:00 | AAPL | Stock | 155.5 | 155.52 | 155.5 | 155.52 | 491.0 |
| 2022-09-15 04:30:00 | AAPL | Stock | 155.55 | 155.59 | 155.55 | 155.59 | 823.0 |
| 2022-09-15 04:35:00 | AAPL | Stock | 155.58 | 155.58 | 155.55 | 155.55 | 844.0 |
| 2022-09-15 04:40:00 | AAPL | Stock | 155.55 | 155.55 | 155.45 | 155.45 | 683.0 |
| 2022-09-15 04:45:00 | AAPL | Stock | 155.43 | 155.46 | 155.3 | 155.32 | 3498.0 |
| 2022-09-15 05:00:00 | AAPL | Stock | 155.43 | 155.43 | 155.34 | 155.34 | 2145.0 |
| 2022-09-15 05:05:00 | AAPL | Stock | 155.47 | 155.47 | 155.46 | 155.47 | 896.0 |
| 2022-09-15 05:10:00 | AAPL | Stock | 155.36 | 155.5 | 155.36 | 155.5 | 2202.0 |
| 2022-09-15 05:15:00 | AAPL | Stock | 155.46 | 155.46 | 155.44 | 155.44 | 2235.0 |
| 2022-09-15 05:20:00 | AAPL | Stock | 155.37 | 155.41 | 155.37 | 155.41 | 200.0 |
| 2022-09-15 05:30:00 | AAPL | Stock | 155.46 | 155.55 | 155.46 | 155.55 | 1527.0 |
| 2022-09-15 05:35:00 | AAPL | Stock | 155.6 | 155.62 | 155.6 | 155.62 | 1844.0 |
| 2022-09-15 05:40:00 | AAPL | Stock | 155.6 | 155.6 | 155.57 | 155.57 | 999.0 |
| 2022-09-15 05:45:00 | AAPL | Stock | 155.57 | 155.63 | 155.55 | 155.55 | 2105.0 |
| 2022-09-15 05:50:00 | AAPL | Stock | 155.59 | 155.59 | 155.59 | 155.59 | 100.0 |
| 2022-09-15 06:00:00 | AAPL | Stock | 155.55 | 155.59 | 155.55 | 155.59 | 809.0 |
| 2022-09-15 06:05:00 | AAPL | Stock | 155.58 | 155.58 | 155.58 | 155.58 | 300.0 |
| 2022-09-15 06:10:00 | AAPL | Stock | 155.55 | 155.55 | 155.55 | 155.55 | 100.0 |
| 2022-09-15 06:20:00 | AAPL | Stock | 155.5 | 155.57 | 155.5 | 155.57 | 4313.0 |
| 2022-09-15 06:30:00 | AAPL | Stock | 155.42 | 155.42 | 155.3 | 155.3 | 3624.0 |
| 2022-09-15 06:35:00 | AAPL | Stock | 155.13 | 155.26 | 154.95 | 154.95 | 7269.0 |
| 2022-09-15 06:40:00 | AAPL | Stock | 154.93 | 154.95 | 154.65 | 154.78 | 5741.0 |
| 2022-09-15 06:45:00 | AAPL | Stock | 154.96 | 155.03 | 154.88 | 154.89 | 4549.0 |
| 2022-09-15 06:50:00 | AAPL | Stock | 154.92 | 154.92 | 154.92 | 154.92 | 880.0 |
| 2022-09-15 06:55:00 | AAPL | Stock | 154.9 | 154.92 | 154.9 | 154.92 | 1022.0 |
| 2022-09-15 07:00:00 | AAPL | Stock | 154.98 | 155.1 | 154.95 | 155.0 | 8607.0 |
| 2022-09-15 07:05:00 | AAPL | Stock | 154.96 | 155.07 | 154.96 | 155.07 | 4562.0 |
| 2022-09-15 07:10:00 | AAPL | Stock | 155.03 | 155.1 | 155.03 | 155.06 | 3659.0 |
| 2022-09-15 07:15:00 | AAPL | Stock | 155.1 | 155.12 | 155.1 | 155.12 | 788.0 |
| 2022-09-15 07:20:00 | AAPL | Stock | 155.15 | 155.21 | 155.1 | 155.2 | 4384.0 |
| 2022-09-15 07:25:00 | AAPL | Stock | 155.21 | 155.39 | 155.12 | 155.39 | 3732.0 |
| 2022-09-15 07:30:00 | AAPL | Stock | 155.39 | 155.42 | 155.2 | 155.21 | 20346.0 |
| 2022-09-15 07:35:00 | AAPL | Stock | 155.18 | 155.18 | 155.12 | 155.12 | 2669.0 |
| 2022-09-15 07:40:00 | AAPL | Stock | 155.05 | 155.12 | 155.01 | 155.12 | 2811.0 |
| 2022-09-15 07:45:00 | AAPL | Stock | 155.1 | 155.1 | 154.95 | 155.01 | 13975.0 |
| 2022-09-15 07:50:00 | AAPL | Stock | 155.0 | 155.0 | 154.85 | 154.91 | 8888.0 |
| 2022-09-15 07:55:00 | AAPL | Stock | 154.88 | 155.0 | 154.85 | 154.96 | 6614.0 |
| 2022-09-15 08:00:00 | AAPL | Stock | 155.05 | 155.78 | 154.79 | 154.83 | 74419.0 |
| 2022-09-15 08:05:00 | AAPL | Stock | 154.81 | 154.81 | 154.62 | 154.62 | 25382.0 |
| 2022-09-15 08:10:00 | AAPL | Stock | 154.68 | 154.84 | 154.68 | 154.8383 | 7868.0 |
| 2022-09-15 08:15:00 | AAPL | Stock | 154.81 | 154.83 | 154.71 | 154.72 | 14167.0 |
| 2022-09-15 08:20:00 | AAPL | Stock | 154.72 | 154.73 | 154.5325 | 154.67 | 21309.0 |
| 2022-09-15 08:25:00 | AAPL | Stock | 154.66 | 154.8 | 154.65 | 154.79 | 10266.0 |
| 2022-09-15 08:30:00 | AAPL | Stock | 154.75 | 155.0 | 154.54 | 154.71 | 52491.0 |
| 2022-09-15 08:35:00 | AAPL | Stock | 154.63 | 154.98 | 154.6 | 154.98 | 19658.0 |
> showing 50 of 429,831 rows — these rows as CSV