PREVIEW / stock_30min / 2021-11-15
file: by_date/stock_30min/2021/2021-11-15.parquet size: 2.3 MB rows: 116,336 symbols: 2,697
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-11-15 04:00:00 | AAPL | Stock | 150.0 | 150.37 | 149.76 | 150.11 | 14113.0 |
| 2021-11-15 04:30:00 | AAPL | Stock | 150.05 | 150.11 | 150.05 | 150.1 | 3666.0 |
| 2021-11-15 05:00:00 | AAPL | Stock | 150.15 | 150.24 | 150.14 | 150.18 | 3821.0 |
| 2021-11-15 05:30:00 | AAPL | Stock | 150.16 | 150.16 | 150.1 | 150.11 | 1377.0 |
| 2021-11-15 06:00:00 | AAPL | Stock | 150.11 | 150.15 | 150.06 | 150.06 | 18321.0 |
| 2021-11-15 06:30:00 | AAPL | Stock | 150.09 | 150.16 | 150.09 | 150.16 | 3732.0 |
| 2021-11-15 07:00:00 | AAPL | Stock | 150.2 | 150.29 | 150.14 | 150.26 | 26949.0 |
| 2021-11-15 07:30:00 | AAPL | Stock | 150.27 | 150.5 | 150.27 | 150.42 | 33485.0 |
| 2021-11-15 08:00:00 | AAPL | Stock | 150.1801 | 151.06 | 149.616 | 150.97 | 172332.0 |
| 2021-11-15 08:30:00 | AAPL | Stock | 150.95 | 151.13 | 150.76 | 150.81 | 128905.0 |
| 2021-11-15 09:00:00 | AAPL | Stock | 150.81 | 150.84 | 150.15 | 150.23 | 189078.0 |
| 2021-11-15 09:30:00 | AAPL | Stock | 150.33 | 151.88 | 150.29 | 150.955 | 8377627.0 |
| 2021-11-15 10:00:00 | AAPL | Stock | 150.96 | 151.01 | 150.25 | 150.4409 | 3627540.0 |
| 2021-11-15 10:30:00 | AAPL | Stock | 150.44 | 150.92 | 150.291 | 150.33 | 3144231.0 |
| 2021-11-15 11:00:00 | AAPL | Stock | 150.32 | 150.53 | 149.955 | 150.06 | 2457590.0 |
| 2021-11-15 11:30:00 | AAPL | Stock | 150.0501 | 150.3 | 149.43 | 149.7799 | 3089076.0 |
| 2021-11-15 12:00:00 | AAPL | Stock | 149.77 | 150.0 | 149.54 | 149.6699 | 1854719.0 |
| 2021-11-15 12:30:00 | AAPL | Stock | 149.6667 | 150.2361 | 149.655 | 150.04 | 1692554.0 |
| 2021-11-15 13:00:00 | AAPL | Stock | 150.04 | 150.14 | 149.91 | 150.03 | 1343936.0 |
| 2021-11-15 13:30:00 | AAPL | Stock | 150.03 | 150.13 | 149.89 | 149.915 | 1366607.0 |
| 2021-11-15 14:00:00 | AAPL | Stock | 149.92 | 149.96 | 149.76 | 149.875 | 1397713.0 |
| 2021-11-15 14:30:00 | AAPL | Stock | 149.875 | 150.205 | 149.83 | 149.995 | 1415791.0 |
| 2021-11-15 15:00:00 | AAPL | Stock | 149.99 | 150.25 | 149.9 | 150.2201 | 2301021.0 |
| 2021-11-15 15:30:00 | AAPL | Stock | 150.23 | 150.26 | 149.75 | 150.0 | 4544539.0 |
| 2021-11-15 16:00:00 | AAPL | Stock | 150.0 | 150.0 | 149.89 | 149.99 | 8673462.0 |
| 2021-11-15 16:30:00 | AAPL | Stock | 149.98 | 150.1 | 149.94 | 149.96 | 58561.0 |
| 2021-11-15 17:00:00 | AAPL | Stock | 149.98 | 149.99 | 149.95 | 149.99 | 7153.0 |
| 2021-11-15 17:30:00 | AAPL | Stock | 149.98 | 149.99 | 149.97 | 149.97 | 10757.0 |
| 2021-11-15 18:00:00 | AAPL | Stock | 149.99 | 150.0 | 149.97 | 149.98 | 24905.0 |
| 2021-11-15 18:30:00 | AAPL | Stock | 149.98 | 150.0 | 149.98 | 149.99 | 24920.0 |
| 2021-11-15 19:00:00 | AAPL | Stock | 149.99 | 150.0 | 149.93 | 149.93 | 32638.0 |
| 2021-11-15 19:30:00 | AAPL | Stock | 149.94 | 150.01 | 149.9 | 150.01 | 56824.0 |
| 2021-11-15 04:00:00 | MSFT | Stock | 337.7 | 338.59 | 337.7 | 338.44 | 4689.0 |
| 2021-11-15 04:30:00 | MSFT | Stock | 338.5 | 338.95 | 338.4 | 338.85 | 6269.0 |
| 2021-11-15 05:00:00 | MSFT | Stock | 338.86 | 339.6 | 338.86 | 339.48 | 4873.0 |
| 2021-11-15 05:30:00 | MSFT | Stock | 339.3 | 339.34 | 338.95 | 339.21 | 2473.0 |
| 2021-11-15 06:00:00 | MSFT | Stock | 339.08 | 339.2 | 339.0 | 339.0 | 1574.0 |
| 2021-11-15 06:30:00 | MSFT | Stock | 338.78 | 338.78 | 338.78 | 338.78 | 106.0 |
| 2021-11-15 07:00:00 | MSFT | Stock | 338.75 | 339.05 | 338.57 | 338.57 | 11481.0 |
| 2021-11-15 07:30:00 | MSFT | Stock | 338.6 | 338.8 | 338.57 | 338.8 | 4382.0 |
| 2021-11-15 08:00:00 | MSFT | Stock | 339.01 | 339.736 | 337.561 | 339.6 | 34307.0 |
| 2021-11-15 08:30:00 | MSFT | Stock | 339.5999 | 339.6 | 339.0559 | 339.2 | 14476.0 |
| 2021-11-15 09:00:00 | MSFT | Stock | 339.1203 | 339.2 | 336.8628 | 337.58 | 72659.0 |
| 2021-11-15 09:30:00 | MSFT | Stock | 337.54 | 337.93 | 335.56 | 336.335 | 2163782.0 |
| 2021-11-15 10:00:00 | MSFT | Stock | 336.39 | 336.39 | 334.62 | 334.975 | 1094317.0 |
| 2021-11-15 10:30:00 | MSFT | Stock | 334.96 | 335.41 | 334.78 | 335.3 | 871515.0 |
| 2021-11-15 11:00:00 | MSFT | Stock | 335.31 | 335.6999 | 335.0035 | 335.17 | 513223.0 |
| 2021-11-15 11:30:00 | MSFT | Stock | 335.19 | 335.82 | 334.225 | 334.98 | 748560.0 |
| 2021-11-15 12:00:00 | MSFT | Stock | 335.0 | 335.31 | 334.034 | 334.18 | 512494.0 |
| 2021-11-15 12:30:00 | MSFT | Stock | 334.15 | 335.065 | 334.13 | 334.84 | 395710.0 |
> showing 50 of 116,336 rows — these rows as CSV