PREVIEW / stock_30min / 2021-06-24
file: by_date/stock_30min/2021/2021-06-24.parquet size: 2.2 MB rows: 111,607 symbols: 2,927
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-24 04:00:00 | AAPL | Stock | 133.83 | 134.25 | 133.83 | 134.2 | 8418.0 |
| 2021-06-24 04:30:00 | AAPL | Stock | 134.26 | 134.28 | 134.15 | 134.21 | 1201.0 |
| 2021-06-24 05:00:00 | AAPL | Stock | 134.29 | 134.35 | 134.26 | 134.34 | 4182.0 |
| 2021-06-24 05:30:00 | AAPL | Stock | 134.31 | 134.31 | 134.22 | 134.23 | 4675.0 |
| 2021-06-24 06:00:00 | AAPL | Stock | 134.21 | 134.35 | 134.18 | 134.35 | 5896.0 |
| 2021-06-24 06:30:00 | AAPL | Stock | 134.33 | 134.45 | 134.17 | 134.35 | 4658.0 |
| 2021-06-24 07:00:00 | AAPL | Stock | 134.26 | 134.3 | 134.16 | 134.25 | 44869.0 |
| 2021-06-24 07:30:00 | AAPL | Stock | 134.25 | 134.5 | 134.17 | 134.44 | 76074.0 |
| 2021-06-24 08:00:00 | AAPL | Stock | 134.25 | 134.7 | 133.366 | 134.62 | 318772.0 |
| 2021-06-24 08:30:00 | AAPL | Stock | 134.64 | 134.69 | 134.49 | 134.65 | 168629.0 |
| 2021-06-24 09:00:00 | AAPL | Stock | 134.65 | 134.68 | 133.7 | 134.41 | 397096.0 |
| 2021-06-24 09:30:00 | AAPL | Stock | 134.45 | 134.64 | 133.9501 | 134.29 | 8663691.0 |
| 2021-06-24 10:00:00 | AAPL | Stock | 134.295 | 134.5 | 134.1 | 134.27 | 4929180.0 |
| 2021-06-24 10:30:00 | AAPL | Stock | 134.265 | 134.4 | 134.07 | 134.075 | 3955693.0 |
| 2021-06-24 11:00:00 | AAPL | Stock | 134.08 | 134.18 | 133.73 | 133.975 | 4599685.0 |
| 2021-06-24 11:30:00 | AAPL | Stock | 133.98 | 134.1 | 133.87 | 133.995 | 2528445.0 |
| 2021-06-24 12:00:00 | AAPL | Stock | 134.0 | 134.08 | 133.831 | 133.91 | 3269653.0 |
| 2021-06-24 12:30:00 | AAPL | Stock | 133.91 | 133.9199 | 133.42 | 133.4387 | 3505068.0 |
| 2021-06-24 13:00:00 | AAPL | Stock | 133.435 | 133.58 | 133.16 | 133.392 | 3393445.0 |
| 2021-06-24 13:30:00 | AAPL | Stock | 133.39 | 133.7 | 133.35 | 133.69 | 2285185.0 |
| 2021-06-24 14:00:00 | AAPL | Stock | 133.6995 | 133.76 | 133.505 | 133.6999 | 2258848.0 |
| 2021-06-24 14:30:00 | AAPL | Stock | 133.7 | 133.71 | 133.36 | 133.465 | 2410215.0 |
| 2021-06-24 15:00:00 | AAPL | Stock | 133.46 | 133.49 | 133.035 | 133.115 | 3001934.0 |
| 2021-06-24 15:30:00 | AAPL | Stock | 133.115 | 133.47 | 132.93 | 133.4 | 7439688.0 |
| 2021-06-24 16:00:00 | AAPL | Stock | 133.41 | 133.45 | 133.29 | 133.3 | 8500690.0 |
| 2021-06-24 16:30:00 | AAPL | Stock | 133.29 | 133.43 | 133.29 | 133.41 | 21224.0 |
| 2021-06-24 17:00:00 | AAPL | Stock | 133.41 | 133.46 | 133.37 | 133.38 | 19157.0 |
| 2021-06-24 17:30:00 | AAPL | Stock | 133.44 | 133.44 | 133.32 | 133.4 | 11764.0 |
| 2021-06-24 18:00:00 | AAPL | Stock | 133.4 | 133.45 | 133.33 | 133.43 | 27512.0 |
| 2021-06-24 18:30:00 | AAPL | Stock | 133.44 | 133.47 | 133.36 | 133.37 | 22705.0 |
| 2021-06-24 19:00:00 | AAPL | Stock | 133.39 | 133.43 | 133.34 | 133.38 | 19546.0 |
| 2021-06-24 19:30:00 | AAPL | Stock | 133.38 | 133.4 | 133.33 | 133.34 | 26864.0 |
| 2021-06-24 04:00:00 | MSFT | Stock | 265.87 | 266.5 | 265.87 | 266.22 | 800.0 |
| 2021-06-24 04:30:00 | MSFT | Stock | 266.6 | 266.6 | 266.42 | 266.42 | 1362.0 |
| 2021-06-24 05:00:00 | MSFT | Stock | 266.88 | 267.0 | 266.88 | 266.88 | 1142.0 |
| 2021-06-24 05:30:00 | MSFT | Stock | 266.81 | 266.99 | 266.79 | 266.79 | 4699.0 |
| 2021-06-24 06:00:00 | MSFT | Stock | 267.0 | 267.0 | 266.8 | 266.8 | 1022.0 |
| 2021-06-24 06:30:00 | MSFT | Stock | 266.8 | 266.8 | 266.8 | 266.8 | 169.0 |
| 2021-06-24 07:00:00 | MSFT | Stock | 266.75 | 266.79 | 266.4 | 266.66 | 2996.0 |
| 2021-06-24 07:30:00 | MSFT | Stock | 266.55 | 266.66 | 266.55 | 266.62 | 1882.0 |
| 2021-06-24 08:00:00 | MSFT | Stock | 266.6001 | 266.9 | 266.5001 | 266.7 | 10361.0 |
| 2021-06-24 08:30:00 | MSFT | Stock | 266.6 | 266.71 | 266.42 | 266.53 | 9467.0 |
| 2021-06-24 09:00:00 | MSFT | Stock | 266.5 | 266.7 | 265.78 | 265.96 | 19292.0 |
| 2021-06-24 09:30:00 | MSFT | Stock | 266.01 | 267.44 | 265.47 | 266.81 | 2089980.0 |
| 2021-06-24 10:00:00 | MSFT | Stock | 266.79 | 267.34 | 266.4 | 267.3399 | 1264561.0 |
| 2021-06-24 10:30:00 | MSFT | Stock | 267.33 | 267.55 | 266.5302 | 266.8419 | 1264773.0 |
| 2021-06-24 11:00:00 | MSFT | Stock | 266.85 | 267.34 | 266.7 | 267.21 | 846492.0 |
| 2021-06-24 11:30:00 | MSFT | Stock | 267.23 | 267.275 | 266.81 | 267.1518 | 663441.0 |
| 2021-06-24 12:00:00 | MSFT | Stock | 267.14 | 267.85 | 267.11 | 267.45 | 779639.0 |
| 2021-06-24 12:30:00 | MSFT | Stock | 267.44 | 267.4898 | 266.35 | 266.425 | 860579.0 |
> showing 50 of 111,607 rows — these rows as CSV