PREVIEW / stock_1hour / 2002-10-08
file: by_date/stock_1hour/2002/2002-10-08.parquet size: 405 KB rows: 19,355 symbols: 1,491
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 |
|---|---|---|---|---|---|---|---|
| 2002-10-08 08:00:00 | AAPL | Stock | 0.248 | 0.2495 | 0.248 | 0.2495 | 39200.0 |
| 2002-10-08 09:00:00 | AAPL | Stock | 0.2459 | 0.2493 | 0.2441 | 0.2445 | 53357080.0 |
| 2002-10-08 10:00:00 | AAPL | Stock | 0.2443 | 0.2455 | 0.2386 | 0.2393 | 94523072.0 |
| 2002-10-08 11:00:00 | AAPL | Stock | 0.2395 | 0.2414 | 0.2386 | 0.2395 | 46388384.0 |
| 2002-10-08 12:00:00 | AAPL | Stock | 0.2395 | 0.2473 | 0.2393 | 0.2468 | 66047240.0 |
| 2002-10-08 13:00:00 | AAPL | Stock | 0.247 | 0.247 | 0.2439 | 0.2459 | 48883576.0 |
| 2002-10-08 14:00:00 | AAPL | Stock | 0.2461 | 0.2475 | 0.2439 | 0.2452 | 50489824.0 |
| 2002-10-08 15:00:00 | AAPL | Stock | 0.2452 | 0.2464 | 0.2436 | 0.2445 | 67434192.0 |
| 2002-10-08 16:00:00 | AAPL | Stock | 0.2445 | 0.245 | 0.2434 | 0.2444 | 10760680.0 |
| 2002-10-08 08:00:00 | MSFT | Stock | 22.24 | 22.395 | 22.15 | 22.3595 | 121224.0 |
| 2002-10-08 09:00:00 | MSFT | Stock | 22.35 | 22.45 | 22.265 | 22.28 | 12045840.0 |
| 2002-10-08 10:00:00 | MSFT | Stock | 22.2705 | 22.655 | 22.2555 | 22.36 | 18514986.0 |
| 2002-10-08 11:00:00 | MSFT | Stock | 22.37 | 22.44 | 22.22 | 22.245 | 14217380.0 |
| 2002-10-08 12:00:00 | MSFT | Stock | 22.25 | 22.505 | 22.065 | 22.47 | 14545234.0 |
| 2002-10-08 13:00:00 | MSFT | Stock | 22.47 | 22.7 | 22.27 | 22.64 | 14924614.0 |
| 2002-10-08 14:00:00 | MSFT | Stock | 22.635 | 22.98 | 22.575 | 22.86 | 15914398.0 |
| 2002-10-08 15:00:00 | MSFT | Stock | 22.86 | 22.96 | 22.4 | 22.495 | 19424710.0 |
| 2002-10-08 16:00:00 | MSFT | Stock | 22.485 | 22.565 | 22.35 | 22.5495 | 2871580.0 |
| 2002-10-08 17:00:00 | MSFT | Stock | 22.5495 | 22.58 | 22.5155 | 22.575 | 11750.0 |
| 2002-10-08 18:00:00 | MSFT | Stock | 22.565 | 22.6 | 22.565 | 22.6 | 13600.0 |
| 2002-10-08 08:00:00 | NVDA | Stock | 0.0663 | 0.0663 | 0.0657 | 0.0659 | 894000.0 |
| 2002-10-08 09:00:00 | NVDA | Stock | 0.066 | 0.0668 | 0.0635 | 0.0637 | 82279200.0 |
| 2002-10-08 10:00:00 | NVDA | Stock | 0.0637 | 0.065 | 0.0633 | 0.0633 | 112712040.0 |
| 2002-10-08 11:00:00 | NVDA | Stock | 0.0633 | 0.0636 | 0.06 | 0.0602 | 128364240.0 |
| 2002-10-08 12:00:00 | NVDA | Stock | 0.0602 | 0.0621 | 0.0602 | 0.0621 | 77844240.0 |
| 2002-10-08 13:00:00 | NVDA | Stock | 0.062 | 0.0632 | 0.0615 | 0.063 | 45904320.0 |
| 2002-10-08 14:00:00 | NVDA | Stock | 0.0627 | 0.0647 | 0.0623 | 0.0637 | 69337920.0 |
| 2002-10-08 15:00:00 | NVDA | Stock | 0.0637 | 0.0647 | 0.0622 | 0.0622 | 102845400.0 |
| 2002-10-08 16:00:00 | NVDA | Stock | 0.0626 | 0.0633 | 0.0621 | 0.0629 | 64875480.0 |
| 2002-10-08 17:00:00 | NVDA | Stock | 0.0628 | 0.0629 | 0.0625 | 0.0628 | 2441160.0 |
| 2002-10-08 18:00:00 | NVDA | Stock | 0.0629 | 0.0629 | 0.0625 | 0.0629 | 109440.0 |
| 2002-10-08 08:00:00 | AMZN | Stock | 0.8312 | 0.8375 | 0.8312 | 0.837 | 328000.0 |
| 2002-10-08 09:00:00 | AMZN | Stock | 0.8375 | 0.847 | 0.8365 | 0.8415 | 9793040.0 |
| 2002-10-08 10:00:00 | AMZN | Stock | 0.8425 | 0.845 | 0.8365 | 0.8375 | 12793700.0 |
| 2002-10-08 11:00:00 | AMZN | Stock | 0.837 | 0.838 | 0.823 | 0.8255 | 11509400.0 |
| 2002-10-08 12:00:00 | AMZN | Stock | 0.826 | 0.8385 | 0.825 | 0.837 | 24440160.0 |
| 2002-10-08 13:00:00 | AMZN | Stock | 0.837 | 0.8415 | 0.8275 | 0.8415 | 21399100.0 |
| 2002-10-08 14:00:00 | AMZN | Stock | 0.841 | 0.8515 | 0.84 | 0.85 | 16712980.0 |
| 2002-10-08 15:00:00 | AMZN | Stock | 0.85 | 0.8531 | 0.844 | 0.8465 | 18053600.0 |
| 2002-10-08 16:00:00 | AMZN | Stock | 0.8465 | 0.8505 | 0.8375 | 0.8494 | 1353980.0 |
| 2002-10-08 17:00:00 | AMZN | Stock | 0.847 | 0.847 | 0.847 | 0.847 | 4000.0 |
| 2002-10-08 09:00:00 | CL | Stock | 27.5 | 27.5 | 27.3 | 27.435 | 591200.0 |
| 2002-10-08 10:00:00 | CL | Stock | 27.435 | 27.625 | 27.4 | 27.415 | 538000.0 |
| 2002-10-08 11:00:00 | CL | Stock | 27.415 | 27.49 | 27.3 | 27.3 | 548400.0 |
| 2002-10-08 12:00:00 | CL | Stock | 27.28 | 27.525 | 27.275 | 27.525 | 518200.0 |
| 2002-10-08 13:00:00 | CL | Stock | 27.505 | 27.59 | 27.255 | 27.59 | 624400.0 |
| 2002-10-08 14:00:00 | CL | Stock | 27.59 | 27.915 | 27.56 | 27.835 | 652600.0 |
| 2002-10-08 15:00:00 | CL | Stock | 27.825 | 27.85 | 27.61 | 27.655 | 928600.0 |
| 2002-10-08 16:00:00 | CL | Stock | 27.65 | 27.655 | 27.65 | 27.655 | 215600.0 |
> showing 49 of 19,355 rows — these rows as CSV