PREVIEW / stock_30min / 2004-12-09
file: by_date/stock_30min/2004/2004-12-09.parquet size: 802 KB rows: 42,244 symbols: 1,887
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-12-09 08:00:00 | AAPL | Stock | 1.1268 | 1.1295 | 1.1214 | 1.1223 | 180600.0 |
| 2004-12-09 08:30:00 | AAPL | Stock | 1.1238 | 1.125 | 1.1214 | 1.1214 | 270480.0 |
| 2004-12-09 09:00:00 | AAPL | Stock | 1.125 | 1.1291 | 1.1198 | 1.1198 | 1100680.0 |
| 2004-12-09 09:30:00 | AAPL | Stock | 1.1205 | 1.1223 | 1.1084 | 1.12 | 95902968.0 |
| 2004-12-09 10:00:00 | AAPL | Stock | 1.1195 | 1.1241 | 1.1116 | 1.1141 | 82439336.0 |
| 2004-12-09 10:30:00 | AAPL | Stock | 1.1139 | 1.1241 | 1.11 | 1.1232 | 58995496.0 |
| 2004-12-09 11:00:00 | AAPL | Stock | 1.1232 | 1.1236 | 1.1161 | 1.1179 | 35538552.0 |
| 2004-12-09 11:30:00 | AAPL | Stock | 1.1173 | 1.1188 | 1.1138 | 1.1177 | 22226456.0 |
| 2004-12-09 12:00:00 | AAPL | Stock | 1.1177 | 1.1205 | 1.1143 | 1.1189 | 24931312.0 |
| 2004-12-09 12:30:00 | AAPL | Stock | 1.1191 | 1.123 | 1.1175 | 1.1198 | 27758640.0 |
| 2004-12-09 13:00:00 | AAPL | Stock | 1.1202 | 1.135 | 1.118 | 1.1309 | 78645560.0 |
| 2004-12-09 13:30:00 | AAPL | Stock | 1.1313 | 1.1373 | 1.1259 | 1.1302 | 50787632.0 |
| 2004-12-09 14:00:00 | AAPL | Stock | 1.1296 | 1.1309 | 1.1214 | 1.1245 | 30418304.0 |
| 2004-12-09 14:30:00 | AAPL | Stock | 1.1246 | 1.1398 | 1.1225 | 1.1393 | 42221368.0 |
| 2004-12-09 15:00:00 | AAPL | Stock | 1.1391 | 1.15 | 1.138 | 1.145 | 92888992.0 |
| 2004-12-09 15:30:00 | AAPL | Stock | 1.1452 | 1.1491 | 1.1373 | 1.142 | 78228528.0 |
| 2004-12-09 16:00:00 | AAPL | Stock | 1.1423 | 1.1446 | 1.127 | 1.1436 | 5351752.0 |
| 2004-12-09 16:30:00 | AAPL | Stock | 1.1438 | 1.1457 | 1.1427 | 1.1438 | 1022000.0 |
| 2004-12-09 17:00:00 | AAPL | Stock | 1.1445 | 1.1548 | 1.1445 | 1.1536 | 2019136.0 |
| 2004-12-09 17:30:00 | AAPL | Stock | 1.1538 | 1.1607 | 1.1427 | 1.1545 | 2321816.0 |
| 2004-12-09 18:00:00 | AAPL | Stock | 1.1545 | 1.1557 | 1.1545 | 1.1554 | 449456.0 |
| 2004-12-09 08:00:00 | MSFT | Stock | 27.35 | 27.35 | 27.17 | 27.23 | 75470.0 |
| 2004-12-09 08:30:00 | MSFT | Stock | 27.19 | 27.36 | 27.12 | 27.17 | 720325.0 |
| 2004-12-09 09:00:00 | MSFT | Stock | 27.17 | 27.25 | 27.11 | 27.12 | 220033.0 |
| 2004-12-09 09:30:00 | MSFT | Stock | 27.12 | 27.26 | 27.08 | 27.19 | 7982405.0 |
| 2004-12-09 10:00:00 | MSFT | Stock | 27.2 | 27.2 | 27.09 | 27.12 | 5234301.0 |
| 2004-12-09 10:30:00 | MSFT | Stock | 27.11 | 27.12 | 27.01 | 27.01 | 6137936.0 |
| 2004-12-09 11:00:00 | MSFT | Stock | 27.01 | 27.05 | 26.98 | 26.98 | 7625732.0 |
| 2004-12-09 11:30:00 | MSFT | Stock | 26.99 | 27.06 | 26.94 | 27.03 | 5647878.0 |
| 2004-12-09 12:00:00 | MSFT | Stock | 27.02 | 27.14 | 27.01 | 27.12 | 4722926.0 |
| 2004-12-09 12:30:00 | MSFT | Stock | 27.12 | 27.15 | 27.07 | 27.13 | 4689627.0 |
| 2004-12-09 13:00:00 | MSFT | Stock | 27.12 | 27.27 | 27.11 | 27.2405 | 5903234.0 |
| 2004-12-09 13:30:00 | MSFT | Stock | 27.24 | 27.26 | 27.17 | 27.229 | 4984177.0 |
| 2004-12-09 14:00:00 | MSFT | Stock | 27.23 | 27.23 | 27.149 | 27.19 | 4863424.0 |
| 2004-12-09 14:30:00 | MSFT | Stock | 27.19 | 27.34 | 27.19 | 27.34 | 5397529.0 |
| 2004-12-09 15:00:00 | MSFT | Stock | 27.34 | 27.35 | 27.26 | 27.28 | 5733948.0 |
| 2004-12-09 15:30:00 | MSFT | Stock | 27.29 | 27.34 | 27.18 | 27.21 | 5849700.0 |
| 2004-12-09 16:00:00 | MSFT | Stock | 27.2 | 27.23 | 27.17 | 27.17 | 2729056.0 |
| 2004-12-09 16:30:00 | MSFT | Stock | 27.17 | 27.19 | 27.01 | 27.19 | 9288.0 |
| 2004-12-09 17:00:00 | MSFT | Stock | 27.18 | 27.23 | 27.18 | 27.19 | 36692.0 |
| 2004-12-09 17:30:00 | MSFT | Stock | 27.19 | 27.19 | 27.17 | 27.17 | 2100.0 |
| 2004-12-09 18:00:00 | MSFT | Stock | 27.17 | 27.17 | 27.17 | 27.17 | 190.0 |
| 2004-12-09 08:00:00 | NVDA | Stock | 0.1888 | 0.1892 | 0.1888 | 0.1892 | 295200.0 |
| 2004-12-09 08:30:00 | NVDA | Stock | 0.1888 | 0.189 | 0.1887 | 0.1887 | 168000.0 |
| 2004-12-09 09:00:00 | NVDA | Stock | 0.1882 | 0.1917 | 0.1881 | 0.1887 | 2114760.0 |
| 2004-12-09 09:30:00 | NVDA | Stock | 0.1884 | 0.1889 | 0.1855 | 0.1865 | 167561880.0 |
| 2004-12-09 10:00:00 | NVDA | Stock | 0.1864 | 0.1871 | 0.1852 | 0.1855 | 85680600.0 |
| 2004-12-09 10:30:00 | NVDA | Stock | 0.1855 | 0.1872 | 0.1852 | 0.186 | 52123920.0 |
| 2004-12-09 11:00:00 | NVDA | Stock | 0.186 | 0.1866 | 0.1852 | 0.1863 | 30421080.0 |
| 2004-12-09 11:30:00 | NVDA | Stock | 0.1863 | 0.1869 | 0.1862 | 0.1865 | 18770160.0 |
> showing 50 of 42,244 rows — these rows as CSV