PREVIEW / stock_1hour / 2004-11-10
file: by_date/stock_1hour/2004/2004-11-10.parquet size: 521 KB rows: 24,426 symbols: 1,877
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-10 08:00:00 | AAPL | Stock | 0.9643 | 0.9643 | 0.9625 | 0.9625 | 44800.0 |
| 2004-11-10 09:00:00 | AAPL | Stock | 0.963 | 0.9723 | 0.9625 | 0.9682 | 54154408.0 |
| 2004-11-10 10:00:00 | AAPL | Stock | 0.9686 | 0.9805 | 0.9661 | 0.978 | 98144648.0 |
| 2004-11-10 11:00:00 | AAPL | Stock | 0.9784 | 0.9784 | 0.9705 | 0.977 | 39745440.0 |
| 2004-11-10 12:00:00 | AAPL | Stock | 0.9768 | 0.9795 | 0.9732 | 0.9784 | 27137208.0 |
| 2004-11-10 13:00:00 | AAPL | Stock | 0.9784 | 0.9804 | 0.9739 | 0.9804 | 29570800.0 |
| 2004-11-10 14:00:00 | AAPL | Stock | 0.9804 | 0.9891 | 0.9798 | 0.9868 | 107059064.0 |
| 2004-11-10 15:00:00 | AAPL | Stock | 0.9866 | 0.9882 | 0.972 | 0.9768 | 128136344.0 |
| 2004-11-10 16:00:00 | AAPL | Stock | 0.9777 | 0.9813 | 0.9761 | 0.9777 | 3971520.0 |
| 2004-11-10 17:00:00 | AAPL | Stock | 0.9788 | 0.9788 | 0.9775 | 0.9777 | 425320.0 |
| 2004-11-10 08:00:00 | MSFT | Stock | 30.0 | 30.0 | 29.85 | 29.95 | 349193.0 |
| 2004-11-10 09:00:00 | MSFT | Stock | 29.93 | 30.0 | 29.77 | 29.85 | 10043329.0 |
| 2004-11-10 10:00:00 | MSFT | Stock | 29.85 | 29.87 | 29.71 | 29.73 | 15081860.0 |
| 2004-11-10 11:00:00 | MSFT | Stock | 29.72 | 29.85 | 29.69 | 29.84 | 11864018.0 |
| 2004-11-10 12:00:00 | MSFT | Stock | 29.84 | 29.86 | 29.79 | 29.82 | 6628700.0 |
| 2004-11-10 13:00:00 | MSFT | Stock | 29.819 | 29.841 | 29.77 | 29.811 | 4895327.0 |
| 2004-11-10 14:00:00 | MSFT | Stock | 29.819 | 29.9 | 29.76 | 29.84 | 11710859.0 |
| 2004-11-10 15:00:00 | MSFT | Stock | 29.83 | 29.86 | 29.71 | 29.73 | 14786749.0 |
| 2004-11-10 16:00:00 | MSFT | Stock | 29.73 | 29.78 | 29.71 | 29.72 | 2869461.0 |
| 2004-11-10 17:00:00 | MSFT | Stock | 29.72 | 29.78 | 29.7 | 29.78 | 201550.0 |
| 2004-11-10 18:00:00 | MSFT | Stock | 29.78 | 29.79 | 29.74 | 29.77 | 34792.0 |
| 2004-11-10 08:00:00 | NVDA | Stock | 0.1467 | 0.1717 | 0.1458 | 0.1487 | 906000.0 |
| 2004-11-10 09:00:00 | NVDA | Stock | 0.1483 | 0.1483 | 0.1469 | 0.1479 | 62490240.0 |
| 2004-11-10 10:00:00 | NVDA | Stock | 0.1478 | 0.1484 | 0.1477 | 0.1484 | 84199440.0 |
| 2004-11-10 11:00:00 | NVDA | Stock | 0.1484 | 0.1484 | 0.1472 | 0.1475 | 72186000.0 |
| 2004-11-10 12:00:00 | NVDA | Stock | 0.1475 | 0.148 | 0.1475 | 0.1477 | 53454840.0 |
| 2004-11-10 13:00:00 | NVDA | Stock | 0.1477 | 0.148 | 0.1476 | 0.1477 | 74137080.0 |
| 2004-11-10 14:00:00 | NVDA | Stock | 0.1477 | 0.1491 | 0.1477 | 0.1483 | 88472520.0 |
| 2004-11-10 15:00:00 | NVDA | Stock | 0.1483 | 0.1485 | 0.1472 | 0.1477 | 194485920.0 |
| 2004-11-10 16:00:00 | NVDA | Stock | 0.1476 | 0.1479 | 0.1476 | 0.1476 | 3981240.0 |
| 2004-11-10 17:00:00 | NVDA | Stock | 0.1475 | 0.1477 | 0.1474 | 0.1474 | 694200.0 |
| 2004-11-10 18:00:00 | NVDA | Stock | 0.1472 | 0.1472 | 0.1472 | 0.1472 | 576000.0 |
| 2004-11-10 08:00:00 | AMZN | Stock | 1.8965 | 1.9225 | 1.895 | 1.8995 | 763000.0 |
| 2004-11-10 09:00:00 | AMZN | Stock | 1.9 | 1.92 | 1.879 | 1.919 | 31620620.0 |
| 2004-11-10 10:00:00 | AMZN | Stock | 1.919 | 1.936 | 1.905 | 1.9244 | 55904580.0 |
| 2004-11-10 11:00:00 | AMZN | Stock | 1.924 | 1.9405 | 1.924 | 1.937 | 27005740.0 |
| 2004-11-10 12:00:00 | AMZN | Stock | 1.937 | 1.942 | 1.9265 | 1.9335 | 17917740.0 |
| 2004-11-10 13:00:00 | AMZN | Stock | 1.934 | 1.938 | 1.927 | 1.9275 | 13187760.0 |
| 2004-11-10 14:00:00 | AMZN | Stock | 1.9275 | 1.938 | 1.9215 | 1.926 | 24009380.0 |
| 2004-11-10 15:00:00 | AMZN | Stock | 1.926 | 1.9305 | 1.9035 | 1.9035 | 34302320.0 |
| 2004-11-10 16:00:00 | AMZN | Stock | 1.9085 | 1.9115 | 1.903 | 1.9075 | 3569260.0 |
| 2004-11-10 17:00:00 | AMZN | Stock | 1.9081 | 1.9226 | 1.9045 | 1.9045 | 463300.0 |
| 2004-11-10 18:00:00 | AMZN | Stock | 1.9075 | 1.9075 | 1.9045 | 1.9045 | 59000.0 |
| 2004-11-10 09:00:00 | CL | Stock | 23.4 | 23.435 | 23.28 | 23.35 | 413400.0 |
| 2004-11-10 10:00:00 | CL | Stock | 23.345 | 23.345 | 23.175 | 23.295 | 660800.0 |
| 2004-11-10 11:00:00 | CL | Stock | 23.285 | 23.3 | 23.21 | 23.251 | 399200.0 |
| 2004-11-10 12:00:00 | CL | Stock | 23.25 | 23.33 | 23.245 | 23.29 | 351600.0 |
| 2004-11-10 13:00:00 | CL | Stock | 23.285 | 23.295 | 23.23 | 23.285 | 415400.0 |
| 2004-11-10 14:00:00 | CL | Stock | 23.285 | 23.35 | 23.255 | 23.335 | 443600.0 |
| 2004-11-10 15:00:00 | CL | Stock | 23.33 | 23.345 | 23.235 | 23.255 | 888800.0 |
> showing 50 of 24,426 rows — these rows as CSV