PREVIEW / stock_1hour / 2004-12-03
file: by_date/stock_1hour/2004/2004-12-03.parquet size: 546 KB rows: 25,927 symbols: 1,889
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-12-03 08:00:00 | AAPL | Stock | 1.1777 | 1.1804 | 1.1584 | 1.1655 | 6729520.0 |
| 2004-12-03 09:00:00 | AAPL | Stock | 1.1661 | 1.1668 | 1.1466 | 1.1514 | 155841168.0 |
| 2004-12-03 10:00:00 | AAPL | Stock | 1.1516 | 1.1536 | 1.1027 | 1.1193 | 564409888.0 |
| 2004-12-03 11:00:00 | AAPL | Stock | 1.1193 | 1.1248 | 1.1114 | 1.1182 | 141543976.0 |
| 2004-12-03 12:00:00 | AAPL | Stock | 1.1186 | 1.125 | 1.117 | 1.1182 | 74640216.0 |
| 2004-12-03 13:00:00 | AAPL | Stock | 1.1179 | 1.1221 | 1.1143 | 1.1175 | 51477720.0 |
| 2004-12-03 14:00:00 | AAPL | Stock | 1.1171 | 1.1211 | 1.1113 | 1.113 | 77582904.0 |
| 2004-12-03 15:00:00 | AAPL | Stock | 1.1132 | 1.1245 | 1.1125 | 1.12 | 130132240.0 |
| 2004-12-03 16:00:00 | AAPL | Stock | 1.1193 | 1.1645 | 1.1189 | 1.1204 | 10412752.0 |
| 2004-12-03 17:00:00 | AAPL | Stock | 1.12 | 1.1575 | 1.1179 | 1.118 | 1069936.0 |
| 2004-12-03 18:00:00 | AAPL | Stock | 1.1179 | 1.1182 | 1.1175 | 1.1177 | 169176.0 |
| 2004-12-03 08:00:00 | MSFT | Stock | 27.3 | 27.34 | 27.08 | 27.15 | 156822.0 |
| 2004-12-03 09:00:00 | MSFT | Stock | 27.15 | 27.42 | 27.09 | 27.35 | 13304024.0 |
| 2004-12-03 10:00:00 | MSFT | Stock | 27.35 | 27.44 | 27.16 | 27.28 | 19170498.0 |
| 2004-12-03 11:00:00 | MSFT | Stock | 27.28 | 27.36 | 27.27 | 27.32 | 6505978.0 |
| 2004-12-03 12:00:00 | MSFT | Stock | 27.32 | 27.35 | 27.26 | 27.28 | 5532116.0 |
| 2004-12-03 13:00:00 | MSFT | Stock | 27.28 | 27.33 | 27.22 | 27.29 | 10236390.0 |
| 2004-12-03 14:00:00 | MSFT | Stock | 27.29 | 27.32 | 27.25 | 27.28 | 8449117.0 |
| 2004-12-03 15:00:00 | MSFT | Stock | 27.28 | 27.32 | 27.21 | 27.22 | 8702872.0 |
| 2004-12-03 16:00:00 | MSFT | Stock | 27.21 | 27.275 | 27.13 | 27.22 | 1160010.0 |
| 2004-12-03 17:00:00 | MSFT | Stock | 27.22 | 27.2986 | 27.21 | 27.22 | 76957.0 |
| 2004-12-03 18:00:00 | MSFT | Stock | 27.22 | 27.22 | 27.22 | 27.22 | 1495.0 |
| 2004-12-03 08:00:00 | NVDA | Stock | 0.1708 | 0.1718 | 0.1657 | 0.1691 | 25544760.0 |
| 2004-12-03 09:00:00 | NVDA | Stock | 0.169 | 0.175 | 0.1656 | 0.173 | 347454000.0 |
| 2004-12-03 10:00:00 | NVDA | Stock | 0.1729 | 0.1747 | 0.169 | 0.1713 | 387606600.0 |
| 2004-12-03 11:00:00 | NVDA | Stock | 0.1713 | 0.1733 | 0.1712 | 0.1726 | 168938400.0 |
| 2004-12-03 12:00:00 | NVDA | Stock | 0.1727 | 0.1729 | 0.1712 | 0.1717 | 61771320.0 |
| 2004-12-03 13:00:00 | NVDA | Stock | 0.1717 | 0.1729 | 0.1713 | 0.1727 | 72762360.0 |
| 2004-12-03 14:00:00 | NVDA | Stock | 0.1727 | 0.1728 | 0.1719 | 0.1722 | 69065640.0 |
| 2004-12-03 15:00:00 | NVDA | Stock | 0.1722 | 0.1733 | 0.1719 | 0.1725 | 154824600.0 |
| 2004-12-03 16:00:00 | NVDA | Stock | 0.1724 | 0.1735 | 0.1722 | 0.1733 | 23118840.0 |
| 2004-12-03 17:00:00 | NVDA | Stock | 0.1736 | 0.1736 | 0.1729 | 0.1735 | 252000.0 |
| 2004-12-03 08:00:00 | AMZN | Stock | 2.025 | 2.035 | 2.0135 | 2.018 | 427000.0 |
| 2004-12-03 09:00:00 | AMZN | Stock | 2.018 | 2.165 | 1.9885 | 2.0155 | 20041320.0 |
| 2004-12-03 10:00:00 | AMZN | Stock | 2.0155 | 2.0195 | 1.9835 | 1.9945 | 37012660.0 |
| 2004-12-03 11:00:00 | AMZN | Stock | 1.9945 | 2.0095 | 1.992 | 1.999 | 12577220.0 |
| 2004-12-03 12:00:00 | AMZN | Stock | 1.9995 | 2.001 | 1.9845 | 1.985 | 7597020.0 |
| 2004-12-03 13:00:00 | AMZN | Stock | 1.985 | 1.996 | 1.9845 | 1.9865 | 19810020.0 |
| 2004-12-03 14:00:00 | AMZN | Stock | 1.986 | 1.991 | 1.977 | 1.9855 | 19916820.0 |
| 2004-12-03 15:00:00 | AMZN | Stock | 1.9865 | 2.0125 | 1.9825 | 2.0015 | 40410620.0 |
| 2004-12-03 16:00:00 | AMZN | Stock | 2.001 | 2.005 | 1.998 | 1.999 | 954000.0 |
| 2004-12-03 17:00:00 | AMZN | Stock | 2.0045 | 2.005 | 2.0 | 2.0 | 136860.0 |
| 2004-12-03 09:00:00 | CL | Stock | 23.725 | 23.725 | 23.6 | 23.6 | 423400.0 |
| 2004-12-03 10:00:00 | CL | Stock | 23.6 | 23.655 | 23.51 | 23.525 | 1033600.0 |
| 2004-12-03 11:00:00 | CL | Stock | 23.525 | 23.53 | 23.38 | 23.38 | 946200.0 |
| 2004-12-03 12:00:00 | CL | Stock | 23.385 | 23.46 | 23.385 | 23.42 | 863000.0 |
| 2004-12-03 13:00:00 | CL | Stock | 23.415 | 23.42 | 23.335 | 23.34 | 718000.0 |
| 2004-12-03 14:00:00 | CL | Stock | 23.34 | 23.395 | 23.295 | 23.3 | 671200.0 |
| 2004-12-03 15:00:00 | CL | Stock | 23.3 | 23.47 | 23.295 | 23.43 | 1526800.0 |
| 2004-12-03 16:00:00 | CL | Stock | 23.45 | 23.45 | 23.45 | 23.45 | 1000.0 |
> showing 50 of 25,927 rows — these rows as CSV