PREVIEW / stock_5min / 2022-10-20
file: by_date/stock_5min/2022/2022-10-20.parquet size: 6.7 MB rows: 412,617 symbols: 2,133
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-10-20 04:00:00 | AAPL | Stock | 142.49 | 142.69 | 142.2 | 142.69 | 6526.0 |
| 2022-10-20 04:05:00 | AAPL | Stock | 142.73 | 142.89 | 142.72 | 142.72 | 1582.0 |
| 2022-10-20 04:10:00 | AAPL | Stock | 142.75 | 142.75 | 142.52 | 142.54 | 2953.0 |
| 2022-10-20 04:15:00 | AAPL | Stock | 142.55 | 142.79 | 142.55 | 142.79 | 805.0 |
| 2022-10-20 04:20:00 | AAPL | Stock | 142.74 | 142.74 | 142.74 | 142.74 | 100.0 |
| 2022-10-20 04:35:00 | AAPL | Stock | 142.79 | 142.79 | 142.79 | 142.79 | 150.0 |
| 2022-10-20 04:40:00 | AAPL | Stock | 142.79 | 142.85 | 142.79 | 142.85 | 357.0 |
| 2022-10-20 04:50:00 | AAPL | Stock | 142.89 | 142.9 | 142.82 | 142.82 | 1480.0 |
| 2022-10-20 05:05:00 | AAPL | Stock | 142.85 | 142.95 | 142.83 | 142.95 | 608.0 |
| 2022-10-20 05:15:00 | AAPL | Stock | 142.98 | 143.01 | 142.96 | 143.01 | 1001.0 |
| 2022-10-20 05:25:00 | AAPL | Stock | 142.86 | 142.86 | 142.85 | 142.86 | 2137.0 |
| 2022-10-20 05:30:00 | AAPL | Stock | 142.93 | 143.12 | 142.93 | 143.12 | 374.0 |
| 2022-10-20 05:35:00 | AAPL | Stock | 143.03 | 143.12 | 142.99 | 142.99 | 2495.0 |
| 2022-10-20 05:40:00 | AAPL | Stock | 142.96 | 142.96 | 142.96 | 142.96 | 200.0 |
| 2022-10-20 05:45:00 | AAPL | Stock | 142.92 | 143.1 | 142.92 | 143.1 | 2438.0 |
| 2022-10-20 05:50:00 | AAPL | Stock | 143.15 | 143.15 | 143.15 | 143.15 | 400.0 |
| 2022-10-20 05:55:00 | AAPL | Stock | 143.04 | 143.04 | 142.99 | 143.0 | 1005.0 |
| 2022-10-20 06:00:00 | AAPL | Stock | 143.0 | 143.0 | 142.85 | 142.85 | 350.0 |
| 2022-10-20 06:05:00 | AAPL | Stock | 142.9 | 142.9 | 142.87 | 142.87 | 250.0 |
| 2022-10-20 06:10:00 | AAPL | Stock | 142.85 | 142.85 | 142.8 | 142.8 | 628.0 |
| 2022-10-20 06:15:00 | AAPL | Stock | 142.85 | 142.85 | 142.8 | 142.81 | 619.0 |
| 2022-10-20 06:20:00 | AAPL | Stock | 142.86 | 142.88 | 142.86 | 142.88 | 300.0 |
| 2022-10-20 06:25:00 | AAPL | Stock | 143.05 | 143.15 | 143.05 | 143.15 | 3119.0 |
| 2022-10-20 06:30:00 | AAPL | Stock | 143.15 | 143.15 | 143.15 | 143.15 | 495.0 |
| 2022-10-20 06:35:00 | AAPL | Stock | 143.18 | 143.44 | 143.18 | 143.44 | 5330.0 |
| 2022-10-20 06:40:00 | AAPL | Stock | 143.4 | 143.61 | 143.38 | 143.57 | 2443.0 |
| 2022-10-20 06:45:00 | AAPL | Stock | 143.58 | 143.58 | 143.51 | 143.51 | 550.0 |
| 2022-10-20 06:50:00 | AAPL | Stock | 143.5 | 144.0 | 143.49 | 144.0 | 7825.0 |
| 2022-10-20 06:55:00 | AAPL | Stock | 144.11 | 144.11 | 143.83 | 143.83 | 3590.0 |
| 2022-10-20 07:00:00 | AAPL | Stock | 143.74 | 144.06 | 143.66 | 144.06 | 29258.0 |
| 2022-10-20 07:05:00 | AAPL | Stock | 144.08 | 144.09 | 143.9 | 143.99 | 8324.0 |
| 2022-10-20 07:10:00 | AAPL | Stock | 143.97 | 144.2 | 143.97 | 144.01 | 4922.0 |
| 2022-10-20 07:15:00 | AAPL | Stock | 144.14 | 144.14 | 144.1 | 144.1 | 400.0 |
| 2022-10-20 07:20:00 | AAPL | Stock | 144.14 | 144.14 | 143.9 | 143.95 | 5164.0 |
| 2022-10-20 07:25:00 | AAPL | Stock | 143.95 | 143.95 | 143.86 | 143.86 | 2527.0 |
| 2022-10-20 07:30:00 | AAPL | Stock | 143.9 | 143.9 | 143.75 | 143.75 | 845.0 |
| 2022-10-20 07:35:00 | AAPL | Stock | 143.84 | 143.84 | 143.73 | 143.75 | 1275.0 |
| 2022-10-20 07:40:00 | AAPL | Stock | 143.75 | 143.75 | 143.41 | 143.41 | 4409.0 |
| 2022-10-20 07:45:00 | AAPL | Stock | 143.42 | 143.69 | 143.42 | 143.62 | 4290.0 |
| 2022-10-20 07:50:00 | AAPL | Stock | 143.57 | 143.68 | 143.42 | 143.64 | 5512.0 |
| 2022-10-20 07:55:00 | AAPL | Stock | 143.64 | 143.75 | 143.64 | 143.71 | 2233.0 |
| 2022-10-20 08:00:00 | AAPL | Stock | 143.8501 | 144.1999 | 142.59 | 143.75 | 56033.0 |
| 2022-10-20 08:05:00 | AAPL | Stock | 143.75 | 143.75 | 143.0 | 143.54 | 24536.0 |
| 2022-10-20 08:10:00 | AAPL | Stock | 143.52 | 143.54 | 143.35 | 143.48 | 23940.0 |
| 2022-10-20 08:15:00 | AAPL | Stock | 143.49 | 143.69 | 143.49 | 143.6 | 5151.0 |
| 2022-10-20 08:20:00 | AAPL | Stock | 143.55 | 144.14 | 143.55 | 144.0 | 27414.0 |
| 2022-10-20 08:25:00 | AAPL | Stock | 144.07 | 144.14 | 143.86 | 143.96 | 18674.0 |
| 2022-10-20 08:30:00 | AAPL | Stock | 143.82 | 144.48 | 143.69 | 143.78 | 24257.0 |
| 2022-10-20 08:35:00 | AAPL | Stock | 143.78 | 143.78 | 142.86 | 143.3 | 61225.0 |
| 2022-10-20 08:40:00 | AAPL | Stock | 143.43 | 143.43 | 142.7261 | 142.82 | 19153.0 |
> showing 50 of 412,617 rows — these rows as CSV