PREVIEW / stock_30min / 2004-07-21
file: by_date/stock_30min/2004/2004-07-21.parquet size: 798 KB rows: 42,611 symbols: 1,805
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 |
|---|---|---|---|---|---|---|---|
| 2004-07-21 08:00:00 | AAPL | Stock | 0.5782 | 0.5804 | 0.5782 | 0.5804 | 143024.0 |
| 2004-07-21 08:30:00 | AAPL | Stock | 0.5804 | 0.5804 | 0.5786 | 0.5786 | 248976.0 |
| 2004-07-21 09:00:00 | AAPL | Stock | 0.5795 | 0.5795 | 0.5777 | 0.5777 | 337624.0 |
| 2004-07-21 09:30:00 | AAPL | Stock | 0.5768 | 0.5841 | 0.575 | 0.5805 | 45579296.0 |
| 2004-07-21 10:00:00 | AAPL | Stock | 0.5804 | 0.5836 | 0.5804 | 0.5809 | 23556120.0 |
| 2004-07-21 10:30:00 | AAPL | Stock | 0.5809 | 0.5809 | 0.5741 | 0.5746 | 17028536.0 |
| 2004-07-21 11:00:00 | AAPL | Stock | 0.5745 | 0.5764 | 0.5714 | 0.5764 | 15578920.0 |
| 2004-07-21 11:30:00 | AAPL | Stock | 0.5763 | 0.5766 | 0.5729 | 0.5732 | 6015688.0 |
| 2004-07-21 12:00:00 | AAPL | Stock | 0.5732 | 0.5743 | 0.5714 | 0.5729 | 10147760.0 |
| 2004-07-21 12:30:00 | AAPL | Stock | 0.5729 | 0.5757 | 0.5718 | 0.575 | 8579200.0 |
| 2004-07-21 13:00:00 | AAPL | Stock | 0.5748 | 0.575 | 0.5714 | 0.5718 | 7765128.0 |
| 2004-07-21 13:30:00 | AAPL | Stock | 0.5716 | 0.5723 | 0.5696 | 0.5723 | 12571216.0 |
| 2004-07-21 14:00:00 | AAPL | Stock | 0.5721 | 0.5725 | 0.5698 | 0.5711 | 22956808.0 |
| 2004-07-21 14:30:00 | AAPL | Stock | 0.5711 | 0.5732 | 0.5679 | 0.5682 | 23631104.0 |
| 2004-07-21 15:00:00 | AAPL | Stock | 0.568 | 0.5682 | 0.5596 | 0.5645 | 33823104.0 |
| 2004-07-21 15:30:00 | AAPL | Stock | 0.5646 | 0.5684 | 0.5638 | 0.5648 | 49272496.0 |
| 2004-07-21 16:00:00 | AAPL | Stock | 0.565 | 0.5664 | 0.563 | 0.563 | 6567344.0 |
| 2004-07-21 16:30:00 | AAPL | Stock | 0.563 | 0.563 | 0.5598 | 0.5602 | 417200.0 |
| 2004-07-21 17:00:00 | AAPL | Stock | 0.5611 | 0.5611 | 0.5611 | 0.5611 | 1657600.0 |
| 2004-07-21 17:30:00 | AAPL | Stock | 0.5646 | 0.5646 | 0.5616 | 0.5625 | 437696.0 |
| 2004-07-21 08:00:00 | MSFT | Stock | 29.78 | 30.65 | 29.37 | 29.6 | 2460883.0 |
| 2004-07-21 08:30:00 | MSFT | Stock | 29.6 | 29.6 | 29.25 | 29.4 | 1200415.0 |
| 2004-07-21 09:00:00 | MSFT | Stock | 29.42 | 30.75 | 29.38 | 29.55 | 3915027.0 |
| 2004-07-21 09:30:00 | MSFT | Stock | 29.53 | 29.65 | 29.02 | 29.13 | 39846379.0 |
| 2004-07-21 10:00:00 | MSFT | Stock | 29.13 | 29.27 | 29.04 | 29.23 | 18033872.0 |
| 2004-07-21 10:30:00 | MSFT | Stock | 29.23 | 29.29 | 29.18 | 29.26 | 12761534.0 |
| 2004-07-21 11:00:00 | MSFT | Stock | 29.25 | 29.28 | 29.16 | 29.24 | 10640709.0 |
| 2004-07-21 11:30:00 | MSFT | Stock | 29.24 | 29.37 | 29.22 | 29.3 | 10026697.0 |
| 2004-07-21 12:00:00 | MSFT | Stock | 29.3 | 29.32 | 29.15 | 29.19 | 8922611.0 |
| 2004-07-21 12:30:00 | MSFT | Stock | 29.19 | 29.25 | 29.15 | 29.18 | 6825918.0 |
| 2004-07-21 13:00:00 | MSFT | Stock | 29.19 | 29.2 | 28.98 | 29.08 | 10443654.0 |
| 2004-07-21 13:30:00 | MSFT | Stock | 29.08 | 29.13 | 28.86 | 28.94 | 13581966.0 |
| 2004-07-21 14:00:00 | MSFT | Stock | 28.94 | 29.09 | 28.87 | 29.009 | 10238266.0 |
| 2004-07-21 14:30:00 | MSFT | Stock | 29.01 | 29.12 | 28.95 | 29.03 | 8606244.0 |
| 2004-07-21 15:00:00 | MSFT | Stock | 29.03 | 29.04 | 28.95 | 29.01 | 9450424.0 |
| 2004-07-21 15:30:00 | MSFT | Stock | 29.02 | 29.05 | 28.82 | 28.86 | 15939044.0 |
| 2004-07-21 16:00:00 | MSFT | Stock | 28.86 | 28.96 | 28.76 | 28.84 | 3899373.0 |
| 2004-07-21 16:30:00 | MSFT | Stock | 28.8 | 28.86 | 28.78 | 28.8 | 10028951.0 |
| 2004-07-21 17:00:00 | MSFT | Stock | 28.8 | 28.84 | 28.75 | 28.76 | 31850.0 |
| 2004-07-21 17:30:00 | MSFT | Stock | 28.78 | 28.86 | 28.76 | 28.83 | 236903.0 |
| 2004-07-21 18:00:00 | MSFT | Stock | 28.83 | 28.89 | 28.83 | 28.87 | 33031.0 |
| 2004-07-21 08:00:00 | NVDA | Stock | 0.1329 | 0.1329 | 0.1317 | 0.1317 | 339000.0 |
| 2004-07-21 08:30:00 | NVDA | Stock | 0.1317 | 0.1323 | 0.1311 | 0.1317 | 408000.0 |
| 2004-07-21 09:00:00 | NVDA | Stock | 0.1317 | 0.1325 | 0.1317 | 0.1325 | 504000.0 |
| 2004-07-21 09:30:00 | NVDA | Stock | 0.1325 | 0.1327 | 0.131 | 0.1316 | 55163040.0 |
| 2004-07-21 10:00:00 | NVDA | Stock | 0.1317 | 0.1327 | 0.1311 | 0.1317 | 37196640.0 |
| 2004-07-21 10:30:00 | NVDA | Stock | 0.1316 | 0.1317 | 0.1294 | 0.1296 | 34958520.0 |
| 2004-07-21 11:00:00 | NVDA | Stock | 0.1295 | 0.1297 | 0.1269 | 0.1271 | 63469320.0 |
| 2004-07-21 11:30:00 | NVDA | Stock | 0.1271 | 0.1271 | 0.1246 | 0.125 | 101337120.0 |
| 2004-07-21 12:00:00 | NVDA | Stock | 0.1248 | 0.1259 | 0.1234 | 0.1254 | 56162040.0 |
> showing 50 of 42,611 rows — these rows as CSV