PREVIEW / stock_30min / 2021-12-15
file: by_date/stock_30min/2021/2021-12-15.parquet size: 2.3 MB rows: 112,052 symbols: 2,663
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-15 04:00:00 | AAPL | Stock | 174.7 | 174.97 | 173.34 | 173.34 | 19736.0 |
| 2021-12-15 04:30:00 | AAPL | Stock | 173.69 | 174.27 | 173.69 | 173.99 | 9129.0 |
| 2021-12-15 05:00:00 | AAPL | Stock | 174.0 | 174.16 | 173.95 | 174.16 | 5501.0 |
| 2021-12-15 05:30:00 | AAPL | Stock | 174.15 | 174.3 | 174.11 | 174.3 | 5296.0 |
| 2021-12-15 06:00:00 | AAPL | Stock | 174.16 | 174.24 | 173.81 | 173.99 | 10876.0 |
| 2021-12-15 06:30:00 | AAPL | Stock | 173.96 | 174.11 | 173.84 | 174.11 | 24003.0 |
| 2021-12-15 07:00:00 | AAPL | Stock | 174.12 | 175.03 | 174.0 | 175.0 | 149776.0 |
| 2021-12-15 07:30:00 | AAPL | Stock | 174.95 | 175.19 | 174.55 | 174.57 | 70537.0 |
| 2021-12-15 08:00:00 | AAPL | Stock | 175.14 | 175.16 | 173.895 | 174.76 | 240053.0 |
| 2021-12-15 08:30:00 | AAPL | Stock | 174.8268 | 175.33 | 174.33 | 174.51 | 243437.0 |
| 2021-12-15 09:00:00 | AAPL | Stock | 174.53 | 175.27 | 174.31 | 175.27 | 212688.0 |
| 2021-12-15 09:30:00 | AAPL | Stock | 175.11 | 175.8494 | 172.96 | 173.74 | 13162679.0 |
| 2021-12-15 10:00:00 | AAPL | Stock | 173.73 | 173.94 | 172.91 | 173.665 | 6146442.0 |
| 2021-12-15 10:30:00 | AAPL | Stock | 173.66 | 174.41 | 173.41 | 173.89 | 4715219.0 |
| 2021-12-15 11:00:00 | AAPL | Stock | 173.88 | 173.91 | 172.95 | 173.185 | 3706527.0 |
| 2021-12-15 11:30:00 | AAPL | Stock | 173.18 | 173.21 | 172.42 | 172.44 | 4313830.0 |
| 2021-12-15 12:00:00 | AAPL | Stock | 172.43 | 173.09 | 172.3108 | 173.0429 | 4024137.0 |
| 2021-12-15 12:30:00 | AAPL | Stock | 173.05 | 173.44 | 172.76 | 173.43 | 3922393.0 |
| 2021-12-15 13:00:00 | AAPL | Stock | 173.43 | 173.82 | 173.18 | 173.5573 | 3525610.0 |
| 2021-12-15 13:30:00 | AAPL | Stock | 173.55 | 173.56 | 172.86 | 173.48 | 3229171.0 |
| 2021-12-15 14:00:00 | AAPL | Stock | 173.46 | 176.77 | 172.4 | 176.17 | 14793830.0 |
| 2021-12-15 14:30:00 | AAPL | Stock | 176.18 | 178.27 | 175.69 | 177.84 | 14255838.0 |
| 2021-12-15 15:00:00 | AAPL | Stock | 177.8301 | 179.3386 | 177.76 | 178.76 | 10834217.0 |
| 2021-12-15 15:30:00 | AAPL | Stock | 178.75 | 179.5 | 178.07 | 179.3 | 11851595.0 |
| 2021-12-15 16:00:00 | AAPL | Stock | 179.3 | 179.78 | 179.24 | 179.72 | 11510796.0 |
| 2021-12-15 16:30:00 | AAPL | Stock | 179.77 | 179.79 | 179.3 | 179.56 | 110571.0 |
| 2021-12-15 17:00:00 | AAPL | Stock | 179.56 | 179.74 | 179.54 | 179.74 | 70980.0 |
| 2021-12-15 17:30:00 | AAPL | Stock | 179.74 | 179.95 | 179.7 | 179.88 | 74810.0 |
| 2021-12-15 18:00:00 | AAPL | Stock | 179.88 | 180.3 | 179.75 | 180.17 | 104860.0 |
| 2021-12-15 18:30:00 | AAPL | Stock | 180.18 | 180.28 | 179.88 | 180.0 | 80438.0 |
| 2021-12-15 19:00:00 | AAPL | Stock | 180.0 | 180.08 | 179.72 | 179.74 | 78751.0 |
| 2021-12-15 19:30:00 | AAPL | Stock | 179.74 | 180.05 | 179.7 | 179.72 | 92739.0 |
| 2021-12-15 04:00:00 | MSFT | Stock | 328.73 | 329.4 | 326.46 | 326.46 | 4172.0 |
| 2021-12-15 04:30:00 | MSFT | Stock | 327.21 | 328.3 | 327.21 | 328.27 | 1124.0 |
| 2021-12-15 05:00:00 | MSFT | Stock | 327.49 | 327.69 | 327.49 | 327.69 | 365.0 |
| 2021-12-15 05:30:00 | MSFT | Stock | 328.41 | 328.41 | 328.3 | 328.3 | 1098.0 |
| 2021-12-15 06:00:00 | MSFT | Stock | 328.06 | 328.16 | 327.51 | 327.51 | 336.0 |
| 2021-12-15 06:30:00 | MSFT | Stock | 327.3 | 328.3 | 327.21 | 327.84 | 7333.0 |
| 2021-12-15 07:00:00 | MSFT | Stock | 327.86 | 328.35 | 327.82 | 328.12 | 7269.0 |
| 2021-12-15 07:30:00 | MSFT | Stock | 328.19 | 328.31 | 327.93 | 327.98 | 6410.0 |
| 2021-12-15 08:00:00 | MSFT | Stock | 327.89 | 329.16 | 327.71 | 328.25 | 934808.0 |
| 2021-12-15 08:30:00 | MSFT | Stock | 328.44 | 329.36 | 327.8 | 327.9 | 12861.0 |
| 2021-12-15 09:00:00 | MSFT | Stock | 327.82 | 328.99 | 327.72 | 328.78 | 16637.0 |
| 2021-12-15 09:30:00 | MSFT | Stock | 328.61 | 329.8 | 327.745 | 329.215 | 2164235.0 |
| 2021-12-15 10:00:00 | MSFT | Stock | 329.25 | 330.44 | 328.51 | 329.4801 | 1420607.0 |
| 2021-12-15 10:30:00 | MSFT | Stock | 329.46 | 330.6 | 329.18 | 329.71 | 836640.0 |
| 2021-12-15 11:00:00 | MSFT | Stock | 329.6902 | 329.931 | 327.33 | 327.55 | 979372.0 |
| 2021-12-15 11:30:00 | MSFT | Stock | 327.55 | 327.57 | 325.64 | 325.77 | 1259727.0 |
| 2021-12-15 12:00:00 | MSFT | Stock | 325.76 | 326.57 | 325.652 | 326.09 | 733971.0 |
| 2021-12-15 12:30:00 | MSFT | Stock | 326.09 | 326.14 | 325.2801 | 325.785 | 524511.0 |
> showing 50 of 112,052 rows — these rows as CSV