PREVIEW / stock_30min / 2022-05-16
file: by_date/stock_30min/2022/2022-05-16.parquet size: 2.1 MB rows: 106,567 symbols: 2,432
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-05-16 04:00:00 | AAPL | Stock | 146.68 | 146.68 | 145.66 | 146.05 | 17114.0 |
| 2022-05-16 04:30:00 | AAPL | Stock | 146.05 | 146.53 | 146.02 | 146.53 | 5180.0 |
| 2022-05-16 05:00:00 | AAPL | Stock | 146.55 | 146.67 | 146.3 | 146.3 | 7541.0 |
| 2022-05-16 05:30:00 | AAPL | Stock | 146.24 | 146.26 | 145.7 | 145.7 | 13256.0 |
| 2022-05-16 06:00:00 | AAPL | Stock | 145.82 | 146.15 | 145.82 | 146.14 | 10963.0 |
| 2022-05-16 06:30:00 | AAPL | Stock | 145.93 | 146.14 | 145.81 | 146.14 | 4222.0 |
| 2022-05-16 07:00:00 | AAPL | Stock | 146.19 | 146.45 | 146.09 | 146.25 | 53648.0 |
| 2022-05-16 07:30:00 | AAPL | Stock | 146.25 | 146.5 | 146.08 | 146.39 | 19611.0 |
| 2022-05-16 08:00:00 | AAPL | Stock | 146.18 | 147.0 | 145.99 | 146.95 | 304355.0 |
| 2022-05-16 08:30:00 | AAPL | Stock | 146.95 | 147.39 | 146.7701 | 146.81 | 240879.0 |
| 2022-05-16 09:00:00 | AAPL | Stock | 146.81 | 146.98 | 145.41 | 145.61 | 222908.0 |
| 2022-05-16 09:30:00 | AAPL | Stock | 145.61 | 146.19 | 144.34 | 145.02 | 10365661.0 |
| 2022-05-16 10:00:00 | AAPL | Stock | 145.025 | 146.66 | 144.5921 | 146.5 | 7089060.0 |
| 2022-05-16 10:30:00 | AAPL | Stock | 146.5 | 146.55 | 144.42 | 144.43 | 5273706.0 |
| 2022-05-16 11:00:00 | AAPL | Stock | 144.44 | 145.4 | 144.18 | 145.02 | 4234367.0 |
| 2022-05-16 11:30:00 | AAPL | Stock | 145.0274 | 146.94 | 144.79 | 146.65 | 4896663.0 |
| 2022-05-16 12:00:00 | AAPL | Stock | 146.65 | 146.8 | 145.48 | 145.7301 | 3623390.0 |
| 2022-05-16 12:30:00 | AAPL | Stock | 145.74 | 145.96 | 145.23 | 145.38 | 3044939.0 |
| 2022-05-16 13:00:00 | AAPL | Stock | 145.37 | 146.71 | 145.15 | 146.59 | 3429625.0 |
| 2022-05-16 13:30:00 | AAPL | Stock | 146.575 | 146.769 | 146.0316 | 146.305 | 3400624.0 |
| 2022-05-16 14:00:00 | AAPL | Stock | 146.31 | 147.25 | 146.06 | 147.2387 | 3782288.0 |
| 2022-05-16 14:30:00 | AAPL | Stock | 147.24 | 147.5199 | 146.64 | 146.955 | 4865289.0 |
| 2022-05-16 15:00:00 | AAPL | Stock | 146.9448 | 147.17 | 145.83 | 146.06 | 3782584.0 |
| 2022-05-16 15:30:00 | AAPL | Stock | 146.07 | 146.17 | 145.0 | 145.54 | 7675793.0 |
| 2022-05-16 16:00:00 | AAPL | Stock | 145.56 | 145.6 | 145.27 | 145.36 | 5892723.0 |
| 2022-05-16 16:30:00 | AAPL | Stock | 145.32 | 145.54 | 145.11 | 145.28 | 73183.0 |
| 2022-05-16 17:00:00 | AAPL | Stock | 145.26 | 145.37 | 145.08 | 145.18 | 18471.0 |
| 2022-05-16 17:30:00 | AAPL | Stock | 145.1799 | 145.2046 | 145.06 | 145.2 | 43044.0 |
| 2022-05-16 18:00:00 | AAPL | Stock | 145.21 | 145.52 | 145.2 | 145.46 | 17291.0 |
| 2022-05-16 18:30:00 | AAPL | Stock | 145.41 | 145.64 | 145.41 | 145.6 | 14093.0 |
| 2022-05-16 19:00:00 | AAPL | Stock | 145.6 | 145.75 | 145.6 | 145.63 | 11163.0 |
| 2022-05-16 19:30:00 | AAPL | Stock | 145.6 | 146.01 | 145.42 | 146.01 | 45608.0 |
| 2022-05-16 04:00:00 | MSFT | Stock | 259.07 | 259.6 | 259.04 | 259.6 | 1422.0 |
| 2022-05-16 05:00:00 | MSFT | Stock | 260.55 | 260.55 | 260.1 | 260.1 | 1061.0 |
| 2022-05-16 05:30:00 | MSFT | Stock | 260.1 | 260.18 | 259.51 | 259.52 | 3294.0 |
| 2022-05-16 06:00:00 | MSFT | Stock | 259.9 | 259.92 | 259.75 | 259.75 | 738.0 |
| 2022-05-16 06:30:00 | MSFT | Stock | 259.93 | 259.94 | 259.93 | 259.94 | 300.0 |
| 2022-05-16 07:00:00 | MSFT | Stock | 259.9 | 260.35 | 259.9 | 260.01 | 2517.0 |
| 2022-05-16 07:30:00 | MSFT | Stock | 260.0 | 260.0 | 259.6 | 259.9 | 2180.0 |
| 2022-05-16 08:00:00 | MSFT | Stock | 260.1666 | 261.0 | 259.6 | 260.55 | 35026.0 |
| 2022-05-16 08:30:00 | MSFT | Stock | 261.0 | 262.0 | 260.17 | 260.4729 | 15304.0 |
| 2022-05-16 09:00:00 | MSFT | Stock | 260.5 | 260.65 | 259.09 | 259.7 | 20176.0 |
| 2022-05-16 09:30:00 | MSFT | Stock | 259.99 | 260.13 | 255.78 | 256.6812 | 2711737.0 |
| 2022-05-16 10:00:00 | MSFT | Stock | 256.69 | 258.8 | 255.86 | 258.6 | 1613636.0 |
| 2022-05-16 10:30:00 | MSFT | Stock | 258.5611 | 258.742 | 257.17 | 257.24 | 1206848.0 |
| 2022-05-16 11:00:00 | MSFT | Stock | 257.24 | 259.07 | 256.765 | 258.54 | 1083632.0 |
| 2022-05-16 11:30:00 | MSFT | Stock | 258.52 | 260.73 | 257.97 | 260.365 | 1085728.0 |
| 2022-05-16 12:00:00 | MSFT | Stock | 260.4 | 260.8499 | 259.565 | 260.05 | 910537.0 |
| 2022-05-16 12:30:00 | MSFT | Stock | 260.03 | 260.94 | 259.59 | 260.17 | 982287.0 |
| 2022-05-16 13:00:00 | MSFT | Stock | 260.15 | 262.57 | 259.81 | 262.3899 | 1370058.0 |
> showing 50 of 106,567 rows — these rows as CSV