PREVIEW / stock_5min / 2022-01-07
file: by_date/stock_5min/2022/2022-01-07.parquet size: 7.3 MB rows: 443,496 symbols: 2,602
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-07 04:00:00 | AAPL | Stock | 171.5 | 171.68 | 171.31 | 171.5 | 6606.0 |
| 2022-01-07 04:05:00 | AAPL | Stock | 171.45 | 171.69 | 171.45 | 171.69 | 1146.0 |
| 2022-01-07 04:10:00 | AAPL | Stock | 171.98 | 172.0 | 171.88 | 171.94 | 4516.0 |
| 2022-01-07 04:15:00 | AAPL | Stock | 171.92 | 171.92 | 171.69 | 171.69 | 664.0 |
| 2022-01-07 04:20:00 | AAPL | Stock | 171.72 | 171.9 | 171.72 | 171.9 | 914.0 |
| 2022-01-07 04:25:00 | AAPL | Stock | 171.98 | 172.09 | 171.98 | 172.09 | 1111.0 |
| 2022-01-07 04:30:00 | AAPL | Stock | 172.19 | 172.23 | 172.17 | 172.2 | 1089.0 |
| 2022-01-07 04:35:00 | AAPL | Stock | 172.23 | 172.36 | 172.23 | 172.3 | 1838.0 |
| 2022-01-07 04:40:00 | AAPL | Stock | 172.38 | 172.46 | 172.38 | 172.4 | 2533.0 |
| 2022-01-07 04:45:00 | AAPL | Stock | 172.43 | 172.43 | 172.43 | 172.43 | 110.0 |
| 2022-01-07 04:50:00 | AAPL | Stock | 172.39 | 172.39 | 172.35 | 172.35 | 373.0 |
| 2022-01-07 04:55:00 | AAPL | Stock | 172.35 | 172.38 | 172.22 | 172.22 | 1405.0 |
| 2022-01-07 05:00:00 | AAPL | Stock | 172.3 | 172.3 | 172.16 | 172.16 | 1057.0 |
| 2022-01-07 05:05:00 | AAPL | Stock | 172.27 | 172.43 | 172.27 | 172.43 | 507.0 |
| 2022-01-07 05:10:00 | AAPL | Stock | 172.47 | 172.5 | 172.47 | 172.5 | 2850.0 |
| 2022-01-07 05:15:00 | AAPL | Stock | 172.62 | 172.62 | 172.47 | 172.47 | 2345.0 |
| 2022-01-07 05:20:00 | AAPL | Stock | 172.5 | 172.6 | 172.5 | 172.57 | 1611.0 |
| 2022-01-07 05:25:00 | AAPL | Stock | 172.53 | 172.7 | 172.53 | 172.7 | 1374.0 |
| 2022-01-07 05:30:00 | AAPL | Stock | 172.69 | 172.83 | 172.69 | 172.8 | 1050.0 |
| 2022-01-07 05:35:00 | AAPL | Stock | 172.78 | 172.78 | 172.75 | 172.75 | 687.0 |
| 2022-01-07 05:40:00 | AAPL | Stock | 172.73 | 172.73 | 172.73 | 172.73 | 494.0 |
| 2022-01-07 05:45:00 | AAPL | Stock | 172.72 | 172.72 | 172.72 | 172.72 | 109.0 |
| 2022-01-07 05:50:00 | AAPL | Stock | 172.78 | 172.78 | 172.78 | 172.78 | 100.0 |
| 2022-01-07 05:55:00 | AAPL | Stock | 172.7 | 172.71 | 172.7 | 172.71 | 200.0 |
| 2022-01-07 06:00:00 | AAPL | Stock | 172.72 | 172.72 | 172.57 | 172.57 | 659.0 |
| 2022-01-07 06:05:00 | AAPL | Stock | 172.65 | 172.7 | 172.64 | 172.64 | 1260.0 |
| 2022-01-07 06:10:00 | AAPL | Stock | 172.7 | 172.73 | 172.64 | 172.64 | 735.0 |
| 2022-01-07 06:15:00 | AAPL | Stock | 172.79 | 172.79 | 172.79 | 172.79 | 100.0 |
| 2022-01-07 06:20:00 | AAPL | Stock | 172.89 | 172.89 | 172.89 | 172.89 | 144.0 |
| 2022-01-07 06:25:00 | AAPL | Stock | 172.88 | 172.95 | 172.84 | 172.94 | 1449.0 |
| 2022-01-07 06:30:00 | AAPL | Stock | 173.0 | 173.3 | 173.0 | 173.13 | 1889.0 |
| 2022-01-07 06:35:00 | AAPL | Stock | 173.13 | 173.13 | 173.0 | 173.0 | 1647.0 |
| 2022-01-07 06:40:00 | AAPL | Stock | 173.0 | 173.1 | 172.95 | 173.1 | 659.0 |
| 2022-01-07 06:45:00 | AAPL | Stock | 173.16 | 173.18 | 173.1 | 173.14 | 1151.0 |
| 2022-01-07 06:50:00 | AAPL | Stock | 173.1 | 173.15 | 172.95 | 172.95 | 4380.0 |
| 2022-01-07 06:55:00 | AAPL | Stock | 172.95 | 173.08 | 172.82 | 172.82 | 2512.0 |
| 2022-01-07 07:00:00 | AAPL | Stock | 172.85 | 173.08 | 172.85 | 173.0 | 6116.0 |
| 2022-01-07 07:05:00 | AAPL | Stock | 173.08 | 173.09 | 172.91 | 172.92 | 15858.0 |
| 2022-01-07 07:10:00 | AAPL | Stock | 172.92 | 172.98 | 172.8 | 172.88 | 5732.0 |
| 2022-01-07 07:15:00 | AAPL | Stock | 172.87 | 172.97 | 172.84 | 172.94 | 3568.0 |
| 2022-01-07 07:20:00 | AAPL | Stock | 172.91 | 172.91 | 172.76 | 172.78 | 5324.0 |
| 2022-01-07 07:25:00 | AAPL | Stock | 172.75 | 172.83 | 172.56 | 172.83 | 7363.0 |
| 2022-01-07 07:30:00 | AAPL | Stock | 172.83 | 172.83 | 172.74 | 172.78 | 2958.0 |
| 2022-01-07 07:35:00 | AAPL | Stock | 172.78 | 172.78 | 172.58 | 172.58 | 11891.0 |
| 2022-01-07 07:40:00 | AAPL | Stock | 172.59 | 172.66 | 172.5 | 172.63 | 5301.0 |
| 2022-01-07 07:45:00 | AAPL | Stock | 172.6 | 172.67 | 172.56 | 172.67 | 5366.0 |
| 2022-01-07 07:50:00 | AAPL | Stock | 172.62 | 172.66 | 172.55 | 172.56 | 2345.0 |
| 2022-01-07 07:55:00 | AAPL | Stock | 172.57 | 172.57 | 172.4 | 172.42 | 7298.0 |
| 2022-01-07 08:00:00 | AAPL | Stock | 172.75 | 173.1299 | 172.4 | 172.54 | 183042.0 |
| 2022-01-07 08:05:00 | AAPL | Stock | 172.53 | 172.6 | 172.49 | 172.53 | 16212.0 |
> showing 50 of 443,496 rows — these rows as CSV