PREVIEW / stock_30min / 2023-02-21
file: by_date/stock_30min/2023/2023-02-21.parquet size: 2.1 MB rows: 104,521 symbols: 1,851
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 |
|---|---|---|---|---|---|---|---|
| 2023-02-21 04:00:00 | AAPL | Stock | 150.86 | 151.0 | 150.22 | 150.49 | 28975.0 |
| 2023-02-21 04:30:00 | AAPL | Stock | 150.49 | 151.22 | 150.45 | 151.1 | 28614.0 |
| 2023-02-21 05:00:00 | AAPL | Stock | 150.97 | 150.97 | 150.58 | 150.73 | 5151.0 |
| 2023-02-21 05:30:00 | AAPL | Stock | 150.65 | 150.74 | 150.41 | 150.51 | 22375.0 |
| 2023-02-21 06:00:00 | AAPL | Stock | 150.5 | 150.9 | 150.45 | 150.77 | 8087.0 |
| 2023-02-21 06:30:00 | AAPL | Stock | 150.78 | 150.86 | 150.63 | 150.75 | 7414.0 |
| 2023-02-21 07:00:00 | AAPL | Stock | 150.8 | 151.02 | 150.53 | 150.54 | 45300.0 |
| 2023-02-21 07:30:00 | AAPL | Stock | 150.63 | 150.74 | 150.63 | 150.66 | 5873.0 |
| 2023-02-21 08:00:00 | AAPL | Stock | 150.5499 | 151.77 | 150.2912 | 150.36 | 121585.0 |
| 2023-02-21 08:30:00 | AAPL | Stock | 150.47 | 150.66 | 150.4023 | 150.45 | 88385.0 |
| 2023-02-21 09:00:00 | AAPL | Stock | 150.44 | 150.58 | 150.12 | 150.34 | 103815.0 |
| 2023-02-21 09:30:00 | AAPL | Stock | 150.33 | 151.3 | 150.08 | 150.36 | 6653472.0 |
| 2023-02-21 10:00:00 | AAPL | Stock | 150.36 | 150.61 | 149.65 | 149.6908 | 4509030.0 |
| 2023-02-21 10:30:00 | AAPL | Stock | 149.69 | 150.3 | 149.6 | 149.9115 | 2867523.0 |
| 2023-02-21 11:00:00 | AAPL | Stock | 149.93 | 150.06 | 149.42 | 149.51 | 2394242.0 |
| 2023-02-21 11:30:00 | AAPL | Stock | 149.505 | 149.94 | 149.36 | 149.8001 | 2026925.0 |
| 2023-02-21 12:00:00 | AAPL | Stock | 149.8 | 149.99 | 149.62 | 149.6825 | 1944805.0 |
| 2023-02-21 12:30:00 | AAPL | Stock | 149.69 | 150.15 | 149.66 | 150.02 | 1606098.0 |
| 2023-02-21 13:00:00 | AAPL | Stock | 150.01 | 150.0334 | 149.31 | 149.46 | 1901442.0 |
| 2023-02-21 13:30:00 | AAPL | Stock | 149.47 | 149.67 | 149.29 | 149.4039 | 1541101.0 |
| 2023-02-21 14:00:00 | AAPL | Stock | 149.41 | 149.41 | 148.86 | 148.885 | 2222782.0 |
| 2023-02-21 14:30:00 | AAPL | Stock | 148.885 | 149.18 | 148.565 | 148.67 | 2210052.0 |
| 2023-02-21 15:00:00 | AAPL | Stock | 148.675 | 148.94 | 148.405 | 148.59 | 2301792.0 |
| 2023-02-21 15:30:00 | AAPL | Stock | 148.59 | 148.94 | 148.41 | 148.48 | 5530006.0 |
| 2023-02-21 16:00:00 | AAPL | Stock | 148.48 | 148.69 | 148.43 | 148.58 | 11309597.0 |
| 2023-02-21 16:30:00 | AAPL | Stock | 148.58 | 148.59 | 148.45 | 148.51 | 153074.0 |
| 2023-02-21 17:00:00 | AAPL | Stock | 148.5 | 148.59 | 148.48 | 148.56 | 107271.0 |
| 2023-02-21 17:30:00 | AAPL | Stock | 148.59 | 148.59 | 148.51 | 148.55 | 20934.0 |
| 2023-02-21 18:00:00 | AAPL | Stock | 148.56 | 148.8 | 148.53 | 148.69 | 47632.0 |
| 2023-02-21 18:30:00 | AAPL | Stock | 148.68 | 148.88 | 148.68 | 148.8 | 21310.0 |
| 2023-02-21 19:00:00 | AAPL | Stock | 148.82 | 148.88 | 148.76 | 148.8 | 12551.0 |
| 2023-02-21 19:30:00 | AAPL | Stock | 148.85 | 148.87 | 148.65 | 148.72 | 22569.0 |
| 2023-02-21 04:00:00 | MSFT | Stock | 255.5 | 256.98 | 254.7 | 255.38 | 15819.0 |
| 2023-02-21 04:30:00 | MSFT | Stock | 255.75 | 256.96 | 255.64 | 256.55 | 4231.0 |
| 2023-02-21 05:00:00 | MSFT | Stock | 256.2 | 256.2 | 255.72 | 255.88 | 2158.0 |
| 2023-02-21 05:30:00 | MSFT | Stock | 255.91 | 256.0 | 255.91 | 256.0 | 227.0 |
| 2023-02-21 06:00:00 | MSFT | Stock | 255.81 | 256.46 | 255.81 | 256.46 | 504.0 |
| 2023-02-21 06:30:00 | MSFT | Stock | 256.56 | 256.6 | 255.99 | 255.99 | 1444.0 |
| 2023-02-21 07:00:00 | MSFT | Stock | 256.09 | 256.09 | 255.17 | 255.35 | 6576.0 |
| 2023-02-21 07:30:00 | MSFT | Stock | 255.4 | 256.47 | 255.4 | 256.02 | 6899.0 |
| 2023-02-21 08:00:00 | MSFT | Stock | 255.683 | 257.93 | 255.17 | 255.5 | 24652.0 |
| 2023-02-21 08:30:00 | MSFT | Stock | 255.36 | 256.01 | 255.2601 | 255.36 | 16497.0 |
| 2023-02-21 09:00:00 | MSFT | Stock | 255.42 | 255.69 | 254.49 | 254.49 | 48193.0 |
| 2023-02-21 09:30:00 | MSFT | Stock | 254.48 | 255.49 | 253.85 | 254.2 | 2722846.0 |
| 2023-02-21 10:00:00 | MSFT | Stock | 254.16 | 254.5 | 253.18 | 253.39 | 1466910.0 |
| 2023-02-21 10:30:00 | MSFT | Stock | 253.37 | 254.0 | 252.84 | 253.29 | 1183884.0 |
| 2023-02-21 11:00:00 | MSFT | Stock | 253.3 | 253.64 | 252.03 | 252.205 | 1114013.0 |
| 2023-02-21 11:30:00 | MSFT | Stock | 252.2078 | 252.43 | 251.81 | 251.86 | 844001.0 |
| 2023-02-21 12:00:00 | MSFT | Stock | 251.86 | 252.26 | 251.59 | 251.89 | 941797.0 |
| 2023-02-21 12:30:00 | MSFT | Stock | 251.9 | 252.47 | 251.79 | 252.42 | 771891.0 |
> showing 50 of 104,521 rows — these rows as CSV