PREVIEW / stock_5min / 2023-01-04
file: by_date/stock_5min/2023/2023-01-04.parquet size: 6.9 MB rows: 424,888 symbols: 1,960
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-04 04:00:00 | AAPL | Stock | 125.9 | 126.4 | 125.66 | 126.35 | 23898.0 |
| 2023-01-04 04:05:00 | AAPL | Stock | 126.36 | 126.4 | 126.28 | 126.3 | 9610.0 |
| 2023-01-04 04:10:00 | AAPL | Stock | 126.26 | 126.35 | 126.1 | 126.33 | 13013.0 |
| 2023-01-04 04:15:00 | AAPL | Stock | 126.23 | 126.33 | 126.23 | 126.28 | 2328.0 |
| 2023-01-04 04:20:00 | AAPL | Stock | 126.26 | 126.3 | 126.21 | 126.21 | 3868.0 |
| 2023-01-04 04:25:00 | AAPL | Stock | 126.24 | 126.24 | 126.1 | 126.15 | 3927.0 |
| 2023-01-04 04:30:00 | AAPL | Stock | 126.1 | 126.25 | 126.07 | 126.25 | 1952.0 |
| 2023-01-04 04:35:00 | AAPL | Stock | 126.27 | 126.3 | 126.21 | 126.29 | 2043.0 |
| 2023-01-04 04:40:00 | AAPL | Stock | 126.27 | 126.3 | 126.18 | 126.18 | 2731.0 |
| 2023-01-04 04:45:00 | AAPL | Stock | 126.2 | 126.4 | 126.2 | 126.37 | 6559.0 |
| 2023-01-04 04:50:00 | AAPL | Stock | 126.37 | 126.38 | 126.3 | 126.3 | 2149.0 |
| 2023-01-04 04:55:00 | AAPL | Stock | 126.29 | 126.3 | 126.21 | 126.24 | 616.0 |
| 2023-01-04 05:00:00 | AAPL | Stock | 126.21 | 126.38 | 126.2 | 126.38 | 4898.0 |
| 2023-01-04 05:05:00 | AAPL | Stock | 126.39 | 126.55 | 126.39 | 126.4 | 5047.0 |
| 2023-01-04 05:10:00 | AAPL | Stock | 126.45 | 126.68 | 126.4 | 126.57 | 2884.0 |
| 2023-01-04 05:15:00 | AAPL | Stock | 126.56 | 126.56 | 126.38 | 126.39 | 1584.0 |
| 2023-01-04 05:20:00 | AAPL | Stock | 126.54 | 126.56 | 126.54 | 126.56 | 563.0 |
| 2023-01-04 05:25:00 | AAPL | Stock | 126.5 | 126.5 | 126.34 | 126.35 | 2200.0 |
| 2023-01-04 05:30:00 | AAPL | Stock | 126.37 | 126.48 | 126.37 | 126.48 | 957.0 |
| 2023-01-04 05:35:00 | AAPL | Stock | 126.32 | 126.32 | 126.1 | 126.1 | 6810.0 |
| 2023-01-04 05:40:00 | AAPL | Stock | 126.1 | 126.1 | 125.91 | 125.92 | 11121.0 |
| 2023-01-04 05:45:00 | AAPL | Stock | 126.05 | 126.15 | 126.04 | 126.15 | 5027.0 |
| 2023-01-04 06:00:00 | AAPL | Stock | 126.13 | 126.15 | 126.13 | 126.13 | 881.0 |
| 2023-01-04 06:05:00 | AAPL | Stock | 126.17 | 126.31 | 126.16 | 126.31 | 2419.0 |
| 2023-01-04 06:10:00 | AAPL | Stock | 126.31 | 126.37 | 126.3 | 126.37 | 2582.0 |
| 2023-01-04 06:15:00 | AAPL | Stock | 126.37 | 126.37 | 126.32 | 126.32 | 1394.0 |
| 2023-01-04 06:20:00 | AAPL | Stock | 126.35 | 126.36 | 126.3 | 126.33 | 1436.0 |
| 2023-01-04 06:25:00 | AAPL | Stock | 126.35 | 126.35 | 126.35 | 126.35 | 100.0 |
| 2023-01-04 06:30:00 | AAPL | Stock | 126.24 | 126.35 | 126.24 | 126.3 | 1376.0 |
| 2023-01-04 06:35:00 | AAPL | Stock | 126.35 | 126.5 | 126.35 | 126.49 | 7835.0 |
| 2023-01-04 06:40:00 | AAPL | Stock | 126.49 | 126.49 | 126.45 | 126.47 | 1638.0 |
| 2023-01-04 06:45:00 | AAPL | Stock | 126.41 | 126.44 | 126.39 | 126.44 | 3077.0 |
| 2023-01-04 06:50:00 | AAPL | Stock | 126.45 | 126.49 | 126.44 | 126.47 | 3210.0 |
| 2023-01-04 06:55:00 | AAPL | Stock | 126.48 | 126.49 | 126.3 | 126.3 | 3002.0 |
| 2023-01-04 07:00:00 | AAPL | Stock | 126.25 | 126.25 | 125.89 | 125.95 | 24009.0 |
| 2023-01-04 07:05:00 | AAPL | Stock | 126.0 | 126.0 | 125.75 | 125.75 | 14100.0 |
| 2023-01-04 07:10:00 | AAPL | Stock | 125.75 | 125.97 | 125.7 | 125.9 | 10654.0 |
| 2023-01-04 07:15:00 | AAPL | Stock | 125.9 | 125.96 | 125.9 | 125.95 | 2131.0 |
| 2023-01-04 07:20:00 | AAPL | Stock | 125.86 | 125.95 | 125.84 | 125.9 | 3780.0 |
| 2023-01-04 07:25:00 | AAPL | Stock | 125.81 | 126.03 | 125.8 | 125.9 | 9234.0 |
| 2023-01-04 07:30:00 | AAPL | Stock | 125.88 | 126.05 | 125.88 | 125.99 | 6698.0 |
| 2023-01-04 07:35:00 | AAPL | Stock | 125.96 | 126.05 | 125.92 | 126.0 | 3997.0 |
| 2023-01-04 07:40:00 | AAPL | Stock | 125.97 | 126.08 | 125.88 | 126.06 | 12043.0 |
| 2023-01-04 07:45:00 | AAPL | Stock | 126.06 | 126.06 | 125.53 | 125.6 | 24872.0 |
| 2023-01-04 07:50:00 | AAPL | Stock | 125.56 | 125.9 | 125.54 | 125.87 | 4001.0 |
| 2023-01-04 07:55:00 | AAPL | Stock | 125.81 | 125.87 | 125.75 | 125.86 | 3750.0 |
| 2023-01-04 08:00:00 | AAPL | Stock | 126.071 | 126.21 | 125.38 | 126.0 | 126688.0 |
| 2023-01-04 08:05:00 | AAPL | Stock | 126.01 | 126.15 | 125.91 | 126.15 | 14843.0 |
| 2023-01-04 08:10:00 | AAPL | Stock | 126.1 | 126.2 | 126.01 | 126.06 | 34943.0 |
| 2023-01-04 08:15:00 | AAPL | Stock | 126.06 | 126.14 | 126.0 | 126.14 | 36039.0 |
> showing 50 of 424,888 rows — these rows as CSV