PREVIEW / stock_30min / 2021-12-13
file: by_date/stock_30min/2021/2021-12-13.parquet size: 2.2 MB rows: 111,676 symbols: 2,641
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-13 04:00:00 | AAPL | Stock | 180.45 | 181.37 | 180.37 | 181.19 | 71432.0 |
| 2021-12-13 04:30:00 | AAPL | Stock | 181.23 | 181.28 | 180.92 | 181.1 | 22624.0 |
| 2021-12-13 05:00:00 | AAPL | Stock | 181.1 | 181.2 | 180.99 | 181.06 | 11718.0 |
| 2021-12-13 05:30:00 | AAPL | Stock | 181.09 | 181.42 | 181.02 | 181.4 | 28917.0 |
| 2021-12-13 06:00:00 | AAPL | Stock | 181.33 | 181.5 | 181.2 | 181.2 | 28583.0 |
| 2021-12-13 06:30:00 | AAPL | Stock | 181.29 | 181.34 | 181.02 | 181.06 | 19167.0 |
| 2021-12-13 07:00:00 | AAPL | Stock | 181.07 | 181.8 | 181.04 | 181.7 | 263035.0 |
| 2021-12-13 07:30:00 | AAPL | Stock | 181.69 | 181.98 | 181.55 | 181.8 | 202996.0 |
| 2021-12-13 08:00:00 | AAPL | Stock | 181.2 | 182.22 | 179.002 | 181.87 | 650515.0 |
| 2021-12-13 08:30:00 | AAPL | Stock | 181.88 | 182.2 | 181.6 | 181.75 | 387846.0 |
| 2021-12-13 09:00:00 | AAPL | Stock | 181.77 | 181.8293 | 180.9 | 181.08 | 657366.0 |
| 2021-12-13 09:30:00 | AAPL | Stock | 181.14 | 181.8 | 179.76 | 180.95 | 17881038.0 |
| 2021-12-13 10:00:00 | AAPL | Stock | 180.94 | 182.13 | 178.32 | 178.9597 | 16520521.0 |
| 2021-12-13 10:30:00 | AAPL | Stock | 178.945 | 180.17 | 178.16 | 179.7801 | 12118195.0 |
| 2021-12-13 11:00:00 | AAPL | Stock | 179.7925 | 180.0 | 177.76 | 177.96 | 8505758.0 |
| 2021-12-13 11:30:00 | AAPL | Stock | 177.95 | 178.07 | 177.11 | 177.8517 | 7859508.0 |
| 2021-12-13 12:00:00 | AAPL | Stock | 177.84 | 179.13 | 177.74 | 179.09 | 7910028.0 |
| 2021-12-13 12:30:00 | AAPL | Stock | 179.095 | 179.41 | 178.56 | 178.73 | 5561908.0 |
| 2021-12-13 13:00:00 | AAPL | Stock | 178.73 | 179.15 | 177.76 | 177.77 | 4647014.0 |
| 2021-12-13 13:30:00 | AAPL | Stock | 177.77 | 178.28 | 177.34 | 178.1696 | 5260524.0 |
| 2021-12-13 14:00:00 | AAPL | Stock | 178.16 | 178.64 | 177.79 | 178.255 | 4868504.0 |
| 2021-12-13 14:30:00 | AAPL | Stock | 178.25 | 178.779 | 178.1 | 178.65 | 3873124.0 |
| 2021-12-13 15:00:00 | AAPL | Stock | 178.645 | 178.86 | 177.18 | 177.1902 | 5888900.0 |
| 2021-12-13 15:30:00 | AAPL | Stock | 177.19 | 177.82 | 175.53 | 175.81 | 14815559.0 |
| 2021-12-13 16:00:00 | AAPL | Stock | 175.81 | 175.85 | 175.41 | 175.48 | 12343844.0 |
| 2021-12-13 16:30:00 | AAPL | Stock | 175.45 | 175.85 | 175.4 | 175.74 | 110768.0 |
| 2021-12-13 17:00:00 | AAPL | Stock | 175.74 | 175.8 | 175.3 | 175.34 | 70717.0 |
| 2021-12-13 17:30:00 | AAPL | Stock | 175.29 | 175.48 | 175.07 | 175.17 | 74566.0 |
| 2021-12-13 18:00:00 | AAPL | Stock | 175.2 | 175.6 | 175.19 | 175.35 | 58013.0 |
| 2021-12-13 18:30:00 | AAPL | Stock | 175.43 | 175.74 | 175.21 | 175.49 | 768994.0 |
| 2021-12-13 19:00:00 | AAPL | Stock | 175.49 | 175.64 | 175.43 | 175.59 | 32377.0 |
| 2021-12-13 19:30:00 | AAPL | Stock | 175.57 | 175.71 | 175.45 | 175.69 | 41152.0 |
| 2021-12-13 04:00:00 | MSFT | Stock | 343.48 | 343.66 | 342.56 | 343.66 | 4155.0 |
| 2021-12-13 04:30:00 | MSFT | Stock | 343.56 | 343.56 | 343.5 | 343.5 | 297.0 |
| 2021-12-13 05:00:00 | MSFT | Stock | 343.53 | 343.56 | 343.45 | 343.56 | 1499.0 |
| 2021-12-13 05:30:00 | MSFT | Stock | 343.36 | 343.74 | 343.36 | 343.53 | 3063.0 |
| 2021-12-13 06:00:00 | MSFT | Stock | 343.59 | 343.63 | 343.59 | 343.61 | 2792.0 |
| 2021-12-13 06:30:00 | MSFT | Stock | 343.37 | 343.37 | 342.72 | 342.93 | 2946.0 |
| 2021-12-13 07:00:00 | MSFT | Stock | 342.94 | 343.08 | 342.8 | 343.0 | 10899.0 |
| 2021-12-13 07:30:00 | MSFT | Stock | 343.05 | 343.25 | 342.6 | 342.8 | 15962.0 |
| 2021-12-13 08:00:00 | MSFT | Stock | 343.1199 | 343.17 | 342.662 | 342.82 | 16487.0 |
| 2021-12-13 08:30:00 | MSFT | Stock | 342.82 | 342.98 | 342.6504 | 342.91 | 10031.0 |
| 2021-12-13 09:00:00 | MSFT | Stock | 342.8 | 342.8 | 340.55 | 340.7 | 37132.0 |
| 2021-12-13 09:30:00 | MSFT | Stock | 340.68 | 342.8 | 339.8 | 341.56 | 2562014.0 |
| 2021-12-13 10:00:00 | MSFT | Stock | 341.53 | 343.79 | 340.8 | 342.44 | 1751338.0 |
| 2021-12-13 10:30:00 | MSFT | Stock | 342.42 | 342.42 | 341.22 | 341.75 | 997247.0 |
| 2021-12-13 11:00:00 | MSFT | Stock | 341.73 | 342.0738 | 340.58 | 341.64 | 1115138.0 |
| 2021-12-13 11:30:00 | MSFT | Stock | 341.6699 | 342.16 | 340.76 | 341.095 | 786281.0 |
| 2021-12-13 12:00:00 | MSFT | Stock | 341.095 | 341.45 | 340.4342 | 341.435 | 647000.0 |
| 2021-12-13 12:30:00 | MSFT | Stock | 341.41 | 341.76 | 341.17 | 341.33 | 488231.0 |
> showing 50 of 111,676 rows — these rows as CSV