PREVIEW / stock_5min / 2022-01-14
file: by_date/stock_5min/2022/2022-01-14.parquet size: 7.4 MB rows: 452,063 symbols: 2,594
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-14 04:00:00 | AAPL | Stock | 172.2 | 172.8 | 172.2 | 172.66 | 3627.0 |
| 2022-01-14 04:05:00 | AAPL | Stock | 172.61 | 172.69 | 172.33 | 172.33 | 2825.0 |
| 2022-01-14 04:10:00 | AAPL | Stock | 172.4 | 172.59 | 172.4 | 172.59 | 1823.0 |
| 2022-01-14 04:15:00 | AAPL | Stock | 172.66 | 172.66 | 172.66 | 172.66 | 388.0 |
| 2022-01-14 04:20:00 | AAPL | Stock | 172.75 | 172.78 | 172.75 | 172.78 | 1454.0 |
| 2022-01-14 04:25:00 | AAPL | Stock | 172.49 | 172.73 | 172.41 | 172.54 | 1476.0 |
| 2022-01-14 04:30:00 | AAPL | Stock | 172.84 | 172.85 | 172.83 | 172.83 | 1879.0 |
| 2022-01-14 04:35:00 | AAPL | Stock | 172.91 | 172.94 | 172.83 | 172.83 | 1554.0 |
| 2022-01-14 04:40:00 | AAPL | Stock | 172.84 | 172.84 | 172.84 | 172.84 | 150.0 |
| 2022-01-14 04:45:00 | AAPL | Stock | 172.71 | 172.71 | 172.71 | 172.71 | 100.0 |
| 2022-01-14 04:50:00 | AAPL | Stock | 172.82 | 172.83 | 172.7 | 172.7 | 350.0 |
| 2022-01-14 05:00:00 | AAPL | Stock | 172.85 | 172.85 | 172.5 | 172.5 | 907.0 |
| 2022-01-14 05:05:00 | AAPL | Stock | 172.45 | 172.45 | 172.45 | 172.45 | 131.0 |
| 2022-01-14 05:10:00 | AAPL | Stock | 172.69 | 172.9 | 172.69 | 172.71 | 3589.0 |
| 2022-01-14 05:15:00 | AAPL | Stock | 172.56 | 172.61 | 172.53 | 172.61 | 1184.0 |
| 2022-01-14 05:20:00 | AAPL | Stock | 172.5 | 172.66 | 172.5 | 172.66 | 400.0 |
| 2022-01-14 05:25:00 | AAPL | Stock | 172.54 | 172.54 | 172.3 | 172.3 | 4287.0 |
| 2022-01-14 05:30:00 | AAPL | Stock | 172.28 | 172.28 | 172.05 | 172.21 | 2886.0 |
| 2022-01-14 05:35:00 | AAPL | Stock | 172.08 | 172.24 | 172.02 | 172.24 | 1795.0 |
| 2022-01-14 05:40:00 | AAPL | Stock | 172.34 | 172.34 | 172.34 | 172.34 | 100.0 |
| 2022-01-14 05:45:00 | AAPL | Stock | 172.42 | 172.59 | 172.34 | 172.59 | 2037.0 |
| 2022-01-14 05:50:00 | AAPL | Stock | 172.41 | 172.41 | 172.41 | 172.41 | 100.0 |
| 2022-01-14 05:55:00 | AAPL | Stock | 172.44 | 172.44 | 172.41 | 172.44 | 924.0 |
| 2022-01-14 06:00:00 | AAPL | Stock | 172.41 | 172.5 | 172.3 | 172.5 | 1592.0 |
| 2022-01-14 06:05:00 | AAPL | Stock | 172.4 | 172.4 | 172.4 | 172.4 | 227.0 |
| 2022-01-14 06:15:00 | AAPL | Stock | 172.46 | 172.46 | 172.46 | 172.46 | 100.0 |
| 2022-01-14 06:25:00 | AAPL | Stock | 172.34 | 172.34 | 172.34 | 172.34 | 100.0 |
| 2022-01-14 06:30:00 | AAPL | Stock | 172.28 | 172.28 | 172.2 | 172.2 | 434.0 |
| 2022-01-14 06:35:00 | AAPL | Stock | 172.07 | 172.07 | 172.07 | 172.07 | 156.0 |
| 2022-01-14 06:40:00 | AAPL | Stock | 172.02 | 172.02 | 171.88 | 171.92 | 1086.0 |
| 2022-01-14 06:45:00 | AAPL | Stock | 171.95 | 172.0 | 171.9 | 172.0 | 1140.0 |
| 2022-01-14 06:50:00 | AAPL | Stock | 172.0 | 172.11 | 172.0 | 172.08 | 1599.0 |
| 2022-01-14 06:55:00 | AAPL | Stock | 172.08 | 172.08 | 171.99 | 172.0 | 1505.0 |
| 2022-01-14 07:00:00 | AAPL | Stock | 172.11 | 172.3 | 171.9 | 171.95 | 12030.0 |
| 2022-01-14 07:05:00 | AAPL | Stock | 171.98 | 171.99 | 171.5 | 171.65 | 13547.0 |
| 2022-01-14 07:10:00 | AAPL | Stock | 171.7 | 171.82 | 171.7 | 171.82 | 7398.0 |
| 2022-01-14 07:15:00 | AAPL | Stock | 171.85 | 171.91 | 171.83 | 171.9 | 5473.0 |
| 2022-01-14 07:20:00 | AAPL | Stock | 171.85 | 172.13 | 171.75 | 171.86 | 11475.0 |
| 2022-01-14 07:25:00 | AAPL | Stock | 171.88 | 171.9 | 171.52 | 171.55 | 14566.0 |
| 2022-01-14 07:30:00 | AAPL | Stock | 171.54 | 171.64 | 171.53 | 171.58 | 4432.0 |
| 2022-01-14 07:35:00 | AAPL | Stock | 171.6 | 171.61 | 171.27 | 171.27 | 15532.0 |
| 2022-01-14 07:40:00 | AAPL | Stock | 171.29 | 171.29 | 171.02 | 171.12 | 25676.0 |
| 2022-01-14 07:45:00 | AAPL | Stock | 171.15 | 171.3 | 171.0 | 171.05 | 20909.0 |
| 2022-01-14 07:50:00 | AAPL | Stock | 171.04 | 171.1 | 170.84 | 170.85 | 29290.0 |
| 2022-01-14 07:55:00 | AAPL | Stock | 170.86 | 170.95 | 170.32 | 170.4 | 25361.0 |
| 2022-01-14 08:00:00 | AAPL | Stock | 172.0046 | 172.31 | 170.3 | 170.65 | 174907.0 |
| 2022-01-14 08:05:00 | AAPL | Stock | 170.65 | 170.85 | 170.6 | 170.74 | 36670.0 |
| 2022-01-14 08:10:00 | AAPL | Stock | 170.65 | 170.86 | 170.5 | 170.65 | 32350.0 |
| 2022-01-14 08:15:00 | AAPL | Stock | 170.64 | 171.14 | 170.6 | 170.98 | 33561.0 |
| 2022-01-14 08:20:00 | AAPL | Stock | 171.0 | 171.04 | 170.78 | 170.9014 | 34656.0 |
> showing 50 of 452,063 rows — these rows as CSV