PREVIEW / stock_5min / 2021-07-07
file: by_date/stock_5min/2021/2021-07-07.parquet size: 7.5 MB rows: 462,603 symbols: 2,869
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-07 04:00:00 | AAPL | Stock | 142.41 | 142.89 | 142.41 | 142.89 | 4053.0 |
| 2021-07-07 04:05:00 | AAPL | Stock | 142.8 | 143.1 | 142.8 | 143.09 | 14730.0 |
| 2021-07-07 04:10:00 | AAPL | Stock | 143.09 | 143.14 | 143.05 | 143.14 | 10828.0 |
| 2021-07-07 04:15:00 | AAPL | Stock | 143.15 | 143.15 | 143.05 | 143.05 | 15477.0 |
| 2021-07-07 04:20:00 | AAPL | Stock | 143.07 | 143.08 | 142.99 | 143.0 | 5077.0 |
| 2021-07-07 04:25:00 | AAPL | Stock | 142.97 | 142.97 | 142.84 | 142.84 | 3635.0 |
| 2021-07-07 04:30:00 | AAPL | Stock | 142.89 | 142.97 | 142.89 | 142.97 | 1782.0 |
| 2021-07-07 04:35:00 | AAPL | Stock | 142.95 | 142.95 | 142.8 | 142.89 | 1702.0 |
| 2021-07-07 04:40:00 | AAPL | Stock | 142.9 | 142.9 | 142.82 | 142.82 | 1561.0 |
| 2021-07-07 04:45:00 | AAPL | Stock | 142.89 | 142.93 | 142.85 | 142.85 | 2522.0 |
| 2021-07-07 04:50:00 | AAPL | Stock | 142.91 | 142.91 | 142.74 | 142.86 | 2703.0 |
| 2021-07-07 04:55:00 | AAPL | Stock | 142.67 | 142.67 | 142.66 | 142.66 | 220.0 |
| 2021-07-07 05:00:00 | AAPL | Stock | 142.7 | 142.72 | 142.7 | 142.72 | 300.0 |
| 2021-07-07 05:05:00 | AAPL | Stock | 142.8 | 142.83 | 142.8 | 142.83 | 408.0 |
| 2021-07-07 05:10:00 | AAPL | Stock | 142.8 | 142.85 | 142.8 | 142.85 | 846.0 |
| 2021-07-07 05:15:00 | AAPL | Stock | 142.81 | 142.81 | 142.8 | 142.8 | 443.0 |
| 2021-07-07 05:20:00 | AAPL | Stock | 142.8 | 142.87 | 142.8 | 142.87 | 848.0 |
| 2021-07-07 05:25:00 | AAPL | Stock | 142.87 | 142.88 | 142.87 | 142.88 | 2367.0 |
| 2021-07-07 05:35:00 | AAPL | Stock | 142.9 | 142.9 | 142.9 | 142.9 | 400.0 |
| 2021-07-07 05:40:00 | AAPL | Stock | 142.93 | 142.97 | 142.93 | 142.97 | 1398.0 |
| 2021-07-07 05:45:00 | AAPL | Stock | 142.98 | 143.04 | 142.98 | 143.04 | 3002.0 |
| 2021-07-07 05:50:00 | AAPL | Stock | 143.04 | 143.04 | 142.9 | 142.9 | 2745.0 |
| 2021-07-07 05:55:00 | AAPL | Stock | 142.9 | 142.9 | 142.84 | 142.85 | 580.0 |
| 2021-07-07 06:00:00 | AAPL | Stock | 142.85 | 142.88 | 142.8 | 142.8 | 956.0 |
| 2021-07-07 06:05:00 | AAPL | Stock | 142.73 | 142.78 | 142.73 | 142.78 | 842.0 |
| 2021-07-07 06:25:00 | AAPL | Stock | 142.88 | 142.88 | 142.85 | 142.85 | 557.0 |
| 2021-07-07 06:35:00 | AAPL | Stock | 142.9 | 142.9 | 142.78 | 142.9 | 1543.0 |
| 2021-07-07 06:40:00 | AAPL | Stock | 142.78 | 142.96 | 142.78 | 142.87 | 2733.0 |
| 2021-07-07 06:45:00 | AAPL | Stock | 142.89 | 142.96 | 142.88 | 142.96 | 1153.0 |
| 2021-07-07 06:50:00 | AAPL | Stock | 142.9 | 142.9 | 142.85 | 142.85 | 1309.0 |
| 2021-07-07 06:55:00 | AAPL | Stock | 142.8 | 142.81 | 142.8 | 142.81 | 2301.0 |
| 2021-07-07 07:00:00 | AAPL | Stock | 142.78 | 143.0 | 142.75 | 142.94 | 37522.0 |
| 2021-07-07 07:05:00 | AAPL | Stock | 142.94 | 143.17 | 142.94 | 143.17 | 38661.0 |
| 2021-07-07 07:10:00 | AAPL | Stock | 143.17 | 143.2 | 143.1 | 143.18 | 30205.0 |
| 2021-07-07 07:15:00 | AAPL | Stock | 143.17 | 143.21 | 143.15 | 143.19 | 23582.0 |
| 2021-07-07 07:20:00 | AAPL | Stock | 143.18 | 143.24 | 143.15 | 143.18 | 9965.0 |
| 2021-07-07 07:25:00 | AAPL | Stock | 143.18 | 143.23 | 143.17 | 143.23 | 4343.0 |
| 2021-07-07 07:30:00 | AAPL | Stock | 143.22 | 143.22 | 143.16 | 143.18 | 11440.0 |
| 2021-07-07 07:35:00 | AAPL | Stock | 143.19 | 143.22 | 143.14 | 143.18 | 8745.0 |
| 2021-07-07 07:40:00 | AAPL | Stock | 143.18 | 143.2 | 143.13 | 143.13 | 4922.0 |
| 2021-07-07 07:45:00 | AAPL | Stock | 143.12 | 143.12 | 143.03 | 143.03 | 22708.0 |
| 2021-07-07 07:50:00 | AAPL | Stock | 143.04 | 143.07 | 143.04 | 143.04 | 2763.0 |
| 2021-07-07 07:55:00 | AAPL | Stock | 143.05 | 143.21 | 143.05 | 143.2 | 18999.0 |
| 2021-07-07 08:00:00 | AAPL | Stock | 142.9 | 143.29 | 142.82 | 143.24 | 269983.0 |
| 2021-07-07 08:05:00 | AAPL | Stock | 143.24 | 143.25 | 143.15 | 143.21 | 30669.0 |
| 2021-07-07 08:10:00 | AAPL | Stock | 143.21 | 143.25 | 143.2 | 143.23 | 21036.0 |
| 2021-07-07 08:15:00 | AAPL | Stock | 143.23 | 143.25 | 143.15 | 143.18 | 33635.0 |
| 2021-07-07 08:20:00 | AAPL | Stock | 143.18 | 143.3 | 143.16 | 143.3 | 61721.0 |
| 2021-07-07 08:25:00 | AAPL | Stock | 143.3 | 143.3 | 143.22 | 143.22 | 11509.0 |
| 2021-07-07 08:30:00 | AAPL | Stock | 143.23 | 143.24 | 143.1 | 143.12 | 28669.0 |
> showing 50 of 462,603 rows — these rows as CSV