PREVIEW / stock_5min / 2021-11-09
file: by_date/stock_5min/2021/2021-11-09.parquet size: 7.6 MB rows: 469,907 symbols: 2,682
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-09 04:00:00 | AAPL | Stock | 150.03 | 150.2 | 150.01 | 150.09 | 2904.0 |
| 2021-11-09 04:05:00 | AAPL | Stock | 150.32 | 150.33 | 150.17 | 150.33 | 486.0 |
| 2021-11-09 04:10:00 | AAPL | Stock | 150.3 | 150.3 | 150.21 | 150.24 | 716.0 |
| 2021-11-09 04:15:00 | AAPL | Stock | 150.2 | 150.23 | 150.11 | 150.23 | 1460.0 |
| 2021-11-09 04:20:00 | AAPL | Stock | 150.16 | 150.16 | 150.16 | 150.16 | 279.0 |
| 2021-11-09 04:30:00 | AAPL | Stock | 150.22 | 150.22 | 150.2 | 150.2 | 580.0 |
| 2021-11-09 04:40:00 | AAPL | Stock | 150.21 | 150.21 | 150.15 | 150.15 | 752.0 |
| 2021-11-09 04:45:00 | AAPL | Stock | 150.27 | 150.28 | 150.1 | 150.15 | 4515.0 |
| 2021-11-09 04:50:00 | AAPL | Stock | 150.17 | 150.19 | 150.17 | 150.19 | 1308.0 |
| 2021-11-09 04:55:00 | AAPL | Stock | 150.19 | 150.2 | 150.12 | 150.12 | 1227.0 |
| 2021-11-09 05:00:00 | AAPL | Stock | 150.13 | 150.13 | 150.13 | 150.13 | 1963.0 |
| 2021-11-09 05:05:00 | AAPL | Stock | 150.17 | 150.18 | 150.17 | 150.18 | 385.0 |
| 2021-11-09 05:10:00 | AAPL | Stock | 150.23 | 150.25 | 150.23 | 150.25 | 1159.0 |
| 2021-11-09 05:20:00 | AAPL | Stock | 150.28 | 150.28 | 150.28 | 150.28 | 100.0 |
| 2021-11-09 05:25:00 | AAPL | Stock | 150.22 | 150.23 | 150.12 | 150.12 | 2014.0 |
| 2021-11-09 05:30:00 | AAPL | Stock | 150.12 | 150.12 | 150.1 | 150.1 | 846.0 |
| 2021-11-09 05:35:00 | AAPL | Stock | 150.18 | 150.18 | 150.18 | 150.18 | 908.0 |
| 2021-11-09 05:45:00 | AAPL | Stock | 150.2 | 150.2 | 150.2 | 150.2 | 312.0 |
| 2021-11-09 05:55:00 | AAPL | Stock | 150.17 | 150.17 | 150.15 | 150.15 | 339.0 |
| 2021-11-09 06:10:00 | AAPL | Stock | 150.12 | 150.15 | 150.12 | 150.15 | 483.0 |
| 2021-11-09 06:15:00 | AAPL | Stock | 150.12 | 150.16 | 150.12 | 150.16 | 1197.0 |
| 2021-11-09 06:20:00 | AAPL | Stock | 150.14 | 150.14 | 150.03 | 150.04 | 2563.0 |
| 2021-11-09 06:25:00 | AAPL | Stock | 150.04 | 150.04 | 150.02 | 150.02 | 1184.0 |
| 2021-11-09 06:30:00 | AAPL | Stock | 150.04 | 150.04 | 150.0 | 150.03 | 1893.0 |
| 2021-11-09 06:35:00 | AAPL | Stock | 150.11 | 150.11 | 150.0 | 150.0 | 929.0 |
| 2021-11-09 06:40:00 | AAPL | Stock | 150.07 | 150.1 | 150.03 | 150.06 | 1742.0 |
| 2021-11-09 06:45:00 | AAPL | Stock | 150.07 | 150.07 | 150.07 | 150.07 | 114.0 |
| 2021-11-09 06:55:00 | AAPL | Stock | 150.06 | 150.06 | 150.0 | 150.03 | 2132.0 |
| 2021-11-09 07:00:00 | AAPL | Stock | 150.03 | 150.15 | 150.03 | 150.15 | 1710.0 |
| 2021-11-09 07:05:00 | AAPL | Stock | 150.15 | 150.23 | 150.14 | 150.23 | 2231.0 |
| 2021-11-09 07:10:00 | AAPL | Stock | 150.23 | 150.24 | 150.03 | 150.09 | 10173.0 |
| 2021-11-09 07:15:00 | AAPL | Stock | 150.08 | 150.1 | 150.01 | 150.1 | 11620.0 |
| 2021-11-09 07:20:00 | AAPL | Stock | 150.11 | 150.11 | 150.06 | 150.06 | 5158.0 |
| 2021-11-09 07:25:00 | AAPL | Stock | 150.07 | 150.08 | 150.06 | 150.06 | 1034.0 |
| 2021-11-09 07:30:00 | AAPL | Stock | 150.05 | 150.2 | 150.05 | 150.12 | 6289.0 |
| 2021-11-09 07:35:00 | AAPL | Stock | 150.13 | 150.13 | 150.05 | 150.07 | 9069.0 |
| 2021-11-09 07:40:00 | AAPL | Stock | 150.07 | 150.07 | 150.03 | 150.03 | 1680.0 |
| 2021-11-09 07:45:00 | AAPL | Stock | 150.03 | 150.03 | 149.84 | 149.95 | 30262.0 |
| 2021-11-09 07:50:00 | AAPL | Stock | 149.97 | 150.0 | 149.97 | 149.99 | 5829.0 |
| 2021-11-09 07:55:00 | AAPL | Stock | 149.96 | 149.99 | 149.95 | 149.95 | 1474.0 |
| 2021-11-09 08:00:00 | AAPL | Stock | 150.06 | 150.24 | 149.85 | 149.97 | 105954.0 |
| 2021-11-09 08:05:00 | AAPL | Stock | 149.97 | 150.05 | 149.97 | 150.04 | 11282.0 |
| 2021-11-09 08:10:00 | AAPL | Stock | 150.04 | 150.11 | 150.01 | 150.06 | 10232.0 |
| 2021-11-09 08:15:00 | AAPL | Stock | 150.06 | 150.09 | 150.06 | 150.07 | 3178.0 |
| 2021-11-09 08:20:00 | AAPL | Stock | 150.08 | 150.2 | 150.08 | 150.1799 | 14656.0 |
| 2021-11-09 08:25:00 | AAPL | Stock | 150.18 | 150.19 | 150.11 | 150.11 | 9338.0 |
| 2021-11-09 08:30:00 | AAPL | Stock | 150.15 | 150.2 | 150.11 | 150.16 | 24351.0 |
| 2021-11-09 08:35:00 | AAPL | Stock | 150.19 | 150.19 | 150.13 | 150.13 | 5674.0 |
| 2021-11-09 08:40:00 | AAPL | Stock | 150.13 | 150.29 | 150.13 | 150.28 | 28866.0 |
| 2021-11-09 08:45:00 | AAPL | Stock | 150.26 | 150.44 | 150.16 | 150.27 | 1618875.0 |
> showing 50 of 469,907 rows — these rows as CSV