PREVIEW / stock_1hour / 2003-11-26
file: by_date/stock_1hour/2003/2003-11-26.parquet size: 467 KB rows: 22,011 symbols: 1,677
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 |
|---|---|---|---|---|---|---|---|
| 2003-11-26 08:00:00 | AAPL | Stock | 0.372 | 0.372 | 0.372 | 0.372 | 16800.0 |
| 2003-11-26 09:00:00 | AAPL | Stock | 0.3732 | 0.3777 | 0.37 | 0.3711 | 18396336.0 |
| 2003-11-26 10:00:00 | AAPL | Stock | 0.3711 | 0.3725 | 0.3623 | 0.3639 | 37064608.0 |
| 2003-11-26 11:00:00 | AAPL | Stock | 0.3639 | 0.3652 | 0.3616 | 0.3628 | 24777368.0 |
| 2003-11-26 12:00:00 | AAPL | Stock | 0.3626 | 0.3655 | 0.3616 | 0.365 | 35211792.0 |
| 2003-11-26 13:00:00 | AAPL | Stock | 0.3654 | 0.3677 | 0.3643 | 0.3666 | 28218064.0 |
| 2003-11-26 14:00:00 | AAPL | Stock | 0.3666 | 0.368 | 0.3655 | 0.3673 | 19214328.0 |
| 2003-11-26 15:00:00 | AAPL | Stock | 0.3673 | 0.3704 | 0.3652 | 0.3696 | 32658920.0 |
| 2003-11-26 16:00:00 | AAPL | Stock | 0.3689 | 0.37 | 0.3673 | 0.3699 | 2242520.0 |
| 2003-11-26 08:00:00 | MSFT | Stock | 25.51 | 25.64 | 25.51 | 25.62 | 101104.0 |
| 2003-11-26 09:00:00 | MSFT | Stock | 25.62 | 25.64 | 25.43 | 25.55 | 6712997.0 |
| 2003-11-26 10:00:00 | MSFT | Stock | 25.55 | 25.58 | 25.36 | 25.37 | 12305212.0 |
| 2003-11-26 11:00:00 | MSFT | Stock | 25.38 | 25.48 | 25.32 | 25.4 | 11811678.0 |
| 2003-11-26 12:00:00 | MSFT | Stock | 25.4 | 25.47 | 25.38 | 25.47 | 6667639.0 |
| 2003-11-26 13:00:00 | MSFT | Stock | 25.47 | 25.49 | 25.35 | 25.4 | 6712613.0 |
| 2003-11-26 14:00:00 | MSFT | Stock | 25.38 | 25.46 | 25.38 | 25.42 | 7575343.0 |
| 2003-11-26 15:00:00 | MSFT | Stock | 25.421 | 25.51 | 25.39 | 25.45 | 9302581.0 |
| 2003-11-26 16:00:00 | MSFT | Stock | 25.45 | 25.52 | 25.43 | 25.51 | 626295.0 |
| 2003-11-26 17:00:00 | MSFT | Stock | 25.51 | 25.51 | 25.48 | 25.49 | 3000.0 |
| 2003-11-26 18:00:00 | MSFT | Stock | 25.48 | 25.5 | 25.47 | 25.5 | 6718.0 |
| 2003-11-26 08:00:00 | NVDA | Stock | 0.1783 | 0.1799 | 0.178 | 0.1799 | 1830000.0 |
| 2003-11-26 09:00:00 | NVDA | Stock | 0.1793 | 0.1811 | 0.1772 | 0.1775 | 68270520.0 |
| 2003-11-26 10:00:00 | NVDA | Stock | 0.1776 | 0.1782 | 0.1744 | 0.1749 | 113078640.0 |
| 2003-11-26 11:00:00 | NVDA | Stock | 0.1749 | 0.1772 | 0.1748 | 0.1768 | 65744280.0 |
| 2003-11-26 12:00:00 | NVDA | Stock | 0.1769 | 0.1779 | 0.1767 | 0.1773 | 33021720.0 |
| 2003-11-26 13:00:00 | NVDA | Stock | 0.1774 | 0.1781 | 0.1768 | 0.1774 | 19487520.0 |
| 2003-11-26 14:00:00 | NVDA | Stock | 0.1773 | 0.1781 | 0.1771 | 0.1774 | 26922480.0 |
| 2003-11-26 15:00:00 | NVDA | Stock | 0.1775 | 0.1781 | 0.1768 | 0.1777 | 47121960.0 |
| 2003-11-26 16:00:00 | NVDA | Stock | 0.1781 | 0.1782 | 0.1772 | 0.1777 | 2877720.0 |
| 2003-11-26 17:00:00 | NVDA | Stock | 0.1777 | 0.1779 | 0.1773 | 0.1773 | 1404000.0 |
| 2003-11-26 08:00:00 | AMZN | Stock | 2.63 | 2.65 | 2.63 | 2.6485 | 440940.0 |
| 2003-11-26 09:00:00 | AMZN | Stock | 2.65 | 2.677 | 2.6325 | 2.655 | 31628080.0 |
| 2003-11-26 10:00:00 | AMZN | Stock | 2.657 | 2.661 | 2.6005 | 2.6055 | 36032100.0 |
| 2003-11-26 11:00:00 | AMZN | Stock | 2.605 | 2.618 | 2.5935 | 2.615 | 22555240.0 |
| 2003-11-26 12:00:00 | AMZN | Stock | 2.615 | 2.6447 | 2.615 | 2.642 | 20412080.0 |
| 2003-11-26 13:00:00 | AMZN | Stock | 2.6425 | 2.644 | 2.627 | 2.635 | 12125340.0 |
| 2003-11-26 14:00:00 | AMZN | Stock | 2.635 | 2.638 | 2.618 | 2.6285 | 13694240.0 |
| 2003-11-26 15:00:00 | AMZN | Stock | 2.6295 | 2.65 | 2.62 | 2.648 | 18789280.0 |
| 2003-11-26 16:00:00 | AMZN | Stock | 2.6485 | 2.654 | 2.6329 | 2.6498 | 1500240.0 |
| 2003-11-26 17:00:00 | AMZN | Stock | 2.6545 | 2.6545 | 2.6505 | 2.652 | 71880.0 |
| 2003-11-26 18:00:00 | AMZN | Stock | 2.652 | 2.6525 | 2.6505 | 2.6525 | 10720.0 |
| 2003-11-26 09:00:00 | CL | Stock | 26.21 | 26.245 | 26.05 | 26.09 | 443600.0 |
| 2003-11-26 10:00:00 | CL | Stock | 26.09 | 26.205 | 26.085 | 26.195 | 762000.0 |
| 2003-11-26 11:00:00 | CL | Stock | 26.19 | 26.2 | 26.05 | 26.085 | 578200.0 |
| 2003-11-26 12:00:00 | CL | Stock | 26.085 | 26.155 | 26.08 | 26.15 | 441200.0 |
| 2003-11-26 13:00:00 | CL | Stock | 26.165 | 26.175 | 26.11 | 26.165 | 382800.0 |
| 2003-11-26 14:00:00 | CL | Stock | 26.15 | 26.17 | 26.11 | 26.135 | 310400.0 |
| 2003-11-26 15:00:00 | CL | Stock | 26.13 | 26.195 | 26.115 | 26.175 | 638200.0 |
| 2003-11-26 16:00:00 | CL | Stock | 26.16 | 26.175 | 26.16 | 26.17 | 136800.0 |
> showing 49 of 22,011 rows — these rows as CSV