PREVIEW / stock_5min / 2022-07-07
file: by_date/stock_5min/2022/2022-07-07.parquet size: 6.9 MB rows: 428,971 symbols: 2,324
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 |
|---|---|---|---|---|---|---|---|
| 2022-07-07 04:00:00 | AAPL | Stock | 143.15 | 143.45 | 143.15 | 143.4 | 4625.0 |
| 2022-07-07 04:05:00 | AAPL | Stock | 143.32 | 143.66 | 143.32 | 143.66 | 3202.0 |
| 2022-07-07 04:10:00 | AAPL | Stock | 143.49 | 143.5 | 143.43 | 143.43 | 1571.0 |
| 2022-07-07 04:15:00 | AAPL | Stock | 143.5 | 143.55 | 143.5 | 143.55 | 1580.0 |
| 2022-07-07 04:25:00 | AAPL | Stock | 143.54 | 143.54 | 143.54 | 143.54 | 100.0 |
| 2022-07-07 04:30:00 | AAPL | Stock | 143.6 | 143.62 | 143.58 | 143.58 | 1106.0 |
| 2022-07-07 04:35:00 | AAPL | Stock | 143.52 | 143.52 | 143.3 | 143.3 | 26990.0 |
| 2022-07-07 04:40:00 | AAPL | Stock | 143.3 | 143.3 | 143.2 | 143.2 | 500.0 |
| 2022-07-07 04:45:00 | AAPL | Stock | 143.16 | 143.25 | 143.16 | 143.25 | 1190.0 |
| 2022-07-07 04:50:00 | AAPL | Stock | 143.3 | 143.3 | 143.3 | 143.3 | 100.0 |
| 2022-07-07 04:55:00 | AAPL | Stock | 143.39 | 143.6 | 143.16 | 143.6 | 2325.0 |
| 2022-07-07 05:00:00 | AAPL | Stock | 143.47 | 143.47 | 143.4 | 143.46 | 1753.0 |
| 2022-07-07 05:05:00 | AAPL | Stock | 143.27 | 143.43 | 143.26 | 143.43 | 1336.0 |
| 2022-07-07 05:10:00 | AAPL | Stock | 143.48 | 143.49 | 143.3 | 143.3 | 1388.0 |
| 2022-07-07 05:20:00 | AAPL | Stock | 143.49 | 143.49 | 143.4 | 143.4 | 1189.0 |
| 2022-07-07 05:25:00 | AAPL | Stock | 143.31 | 143.31 | 143.28 | 143.31 | 400.0 |
| 2022-07-07 05:30:00 | AAPL | Stock | 143.29 | 143.29 | 143.21 | 143.21 | 1513.0 |
| 2022-07-07 05:35:00 | AAPL | Stock | 143.33 | 143.34 | 143.33 | 143.34 | 745.0 |
| 2022-07-07 05:40:00 | AAPL | Stock | 143.29 | 143.29 | 143.21 | 143.22 | 300.0 |
| 2022-07-07 05:45:00 | AAPL | Stock | 143.21 | 143.21 | 143.15 | 143.15 | 1124.0 |
| 2022-07-07 05:50:00 | AAPL | Stock | 143.11 | 143.16 | 143.04 | 143.04 | 1222.0 |
| 2022-07-07 05:55:00 | AAPL | Stock | 143.1 | 143.1 | 143.07 | 143.07 | 441.0 |
| 2022-07-07 06:00:00 | AAPL | Stock | 143.13 | 143.13 | 143.13 | 143.13 | 100.0 |
| 2022-07-07 06:05:00 | AAPL | Stock | 143.13 | 143.13 | 143.07 | 143.07 | 654.0 |
| 2022-07-07 06:15:00 | AAPL | Stock | 143.04 | 143.04 | 143.0 | 143.0 | 2013.0 |
| 2022-07-07 06:20:00 | AAPL | Stock | 143.0 | 143.0 | 142.8 | 142.8 | 1330.0 |
| 2022-07-07 06:25:00 | AAPL | Stock | 142.97 | 143.01 | 142.88 | 142.88 | 900.0 |
| 2022-07-07 06:30:00 | AAPL | Stock | 143.09 | 143.09 | 143.09 | 143.09 | 100.0 |
| 2022-07-07 06:35:00 | AAPL | Stock | 143.13 | 143.13 | 143.13 | 143.13 | 103.0 |
| 2022-07-07 06:40:00 | AAPL | Stock | 143.13 | 143.13 | 143.13 | 143.13 | 149.0 |
| 2022-07-07 06:45:00 | AAPL | Stock | 143.13 | 143.22 | 143.13 | 143.2 | 3131.0 |
| 2022-07-07 06:50:00 | AAPL | Stock | 143.2 | 143.23 | 143.2 | 143.22 | 3031.0 |
| 2022-07-07 06:55:00 | AAPL | Stock | 143.21 | 143.3 | 143.21 | 143.21 | 3602.0 |
| 2022-07-07 07:00:00 | AAPL | Stock | 143.22 | 143.38 | 143.22 | 143.22 | 11161.0 |
| 2022-07-07 07:05:00 | AAPL | Stock | 143.22 | 143.29 | 143.22 | 143.29 | 730.0 |
| 2022-07-07 07:10:00 | AAPL | Stock | 143.26 | 143.26 | 143.26 | 143.26 | 100.0 |
| 2022-07-07 07:15:00 | AAPL | Stock | 143.25 | 143.25 | 143.25 | 143.25 | 808.0 |
| 2022-07-07 07:20:00 | AAPL | Stock | 143.26 | 143.26 | 143.15 | 143.15 | 2900.0 |
| 2022-07-07 07:25:00 | AAPL | Stock | 143.23 | 143.23 | 143.23 | 143.23 | 270.0 |
| 2022-07-07 07:30:00 | AAPL | Stock | 143.25 | 143.35 | 143.24 | 143.35 | 3699.0 |
| 2022-07-07 07:35:00 | AAPL | Stock | 143.37 | 143.37 | 143.28 | 143.31 | 688.0 |
| 2022-07-07 07:40:00 | AAPL | Stock | 143.35 | 143.4 | 143.35 | 143.35 | 2789.0 |
| 2022-07-07 07:45:00 | AAPL | Stock | 143.39 | 143.39 | 143.25 | 143.25 | 4490.0 |
| 2022-07-07 07:50:00 | AAPL | Stock | 143.34 | 143.41 | 143.31 | 143.41 | 3540.0 |
| 2022-07-07 07:55:00 | AAPL | Stock | 143.45 | 143.56 | 143.45 | 143.56 | 10437.0 |
| 2022-07-07 08:00:00 | AAPL | Stock | 143.25 | 143.57 | 142.563 | 143.49 | 59345.0 |
| 2022-07-07 08:05:00 | AAPL | Stock | 143.45 | 143.49 | 143.3725 | 143.41 | 13903.0 |
| 2022-07-07 08:10:00 | AAPL | Stock | 143.4 | 143.41 | 143.32 | 143.32 | 8794.0 |
| 2022-07-07 08:15:00 | AAPL | Stock | 143.31 | 143.36 | 143.11 | 143.11 | 18238.0 |
| 2022-07-07 08:20:00 | AAPL | Stock | 143.1 | 143.27 | 143.1 | 143.22 | 19673.0 |
> showing 50 of 428,971 rows — these rows as CSV