PREVIEW / stock_5min / 2023-01-05
file: by_date/stock_5min/2023/2023-01-05.parquet size: 6.8 MB rows: 416,901 symbols: 1,962
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-01-05 04:00:00 | AAPL | Stock | 127.0 | 127.0 | 126.37 | 126.6 | 16051.0 |
| 2023-01-05 04:05:00 | AAPL | Stock | 126.53 | 126.53 | 125.95 | 125.99 | 52184.0 |
| 2023-01-05 04:10:00 | AAPL | Stock | 125.96 | 126.16 | 125.95 | 126.16 | 3422.0 |
| 2023-01-05 04:15:00 | AAPL | Stock | 126.21 | 126.4 | 126.21 | 126.4 | 4550.0 |
| 2023-01-05 04:20:00 | AAPL | Stock | 126.45 | 126.56 | 126.25 | 126.56 | 2419.0 |
| 2023-01-05 04:25:00 | AAPL | Stock | 126.5 | 126.5 | 126.25 | 126.34 | 2770.0 |
| 2023-01-05 04:30:00 | AAPL | Stock | 126.4 | 126.41 | 126.2 | 126.24 | 8154.0 |
| 2023-01-05 04:35:00 | AAPL | Stock | 126.15 | 126.19 | 126.12 | 126.14 | 645.0 |
| 2023-01-05 04:40:00 | AAPL | Stock | 126.48 | 126.5 | 126.13 | 126.13 | 4886.0 |
| 2023-01-05 04:45:00 | AAPL | Stock | 126.31 | 126.45 | 126.3 | 126.45 | 1644.0 |
| 2023-01-05 04:50:00 | AAPL | Stock | 126.45 | 126.45 | 126.27 | 126.27 | 7217.0 |
| 2023-01-05 04:55:00 | AAPL | Stock | 126.37 | 126.4 | 126.36 | 126.4 | 9935.0 |
| 2023-01-05 05:00:00 | AAPL | Stock | 126.4 | 126.58 | 126.39 | 126.5 | 5313.0 |
| 2023-01-05 05:05:00 | AAPL | Stock | 126.5 | 126.5 | 126.4 | 126.4 | 2441.0 |
| 2023-01-05 05:10:00 | AAPL | Stock | 126.57 | 126.62 | 126.55 | 126.61 | 1370.0 |
| 2023-01-05 05:15:00 | AAPL | Stock | 126.7 | 126.83 | 126.7 | 126.83 | 200.0 |
| 2023-01-05 05:20:00 | AAPL | Stock | 126.9 | 126.9 | 126.9 | 126.9 | 1040.0 |
| 2023-01-05 05:35:00 | AAPL | Stock | 126.72 | 126.72 | 126.59 | 126.69 | 15519.0 |
| 2023-01-05 05:40:00 | AAPL | Stock | 126.69 | 126.69 | 126.56 | 126.56 | 18587.0 |
| 2023-01-05 05:45:00 | AAPL | Stock | 126.54 | 126.54 | 126.33 | 126.33 | 4777.0 |
| 2023-01-05 05:50:00 | AAPL | Stock | 126.33 | 126.33 | 125.79 | 125.86 | 31611.0 |
| 2023-01-05 05:55:00 | AAPL | Stock | 125.9 | 126.0 | 125.9 | 125.92 | 8723.0 |
| 2023-01-05 06:00:00 | AAPL | Stock | 125.96 | 126.27 | 125.96 | 126.21 | 6720.0 |
| 2023-01-05 06:05:00 | AAPL | Stock | 126.21 | 126.31 | 126.2 | 126.3 | 5628.0 |
| 2023-01-05 06:10:00 | AAPL | Stock | 126.3 | 126.52 | 126.3 | 126.52 | 4733.0 |
| 2023-01-05 06:15:00 | AAPL | Stock | 126.5 | 126.64 | 126.5 | 126.5 | 18426.0 |
| 2023-01-05 06:20:00 | AAPL | Stock | 126.5 | 126.5 | 126.37 | 126.46 | 5797.0 |
| 2023-01-05 06:25:00 | AAPL | Stock | 126.47 | 126.5 | 126.34 | 126.48 | 10125.0 |
| 2023-01-05 06:30:00 | AAPL | Stock | 126.46 | 126.73 | 126.46 | 126.72 | 11361.0 |
| 2023-01-05 06:35:00 | AAPL | Stock | 126.71 | 126.73 | 126.62 | 126.73 | 5520.0 |
| 2023-01-05 06:40:00 | AAPL | Stock | 126.7 | 126.7 | 126.62 | 126.69 | 1053.0 |
| 2023-01-05 06:45:00 | AAPL | Stock | 126.72 | 126.83 | 126.72 | 126.82 | 7007.0 |
| 2023-01-05 06:50:00 | AAPL | Stock | 126.83 | 126.99 | 126.79 | 126.99 | 2471.0 |
| 2023-01-05 06:55:00 | AAPL | Stock | 126.96 | 127.09 | 126.9 | 126.99 | 7273.0 |
| 2023-01-05 07:00:00 | AAPL | Stock | 126.93 | 127.0 | 126.87 | 126.95 | 17654.0 |
| 2023-01-05 07:05:00 | AAPL | Stock | 126.98 | 127.44 | 126.98 | 127.1 | 10624.0 |
| 2023-01-05 07:10:00 | AAPL | Stock | 127.1 | 127.25 | 127.1 | 127.16 | 5430.0 |
| 2023-01-05 07:15:00 | AAPL | Stock | 127.2 | 127.44 | 127.2 | 127.36 | 6661.0 |
| 2023-01-05 07:20:00 | AAPL | Stock | 127.38 | 127.43 | 127.38 | 127.43 | 3029.0 |
| 2023-01-05 07:25:00 | AAPL | Stock | 127.38 | 127.38 | 127.15 | 127.15 | 2322.0 |
| 2023-01-05 07:30:00 | AAPL | Stock | 127.25 | 127.44 | 127.25 | 127.44 | 2040.0 |
| 2023-01-05 07:35:00 | AAPL | Stock | 127.44 | 127.7 | 127.44 | 127.6 | 11182.0 |
| 2023-01-05 07:40:00 | AAPL | Stock | 127.57 | 127.88 | 127.45 | 127.69 | 22914.0 |
| 2023-01-05 07:45:00 | AAPL | Stock | 127.7 | 127.7 | 127.4 | 127.61 | 20504.0 |
| 2023-01-05 07:50:00 | AAPL | Stock | 127.53 | 127.6 | 127.45 | 127.6 | 11335.0 |
| 2023-01-05 07:55:00 | AAPL | Stock | 127.64 | 127.69 | 127.55 | 127.6 | 12749.0 |
| 2023-01-05 08:00:00 | AAPL | Stock | 127.05 | 127.87 | 126.25 | 127.61 | 141424.0 |
| 2023-01-05 08:05:00 | AAPL | Stock | 127.6 | 127.72 | 127.48 | 127.689 | 34322.0 |
| 2023-01-05 08:10:00 | AAPL | Stock | 127.66 | 127.66 | 127.37 | 127.6 | 25294.0 |
| 2023-01-05 08:15:00 | AAPL | Stock | 127.51 | 127.51 | 126.9 | 127.1 | 75736.0 |
> showing 50 of 416,901 rows — these rows as CSV