PREVIEW / stock_1hour / 2004-11-30
file: by_date/stock_1hour/2004/2004-11-30.parquet size: 557 KB rows: 25,893 symbols: 1,894
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-30 08:00:00 | AAPL | Stock | 1.233 | 1.2375 | 1.2257 | 1.2264 | 4210472.0 |
| 2004-11-30 09:00:00 | AAPL | Stock | 1.2257 | 1.2288 | 1.2064 | 1.2204 | 175688240.0 |
| 2004-11-30 10:00:00 | AAPL | Stock | 1.2204 | 1.2223 | 1.202 | 1.2055 | 195911576.0 |
| 2004-11-30 11:00:00 | AAPL | Stock | 1.205 | 1.2182 | 1.2002 | 1.2143 | 156322264.0 |
| 2004-11-30 12:00:00 | AAPL | Stock | 1.2143 | 1.2214 | 1.2127 | 1.2207 | 105045080.0 |
| 2004-11-30 13:00:00 | AAPL | Stock | 1.2207 | 1.2227 | 1.2109 | 1.2125 | 71688904.0 |
| 2004-11-30 14:00:00 | AAPL | Stock | 1.2121 | 1.2159 | 1.2098 | 1.2111 | 48554464.0 |
| 2004-11-30 15:00:00 | AAPL | Stock | 1.2113 | 1.2163 | 1.2009 | 1.2013 | 135531984.0 |
| 2004-11-30 16:00:00 | AAPL | Stock | 1.2018 | 1.2045 | 1.1973 | 1.2034 | 20286728.0 |
| 2004-11-30 17:00:00 | AAPL | Stock | 1.2018 | 1.2121 | 1.1973 | 1.2045 | 1217104.0 |
| 2004-11-30 18:00:00 | AAPL | Stock | 1.2122 | 1.2122 | 1.2045 | 1.2045 | 620200.0 |
| 2004-11-30 08:00:00 | MSFT | Stock | 26.77 | 26.77 | 26.7 | 26.75 | 320742.0 |
| 2004-11-30 09:00:00 | MSFT | Stock | 26.75 | 26.86 | 26.7 | 26.76 | 9857999.0 |
| 2004-11-30 10:00:00 | MSFT | Stock | 26.76 | 26.91 | 26.72 | 26.9 | 11104836.0 |
| 2004-11-30 11:00:00 | MSFT | Stock | 26.89 | 27.0 | 26.85 | 26.94 | 11040600.0 |
| 2004-11-30 12:00:00 | MSFT | Stock | 26.92 | 26.98 | 26.85 | 26.93 | 7058379.0 |
| 2004-11-30 13:00:00 | MSFT | Stock | 26.93 | 26.94 | 26.85 | 26.88 | 4586465.0 |
| 2004-11-30 14:00:00 | MSFT | Stock | 26.89 | 26.93 | 26.87 | 26.9 | 6748040.0 |
| 2004-11-30 15:00:00 | MSFT | Stock | 26.905 | 27.01 | 26.8 | 26.8 | 17810757.0 |
| 2004-11-30 16:00:00 | MSFT | Stock | 26.81 | 26.89 | 26.79 | 26.88 | 2818160.0 |
| 2004-11-30 17:00:00 | MSFT | Stock | 26.87 | 26.98 | 26.74 | 26.92 | 290014.0 |
| 2004-11-30 18:00:00 | MSFT | Stock | 26.9008 | 26.94 | 26.9 | 26.93 | 70021.0 |
| 2004-11-30 08:00:00 | NVDA | Stock | 0.1624 | 0.1638 | 0.1624 | 0.1638 | 748680.0 |
| 2004-11-30 09:00:00 | NVDA | Stock | 0.1637 | 0.1638 | 0.1608 | 0.1616 | 69548760.0 |
| 2004-11-30 10:00:00 | NVDA | Stock | 0.1615 | 0.1626 | 0.1594 | 0.1597 | 109677480.0 |
| 2004-11-30 11:00:00 | NVDA | Stock | 0.1597 | 0.1599 | 0.1592 | 0.1599 | 82516320.0 |
| 2004-11-30 12:00:00 | NVDA | Stock | 0.1599 | 0.1604 | 0.1597 | 0.1598 | 46501680.0 |
| 2004-11-30 13:00:00 | NVDA | Stock | 0.1598 | 0.16 | 0.1592 | 0.1597 | 35720040.0 |
| 2004-11-30 14:00:00 | NVDA | Stock | 0.1597 | 0.1599 | 0.1585 | 0.1585 | 62272920.0 |
| 2004-11-30 15:00:00 | NVDA | Stock | 0.1585 | 0.16 | 0.1585 | 0.1589 | 102332280.0 |
| 2004-11-30 16:00:00 | NVDA | Stock | 0.1589 | 0.1614 | 0.1587 | 0.1597 | 40884360.0 |
| 2004-11-30 17:00:00 | NVDA | Stock | 0.1597 | 0.1603 | 0.1597 | 0.1601 | 423840.0 |
| 2004-11-30 18:00:00 | NVDA | Stock | 0.1607 | 0.1607 | 0.1607 | 0.1607 | 120000.0 |
| 2004-11-30 08:00:00 | AMZN | Stock | 1.945 | 1.959 | 1.945 | 1.95 | 121500.0 |
| 2004-11-30 09:00:00 | AMZN | Stock | 1.953 | 1.9625 | 1.9475 | 1.954 | 16097640.0 |
| 2004-11-30 10:00:00 | AMZN | Stock | 1.9545 | 1.99 | 1.95 | 1.974 | 39398800.0 |
| 2004-11-30 11:00:00 | AMZN | Stock | 1.974 | 1.976 | 1.9675 | 1.9705 | 10780300.0 |
| 2004-11-30 12:00:00 | AMZN | Stock | 1.97 | 1.98 | 1.9635 | 1.965 | 11945220.0 |
| 2004-11-30 13:00:00 | AMZN | Stock | 1.965 | 1.9715 | 1.96 | 1.9625 | 9799220.0 |
| 2004-11-30 14:00:00 | AMZN | Stock | 1.9625 | 1.975 | 1.9625 | 1.9705 | 11581440.0 |
| 2004-11-30 15:00:00 | AMZN | Stock | 1.9705 | 1.9825 | 1.9665 | 1.9825 | 28183900.0 |
| 2004-11-30 16:00:00 | AMZN | Stock | 1.9825 | 1.984 | 1.9705 | 1.984 | 5328960.0 |
| 2004-11-30 17:00:00 | AMZN | Stock | 1.9717 | 1.984 | 1.9674 | 1.983 | 337900.0 |
| 2004-11-30 18:00:00 | AMZN | Stock | 1.9582 | 1.983 | 1.9582 | 1.983 | 18600.0 |
| 2004-11-30 08:00:00 | CL | Stock | 23.045 | 23.045 | 23.045 | 23.045 | 200.0 |
| 2004-11-30 09:00:00 | CL | Stock | 22.925 | 23.025 | 22.905 | 22.905 | 453200.0 |
| 2004-11-30 10:00:00 | CL | Stock | 22.905 | 22.985 | 22.9 | 22.925 | 466600.0 |
| 2004-11-30 11:00:00 | CL | Stock | 22.93 | 22.99 | 22.895 | 22.98 | 350400.0 |
| 2004-11-30 12:00:00 | CL | Stock | 22.975 | 23.02 | 22.9 | 22.94 | 322400.0 |
| 2004-11-30 13:00:00 | CL | Stock | 22.94 | 23.025 | 22.93 | 22.99 | 393200.0 |
> showing 50 of 25,893 rows — these rows as CSV