PREVIEW / stock_30min / 2022-05-24
file: by_date/stock_30min/2022/2022-05-24.parquet size: 2.1 MB rows: 104,862 symbols: 2,399
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-24 04:00:00 | AAPL | Stock | 140.69 | 141.0 | 139.9 | 140.7 | 48299.0 |
| 2022-05-24 04:30:00 | AAPL | Stock | 140.74 | 140.77 | 140.41 | 140.43 | 10857.0 |
| 2022-05-24 05:00:00 | AAPL | Stock | 140.5 | 140.61 | 140.4 | 140.61 | 6302.0 |
| 2022-05-24 05:30:00 | AAPL | Stock | 140.56 | 141.0 | 140.56 | 141.0 | 10500.0 |
| 2022-05-24 06:00:00 | AAPL | Stock | 140.96 | 141.24 | 140.85 | 141.08 | 20973.0 |
| 2022-05-24 06:30:00 | AAPL | Stock | 141.06 | 141.14 | 140.95 | 141.0 | 12533.0 |
| 2022-05-24 07:00:00 | AAPL | Stock | 141.05 | 141.45 | 140.95 | 141.43 | 80618.0 |
| 2022-05-24 07:30:00 | AAPL | Stock | 141.4 | 141.5 | 140.91 | 141.0 | 60130.0 |
| 2022-05-24 08:00:00 | AAPL | Stock | 141.25 | 141.5 | 140.72 | 140.92 | 530394.0 |
| 2022-05-24 08:30:00 | AAPL | Stock | 140.92 | 141.5 | 140.8 | 141.19 | 363730.0 |
| 2022-05-24 09:00:00 | AAPL | Stock | 141.21 | 141.3344 | 140.63 | 140.84 | 204108.0 |
| 2022-05-24 09:30:00 | AAPL | Stock | 140.83 | 141.97 | 139.23 | 139.33 | 12747098.0 |
| 2022-05-24 10:00:00 | AAPL | Stock | 139.33 | 139.34 | 137.33 | 138.48 | 9899649.0 |
| 2022-05-24 10:30:00 | AAPL | Stock | 138.49 | 138.87 | 137.8 | 138.17 | 6918738.0 |
| 2022-05-24 11:00:00 | AAPL | Stock | 138.17 | 138.59 | 137.86 | 138.42 | 4722088.0 |
| 2022-05-24 11:30:00 | AAPL | Stock | 138.4298 | 139.555 | 138.05 | 139.17 | 5220363.0 |
| 2022-05-24 12:00:00 | AAPL | Stock | 139.175 | 140.27 | 138.9493 | 139.3 | 4920468.0 |
| 2022-05-24 12:30:00 | AAPL | Stock | 139.3 | 139.42 | 138.52 | 139.11 | 4007830.0 |
| 2022-05-24 13:00:00 | AAPL | Stock | 139.11 | 139.1259 | 138.15 | 138.525 | 3893678.0 |
| 2022-05-24 13:30:00 | AAPL | Stock | 138.53 | 139.7 | 138.165 | 139.3209 | 4291584.0 |
| 2022-05-24 14:00:00 | AAPL | Stock | 139.34 | 140.11 | 138.945 | 139.47 | 5058226.0 |
| 2022-05-24 14:30:00 | AAPL | Stock | 139.46 | 140.22 | 138.69 | 139.11 | 5472348.0 |
| 2022-05-24 15:00:00 | AAPL | Stock | 139.105 | 139.99 | 138.95 | 139.74 | 5863657.0 |
| 2022-05-24 15:30:00 | AAPL | Stock | 139.736 | 140.9405 | 139.71 | 140.42 | 11838164.0 |
| 2022-05-24 16:00:00 | AAPL | Stock | 140.52 | 140.87 | 140.29 | 140.39 | 5517191.0 |
| 2022-05-24 16:30:00 | AAPL | Stock | 140.4 | 140.78 | 140.36 | 140.69 | 123591.0 |
| 2022-05-24 17:00:00 | AAPL | Stock | 140.66 | 140.77 | 140.64 | 140.67 | 19589.0 |
| 2022-05-24 17:30:00 | AAPL | Stock | 140.64 | 140.77 | 140.61 | 140.75 | 18036.0 |
| 2022-05-24 18:00:00 | AAPL | Stock | 140.74 | 141.19 | 140.69 | 141.09 | 46956.0 |
| 2022-05-24 18:30:00 | AAPL | Stock | 141.07 | 141.32 | 141.01 | 141.24 | 32376.0 |
| 2022-05-24 19:00:00 | AAPL | Stock | 141.27 | 141.59 | 141.22 | 141.44 | 59237.0 |
| 2022-05-24 19:30:00 | AAPL | Stock | 141.48 | 141.6 | 141.32 | 141.6 | 34077.0 |
| 2022-05-24 04:00:00 | MSFT | Stock | 256.89 | 257.79 | 256.77 | 257.05 | 7890.0 |
| 2022-05-24 04:30:00 | MSFT | Stock | 257.4 | 257.4 | 256.75 | 256.75 | 4091.0 |
| 2022-05-24 05:00:00 | MSFT | Stock | 257.01 | 257.16 | 256.7 | 257.16 | 1449.0 |
| 2022-05-24 05:30:00 | MSFT | Stock | 257.22 | 258.0 | 257.22 | 257.62 | 2704.0 |
| 2022-05-24 06:00:00 | MSFT | Stock | 257.59 | 257.91 | 257.59 | 257.8 | 3054.0 |
| 2022-05-24 06:30:00 | MSFT | Stock | 257.87 | 257.87 | 257.59 | 257.59 | 450.0 |
| 2022-05-24 07:00:00 | MSFT | Stock | 257.74 | 258.5 | 257.74 | 258.28 | 8211.0 |
| 2022-05-24 07:30:00 | MSFT | Stock | 258.35 | 258.5 | 257.61 | 257.61 | 3779.0 |
| 2022-05-24 08:00:00 | MSFT | Stock | 257.851 | 259.999 | 257.39 | 257.8281 | 16830.0 |
| 2022-05-24 08:30:00 | MSFT | Stock | 257.92 | 258.49 | 257.92 | 258.16 | 11055.0 |
| 2022-05-24 09:00:00 | MSFT | Stock | 258.21 | 258.39 | 257.65 | 257.95 | 18847.0 |
| 2022-05-24 09:30:00 | MSFT | Stock | 257.87 | 259.523 | 256.319 | 256.465 | 2695852.0 |
| 2022-05-24 10:00:00 | MSFT | Stock | 256.44 | 256.92 | 253.5 | 254.8874 | 2559802.0 |
| 2022-05-24 10:30:00 | MSFT | Stock | 254.885 | 256.09 | 254.255 | 255.14 | 1484316.0 |
| 2022-05-24 11:00:00 | MSFT | Stock | 255.15 | 256.24 | 254.72 | 255.75 | 890320.0 |
| 2022-05-24 11:30:00 | MSFT | Stock | 255.7811 | 257.91 | 255.33 | 257.38 | 922450.0 |
| 2022-05-24 12:00:00 | MSFT | Stock | 257.36 | 259.57 | 257.17 | 258.1 | 1073940.0 |
| 2022-05-24 12:30:00 | MSFT | Stock | 258.0831 | 258.25 | 256.98 | 257.9 | 732209.0 |
> showing 50 of 104,862 rows — these rows as CSV