PREVIEW / stock_5min / 2020-12-04
file: by_date/stock_5min/2020/2020-12-04.parquet size: 7.3 MB rows: 447,921 symbols: 2,643
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 |
|---|---|---|---|---|---|---|---|
| 2020-12-04 04:00:00 | AAPL | Stock | 123.3 | 123.31 | 123.18 | 123.18 | 3550.0 |
| 2020-12-04 04:05:00 | AAPL | Stock | 123.18 | 123.18 | 123.18 | 123.18 | 2826.0 |
| 2020-12-04 04:10:00 | AAPL | Stock | 123.25 | 123.25 | 123.23 | 123.23 | 361.0 |
| 2020-12-04 04:15:00 | AAPL | Stock | 123.24 | 123.26 | 123.22 | 123.22 | 518.0 |
| 2020-12-04 04:20:00 | AAPL | Stock | 123.2 | 123.26 | 123.2 | 123.2 | 1413.0 |
| 2020-12-04 04:30:00 | AAPL | Stock | 123.2 | 123.2 | 123.2 | 123.2 | 100.0 |
| 2020-12-04 04:35:00 | AAPL | Stock | 123.18 | 123.18 | 123.18 | 123.18 | 100.0 |
| 2020-12-04 04:50:00 | AAPL | Stock | 123.15 | 123.24 | 123.15 | 123.24 | 700.0 |
| 2020-12-04 04:55:00 | AAPL | Stock | 123.2 | 123.2 | 123.2 | 123.2 | 100.0 |
| 2020-12-04 05:00:00 | AAPL | Stock | 123.23 | 123.23 | 123.18 | 123.18 | 6199.0 |
| 2020-12-04 05:05:00 | AAPL | Stock | 123.14 | 123.14 | 123.14 | 123.14 | 415.0 |
| 2020-12-04 05:10:00 | AAPL | Stock | 123.14 | 123.2 | 123.14 | 123.2 | 4183.0 |
| 2020-12-04 05:15:00 | AAPL | Stock | 123.2 | 123.2 | 123.2 | 123.2 | 1100.0 |
| 2020-12-04 05:30:00 | AAPL | Stock | 123.2 | 123.2 | 123.2 | 123.2 | 800.0 |
| 2020-12-04 05:35:00 | AAPL | Stock | 123.14 | 123.2 | 123.12 | 123.2 | 1181.0 |
| 2020-12-04 05:40:00 | AAPL | Stock | 123.2 | 123.2 | 123.2 | 123.2 | 100.0 |
| 2020-12-04 05:45:00 | AAPL | Stock | 123.17 | 123.17 | 123.17 | 123.17 | 500.0 |
| 2020-12-04 05:50:00 | AAPL | Stock | 123.2 | 123.2 | 123.2 | 123.2 | 126.0 |
| 2020-12-04 05:55:00 | AAPL | Stock | 123.17 | 123.18 | 123.17 | 123.18 | 330.0 |
| 2020-12-04 06:10:00 | AAPL | Stock | 123.2 | 123.2 | 123.2 | 123.2 | 900.0 |
| 2020-12-04 06:15:00 | AAPL | Stock | 123.2 | 123.2 | 123.16 | 123.16 | 600.0 |
| 2020-12-04 06:20:00 | AAPL | Stock | 123.2 | 123.2 | 123.18 | 123.18 | 717.0 |
| 2020-12-04 06:25:00 | AAPL | Stock | 123.2 | 123.28 | 123.2 | 123.28 | 1042.0 |
| 2020-12-04 06:30:00 | AAPL | Stock | 123.28 | 123.28 | 123.28 | 123.28 | 300.0 |
| 2020-12-04 06:35:00 | AAPL | Stock | 123.28 | 123.3 | 123.28 | 123.3 | 988.0 |
| 2020-12-04 06:45:00 | AAPL | Stock | 123.27 | 123.27 | 123.27 | 123.27 | 789.0 |
| 2020-12-04 06:50:00 | AAPL | Stock | 123.27 | 123.27 | 123.27 | 123.27 | 393.0 |
| 2020-12-04 07:00:00 | AAPL | Stock | 123.25 | 123.28 | 123.13 | 123.28 | 16665.0 |
| 2020-12-04 07:05:00 | AAPL | Stock | 123.26 | 123.28 | 123.21 | 123.25 | 5725.0 |
| 2020-12-04 07:10:00 | AAPL | Stock | 123.22 | 123.22 | 123.15 | 123.21 | 4631.0 |
| 2020-12-04 07:15:00 | AAPL | Stock | 123.21 | 123.22 | 123.21 | 123.22 | 641.0 |
| 2020-12-04 07:20:00 | AAPL | Stock | 123.23 | 123.24 | 123.21 | 123.21 | 4327.0 |
| 2020-12-04 07:25:00 | AAPL | Stock | 123.21 | 123.25 | 123.14 | 123.22 | 15257.0 |
| 2020-12-04 07:30:00 | AAPL | Stock | 123.22 | 123.25 | 123.13 | 123.17 | 18059.0 |
| 2020-12-04 07:35:00 | AAPL | Stock | 123.17 | 123.17 | 123.09 | 123.14 | 5057.0 |
| 2020-12-04 07:40:00 | AAPL | Stock | 123.1 | 123.1 | 123.0 | 123.03 | 9131.0 |
| 2020-12-04 07:45:00 | AAPL | Stock | 123.04 | 123.05 | 122.94 | 122.98 | 11578.0 |
| 2020-12-04 07:50:00 | AAPL | Stock | 122.98 | 122.99 | 122.93 | 122.96 | 4194.0 |
| 2020-12-04 07:55:00 | AAPL | Stock | 122.93 | 122.93 | 122.9 | 122.9 | 1507.0 |
| 2020-12-04 08:00:00 | AAPL | Stock | 123.268 | 123.28 | 122.896 | 122.98 | 74314.0 |
| 2020-12-04 08:05:00 | AAPL | Stock | 122.98 | 123.01 | 122.97 | 123.01 | 9435.0 |
| 2020-12-04 08:10:00 | AAPL | Stock | 123.04 | 123.12 | 123.0 | 123.1 | 21269.0 |
| 2020-12-04 08:15:00 | AAPL | Stock | 123.13 | 123.13 | 123.07 | 123.07 | 8219.0 |
| 2020-12-04 08:20:00 | AAPL | Stock | 123.08 | 123.08 | 122.97 | 123.04 | 9337.0 |
| 2020-12-04 08:25:00 | AAPL | Stock | 123.04 | 123.07 | 123.01 | 123.06 | 5027.0 |
| 2020-12-04 08:30:00 | AAPL | Stock | 123.05 | 123.24 | 122.85 | 123.15 | 47053.0 |
| 2020-12-04 08:35:00 | AAPL | Stock | 123.15 | 123.16 | 123.01 | 123.02 | 15674.0 |
| 2020-12-04 08:40:00 | AAPL | Stock | 123.04 | 123.05 | 123.0 | 123.04 | 9715.0 |
| 2020-12-04 08:45:00 | AAPL | Stock | 123.02 | 123.02 | 122.81 | 122.88 | 23850.0 |
| 2020-12-04 08:50:00 | AAPL | Stock | 122.87 | 122.96 | 122.72 | 122.72 | 25298.0 |
> showing 50 of 447,921 rows — these rows as CSV