PREVIEW / stock_30min / 2021-12-22
file: by_date/stock_30min/2021/2021-12-22.parquet size: 2.2 MB rows: 108,826 symbols: 2,654
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-12-22 04:00:00 | AAPL | Stock | 172.29 | 172.48 | 172.0 | 172.22 | 11647.0 |
| 2021-12-22 04:30:00 | AAPL | Stock | 172.18 | 172.3 | 171.91 | 172.09 | 2745.0 |
| 2021-12-22 05:00:00 | AAPL | Stock | 172.09 | 172.44 | 172.0 | 172.21 | 8675.0 |
| 2021-12-22 05:30:00 | AAPL | Stock | 172.35 | 172.79 | 172.3 | 172.79 | 3901.0 |
| 2021-12-22 06:00:00 | AAPL | Stock | 172.79 | 172.91 | 172.72 | 172.8 | 7625.0 |
| 2021-12-22 06:30:00 | AAPL | Stock | 172.64 | 173.1 | 172.52 | 172.94 | 12203.0 |
| 2021-12-22 07:00:00 | AAPL | Stock | 172.9 | 173.07 | 172.76 | 172.8 | 69694.0 |
| 2021-12-22 07:30:00 | AAPL | Stock | 172.8 | 172.9 | 172.5 | 172.56 | 40964.0 |
| 2021-12-22 08:00:00 | AAPL | Stock | 172.56 | 173.0 | 172.25 | 172.2602 | 166441.0 |
| 2021-12-22 08:30:00 | AAPL | Stock | 172.39 | 172.8289 | 172.22 | 172.8 | 154988.0 |
| 2021-12-22 09:00:00 | AAPL | Stock | 172.8 | 173.05 | 172.55 | 173.0 | 170424.0 |
| 2021-12-22 09:30:00 | AAPL | Stock | 172.93 | 174.04 | 172.15 | 173.72 | 10554014.0 |
| 2021-12-22 10:00:00 | AAPL | Stock | 173.73 | 174.16 | 172.89 | 173.625 | 7214505.0 |
| 2021-12-22 10:30:00 | AAPL | Stock | 173.63 | 174.525 | 173.5401 | 174.48 | 6231175.0 |
| 2021-12-22 11:00:00 | AAPL | Stock | 174.47 | 174.4967 | 173.56 | 173.855 | 4683300.0 |
| 2021-12-22 11:30:00 | AAPL | Stock | 173.86 | 174.15 | 173.61 | 174.12 | 3477087.0 |
| 2021-12-22 12:00:00 | AAPL | Stock | 174.13 | 174.61 | 174.0 | 174.37 | 4637782.0 |
| 2021-12-22 12:30:00 | AAPL | Stock | 174.37 | 174.56 | 174.14 | 174.5268 | 2330410.0 |
| 2021-12-22 13:00:00 | AAPL | Stock | 174.51 | 174.75 | 174.17 | 174.21 | 3233166.0 |
| 2021-12-22 13:30:00 | AAPL | Stock | 174.195 | 174.44 | 173.77 | 174.1099 | 2848965.0 |
| 2021-12-22 14:00:00 | AAPL | Stock | 174.11 | 174.16 | 173.62 | 173.7103 | 2617445.0 |
| 2021-12-22 14:30:00 | AAPL | Stock | 173.72 | 174.59 | 173.48 | 174.52 | 4765732.0 |
| 2021-12-22 15:00:00 | AAPL | Stock | 174.52 | 175.03 | 174.36 | 174.925 | 4677833.0 |
| 2021-12-22 15:30:00 | AAPL | Stock | 174.915 | 175.86 | 174.76 | 175.63 | 8551409.0 |
| 2021-12-22 16:00:00 | AAPL | Stock | 175.63 | 175.95 | 175.58 | 175.79 | 7617017.0 |
| 2021-12-22 16:30:00 | AAPL | Stock | 175.8 | 175.85 | 175.64 | 175.81 | 49225.0 |
| 2021-12-22 17:00:00 | AAPL | Stock | 175.78 | 175.8 | 175.65 | 175.71 | 21528.0 |
| 2021-12-22 17:30:00 | AAPL | Stock | 175.73 | 175.84 | 175.7001 | 175.81 | 20184.0 |
| 2021-12-22 18:00:00 | AAPL | Stock | 175.84 | 175.84 | 175.71 | 175.8 | 16503.0 |
| 2021-12-22 18:30:00 | AAPL | Stock | 175.7601 | 175.85 | 175.76 | 175.82 | 25846.0 |
| 2021-12-22 19:00:00 | AAPL | Stock | 175.84 | 176.0 | 175.75 | 175.78 | 53660.0 |
| 2021-12-22 19:30:00 | AAPL | Stock | 175.77 | 175.98 | 175.76 | 175.98 | 23893.0 |
| 2021-12-22 04:00:00 | MSFT | Stock | 326.75 | 326.75 | 326.4 | 326.4 | 482.0 |
| 2021-12-22 04:30:00 | MSFT | Stock | 326.4 | 326.73 | 326.2 | 326.2 | 2083.0 |
| 2021-12-22 05:00:00 | MSFT | Stock | 326.32 | 326.32 | 326.32 | 326.32 | 250.0 |
| 2021-12-22 05:30:00 | MSFT | Stock | 326.11 | 326.7 | 326.11 | 326.7 | 425.0 |
| 2021-12-22 06:00:00 | MSFT | Stock | 327.13 | 327.27 | 327.13 | 327.27 | 300.0 |
| 2021-12-22 06:30:00 | MSFT | Stock | 327.26 | 328.23 | 327.22 | 328.22 | 6537.0 |
| 2021-12-22 07:00:00 | MSFT | Stock | 328.25 | 328.25 | 327.7 | 327.7 | 7842.0 |
| 2021-12-22 07:30:00 | MSFT | Stock | 327.5 | 327.5 | 326.82 | 326.82 | 6296.0 |
| 2021-12-22 08:00:00 | MSFT | Stock | 328.0 | 328.2499 | 326.56 | 326.6 | 19698.0 |
| 2021-12-22 08:30:00 | MSFT | Stock | 326.76 | 327.01 | 326.22 | 326.97 | 7012.0 |
| 2021-12-22 09:00:00 | MSFT | Stock | 326.98 | 328.6 | 326.84 | 328.01 | 37234.0 |
| 2021-12-22 09:30:00 | MSFT | Stock | 328.01 | 329.46 | 325.75 | 328.17 | 2170151.0 |
| 2021-12-22 10:00:00 | MSFT | Stock | 328.16 | 329.52 | 327.14 | 329.045 | 1381816.0 |
| 2021-12-22 10:30:00 | MSFT | Stock | 329.12 | 331.14 | 328.92 | 330.9037 | 1716974.0 |
| 2021-12-22 11:00:00 | MSFT | Stock | 330.93 | 331.48 | 327.72 | 330.66 | 1211366.0 |
| 2021-12-22 11:30:00 | MSFT | Stock | 330.66 | 331.46 | 330.47 | 331.24 | 803966.0 |
| 2021-12-22 12:00:00 | MSFT | Stock | 331.28 | 331.56 | 330.61 | 331.01 | 734861.0 |
| 2021-12-22 12:30:00 | MSFT | Stock | 331.029 | 331.26 | 330.44 | 331.2 | 714770.0 |
> showing 50 of 108,826 rows — these rows as CSV