PREVIEW / stock_30min / 2023-05-15
file: by_date/stock_30min/2023/2023-05-15.parquet size: 2.1 MB rows: 101,157 symbols: 1,669
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-05-15 04:00:00 | AAPL | Stock | 172.59 | 173.0 | 172.59 | 172.99 | 8264.0 |
| 2023-05-15 04:30:00 | AAPL | Stock | 172.94 | 172.99 | 172.75 | 172.75 | 7457.0 |
| 2023-05-15 05:00:00 | AAPL | Stock | 172.89 | 172.94 | 172.88 | 172.91 | 4296.0 |
| 2023-05-15 05:30:00 | AAPL | Stock | 172.85 | 172.91 | 172.85 | 172.9 | 8102.0 |
| 2023-05-15 06:00:00 | AAPL | Stock | 172.89 | 172.9 | 172.78 | 172.9 | 2125.0 |
| 2023-05-15 06:30:00 | AAPL | Stock | 172.94 | 172.95 | 172.9 | 172.9 | 1342.0 |
| 2023-05-15 07:00:00 | AAPL | Stock | 172.9 | 173.32 | 172.86 | 173.25 | 50872.0 |
| 2023-05-15 07:30:00 | AAPL | Stock | 173.26 | 173.28 | 172.95 | 173.0 | 41549.0 |
| 2023-05-15 08:00:00 | AAPL | Stock | 172.9219 | 173.3 | 172.16 | 172.94 | 87412.0 |
| 2023-05-15 08:30:00 | AAPL | Stock | 172.98 | 173.18 | 172.8 | 173.09 | 52863.0 |
| 2023-05-15 09:00:00 | AAPL | Stock | 173.1 | 173.26 | 172.8 | 173.16 | 110655.0 |
| 2023-05-15 09:30:00 | AAPL | Stock | 173.16 | 173.21 | 171.83 | 171.98 | 4969092.0 |
| 2023-05-15 10:00:00 | AAPL | Stock | 171.975 | 172.1 | 171.47 | 171.8429 | 2638944.0 |
| 2023-05-15 10:30:00 | AAPL | Stock | 171.84 | 172.28 | 171.8001 | 171.905 | 2198232.0 |
| 2023-05-15 11:00:00 | AAPL | Stock | 171.905 | 172.42 | 171.88 | 172.27 | 1680031.0 |
| 2023-05-15 11:30:00 | AAPL | Stock | 172.26 | 172.37 | 171.97 | 172.3518 | 1521922.0 |
| 2023-05-15 12:00:00 | AAPL | Stock | 172.365 | 172.43 | 172.12 | 172.1787 | 1067369.0 |
| 2023-05-15 12:30:00 | AAPL | Stock | 172.173 | 172.23 | 171.94 | 172.19 | 1238831.0 |
| 2023-05-15 13:00:00 | AAPL | Stock | 172.2 | 172.3 | 171.82 | 171.847 | 1495523.0 |
| 2023-05-15 13:30:00 | AAPL | Stock | 171.85 | 171.965 | 171.525 | 171.865 | 1774922.0 |
| 2023-05-15 14:00:00 | AAPL | Stock | 171.87 | 172.02 | 171.7 | 171.815 | 1290194.0 |
| 2023-05-15 14:30:00 | AAPL | Stock | 171.825 | 171.91 | 171.66 | 171.73 | 1152262.0 |
| 2023-05-15 15:00:00 | AAPL | Stock | 171.73 | 171.91 | 171.67 | 171.8122 | 1351058.0 |
| 2023-05-15 15:30:00 | AAPL | Stock | 171.81 | 172.185 | 171.7527 | 172.14 | 3242671.0 |
| 2023-05-15 16:00:00 | AAPL | Stock | 172.14 | 172.19 | 170.07 | 172.14 | 4871168.0 |
| 2023-05-15 16:30:00 | AAPL | Stock | 172.14 | 172.14 | 171.96 | 171.97 | 26053.0 |
| 2023-05-15 17:00:00 | AAPL | Stock | 171.99 | 172.05 | 171.98 | 172.03 | 5860.0 |
| 2023-05-15 17:30:00 | AAPL | Stock | 172.01 | 172.03 | 171.97 | 172.03 | 5057.0 |
| 2023-05-15 18:00:00 | AAPL | Stock | 171.97 | 172.03 | 171.95 | 172.0 | 5211.0 |
| 2023-05-15 18:30:00 | AAPL | Stock | 172.05 | 172.14 | 172.0 | 172.03 | 2632.0 |
| 2023-05-15 19:00:00 | AAPL | Stock | 172.02 | 172.04 | 171.94 | 172.0 | 5774.0 |
| 2023-05-15 19:30:00 | AAPL | Stock | 171.99 | 172.0 | 171.93 | 172.0 | 7843.0 |
| 2023-05-15 04:00:00 | MSFT | Stock | 309.08 | 309.61 | 309.02 | 309.46 | 1118.0 |
| 2023-05-15 04:30:00 | MSFT | Stock | 309.55 | 309.85 | 309.55 | 309.6 | 1552.0 |
| 2023-05-15 05:00:00 | MSFT | Stock | 309.84 | 309.89 | 309.7 | 309.78 | 895.0 |
| 2023-05-15 05:30:00 | MSFT | Stock | 309.64 | 309.65 | 309.64 | 309.65 | 200.0 |
| 2023-05-15 06:00:00 | MSFT | Stock | 309.25 | 309.48 | 309.25 | 309.47 | 1862.0 |
| 2023-05-15 07:00:00 | MSFT | Stock | 309.54 | 309.7 | 309.47 | 309.56 | 4043.0 |
| 2023-05-15 07:30:00 | MSFT | Stock | 309.65 | 309.65 | 309.26 | 309.33 | 2535.0 |
| 2023-05-15 08:00:00 | MSFT | Stock | 309.5516 | 309.8 | 308.6 | 308.94 | 11626.0 |
| 2023-05-15 08:30:00 | MSFT | Stock | 308.89 | 309.645 | 308.8 | 309.47 | 14193.0 |
| 2023-05-15 09:00:00 | MSFT | Stock | 309.55 | 309.75 | 308.86 | 309.16 | 19677.0 |
| 2023-05-15 09:30:00 | MSFT | Stock | 309.18 | 309.59 | 307.64 | 308.79 | 2009086.0 |
| 2023-05-15 10:00:00 | MSFT | Stock | 308.83 | 309.38 | 307.655 | 307.68 | 945609.0 |
| 2023-05-15 10:30:00 | MSFT | Stock | 307.66 | 309.905 | 307.59 | 309.18 | 1087242.0 |
| 2023-05-15 11:00:00 | MSFT | Stock | 309.185 | 309.8815 | 308.7801 | 309.58 | 711804.0 |
| 2023-05-15 11:30:00 | MSFT | Stock | 309.57 | 309.8 | 309.19 | 309.7799 | 453818.0 |
| 2023-05-15 12:00:00 | MSFT | Stock | 309.8 | 309.84 | 308.9 | 309.1299 | 388596.0 |
| 2023-05-15 12:30:00 | MSFT | Stock | 309.12 | 309.1864 | 308.47 | 308.96 | 528458.0 |
| 2023-05-15 13:00:00 | MSFT | Stock | 308.9701 | 309.73 | 308.72 | 309.02 | 528371.0 |
> showing 50 of 101,157 rows — these rows as CSV