PREVIEW / stock_30min / 2021-09-16
file: by_date/stock_30min/2021/2021-09-16.parquet size: 2.2 MB rows: 108,035 symbols: 2,737
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-09-16 04:00:00 | AAPL | Stock | 148.97 | 148.98 | 148.75 | 148.75 | 4857.0 |
| 2021-09-16 04:30:00 | AAPL | Stock | 148.71 | 148.71 | 148.56 | 148.67 | 5045.0 |
| 2021-09-16 05:00:00 | AAPL | Stock | 148.7 | 148.7 | 148.65 | 148.66 | 1525.0 |
| 2021-09-16 05:30:00 | AAPL | Stock | 148.53 | 148.54 | 148.52 | 148.52 | 1029.0 |
| 2021-09-16 06:00:00 | AAPL | Stock | 148.53 | 148.61 | 148.51 | 148.61 | 4888.0 |
| 2021-09-16 06:30:00 | AAPL | Stock | 148.61 | 148.66 | 148.6 | 148.64 | 2114.0 |
| 2021-09-16 07:00:00 | AAPL | Stock | 148.65 | 148.74 | 148.6 | 148.61 | 27804.0 |
| 2021-09-16 07:30:00 | AAPL | Stock | 148.601 | 148.62 | 148.44 | 148.55 | 26400.0 |
| 2021-09-16 08:00:00 | AAPL | Stock | 148.6465 | 148.74 | 148.25 | 148.39 | 215521.0 |
| 2021-09-16 08:30:00 | AAPL | Stock | 148.35 | 148.75 | 148.33 | 148.72 | 180531.0 |
| 2021-09-16 09:00:00 | AAPL | Stock | 148.74 | 148.74 | 148.35 | 148.44 | 208217.0 |
| 2021-09-16 09:30:00 | AAPL | Stock | 148.44 | 148.97 | 147.71 | 147.9099 | 8768098.0 |
| 2021-09-16 10:00:00 | AAPL | Stock | 147.9 | 147.99 | 147.3 | 147.765 | 5971422.0 |
| 2021-09-16 10:30:00 | AAPL | Stock | 147.76 | 147.88 | 147.32 | 147.6899 | 4524658.0 |
| 2021-09-16 11:00:00 | AAPL | Stock | 147.68 | 147.7876 | 147.221 | 147.531 | 4267147.0 |
| 2021-09-16 11:30:00 | AAPL | Stock | 147.53 | 147.85 | 147.46 | 147.7101 | 3155500.0 |
| 2021-09-16 12:00:00 | AAPL | Stock | 147.71 | 148.11 | 147.64 | 147.865 | 3008211.0 |
| 2021-09-16 12:30:00 | AAPL | Stock | 147.875 | 148.25 | 147.86 | 148.1 | 2628945.0 |
| 2021-09-16 13:00:00 | AAPL | Stock | 148.1 | 148.135 | 147.88 | 147.956 | 1802250.0 |
| 2021-09-16 13:30:00 | AAPL | Stock | 147.96 | 148.325 | 147.69 | 148.21 | 3212980.0 |
| 2021-09-16 14:00:00 | AAPL | Stock | 148.2082 | 148.39 | 148.03 | 148.11 | 2866133.0 |
| 2021-09-16 14:30:00 | AAPL | Stock | 148.11 | 148.4876 | 148.07 | 148.425 | 2783972.0 |
| 2021-09-16 15:00:00 | AAPL | Stock | 148.43 | 148.87 | 148.4 | 148.58 | 3704291.0 |
| 2021-09-16 15:30:00 | AAPL | Stock | 148.58 | 148.94 | 148.58 | 148.85 | 6457421.0 |
| 2021-09-16 16:00:00 | AAPL | Stock | 148.79 | 148.85 | 148.61 | 148.78 | 7021920.0 |
| 2021-09-16 16:30:00 | AAPL | Stock | 148.74 | 148.77 | 148.67 | 148.7 | 11859.0 |
| 2021-09-16 17:00:00 | AAPL | Stock | 148.7421 | 148.75 | 148.67 | 148.67 | 11317.0 |
| 2021-09-16 17:30:00 | AAPL | Stock | 148.68 | 148.72 | 148.67 | 148.71 | 4312.0 |
| 2021-09-16 18:00:00 | AAPL | Stock | 148.72 | 148.72 | 148.67 | 148.7 | 7957.0 |
| 2021-09-16 18:30:00 | AAPL | Stock | 148.7 | 148.72 | 148.67 | 148.67 | 12202.0 |
| 2021-09-16 19:00:00 | AAPL | Stock | 148.67 | 148.7 | 148.61 | 148.7 | 17849.0 |
| 2021-09-16 19:30:00 | AAPL | Stock | 148.66 | 148.67 | 148.58 | 148.6 | 20486.0 |
| 2021-09-16 04:00:00 | MSFT | Stock | 305.31 | 305.31 | 304.9 | 304.9 | 2003.0 |
| 2021-09-16 04:30:00 | MSFT | Stock | 304.97 | 304.98 | 304.9 | 304.9 | 722.0 |
| 2021-09-16 05:00:00 | MSFT | Stock | 304.9 | 304.91 | 304.8 | 304.91 | 964.0 |
| 2021-09-16 05:30:00 | MSFT | Stock | 304.5 | 304.55 | 304.49 | 304.5 | 1549.0 |
| 2021-09-16 06:00:00 | MSFT | Stock | 304.51 | 304.51 | 304.46 | 304.5 | 948.0 |
| 2021-09-16 07:00:00 | MSFT | Stock | 304.53 | 304.82 | 304.53 | 304.61 | 3363.0 |
| 2021-09-16 07:30:00 | MSFT | Stock | 304.46 | 304.46 | 304.01 | 304.21 | 1755.0 |
| 2021-09-16 08:00:00 | MSFT | Stock | 304.5562 | 305.582 | 303.82 | 303.99 | 17219.0 |
| 2021-09-16 08:30:00 | MSFT | Stock | 303.99 | 304.23 | 303.61 | 304.02 | 15463.0 |
| 2021-09-16 09:00:00 | MSFT | Stock | 304.0224 | 304.19 | 303.4 | 303.74 | 21931.0 |
| 2021-09-16 09:30:00 | MSFT | Stock | 303.88 | 304.38 | 302.56 | 302.775 | 1746222.0 |
| 2021-09-16 10:00:00 | MSFT | Stock | 302.75 | 302.82 | 300.76 | 301.79 | 1404419.0 |
| 2021-09-16 10:30:00 | MSFT | Stock | 301.79 | 302.15 | 301.0 | 301.54 | 786339.0 |
| 2021-09-16 11:00:00 | MSFT | Stock | 301.52 | 302.06 | 301.2 | 301.695 | 646622.0 |
| 2021-09-16 11:30:00 | MSFT | Stock | 301.67 | 302.02 | 301.39 | 301.82 | 594359.0 |
| 2021-09-16 12:00:00 | MSFT | Stock | 301.83 | 302.45 | 301.65 | 302.01 | 594408.0 |
| 2021-09-16 12:30:00 | MSFT | Stock | 302.04 | 302.71 | 302.04 | 302.5 | 421538.0 |
| 2021-09-16 13:00:00 | MSFT | Stock | 302.49 | 302.85 | 302.26 | 302.54 | 339609.0 |
> showing 50 of 108,035 rows — these rows as CSV