PREVIEW / stock_5min / 2022-09-28
file: by_date/stock_5min/2022/2022-09-28.parquet size: 6.9 MB rows: 431,693 symbols: 2,217
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-09-28 04:00:00 | AAPL | Stock | 149.47 | 149.75 | 147.4 | 147.4 | 62014.0 |
| 2022-09-28 04:05:00 | AAPL | Stock | 147.38 | 147.82 | 147.38 | 147.4 | 20705.0 |
| 2022-09-28 04:10:00 | AAPL | Stock | 147.4 | 147.6 | 146.69 | 146.94 | 48280.0 |
| 2022-09-28 04:15:00 | AAPL | Stock | 146.99 | 147.14 | 146.8 | 146.8 | 15883.0 |
| 2022-09-28 04:20:00 | AAPL | Stock | 146.9 | 147.35 | 146.9 | 147.25 | 19740.0 |
| 2022-09-28 04:25:00 | AAPL | Stock | 147.33 | 147.34 | 146.75 | 146.9 | 10913.0 |
| 2022-09-28 04:30:00 | AAPL | Stock | 146.83 | 146.89 | 146.67 | 146.67 | 10688.0 |
| 2022-09-28 04:35:00 | AAPL | Stock | 146.67 | 146.9 | 146.6 | 146.6 | 15785.0 |
| 2022-09-28 04:40:00 | AAPL | Stock | 146.52 | 146.62 | 146.52 | 146.62 | 3059.0 |
| 2022-09-28 04:45:00 | AAPL | Stock | 146.68 | 146.75 | 146.55 | 146.73 | 26381.0 |
| 2022-09-28 04:50:00 | AAPL | Stock | 146.7 | 146.86 | 146.64 | 146.85 | 6891.0 |
| 2022-09-28 04:55:00 | AAPL | Stock | 146.85 | 147.09 | 146.5 | 146.68 | 12656.0 |
| 2022-09-28 05:00:00 | AAPL | Stock | 146.6 | 146.77 | 146.3 | 146.35 | 12126.0 |
| 2022-09-28 05:05:00 | AAPL | Stock | 146.33 | 146.35 | 146.0 | 146.05 | 38629.0 |
| 2022-09-28 05:10:00 | AAPL | Stock | 146.06 | 146.26 | 146.06 | 146.1 | 9069.0 |
| 2022-09-28 05:15:00 | AAPL | Stock | 146.01 | 146.03 | 145.7 | 145.77 | 19930.0 |
| 2022-09-28 05:20:00 | AAPL | Stock | 145.82 | 145.9 | 145.75 | 145.89 | 9810.0 |
| 2022-09-28 05:25:00 | AAPL | Stock | 145.87 | 146.11 | 145.75 | 146.11 | 6918.0 |
| 2022-09-28 05:30:00 | AAPL | Stock | 146.15 | 146.15 | 146.0 | 146.0 | 1641.0 |
| 2022-09-28 05:35:00 | AAPL | Stock | 146.0 | 146.0 | 145.71 | 145.88 | 3710.0 |
| 2022-09-28 05:40:00 | AAPL | Stock | 145.83 | 145.99 | 145.83 | 145.99 | 1464.0 |
| 2022-09-28 05:45:00 | AAPL | Stock | 146.0 | 146.1 | 145.78 | 145.78 | 4044.0 |
| 2022-09-28 05:50:00 | AAPL | Stock | 145.75 | 145.91 | 145.69 | 145.89 | 6202.0 |
| 2022-09-28 05:55:00 | AAPL | Stock | 145.84 | 145.84 | 145.7 | 145.75 | 3162.0 |
| 2022-09-28 06:00:00 | AAPL | Stock | 145.72 | 146.66 | 145.61 | 145.79 | 32721.0 |
| 2022-09-28 06:05:00 | AAPL | Stock | 145.79 | 146.28 | 145.61 | 146.23 | 42401.0 |
| 2022-09-28 06:10:00 | AAPL | Stock | 146.14 | 146.49 | 145.75 | 146.24 | 41981.0 |
| 2022-09-28 06:15:00 | AAPL | Stock | 146.25 | 146.5 | 146.0 | 146.42 | 51140.0 |
| 2022-09-28 06:20:00 | AAPL | Stock | 146.41 | 147.27 | 146.41 | 146.77 | 53878.0 |
| 2022-09-28 06:25:00 | AAPL | Stock | 146.81 | 146.87 | 146.37 | 146.84 | 36889.0 |
| 2022-09-28 06:30:00 | AAPL | Stock | 146.87 | 146.94 | 146.1 | 146.3 | 60300.0 |
| 2022-09-28 06:35:00 | AAPL | Stock | 146.21 | 146.71 | 145.7 | 146.67 | 35675.0 |
| 2022-09-28 06:40:00 | AAPL | Stock | 146.6 | 147.01 | 146.6 | 146.88 | 20835.0 |
| 2022-09-28 06:45:00 | AAPL | Stock | 146.8 | 146.8 | 146.12 | 146.29 | 11976.0 |
| 2022-09-28 06:50:00 | AAPL | Stock | 146.49 | 146.6 | 146.27 | 146.27 | 5699.0 |
| 2022-09-28 06:55:00 | AAPL | Stock | 146.16 | 146.3 | 145.81 | 145.91 | 18448.0 |
| 2022-09-28 07:00:00 | AAPL | Stock | 145.95 | 146.4 | 145.8 | 145.8 | 116042.0 |
| 2022-09-28 07:05:00 | AAPL | Stock | 145.88 | 145.88 | 145.66 | 145.81 | 26049.0 |
| 2022-09-28 07:10:00 | AAPL | Stock | 145.83 | 146.1 | 145.75 | 145.75 | 42230.0 |
| 2022-09-28 07:15:00 | AAPL | Stock | 145.75 | 146.16 | 145.75 | 146.16 | 18729.0 |
| 2022-09-28 07:20:00 | AAPL | Stock | 146.15 | 146.4 | 145.89 | 146.13 | 24774.0 |
| 2022-09-28 07:25:00 | AAPL | Stock | 146.13 | 146.2 | 146.02 | 146.06 | 35651.0 |
| 2022-09-28 07:30:00 | AAPL | Stock | 146.03 | 146.3 | 146.0 | 146.19 | 30955.0 |
| 2022-09-28 07:35:00 | AAPL | Stock | 146.19 | 146.2 | 145.83 | 146.03 | 48232.0 |
| 2022-09-28 07:40:00 | AAPL | Stock | 145.98 | 146.18 | 145.8 | 146.09 | 56622.0 |
| 2022-09-28 07:45:00 | AAPL | Stock | 146.09 | 146.14 | 145.94 | 146.0 | 23571.0 |
| 2022-09-28 07:50:00 | AAPL | Stock | 145.99 | 145.99 | 145.83 | 145.99 | 24101.0 |
| 2022-09-28 07:55:00 | AAPL | Stock | 145.98 | 146.0 | 145.81 | 146.0 | 28610.0 |
| 2022-09-28 08:00:00 | AAPL | Stock | 146.34 | 148.41 | 145.66 | 146.38 | 304771.0 |
| 2022-09-28 08:05:00 | AAPL | Stock | 146.4 | 151.76 | 146.3 | 146.52 | 355475.0 |
> showing 50 of 431,693 rows — these rows as CSV