PREVIEW / stock_5min / 2021-11-12
file: by_date/stock_5min/2021/2021-11-12.parquet size: 7.5 MB rows: 460,805 symbols: 2,706
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-12 04:00:00 | AAPL | Stock | 148.26 | 148.32 | 148.17 | 148.23 | 1495.0 |
| 2021-11-12 04:05:00 | AAPL | Stock | 148.17 | 148.17 | 148.1 | 148.1 | 399.0 |
| 2021-11-12 04:10:00 | AAPL | Stock | 148.05 | 148.05 | 148.05 | 148.05 | 400.0 |
| 2021-11-12 04:15:00 | AAPL | Stock | 148.03 | 148.03 | 147.95 | 147.95 | 1121.0 |
| 2021-11-12 04:20:00 | AAPL | Stock | 148.02 | 148.03 | 148.02 | 148.03 | 520.0 |
| 2021-11-12 04:25:00 | AAPL | Stock | 147.95 | 148.0 | 147.95 | 147.95 | 440.0 |
| 2021-11-12 04:30:00 | AAPL | Stock | 147.99 | 148.0 | 147.99 | 148.0 | 267.0 |
| 2021-11-12 04:35:00 | AAPL | Stock | 148.0 | 148.0 | 147.95 | 147.98 | 984.0 |
| 2021-11-12 04:40:00 | AAPL | Stock | 147.98 | 147.98 | 147.95 | 147.95 | 532.0 |
| 2021-11-12 04:45:00 | AAPL | Stock | 148.04 | 148.08 | 148.04 | 148.08 | 723.0 |
| 2021-11-12 04:55:00 | AAPL | Stock | 148.01 | 148.01 | 148.01 | 148.01 | 100.0 |
| 2021-11-12 05:00:00 | AAPL | Stock | 148.04 | 148.04 | 148.04 | 148.04 | 123.0 |
| 2021-11-12 05:05:00 | AAPL | Stock | 148.05 | 148.08 | 148.05 | 148.08 | 2090.0 |
| 2021-11-12 05:10:00 | AAPL | Stock | 148.05 | 148.05 | 148.05 | 148.05 | 256.0 |
| 2021-11-12 05:25:00 | AAPL | Stock | 148.01 | 148.03 | 148.01 | 148.03 | 350.0 |
| 2021-11-12 05:30:00 | AAPL | Stock | 148.03 | 148.03 | 148.01 | 148.01 | 605.0 |
| 2021-11-12 05:35:00 | AAPL | Stock | 148.01 | 148.01 | 148.0 | 148.0 | 1396.0 |
| 2021-11-12 05:50:00 | AAPL | Stock | 148.05 | 148.05 | 148.05 | 148.05 | 317.0 |
| 2021-11-12 06:05:00 | AAPL | Stock | 148.09 | 148.09 | 148.05 | 148.05 | 639.0 |
| 2021-11-12 06:10:00 | AAPL | Stock | 148.05 | 148.05 | 148.05 | 148.05 | 115.0 |
| 2021-11-12 06:20:00 | AAPL | Stock | 148.05 | 148.05 | 148.05 | 148.05 | 807.0 |
| 2021-11-12 06:35:00 | AAPL | Stock | 148.12 | 148.12 | 148.12 | 148.12 | 574.0 |
| 2021-11-12 06:40:00 | AAPL | Stock | 148.12 | 148.12 | 148.11 | 148.12 | 1087.0 |
| 2021-11-12 06:45:00 | AAPL | Stock | 148.1 | 148.18 | 148.1 | 148.18 | 1751.0 |
| 2021-11-12 06:50:00 | AAPL | Stock | 148.16 | 148.16 | 148.16 | 148.16 | 100.0 |
| 2021-11-12 06:55:00 | AAPL | Stock | 148.16 | 148.17 | 148.16 | 148.17 | 1463.0 |
| 2021-11-12 07:00:00 | AAPL | Stock | 148.23 | 148.3 | 148.12 | 148.2 | 9834.0 |
| 2021-11-12 07:05:00 | AAPL | Stock | 148.2 | 148.23 | 148.18 | 148.18 | 3294.0 |
| 2021-11-12 07:10:00 | AAPL | Stock | 148.16 | 148.16 | 148.15 | 148.15 | 5300.0 |
| 2021-11-12 07:15:00 | AAPL | Stock | 148.15 | 148.2 | 148.12 | 148.16 | 1929.0 |
| 2021-11-12 07:25:00 | AAPL | Stock | 148.17 | 148.18 | 148.17 | 148.18 | 1200.0 |
| 2021-11-12 07:30:00 | AAPL | Stock | 148.16 | 148.16 | 148.15 | 148.15 | 1693.0 |
| 2021-11-12 07:35:00 | AAPL | Stock | 148.13 | 148.14 | 148.13 | 148.14 | 2517.0 |
| 2021-11-12 07:40:00 | AAPL | Stock | 148.15 | 148.15 | 148.15 | 148.15 | 100.0 |
| 2021-11-12 07:45:00 | AAPL | Stock | 148.16 | 148.23 | 148.16 | 148.23 | 3580.0 |
| 2021-11-12 07:50:00 | AAPL | Stock | 148.24 | 148.25 | 148.19 | 148.2 | 10693.0 |
| 2021-11-12 07:55:00 | AAPL | Stock | 148.18 | 148.2 | 148.17 | 148.18 | 2586.0 |
| 2021-11-12 08:00:00 | AAPL | Stock | 148.16 | 148.3 | 147.501 | 148.1501 | 49988.0 |
| 2021-11-12 08:05:00 | AAPL | Stock | 148.17 | 148.23 | 148.15 | 148.201 | 7958.0 |
| 2021-11-12 08:10:00 | AAPL | Stock | 148.2 | 148.29 | 148.2 | 148.23 | 2770.0 |
| 2021-11-12 08:15:00 | AAPL | Stock | 148.26 | 148.29 | 148.23 | 148.26 | 14239.0 |
| 2021-11-12 08:20:00 | AAPL | Stock | 148.26 | 148.26 | 148.22 | 148.23 | 8815.0 |
| 2021-11-12 08:25:00 | AAPL | Stock | 148.24 | 148.35 | 148.23 | 148.34 | 24610.0 |
| 2021-11-12 08:30:00 | AAPL | Stock | 148.34 | 148.34 | 148.3 | 148.34 | 10415.0 |
| 2021-11-12 08:35:00 | AAPL | Stock | 148.34 | 148.37 | 148.3 | 148.34 | 8535.0 |
| 2021-11-12 08:40:00 | AAPL | Stock | 148.35 | 148.38 | 148.33 | 148.38 | 8256.0 |
| 2021-11-12 08:45:00 | AAPL | Stock | 148.38 | 148.39 | 148.36 | 148.38 | 12980.0 |
| 2021-11-12 08:50:00 | AAPL | Stock | 148.38 | 148.38 | 148.35 | 148.36 | 9256.0 |
| 2021-11-12 08:55:00 | AAPL | Stock | 148.36 | 148.38 | 148.34 | 148.35 | 14743.0 |
| 2021-11-12 09:00:00 | AAPL | Stock | 148.36 | 148.45 | 148.36 | 148.45 | 32672.0 |
> showing 50 of 460,805 rows — these rows as CSV