PREVIEW / stock_30min / 2021-11-24
file: by_date/stock_30min/2021/2021-11-24.parquet size: 2.2 MB rows: 109,998 symbols: 2,619
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-24 04:00:00 | AAPL | Stock | 161.5 | 161.5 | 161.03 | 161.44 | 12093.0 |
| 2021-11-24 04:30:00 | AAPL | Stock | 161.44 | 161.44 | 160.9 | 161.1 | 21649.0 |
| 2021-11-24 05:00:00 | AAPL | Stock | 161.08 | 161.24 | 161.08 | 161.16 | 1947.0 |
| 2021-11-24 05:30:00 | AAPL | Stock | 161.11 | 161.18 | 160.67 | 160.86 | 3968.0 |
| 2021-11-24 06:00:00 | AAPL | Stock | 160.7 | 160.98 | 160.59 | 160.97 | 6606.0 |
| 2021-11-24 06:30:00 | AAPL | Stock | 160.97 | 161.23 | 160.81 | 160.81 | 11023.0 |
| 2021-11-24 07:00:00 | AAPL | Stock | 160.98 | 161.0 | 160.85 | 160.95 | 56859.0 |
| 2021-11-24 07:30:00 | AAPL | Stock | 160.94 | 160.95 | 160.73 | 160.74 | 29927.0 |
| 2021-11-24 08:00:00 | AAPL | Stock | 160.92 | 161.08 | 160.7 | 160.8689 | 189119.0 |
| 2021-11-24 08:30:00 | AAPL | Stock | 160.87 | 161.19 | 160.25 | 160.5 | 294899.0 |
| 2021-11-24 09:00:00 | AAPL | Stock | 160.53 | 161.4827 | 160.26 | 160.75 | 327955.0 |
| 2021-11-24 09:30:00 | AAPL | Stock | 160.75 | 161.41 | 159.71 | 159.9604 | 8960056.0 |
| 2021-11-24 10:00:00 | AAPL | Stock | 159.96 | 160.55 | 159.64 | 160.385 | 5672393.0 |
| 2021-11-24 10:30:00 | AAPL | Stock | 160.395 | 161.115 | 160.3 | 161.09 | 5015783.0 |
| 2021-11-24 11:00:00 | AAPL | Stock | 161.08 | 161.88 | 160.7 | 161.75 | 4497804.0 |
| 2021-11-24 11:30:00 | AAPL | Stock | 161.76 | 161.98 | 161.24 | 161.2623 | 3983777.0 |
| 2021-11-24 12:00:00 | AAPL | Stock | 161.26 | 161.63 | 160.92 | 161.1201 | 2987897.0 |
| 2021-11-24 12:30:00 | AAPL | Stock | 161.12 | 161.59 | 161.06 | 161.51 | 2492086.0 |
| 2021-11-24 13:00:00 | AAPL | Stock | 161.5 | 161.74 | 161.18 | 161.35 | 2815497.0 |
| 2021-11-24 13:30:00 | AAPL | Stock | 161.36 | 161.39 | 160.91 | 160.9987 | 2127201.0 |
| 2021-11-24 14:00:00 | AAPL | Stock | 160.9901 | 161.298 | 160.4905 | 160.6915 | 3513469.0 |
| 2021-11-24 14:30:00 | AAPL | Stock | 160.69 | 161.15 | 160.66 | 161.0 | 2340902.0 |
| 2021-11-24 15:00:00 | AAPL | Stock | 161.0 | 161.57 | 160.8 | 161.3375 | 2990630.0 |
| 2021-11-24 15:30:00 | AAPL | Stock | 161.335 | 162.14 | 161.12 | 161.94 | 7191598.0 |
| 2021-11-24 16:00:00 | AAPL | Stock | 162.08 | 162.08 | 161.7 | 161.8 | 4409051.0 |
| 2021-11-24 16:30:00 | AAPL | Stock | 161.78 | 161.94 | 161.67 | 161.82 | 29592.0 |
| 2021-11-24 17:00:00 | AAPL | Stock | 161.87 | 161.94 | 161.86 | 161.9 | 9019.0 |
| 2021-11-24 17:30:00 | AAPL | Stock | 161.92 | 162.16 | 161.9 | 162.04 | 27946.0 |
| 2021-11-24 18:00:00 | AAPL | Stock | 162.05 | 162.06 | 161.91 | 161.92 | 13916.0 |
| 2021-11-24 18:30:00 | AAPL | Stock | 161.91 | 161.99 | 161.85 | 161.94 | 13025.0 |
| 2021-11-24 19:00:00 | AAPL | Stock | 161.94 | 162.04 | 161.94 | 162.04 | 7415.0 |
| 2021-11-24 19:30:00 | AAPL | Stock | 162.04 | 162.2 | 161.96 | 162.2 | 27915.0 |
| 2021-11-24 04:00:00 | MSFT | Stock | 336.65 | 337.46 | 336.0 | 337.46 | 1601.0 |
| 2021-11-24 04:30:00 | MSFT | Stock | 337.4 | 337.4 | 336.35 | 336.35 | 799.0 |
| 2021-11-24 05:00:00 | MSFT | Stock | 337.08 | 337.1 | 337.08 | 337.1 | 206.0 |
| 2021-11-24 05:30:00 | MSFT | Stock | 336.61 | 336.61 | 336.14 | 336.14 | 1498.0 |
| 2021-11-24 06:00:00 | MSFT | Stock | 335.98 | 336.09 | 335.98 | 336.09 | 1100.0 |
| 2021-11-24 06:30:00 | MSFT | Stock | 336.4 | 337.31 | 336.4 | 337.01 | 2653.0 |
| 2021-11-24 07:00:00 | MSFT | Stock | 337.04 | 337.11 | 336.16 | 336.5 | 5862.0 |
| 2021-11-24 07:30:00 | MSFT | Stock | 336.2 | 336.91 | 336.2 | 336.91 | 1728.0 |
| 2021-11-24 08:00:00 | MSFT | Stock | 336.6 | 337.15 | 336.1666 | 337.15 | 6622.0 |
| 2021-11-24 08:30:00 | MSFT | Stock | 336.95 | 337.75 | 335.8 | 335.95 | 18804.0 |
| 2021-11-24 09:00:00 | MSFT | Stock | 335.94 | 336.93 | 335.47 | 336.48 | 28346.0 |
| 2021-11-24 09:30:00 | MSFT | Stock | 336.22 | 336.58 | 333.911 | 335.075 | 1740029.0 |
| 2021-11-24 10:00:00 | MSFT | Stock | 335.01 | 336.39 | 334.04 | 336.28 | 1385685.0 |
| 2021-11-24 10:30:00 | MSFT | Stock | 336.26 | 336.44 | 334.83 | 335.46 | 851022.0 |
| 2021-11-24 11:00:00 | MSFT | Stock | 335.45 | 336.31 | 334.71 | 336.1 | 792777.0 |
| 2021-11-24 11:30:00 | MSFT | Stock | 336.11 | 336.73 | 335.805 | 335.93 | 666287.0 |
| 2021-11-24 12:00:00 | MSFT | Stock | 335.92 | 336.5 | 335.8 | 335.9201 | 483793.0 |
| 2021-11-24 12:30:00 | MSFT | Stock | 335.92 | 336.62 | 335.8817 | 336.28 | 370575.0 |
> showing 50 of 109,998 rows — these rows as CSV