PREVIEW / stock_1hour / 2003-10-06
file: by_date/stock_1hour/2003/2003-10-06.parquet size: 460 KB rows: 21,589 symbols: 1,623
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-06 09:00:00 | AAPL | Stock | 0.3873 | 0.3898 | 0.3854 | 0.3891 | 10715376.0 |
| 2003-10-06 10:00:00 | AAPL | Stock | 0.3889 | 0.3914 | 0.3886 | 0.3895 | 30447368.0 |
| 2003-10-06 11:00:00 | AAPL | Stock | 0.3891 | 0.3918 | 0.3891 | 0.3918 | 18333840.0 |
| 2003-10-06 12:00:00 | AAPL | Stock | 0.3916 | 0.3952 | 0.3916 | 0.3941 | 30390752.0 |
| 2003-10-06 13:00:00 | AAPL | Stock | 0.3939 | 0.3946 | 0.3934 | 0.3945 | 24936576.0 |
| 2003-10-06 14:00:00 | AAPL | Stock | 0.3945 | 0.3963 | 0.3938 | 0.395 | 23447312.0 |
| 2003-10-06 15:00:00 | AAPL | Stock | 0.395 | 0.3988 | 0.395 | 0.3988 | 86884896.0 |
| 2003-10-06 16:00:00 | AAPL | Stock | 0.398 | 0.4014 | 0.3973 | 0.4014 | 14289240.0 |
| 2003-10-06 17:00:00 | AAPL | Stock | 0.398 | 0.398 | 0.398 | 0.398 | 28000.0 |
| 2003-10-06 08:00:00 | MSFT | Stock | 29.25 | 29.36 | 29.2 | 29.3 | 47500.0 |
| 2003-10-06 09:00:00 | MSFT | Stock | 29.261 | 29.3 | 28.91 | 29.05 | 4265888.0 |
| 2003-10-06 10:00:00 | MSFT | Stock | 29.05 | 29.15 | 28.99 | 29.05 | 5716439.0 |
| 2003-10-06 11:00:00 | MSFT | Stock | 29.04 | 29.08 | 29.008 | 29.06 | 2499375.0 |
| 2003-10-06 12:00:00 | MSFT | Stock | 29.05 | 29.18 | 29.009 | 29.08 | 3862116.0 |
| 2003-10-06 13:00:00 | MSFT | Stock | 29.081 | 29.16 | 29.06 | 29.09 | 1833321.0 |
| 2003-10-06 14:00:00 | MSFT | Stock | 29.1 | 29.22 | 29.045 | 29.08 | 3369599.0 |
| 2003-10-06 15:00:00 | MSFT | Stock | 29.08 | 29.3 | 29.02 | 29.19 | 5197862.0 |
| 2003-10-06 16:00:00 | MSFT | Stock | 29.2 | 29.25 | 29.13 | 29.17 | 3282207.0 |
| 2003-10-06 17:00:00 | MSFT | Stock | 29.18 | 29.2 | 29.17 | 29.18 | 22500.0 |
| 2003-10-06 18:00:00 | MSFT | Stock | 29.19 | 29.24 | 29.16 | 29.16 | 6352.0 |
| 2003-10-06 08:00:00 | NVDA | Stock | 0.1398 | 0.1408 | 0.1398 | 0.1408 | 36000.0 |
| 2003-10-06 09:00:00 | NVDA | Stock | 0.1408 | 0.1415 | 0.1392 | 0.1401 | 54358080.0 |
| 2003-10-06 10:00:00 | NVDA | Stock | 0.1398 | 0.1404 | 0.1376 | 0.1383 | 66274320.0 |
| 2003-10-06 11:00:00 | NVDA | Stock | 0.1383 | 0.1397 | 0.1377 | 0.1387 | 42027240.0 |
| 2003-10-06 12:00:00 | NVDA | Stock | 0.1386 | 0.1393 | 0.1383 | 0.1387 | 29685480.0 |
| 2003-10-06 13:00:00 | NVDA | Stock | 0.1387 | 0.1389 | 0.1382 | 0.1387 | 18578160.0 |
| 2003-10-06 14:00:00 | NVDA | Stock | 0.1387 | 0.1394 | 0.1383 | 0.1387 | 26275080.0 |
| 2003-10-06 15:00:00 | NVDA | Stock | 0.1386 | 0.1393 | 0.138 | 0.1385 | 70407480.0 |
| 2003-10-06 16:00:00 | NVDA | Stock | 0.1387 | 0.1389 | 0.1383 | 0.1386 | 4300080.0 |
| 2003-10-06 17:00:00 | NVDA | Stock | 0.1387 | 0.1387 | 0.138 | 0.138 | 4104000.0 |
| 2003-10-06 18:00:00 | NVDA | Stock | 0.1386 | 0.1387 | 0.1386 | 0.1387 | 36000.0 |
| 2003-10-06 08:00:00 | AMZN | Stock | 2.644 | 2.66 | 2.644 | 2.6515 | 135260.0 |
| 2003-10-06 09:00:00 | AMZN | Stock | 2.6505 | 2.6625 | 2.6295 | 2.66 | 21447840.0 |
| 2003-10-06 10:00:00 | AMZN | Stock | 2.66 | 2.6825 | 2.6375 | 2.6485 | 34310480.0 |
| 2003-10-06 11:00:00 | AMZN | Stock | 2.648 | 2.6615 | 2.6405 | 2.66 | 17058240.0 |
| 2003-10-06 12:00:00 | AMZN | Stock | 2.66 | 2.69 | 2.657 | 2.6765 | 19013220.0 |
| 2003-10-06 13:00:00 | AMZN | Stock | 2.6765 | 2.6875 | 2.675 | 2.686 | 10136720.0 |
| 2003-10-06 14:00:00 | AMZN | Stock | 2.6855 | 2.7 | 2.6815 | 2.6915 | 14058820.0 |
| 2003-10-06 15:00:00 | AMZN | Stock | 2.6915 | 2.71 | 2.688 | 2.706 | 19362120.0 |
| 2003-10-06 16:00:00 | AMZN | Stock | 2.7105 | 2.7175 | 2.7049 | 2.7175 | 915980.0 |
| 2003-10-06 17:00:00 | AMZN | Stock | 2.7075 | 2.7205 | 2.7075 | 2.72 | 1528000.0 |
| 2003-10-06 18:00:00 | AMZN | Stock | 2.722 | 2.725 | 2.712 | 2.7245 | 168000.0 |
| 2003-10-06 09:00:00 | CL | Stock | 28.725 | 28.825 | 28.71 | 28.765 | 166600.0 |
| 2003-10-06 10:00:00 | CL | Stock | 28.775 | 28.8 | 28.705 | 28.725 | 313400.0 |
| 2003-10-06 11:00:00 | CL | Stock | 28.735 | 28.775 | 28.675 | 28.76 | 412000.0 |
| 2003-10-06 12:00:00 | CL | Stock | 28.765 | 28.81 | 28.73 | 28.805 | 254400.0 |
| 2003-10-06 13:00:00 | CL | Stock | 28.8 | 28.905 | 28.795 | 28.89 | 199600.0 |
| 2003-10-06 14:00:00 | CL | Stock | 28.88 | 28.93 | 28.81 | 28.825 | 168000.0 |
| 2003-10-06 15:00:00 | CL | Stock | 28.83 | 28.85 | 28.805 | 28.845 | 388200.0 |
| 2003-10-06 16:00:00 | CL | Stock | 28.84 | 28.845 | 28.7924 | 28.7924 | 94800.0 |
> showing 50 of 21,589 rows — these rows as CSV