PREVIEW / stock_1hour / 2004-12-22
file: by_date/stock_1hour/2004/2004-12-22.parquet size: 551 KB rows: 25,316 symbols: 1,909
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-22 08:00:00 | AAPL | Stock | 1.1429 | 1.1429 | 1.1366 | 1.1379 | 728672.0 |
| 2004-12-22 09:00:00 | AAPL | Stock | 1.1379 | 1.1493 | 1.1343 | 1.1388 | 105747320.0 |
| 2004-12-22 10:00:00 | AAPL | Stock | 1.1391 | 1.1491 | 1.1321 | 1.1459 | 115344656.0 |
| 2004-12-22 11:00:00 | AAPL | Stock | 1.1461 | 1.1464 | 1.1425 | 1.1432 | 61690664.0 |
| 2004-12-22 12:00:00 | AAPL | Stock | 1.1432 | 1.1455 | 1.1379 | 1.1439 | 50258152.0 |
| 2004-12-22 13:00:00 | AAPL | Stock | 1.1443 | 1.1443 | 1.1339 | 1.1355 | 66333288.0 |
| 2004-12-22 14:00:00 | AAPL | Stock | 1.1355 | 1.1404 | 1.1339 | 1.1379 | 56158984.0 |
| 2004-12-22 15:00:00 | AAPL | Stock | 1.138 | 1.1396 | 1.1357 | 1.1375 | 91791504.0 |
| 2004-12-22 16:00:00 | AAPL | Stock | 1.1375 | 1.1391 | 1.1363 | 1.138 | 3911488.0 |
| 2004-12-22 17:00:00 | AAPL | Stock | 1.1377 | 1.1377 | 1.137 | 1.137 | 145600.0 |
| 2004-12-22 18:00:00 | AAPL | Stock | 1.1368 | 1.1375 | 1.1368 | 1.1375 | 108696.0 |
| 2004-12-22 08:00:00 | MSFT | Stock | 26.95 | 26.99 | 26.9 | 26.93 | 260015.0 |
| 2004-12-22 09:00:00 | MSFT | Stock | 26.94 | 27.02 | 26.8 | 26.94 | 12207199.0 |
| 2004-12-22 10:00:00 | MSFT | Stock | 26.95 | 27.121 | 26.92 | 27.07 | 13811270.0 |
| 2004-12-22 11:00:00 | MSFT | Stock | 27.08 | 27.12 | 27.02 | 27.1 | 10216104.0 |
| 2004-12-22 12:00:00 | MSFT | Stock | 27.1 | 27.1 | 27.0 | 27.03 | 3560499.0 |
| 2004-12-22 13:00:00 | MSFT | Stock | 27.02 | 27.03 | 26.91 | 26.948 | 5918325.0 |
| 2004-12-22 14:00:00 | MSFT | Stock | 26.95 | 26.97 | 26.92 | 26.94 | 4417797.0 |
| 2004-12-22 15:00:00 | MSFT | Stock | 26.94 | 27.05 | 26.94 | 26.98 | 7445374.0 |
| 2004-12-22 16:00:00 | MSFT | Stock | 26.97 | 26.99 | 26.91 | 26.94 | 3409111.0 |
| 2004-12-22 17:00:00 | MSFT | Stock | 26.97 | 27.0024 | 26.9186 | 26.96 | 551751.0 |
| 2004-12-22 18:00:00 | MSFT | Stock | 26.96 | 26.96 | 26.94 | 26.94 | 9200.0 |
| 2004-12-22 08:00:00 | NVDA | Stock | 0.1911 | 0.194 | 0.1911 | 0.194 | 730080.0 |
| 2004-12-22 09:00:00 | NVDA | Stock | 0.1925 | 0.1957 | 0.1917 | 0.1941 | 78714960.0 |
| 2004-12-22 10:00:00 | NVDA | Stock | 0.1941 | 0.1962 | 0.1933 | 0.1952 | 121066440.0 |
| 2004-12-22 11:00:00 | NVDA | Stock | 0.1952 | 0.1955 | 0.1934 | 0.194 | 51669600.0 |
| 2004-12-22 12:00:00 | NVDA | Stock | 0.1941 | 0.1941 | 0.1927 | 0.1933 | 26541600.0 |
| 2004-12-22 13:00:00 | NVDA | Stock | 0.1933 | 0.1933 | 0.1917 | 0.1918 | 33243000.0 |
| 2004-12-22 14:00:00 | NVDA | Stock | 0.1918 | 0.1921 | 0.1915 | 0.1916 | 34427520.0 |
| 2004-12-22 15:00:00 | NVDA | Stock | 0.1916 | 0.1922 | 0.1913 | 0.1919 | 70496520.0 |
| 2004-12-22 16:00:00 | NVDA | Stock | 0.1917 | 0.1922 | 0.1917 | 0.1919 | 2957880.0 |
| 2004-12-22 17:00:00 | NVDA | Stock | 0.1919 | 0.1919 | 0.1917 | 0.1919 | 742680.0 |
| 2004-12-22 18:00:00 | NVDA | Stock | 0.1917 | 0.1919 | 0.1917 | 0.1918 | 480000.0 |
| 2004-12-22 08:00:00 | AMZN | Stock | 1.9645 | 1.965 | 1.9645 | 1.965 | 30000.0 |
| 2004-12-22 09:00:00 | AMZN | Stock | 1.965 | 1.965 | 1.9275 | 1.949 | 19361300.0 |
| 2004-12-22 10:00:00 | AMZN | Stock | 1.948 | 1.955 | 1.9425 | 1.9515 | 20138780.0 |
| 2004-12-22 11:00:00 | AMZN | Stock | 1.9515 | 1.955 | 1.944 | 1.955 | 10288320.0 |
| 2004-12-22 12:00:00 | AMZN | Stock | 1.9549 | 1.9575 | 1.9505 | 1.957 | 6900420.0 |
| 2004-12-22 13:00:00 | AMZN | Stock | 1.9575 | 1.9595 | 1.9525 | 1.9595 | 8299140.0 |
| 2004-12-22 14:00:00 | AMZN | Stock | 1.9575 | 1.9685 | 1.9555 | 1.967 | 15335640.0 |
| 2004-12-22 15:00:00 | AMZN | Stock | 1.9675 | 1.9795 | 1.967 | 1.975 | 20191100.0 |
| 2004-12-22 16:00:00 | AMZN | Stock | 1.9745 | 1.9765 | 1.965 | 1.9745 | 3253680.0 |
| 2004-12-22 17:00:00 | AMZN | Stock | 1.975 | 1.978 | 1.9718 | 1.9775 | 81000.0 |
| 2004-12-22 18:00:00 | AMZN | Stock | 1.973 | 1.973 | 1.973 | 1.973 | 10000.0 |
| 2004-12-22 09:00:00 | CL | Stock | 25.15 | 25.25 | 25.13 | 25.175 | 383000.0 |
| 2004-12-22 10:00:00 | CL | Stock | 25.19 | 25.275 | 25.125 | 25.24 | 878400.0 |
| 2004-12-22 11:00:00 | CL | Stock | 25.24 | 25.27 | 25.185 | 25.235 | 775600.0 |
| 2004-12-22 12:00:00 | CL | Stock | 25.235 | 25.25 | 25.21 | 25.21 | 272200.0 |
| 2004-12-22 13:00:00 | CL | Stock | 25.21 | 25.23 | 25.2 | 25.22 | 390800.0 |
| 2004-12-22 14:00:00 | CL | Stock | 25.215 | 25.285 | 25.205 | 25.25 | 627000.0 |
> showing 50 of 25,316 rows — these rows as CSV