PREVIEW / stock_5min / 2021-11-03
file: by_date/stock_5min/2021/2021-11-03.parquet size: 7.6 MB rows: 470,860 symbols: 2,717
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-11-03 04:00:00 | AAPL | Stock | 150.05 | 150.39 | 150.05 | 150.25 | 1496.0 |
| 2021-11-03 04:05:00 | AAPL | Stock | 150.25 | 150.37 | 150.24 | 150.37 | 2290.0 |
| 2021-11-03 04:10:00 | AAPL | Stock | 150.31 | 150.35 | 150.31 | 150.35 | 357.0 |
| 2021-11-03 04:15:00 | AAPL | Stock | 150.37 | 150.39 | 150.23 | 150.23 | 1896.0 |
| 2021-11-03 04:20:00 | AAPL | Stock | 150.21 | 150.26 | 150.21 | 150.26 | 737.0 |
| 2021-11-03 04:25:00 | AAPL | Stock | 150.32 | 150.34 | 150.25 | 150.34 | 1241.0 |
| 2021-11-03 04:30:00 | AAPL | Stock | 150.25 | 150.25 | 150.25 | 150.25 | 100.0 |
| 2021-11-03 04:35:00 | AAPL | Stock | 150.3 | 150.3 | 150.22 | 150.22 | 1356.0 |
| 2021-11-03 04:40:00 | AAPL | Stock | 150.14 | 150.14 | 150.14 | 150.14 | 211.0 |
| 2021-11-03 04:45:00 | AAPL | Stock | 150.14 | 150.14 | 150.14 | 150.14 | 100.0 |
| 2021-11-03 04:50:00 | AAPL | Stock | 150.07 | 150.07 | 150.07 | 150.07 | 100.0 |
| 2021-11-03 04:55:00 | AAPL | Stock | 150.19 | 150.19 | 150.19 | 150.19 | 287.0 |
| 2021-11-03 05:00:00 | AAPL | Stock | 150.1 | 150.11 | 150.1 | 150.11 | 200.0 |
| 2021-11-03 05:05:00 | AAPL | Stock | 150.16 | 150.16 | 150.07 | 150.07 | 518.0 |
| 2021-11-03 05:10:00 | AAPL | Stock | 150.12 | 150.17 | 150.12 | 150.17 | 1313.0 |
| 2021-11-03 05:15:00 | AAPL | Stock | 150.2 | 150.2 | 150.2 | 150.2 | 435.0 |
| 2021-11-03 05:20:00 | AAPL | Stock | 150.2 | 150.2 | 150.2 | 150.2 | 370.0 |
| 2021-11-03 05:25:00 | AAPL | Stock | 150.2 | 150.21 | 150.12 | 150.14 | 829.0 |
| 2021-11-03 05:35:00 | AAPL | Stock | 150.09 | 150.09 | 150.07 | 150.07 | 200.0 |
| 2021-11-03 05:40:00 | AAPL | Stock | 150.09 | 150.09 | 150.05 | 150.05 | 1555.0 |
| 2021-11-03 05:45:00 | AAPL | Stock | 150.08 | 150.08 | 150.08 | 150.08 | 102.0 |
| 2021-11-03 06:00:00 | AAPL | Stock | 150.01 | 150.01 | 150.01 | 150.01 | 318.0 |
| 2021-11-03 06:05:00 | AAPL | Stock | 150.04 | 150.04 | 149.99 | 149.99 | 1651.0 |
| 2021-11-03 06:10:00 | AAPL | Stock | 150.0 | 150.05 | 150.0 | 150.05 | 7626.0 |
| 2021-11-03 06:15:00 | AAPL | Stock | 150.09 | 150.11 | 150.09 | 150.1 | 1312.0 |
| 2021-11-03 06:20:00 | AAPL | Stock | 150.1 | 150.1 | 150.07 | 150.07 | 941.0 |
| 2021-11-03 06:25:00 | AAPL | Stock | 150.04 | 150.04 | 150.04 | 150.04 | 100.0 |
| 2021-11-03 06:30:00 | AAPL | Stock | 150.07 | 150.08 | 150.07 | 150.08 | 382.0 |
| 2021-11-03 06:40:00 | AAPL | Stock | 150.06 | 150.1 | 150.06 | 150.06 | 529.0 |
| 2021-11-03 06:45:00 | AAPL | Stock | 150.03 | 150.03 | 150.03 | 150.03 | 100.0 |
| 2021-11-03 06:50:00 | AAPL | Stock | 150.03 | 150.03 | 150.0 | 150.0 | 538.0 |
| 2021-11-03 06:55:00 | AAPL | Stock | 150.0 | 150.0 | 150.0 | 150.0 | 377.0 |
| 2021-11-03 07:00:00 | AAPL | Stock | 150.0 | 150.03 | 149.99 | 150.03 | 4049.0 |
| 2021-11-03 07:05:00 | AAPL | Stock | 150.0 | 150.0 | 149.99 | 149.99 | 2116.0 |
| 2021-11-03 07:10:00 | AAPL | Stock | 149.98 | 150.06 | 149.98 | 150.03 | 1570.0 |
| 2021-11-03 07:15:00 | AAPL | Stock | 150.08 | 150.11 | 150.07 | 150.1 | 6292.0 |
| 2021-11-03 07:20:00 | AAPL | Stock | 150.1 | 150.19 | 150.1 | 150.16 | 5808.0 |
| 2021-11-03 07:25:00 | AAPL | Stock | 150.17 | 150.23 | 150.17 | 150.19 | 5679.0 |
| 2021-11-03 07:30:00 | AAPL | Stock | 150.21 | 150.24 | 150.12 | 150.13 | 4474.0 |
| 2021-11-03 07:35:00 | AAPL | Stock | 150.12 | 150.2 | 150.12 | 150.16 | 3391.0 |
| 2021-11-03 07:40:00 | AAPL | Stock | 150.18 | 150.21 | 150.18 | 150.21 | 1357.0 |
| 2021-11-03 07:45:00 | AAPL | Stock | 150.22 | 150.24 | 150.21 | 150.22 | 4536.0 |
| 2021-11-03 07:50:00 | AAPL | Stock | 150.25 | 150.26 | 150.24 | 150.25 | 3473.0 |
| 2021-11-03 07:55:00 | AAPL | Stock | 150.23 | 150.23 | 150.21 | 150.23 | 954.0 |
| 2021-11-03 08:00:00 | AAPL | Stock | 149.95 | 150.28 | 149.95 | 150.25 | 75966.0 |
| 2021-11-03 08:05:00 | AAPL | Stock | 150.24 | 150.24 | 150.17 | 150.18 | 16637.0 |
| 2021-11-03 08:10:00 | AAPL | Stock | 150.2 | 150.25 | 150.2 | 150.22 | 5606.0 |
| 2021-11-03 08:15:00 | AAPL | Stock | 150.22 | 150.22 | 150.15 | 150.16 | 5052.0 |
| 2021-11-03 08:20:00 | AAPL | Stock | 150.1799 | 150.18 | 150.0806 | 150.1101 | 12699.0 |
| 2021-11-03 08:25:00 | AAPL | Stock | 150.11 | 150.16 | 150.11 | 150.15 | 13147.0 |
> showing 50 of 470,860 rows — these rows as CSV