PREVIEW / stock_1hour / 2001-08-13
file: by_date/stock_1hour/2001/2001-08-13.parquet size: 354 KB rows: 16,928 symbols: 1,324
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 |
|---|---|---|---|---|---|---|---|
| 2001-08-13 08:00:00 | AAPL | Stock | 0.3411 | 0.3411 | 0.3411 | 0.3411 | 112000.0 |
| 2001-08-13 09:00:00 | AAPL | Stock | 0.3404 | 0.3452 | 0.34 | 0.343 | 11894400.0 |
| 2001-08-13 10:00:00 | AAPL | Stock | 0.3434 | 0.345 | 0.335 | 0.3375 | 31516800.0 |
| 2001-08-13 11:00:00 | AAPL | Stock | 0.3379 | 0.3405 | 0.3373 | 0.3382 | 12728800.0 |
| 2001-08-13 12:00:00 | AAPL | Stock | 0.3388 | 0.3396 | 0.3375 | 0.3377 | 7386400.0 |
| 2001-08-13 13:00:00 | AAPL | Stock | 0.3379 | 0.3384 | 0.3368 | 0.3382 | 16508800.0 |
| 2001-08-13 14:00:00 | AAPL | Stock | 0.3384 | 0.3404 | 0.3366 | 0.3391 | 21509600.0 |
| 2001-08-13 15:00:00 | AAPL | Stock | 0.3391 | 0.3411 | 0.3384 | 0.3409 | 36736000.0 |
| 2001-08-13 16:00:00 | AAPL | Stock | 0.3409 | 0.3438 | 0.3395 | 0.3438 | 5096000.0 |
| 2001-08-13 18:00:00 | AAPL | Stock | 0.34 | 0.34 | 0.34 | 0.34 | 5600.0 |
| 2001-08-13 08:00:00 | MSFT | Stock | 32.65 | 32.85 | 32.65 | 32.785 | 13000.0 |
| 2001-08-13 09:00:00 | MSFT | Stock | 32.8 | 32.8 | 32.4 | 32.555 | 3893400.0 |
| 2001-08-13 10:00:00 | MSFT | Stock | 32.555 | 32.735 | 32.4 | 32.425 | 6207800.0 |
| 2001-08-13 11:00:00 | MSFT | Stock | 32.455 | 32.53 | 32.375 | 32.46 | 2844400.0 |
| 2001-08-13 12:00:00 | MSFT | Stock | 32.46 | 32.525 | 32.415 | 32.44 | 2746400.0 |
| 2001-08-13 13:00:00 | MSFT | Stock | 32.44 | 32.7 | 32.425 | 32.675 | 3842200.0 |
| 2001-08-13 14:00:00 | MSFT | Stock | 32.68 | 32.85 | 32.63 | 32.835 | 4565200.0 |
| 2001-08-13 15:00:00 | MSFT | Stock | 32.82 | 32.995 | 32.775 | 32.915 | 5630000.0 |
| 2001-08-13 16:00:00 | MSFT | Stock | 32.92 | 32.955 | 32.61 | 32.85 | 1330600.0 |
| 2001-08-13 17:00:00 | MSFT | Stock | 32.855 | 32.875 | 32.85 | 32.875 | 1400.0 |
| 2001-08-13 08:00:00 | NVDA | Stock | 0.3573 | 0.3573 | 0.3552 | 0.3573 | 2616000.0 |
| 2001-08-13 09:00:00 | NVDA | Stock | 0.3568 | 0.3624 | 0.3534 | 0.3606 | 211320000.0 |
| 2001-08-13 10:00:00 | NVDA | Stock | 0.3606 | 0.3623 | 0.356 | 0.3588 | 207456000.0 |
| 2001-08-13 11:00:00 | NVDA | Stock | 0.3588 | 0.361 | 0.3568 | 0.3588 | 107760000.0 |
| 2001-08-13 12:00:00 | NVDA | Stock | 0.359 | 0.3604 | 0.3575 | 0.3585 | 66792000.0 |
| 2001-08-13 13:00:00 | NVDA | Stock | 0.359 | 0.3656 | 0.359 | 0.3654 | 208968000.0 |
| 2001-08-13 14:00:00 | NVDA | Stock | 0.3654 | 0.3696 | 0.3641 | 0.3687 | 253392000.0 |
| 2001-08-13 15:00:00 | NVDA | Stock | 0.3685 | 0.3715 | 0.3647 | 0.3675 | 330456000.0 |
| 2001-08-13 16:00:00 | NVDA | Stock | 0.3675 | 0.3718 | 0.363 | 0.3678 | 30624000.0 |
| 2001-08-13 17:00:00 | NVDA | Stock | 0.3679 | 0.3682 | 0.3675 | 0.3678 | 1656000.0 |
| 2001-08-13 18:00:00 | NVDA | Stock | 0.3675 | 0.368 | 0.3675 | 0.3676 | 312000.0 |
| 2001-08-13 08:00:00 | AMZN | Stock | 0.4975 | 0.5025 | 0.497 | 0.5 | 172000.0 |
| 2001-08-13 09:00:00 | AMZN | Stock | 0.5 | 0.507 | 0.499 | 0.504 | 6710000.0 |
| 2001-08-13 10:00:00 | AMZN | Stock | 0.504 | 0.51 | 0.4985 | 0.5015 | 11510000.0 |
| 2001-08-13 11:00:00 | AMZN | Stock | 0.5015 | 0.5025 | 0.4905 | 0.4945 | 12768000.0 |
| 2001-08-13 12:00:00 | AMZN | Stock | 0.4945 | 0.4965 | 0.4885 | 0.495 | 20560000.0 |
| 2001-08-13 13:00:00 | AMZN | Stock | 0.495 | 0.5 | 0.4935 | 0.497 | 9666000.0 |
| 2001-08-13 14:00:00 | AMZN | Stock | 0.497 | 0.5065 | 0.494 | 0.506 | 12780000.0 |
| 2001-08-13 15:00:00 | AMZN | Stock | 0.507 | 0.5115 | 0.499 | 0.5065 | 16694000.0 |
| 2001-08-13 16:00:00 | AMZN | Stock | 0.506 | 0.5085 | 0.506 | 0.506 | 2560000.0 |
| 2001-08-13 17:00:00 | AMZN | Stock | 0.506 | 0.506 | 0.506 | 0.506 | 8000.0 |
| 2001-08-13 09:00:00 | CL | Stock | 26.875 | 27.04 | 26.86 | 26.95 | 212200.0 |
| 2001-08-13 10:00:00 | CL | Stock | 26.955 | 26.995 | 26.85 | 26.99 | 298000.0 |
| 2001-08-13 11:00:00 | CL | Stock | 26.99 | 27.175 | 26.925 | 27.1 | 291000.0 |
| 2001-08-13 12:00:00 | CL | Stock | 27.105 | 27.215 | 27.05 | 27.065 | 246400.0 |
| 2001-08-13 13:00:00 | CL | Stock | 27.055 | 27.45 | 27.055 | 27.425 | 424200.0 |
| 2001-08-13 14:00:00 | CL | Stock | 27.42 | 27.5 | 27.34 | 27.415 | 517600.0 |
| 2001-08-13 15:00:00 | CL | Stock | 27.415 | 27.525 | 27.275 | 27.315 | 770000.0 |
| 2001-08-13 16:00:00 | CL | Stock | 27.315 | 27.375 | 27.315 | 27.375 | 119400.0 |
> showing 49 of 16,928 rows — these rows as CSV