PREVIEW / stock_5min / 2023-03-01
file: by_date/stock_5min/2023/2023-03-01.parquet size: 6.8 MB rows: 416,520 symbols: 1,814
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-01 04:00:00 | AAPL | Stock | 147.66 | 148.32 | 147.66 | 148.3 | 7642.0 |
| 2023-03-01 04:05:00 | AAPL | Stock | 148.32 | 148.33 | 148.11 | 148.19 | 2750.0 |
| 2023-03-01 04:10:00 | AAPL | Stock | 148.25 | 148.28 | 148.2 | 148.25 | 1355.0 |
| 2023-03-01 04:15:00 | AAPL | Stock | 148.16 | 148.23 | 148.07 | 148.07 | 2348.0 |
| 2023-03-01 04:20:00 | AAPL | Stock | 148.1 | 148.1 | 147.9 | 147.95 | 1413.0 |
| 2023-03-01 04:25:00 | AAPL | Stock | 148.08 | 148.08 | 148.0 | 148.02 | 1514.0 |
| 2023-03-01 04:30:00 | AAPL | Stock | 148.09 | 148.29 | 148.09 | 148.18 | 711.0 |
| 2023-03-01 04:35:00 | AAPL | Stock | 148.14 | 148.14 | 148.12 | 148.12 | 900.0 |
| 2023-03-01 04:40:00 | AAPL | Stock | 148.12 | 148.12 | 148.12 | 148.12 | 1251.0 |
| 2023-03-01 04:45:00 | AAPL | Stock | 148.17 | 148.17 | 148.08 | 148.1 | 630.0 |
| 2023-03-01 04:50:00 | AAPL | Stock | 148.1 | 148.13 | 148.1 | 148.13 | 446.0 |
| 2023-03-01 04:55:00 | AAPL | Stock | 148.13 | 148.17 | 148.13 | 148.17 | 300.0 |
| 2023-03-01 05:00:00 | AAPL | Stock | 148.16 | 148.16 | 148.16 | 148.16 | 802.0 |
| 2023-03-01 05:10:00 | AAPL | Stock | 148.15 | 148.19 | 148.15 | 148.19 | 200.0 |
| 2023-03-01 05:25:00 | AAPL | Stock | 148.12 | 148.21 | 148.12 | 148.21 | 799.0 |
| 2023-03-01 05:30:00 | AAPL | Stock | 148.22 | 148.22 | 148.2 | 148.2 | 575.0 |
| 2023-03-01 05:35:00 | AAPL | Stock | 148.17 | 148.22 | 148.17 | 148.22 | 419.0 |
| 2023-03-01 05:40:00 | AAPL | Stock | 148.28 | 148.28 | 148.21 | 148.21 | 1749.0 |
| 2023-03-01 05:45:00 | AAPL | Stock | 148.24 | 148.28 | 148.24 | 148.28 | 244.0 |
| 2023-03-01 05:50:00 | AAPL | Stock | 148.26 | 148.28 | 148.26 | 148.28 | 954.0 |
| 2023-03-01 05:55:00 | AAPL | Stock | 148.29 | 148.45 | 148.29 | 148.37 | 5597.0 |
| 2023-03-01 06:00:00 | AAPL | Stock | 148.4 | 148.41 | 148.35 | 148.35 | 1000.0 |
| 2023-03-01 06:10:00 | AAPL | Stock | 148.42 | 148.42 | 148.42 | 148.42 | 1000.0 |
| 2023-03-01 06:15:00 | AAPL | Stock | 148.45 | 148.48 | 148.45 | 148.48 | 922.0 |
| 2023-03-01 06:20:00 | AAPL | Stock | 148.49 | 148.49 | 148.45 | 148.49 | 600.0 |
| 2023-03-01 06:25:00 | AAPL | Stock | 148.49 | 148.49 | 148.42 | 148.42 | 835.0 |
| 2023-03-01 06:30:00 | AAPL | Stock | 148.44 | 148.45 | 148.31 | 148.33 | 1855.0 |
| 2023-03-01 06:35:00 | AAPL | Stock | 148.39 | 148.39 | 148.32 | 148.35 | 623.0 |
| 2023-03-01 06:45:00 | AAPL | Stock | 148.38 | 148.38 | 148.32 | 148.34 | 2902.0 |
| 2023-03-01 06:50:00 | AAPL | Stock | 148.3 | 148.32 | 148.19 | 148.21 | 5433.0 |
| 2023-03-01 06:55:00 | AAPL | Stock | 148.25 | 148.25 | 148.2 | 148.24 | 3523.0 |
| 2023-03-01 07:00:00 | AAPL | Stock | 148.19 | 148.25 | 148.12 | 148.25 | 8646.0 |
| 2023-03-01 07:05:00 | AAPL | Stock | 148.21 | 148.21 | 148.18 | 148.18 | 4596.0 |
| 2023-03-01 07:10:00 | AAPL | Stock | 148.18 | 148.18 | 148.04 | 148.1 | 4199.0 |
| 2023-03-01 07:15:00 | AAPL | Stock | 148.1 | 148.12 | 148.1 | 148.12 | 3999.0 |
| 2023-03-01 07:20:00 | AAPL | Stock | 148.09 | 148.12 | 148.09 | 148.1 | 4984.0 |
| 2023-03-01 07:25:00 | AAPL | Stock | 148.12 | 148.17 | 148.08 | 148.12 | 13249.0 |
| 2023-03-01 07:30:00 | AAPL | Stock | 148.12 | 148.14 | 148.11 | 148.14 | 5074.0 |
| 2023-03-01 07:35:00 | AAPL | Stock | 148.14 | 148.14 | 148.11 | 148.11 | 1352.0 |
| 2023-03-01 07:40:00 | AAPL | Stock | 148.11 | 148.11 | 148.11 | 148.11 | 1052.0 |
| 2023-03-01 07:45:00 | AAPL | Stock | 148.13 | 148.13 | 148.08 | 148.08 | 1106.0 |
| 2023-03-01 07:50:00 | AAPL | Stock | 148.1 | 148.1 | 148.08 | 148.08 | 741.0 |
| 2023-03-01 07:55:00 | AAPL | Stock | 148.04 | 148.09 | 148.04 | 148.09 | 629.0 |
| 2023-03-01 08:00:00 | AAPL | Stock | 148.1401 | 148.2001 | 147.6 | 147.88 | 42240.0 |
| 2023-03-01 08:05:00 | AAPL | Stock | 147.9 | 147.95 | 147.8 | 147.8 | 14332.0 |
| 2023-03-01 08:10:00 | AAPL | Stock | 147.86 | 147.86 | 147.75 | 147.75 | 11957.0 |
| 2023-03-01 08:15:00 | AAPL | Stock | 147.77 | 147.85 | 147.75 | 147.75 | 3117.0 |
| 2023-03-01 08:20:00 | AAPL | Stock | 147.75 | 147.8 | 147.7 | 147.7 | 8716.0 |
| 2023-03-01 08:25:00 | AAPL | Stock | 147.62 | 147.62 | 147.5 | 147.5 | 9639.0 |
| 2023-03-01 08:30:00 | AAPL | Stock | 147.45 | 147.58 | 147.3 | 147.3 | 27085.0 |
> showing 50 of 416,520 rows — these rows as CSV