PREVIEW / stock_30min / 2021-10-29
file: by_date/stock_30min/2021/2021-10-29.parquet size: 2.2 MB rows: 111,713 symbols: 2,695
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-10-29 04:00:00 | AAPL | Stock | 147.0 | 147.64 | 146.73 | 147.61 | 75170.0 |
| 2021-10-29 04:30:00 | AAPL | Stock | 147.61 | 147.74 | 147.33 | 147.6 | 34146.0 |
| 2021-10-29 05:00:00 | AAPL | Stock | 147.59 | 147.73 | 147.21 | 147.23 | 20909.0 |
| 2021-10-29 05:30:00 | AAPL | Stock | 147.24 | 147.65 | 147.22 | 147.51 | 9634.0 |
| 2021-10-29 06:00:00 | AAPL | Stock | 147.5 | 147.56 | 146.5 | 146.86 | 49675.0 |
| 2021-10-29 06:30:00 | AAPL | Stock | 146.72 | 147.3 | 146.72 | 147.24 | 23050.0 |
| 2021-10-29 07:00:00 | AAPL | Stock | 147.28 | 147.47 | 147.07 | 147.2 | 138810.0 |
| 2021-10-29 07:30:00 | AAPL | Stock | 147.22 | 147.5 | 146.95 | 147.3 | 198726.0 |
| 2021-10-29 08:00:00 | AAPL | Stock | 147.1101 | 147.48 | 146.8 | 147.27 | 671907.0 |
| 2021-10-29 08:30:00 | AAPL | Stock | 147.27 | 147.4 | 146.8 | 147.2 | 553467.0 |
| 2021-10-29 09:00:00 | AAPL | Stock | 147.2 | 148.2 | 147.05 | 147.12 | 814749.0 |
| 2021-10-29 09:30:00 | AAPL | Stock | 147.19 | 148.7 | 146.4128 | 147.125 | 22368444.0 |
| 2021-10-29 10:00:00 | AAPL | Stock | 147.13 | 147.82 | 146.91 | 147.05 | 9364443.0 |
| 2021-10-29 10:30:00 | AAPL | Stock | 147.055 | 147.48 | 146.92 | 147.26 | 6231512.0 |
| 2021-10-29 11:00:00 | AAPL | Stock | 147.255 | 147.96 | 147.02 | 147.94 | 5451670.0 |
| 2021-10-29 11:30:00 | AAPL | Stock | 147.95 | 148.64 | 147.87 | 148.32 | 5809409.0 |
| 2021-10-29 12:00:00 | AAPL | Stock | 148.315 | 149.38 | 148.285 | 149.36 | 6916813.0 |
| 2021-10-29 12:30:00 | AAPL | Stock | 149.355 | 149.505 | 149.01 | 149.375 | 5655378.0 |
| 2021-10-29 13:00:00 | AAPL | Stock | 149.38 | 149.5 | 149.02 | 149.11 | 3388919.0 |
| 2021-10-29 13:30:00 | AAPL | Stock | 149.115 | 149.1211 | 148.61 | 148.685 | 3423877.0 |
| 2021-10-29 14:00:00 | AAPL | Stock | 148.68 | 149.24 | 148.54 | 148.94 | 4483598.0 |
| 2021-10-29 14:30:00 | AAPL | Stock | 148.945 | 149.31 | 148.84 | 149.15 | 2994454.0 |
| 2021-10-29 15:00:00 | AAPL | Stock | 149.155 | 149.65 | 148.98 | 149.495 | 5425147.0 |
| 2021-10-29 15:30:00 | AAPL | Stock | 149.495 | 149.94 | 149.38 | 149.8 | 9228417.0 |
| 2021-10-29 16:00:00 | AAPL | Stock | 149.75 | 149.9 | 149.73 | 149.8 | 11028507.0 |
| 2021-10-29 16:30:00 | AAPL | Stock | 149.83 | 149.84 | 149.65 | 149.8 | 100660.0 |
| 2021-10-29 17:00:00 | AAPL | Stock | 149.82 | 149.9 | 149.8 | 149.9 | 66266.0 |
| 2021-10-29 17:30:00 | AAPL | Stock | 149.9 | 149.94 | 149.86 | 149.9 | 35719.0 |
| 2021-10-29 18:00:00 | AAPL | Stock | 149.88 | 149.9 | 149.85 | 149.87 | 22146.0 |
| 2021-10-29 18:30:00 | AAPL | Stock | 149.8999 | 149.9 | 149.81 | 149.84 | 28067.0 |
| 2021-10-29 19:00:00 | AAPL | Stock | 149.84 | 149.9 | 149.83 | 149.88 | 17962.0 |
| 2021-10-29 19:30:00 | AAPL | Stock | 149.8899 | 149.96 | 149.88 | 149.9201 | 26759.0 |
| 2021-10-29 04:00:00 | MSFT | Stock | 325.07 | 325.07 | 324.11 | 324.28 | 4959.0 |
| 2021-10-29 04:30:00 | MSFT | Stock | 324.38 | 324.54 | 323.81 | 324.54 | 1271.0 |
| 2021-10-29 05:00:00 | MSFT | Stock | 324.99 | 324.99 | 324.02 | 324.14 | 9632.0 |
| 2021-10-29 05:30:00 | MSFT | Stock | 324.44 | 324.44 | 324.34 | 324.34 | 300.0 |
| 2021-10-29 06:00:00 | MSFT | Stock | 324.72 | 324.72 | 323.37 | 323.5 | 3721.0 |
| 2021-10-29 06:30:00 | MSFT | Stock | 324.05 | 324.32 | 323.9 | 324.01 | 1885.0 |
| 2021-10-29 07:00:00 | MSFT | Stock | 324.0 | 324.46 | 323.76 | 323.95 | 12064.0 |
| 2021-10-29 07:30:00 | MSFT | Stock | 323.72 | 324.3 | 323.65 | 324.21 | 19668.0 |
| 2021-10-29 08:00:00 | MSFT | Stock | 324.2877 | 325.16 | 323.8 | 324.84 | 15931.0 |
| 2021-10-29 08:30:00 | MSFT | Stock | 324.72 | 325.18 | 324.33 | 324.5 | 46170.0 |
| 2021-10-29 09:00:00 | MSFT | Stock | 324.6 | 325.0 | 323.5 | 324.14 | 67841.0 |
| 2021-10-29 09:30:00 | MSFT | Stock | 324.14 | 327.88 | 323.9 | 325.41 | 3852845.0 |
| 2021-10-29 10:00:00 | MSFT | Stock | 325.3801 | 327.025 | 325.0501 | 326.297 | 1446949.0 |
| 2021-10-29 10:30:00 | MSFT | Stock | 326.3168 | 329.52 | 326.16 | 327.86 | 1787166.0 |
| 2021-10-29 11:00:00 | MSFT | Stock | 327.85 | 328.77 | 327.8 | 328.19 | 1258276.0 |
| 2021-10-29 11:30:00 | MSFT | Stock | 328.195 | 328.22 | 327.32 | 327.49 | 1122483.0 |
| 2021-10-29 12:00:00 | MSFT | Stock | 327.49 | 328.95 | 327.23 | 328.91 | 1198432.0 |
| 2021-10-29 12:30:00 | MSFT | Stock | 328.91 | 329.185 | 328.4 | 329.185 | 805544.0 |
> showing 50 of 111,713 rows — these rows as CSV