PREVIEW / stock_5min / 2021-08-13
file: by_date/stock_5min/2021/2021-08-13.parquet size: 7.2 MB rows: 441,144 symbols: 2,802
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-08-13 04:00:00 | AAPL | Stock | 148.99 | 149.24 | 148.88 | 149.24 | 5043.0 |
| 2021-08-13 04:05:00 | AAPL | Stock | 149.15 | 149.2 | 149.14 | 149.18 | 1903.0 |
| 2021-08-13 04:10:00 | AAPL | Stock | 149.15 | 149.2 | 149.15 | 149.2 | 3363.0 |
| 2021-08-13 04:15:00 | AAPL | Stock | 149.23 | 149.24 | 149.2 | 149.2 | 3892.0 |
| 2021-08-13 04:20:00 | AAPL | Stock | 149.24 | 149.24 | 149.24 | 149.24 | 935.0 |
| 2021-08-13 04:25:00 | AAPL | Stock | 149.21 | 149.25 | 149.2 | 149.24 | 5811.0 |
| 2021-08-13 04:30:00 | AAPL | Stock | 149.2 | 149.2 | 149.2 | 149.2 | 710.0 |
| 2021-08-13 04:40:00 | AAPL | Stock | 149.23 | 149.23 | 149.2 | 149.2 | 761.0 |
| 2021-08-13 04:45:00 | AAPL | Stock | 149.23 | 149.23 | 149.21 | 149.21 | 1298.0 |
| 2021-08-13 05:00:00 | AAPL | Stock | 149.17 | 149.17 | 149.17 | 149.17 | 100.0 |
| 2021-08-13 05:05:00 | AAPL | Stock | 149.13 | 149.13 | 149.13 | 149.13 | 100.0 |
| 2021-08-13 05:10:00 | AAPL | Stock | 149.13 | 149.17 | 149.13 | 149.16 | 769.0 |
| 2021-08-13 05:15:00 | AAPL | Stock | 149.15 | 149.17 | 149.15 | 149.15 | 675.0 |
| 2021-08-13 05:20:00 | AAPL | Stock | 149.09 | 149.17 | 149.09 | 149.17 | 421.0 |
| 2021-08-13 05:40:00 | AAPL | Stock | 149.13 | 149.13 | 149.13 | 149.13 | 226.0 |
| 2021-08-13 05:55:00 | AAPL | Stock | 149.13 | 149.13 | 149.13 | 149.13 | 144.0 |
| 2021-08-13 06:00:00 | AAPL | Stock | 149.13 | 149.13 | 149.13 | 149.13 | 1615.0 |
| 2021-08-13 06:10:00 | AAPL | Stock | 149.12 | 149.12 | 149.12 | 149.12 | 122.0 |
| 2021-08-13 06:15:00 | AAPL | Stock | 149.09 | 149.09 | 149.09 | 149.09 | 113.0 |
| 2021-08-13 06:20:00 | AAPL | Stock | 149.09 | 149.09 | 149.09 | 149.09 | 598.0 |
| 2021-08-13 06:25:00 | AAPL | Stock | 149.11 | 149.11 | 149.11 | 149.11 | 229.0 |
| 2021-08-13 06:35:00 | AAPL | Stock | 149.11 | 149.11 | 149.11 | 149.11 | 470.0 |
| 2021-08-13 06:40:00 | AAPL | Stock | 149.11 | 149.22 | 149.05 | 149.05 | 7772.0 |
| 2021-08-13 06:50:00 | AAPL | Stock | 149.09 | 149.09 | 149.0 | 149.08 | 5862.0 |
| 2021-08-13 06:55:00 | AAPL | Stock | 149.11 | 149.18 | 149.05 | 149.05 | 999.0 |
| 2021-08-13 07:00:00 | AAPL | Stock | 149.1 | 149.24 | 149.08 | 149.21 | 54634.0 |
| 2021-08-13 07:05:00 | AAPL | Stock | 149.22 | 149.22 | 149.1 | 149.21 | 16669.0 |
| 2021-08-13 07:10:00 | AAPL | Stock | 149.17 | 149.21 | 149.0 | 149.07 | 38574.0 |
| 2021-08-13 07:15:00 | AAPL | Stock | 149.1 | 149.15 | 149.0 | 149.09 | 21329.0 |
| 2021-08-13 07:20:00 | AAPL | Stock | 149.06 | 149.06 | 148.89 | 148.99 | 12304.0 |
| 2021-08-13 07:25:00 | AAPL | Stock | 149.04 | 149.15 | 149.04 | 149.15 | 4006.0 |
| 2021-08-13 07:30:00 | AAPL | Stock | 149.16 | 149.16 | 148.98 | 148.99 | 9502.0 |
| 2021-08-13 07:35:00 | AAPL | Stock | 148.97 | 149.0 | 148.88 | 149.0 | 14216.0 |
| 2021-08-13 07:40:00 | AAPL | Stock | 148.97 | 149.01 | 148.85 | 148.89 | 5982.0 |
| 2021-08-13 07:45:00 | AAPL | Stock | 148.9 | 148.93 | 148.85 | 148.86 | 3440.0 |
| 2021-08-13 07:50:00 | AAPL | Stock | 148.85 | 148.93 | 148.78 | 148.89 | 12648.0 |
| 2021-08-13 07:55:00 | AAPL | Stock | 148.85 | 148.85 | 148.67 | 148.67 | 6672.0 |
| 2021-08-13 08:00:00 | AAPL | Stock | 149.0501 | 149.22 | 148.518 | 148.8 | 67850.0 |
| 2021-08-13 08:05:00 | AAPL | Stock | 148.84 | 148.88 | 148.67 | 148.71 | 13938.0 |
| 2021-08-13 08:10:00 | AAPL | Stock | 148.73 | 148.87 | 148.63 | 148.87 | 13769.0 |
| 2021-08-13 08:15:00 | AAPL | Stock | 148.86 | 148.87 | 148.75 | 148.84 | 8598.0 |
| 2021-08-13 08:20:00 | AAPL | Stock | 148.85 | 148.95 | 148.8 | 148.86 | 9315.0 |
| 2021-08-13 08:25:00 | AAPL | Stock | 148.93 | 149.02 | 148.93 | 148.93 | 15105.0 |
| 2021-08-13 08:30:00 | AAPL | Stock | 148.86 | 149.02 | 148.86 | 149.0 | 10837.0 |
| 2021-08-13 08:35:00 | AAPL | Stock | 149.0 | 149.02 | 148.94 | 148.96 | 7556.0 |
| 2021-08-13 08:40:00 | AAPL | Stock | 148.97 | 148.97 | 148.88 | 148.91 | 15307.0 |
| 2021-08-13 08:45:00 | AAPL | Stock | 148.91 | 148.93 | 148.88 | 148.93 | 4739.0 |
| 2021-08-13 08:50:00 | AAPL | Stock | 148.92 | 148.95 | 148.9 | 148.95 | 5456.0 |
| 2021-08-13 08:55:00 | AAPL | Stock | 148.95 | 148.97 | 148.9 | 148.97 | 7511.0 |
| 2021-08-13 09:00:00 | AAPL | Stock | 148.98 | 149.05 | 148.98 | 149.0 | 26835.0 |
> showing 50 of 441,144 rows — these rows as CSV