PREVIEW / stock_5min / 2021-07-29
file: by_date/stock_5min/2021/2021-07-29.parquet size: 7.3 MB rows: 448,117 symbols: 2,835
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-07-29 04:00:00 | AAPL | Stock | 145.14 | 145.69 | 145.14 | 145.45 | 1200.0 |
| 2021-07-29 04:05:00 | AAPL | Stock | 145.46 | 145.5 | 145.15 | 145.5 | 3441.0 |
| 2021-07-29 04:10:00 | AAPL | Stock | 145.5 | 145.5 | 145.5 | 145.5 | 200.0 |
| 2021-07-29 04:15:00 | AAPL | Stock | 145.45 | 145.5 | 144.98 | 145.26 | 13400.0 |
| 2021-07-29 04:20:00 | AAPL | Stock | 145.04 | 145.15 | 144.99 | 145.04 | 1735.0 |
| 2021-07-29 04:25:00 | AAPL | Stock | 145.1 | 145.2 | 145.1 | 145.15 | 508.0 |
| 2021-07-29 04:30:00 | AAPL | Stock | 145.25 | 145.25 | 145.25 | 145.25 | 416.0 |
| 2021-07-29 04:40:00 | AAPL | Stock | 145.25 | 145.25 | 145.17 | 145.17 | 571.0 |
| 2021-07-29 04:45:00 | AAPL | Stock | 145.14 | 145.14 | 145.0 | 145.04 | 932.0 |
| 2021-07-29 04:50:00 | AAPL | Stock | 145.04 | 145.11 | 145.04 | 145.11 | 1300.0 |
| 2021-07-29 04:55:00 | AAPL | Stock | 145.1 | 145.1 | 145.0 | 145.0 | 1321.0 |
| 2021-07-29 05:00:00 | AAPL | Stock | 145.0 | 145.04 | 145.0 | 145.04 | 276.0 |
| 2021-07-29 05:05:00 | AAPL | Stock | 145.01 | 145.01 | 144.94 | 144.94 | 1297.0 |
| 2021-07-29 05:10:00 | AAPL | Stock | 144.98 | 145.08 | 144.98 | 145.08 | 2290.0 |
| 2021-07-29 05:15:00 | AAPL | Stock | 145.08 | 145.11 | 145.08 | 145.11 | 2593.0 |
| 2021-07-29 05:25:00 | AAPL | Stock | 145.05 | 145.05 | 145.05 | 145.05 | 592.0 |
| 2021-07-29 05:30:00 | AAPL | Stock | 145.16 | 145.16 | 145.16 | 145.16 | 550.0 |
| 2021-07-29 05:35:00 | AAPL | Stock | 145.12 | 145.26 | 145.12 | 145.26 | 1835.0 |
| 2021-07-29 05:40:00 | AAPL | Stock | 145.38 | 145.38 | 145.31 | 145.31 | 214.0 |
| 2021-07-29 05:45:00 | AAPL | Stock | 145.31 | 145.31 | 145.3 | 145.3 | 327.0 |
| 2021-07-29 05:50:00 | AAPL | Stock | 145.3 | 145.3 | 145.2 | 145.2 | 1143.0 |
| 2021-07-29 05:55:00 | AAPL | Stock | 145.23 | 145.23 | 145.23 | 145.23 | 443.0 |
| 2021-07-29 06:00:00 | AAPL | Stock | 145.21 | 145.21 | 144.99 | 145.0 | 6738.0 |
| 2021-07-29 06:05:00 | AAPL | Stock | 145.05 | 145.05 | 145.05 | 145.05 | 100.0 |
| 2021-07-29 06:10:00 | AAPL | Stock | 145.05 | 145.11 | 144.98 | 145.05 | 1946.0 |
| 2021-07-29 06:15:00 | AAPL | Stock | 145.01 | 145.07 | 145.01 | 145.07 | 380.0 |
| 2021-07-29 06:20:00 | AAPL | Stock | 145.11 | 145.11 | 145.0 | 145.11 | 1431.0 |
| 2021-07-29 06:25:00 | AAPL | Stock | 145.14 | 145.14 | 145.03 | 145.03 | 788.0 |
| 2021-07-29 06:30:00 | AAPL | Stock | 145.03 | 145.03 | 144.94 | 145.0 | 1268.0 |
| 2021-07-29 06:35:00 | AAPL | Stock | 144.94 | 144.99 | 144.94 | 144.98 | 2982.0 |
| 2021-07-29 06:40:00 | AAPL | Stock | 144.98 | 144.98 | 144.82 | 144.82 | 1839.0 |
| 2021-07-29 06:45:00 | AAPL | Stock | 144.82 | 144.85 | 144.73 | 144.73 | 3259.0 |
| 2021-07-29 06:50:00 | AAPL | Stock | 144.53 | 144.61 | 144.5 | 144.61 | 660.0 |
| 2021-07-29 06:55:00 | AAPL | Stock | 144.7 | 144.8 | 144.7 | 144.8 | 2105.0 |
| 2021-07-29 07:00:00 | AAPL | Stock | 144.79 | 144.93 | 144.73 | 144.93 | 20516.0 |
| 2021-07-29 07:05:00 | AAPL | Stock | 144.85 | 144.88 | 144.75 | 144.8 | 7790.0 |
| 2021-07-29 07:10:00 | AAPL | Stock | 144.85 | 144.95 | 144.79 | 144.95 | 8914.0 |
| 2021-07-29 07:15:00 | AAPL | Stock | 144.95 | 145.01 | 144.9 | 144.95 | 9493.0 |
| 2021-07-29 07:20:00 | AAPL | Stock | 144.95 | 144.95 | 144.82 | 144.82 | 7926.0 |
| 2021-07-29 07:25:00 | AAPL | Stock | 144.85 | 144.86 | 144.78 | 144.78 | 13159.0 |
| 2021-07-29 07:30:00 | AAPL | Stock | 144.77 | 144.8 | 144.7 | 144.71 | 7103.0 |
| 2021-07-29 07:35:00 | AAPL | Stock | 144.75 | 144.8 | 144.75 | 144.77 | 2564.0 |
| 2021-07-29 07:40:00 | AAPL | Stock | 144.8 | 145.0 | 144.8 | 144.99 | 10826.0 |
| 2021-07-29 07:45:00 | AAPL | Stock | 144.99 | 145.17 | 144.99 | 145.11 | 11450.0 |
| 2021-07-29 07:50:00 | AAPL | Stock | 145.07 | 145.13 | 145.03 | 145.12 | 7183.0 |
| 2021-07-29 07:55:00 | AAPL | Stock | 145.09 | 145.15 | 145.01 | 145.15 | 5056.0 |
| 2021-07-29 08:00:00 | AAPL | Stock | 145.02 | 145.2 | 144.618 | 145.2 | 98606.0 |
| 2021-07-29 08:05:00 | AAPL | Stock | 145.2 | 145.3 | 145.2 | 145.27 | 24841.0 |
| 2021-07-29 08:10:00 | AAPL | Stock | 145.25 | 145.29 | 145.235 | 145.28 | 16200.0 |
| 2021-07-29 08:15:00 | AAPL | Stock | 145.24 | 145.25 | 145.21 | 145.21 | 3912.0 |
> showing 50 of 448,117 rows — these rows as CSV