PREVIEW / stock_1hour / 2002-10-09
file: by_date/stock_1hour/2002/2002-10-09.parquet size: 409 KB rows: 20,119 symbols: 1,495
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-09 08:00:00 | AAPL | Stock | 0.2321 | 0.2442 | 0.2321 | 0.2393 | 78400.0 |
| 2002-10-09 09:00:00 | AAPL | Stock | 0.2393 | 0.2439 | 0.2393 | 0.2427 | 21926464.0 |
| 2002-10-09 10:00:00 | AAPL | Stock | 0.2429 | 0.2473 | 0.2411 | 0.2446 | 68076456.0 |
| 2002-10-09 11:00:00 | AAPL | Stock | 0.2447 | 0.2466 | 0.243 | 0.2459 | 55331920.0 |
| 2002-10-09 12:00:00 | AAPL | Stock | 0.2457 | 0.2464 | 0.2436 | 0.2445 | 42191576.0 |
| 2002-10-09 13:00:00 | AAPL | Stock | 0.2445 | 0.245 | 0.242 | 0.2441 | 43846712.0 |
| 2002-10-09 14:00:00 | AAPL | Stock | 0.2441 | 0.2446 | 0.2423 | 0.2425 | 62706952.0 |
| 2002-10-09 15:00:00 | AAPL | Stock | 0.2427 | 0.2445 | 0.2407 | 0.2429 | 45355184.0 |
| 2002-10-09 16:00:00 | AAPL | Stock | 0.2429 | 0.2432 | 0.2427 | 0.2432 | 2862048.0 |
| 2002-10-09 17:00:00 | AAPL | Stock | 0.2428 | 0.2428 | 0.2428 | 0.2428 | 1142400.0 |
| 2002-10-09 18:00:00 | AAPL | Stock | 0.2428 | 0.2428 | 0.2428 | 0.2428 | 425600.0 |
| 2002-10-09 08:00:00 | MSFT | Stock | 22.3255 | 22.74 | 21.76 | 22.03 | 358348.0 |
| 2002-10-09 09:00:00 | MSFT | Stock | 22.14 | 22.495 | 22.031 | 22.195 | 13427080.0 |
| 2002-10-09 10:00:00 | MSFT | Stock | 22.195 | 22.725 | 22.105 | 22.39 | 23110516.0 |
| 2002-10-09 11:00:00 | MSFT | Stock | 22.4 | 22.66 | 22.32 | 22.58 | 14808328.0 |
| 2002-10-09 12:00:00 | MSFT | Stock | 22.58 | 22.595 | 22.075 | 22.23 | 16693772.0 |
| 2002-10-09 13:00:00 | MSFT | Stock | 22.24 | 22.595 | 22.195 | 22.475 | 13193760.0 |
| 2002-10-09 14:00:00 | MSFT | Stock | 22.47 | 22.555 | 22.14 | 22.155 | 14983062.0 |
| 2002-10-09 15:00:00 | MSFT | Stock | 22.163 | 22.28 | 21.905 | 21.9945 | 21489162.0 |
| 2002-10-09 16:00:00 | MSFT | Stock | 21.975 | 22.075 | 21.95 | 22.06 | 1390278.0 |
| 2002-10-09 17:00:00 | MSFT | Stock | 22.04 | 22.15 | 21.995 | 22.1 | 204180.0 |
| 2002-10-09 18:00:00 | MSFT | Stock | 22.1 | 22.15 | 21.995 | 22.075 | 81000.0 |
| 2002-10-09 08:00:00 | NVDA | Stock | 0.0624 | 0.0624 | 0.0592 | 0.0604 | 876000.0 |
| 2002-10-09 09:00:00 | NVDA | Stock | 0.0613 | 0.0623 | 0.0609 | 0.0615 | 50017440.0 |
| 2002-10-09 10:00:00 | NVDA | Stock | 0.0614 | 0.0641 | 0.0603 | 0.0632 | 125594400.0 |
| 2002-10-09 11:00:00 | NVDA | Stock | 0.0631 | 0.0641 | 0.0622 | 0.0637 | 64621440.0 |
| 2002-10-09 12:00:00 | NVDA | Stock | 0.0637 | 0.064 | 0.0625 | 0.0636 | 41392800.0 |
| 2002-10-09 13:00:00 | NVDA | Stock | 0.0636 | 0.0657 | 0.0629 | 0.065 | 68604720.0 |
| 2002-10-09 14:00:00 | NVDA | Stock | 0.065 | 0.065 | 0.0622 | 0.0623 | 83287440.0 |
| 2002-10-09 15:00:00 | NVDA | Stock | 0.0623 | 0.0628 | 0.0607 | 0.0614 | 106369560.0 |
| 2002-10-09 16:00:00 | NVDA | Stock | 0.0612 | 0.0617 | 0.0608 | 0.0612 | 19917600.0 |
| 2002-10-09 17:00:00 | NVDA | Stock | 0.0609 | 0.0622 | 0.0609 | 0.0617 | 2064000.0 |
| 2002-10-09 18:00:00 | NVDA | Stock | 0.0614 | 0.0614 | 0.0614 | 0.0614 | 288000.0 |
| 2002-10-09 08:00:00 | AMZN | Stock | 0.85 | 0.85 | 0.8306 | 0.835 | 58000.0 |
| 2002-10-09 09:00:00 | AMZN | Stock | 0.835 | 0.847 | 0.83 | 0.836 | 10848980.0 |
| 2002-10-09 10:00:00 | AMZN | Stock | 0.835 | 0.855 | 0.8325 | 0.852 | 18273460.0 |
| 2002-10-09 11:00:00 | AMZN | Stock | 0.852 | 0.8565 | 0.8485 | 0.854 | 15762500.0 |
| 2002-10-09 12:00:00 | AMZN | Stock | 0.855 | 0.855 | 0.8395 | 0.844 | 17010140.0 |
| 2002-10-09 13:00:00 | AMZN | Stock | 0.843 | 0.85 | 0.834 | 0.848 | 18304340.0 |
| 2002-10-09 14:00:00 | AMZN | Stock | 0.8485 | 0.8535 | 0.845 | 0.846 | 14868500.0 |
| 2002-10-09 15:00:00 | AMZN | Stock | 0.8465 | 0.851 | 0.84 | 0.845 | 17586360.0 |
| 2002-10-09 16:00:00 | AMZN | Stock | 0.8445 | 0.8575 | 0.843 | 0.8475 | 3619000.0 |
| 2002-10-09 17:00:00 | AMZN | Stock | 0.8485 | 0.85 | 0.843 | 0.85 | 364000.0 |
| 2002-10-09 18:00:00 | AMZN | Stock | 0.85 | 0.8525 | 0.843 | 0.845 | 226000.0 |
| 2002-10-09 09:00:00 | CL | Stock | 27.3 | 27.475 | 27.3 | 27.405 | 336800.0 |
| 2002-10-09 10:00:00 | CL | Stock | 27.385 | 27.525 | 27.155 | 27.25 | 615600.0 |
| 2002-10-09 11:00:00 | CL | Stock | 27.24 | 27.43 | 27.18 | 27.395 | 861400.0 |
| 2002-10-09 12:00:00 | CL | Stock | 27.4 | 27.54 | 27.21 | 27.535 | 793400.0 |
| 2002-10-09 13:00:00 | CL | Stock | 27.53 | 27.54 | 27.275 | 27.48 | 529600.0 |
| 2002-10-09 14:00:00 | CL | Stock | 27.47 | 27.555 | 27.265 | 27.29 | 492400.0 |
> showing 50 of 20,119 rows — these rows as CSV