PREVIEW / stock_5min / 2021-11-10
file: by_date/stock_5min/2021/2021-11-10.parquet size: 7.7 MB rows: 475,144 symbols: 2,708
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-10 04:00:00 | AAPL | Stock | 150.72 | 150.72 | 150.28 | 150.3 | 1638.0 |
| 2021-11-10 04:10:00 | AAPL | Stock | 150.4 | 150.4 | 150.4 | 150.4 | 119.0 |
| 2021-11-10 04:15:00 | AAPL | Stock | 150.32 | 150.32 | 150.3 | 150.3 | 800.0 |
| 2021-11-10 04:20:00 | AAPL | Stock | 150.31 | 150.36 | 150.3 | 150.3 | 2287.0 |
| 2021-11-10 04:30:00 | AAPL | Stock | 150.28 | 150.3 | 150.16 | 150.21 | 1354.0 |
| 2021-11-10 04:35:00 | AAPL | Stock | 150.21 | 150.21 | 150.16 | 150.17 | 1013.0 |
| 2021-11-10 04:55:00 | AAPL | Stock | 150.29 | 150.29 | 150.29 | 150.29 | 404.0 |
| 2021-11-10 05:00:00 | AAPL | Stock | 150.18 | 150.18 | 150.05 | 150.05 | 1016.0 |
| 2021-11-10 05:10:00 | AAPL | Stock | 150.15 | 150.15 | 150.14 | 150.14 | 473.0 |
| 2021-11-10 05:20:00 | AAPL | Stock | 150.12 | 150.16 | 150.12 | 150.16 | 1104.0 |
| 2021-11-10 05:25:00 | AAPL | Stock | 150.15 | 150.15 | 150.15 | 150.15 | 500.0 |
| 2021-11-10 05:30:00 | AAPL | Stock | 150.15 | 150.15 | 150.15 | 150.15 | 447.0 |
| 2021-11-10 05:35:00 | AAPL | Stock | 150.1 | 150.12 | 150.07 | 150.07 | 1320.0 |
| 2021-11-10 05:40:00 | AAPL | Stock | 150.07 | 150.16 | 150.05 | 150.16 | 2443.0 |
| 2021-11-10 05:45:00 | AAPL | Stock | 150.11 | 150.11 | 150.11 | 150.11 | 135.0 |
| 2021-11-10 05:50:00 | AAPL | Stock | 150.05 | 150.05 | 149.92 | 150.0 | 998.0 |
| 2021-11-10 05:55:00 | AAPL | Stock | 150.08 | 150.08 | 150.04 | 150.04 | 1140.0 |
| 2021-11-10 06:00:00 | AAPL | Stock | 150.13 | 150.19 | 150.1 | 150.19 | 2010.0 |
| 2021-11-10 06:10:00 | AAPL | Stock | 150.06 | 150.06 | 150.06 | 150.06 | 848.0 |
| 2021-11-10 06:15:00 | AAPL | Stock | 150.01 | 150.01 | 149.94 | 149.94 | 948.0 |
| 2021-11-10 06:20:00 | AAPL | Stock | 149.94 | 150.0 | 149.94 | 150.0 | 611.0 |
| 2021-11-10 06:30:00 | AAPL | Stock | 149.95 | 149.95 | 149.95 | 149.95 | 140.0 |
| 2021-11-10 06:35:00 | AAPL | Stock | 149.97 | 150.0 | 149.92 | 149.95 | 6150.0 |
| 2021-11-10 06:40:00 | AAPL | Stock | 149.92 | 149.94 | 149.83 | 149.94 | 2353.0 |
| 2021-11-10 06:45:00 | AAPL | Stock | 149.94 | 149.94 | 149.94 | 149.94 | 100.0 |
| 2021-11-10 06:55:00 | AAPL | Stock | 149.95 | 149.95 | 149.94 | 149.94 | 465.0 |
| 2021-11-10 07:00:00 | AAPL | Stock | 149.95 | 150.19 | 149.94 | 150.15 | 11072.0 |
| 2021-11-10 07:05:00 | AAPL | Stock | 150.15 | 150.2 | 150.1 | 150.2 | 4200.0 |
| 2021-11-10 07:10:00 | AAPL | Stock | 150.2 | 150.31 | 150.2 | 150.31 | 4591.0 |
| 2021-11-10 07:15:00 | AAPL | Stock | 150.29 | 150.3 | 150.21 | 150.21 | 2605.0 |
| 2021-11-10 07:20:00 | AAPL | Stock | 150.23 | 150.28 | 150.13 | 150.28 | 8768.0 |
| 2021-11-10 07:25:00 | AAPL | Stock | 150.26 | 150.35 | 150.18 | 150.27 | 6352.0 |
| 2021-11-10 07:30:00 | AAPL | Stock | 150.2 | 150.27 | 150.08 | 150.24 | 15436.0 |
| 2021-11-10 07:35:00 | AAPL | Stock | 150.24 | 150.37 | 150.24 | 150.33 | 12620.0 |
| 2021-11-10 07:40:00 | AAPL | Stock | 150.34 | 150.36 | 150.31 | 150.33 | 4808.0 |
| 2021-11-10 07:45:00 | AAPL | Stock | 150.31 | 150.33 | 150.28 | 150.32 | 4240.0 |
| 2021-11-10 07:50:00 | AAPL | Stock | 150.3 | 150.32 | 150.28 | 150.28 | 5203.0 |
| 2021-11-10 07:55:00 | AAPL | Stock | 150.28 | 150.28 | 150.25 | 150.28 | 4599.0 |
| 2021-11-10 08:00:00 | AAPL | Stock | 150.29 | 150.433 | 150.0 | 150.35 | 130193.0 |
| 2021-11-10 08:05:00 | AAPL | Stock | 150.35 | 150.45 | 150.3122 | 150.45 | 12402.0 |
| 2021-11-10 08:10:00 | AAPL | Stock | 150.44 | 150.4799 | 150.36 | 150.4 | 37504.0 |
| 2021-11-10 08:15:00 | AAPL | Stock | 150.3899 | 150.43 | 150.3899 | 150.429 | 15397.0 |
| 2021-11-10 08:20:00 | AAPL | Stock | 150.401 | 150.42 | 150.36 | 150.41 | 11555.0 |
| 2021-11-10 08:25:00 | AAPL | Stock | 150.43 | 150.5 | 150.35 | 150.35 | 7297.0 |
| 2021-11-10 08:30:00 | AAPL | Stock | 150.3 | 150.31 | 150.0 | 150.15 | 109334.0 |
| 2021-11-10 08:35:00 | AAPL | Stock | 150.15 | 150.15 | 149.96 | 149.96 | 55764.0 |
| 2021-11-10 08:40:00 | AAPL | Stock | 149.99 | 150.22 | 149.99 | 150.1 | 56307.0 |
| 2021-11-10 08:45:00 | AAPL | Stock | 150.12 | 150.13 | 150.01 | 150.08 | 36180.0 |
| 2021-11-10 08:50:00 | AAPL | Stock | 150.04 | 150.29 | 150.04 | 150.24 | 41510.0 |
| 2021-11-10 08:55:00 | AAPL | Stock | 150.25 | 150.27 | 150.2 | 150.21 | 15073.0 |
> showing 50 of 475,144 rows — these rows as CSV