PREVIEW / stock_30min / 2004-11-09
file: by_date/stock_30min/2004/2004-11-09.parquet size: 766 KB rows: 41,759 symbols: 1,866
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-11-09 08:00:00 | AAPL | Stock | 0.9739 | 0.9741 | 0.9711 | 0.9711 | 1703072.0 |
| 2004-11-09 08:30:00 | AAPL | Stock | 0.9723 | 0.9732 | 0.9718 | 0.9723 | 196000.0 |
| 2004-11-09 09:00:00 | AAPL | Stock | 0.9732 | 0.9732 | 0.9679 | 0.9695 | 939960.0 |
| 2004-11-09 09:30:00 | AAPL | Stock | 0.9679 | 0.9727 | 0.9621 | 0.9634 | 78071392.0 |
| 2004-11-09 10:00:00 | AAPL | Stock | 0.9634 | 0.9646 | 0.9561 | 0.9613 | 64078000.0 |
| 2004-11-09 10:30:00 | AAPL | Stock | 0.9611 | 0.962 | 0.9532 | 0.9586 | 46123728.0 |
| 2004-11-09 11:00:00 | AAPL | Stock | 0.9584 | 0.9636 | 0.9571 | 0.9609 | 29240680.0 |
| 2004-11-09 11:30:00 | AAPL | Stock | 0.9607 | 0.9625 | 0.9591 | 0.9605 | 16482312.0 |
| 2004-11-09 12:00:00 | AAPL | Stock | 0.9607 | 0.9664 | 0.9605 | 0.9645 | 22321040.0 |
| 2004-11-09 12:30:00 | AAPL | Stock | 0.9645 | 0.9645 | 0.9611 | 0.9625 | 21417256.0 |
| 2004-11-09 13:00:00 | AAPL | Stock | 0.9625 | 0.9664 | 0.9618 | 0.9648 | 17887800.0 |
| 2004-11-09 13:30:00 | AAPL | Stock | 0.9648 | 0.9677 | 0.9613 | 0.9671 | 28974792.0 |
| 2004-11-09 14:00:00 | AAPL | Stock | 0.9673 | 0.9741 | 0.9664 | 0.9695 | 36619352.0 |
| 2004-11-09 14:30:00 | AAPL | Stock | 0.9695 | 0.9704 | 0.9664 | 0.968 | 20073256.0 |
| 2004-11-09 15:00:00 | AAPL | Stock | 0.968 | 0.9689 | 0.9659 | 0.968 | 19021072.0 |
| 2004-11-09 15:30:00 | AAPL | Stock | 0.9682 | 0.9711 | 0.9641 | 0.9643 | 44022888.0 |
| 2004-11-09 16:00:00 | AAPL | Stock | 0.9655 | 0.9678 | 0.9638 | 0.9678 | 5879664.0 |
| 2004-11-09 16:30:00 | AAPL | Stock | 0.9652 | 0.9652 | 0.9652 | 0.9652 | 161336.0 |
| 2004-11-09 17:00:00 | AAPL | Stock | 0.9666 | 0.967 | 0.9625 | 0.9627 | 96936.0 |
| 2004-11-09 17:30:00 | AAPL | Stock | 0.963 | 0.967 | 0.9625 | 0.9625 | 627760.0 |
| 2004-11-09 18:00:00 | AAPL | Stock | 0.9625 | 0.9625 | 0.958 | 0.958 | 113736.0 |
| 2004-11-09 08:00:00 | MSFT | Stock | 29.38 | 29.61 | 29.29 | 29.47 | 755757.0 |
| 2004-11-09 08:30:00 | MSFT | Stock | 29.46 | 29.5 | 29.4 | 29.44 | 48444.0 |
| 2004-11-09 09:00:00 | MSFT | Stock | 29.41 | 29.45 | 29.33 | 29.43 | 322458.0 |
| 2004-11-09 09:30:00 | MSFT | Stock | 29.43 | 29.55 | 29.35 | 29.53 | 10555304.0 |
| 2004-11-09 10:00:00 | MSFT | Stock | 29.528 | 29.54 | 29.41 | 29.44 | 5723276.0 |
| 2004-11-09 10:30:00 | MSFT | Stock | 29.44 | 29.48 | 29.42 | 29.45 | 4468436.0 |
| 2004-11-09 11:00:00 | MSFT | Stock | 29.45 | 29.49 | 29.37 | 29.41 | 6950464.0 |
| 2004-11-09 11:30:00 | MSFT | Stock | 29.41 | 29.53 | 29.4 | 29.49 | 5313103.0 |
| 2004-11-09 12:00:00 | MSFT | Stock | 29.5 | 29.57 | 29.48 | 29.5 | 4604217.0 |
| 2004-11-09 12:30:00 | MSFT | Stock | 29.49 | 29.62 | 29.49 | 29.62 | 6455488.0 |
| 2004-11-09 13:00:00 | MSFT | Stock | 29.6188 | 29.67 | 29.57 | 29.65 | 6161628.0 |
| 2004-11-09 13:30:00 | MSFT | Stock | 29.65 | 29.7 | 29.61 | 29.7 | 4236771.0 |
| 2004-11-09 14:00:00 | MSFT | Stock | 29.6987 | 29.8 | 29.69 | 29.78 | 8690011.0 |
| 2004-11-09 14:30:00 | MSFT | Stock | 29.77 | 29.89 | 29.76 | 29.85 | 8772412.0 |
| 2004-11-09 15:00:00 | MSFT | Stock | 29.85 | 29.89 | 29.81 | 29.82 | 8310279.0 |
| 2004-11-09 15:30:00 | MSFT | Stock | 29.83 | 29.84 | 29.73 | 29.77 | 11995120.0 |
| 2004-11-09 16:00:00 | MSFT | Stock | 29.77 | 29.8217 | 29.7 | 29.74 | 2239382.0 |
| 2004-11-09 16:30:00 | MSFT | Stock | 29.75 | 29.83 | 29.73 | 29.76 | 79680.0 |
| 2004-11-09 17:00:00 | MSFT | Stock | 29.79 | 29.81 | 29.76 | 29.79 | 33045.0 |
| 2004-11-09 17:30:00 | MSFT | Stock | 29.79 | 29.82 | 29.74 | 29.78 | 157350.0 |
| 2004-11-09 18:00:00 | MSFT | Stock | 29.78 | 29.82 | 29.78 | 29.8 | 8905.0 |
| 2004-11-09 08:00:00 | NVDA | Stock | 0.1479 | 0.1486 | 0.1479 | 0.1486 | 1457760.0 |
| 2004-11-09 08:30:00 | NVDA | Stock | 0.1481 | 0.1483 | 0.1463 | 0.1469 | 300000.0 |
| 2004-11-09 09:00:00 | NVDA | Stock | 0.1469 | 0.1475 | 0.1464 | 0.147 | 923520.0 |
| 2004-11-09 09:30:00 | NVDA | Stock | 0.1463 | 0.1498 | 0.1462 | 0.1487 | 99062280.0 |
| 2004-11-09 10:00:00 | NVDA | Stock | 0.1487 | 0.1491 | 0.1482 | 0.1486 | 76418400.0 |
| 2004-11-09 10:30:00 | NVDA | Stock | 0.1486 | 0.1486 | 0.1471 | 0.1477 | 62699160.0 |
| 2004-11-09 11:00:00 | NVDA | Stock | 0.1476 | 0.148 | 0.147 | 0.1471 | 48920040.0 |
| 2004-11-09 11:30:00 | NVDA | Stock | 0.1471 | 0.1473 | 0.1469 | 0.1472 | 23071440.0 |
> showing 50 of 41,759 rows — these rows as CSV