PREVIEW / stock_30min / 2021-06-25
file: by_date/stock_30min/2021/2021-06-25.parquet size: 2.2 MB rows: 112,902 symbols: 2,929
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-06-25 04:00:00 | AAPL | Stock | 133.33 | 133.34 | 133.01 | 133.34 | 5980.0 |
| 2021-06-25 04:30:00 | AAPL | Stock | 133.35 | 133.41 | 133.32 | 133.32 | 2154.0 |
| 2021-06-25 05:00:00 | AAPL | Stock | 133.4 | 133.4 | 133.16 | 133.16 | 3356.0 |
| 2021-06-25 05:30:00 | AAPL | Stock | 133.17 | 133.6 | 133.17 | 133.6 | 5477.0 |
| 2021-06-25 06:00:00 | AAPL | Stock | 133.54 | 133.55 | 133.41 | 133.41 | 3090.0 |
| 2021-06-25 06:30:00 | AAPL | Stock | 133.4 | 133.45 | 133.38 | 133.45 | 596.0 |
| 2021-06-25 07:00:00 | AAPL | Stock | 133.41 | 133.72 | 133.4 | 133.45 | 39099.0 |
| 2021-06-25 07:30:00 | AAPL | Stock | 133.47 | 133.49 | 133.29 | 133.32 | 36949.0 |
| 2021-06-25 08:00:00 | AAPL | Stock | 133.55 | 133.57 | 133.077 | 133.2 | 143084.0 |
| 2021-06-25 08:30:00 | AAPL | Stock | 133.37 | 133.63 | 133.34 | 133.57 | 214935.0 |
| 2021-06-25 09:00:00 | AAPL | Stock | 133.57 | 133.68 | 133.17 | 133.49 | 193668.0 |
| 2021-06-25 09:30:00 | AAPL | Stock | 133.47 | 133.708 | 133.105 | 133.245 | 6592737.0 |
| 2021-06-25 10:00:00 | AAPL | Stock | 133.24 | 133.79 | 133.085 | 133.755 | 4071830.0 |
| 2021-06-25 10:30:00 | AAPL | Stock | 133.756 | 133.89 | 133.41 | 133.49 | 3130404.0 |
| 2021-06-25 11:00:00 | AAPL | Stock | 133.5 | 133.65 | 133.391 | 133.505 | 2366174.0 |
| 2021-06-25 11:30:00 | AAPL | Stock | 133.505 | 133.58 | 133.3418 | 133.375 | 1603559.0 |
| 2021-06-25 12:00:00 | AAPL | Stock | 133.38 | 133.38 | 133.24 | 133.3 | 1686489.0 |
| 2021-06-25 12:30:00 | AAPL | Stock | 133.3 | 133.51 | 133.28 | 133.3906 | 1464837.0 |
| 2021-06-25 13:00:00 | AAPL | Stock | 133.395 | 133.45 | 133.32 | 133.34 | 1293694.0 |
| 2021-06-25 13:30:00 | AAPL | Stock | 133.34 | 133.34 | 133.05 | 133.0957 | 1957709.0 |
| 2021-06-25 14:00:00 | AAPL | Stock | 133.1 | 133.17 | 132.96 | 133.115 | 2319271.0 |
| 2021-06-25 14:30:00 | AAPL | Stock | 133.115 | 133.17 | 132.9 | 133.0 | 2268414.0 |
| 2021-06-25 15:00:00 | AAPL | Stock | 132.9906 | 133.15 | 132.94 | 132.995 | 2218499.0 |
| 2021-06-25 15:30:00 | AAPL | Stock | 133.0 | 133.36 | 132.81 | 133.11 | 7013677.0 |
| 2021-06-25 16:00:00 | AAPL | Stock | 133.12 | 133.29 | 133.11 | 133.15 | 22507686.0 |
| 2021-06-25 16:30:00 | AAPL | Stock | 133.13 | 133.15 | 133.01 | 133.04 | 61707.0 |
| 2021-06-25 17:00:00 | AAPL | Stock | 133.045 | 133.08 | 133.0 | 133.04 | 22584.0 |
| 2021-06-25 17:30:00 | AAPL | Stock | 133.0 | 133.04 | 132.98 | 133.03 | 24574.0 |
| 2021-06-25 18:00:00 | AAPL | Stock | 133.03 | 133.12 | 133.03 | 133.1 | 11642.0 |
| 2021-06-25 18:30:00 | AAPL | Stock | 133.05 | 133.05 | 133.0 | 133.02 | 3581.0 |
| 2021-06-25 19:00:00 | AAPL | Stock | 133.01 | 133.01 | 132.97 | 132.99 | 9721.0 |
| 2021-06-25 19:30:00 | AAPL | Stock | 132.99 | 133.0 | 132.93 | 132.98 | 24157.0 |
| 2021-06-25 04:00:00 | MSFT | Stock | 267.0 | 267.5 | 267.0 | 267.5 | 300.0 |
| 2021-06-25 04:30:00 | MSFT | Stock | 267.36 | 267.36 | 267.36 | 267.36 | 200.0 |
| 2021-06-25 05:00:00 | MSFT | Stock | 267.27 | 267.27 | 266.84 | 266.84 | 795.0 |
| 2021-06-25 05:30:00 | MSFT | Stock | 267.23 | 267.23 | 267.23 | 267.23 | 100.0 |
| 2021-06-25 06:00:00 | MSFT | Stock | 267.48 | 267.49 | 267.39 | 267.39 | 760.0 |
| 2021-06-25 06:30:00 | MSFT | Stock | 267.37 | 267.4 | 267.31 | 267.31 | 362.0 |
| 2021-06-25 07:00:00 | MSFT | Stock | 267.38 | 267.38 | 267.04 | 267.25 | 5620.0 |
| 2021-06-25 07:30:00 | MSFT | Stock | 267.23 | 267.23 | 266.82 | 266.85 | 6364.0 |
| 2021-06-25 08:00:00 | MSFT | Stock | 267.31 | 267.4 | 266.67 | 266.67 | 10395.0 |
| 2021-06-25 08:30:00 | MSFT | Stock | 266.9 | 267.4 | 266.79 | 266.9 | 9814.0 |
| 2021-06-25 09:00:00 | MSFT | Stock | 267.03 | 267.03 | 265.95 | 266.49 | 35824.0 |
| 2021-06-25 09:30:00 | MSFT | Stock | 266.3 | 267.25 | 265.6 | 265.785 | 1896541.0 |
| 2021-06-25 10:00:00 | MSFT | Stock | 265.77 | 265.99 | 264.9154 | 265.87 | 978313.0 |
| 2021-06-25 10:30:00 | MSFT | Stock | 265.87 | 266.1172 | 265.4956 | 265.73 | 596097.0 |
| 2021-06-25 11:00:00 | MSFT | Stock | 265.73 | 266.06 | 265.51 | 265.9907 | 443107.0 |
| 2021-06-25 11:30:00 | MSFT | Stock | 266.01 | 266.26 | 265.82 | 265.835 | 401133.0 |
| 2021-06-25 12:00:00 | MSFT | Stock | 265.8286 | 265.83 | 265.15 | 265.34 | 454026.0 |
| 2021-06-25 12:30:00 | MSFT | Stock | 265.35 | 265.35 | 265.07 | 265.13 | 510555.0 |
> showing 50 of 112,902 rows — these rows as CSV