PREVIEW / stock_1hour / 2003-10-07
file: by_date/stock_1hour/2003/2003-10-07.parquet size: 474 KB rows: 21,886 symbols: 1,629
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-10-07 08:00:00 | AAPL | Stock | 0.3979 | 0.3979 | 0.3929 | 0.3946 | 1120000.0 |
| 2003-10-07 09:00:00 | AAPL | Stock | 0.3946 | 0.4009 | 0.3913 | 0.3991 | 43990296.0 |
| 2003-10-07 10:00:00 | AAPL | Stock | 0.3989 | 0.4018 | 0.3945 | 0.4005 | 47564888.0 |
| 2003-10-07 11:00:00 | AAPL | Stock | 0.4005 | 0.4046 | 0.4003 | 0.4025 | 50200528.0 |
| 2003-10-07 12:00:00 | AAPL | Stock | 0.4023 | 0.405 | 0.4011 | 0.4029 | 48811952.0 |
| 2003-10-07 13:00:00 | AAPL | Stock | 0.4027 | 0.4041 | 0.4025 | 0.4036 | 31180744.0 |
| 2003-10-07 14:00:00 | AAPL | Stock | 0.4036 | 0.4114 | 0.4036 | 0.4107 | 56177408.0 |
| 2003-10-07 15:00:00 | AAPL | Stock | 0.4107 | 0.418 | 0.4098 | 0.4146 | 80036824.0 |
| 2003-10-07 16:00:00 | AAPL | Stock | 0.4143 | 0.4152 | 0.4036 | 0.4145 | 1831200.0 |
| 2003-10-07 17:00:00 | AAPL | Stock | 0.4134 | 0.4143 | 0.4134 | 0.4143 | 11200.0 |
| 2003-10-07 08:00:00 | MSFT | Stock | 29.25 | 29.25 | 28.95 | 29.001 | 48900.0 |
| 2003-10-07 09:00:00 | MSFT | Stock | 29.0 | 29.2 | 28.95 | 29.109 | 4931699.0 |
| 2003-10-07 10:00:00 | MSFT | Stock | 29.1 | 29.23 | 28.92 | 29.14 | 6445540.0 |
| 2003-10-07 11:00:00 | MSFT | Stock | 29.134 | 29.372 | 29.03 | 29.271 | 5924969.0 |
| 2003-10-07 12:00:00 | MSFT | Stock | 29.27 | 29.35 | 29.09 | 29.11 | 5345294.0 |
| 2003-10-07 13:00:00 | MSFT | Stock | 29.12 | 29.19 | 29.0 | 29.08 | 4271284.0 |
| 2003-10-07 14:00:00 | MSFT | Stock | 29.08 | 29.18 | 29.04 | 29.14 | 4779497.0 |
| 2003-10-07 15:00:00 | MSFT | Stock | 29.139 | 29.212 | 29.09 | 29.14 | 8664130.0 |
| 2003-10-07 16:00:00 | MSFT | Stock | 29.14 | 29.22 | 29.13 | 29.17 | 3724942.0 |
| 2003-10-07 17:00:00 | MSFT | Stock | 29.17 | 29.18 | 29.13 | 29.17 | 20070.0 |
| 2003-10-07 18:00:00 | MSFT | Stock | 29.17 | 29.17 | 29.14 | 29.141 | 7645.0 |
| 2003-10-07 08:00:00 | NVDA | Stock | 0.1375 | 0.1375 | 0.1367 | 0.1368 | 84000.0 |
| 2003-10-07 09:00:00 | NVDA | Stock | 0.1375 | 0.1399 | 0.1368 | 0.1394 | 56032920.0 |
| 2003-10-07 10:00:00 | NVDA | Stock | 0.1394 | 0.1395 | 0.1379 | 0.1379 | 75946320.0 |
| 2003-10-07 11:00:00 | NVDA | Stock | 0.1379 | 0.1387 | 0.1376 | 0.1378 | 63960600.0 |
| 2003-10-07 12:00:00 | NVDA | Stock | 0.1378 | 0.1382 | 0.1371 | 0.1373 | 49752480.0 |
| 2003-10-07 13:00:00 | NVDA | Stock | 0.1373 | 0.1378 | 0.1368 | 0.1371 | 33386880.0 |
| 2003-10-07 14:00:00 | NVDA | Stock | 0.1371 | 0.1385 | 0.1371 | 0.1381 | 56969280.0 |
| 2003-10-07 15:00:00 | NVDA | Stock | 0.1381 | 0.14 | 0.1381 | 0.1397 | 106867560.0 |
| 2003-10-07 16:00:00 | NVDA | Stock | 0.1397 | 0.1406 | 0.1397 | 0.1404 | 5182680.0 |
| 2003-10-07 17:00:00 | NVDA | Stock | 0.1404 | 0.1404 | 0.1394 | 0.1394 | 396000.0 |
| 2003-10-07 18:00:00 | NVDA | Stock | 0.1393 | 0.1393 | 0.1392 | 0.1392 | 276000.0 |
| 2003-10-07 08:00:00 | AMZN | Stock | 2.6955 | 2.712 | 2.69 | 2.6925 | 523000.0 |
| 2003-10-07 09:00:00 | AMZN | Stock | 2.7015 | 2.7355 | 2.69 | 2.732 | 50393360.0 |
| 2003-10-07 10:00:00 | AMZN | Stock | 2.733 | 2.755 | 2.72 | 2.7475 | 52356740.0 |
| 2003-10-07 11:00:00 | AMZN | Stock | 2.7475 | 2.8125 | 2.741 | 2.7995 | 81735980.0 |
| 2003-10-07 12:00:00 | AMZN | Stock | 2.7995 | 2.805 | 2.776 | 2.7815 | 42593280.0 |
| 2003-10-07 13:00:00 | AMZN | Stock | 2.7806 | 2.792 | 2.7675 | 2.774 | 27148160.0 |
| 2003-10-07 14:00:00 | AMZN | Stock | 2.774 | 2.7995 | 2.7735 | 2.79 | 24544640.0 |
| 2003-10-07 15:00:00 | AMZN | Stock | 2.792 | 2.7945 | 2.745 | 2.7475 | 59797460.0 |
| 2003-10-07 16:00:00 | AMZN | Stock | 2.7445 | 2.755 | 2.7395 | 2.7465 | 4118220.0 |
| 2003-10-07 17:00:00 | AMZN | Stock | 2.7465 | 2.7818 | 2.7435 | 2.744 | 222000.0 |
| 2003-10-07 18:00:00 | AMZN | Stock | 2.747 | 2.747 | 2.747 | 2.747 | 12000.0 |
| 2003-10-07 09:00:00 | CL | Stock | 28.845 | 28.845 | 28.716 | 28.795 | 188400.0 |
| 2003-10-07 10:00:00 | CL | Stock | 28.795 | 29.025 | 28.75 | 29.01 | 370200.0 |
| 2003-10-07 11:00:00 | CL | Stock | 29.01 | 29.07 | 28.92 | 28.99 | 262800.0 |
| 2003-10-07 12:00:00 | CL | Stock | 28.98 | 28.99 | 28.82 | 28.855 | 257400.0 |
| 2003-10-07 13:00:00 | CL | Stock | 28.82 | 28.92 | 28.755 | 28.785 | 204600.0 |
| 2003-10-07 14:00:00 | CL | Stock | 28.775 | 28.925 | 28.75 | 28.915 | 292600.0 |
| 2003-10-07 15:00:00 | CL | Stock | 28.915 | 29.035 | 28.86 | 28.975 | 460200.0 |
> showing 50 of 21,886 rows — these rows as CSV