PREVIEW / stock_30min / 2023-01-17
file: by_date/stock_30min/2023/2023-01-17.parquet size: 2.2 MB rows: 106,003 symbols: 1,938
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 |
|---|---|---|---|---|---|---|---|
| 2023-01-17 04:00:00 | AAPL | Stock | 134.53 | 135.66 | 134.15 | 134.23 | 13072.0 |
| 2023-01-17 04:30:00 | AAPL | Stock | 134.34 | 134.45 | 134.2 | 134.2 | 5173.0 |
| 2023-01-17 05:00:00 | AAPL | Stock | 134.24 | 134.36 | 134.15 | 134.28 | 3689.0 |
| 2023-01-17 05:30:00 | AAPL | Stock | 134.29 | 134.55 | 134.29 | 134.55 | 8468.0 |
| 2023-01-17 06:00:00 | AAPL | Stock | 134.52 | 134.52 | 134.4 | 134.45 | 2122.0 |
| 2023-01-17 06:30:00 | AAPL | Stock | 134.49 | 134.6 | 134.39 | 134.46 | 4893.0 |
| 2023-01-17 07:00:00 | AAPL | Stock | 134.57 | 134.78 | 134.48 | 134.69 | 21149.0 |
| 2023-01-17 07:30:00 | AAPL | Stock | 134.65 | 134.9 | 134.6 | 134.67 | 30444.0 |
| 2023-01-17 08:00:00 | AAPL | Stock | 134.57 | 135.0 | 133.51 | 135.0 | 90636.0 |
| 2023-01-17 08:30:00 | AAPL | Stock | 135.0 | 135.41 | 134.99 | 135.22 | 143657.0 |
| 2023-01-17 09:00:00 | AAPL | Stock | 135.24 | 135.4 | 134.64 | 134.8 | 288286.0 |
| 2023-01-17 09:30:00 | AAPL | Stock | 134.83 | 135.61 | 134.13 | 135.19 | 8140350.0 |
| 2023-01-17 10:00:00 | AAPL | Stock | 135.19 | 137.29 | 135.19 | 136.69 | 7158695.0 |
| 2023-01-17 10:30:00 | AAPL | Stock | 136.7 | 136.7999 | 135.34 | 135.54 | 4953957.0 |
| 2023-01-17 11:00:00 | AAPL | Stock | 135.535 | 135.6699 | 134.68 | 135.395 | 4201984.0 |
| 2023-01-17 11:30:00 | AAPL | Stock | 135.39 | 136.14 | 135.3601 | 135.86 | 2892879.0 |
| 2023-01-17 12:00:00 | AAPL | Stock | 135.87 | 135.96 | 135.31 | 135.59 | 2129790.0 |
| 2023-01-17 12:30:00 | AAPL | Stock | 135.59 | 136.28 | 135.56 | 136.25 | 2420900.0 |
| 2023-01-17 13:00:00 | AAPL | Stock | 136.24 | 136.31 | 135.91 | 136.05 | 2011913.0 |
| 2023-01-17 13:30:00 | AAPL | Stock | 136.06 | 136.4 | 135.93 | 136.055 | 1643749.0 |
| 2023-01-17 14:00:00 | AAPL | Stock | 136.06 | 136.0899 | 135.4 | 135.6606 | 2165110.0 |
| 2023-01-17 14:30:00 | AAPL | Stock | 135.665 | 136.08 | 135.665 | 135.9075 | 2006000.0 |
| 2023-01-17 15:00:00 | AAPL | Stock | 135.895 | 136.08 | 135.6 | 135.705 | 2100768.0 |
| 2023-01-17 15:30:00 | AAPL | Stock | 135.695 | 136.0 | 135.61 | 135.93 | 5057744.0 |
| 2023-01-17 16:00:00 | AAPL | Stock | 135.91 | 136.05 | 135.9 | 136.03 | 7347036.0 |
| 2023-01-17 16:30:00 | AAPL | Stock | 136.03 | 136.04 | 135.94 | 136.02 | 32209.0 |
| 2023-01-17 17:00:00 | AAPL | Stock | 136.0197 | 136.02 | 135.91 | 135.91 | 16646.0 |
| 2023-01-17 17:30:00 | AAPL | Stock | 135.91 | 135.98 | 135.91 | 135.97 | 6842.0 |
| 2023-01-17 18:00:00 | AAPL | Stock | 135.93 | 135.94 | 135.67 | 135.8 | 21799.0 |
| 2023-01-17 18:30:00 | AAPL | Stock | 135.8 | 135.8 | 135.49 | 135.6 | 34865.0 |
| 2023-01-17 19:00:00 | AAPL | Stock | 135.62 | 135.62 | 135.5 | 135.58 | 16788.0 |
| 2023-01-17 19:30:00 | AAPL | Stock | 135.55 | 135.59 | 135.49 | 135.5 | 32157.0 |
| 2023-01-17 04:00:00 | MSFT | Stock | 239.18 | 239.18 | 238.02 | 238.5 | 7320.0 |
| 2023-01-17 04:30:00 | MSFT | Stock | 238.63 | 238.76 | 238.63 | 238.63 | 1033.0 |
| 2023-01-17 05:00:00 | MSFT | Stock | 238.72 | 239.19 | 238.57 | 239.19 | 2871.0 |
| 2023-01-17 05:30:00 | MSFT | Stock | 239.02 | 239.02 | 239.02 | 239.02 | 792.0 |
| 2023-01-17 06:00:00 | MSFT | Stock | 238.8 | 238.8 | 238.8 | 238.8 | 100.0 |
| 2023-01-17 06:30:00 | MSFT | Stock | 238.82 | 238.95 | 238.71 | 238.79 | 2819.0 |
| 2023-01-17 07:00:00 | MSFT | Stock | 239.19 | 239.24 | 238.9 | 239.24 | 4271.0 |
| 2023-01-17 07:30:00 | MSFT | Stock | 239.17 | 239.24 | 235.61 | 236.0 | 97617.0 |
| 2023-01-17 08:00:00 | MSFT | Stock | 238.7636 | 239.29 | 235.65 | 236.49 | 56386.0 |
| 2023-01-17 08:30:00 | MSFT | Stock | 236.55 | 236.8 | 236.01 | 236.31 | 29210.0 |
| 2023-01-17 09:00:00 | MSFT | Stock | 236.15 | 238.6 | 236.07 | 237.97 | 75993.0 |
| 2023-01-17 09:30:00 | MSFT | Stock | 237.87 | 239.78 | 237.09 | 239.73 | 3395643.0 |
| 2023-01-17 10:00:00 | MSFT | Stock | 239.78 | 240.91 | 239.54 | 240.16 | 1695605.0 |
| 2023-01-17 10:30:00 | MSFT | Stock | 240.18 | 240.27 | 238.3606 | 239.68 | 1403847.0 |
| 2023-01-17 11:00:00 | MSFT | Stock | 239.68 | 239.8632 | 238.18 | 238.79 | 1119100.0 |
| 2023-01-17 11:30:00 | MSFT | Stock | 238.78 | 239.52 | 238.74 | 239.34 | 839642.0 |
| 2023-01-17 12:00:00 | MSFT | Stock | 239.36 | 239.63 | 238.92 | 239.18 | 753013.0 |
| 2023-01-17 12:30:00 | MSFT | Stock | 239.18 | 239.73 | 239.11 | 239.5 | 519139.0 |
> showing 50 of 106,003 rows — these rows as CSV