PREVIEW / stock_5min / 2021-12-31
file: by_date/stock_5min/2021/2021-12-31.parquet size: 7.4 MB rows: 449,336 symbols: 2,649
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-12-31 04:00:00 | AAPL | Stock | 177.98 | 178.0 | 177.98 | 178.0 | 587.0 |
| 2021-12-31 04:05:00 | AAPL | Stock | 178.12 | 178.13 | 178.12 | 178.13 | 440.0 |
| 2021-12-31 04:10:00 | AAPL | Stock | 178.13 | 178.13 | 178.01 | 178.01 | 706.0 |
| 2021-12-31 04:15:00 | AAPL | Stock | 178.0 | 178.0 | 178.0 | 178.0 | 490.0 |
| 2021-12-31 04:20:00 | AAPL | Stock | 177.76 | 177.85 | 177.76 | 177.82 | 486.0 |
| 2021-12-31 04:25:00 | AAPL | Stock | 177.83 | 177.85 | 177.83 | 177.85 | 441.0 |
| 2021-12-31 04:35:00 | AAPL | Stock | 177.97 | 177.97 | 177.96 | 177.96 | 300.0 |
| 2021-12-31 04:40:00 | AAPL | Stock | 177.88 | 177.9 | 177.88 | 177.9 | 400.0 |
| 2021-12-31 04:50:00 | AAPL | Stock | 177.9 | 177.9 | 177.9 | 177.9 | 100.0 |
| 2021-12-31 05:45:00 | AAPL | Stock | 177.91 | 177.91 | 177.89 | 177.89 | 457.0 |
| 2021-12-31 05:50:00 | AAPL | Stock | 177.87 | 177.87 | 177.87 | 177.87 | 100.0 |
| 2021-12-31 05:55:00 | AAPL | Stock | 177.8 | 177.8 | 177.8 | 177.8 | 229.0 |
| 2021-12-31 06:05:00 | AAPL | Stock | 177.8 | 177.8 | 177.8 | 177.8 | 254.0 |
| 2021-12-31 06:40:00 | AAPL | Stock | 177.98 | 177.99 | 177.98 | 177.99 | 408.0 |
| 2021-12-31 06:45:00 | AAPL | Stock | 177.94 | 177.94 | 177.92 | 177.92 | 878.0 |
| 2021-12-31 06:55:00 | AAPL | Stock | 177.83 | 177.83 | 177.83 | 177.83 | 693.0 |
| 2021-12-31 07:00:00 | AAPL | Stock | 177.75 | 177.79 | 177.75 | 177.79 | 413.0 |
| 2021-12-31 07:05:00 | AAPL | Stock | 177.8 | 177.8 | 177.72 | 177.72 | 893.0 |
| 2021-12-31 07:10:00 | AAPL | Stock | 177.71 | 177.8 | 177.71 | 177.75 | 1315.0 |
| 2021-12-31 07:15:00 | AAPL | Stock | 177.8 | 177.83 | 177.79 | 177.83 | 1045.0 |
| 2021-12-31 07:25:00 | AAPL | Stock | 177.89 | 177.9 | 177.89 | 177.9 | 750.0 |
| 2021-12-31 07:30:00 | AAPL | Stock | 177.9 | 177.93 | 177.87 | 177.93 | 2015.0 |
| 2021-12-31 07:35:00 | AAPL | Stock | 177.93 | 178.02 | 177.93 | 178.02 | 2068.0 |
| 2021-12-31 07:40:00 | AAPL | Stock | 178.0 | 178.09 | 177.98 | 178.09 | 6061.0 |
| 2021-12-31 07:45:00 | AAPL | Stock | 178.1 | 178.24 | 178.09 | 178.14 | 9637.0 |
| 2021-12-31 07:50:00 | AAPL | Stock | 178.14 | 178.15 | 178.09 | 178.15 | 700.0 |
| 2021-12-31 07:55:00 | AAPL | Stock | 178.1 | 178.13 | 178.03 | 178.03 | 5426.0 |
| 2021-12-31 08:00:00 | AAPL | Stock | 177.8902 | 178.25 | 177.72 | 178.0 | 47240.0 |
| 2021-12-31 08:05:00 | AAPL | Stock | 178.0003 | 178.06 | 178.0 | 178.0022 | 2329.0 |
| 2021-12-31 08:10:00 | AAPL | Stock | 178.05 | 178.16 | 178.05 | 178.13 | 2578.0 |
| 2021-12-31 08:15:00 | AAPL | Stock | 178.13 | 178.17 | 178.11 | 178.11 | 5656.0 |
| 2021-12-31 08:20:00 | AAPL | Stock | 178.1 | 178.15 | 178.02 | 178.08 | 4598.0 |
| 2021-12-31 08:25:00 | AAPL | Stock | 178.08 | 178.26 | 178.08 | 178.14 | 24753.0 |
| 2021-12-31 08:30:00 | AAPL | Stock | 178.14 | 178.18 | 178.12 | 178.15 | 9677.0 |
| 2021-12-31 08:35:00 | AAPL | Stock | 178.13 | 178.35 | 178.13 | 178.26 | 25984.0 |
| 2021-12-31 08:40:00 | AAPL | Stock | 178.26 | 178.28 | 178.2 | 178.28 | 7469.0 |
| 2021-12-31 08:45:00 | AAPL | Stock | 178.33 | 178.35 | 178.28 | 178.31 | 7442.0 |
| 2021-12-31 08:50:00 | AAPL | Stock | 178.29 | 178.32 | 178.18 | 178.31 | 19312.0 |
| 2021-12-31 08:55:00 | AAPL | Stock | 178.31 | 178.31 | 178.21 | 178.26 | 5082.0 |
| 2021-12-31 09:00:00 | AAPL | Stock | 178.26 | 178.35 | 178.26 | 178.27 | 4780.0 |
| 2021-12-31 09:05:00 | AAPL | Stock | 178.3 | 178.36 | 178.3 | 178.35 | 2327.0 |
| 2021-12-31 09:10:00 | AAPL | Stock | 178.35 | 178.3501 | 178.25 | 178.25 | 8718.0 |
| 2021-12-31 09:15:00 | AAPL | Stock | 178.26 | 178.28 | 178.02 | 178.03 | 7842.0 |
| 2021-12-31 09:20:00 | AAPL | Stock | 178.06 | 178.24 | 178.06 | 178.1799 | 7540.0 |
| 2021-12-31 09:25:00 | AAPL | Stock | 178.16 | 178.16 | 177.96 | 178.13 | 21742.0 |
| 2021-12-31 09:30:00 | AAPL | Stock | 178.12 | 179.23 | 177.72 | 178.5601 | 2036501.0 |
| 2021-12-31 09:35:00 | AAPL | Stock | 178.56 | 178.66 | 178.05 | 178.13 | 859055.0 |
| 2021-12-31 09:40:00 | AAPL | Stock | 178.14 | 178.6791 | 178.13 | 178.425 | 959729.0 |
| 2021-12-31 09:45:00 | AAPL | Stock | 178.44 | 178.58 | 177.84 | 178.1 | 763754.0 |
| 2021-12-31 09:50:00 | AAPL | Stock | 178.1 | 178.22 | 177.81 | 178.0974 | 557955.0 |
> showing 50 of 449,336 rows — these rows as CSV