PREVIEW / stock_30min / 2000-04-14
file: by_date/stock_30min/2000/2000-04-14.parquet size: 435 KB rows: 24,857 symbols: 1,162
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 |
|---|---|---|---|---|---|---|---|
| 2000-04-14 09:30:00 | AAPL | Stock | 0.976 | 1.0525 | 0.9732 | 1.0452 | 51262400.0 |
| 2000-04-14 10:00:00 | AAPL | Stock | 1.0452 | 1.0513 | 1.0346 | 1.0446 | 64108800.0 |
| 2000-04-14 10:30:00 | AAPL | Stock | 1.0446 | 1.048 | 1.0212 | 1.0276 | 48798400.0 |
| 2000-04-14 11:00:00 | AAPL | Stock | 1.0276 | 1.0276 | 0.9978 | 1.0 | 44352000.0 |
| 2000-04-14 11:30:00 | AAPL | Stock | 1.0006 | 1.0134 | 0.9933 | 0.9989 | 41854400.0 |
| 2000-04-14 12:00:00 | AAPL | Stock | 1.0011 | 1.024 | 0.9911 | 1.0045 | 56123200.0 |
| 2000-04-14 12:30:00 | AAPL | Stock | 1.0045 | 1.0134 | 0.9833 | 0.9955 | 34204800.0 |
| 2000-04-14 13:00:00 | AAPL | Stock | 0.9961 | 1.0396 | 0.9922 | 1.0313 | 34484800.0 |
| 2000-04-14 13:30:00 | AAPL | Stock | 1.0301 | 1.0385 | 1.0223 | 1.0374 | 39457600.0 |
| 2000-04-14 14:00:00 | AAPL | Stock | 1.0357 | 1.0368 | 1.0073 | 1.0223 | 40040000.0 |
| 2000-04-14 14:30:00 | AAPL | Stock | 1.024 | 1.0368 | 1.0123 | 1.0251 | 36288000.0 |
| 2000-04-14 15:00:00 | AAPL | Stock | 1.0246 | 1.0536 | 1.0112 | 1.0533 | 53457600.0 |
| 2000-04-14 15:30:00 | AAPL | Stock | 1.0536 | 1.0536 | 0.99 | 0.9989 | 67166400.0 |
| 2000-04-14 16:00:00 | AAPL | Stock | 0.9994 | 0.9994 | 0.9989 | 0.9989 | 246400.0 |
| 2000-04-14 09:30:00 | MSFT | Stock | 39.5625 | 39.625 | 38.75 | 39.0938 | 13076000.0 |
| 2000-04-14 10:00:00 | MSFT | Stock | 39.0938 | 39.1875 | 38.5625 | 38.6562 | 9695000.0 |
| 2000-04-14 10:30:00 | MSFT | Stock | 38.6562 | 38.9375 | 38.375 | 38.7812 | 8970600.0 |
| 2000-04-14 11:00:00 | MSFT | Stock | 38.7812 | 38.7812 | 37.8125 | 37.8438 | 13017200.0 |
| 2000-04-14 11:30:00 | MSFT | Stock | 37.875 | 38.3125 | 37.5312 | 37.5312 | 11310600.0 |
| 2000-04-14 12:00:00 | MSFT | Stock | 37.5625 | 38.0 | 37.4844 | 37.6875 | 14062600.0 |
| 2000-04-14 12:30:00 | MSFT | Stock | 37.7188 | 37.8125 | 37.5 | 37.5625 | 9500000.0 |
| 2000-04-14 13:00:00 | MSFT | Stock | 37.5625 | 37.9688 | 37.5625 | 37.7188 | 9119800.0 |
| 2000-04-14 13:30:00 | MSFT | Stock | 37.75 | 37.8438 | 37.5625 | 37.75 | 6364600.0 |
| 2000-04-14 14:00:00 | MSFT | Stock | 37.75 | 37.8125 | 37.4375 | 37.5 | 10246000.0 |
| 2000-04-14 14:30:00 | MSFT | Stock | 37.5312 | 37.6875 | 37.2188 | 37.3438 | 11756200.0 |
| 2000-04-14 15:00:00 | MSFT | Stock | 37.3125 | 37.5625 | 37.0 | 37.4688 | 9616400.0 |
| 2000-04-14 15:30:00 | MSFT | Stock | 37.4375 | 37.4688 | 36.625 | 37.0625 | 12420200.0 |
| 2000-04-14 16:00:00 | MSFT | Stock | 37.0312 | 37.2344 | 36.9688 | 37.0625 | 39000.0 |
| 2000-04-14 09:30:00 | NVDA | Stock | 0.1471 | 0.1542 | 0.1417 | 0.1542 | 26352000.0 |
| 2000-04-14 10:00:00 | NVDA | Stock | 0.1553 | 0.1573 | 0.151 | 0.1556 | 17952000.0 |
| 2000-04-14 10:30:00 | NVDA | Stock | 0.1556 | 0.1585 | 0.1556 | 0.1566 | 13776000.0 |
| 2000-04-14 11:00:00 | NVDA | Stock | 0.1566 | 0.1572 | 0.1458 | 0.1477 | 32496000.0 |
| 2000-04-14 11:30:00 | NVDA | Stock | 0.1477 | 0.1479 | 0.138 | 0.1419 | 55872000.0 |
| 2000-04-14 12:00:00 | NVDA | Stock | 0.1413 | 0.1507 | 0.1396 | 0.1424 | 41568000.0 |
| 2000-04-14 12:30:00 | NVDA | Stock | 0.1447 | 0.1499 | 0.1422 | 0.1482 | 19632000.0 |
| 2000-04-14 13:00:00 | NVDA | Stock | 0.1479 | 0.1523 | 0.1479 | 0.1521 | 28464000.0 |
| 2000-04-14 13:30:00 | NVDA | Stock | 0.1521 | 0.1529 | 0.1437 | 0.149 | 19488000.0 |
| 2000-04-14 14:00:00 | NVDA | Stock | 0.1492 | 0.1492 | 0.1385 | 0.1414 | 30720000.0 |
| 2000-04-14 14:30:00 | NVDA | Stock | 0.1417 | 0.1427 | 0.1375 | 0.1419 | 39648000.0 |
| 2000-04-14 15:00:00 | NVDA | Stock | 0.1427 | 0.1474 | 0.1365 | 0.1398 | 29712000.0 |
| 2000-04-14 15:30:00 | NVDA | Stock | 0.1418 | 0.1437 | 0.1375 | 0.1433 | 32448000.0 |
| 2000-04-14 09:30:00 | AMZN | Stock | 2.3938 | 2.6188 | 2.35 | 2.5969 | 24872000.0 |
| 2000-04-14 10:00:00 | AMZN | Stock | 2.6062 | 2.6125 | 2.45 | 2.5062 | 19314000.0 |
| 2000-04-14 10:30:00 | AMZN | Stock | 2.5 | 2.5125 | 2.3062 | 2.3125 | 25684000.0 |
| 2000-04-14 11:00:00 | AMZN | Stock | 2.3219 | 2.325 | 2.0406 | 2.1188 | 52248000.0 |
| 2000-04-14 11:30:00 | AMZN | Stock | 2.1094 | 2.2 | 2.0906 | 2.1531 | 52352000.0 |
| 2000-04-14 12:00:00 | AMZN | Stock | 2.15 | 2.2531 | 2.1375 | 2.2063 | 30168000.0 |
| 2000-04-14 12:30:00 | AMZN | Stock | 2.2063 | 2.3438 | 2.1906 | 2.1938 | 18030000.0 |
| 2000-04-14 13:00:00 | AMZN | Stock | 2.1969 | 2.3375 | 2.1875 | 2.3031 | 25208000.0 |
| 2000-04-14 13:30:00 | AMZN | Stock | 2.3031 | 2.3844 | 2.2938 | 2.3625 | 28386000.0 |
> showing 50 of 24,857 rows — these rows as CSV