PREVIEW / stock_30min / 2022-03-04
file: by_date/stock_30min/2022/2022-03-04.parquet size: 2.2 MB rows: 107,668 symbols: 2,515
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-03-04 04:00:00 | AAPL | Stock | 163.72 | 165.24 | 163.72 | 164.52 | 22160.0 |
| 2022-03-04 04:30:00 | AAPL | Stock | 164.78 | 164.78 | 164.37 | 164.4 | 10202.0 |
| 2022-03-04 05:00:00 | AAPL | Stock | 164.3 | 165.0 | 164.3 | 165.0 | 7001.0 |
| 2022-03-04 05:30:00 | AAPL | Stock | 164.8 | 164.83 | 164.71 | 164.71 | 3650.0 |
| 2022-03-04 06:00:00 | AAPL | Stock | 164.56 | 164.94 | 164.31 | 164.5 | 10211.0 |
| 2022-03-04 06:30:00 | AAPL | Stock | 164.64 | 164.8 | 164.57 | 164.8 | 6043.0 |
| 2022-03-04 07:00:00 | AAPL | Stock | 164.61 | 164.74 | 164.08 | 164.12 | 50570.0 |
| 2022-03-04 07:30:00 | AAPL | Stock | 164.21 | 164.88 | 164.18 | 164.72 | 72444.0 |
| 2022-03-04 08:00:00 | AAPL | Stock | 164.5001 | 165.9 | 164.12 | 164.8 | 418527.0 |
| 2022-03-04 08:30:00 | AAPL | Stock | 164.8 | 165.68 | 164.8 | 164.89 | 381260.0 |
| 2022-03-04 09:00:00 | AAPL | Stock | 164.9 | 164.94 | 163.88 | 164.49 | 466570.0 |
| 2022-03-04 09:30:00 | AAPL | Stock | 164.49 | 165.55 | 164.08 | 165.0399 | 7814167.0 |
| 2022-03-04 10:00:00 | AAPL | Stock | 165.04 | 165.3101 | 162.95 | 163.31 | 6824480.0 |
| 2022-03-04 10:30:00 | AAPL | Stock | 163.32 | 163.525 | 162.22 | 162.5801 | 5263194.0 |
| 2022-03-04 11:00:00 | AAPL | Stock | 162.59 | 162.79 | 162.1 | 162.5445 | 4488049.0 |
| 2022-03-04 11:30:00 | AAPL | Stock | 162.55 | 163.16 | 162.26 | 162.76 | 3941375.0 |
| 2022-03-04 12:00:00 | AAPL | Stock | 162.76 | 163.81 | 162.49 | 163.7 | 4819219.0 |
| 2022-03-04 12:30:00 | AAPL | Stock | 163.7099 | 163.95 | 163.1225 | 163.6948 | 3774733.0 |
| 2022-03-04 13:00:00 | AAPL | Stock | 163.7 | 164.465 | 163.46 | 163.475 | 3858457.0 |
| 2022-03-04 13:30:00 | AAPL | Stock | 163.455 | 164.36 | 163.032 | 163.12 | 2958857.0 |
| 2022-03-04 14:00:00 | AAPL | Stock | 163.12 | 163.73 | 162.79 | 163.33 | 3744880.0 |
| 2022-03-04 14:30:00 | AAPL | Stock | 163.32 | 163.6653 | 162.52 | 162.62 | 3106494.0 |
| 2022-03-04 15:00:00 | AAPL | Stock | 162.611 | 163.3 | 162.39 | 162.7 | 4896453.0 |
| 2022-03-04 15:30:00 | AAPL | Stock | 162.705 | 163.53 | 162.13 | 163.22 | 7794862.0 |
| 2022-03-04 16:00:00 | AAPL | Stock | 163.22 | 164.07 | 163.01 | 163.17 | 7988504.0 |
| 2022-03-04 16:30:00 | AAPL | Stock | 163.15 | 163.3 | 162.87 | 163.0622 | 108363.0 |
| 2022-03-04 17:00:00 | AAPL | Stock | 162.99 | 163.2399 | 162.92 | 163.2 | 26614.0 |
| 2022-03-04 17:30:00 | AAPL | Stock | 163.2 | 163.2 | 163.01 | 163.05 | 7984.0 |
| 2022-03-04 18:00:00 | AAPL | Stock | 163.05 | 163.08 | 163.01 | 163.06 | 5081.0 |
| 2022-03-04 18:30:00 | AAPL | Stock | 163.08 | 163.16 | 163.0 | 163.05 | 21789.0 |
| 2022-03-04 19:00:00 | AAPL | Stock | 163.05 | 163.05 | 162.96 | 163.05 | 28842.0 |
| 2022-03-04 19:30:00 | AAPL | Stock | 163.05 | 163.05 | 162.91 | 162.97 | 14759.0 |
| 2022-03-04 04:00:00 | MSFT | Stock | 293.23 | 294.39 | 293.07 | 293.85 | 6348.0 |
| 2022-03-04 04:30:00 | MSFT | Stock | 294.0 | 294.0 | 293.71 | 293.71 | 1030.0 |
| 2022-03-04 05:00:00 | MSFT | Stock | 294.2 | 294.52 | 294.17 | 294.52 | 1087.0 |
| 2022-03-04 05:30:00 | MSFT | Stock | 294.58 | 294.58 | 293.45 | 293.52 | 3609.0 |
| 2022-03-04 06:00:00 | MSFT | Stock | 293.91 | 293.91 | 293.21 | 293.21 | 1043.0 |
| 2022-03-04 06:30:00 | MSFT | Stock | 293.2 | 293.81 | 293.2 | 293.81 | 1314.0 |
| 2022-03-04 07:00:00 | MSFT | Stock | 293.13 | 294.0 | 293.0 | 293.1 | 6379.0 |
| 2022-03-04 07:30:00 | MSFT | Stock | 292.78 | 293.74 | 292.78 | 293.74 | 6871.0 |
| 2022-03-04 08:00:00 | MSFT | Stock | 293.99 | 294.47 | 292.6412 | 293.15 | 18523.0 |
| 2022-03-04 08:30:00 | MSFT | Stock | 293.67 | 294.71 | 292.9 | 293.01 | 27424.0 |
| 2022-03-04 09:00:00 | MSFT | Stock | 293.38 | 294.2 | 293.0 | 294.2 | 25529.0 |
| 2022-03-04 09:30:00 | MSFT | Stock | 294.33 | 295.66 | 289.6401 | 292.18 | 2803514.0 |
| 2022-03-04 10:00:00 | MSFT | Stock | 292.15 | 292.8155 | 289.2835 | 289.95 | 1659848.0 |
| 2022-03-04 10:30:00 | MSFT | Stock | 289.99 | 291.35 | 289.21 | 289.54 | 1212112.0 |
| 2022-03-04 11:00:00 | MSFT | Stock | 289.55 | 289.74 | 287.55 | 287.9 | 1396007.0 |
| 2022-03-04 11:30:00 | MSFT | Stock | 287.89 | 289.11 | 287.165 | 288.9 | 1212514.0 |
| 2022-03-04 12:00:00 | MSFT | Stock | 288.91 | 291.93 | 288.63 | 291.77 | 1441664.0 |
| 2022-03-04 12:30:00 | MSFT | Stock | 291.73 | 291.78 | 289.46 | 290.8001 | 1019286.0 |
> showing 50 of 107,668 rows — these rows as CSV