PREVIEW / stock_1hour / 2003-10-13
file: by_date/stock_1hour/2003/2003-10-13.parquet size: 463 KB rows: 21,950 symbols: 1,642
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-13 08:00:00 | AAPL | Stock | 0.4223 | 0.4245 | 0.4223 | 0.4245 | 145600.0 |
| 2003-10-13 09:00:00 | AAPL | Stock | 0.4239 | 0.4268 | 0.4236 | 0.4261 | 21781256.0 |
| 2003-10-13 10:00:00 | AAPL | Stock | 0.4266 | 0.4289 | 0.4255 | 0.4284 | 32767168.0 |
| 2003-10-13 11:00:00 | AAPL | Stock | 0.4282 | 0.4348 | 0.4279 | 0.4345 | 47716536.0 |
| 2003-10-13 12:00:00 | AAPL | Stock | 0.4345 | 0.4359 | 0.4341 | 0.4343 | 27134016.0 |
| 2003-10-13 13:00:00 | AAPL | Stock | 0.4341 | 0.435 | 0.4298 | 0.4336 | 29451800.0 |
| 2003-10-13 14:00:00 | AAPL | Stock | 0.4336 | 0.4345 | 0.4332 | 0.4334 | 17527272.0 |
| 2003-10-13 15:00:00 | AAPL | Stock | 0.4339 | 0.4357 | 0.4314 | 0.4345 | 63291200.0 |
| 2003-10-13 16:00:00 | AAPL | Stock | 0.4348 | 0.4418 | 0.4338 | 0.4348 | 1273608.0 |
| 2003-10-13 17:00:00 | AAPL | Stock | 0.4348 | 0.4357 | 0.4348 | 0.4357 | 22400.0 |
| 2003-10-13 18:00:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4357 | 0.4357 | 11200.0 |
| 2003-10-13 08:00:00 | MSFT | Stock | 29.0 | 29.19 | 29.0 | 29.05 | 91874.0 |
| 2003-10-13 09:00:00 | MSFT | Stock | 29.03 | 29.1 | 28.91 | 28.98 | 4405143.0 |
| 2003-10-13 10:00:00 | MSFT | Stock | 28.979 | 29.06 | 28.96 | 28.97 | 5477511.0 |
| 2003-10-13 11:00:00 | MSFT | Stock | 28.97 | 28.97 | 28.748 | 28.82 | 6390570.0 |
| 2003-10-13 12:00:00 | MSFT | Stock | 28.83 | 28.85 | 28.74 | 28.75 | 3368513.0 |
| 2003-10-13 13:00:00 | MSFT | Stock | 28.75 | 28.77 | 28.5 | 28.69 | 5949961.0 |
| 2003-10-13 14:00:00 | MSFT | Stock | 28.69 | 28.69 | 28.55 | 28.609 | 3650322.0 |
| 2003-10-13 15:00:00 | MSFT | Stock | 28.61 | 28.79 | 28.555 | 28.78 | 5971546.0 |
| 2003-10-13 16:00:00 | MSFT | Stock | 28.79 | 28.8 | 28.67 | 28.75 | 595492.0 |
| 2003-10-13 17:00:00 | MSFT | Stock | 28.76 | 28.77 | 28.73 | 28.73 | 14300.0 |
| 2003-10-13 18:00:00 | MSFT | Stock | 28.72 | 28.77 | 28.72 | 28.77 | 11000.0 |
| 2003-10-13 08:00:00 | NVDA | Stock | 0.1413 | 0.1415 | 0.1408 | 0.1413 | 831600.0 |
| 2003-10-13 09:00:00 | NVDA | Stock | 0.1413 | 0.1417 | 0.14 | 0.1412 | 38671560.0 |
| 2003-10-13 10:00:00 | NVDA | Stock | 0.1412 | 0.1437 | 0.1411 | 0.1422 | 134423640.0 |
| 2003-10-13 11:00:00 | NVDA | Stock | 0.1422 | 0.1422 | 0.1401 | 0.1415 | 86070240.0 |
| 2003-10-13 12:00:00 | NVDA | Stock | 0.1414 | 0.1417 | 0.1409 | 0.1413 | 29488920.0 |
| 2003-10-13 13:00:00 | NVDA | Stock | 0.1412 | 0.1412 | 0.1399 | 0.1408 | 33116280.0 |
| 2003-10-13 14:00:00 | NVDA | Stock | 0.1409 | 0.1411 | 0.1403 | 0.1408 | 17996520.0 |
| 2003-10-13 15:00:00 | NVDA | Stock | 0.1408 | 0.1413 | 0.1403 | 0.1411 | 51411120.0 |
| 2003-10-13 16:00:00 | NVDA | Stock | 0.141 | 0.1412 | 0.1402 | 0.1411 | 4920480.0 |
| 2003-10-13 17:00:00 | NVDA | Stock | 0.141 | 0.141 | 0.1409 | 0.1409 | 408000.0 |
| 2003-10-13 18:00:00 | NVDA | Stock | 0.1409 | 0.1409 | 0.1405 | 0.1405 | 168000.0 |
| 2003-10-13 08:00:00 | AMZN | Stock | 2.8925 | 2.9075 | 2.885 | 2.888 | 440680.0 |
| 2003-10-13 09:00:00 | AMZN | Stock | 2.89 | 2.902 | 2.876 | 2.899 | 27432100.0 |
| 2003-10-13 10:00:00 | AMZN | Stock | 2.899 | 2.9345 | 2.872 | 2.923 | 44220160.0 |
| 2003-10-13 11:00:00 | AMZN | Stock | 2.923 | 2.923 | 2.9035 | 2.917 | 15102840.0 |
| 2003-10-13 12:00:00 | AMZN | Stock | 2.917 | 2.9215 | 2.9025 | 2.9045 | 18929860.0 |
| 2003-10-13 13:00:00 | AMZN | Stock | 2.9065 | 2.909 | 2.88 | 2.891 | 19452560.0 |
| 2003-10-13 14:00:00 | AMZN | Stock | 2.891 | 2.905 | 2.891 | 2.9005 | 11095360.0 |
| 2003-10-13 15:00:00 | AMZN | Stock | 2.9025 | 2.916 | 2.8905 | 2.915 | 16452760.0 |
| 2003-10-13 16:00:00 | AMZN | Stock | 2.915 | 2.9345 | 2.896 | 2.9344 | 2028800.0 |
| 2003-10-13 17:00:00 | AMZN | Stock | 2.9285 | 2.9285 | 2.9138 | 2.921 | 166000.0 |
| 2003-10-13 09:00:00 | CL | Stock | 29.25 | 29.25 | 29.035 | 29.04 | 256600.0 |
| 2003-10-13 10:00:00 | CL | Stock | 29.04 | 29.175 | 29.035 | 29.115 | 269200.0 |
| 2003-10-13 11:00:00 | CL | Stock | 29.12 | 29.125 | 29.03 | 29.055 | 137000.0 |
| 2003-10-13 12:00:00 | CL | Stock | 29.055 | 29.085 | 28.99 | 29.01 | 403400.0 |
| 2003-10-13 13:00:00 | CL | Stock | 29.0 | 29.01 | 28.925 | 28.955 | 357200.0 |
| 2003-10-13 14:00:00 | CL | Stock | 28.96 | 29.005 | 28.925 | 29.005 | 177800.0 |
| 2003-10-13 15:00:00 | CL | Stock | 29.0 | 29.105 | 28.97 | 29.04 | 294600.0 |
> showing 50 of 21,950 rows — these rows as CSV