PREVIEW / stock_5min / 2021-04-06
file: by_date/stock_5min/2021/2021-04-06.parquet size: 7.6 MB rows: 470,517 symbols: 2,954
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-04-06 04:00:00 | AAPL | Stock | 125.33 | 125.4 | 125.0 | 125.4 | 16244.0 |
| 2021-04-06 04:05:00 | AAPL | Stock | 125.3 | 125.39 | 125.3 | 125.31 | 1437.0 |
| 2021-04-06 04:10:00 | AAPL | Stock | 125.3 | 125.3 | 125.17 | 125.17 | 1115.0 |
| 2021-04-06 04:15:00 | AAPL | Stock | 125.26 | 125.29 | 125.22 | 125.29 | 547.0 |
| 2021-04-06 04:20:00 | AAPL | Stock | 125.26 | 125.31 | 125.23 | 125.3 | 2534.0 |
| 2021-04-06 04:25:00 | AAPL | Stock | 125.3 | 125.31 | 125.23 | 125.31 | 3242.0 |
| 2021-04-06 04:30:00 | AAPL | Stock | 125.27 | 125.38 | 125.27 | 125.35 | 720.0 |
| 2021-04-06 04:35:00 | AAPL | Stock | 125.4 | 125.4 | 125.37 | 125.37 | 700.0 |
| 2021-04-06 04:40:00 | AAPL | Stock | 125.5 | 125.57 | 125.4 | 125.5 | 4904.0 |
| 2021-04-06 04:45:00 | AAPL | Stock | 125.49 | 125.57 | 125.49 | 125.57 | 1942.0 |
| 2021-04-06 04:50:00 | AAPL | Stock | 125.62 | 125.68 | 125.58 | 125.58 | 902.0 |
| 2021-04-06 04:55:00 | AAPL | Stock | 125.56 | 125.56 | 125.5 | 125.5 | 818.0 |
| 2021-04-06 05:00:00 | AAPL | Stock | 125.5 | 125.51 | 125.46 | 125.5 | 2229.0 |
| 2021-04-06 05:05:00 | AAPL | Stock | 125.51 | 125.51 | 125.48 | 125.5 | 1497.0 |
| 2021-04-06 05:10:00 | AAPL | Stock | 125.52 | 125.52 | 125.5 | 125.5 | 687.0 |
| 2021-04-06 05:15:00 | AAPL | Stock | 125.54 | 125.54 | 125.5 | 125.5 | 1044.0 |
| 2021-04-06 05:20:00 | AAPL | Stock | 125.53 | 125.53 | 125.53 | 125.53 | 200.0 |
| 2021-04-06 05:25:00 | AAPL | Stock | 125.56 | 125.56 | 125.56 | 125.56 | 100.0 |
| 2021-04-06 05:30:00 | AAPL | Stock | 125.5 | 125.54 | 125.5 | 125.54 | 407.0 |
| 2021-04-06 05:35:00 | AAPL | Stock | 125.56 | 125.56 | 125.53 | 125.53 | 200.0 |
| 2021-04-06 05:40:00 | AAPL | Stock | 125.6 | 125.6 | 125.6 | 125.6 | 890.0 |
| 2021-04-06 05:45:00 | AAPL | Stock | 125.6 | 125.64 | 125.6 | 125.64 | 4034.0 |
| 2021-04-06 05:50:00 | AAPL | Stock | 125.61 | 125.61 | 125.61 | 125.61 | 436.0 |
| 2021-04-06 05:55:00 | AAPL | Stock | 125.52 | 125.53 | 125.46 | 125.53 | 438.0 |
| 2021-04-06 06:05:00 | AAPL | Stock | 125.61 | 125.61 | 125.61 | 125.61 | 284.0 |
| 2021-04-06 06:10:00 | AAPL | Stock | 125.61 | 125.61 | 125.61 | 125.61 | 100.0 |
| 2021-04-06 06:15:00 | AAPL | Stock | 125.6 | 125.6 | 125.57 | 125.57 | 648.0 |
| 2021-04-06 06:20:00 | AAPL | Stock | 125.58 | 125.58 | 125.51 | 125.57 | 1694.0 |
| 2021-04-06 06:25:00 | AAPL | Stock | 125.52 | 125.52 | 125.5 | 125.5 | 931.0 |
| 2021-04-06 06:30:00 | AAPL | Stock | 125.54 | 125.58 | 125.54 | 125.58 | 795.0 |
| 2021-04-06 06:35:00 | AAPL | Stock | 125.56 | 125.6 | 125.56 | 125.6 | 1382.0 |
| 2021-04-06 06:40:00 | AAPL | Stock | 125.62 | 125.62 | 125.62 | 125.62 | 194.0 |
| 2021-04-06 06:45:00 | AAPL | Stock | 125.62 | 125.64 | 125.62 | 125.64 | 1164.0 |
| 2021-04-06 06:50:00 | AAPL | Stock | 125.61 | 125.7 | 125.61 | 125.61 | 2701.0 |
| 2021-04-06 06:55:00 | AAPL | Stock | 125.54 | 125.63 | 125.54 | 125.63 | 600.0 |
| 2021-04-06 07:00:00 | AAPL | Stock | 125.64 | 125.98 | 125.61 | 125.9 | 39622.0 |
| 2021-04-06 07:05:00 | AAPL | Stock | 125.9 | 125.9 | 125.72 | 125.72 | 12428.0 |
| 2021-04-06 07:10:00 | AAPL | Stock | 125.73 | 125.84 | 125.72 | 125.75 | 9213.0 |
| 2021-04-06 07:15:00 | AAPL | Stock | 125.75 | 125.82 | 125.68 | 125.79 | 15362.0 |
| 2021-04-06 07:20:00 | AAPL | Stock | 125.79 | 125.79 | 125.7 | 125.7 | 7107.0 |
| 2021-04-06 07:25:00 | AAPL | Stock | 125.71 | 125.8 | 125.71 | 125.73 | 15204.0 |
| 2021-04-06 07:30:00 | AAPL | Stock | 125.72 | 125.78 | 125.71 | 125.78 | 8959.0 |
| 2021-04-06 07:35:00 | AAPL | Stock | 125.79 | 125.87 | 125.78 | 125.86 | 6939.0 |
| 2021-04-06 07:40:00 | AAPL | Stock | 125.85 | 126.03 | 125.85 | 126.03 | 9435.0 |
| 2021-04-06 07:45:00 | AAPL | Stock | 126.04 | 126.34 | 126.03 | 126.34 | 56296.0 |
| 2021-04-06 07:50:00 | AAPL | Stock | 126.3 | 126.3 | 126.12 | 126.19 | 31484.0 |
| 2021-04-06 07:55:00 | AAPL | Stock | 126.19 | 126.38 | 126.19 | 126.3 | 19386.0 |
| 2021-04-06 08:00:00 | AAPL | Stock | 125.9192 | 126.47 | 125.68 | 126.45 | 87316.0 |
| 2021-04-06 08:05:00 | AAPL | Stock | 126.45 | 126.61 | 126.36 | 126.59 | 90277.0 |
| 2021-04-06 08:10:00 | AAPL | Stock | 126.61 | 126.61 | 126.4 | 126.43 | 40755.0 |
> showing 50 of 470,517 rows — these rows as CSV