PREVIEW / stock_30min / 2022-02-28
file: by_date/stock_30min/2022/2022-02-28.parquet size: 2.2 MB rows: 110,339 symbols: 2,561
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 |
|---|---|---|---|---|---|---|---|
| 2022-02-28 04:00:00 | AAPL | Stock | 163.18 | 163.28 | 161.36 | 162.07 | 37418.0 |
| 2022-02-28 04:30:00 | AAPL | Stock | 161.9 | 162.55 | 161.87 | 162.42 | 9560.0 |
| 2022-02-28 05:00:00 | AAPL | Stock | 162.41 | 162.5 | 162.35 | 162.5 | 1465.0 |
| 2022-02-28 05:30:00 | AAPL | Stock | 162.0 | 162.68 | 161.99 | 162.59 | 5206.0 |
| 2022-02-28 06:00:00 | AAPL | Stock | 162.6 | 162.86 | 162.4 | 162.42 | 9367.0 |
| 2022-02-28 06:30:00 | AAPL | Stock | 162.4 | 162.77 | 162.3 | 162.7 | 15218.0 |
| 2022-02-28 07:00:00 | AAPL | Stock | 162.7 | 163.8 | 162.52 | 163.5 | 115942.0 |
| 2022-02-28 07:30:00 | AAPL | Stock | 163.5 | 163.63 | 162.64 | 162.98 | 60428.0 |
| 2022-02-28 08:00:00 | AAPL | Stock | 162.9 | 163.8 | 161.1 | 163.18 | 294118.0 |
| 2022-02-28 08:30:00 | AAPL | Stock | 163.13 | 163.4 | 162.6601 | 163.03 | 294692.0 |
| 2022-02-28 09:00:00 | AAPL | Stock | 163.01 | 163.5 | 162.88 | 162.97 | 220795.0 |
| 2022-02-28 09:30:00 | AAPL | Stock | 162.97 | 164.81 | 162.78 | 164.74 | 8983122.0 |
| 2022-02-28 10:00:00 | AAPL | Stock | 164.74 | 164.85 | 163.19 | 163.78 | 5037550.0 |
| 2022-02-28 10:30:00 | AAPL | Stock | 163.78 | 165.14 | 163.7599 | 164.84 | 5512450.0 |
| 2022-02-28 11:00:00 | AAPL | Stock | 164.86 | 165.23 | 164.66 | 165.08 | 3648295.0 |
| 2022-02-28 11:30:00 | AAPL | Stock | 165.07 | 165.42 | 164.6 | 164.96 | 3882006.0 |
| 2022-02-28 12:00:00 | AAPL | Stock | 164.96 | 165.23 | 163.99 | 164.3 | 3594220.0 |
| 2022-02-28 12:30:00 | AAPL | Stock | 164.3 | 164.51 | 163.71 | 164.1052 | 3101429.0 |
| 2022-02-28 13:00:00 | AAPL | Stock | 164.1 | 164.9488 | 163.8 | 164.07 | 3165971.0 |
| 2022-02-28 13:30:00 | AAPL | Stock | 164.06 | 164.65 | 163.77 | 164.26 | 2748922.0 |
| 2022-02-28 14:00:00 | AAPL | Stock | 164.26 | 164.26 | 162.5201 | 162.83 | 4097705.0 |
| 2022-02-28 14:30:00 | AAPL | Stock | 162.8201 | 163.65 | 162.43 | 163.43 | 3329587.0 |
| 2022-02-28 15:00:00 | AAPL | Stock | 163.42 | 164.18 | 162.9 | 163.8199 | 3899383.0 |
| 2022-02-28 15:30:00 | AAPL | Stock | 163.81 | 165.4 | 162.64 | 165.13 | 10940347.0 |
| 2022-02-28 16:00:00 | AAPL | Stock | 164.97 | 165.15 | 164.6 | 164.84 | 15202171.0 |
| 2022-02-28 16:30:00 | AAPL | Stock | 164.84 | 165.2 | 164.81 | 164.95 | 51422.0 |
| 2022-02-28 17:00:00 | AAPL | Stock | 165.0 | 165.18 | 164.74 | 164.83 | 13316.0 |
| 2022-02-28 17:30:00 | AAPL | Stock | 164.85 | 164.88 | 164.76 | 164.76 | 12150.0 |
| 2022-02-28 18:00:00 | AAPL | Stock | 164.76 | 165.0 | 164.73 | 164.93 | 33548.0 |
| 2022-02-28 18:30:00 | AAPL | Stock | 164.98 | 165.37 | 164.98 | 165.31 | 46112.0 |
| 2022-02-28 19:00:00 | AAPL | Stock | 165.26 | 165.3 | 165.05 | 165.15 | 14888.0 |
| 2022-02-28 19:30:00 | AAPL | Stock | 165.18 | 165.3 | 164.75 | 164.8 | 31094.0 |
| 2022-02-28 04:00:00 | MSFT | Stock | 295.47 | 295.47 | 292.72 | 292.72 | 2581.0 |
| 2022-02-28 04:30:00 | MSFT | Stock | 292.1 | 292.99 | 292.09 | 292.68 | 4782.0 |
| 2022-02-28 05:00:00 | MSFT | Stock | 292.6 | 292.6 | 292.6 | 292.6 | 143.0 |
| 2022-02-28 05:30:00 | MSFT | Stock | 292.1 | 292.1 | 292.0 | 292.0 | 239.0 |
| 2022-02-28 06:00:00 | MSFT | Stock | 293.01 | 293.01 | 292.6 | 292.82 | 597.0 |
| 2022-02-28 06:30:00 | MSFT | Stock | 292.83 | 292.83 | 292.79 | 292.8 | 2122.0 |
| 2022-02-28 07:00:00 | MSFT | Stock | 292.8 | 294.58 | 292.57 | 294.4 | 13075.0 |
| 2022-02-28 07:30:00 | MSFT | Stock | 294.28 | 294.44 | 292.51 | 292.51 | 10962.0 |
| 2022-02-28 08:00:00 | MSFT | Stock | 293.8 | 294.75 | 292.3685 | 292.9 | 28868.0 |
| 2022-02-28 08:30:00 | MSFT | Stock | 292.89 | 293.0 | 292.0 | 292.696 | 37151.0 |
| 2022-02-28 09:00:00 | MSFT | Stock | 292.4 | 294.99 | 292.4 | 294.5 | 26750.0 |
| 2022-02-28 09:30:00 | MSFT | Stock | 294.44 | 296.92 | 294.2 | 296.49 | 2160525.0 |
| 2022-02-28 10:00:00 | MSFT | Stock | 296.46 | 296.5985 | 293.73 | 294.78 | 1405662.0 |
| 2022-02-28 10:30:00 | MSFT | Stock | 294.75 | 297.69 | 294.73 | 296.83 | 1434236.0 |
| 2022-02-28 11:00:00 | MSFT | Stock | 296.86 | 297.98 | 296.31 | 297.83 | 1122354.0 |
| 2022-02-28 11:30:00 | MSFT | Stock | 297.87 | 298.54 | 296.73 | 297.8656 | 1210364.0 |
| 2022-02-28 12:00:00 | MSFT | Stock | 297.86 | 298.115 | 295.17 | 295.63 | 1300974.0 |
| 2022-02-28 12:30:00 | MSFT | Stock | 295.59 | 295.75 | 294.38 | 294.99 | 1159848.0 |
> showing 50 of 110,339 rows — these rows as CSV