PREVIEW / stock_5min / 2021-08-26
file: by_date/stock_5min/2021/2021-08-26.parquet size: 7.2 MB rows: 442,024 symbols: 2,756
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 |
|---|---|---|---|---|---|---|---|
| 2021-08-26 04:00:00 | AAPL | Stock | 148.0 | 148.1 | 148.0 | 148.1 | 667.0 |
| 2021-08-26 04:05:00 | AAPL | Stock | 148.01 | 148.01 | 148.0 | 148.0 | 210.0 |
| 2021-08-26 04:10:00 | AAPL | Stock | 147.92 | 147.92 | 147.92 | 147.92 | 405.0 |
| 2021-08-26 04:15:00 | AAPL | Stock | 148.0 | 148.0 | 148.0 | 148.0 | 100.0 |
| 2021-08-26 04:25:00 | AAPL | Stock | 148.1 | 148.13 | 148.1 | 148.1 | 364.0 |
| 2021-08-26 04:50:00 | AAPL | Stock | 148.08 | 148.09 | 148.08 | 148.09 | 492.0 |
| 2021-08-26 04:55:00 | AAPL | Stock | 148.09 | 148.11 | 148.09 | 148.11 | 360.0 |
| 2021-08-26 05:00:00 | AAPL | Stock | 148.04 | 148.04 | 148.04 | 148.04 | 253.0 |
| 2021-08-26 05:05:00 | AAPL | Stock | 148.0 | 148.0 | 148.0 | 148.0 | 332.0 |
| 2021-08-26 05:10:00 | AAPL | Stock | 148.08 | 148.08 | 148.08 | 148.08 | 341.0 |
| 2021-08-26 05:15:00 | AAPL | Stock | 148.08 | 148.08 | 148.08 | 148.08 | 300.0 |
| 2021-08-26 05:20:00 | AAPL | Stock | 148.07 | 148.07 | 148.07 | 148.07 | 228.0 |
| 2021-08-26 05:30:00 | AAPL | Stock | 148.07 | 148.07 | 148.07 | 148.07 | 209.0 |
| 2021-08-26 05:35:00 | AAPL | Stock | 148.05 | 148.05 | 148.05 | 148.05 | 951.0 |
| 2021-08-26 06:05:00 | AAPL | Stock | 148.07 | 148.07 | 148.07 | 148.07 | 101.0 |
| 2021-08-26 06:20:00 | AAPL | Stock | 148.12 | 148.12 | 148.12 | 148.12 | 129.0 |
| 2021-08-26 06:25:00 | AAPL | Stock | 148.15 | 148.15 | 148.09 | 148.09 | 336.0 |
| 2021-08-26 06:30:00 | AAPL | Stock | 148.07 | 148.07 | 148.05 | 148.05 | 1075.0 |
| 2021-08-26 06:40:00 | AAPL | Stock | 148.05 | 148.05 | 148.05 | 148.05 | 504.0 |
| 2021-08-26 06:45:00 | AAPL | Stock | 148.05 | 148.05 | 148.05 | 148.05 | 305.0 |
| 2021-08-26 06:50:00 | AAPL | Stock | 148.1 | 148.1 | 148.1 | 148.1 | 100.0 |
| 2021-08-26 06:55:00 | AAPL | Stock | 148.1 | 148.1 | 148.1 | 148.1 | 485.0 |
| 2021-08-26 07:00:00 | AAPL | Stock | 148.14 | 148.15 | 148.11 | 148.15 | 5453.0 |
| 2021-08-26 07:05:00 | AAPL | Stock | 148.14 | 148.15 | 148.13 | 148.13 | 1794.0 |
| 2021-08-26 07:10:00 | AAPL | Stock | 148.13 | 148.16 | 148.13 | 148.16 | 565.0 |
| 2021-08-26 07:15:00 | AAPL | Stock | 148.16 | 148.2 | 148.16 | 148.2 | 1913.0 |
| 2021-08-26 07:20:00 | AAPL | Stock | 148.22 | 148.3 | 148.22 | 148.3 | 5190.0 |
| 2021-08-26 07:25:00 | AAPL | Stock | 148.3 | 148.35 | 148.29 | 148.29 | 9570.0 |
| 2021-08-26 07:30:00 | AAPL | Stock | 148.29 | 148.29 | 148.2 | 148.2 | 3959.0 |
| 2021-08-26 07:35:00 | AAPL | Stock | 148.22 | 148.25 | 148.22 | 148.25 | 1834.0 |
| 2021-08-26 07:40:00 | AAPL | Stock | 148.25 | 148.25 | 148.22 | 148.22 | 677.0 |
| 2021-08-26 07:50:00 | AAPL | Stock | 148.24 | 148.24 | 148.21 | 148.21 | 1680.0 |
| 2021-08-26 07:55:00 | AAPL | Stock | 148.19 | 148.28 | 148.13 | 148.27 | 11600.0 |
| 2021-08-26 08:00:00 | AAPL | Stock | 148.3201 | 148.36 | 147.99 | 148.28 | 49101.0 |
| 2021-08-26 08:05:00 | AAPL | Stock | 148.29 | 148.32 | 148.22 | 148.27 | 11719.0 |
| 2021-08-26 08:10:00 | AAPL | Stock | 148.3 | 148.45 | 148.25 | 148.44 | 66045.0 |
| 2021-08-26 08:15:00 | AAPL | Stock | 148.46 | 148.54 | 148.46 | 148.52 | 9277.0 |
| 2021-08-26 08:20:00 | AAPL | Stock | 148.51 | 148.53 | 148.44 | 148.49 | 16456.0 |
| 2021-08-26 08:25:00 | AAPL | Stock | 148.5 | 148.58 | 148.48 | 148.54 | 14285.0 |
| 2021-08-26 08:30:00 | AAPL | Stock | 148.58 | 148.59 | 148.44 | 148.47 | 12036.0 |
| 2021-08-26 08:35:00 | AAPL | Stock | 148.45 | 148.45 | 148.1 | 148.29 | 101168.0 |
| 2021-08-26 08:40:00 | AAPL | Stock | 148.28 | 148.35 | 148.18 | 148.26 | 68873.0 |
| 2021-08-26 08:45:00 | AAPL | Stock | 148.25 | 148.33 | 148.24 | 148.3281 | 20641.0 |
| 2021-08-26 08:50:00 | AAPL | Stock | 148.3 | 148.33 | 148.24 | 148.32 | 42991.0 |
| 2021-08-26 08:55:00 | AAPL | Stock | 148.33 | 148.33 | 148.25 | 148.33 | 17138.0 |
| 2021-08-26 09:00:00 | AAPL | Stock | 148.33 | 148.38 | 148.3 | 148.31 | 17666.0 |
| 2021-08-26 09:05:00 | AAPL | Stock | 148.2701 | 148.2701 | 148.21 | 148.26 | 14674.0 |
| 2021-08-26 09:10:00 | AAPL | Stock | 148.25 | 148.28 | 148.25 | 148.28 | 5858.0 |
| 2021-08-26 09:15:00 | AAPL | Stock | 148.31 | 148.34 | 148.29 | 148.32 | 11880.0 |
| 2021-08-26 09:20:00 | AAPL | Stock | 148.31 | 148.31 | 148.27 | 148.31 | 11622.0 |
> showing 50 of 442,024 rows — these rows as CSV