PREVIEW / stock_30min / 2023-01-20
file: by_date/stock_30min/2023/2023-01-20.parquet size: 2.1 MB rows: 103,083 symbols: 1,936
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-20 04:00:00 | AAPL | Stock | 135.6 | 135.63 | 135.25 | 135.59 | 20320.0 |
| 2023-01-20 04:30:00 | AAPL | Stock | 135.42 | 135.43 | 135.24 | 135.24 | 10977.0 |
| 2023-01-20 05:00:00 | AAPL | Stock | 135.25 | 135.33 | 135.18 | 135.26 | 7487.0 |
| 2023-01-20 05:30:00 | AAPL | Stock | 135.33 | 135.4 | 135.28 | 135.4 | 2073.0 |
| 2023-01-20 06:00:00 | AAPL | Stock | 135.44 | 135.56 | 135.13 | 135.35 | 6144.0 |
| 2023-01-20 06:30:00 | AAPL | Stock | 135.3 | 135.4 | 135.21 | 135.27 | 7177.0 |
| 2023-01-20 07:00:00 | AAPL | Stock | 135.36 | 135.88 | 135.36 | 135.83 | 34160.0 |
| 2023-01-20 07:30:00 | AAPL | Stock | 135.83 | 136.29 | 135.83 | 136.17 | 43162.0 |
| 2023-01-20 08:00:00 | AAPL | Stock | 135.85 | 136.29 | 134.932 | 135.84 | 162872.0 |
| 2023-01-20 08:30:00 | AAPL | Stock | 135.81 | 135.81 | 135.38 | 135.46 | 107351.0 |
| 2023-01-20 09:00:00 | AAPL | Stock | 135.48 | 136.0 | 135.05 | 135.21 | 331913.0 |
| 2023-01-20 09:30:00 | AAPL | Stock | 135.27 | 135.29 | 134.22 | 134.6012 | 11456213.0 |
| 2023-01-20 10:00:00 | AAPL | Stock | 134.61 | 135.2 | 134.32 | 135.05 | 4353114.0 |
| 2023-01-20 10:30:00 | AAPL | Stock | 135.06 | 135.4897 | 134.95 | 135.01 | 3867140.0 |
| 2023-01-20 11:00:00 | AAPL | Stock | 135.02 | 135.57 | 135.0 | 135.54 | 3230364.0 |
| 2023-01-20 11:30:00 | AAPL | Stock | 135.54 | 135.6718 | 135.04 | 135.3063 | 2993470.0 |
| 2023-01-20 12:00:00 | AAPL | Stock | 135.31 | 135.76 | 135.305 | 135.645 | 2164710.0 |
| 2023-01-20 12:30:00 | AAPL | Stock | 135.6421 | 135.95 | 135.58 | 135.77 | 1923520.0 |
| 2023-01-20 13:00:00 | AAPL | Stock | 135.7689 | 136.06 | 135.38 | 135.69 | 2935739.0 |
| 2023-01-20 13:30:00 | AAPL | Stock | 135.7 | 136.85 | 135.695 | 136.8301 | 3524243.0 |
| 2023-01-20 14:00:00 | AAPL | Stock | 136.84 | 136.99 | 136.64 | 136.945 | 2546280.0 |
| 2023-01-20 14:30:00 | AAPL | Stock | 136.945 | 137.28 | 136.89 | 137.17 | 2930298.0 |
| 2023-01-20 15:00:00 | AAPL | Stock | 137.17 | 137.89 | 137.1342 | 137.475 | 3908774.0 |
| 2023-01-20 15:30:00 | AAPL | Stock | 137.48 | 138.02 | 137.2606 | 137.84 | 8716528.0 |
| 2023-01-20 16:00:00 | AAPL | Stock | 137.86 | 137.95 | 136.55 | 137.84 | 16189777.0 |
| 2023-01-20 16:30:00 | AAPL | Stock | 137.84 | 137.98 | 137.82 | 137.9 | 62289.0 |
| 2023-01-20 17:00:00 | AAPL | Stock | 137.89 | 137.93 | 137.84 | 137.89 | 26214.0 |
| 2023-01-20 17:30:00 | AAPL | Stock | 137.88 | 137.88 | 137.8216 | 137.88 | 37031.0 |
| 2023-01-20 18:00:00 | AAPL | Stock | 137.86 | 137.91 | 137.8 | 137.9 | 18387.0 |
| 2023-01-20 18:30:00 | AAPL | Stock | 137.9 | 137.93 | 137.9 | 137.9 | 48087.0 |
| 2023-01-20 19:00:00 | AAPL | Stock | 137.91 | 138.07 | 137.91 | 138.04 | 43977.0 |
| 2023-01-20 19:30:00 | AAPL | Stock | 138.07 | 138.18 | 138.04 | 138.1 | 39171.0 |
| 2023-01-20 04:00:00 | MSFT | Stock | 232.46 | 232.46 | 232.03 | 232.29 | 1097.0 |
| 2023-01-20 04:30:00 | MSFT | Stock | 232.45 | 232.48 | 232.29 | 232.31 | 2956.0 |
| 2023-01-20 05:00:00 | MSFT | Stock | 232.21 | 232.75 | 232.21 | 232.75 | 216.0 |
| 2023-01-20 05:30:00 | MSFT | Stock | 232.97 | 233.0 | 232.58 | 232.85 | 1320.0 |
| 2023-01-20 06:00:00 | MSFT | Stock | 232.71 | 232.84 | 232.25 | 232.32 | 2679.0 |
| 2023-01-20 06:30:00 | MSFT | Stock | 232.55 | 232.81 | 232.41 | 232.42 | 4357.0 |
| 2023-01-20 07:00:00 | MSFT | Stock | 232.7 | 232.7 | 232.37 | 232.37 | 4218.0 |
| 2023-01-20 07:30:00 | MSFT | Stock | 232.68 | 233.2 | 232.68 | 232.92 | 4476.0 |
| 2023-01-20 08:00:00 | MSFT | Stock | 232.6 | 233.28 | 231.351 | 232.87 | 22349.0 |
| 2023-01-20 08:30:00 | MSFT | Stock | 232.9 | 233.07 | 231.93 | 232.8 | 82813.0 |
| 2023-01-20 09:00:00 | MSFT | Stock | 232.83 | 235.19 | 232.65 | 234.93 | 315928.0 |
| 2023-01-20 09:30:00 | MSFT | Stock | 234.855 | 236.96 | 234.51 | 235.6942 | 6253450.0 |
| 2023-01-20 10:00:00 | MSFT | Stock | 235.68 | 236.49 | 235.14 | 236.4 | 1288346.0 |
| 2023-01-20 10:30:00 | MSFT | Stock | 236.42 | 236.74 | 235.6328 | 236.09 | 1041036.0 |
| 2023-01-20 11:00:00 | MSFT | Stock | 236.11 | 238.17 | 236.01 | 238.14 | 1193650.0 |
| 2023-01-20 11:30:00 | MSFT | Stock | 238.15 | 238.6662 | 237.87 | 238.531 | 974784.0 |
| 2023-01-20 12:00:00 | MSFT | Stock | 238.52 | 238.81 | 238.21 | 238.445 | 776664.0 |
| 2023-01-20 12:30:00 | MSFT | Stock | 238.42 | 238.84 | 238.117 | 238.31 | 543067.0 |
> showing 50 of 103,083 rows — these rows as CSV