PREVIEW / stock_30min / 2021-09-21
file: by_date/stock_30min/2021/2021-09-21.parquet size: 2.2 MB rows: 108,044 symbols: 2,669
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-21 04:00:00 | AAPL | Stock | 144.72 | 144.8 | 144.11 | 144.46 | 60651.0 |
| 2021-09-21 04:30:00 | AAPL | Stock | 144.5 | 144.8 | 144.45 | 144.55 | 11185.0 |
| 2021-09-21 05:00:00 | AAPL | Stock | 144.5 | 144.6 | 144.15 | 144.45 | 12489.0 |
| 2021-09-21 05:30:00 | AAPL | Stock | 144.45 | 144.69 | 144.39 | 144.53 | 20300.0 |
| 2021-09-21 06:00:00 | AAPL | Stock | 144.59 | 144.6 | 144.4 | 144.59 | 14721.0 |
| 2021-09-21 06:30:00 | AAPL | Stock | 144.47 | 144.54 | 144.4 | 144.5 | 10913.0 |
| 2021-09-21 07:00:00 | AAPL | Stock | 144.45 | 144.53 | 144.05 | 144.2 | 149903.0 |
| 2021-09-21 07:30:00 | AAPL | Stock | 144.2 | 144.35 | 144.04 | 144.31 | 104613.0 |
| 2021-09-21 08:00:00 | AAPL | Stock | 144.1999 | 144.5 | 143.297 | 144.12 | 333514.0 |
| 2021-09-21 08:30:00 | AAPL | Stock | 144.09 | 144.2 | 143.85 | 143.87 | 276970.0 |
| 2021-09-21 09:00:00 | AAPL | Stock | 143.88 | 144.05 | 143.66 | 143.97 | 313353.0 |
| 2021-09-21 09:30:00 | AAPL | Stock | 143.93 | 144.6 | 143.18 | 144.1173 | 11537263.0 |
| 2021-09-21 10:00:00 | AAPL | Stock | 144.11 | 144.3 | 143.38 | 143.79 | 6966274.0 |
| 2021-09-21 10:30:00 | AAPL | Stock | 143.785 | 143.8699 | 142.88 | 143.015 | 5355307.0 |
| 2021-09-21 11:00:00 | AAPL | Stock | 143.02 | 143.9 | 142.78 | 143.52 | 4728529.0 |
| 2021-09-21 11:30:00 | AAPL | Stock | 143.52 | 144.23 | 143.52 | 143.975 | 3879812.0 |
| 2021-09-21 12:00:00 | AAPL | Stock | 143.97 | 144.3599 | 143.92 | 144.0402 | 3418948.0 |
| 2021-09-21 12:30:00 | AAPL | Stock | 144.0413 | 144.27 | 143.73 | 143.87 | 2435380.0 |
| 2021-09-21 13:00:00 | AAPL | Stock | 143.87 | 143.97 | 143.45 | 143.475 | 2642039.0 |
| 2021-09-21 13:30:00 | AAPL | Stock | 143.47 | 143.74 | 143.29 | 143.4538 | 2938392.0 |
| 2021-09-21 14:00:00 | AAPL | Stock | 143.46 | 143.7 | 143.195 | 143.234 | 2643927.0 |
| 2021-09-21 14:30:00 | AAPL | Stock | 143.24 | 144.13 | 143.21 | 143.8463 | 3355940.0 |
| 2021-09-21 15:00:00 | AAPL | Stock | 143.8489 | 144.23 | 143.84 | 144.09 | 3417183.0 |
| 2021-09-21 15:30:00 | AAPL | Stock | 144.08 | 144.2112 | 143.4 | 143.41 | 5952273.0 |
| 2021-09-21 16:00:00 | AAPL | Stock | 143.4 | 143.47 | 143.1 | 143.2 | 5513990.0 |
| 2021-09-21 16:30:00 | AAPL | Stock | 143.2 | 143.25 | 143.07 | 143.23 | 36745.0 |
| 2021-09-21 17:00:00 | AAPL | Stock | 143.23 | 143.43 | 143.07 | 143.14 | 511089.0 |
| 2021-09-21 17:30:00 | AAPL | Stock | 143.17 | 143.2299 | 143.1 | 143.18 | 8656.0 |
| 2021-09-21 18:00:00 | AAPL | Stock | 143.18 | 143.39 | 143.12 | 143.3 | 23483.0 |
| 2021-09-21 18:30:00 | AAPL | Stock | 143.26 | 143.3 | 143.23 | 143.23 | 6071.0 |
| 2021-09-21 19:00:00 | AAPL | Stock | 143.21 | 143.23 | 143.15 | 143.2 | 16276.0 |
| 2021-09-21 19:30:00 | AAPL | Stock | 143.16 | 143.23 | 143.07 | 143.09 | 25549.0 |
| 2021-09-21 04:00:00 | MSFT | Stock | 297.0 | 297.35 | 296.71 | 296.71 | 6137.0 |
| 2021-09-21 04:30:00 | MSFT | Stock | 296.7 | 297.1 | 296.7 | 297.01 | 5396.0 |
| 2021-09-21 05:00:00 | MSFT | Stock | 296.73 | 296.73 | 295.62 | 296.15 | 2525.0 |
| 2021-09-21 05:30:00 | MSFT | Stock | 296.28 | 296.28 | 296.28 | 296.28 | 400.0 |
| 2021-09-21 06:00:00 | MSFT | Stock | 296.13 | 296.19 | 296.06 | 296.06 | 631.0 |
| 2021-09-21 06:30:00 | MSFT | Stock | 296.1 | 296.2 | 296.06 | 296.2 | 2805.0 |
| 2021-09-21 07:00:00 | MSFT | Stock | 296.28 | 296.5 | 296.04 | 296.35 | 24261.0 |
| 2021-09-21 07:30:00 | MSFT | Stock | 296.43 | 296.84 | 296.21 | 296.4 | 20020.0 |
| 2021-09-21 08:00:00 | MSFT | Stock | 296.2999 | 296.65 | 295.035 | 296.0 | 32564.0 |
| 2021-09-21 08:30:00 | MSFT | Stock | 295.8 | 296.31 | 295.5 | 295.55 | 23620.0 |
| 2021-09-21 09:00:00 | MSFT | Stock | 295.6 | 295.9 | 295.33 | 295.59 | 28992.0 |
| 2021-09-21 09:30:00 | MSFT | Stock | 295.59 | 297.54 | 294.07 | 296.5429 | 2395452.0 |
| 2021-09-21 10:00:00 | MSFT | Stock | 296.48 | 296.77 | 294.81 | 295.6 | 1387995.0 |
| 2021-09-21 10:30:00 | MSFT | Stock | 295.6 | 296.03 | 294.35 | 294.69 | 1070102.0 |
| 2021-09-21 11:00:00 | MSFT | Stock | 294.7 | 296.4 | 294.13 | 295.81 | 1154475.0 |
| 2021-09-21 11:30:00 | MSFT | Stock | 295.84 | 296.98 | 295.63 | 296.45 | 758724.0 |
| 2021-09-21 12:00:00 | MSFT | Stock | 296.46 | 296.91 | 295.93 | 295.95 | 669296.0 |
| 2021-09-21 12:30:00 | MSFT | Stock | 295.95 | 296.29 | 295.31 | 295.6 | 655803.0 |
> showing 50 of 108,044 rows — these rows as CSV