PREVIEW / stock_5min / 2022-02-02
file: by_date/stock_5min/2022/2022-02-02.parquet size: 7.3 MB rows: 457,250 symbols: 2,561
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 |
|---|---|---|---|---|---|---|---|
| 2022-02-02 04:00:00 | AAPL | Stock | 174.19 | 174.6 | 174.11 | 174.6 | 6785.0 |
| 2022-02-02 04:05:00 | AAPL | Stock | 174.75 | 174.84 | 174.71 | 174.8 | 2812.0 |
| 2022-02-02 04:10:00 | AAPL | Stock | 174.75 | 174.95 | 174.69 | 174.94 | 4981.0 |
| 2022-02-02 04:15:00 | AAPL | Stock | 174.89 | 174.94 | 174.73 | 174.86 | 4332.0 |
| 2022-02-02 04:20:00 | AAPL | Stock | 174.86 | 174.9 | 174.84 | 174.84 | 1403.0 |
| 2022-02-02 04:25:00 | AAPL | Stock | 174.85 | 174.85 | 174.55 | 174.62 | 1807.0 |
| 2022-02-02 04:30:00 | AAPL | Stock | 174.71 | 174.85 | 174.67 | 174.67 | 3507.0 |
| 2022-02-02 04:35:00 | AAPL | Stock | 174.73 | 174.9 | 174.73 | 174.87 | 2449.0 |
| 2022-02-02 04:40:00 | AAPL | Stock | 174.83 | 175.0 | 174.83 | 174.99 | 4810.0 |
| 2022-02-02 04:45:00 | AAPL | Stock | 174.95 | 175.09 | 174.95 | 175.09 | 3380.0 |
| 2022-02-02 04:50:00 | AAPL | Stock | 175.22 | 175.23 | 175.11 | 175.2 | 3534.0 |
| 2022-02-02 04:55:00 | AAPL | Stock | 175.19 | 175.32 | 175.18 | 175.32 | 2194.0 |
| 2022-02-02 05:00:00 | AAPL | Stock | 175.31 | 175.31 | 175.09 | 175.09 | 2122.0 |
| 2022-02-02 05:05:00 | AAPL | Stock | 175.1 | 175.1 | 174.88 | 174.88 | 4334.0 |
| 2022-02-02 05:10:00 | AAPL | Stock | 174.85 | 174.86 | 174.85 | 174.86 | 356.0 |
| 2022-02-02 05:15:00 | AAPL | Stock | 174.9 | 174.92 | 174.9 | 174.9 | 1551.0 |
| 2022-02-02 05:20:00 | AAPL | Stock | 174.86 | 174.86 | 174.81 | 174.81 | 565.0 |
| 2022-02-02 05:25:00 | AAPL | Stock | 174.8 | 174.83 | 174.8 | 174.83 | 291.0 |
| 2022-02-02 05:30:00 | AAPL | Stock | 174.84 | 174.84 | 174.84 | 174.84 | 100.0 |
| 2022-02-02 05:35:00 | AAPL | Stock | 174.9 | 174.9 | 174.83 | 174.83 | 394.0 |
| 2022-02-02 05:40:00 | AAPL | Stock | 174.83 | 174.83 | 174.83 | 174.83 | 115.0 |
| 2022-02-02 05:45:00 | AAPL | Stock | 174.83 | 174.83 | 174.7 | 174.7 | 1259.0 |
| 2022-02-02 05:50:00 | AAPL | Stock | 174.64 | 174.67 | 174.61 | 174.64 | 1729.0 |
| 2022-02-02 05:55:00 | AAPL | Stock | 174.68 | 174.71 | 174.68 | 174.71 | 300.0 |
| 2022-02-02 06:00:00 | AAPL | Stock | 174.66 | 174.66 | 174.66 | 174.66 | 940.0 |
| 2022-02-02 06:05:00 | AAPL | Stock | 174.6 | 174.61 | 174.41 | 174.41 | 2579.0 |
| 2022-02-02 06:10:00 | AAPL | Stock | 174.47 | 174.5 | 174.47 | 174.5 | 538.0 |
| 2022-02-02 06:15:00 | AAPL | Stock | 174.49 | 174.49 | 174.45 | 174.45 | 2577.0 |
| 2022-02-02 06:20:00 | AAPL | Stock | 174.45 | 174.59 | 174.45 | 174.59 | 1524.0 |
| 2022-02-02 06:25:00 | AAPL | Stock | 174.59 | 174.59 | 174.59 | 174.59 | 100.0 |
| 2022-02-02 06:30:00 | AAPL | Stock | 174.61 | 174.66 | 174.61 | 174.65 | 1066.0 |
| 2022-02-02 06:35:00 | AAPL | Stock | 174.65 | 174.84 | 174.65 | 174.78 | 2417.0 |
| 2022-02-02 06:40:00 | AAPL | Stock | 174.87 | 174.94 | 174.79 | 174.79 | 2758.0 |
| 2022-02-02 06:45:00 | AAPL | Stock | 174.84 | 174.93 | 174.83 | 174.93 | 454.0 |
| 2022-02-02 06:50:00 | AAPL | Stock | 174.94 | 175.1 | 174.94 | 175.1 | 4631.0 |
| 2022-02-02 06:55:00 | AAPL | Stock | 175.09 | 175.1 | 174.94 | 174.94 | 3224.0 |
| 2022-02-02 07:00:00 | AAPL | Stock | 174.96 | 175.02 | 174.8 | 174.87 | 5414.0 |
| 2022-02-02 07:05:00 | AAPL | Stock | 174.88 | 174.94 | 174.86 | 174.9 | 4916.0 |
| 2022-02-02 07:10:00 | AAPL | Stock | 174.9 | 175.03 | 174.9 | 174.99 | 13120.0 |
| 2022-02-02 07:15:00 | AAPL | Stock | 175.0 | 175.2 | 175.0 | 175.15 | 16621.0 |
| 2022-02-02 07:20:00 | AAPL | Stock | 175.15 | 175.2 | 175.11 | 175.2 | 12056.0 |
| 2022-02-02 07:25:00 | AAPL | Stock | 175.19 | 175.23 | 175.1 | 175.11 | 15809.0 |
| 2022-02-02 07:30:00 | AAPL | Stock | 175.11 | 175.19 | 175.03 | 175.08 | 6180.0 |
| 2022-02-02 07:35:00 | AAPL | Stock | 175.05 | 175.05 | 174.86 | 174.86 | 20699.0 |
| 2022-02-02 07:40:00 | AAPL | Stock | 174.86 | 175.06 | 174.75 | 175.05 | 27959.0 |
| 2022-02-02 07:45:00 | AAPL | Stock | 175.05 | 175.13 | 174.93 | 175.05 | 25932.0 |
| 2022-02-02 07:50:00 | AAPL | Stock | 175.05 | 175.15 | 175.0 | 175.06 | 12609.0 |
| 2022-02-02 07:55:00 | AAPL | Stock | 175.06 | 175.17 | 175.06 | 175.11 | 11647.0 |
| 2022-02-02 08:00:00 | AAPL | Stock | 174.9033 | 175.24 | 174.79 | 174.99 | 216229.0 |
| 2022-02-02 08:05:00 | AAPL | Stock | 175.0 | 175.02 | 174.94 | 174.97 | 12071.0 |
> showing 50 of 457,250 rows — these rows as CSV