PREVIEW / stock_5min / 2021-10-27
file: by_date/stock_5min/2021/2021-10-27.parquet size: 7.6 MB rows: 463,946 symbols: 2,705
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-10-27 04:00:00 | AAPL | Stock | 149.47 | 149.52 | 149.47 | 149.52 | 419.0 |
| 2021-10-27 04:05:00 | AAPL | Stock | 149.66 | 149.72 | 149.6 | 149.6 | 1393.0 |
| 2021-10-27 04:10:00 | AAPL | Stock | 149.72 | 149.72 | 149.51 | 149.51 | 4104.0 |
| 2021-10-27 04:15:00 | AAPL | Stock | 149.51 | 149.68 | 149.51 | 149.68 | 479.0 |
| 2021-10-27 04:20:00 | AAPL | Stock | 149.65 | 149.68 | 149.65 | 149.68 | 365.0 |
| 2021-10-27 04:30:00 | AAPL | Stock | 149.6 | 149.6 | 149.6 | 149.6 | 500.0 |
| 2021-10-27 04:35:00 | AAPL | Stock | 149.6 | 149.6 | 149.52 | 149.52 | 416.0 |
| 2021-10-27 04:40:00 | AAPL | Stock | 149.52 | 149.59 | 149.52 | 149.59 | 409.0 |
| 2021-10-27 04:45:00 | AAPL | Stock | 149.55 | 149.55 | 149.55 | 149.55 | 100.0 |
| 2021-10-27 04:50:00 | AAPL | Stock | 149.55 | 149.55 | 149.45 | 149.45 | 1617.0 |
| 2021-10-27 04:55:00 | AAPL | Stock | 149.41 | 149.41 | 149.33 | 149.33 | 1502.0 |
| 2021-10-27 05:00:00 | AAPL | Stock | 149.3 | 149.3 | 149.08 | 149.15 | 3230.0 |
| 2021-10-27 05:05:00 | AAPL | Stock | 149.14 | 149.14 | 149.14 | 149.14 | 894.0 |
| 2021-10-27 05:10:00 | AAPL | Stock | 149.08 | 149.15 | 149.0 | 149.13 | 834.0 |
| 2021-10-27 05:15:00 | AAPL | Stock | 149.06 | 149.2 | 149.06 | 149.2 | 222.0 |
| 2021-10-27 05:20:00 | AAPL | Stock | 149.27 | 149.27 | 149.15 | 149.15 | 778.0 |
| 2021-10-27 05:25:00 | AAPL | Stock | 149.44 | 149.44 | 149.25 | 149.3 | 415.0 |
| 2021-10-27 05:30:00 | AAPL | Stock | 149.31 | 149.31 | 149.3 | 149.3 | 1413.0 |
| 2021-10-27 05:35:00 | AAPL | Stock | 149.21 | 149.28 | 149.21 | 149.28 | 405.0 |
| 2021-10-27 05:40:00 | AAPL | Stock | 149.18 | 149.19 | 149.18 | 149.18 | 864.0 |
| 2021-10-27 05:50:00 | AAPL | Stock | 149.18 | 149.18 | 148.98 | 149.1 | 2147.0 |
| 2021-10-27 05:55:00 | AAPL | Stock | 149.03 | 149.12 | 149.03 | 149.12 | 1628.0 |
| 2021-10-27 06:00:00 | AAPL | Stock | 149.11 | 149.12 | 149.11 | 149.12 | 258.0 |
| 2021-10-27 06:05:00 | AAPL | Stock | 149.11 | 149.12 | 149.11 | 149.12 | 239.0 |
| 2021-10-27 06:15:00 | AAPL | Stock | 149.05 | 149.05 | 149.0 | 149.0 | 957.0 |
| 2021-10-27 06:20:00 | AAPL | Stock | 149.0 | 149.0 | 148.92 | 148.92 | 1396.0 |
| 2021-10-27 06:25:00 | AAPL | Stock | 149.05 | 149.05 | 149.05 | 149.05 | 869.0 |
| 2021-10-27 06:30:00 | AAPL | Stock | 149.05 | 149.05 | 149.05 | 149.05 | 1411.0 |
| 2021-10-27 06:35:00 | AAPL | Stock | 149.18 | 149.18 | 149.18 | 149.18 | 957.0 |
| 2021-10-27 06:40:00 | AAPL | Stock | 149.17 | 149.17 | 149.17 | 149.17 | 150.0 |
| 2021-10-27 06:45:00 | AAPL | Stock | 149.07 | 149.15 | 148.99 | 149.15 | 1543.0 |
| 2021-10-27 06:50:00 | AAPL | Stock | 149.03 | 149.03 | 148.82 | 148.82 | 3212.0 |
| 2021-10-27 06:55:00 | AAPL | Stock | 148.94 | 149.07 | 148.94 | 149.07 | 997.0 |
| 2021-10-27 07:00:00 | AAPL | Stock | 149.08 | 149.28 | 149.07 | 149.15 | 7796.0 |
| 2021-10-27 07:05:00 | AAPL | Stock | 149.15 | 149.15 | 149.01 | 149.01 | 11614.0 |
| 2021-10-27 07:10:00 | AAPL | Stock | 149.01 | 149.07 | 148.9 | 148.9 | 14250.0 |
| 2021-10-27 07:15:00 | AAPL | Stock | 148.87 | 148.95 | 148.8 | 148.95 | 23172.0 |
| 2021-10-27 07:20:00 | AAPL | Stock | 148.97 | 149.03 | 148.93 | 149.03 | 9756.0 |
| 2021-10-27 07:25:00 | AAPL | Stock | 149.0 | 149.05 | 148.96 | 149.0 | 4034.0 |
| 2021-10-27 07:30:00 | AAPL | Stock | 149.02 | 149.1 | 148.9 | 148.97 | 7616.0 |
| 2021-10-27 07:35:00 | AAPL | Stock | 148.99 | 149.05 | 148.96 | 148.99 | 3850.0 |
| 2021-10-27 07:40:00 | AAPL | Stock | 149.0 | 149.01 | 148.96 | 148.99 | 8471.0 |
| 2021-10-27 07:45:00 | AAPL | Stock | 149.05 | 149.06 | 148.96 | 148.98 | 4341.0 |
| 2021-10-27 07:50:00 | AAPL | Stock | 149.0 | 149.05 | 148.96 | 148.96 | 4429.0 |
| 2021-10-27 07:55:00 | AAPL | Stock | 148.97 | 149.05 | 148.82 | 148.85 | 20308.0 |
| 2021-10-27 08:00:00 | AAPL | Stock | 149.12 | 149.28 | 148.8 | 148.94 | 49443.0 |
| 2021-10-27 08:05:00 | AAPL | Stock | 148.96 | 148.99 | 148.86 | 148.97 | 9640.0 |
| 2021-10-27 08:10:00 | AAPL | Stock | 148.96 | 149.04 | 148.95 | 149.03 | 20192.0 |
| 2021-10-27 08:15:00 | AAPL | Stock | 149.03 | 149.0401 | 149.01 | 149.04 | 5540.0 |
| 2021-10-27 08:20:00 | AAPL | Stock | 149.01 | 149.14 | 149.01 | 149.12 | 25087.0 |
> showing 50 of 463,946 rows — these rows as CSV