PREVIEW / stock_5min / 2023-03-31
file: by_date/stock_5min/2023/2023-03-31.parquet size: 6.8 MB rows: 419,540 symbols: 1,721
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-03-31 04:00:00 | AAPL | Stock | 162.39 | 162.5 | 162.39 | 162.41 | 527.0 |
| 2023-03-31 04:05:00 | AAPL | Stock | 162.43 | 162.43 | 162.01 | 162.21 | 2290.0 |
| 2023-03-31 04:10:00 | AAPL | Stock | 162.22 | 162.26 | 162.21 | 162.22 | 1504.0 |
| 2023-03-31 04:15:00 | AAPL | Stock | 161.97 | 161.97 | 161.97 | 161.97 | 166.0 |
| 2023-03-31 04:20:00 | AAPL | Stock | 162.0 | 162.04 | 161.99 | 162.04 | 856.0 |
| 2023-03-31 04:30:00 | AAPL | Stock | 162.09 | 162.09 | 162.09 | 162.09 | 200.0 |
| 2023-03-31 04:40:00 | AAPL | Stock | 162.09 | 162.1 | 162.09 | 162.1 | 1062.0 |
| 2023-03-31 04:45:00 | AAPL | Stock | 162.0 | 162.0 | 162.0 | 162.0 | 100.0 |
| 2023-03-31 04:50:00 | AAPL | Stock | 162.0 | 162.0 | 162.0 | 162.0 | 223.0 |
| 2023-03-31 04:55:00 | AAPL | Stock | 162.01 | 162.01 | 162.01 | 162.01 | 352.0 |
| 2023-03-31 05:00:00 | AAPL | Stock | 162.01 | 162.02 | 161.93 | 162.0 | 1201.0 |
| 2023-03-31 05:05:00 | AAPL | Stock | 162.05 | 162.05 | 162.05 | 162.05 | 100.0 |
| 2023-03-31 05:10:00 | AAPL | Stock | 162.1 | 162.1 | 162.04 | 162.04 | 837.0 |
| 2023-03-31 05:20:00 | AAPL | Stock | 162.12 | 162.14 | 162.12 | 162.13 | 451.0 |
| 2023-03-31 05:25:00 | AAPL | Stock | 162.06 | 162.06 | 162.06 | 162.06 | 121.0 |
| 2023-03-31 05:40:00 | AAPL | Stock | 162.11 | 162.14 | 162.11 | 162.14 | 377.0 |
| 2023-03-31 05:50:00 | AAPL | Stock | 162.1 | 162.1 | 162.05 | 162.05 | 1683.0 |
| 2023-03-31 06:00:00 | AAPL | Stock | 162.12 | 162.12 | 162.07 | 162.07 | 603.0 |
| 2023-03-31 06:05:00 | AAPL | Stock | 162.05 | 162.05 | 162.04 | 162.05 | 418.0 |
| 2023-03-31 06:10:00 | AAPL | Stock | 162.05 | 162.05 | 162.0 | 162.0 | 3022.0 |
| 2023-03-31 06:30:00 | AAPL | Stock | 162.05 | 162.05 | 162.05 | 162.05 | 695.0 |
| 2023-03-31 06:35:00 | AAPL | Stock | 162.07 | 162.07 | 162.07 | 162.07 | 594.0 |
| 2023-03-31 06:45:00 | AAPL | Stock | 162.07 | 162.07 | 161.84 | 162.04 | 9575.0 |
| 2023-03-31 06:55:00 | AAPL | Stock | 162.06 | 162.06 | 162.01 | 162.04 | 1136.0 |
| 2023-03-31 07:00:00 | AAPL | Stock | 162.08 | 162.18 | 162.02 | 162.15 | 8424.0 |
| 2023-03-31 07:05:00 | AAPL | Stock | 162.12 | 162.17 | 162.1 | 162.15 | 2071.0 |
| 2023-03-31 07:10:00 | AAPL | Stock | 162.1 | 162.1 | 162.1 | 162.1 | 447.0 |
| 2023-03-31 07:15:00 | AAPL | Stock | 162.16 | 162.18 | 162.16 | 162.18 | 200.0 |
| 2023-03-31 07:20:00 | AAPL | Stock | 162.16 | 162.16 | 162.12 | 162.12 | 880.0 |
| 2023-03-31 07:25:00 | AAPL | Stock | 162.11 | 162.19 | 162.11 | 162.19 | 1082.0 |
| 2023-03-31 07:30:00 | AAPL | Stock | 162.2 | 162.2 | 162.2 | 162.2 | 111.0 |
| 2023-03-31 07:35:00 | AAPL | Stock | 162.15 | 162.24 | 162.15 | 162.2 | 1403.0 |
| 2023-03-31 07:45:00 | AAPL | Stock | 162.18 | 162.18 | 162.18 | 162.18 | 400.0 |
| 2023-03-31 07:50:00 | AAPL | Stock | 162.18 | 162.18 | 162.11 | 162.11 | 7673.0 |
| 2023-03-31 07:55:00 | AAPL | Stock | 162.11 | 162.11 | 162.11 | 162.11 | 930.0 |
| 2023-03-31 08:00:00 | AAPL | Stock | 162.21 | 162.64 | 161.955 | 162.45 | 19488.0 |
| 2023-03-31 08:05:00 | AAPL | Stock | 162.2 | 162.2 | 162.2 | 162.2 | 4182.0 |
| 2023-03-31 08:10:00 | AAPL | Stock | 162.16 | 162.16 | 162.13 | 162.13 | 780.0 |
| 2023-03-31 08:15:00 | AAPL | Stock | 162.14 | 162.19 | 162.0 | 162.08 | 12485.0 |
| 2023-03-31 08:20:00 | AAPL | Stock | 162.12 | 162.15 | 162.08 | 162.15 | 10601.0 |
| 2023-03-31 08:25:00 | AAPL | Stock | 162.13 | 162.25 | 162.13 | 162.25 | 3111.0 |
| 2023-03-31 08:30:00 | AAPL | Stock | 162.13 | 162.8 | 162.13 | 162.64 | 62374.0 |
| 2023-03-31 08:35:00 | AAPL | Stock | 162.59 | 162.65 | 162.34 | 162.35 | 32601.0 |
| 2023-03-31 08:40:00 | AAPL | Stock | 162.41 | 162.43 | 162.2 | 162.2 | 14854.0 |
| 2023-03-31 08:45:00 | AAPL | Stock | 162.28 | 162.28 | 162.05 | 162.09 | 38334.0 |
| 2023-03-31 08:50:00 | AAPL | Stock | 162.17 | 162.18 | 162.1 | 162.15 | 17337.0 |
| 2023-03-31 08:55:00 | AAPL | Stock | 162.15 | 162.2 | 162.12 | 162.16 | 10020.0 |
| 2023-03-31 09:00:00 | AAPL | Stock | 162.19 | 162.2 | 162.02 | 162.16 | 24139.0 |
| 2023-03-31 09:05:00 | AAPL | Stock | 162.07 | 162.3 | 162.07 | 162.3 | 7487.0 |
| 2023-03-31 09:10:00 | AAPL | Stock | 162.3 | 162.5 | 162.26 | 162.5 | 10801.0 |
> showing 50 of 419,540 rows — these rows as CSV