PREVIEW / stock_1hour / 2003-11-24
file: by_date/stock_1hour/2003/2003-11-24.parquet size: 514 KB rows: 23,609 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-24 09:00:00 | AAPL | Stock | 0.3627 | 0.3723 | 0.3627 | 0.3707 | 37104928.0 |
| 2003-11-24 10:00:00 | AAPL | Stock | 0.3705 | 0.3739 | 0.3705 | 0.373 | 41744192.0 |
| 2003-11-24 11:00:00 | AAPL | Stock | 0.373 | 0.3741 | 0.3713 | 0.3725 | 25331600.0 |
| 2003-11-24 12:00:00 | AAPL | Stock | 0.3725 | 0.3748 | 0.3723 | 0.3743 | 45293024.0 |
| 2003-11-24 13:00:00 | AAPL | Stock | 0.3743 | 0.3754 | 0.3727 | 0.3739 | 29340640.0 |
| 2003-11-24 14:00:00 | AAPL | Stock | 0.3739 | 0.3768 | 0.3723 | 0.3757 | 49715848.0 |
| 2003-11-24 15:00:00 | AAPL | Stock | 0.3757 | 0.3796 | 0.3757 | 0.3796 | 92490664.0 |
| 2003-11-24 16:00:00 | AAPL | Stock | 0.378 | 0.3798 | 0.3755 | 0.3777 | 5543216.0 |
| 2003-11-24 17:00:00 | AAPL | Stock | 0.3798 | 0.3798 | 0.3777 | 0.3777 | 52696.0 |
| 2003-11-24 08:00:00 | MSFT | Stock | 25.25 | 25.33 | 25.18 | 25.33 | 114164.0 |
| 2003-11-24 09:00:00 | MSFT | Stock | 25.33 | 25.4 | 25.24 | 25.35 | 7843769.0 |
| 2003-11-24 10:00:00 | MSFT | Stock | 25.35 | 25.58 | 25.34 | 25.57 | 19639934.0 |
| 2003-11-24 11:00:00 | MSFT | Stock | 25.57 | 25.67 | 25.54 | 25.63 | 14514658.0 |
| 2003-11-24 12:00:00 | MSFT | Stock | 25.63 | 25.65 | 25.55 | 25.59 | 6913664.0 |
| 2003-11-24 13:00:00 | MSFT | Stock | 25.6 | 25.62 | 25.52 | 25.56 | 8675314.0 |
| 2003-11-24 14:00:00 | MSFT | Stock | 25.56 | 25.62 | 25.52 | 25.58 | 9648284.0 |
| 2003-11-24 15:00:00 | MSFT | Stock | 25.58 | 25.75 | 25.57 | 25.71 | 20473584.0 |
| 2003-11-24 16:00:00 | MSFT | Stock | 25.7 | 25.81 | 25.68 | 25.8 | 1310945.0 |
| 2003-11-24 17:00:00 | MSFT | Stock | 25.75 | 25.78 | 25.73 | 25.75 | 831602.0 |
| 2003-11-24 18:00:00 | MSFT | Stock | 25.75 | 25.76 | 25.75 | 25.76 | 10600.0 |
| 2003-11-24 08:00:00 | NVDA | Stock | 0.165 | 0.1667 | 0.165 | 0.1657 | 544800.0 |
| 2003-11-24 09:00:00 | NVDA | Stock | 0.1655 | 0.168 | 0.1653 | 0.1676 | 75461280.0 |
| 2003-11-24 10:00:00 | NVDA | Stock | 0.1676 | 0.1719 | 0.1675 | 0.1717 | 282043440.0 |
| 2003-11-24 11:00:00 | NVDA | Stock | 0.1717 | 0.1729 | 0.1708 | 0.1728 | 151525680.0 |
| 2003-11-24 12:00:00 | NVDA | Stock | 0.1729 | 0.1733 | 0.1722 | 0.1727 | 66880560.0 |
| 2003-11-24 13:00:00 | NVDA | Stock | 0.1726 | 0.1732 | 0.1724 | 0.1729 | 60777960.0 |
| 2003-11-24 14:00:00 | NVDA | Stock | 0.1728 | 0.1742 | 0.1727 | 0.174 | 81783480.0 |
| 2003-11-24 15:00:00 | NVDA | Stock | 0.1741 | 0.175 | 0.1737 | 0.1748 | 139800120.0 |
| 2003-11-24 16:00:00 | NVDA | Stock | 0.1748 | 0.1758 | 0.1742 | 0.1742 | 8785560.0 |
| 2003-11-24 17:00:00 | NVDA | Stock | 0.1748 | 0.1749 | 0.1743 | 0.1749 | 380400.0 |
| 2003-11-24 18:00:00 | NVDA | Stock | 0.175 | 0.175 | 0.175 | 0.175 | 84000.0 |
| 2003-11-24 08:00:00 | AMZN | Stock | 2.454 | 2.49 | 2.429 | 2.46 | 303020.0 |
| 2003-11-24 09:00:00 | AMZN | Stock | 2.46 | 2.4725 | 2.4325 | 2.4645 | 29178480.0 |
| 2003-11-24 10:00:00 | AMZN | Stock | 2.465 | 2.5233 | 2.4635 | 2.521 | 43488300.0 |
| 2003-11-24 11:00:00 | AMZN | Stock | 2.521 | 2.532 | 2.507 | 2.5195 | 25867660.0 |
| 2003-11-24 12:00:00 | AMZN | Stock | 2.5195 | 2.5245 | 2.514 | 2.5195 | 10628800.0 |
| 2003-11-24 13:00:00 | AMZN | Stock | 2.519 | 2.5355 | 2.5165 | 2.526 | 16863500.0 |
| 2003-11-24 14:00:00 | AMZN | Stock | 2.525 | 2.55 | 2.5195 | 2.5455 | 20478100.0 |
| 2003-11-24 15:00:00 | AMZN | Stock | 2.545 | 2.57 | 2.5385 | 2.569 | 42674800.0 |
| 2003-11-24 16:00:00 | AMZN | Stock | 2.5705 | 2.5725 | 2.5665 | 2.5685 | 1815200.0 |
| 2003-11-24 17:00:00 | AMZN | Stock | 2.5685 | 2.575 | 2.568 | 2.5745 | 826400.0 |
| 2003-11-24 18:00:00 | AMZN | Stock | 2.5745 | 2.5775 | 2.5725 | 2.5775 | 12000.0 |
| 2003-11-24 09:00:00 | CL | Stock | 26.05 | 26.23 | 25.99 | 26.21 | 294800.0 |
| 2003-11-24 10:00:00 | CL | Stock | 26.21 | 26.225 | 26.135 | 26.195 | 839200.0 |
| 2003-11-24 11:00:00 | CL | Stock | 26.2 | 26.24 | 26.185 | 26.195 | 829000.0 |
| 2003-11-24 12:00:00 | CL | Stock | 26.19 | 26.245 | 26.16 | 26.2 | 438800.0 |
| 2003-11-24 13:00:00 | CL | Stock | 26.2 | 26.215 | 26.149 | 26.165 | 311200.0 |
| 2003-11-24 14:00:00 | CL | Stock | 26.175 | 26.19 | 26.125 | 26.155 | 424000.0 |
| 2003-11-24 15:00:00 | CL | Stock | 26.155 | 26.195 | 26.105 | 26.175 | 1113600.0 |
| 2003-11-24 16:00:00 | CL | Stock | 26.18 | 26.225 | 26.18 | 26.225 | 265000.0 |
> showing 50 of 23,609 rows — these rows as CSV