PREVIEW / stock_5min / 2023-10-02
file: by_date/stock_5min/2023/2023-10-02.parquet size: 6.5 MB rows: 398,046 symbols: 1,368
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-10-02 04:00:00 | AAPL | Stock | 172.7 | 172.91 | 172.7 | 172.9 | 3507.0 |
| 2023-10-02 04:05:00 | AAPL | Stock | 172.91 | 172.91 | 172.87 | 172.87 | 1070.0 |
| 2023-10-02 04:10:00 | AAPL | Stock | 172.8 | 172.8 | 172.52 | 172.54 | 2555.0 |
| 2023-10-02 04:15:00 | AAPL | Stock | 172.53 | 172.53 | 172.4 | 172.4 | 4694.0 |
| 2023-10-02 04:25:00 | AAPL | Stock | 172.54 | 172.54 | 172.54 | 172.54 | 100.0 |
| 2023-10-02 04:30:00 | AAPL | Stock | 172.56 | 172.56 | 172.56 | 172.56 | 300.0 |
| 2023-10-02 04:40:00 | AAPL | Stock | 172.65 | 172.65 | 172.65 | 172.65 | 497.0 |
| 2023-10-02 04:45:00 | AAPL | Stock | 172.62 | 172.78 | 172.62 | 172.71 | 3192.0 |
| 2023-10-02 04:50:00 | AAPL | Stock | 172.67 | 172.67 | 172.67 | 172.67 | 224.0 |
| 2023-10-02 04:55:00 | AAPL | Stock | 172.6 | 172.6 | 172.51 | 172.51 | 1155.0 |
| 2023-10-02 05:00:00 | AAPL | Stock | 172.5 | 172.5 | 172.39 | 172.39 | 1141.0 |
| 2023-10-02 05:05:00 | AAPL | Stock | 172.31 | 172.31 | 172.19 | 172.2 | 1563.0 |
| 2023-10-02 05:10:00 | AAPL | Stock | 172.25 | 172.26 | 172.24 | 172.24 | 3655.0 |
| 2023-10-02 05:15:00 | AAPL | Stock | 172.2 | 172.23 | 171.9 | 171.99 | 13101.0 |
| 2023-10-02 05:20:00 | AAPL | Stock | 172.08 | 172.08 | 172.08 | 172.08 | 100.0 |
| 2023-10-02 05:25:00 | AAPL | Stock | 172.07 | 172.07 | 171.9 | 171.9 | 859.0 |
| 2023-10-02 05:30:00 | AAPL | Stock | 171.98 | 172.18 | 171.98 | 172.14 | 1276.0 |
| 2023-10-02 05:40:00 | AAPL | Stock | 171.94 | 172.03 | 171.94 | 172.03 | 500.0 |
| 2023-10-02 05:45:00 | AAPL | Stock | 172.06 | 172.1 | 171.5 | 171.54 | 6562.0 |
| 2023-10-02 05:50:00 | AAPL | Stock | 171.62 | 171.71 | 171.51 | 171.51 | 3221.0 |
| 2023-10-02 05:55:00 | AAPL | Stock | 171.6 | 171.62 | 171.33 | 171.33 | 10615.0 |
| 2023-10-02 06:00:00 | AAPL | Stock | 171.42 | 171.51 | 171.4 | 171.46 | 1248.0 |
| 2023-10-02 06:05:00 | AAPL | Stock | 171.55 | 171.6 | 171.49 | 171.49 | 508.0 |
| 2023-10-02 06:10:00 | AAPL | Stock | 171.43 | 171.43 | 171.03 | 171.03 | 2423.0 |
| 2023-10-02 06:15:00 | AAPL | Stock | 171.48 | 171.5 | 171.48 | 171.48 | 400.0 |
| 2023-10-02 06:20:00 | AAPL | Stock | 171.61 | 171.61 | 171.6 | 171.61 | 1246.0 |
| 2023-10-02 06:25:00 | AAPL | Stock | 171.58 | 171.58 | 171.25 | 171.3 | 2484.0 |
| 2023-10-02 06:30:00 | AAPL | Stock | 171.27 | 171.32 | 171.27 | 171.27 | 581.0 |
| 2023-10-02 06:35:00 | AAPL | Stock | 171.34 | 171.34 | 171.31 | 171.31 | 415.0 |
| 2023-10-02 06:40:00 | AAPL | Stock | 171.4 | 171.4 | 171.32 | 171.38 | 336.0 |
| 2023-10-02 06:45:00 | AAPL | Stock | 171.32 | 171.44 | 171.32 | 171.36 | 822.0 |
| 2023-10-02 06:50:00 | AAPL | Stock | 171.35 | 171.35 | 171.04 | 171.21 | 5525.0 |
| 2023-10-02 06:55:00 | AAPL | Stock | 171.34 | 171.34 | 171.06 | 171.23 | 3977.0 |
| 2023-10-02 07:00:00 | AAPL | Stock | 171.37 | 171.37 | 171.25 | 171.25 | 5530.0 |
| 2023-10-02 07:05:00 | AAPL | Stock | 171.25 | 171.33 | 171.25 | 171.33 | 3956.0 |
| 2023-10-02 07:10:00 | AAPL | Stock | 171.35 | 171.4 | 171.35 | 171.4 | 3206.0 |
| 2023-10-02 07:15:00 | AAPL | Stock | 171.45 | 171.59 | 171.45 | 171.57 | 2573.0 |
| 2023-10-02 07:20:00 | AAPL | Stock | 171.6 | 171.8 | 171.6 | 171.8 | 4699.0 |
| 2023-10-02 07:25:00 | AAPL | Stock | 171.85 | 171.97 | 171.85 | 171.95 | 4848.0 |
| 2023-10-02 07:30:00 | AAPL | Stock | 171.9 | 171.94 | 171.6 | 171.69 | 5374.0 |
| 2023-10-02 07:35:00 | AAPL | Stock | 171.74 | 171.82 | 171.74 | 171.82 | 2005.0 |
| 2023-10-02 07:40:00 | AAPL | Stock | 171.82 | 171.82 | 171.45 | 171.45 | 6088.0 |
| 2023-10-02 07:45:00 | AAPL | Stock | 171.4 | 171.49 | 171.29 | 171.47 | 7673.0 |
| 2023-10-02 07:50:00 | AAPL | Stock | 171.41 | 171.5 | 171.41 | 171.5 | 2700.0 |
| 2023-10-02 07:55:00 | AAPL | Stock | 171.5 | 171.56 | 171.5 | 171.55 | 1735.0 |
| 2023-10-02 08:00:00 | AAPL | Stock | 171.38 | 172.99 | 171.2 | 171.428 | 43840.0 |
| 2023-10-02 08:05:00 | AAPL | Stock | 171.36 | 171.46 | 171.36 | 171.4495 | 1790.0 |
| 2023-10-02 08:10:00 | AAPL | Stock | 171.37 | 171.54 | 171.37 | 171.45 | 24520.0 |
| 2023-10-02 08:15:00 | AAPL | Stock | 171.5 | 171.5 | 171.26 | 171.35 | 3972.0 |
| 2023-10-02 08:20:00 | AAPL | Stock | 171.31 | 171.46 | 171.06 | 171.16 | 27294.0 |
> showing 50 of 398,046 rows — these rows as CSV