PREVIEW / stock_5min / 2022-01-31
file: by_date/stock_5min/2022/2022-01-31.parquet size: 7.5 MB rows: 460,252 symbols: 2,610
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-01-31 04:00:00 | AAPL | Stock | 170.7 | 172.01 | 170.7 | 172.0 | 17025.0 |
| 2022-01-31 04:05:00 | AAPL | Stock | 172.0 | 172.0 | 171.6 | 171.87 | 10141.0 |
| 2022-01-31 04:10:00 | AAPL | Stock | 171.8 | 171.91 | 171.77 | 171.87 | 5606.0 |
| 2022-01-31 04:15:00 | AAPL | Stock | 171.91 | 171.91 | 171.42 | 171.63 | 6804.0 |
| 2022-01-31 04:20:00 | AAPL | Stock | 171.69 | 171.75 | 171.47 | 171.72 | 6694.0 |
| 2022-01-31 04:25:00 | AAPL | Stock | 171.72 | 171.73 | 171.61 | 171.71 | 2010.0 |
| 2022-01-31 04:30:00 | AAPL | Stock | 171.68 | 171.68 | 171.68 | 171.68 | 292.0 |
| 2022-01-31 04:35:00 | AAPL | Stock | 171.7 | 171.91 | 171.7 | 171.73 | 4615.0 |
| 2022-01-31 04:40:00 | AAPL | Stock | 171.77 | 171.78 | 171.7 | 171.7 | 3348.0 |
| 2022-01-31 04:45:00 | AAPL | Stock | 171.75 | 171.77 | 171.75 | 171.77 | 2035.0 |
| 2022-01-31 04:50:00 | AAPL | Stock | 171.75 | 171.75 | 171.4 | 171.42 | 3389.0 |
| 2022-01-31 04:55:00 | AAPL | Stock | 171.4 | 171.55 | 171.32 | 171.55 | 992.0 |
| 2022-01-31 05:00:00 | AAPL | Stock | 171.5 | 171.56 | 171.48 | 171.56 | 520.0 |
| 2022-01-31 05:05:00 | AAPL | Stock | 171.56 | 171.57 | 171.2 | 171.37 | 2273.0 |
| 2022-01-31 05:10:00 | AAPL | Stock | 171.3 | 171.3 | 170.96 | 171.0 | 7593.0 |
| 2022-01-31 05:15:00 | AAPL | Stock | 171.0 | 171.0 | 170.83 | 170.87 | 7943.0 |
| 2022-01-31 05:20:00 | AAPL | Stock | 170.89 | 171.19 | 170.89 | 171.06 | 3324.0 |
| 2022-01-31 05:25:00 | AAPL | Stock | 171.1 | 171.2 | 171.04 | 171.04 | 1620.0 |
| 2022-01-31 05:30:00 | AAPL | Stock | 170.89 | 170.9 | 170.32 | 170.33 | 47417.0 |
| 2022-01-31 05:35:00 | AAPL | Stock | 170.33 | 170.33 | 170.09 | 170.15 | 12659.0 |
| 2022-01-31 05:40:00 | AAPL | Stock | 170.09 | 170.4 | 170.08 | 170.3 | 22957.0 |
| 2022-01-31 05:45:00 | AAPL | Stock | 170.3 | 170.5 | 170.26 | 170.3 | 26236.0 |
| 2022-01-31 05:50:00 | AAPL | Stock | 170.26 | 170.33 | 170.16 | 170.23 | 7876.0 |
| 2022-01-31 05:55:00 | AAPL | Stock | 170.23 | 170.33 | 170.21 | 170.33 | 32031.0 |
| 2022-01-31 06:00:00 | AAPL | Stock | 170.49 | 170.54 | 170.27 | 170.3 | 8285.0 |
| 2022-01-31 06:05:00 | AAPL | Stock | 170.32 | 170.36 | 170.32 | 170.36 | 416.0 |
| 2022-01-31 06:10:00 | AAPL | Stock | 170.41 | 170.41 | 170.21 | 170.25 | 4445.0 |
| 2022-01-31 06:15:00 | AAPL | Stock | 170.25 | 170.54 | 170.25 | 170.54 | 2111.0 |
| 2022-01-31 06:20:00 | AAPL | Stock | 170.55 | 170.67 | 170.52 | 170.67 | 23170.0 |
| 2022-01-31 06:25:00 | AAPL | Stock | 170.4 | 170.54 | 170.37 | 170.4 | 1652.0 |
| 2022-01-31 06:30:00 | AAPL | Stock | 170.45 | 170.6 | 170.42 | 170.6 | 10613.0 |
| 2022-01-31 06:35:00 | AAPL | Stock | 170.6 | 170.64 | 170.51 | 170.64 | 2282.0 |
| 2022-01-31 06:40:00 | AAPL | Stock | 170.6 | 170.65 | 170.53 | 170.54 | 1962.0 |
| 2022-01-31 06:45:00 | AAPL | Stock | 170.54 | 170.55 | 170.52 | 170.55 | 3877.0 |
| 2022-01-31 06:50:00 | AAPL | Stock | 170.67 | 170.68 | 170.6 | 170.6 | 1855.0 |
| 2022-01-31 06:55:00 | AAPL | Stock | 170.6 | 170.82 | 170.6 | 170.61 | 2461.0 |
| 2022-01-31 07:00:00 | AAPL | Stock | 170.69 | 170.85 | 170.41 | 170.41 | 63112.0 |
| 2022-01-31 07:05:00 | AAPL | Stock | 170.4 | 170.4 | 169.9 | 170.04 | 48897.0 |
| 2022-01-31 07:10:00 | AAPL | Stock | 170.08 | 170.35 | 170.08 | 170.18 | 11290.0 |
| 2022-01-31 07:15:00 | AAPL | Stock | 170.06 | 170.19 | 169.95 | 170.12 | 27075.0 |
| 2022-01-31 07:20:00 | AAPL | Stock | 170.12 | 170.12 | 169.63 | 169.82 | 16690.0 |
| 2022-01-31 07:25:00 | AAPL | Stock | 169.88 | 170.0 | 169.8 | 169.93 | 11401.0 |
| 2022-01-31 07:30:00 | AAPL | Stock | 169.94 | 170.17 | 169.8 | 170.15 | 36951.0 |
| 2022-01-31 07:35:00 | AAPL | Stock | 170.08 | 170.17 | 169.94 | 169.96 | 24072.0 |
| 2022-01-31 07:40:00 | AAPL | Stock | 169.97 | 170.07 | 169.86 | 169.95 | 17712.0 |
| 2022-01-31 07:45:00 | AAPL | Stock | 169.95 | 170.37 | 169.91 | 170.28 | 18717.0 |
| 2022-01-31 07:50:00 | AAPL | Stock | 170.23 | 170.27 | 170.1 | 170.16 | 11096.0 |
| 2022-01-31 07:55:00 | AAPL | Stock | 170.17 | 170.36 | 170.17 | 170.3 | 11893.0 |
| 2022-01-31 08:00:00 | AAPL | Stock | 170.55 | 170.86 | 169.63 | 170.27 | 284377.0 |
| 2022-01-31 08:05:00 | AAPL | Stock | 170.28 | 170.3 | 169.9 | 170.03 | 58102.0 |
> showing 50 of 460,252 rows — these rows as CSV