PREVIEW / stock_30min / 2022-01-26
file: by_date/stock_30min/2022/2022-01-26.parquet size: 2.2 MB rows: 110,229 symbols: 2,637
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-01-26 04:00:00 | AAPL | Stock | 161.53 | 162.8 | 161.53 | 162.7 | 40810.0 |
| 2022-01-26 04:30:00 | AAPL | Stock | 162.77 | 163.41 | 162.75 | 162.94 | 24292.0 |
| 2022-01-26 05:00:00 | AAPL | Stock | 163.0 | 163.25 | 162.59 | 163.08 | 17632.0 |
| 2022-01-26 05:30:00 | AAPL | Stock | 163.2 | 163.29 | 162.86 | 162.86 | 16789.0 |
| 2022-01-26 06:00:00 | AAPL | Stock | 162.89 | 163.34 | 162.83 | 162.95 | 14076.0 |
| 2022-01-26 06:30:00 | AAPL | Stock | 163.07 | 163.51 | 163.07 | 163.46 | 20860.0 |
| 2022-01-26 07:00:00 | AAPL | Stock | 163.29 | 163.43 | 162.45 | 162.77 | 147552.0 |
| 2022-01-26 07:30:00 | AAPL | Stock | 162.92 | 163.35 | 162.7 | 163.34 | 89887.0 |
| 2022-01-26 08:00:00 | AAPL | Stock | 162.8999 | 163.98 | 159.381 | 163.82 | 522114.0 |
| 2022-01-26 08:30:00 | AAPL | Stock | 163.82 | 163.86 | 163.02 | 163.3 | 284952.0 |
| 2022-01-26 09:00:00 | AAPL | Stock | 163.3 | 163.9 | 162.57 | 163.44 | 386887.0 |
| 2022-01-26 09:30:00 | AAPL | Stock | 163.44 | 163.63 | 161.59 | 162.1501 | 10188329.0 |
| 2022-01-26 10:00:00 | AAPL | Stock | 162.14 | 162.95 | 161.5 | 161.76 | 6130963.0 |
| 2022-01-26 10:30:00 | AAPL | Stock | 161.7587 | 162.42 | 161.36 | 162.19 | 5708669.0 |
| 2022-01-26 11:00:00 | AAPL | Stock | 162.2 | 162.9 | 161.77 | 162.7 | 3828593.0 |
| 2022-01-26 11:30:00 | AAPL | Stock | 162.71 | 163.13 | 162.43 | 162.8371 | 3396959.0 |
| 2022-01-26 12:00:00 | AAPL | Stock | 162.8454 | 163.15 | 162.72 | 162.93 | 2984376.0 |
| 2022-01-26 12:30:00 | AAPL | Stock | 162.9396 | 163.5499 | 162.83 | 163.2434 | 3352158.0 |
| 2022-01-26 13:00:00 | AAPL | Stock | 163.25 | 163.275 | 162.57 | 162.8738 | 3500890.0 |
| 2022-01-26 13:30:00 | AAPL | Stock | 162.86 | 163.15 | 162.6827 | 162.78 | 3109433.0 |
| 2022-01-26 14:00:00 | AAPL | Stock | 162.78 | 164.3894 | 161.93 | 163.08 | 7804947.0 |
| 2022-01-26 14:30:00 | AAPL | Stock | 163.08 | 163.5 | 159.08 | 160.5201 | 9591987.0 |
| 2022-01-26 15:00:00 | AAPL | Stock | 160.54 | 160.54 | 157.82 | 159.6 | 8733812.0 |
| 2022-01-26 15:30:00 | AAPL | Stock | 159.59 | 160.245 | 158.17 | 159.75 | 11132737.0 |
| 2022-01-26 16:00:00 | AAPL | Stock | 159.65 | 159.92 | 159.0 | 159.5117 | 8517410.0 |
| 2022-01-26 16:30:00 | AAPL | Stock | 159.6 | 160.42 | 159.2 | 160.27 | 116659.0 |
| 2022-01-26 17:00:00 | AAPL | Stock | 160.25 | 160.75 | 160.1 | 160.7 | 37003.0 |
| 2022-01-26 17:30:00 | AAPL | Stock | 160.66 | 161.47 | 160.35 | 161.0 | 97044.0 |
| 2022-01-26 18:00:00 | AAPL | Stock | 161.03 | 161.6 | 160.77 | 161.4501 | 116054.0 |
| 2022-01-26 18:30:00 | AAPL | Stock | 161.52 | 161.89 | 161.5 | 161.66 | 55019.0 |
| 2022-01-26 19:00:00 | AAPL | Stock | 161.64 | 161.67 | 160.82 | 161.14 | 54339.0 |
| 2022-01-26 19:30:00 | AAPL | Stock | 161.06 | 161.2 | 160.35 | 160.4999 | 79049.0 |
| 2022-01-26 04:00:00 | MSFT | Stock | 295.5 | 297.5 | 295.1 | 297.39 | 63220.0 |
| 2022-01-26 04:30:00 | MSFT | Stock | 297.44 | 299.0 | 297.3 | 298.34 | 33651.0 |
| 2022-01-26 05:00:00 | MSFT | Stock | 298.1 | 299.4 | 297.6 | 299.18 | 32709.0 |
| 2022-01-26 05:30:00 | MSFT | Stock | 299.36 | 300.87 | 299.36 | 300.0 | 42295.0 |
| 2022-01-26 06:00:00 | MSFT | Stock | 299.97 | 300.51 | 298.8 | 299.31 | 44445.0 |
| 2022-01-26 06:30:00 | MSFT | Stock | 299.5 | 300.2 | 299.33 | 299.5 | 15382.0 |
| 2022-01-26 07:00:00 | MSFT | Stock | 299.5 | 299.81 | 298.12 | 299.25 | 236656.0 |
| 2022-01-26 07:30:00 | MSFT | Stock | 299.3 | 300.92 | 298.8 | 300.52 | 193497.0 |
| 2022-01-26 08:00:00 | MSFT | Stock | 299.7179 | 304.67 | 298.1 | 304.15 | 653608.0 |
| 2022-01-26 08:30:00 | MSFT | Stock | 304.15 | 304.87 | 302.76 | 304.75 | 424882.0 |
| 2022-01-26 09:00:00 | MSFT | Stock | 304.75 | 308.75 | 303.6 | 307.88 | 770008.0 |
| 2022-01-26 09:30:00 | MSFT | Stock | 307.99 | 308.5 | 300.33 | 301.3 | 11775009.0 |
| 2022-01-26 10:00:00 | MSFT | Stock | 301.29 | 303.19 | 298.54 | 300.0215 | 6263237.0 |
| 2022-01-26 10:30:00 | MSFT | Stock | 300.06 | 301.2773 | 298.55 | 300.51 | 4563280.0 |
| 2022-01-26 11:00:00 | MSFT | Stock | 300.48 | 301.25 | 299.0 | 300.69 | 3500693.0 |
| 2022-01-26 11:30:00 | MSFT | Stock | 300.69 | 302.29 | 299.88 | 300.08 | 3131171.0 |
| 2022-01-26 12:00:00 | MSFT | Stock | 300.19 | 303.31 | 300.17 | 303.29 | 2445065.0 |
| 2022-01-26 12:30:00 | MSFT | Stock | 303.28 | 304.24 | 302.7 | 303.2095 | 2207603.0 |
> showing 50 of 110,229 rows — these rows as CSV