PREVIEW / stock_1hour / 2006-07-03
file: by_date/stock_1hour/2006/2006-07-03.parquet size: 396 KB rows: 17,270 symbols: 2,241
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 |
|---|---|---|---|---|---|---|---|
| 2006-07-03 08:00:00 | AAPL | Stock | 2.0525 | 2.0689 | 2.0525 | 2.0625 | 793520.0 |
| 2006-07-03 09:00:00 | AAPL | Stock | 2.0625 | 2.0779 | 2.04 | 2.0743 | 59235456.0 |
| 2006-07-03 10:00:00 | AAPL | Stock | 2.0739 | 2.0743 | 2.0543 | 2.0689 | 50356096.0 |
| 2006-07-03 11:00:00 | AAPL | Stock | 2.0689 | 2.0743 | 2.0675 | 2.0693 | 28956984.0 |
| 2006-07-03 12:00:00 | AAPL | Stock | 2.0693 | 2.0732 | 2.0625 | 2.0696 | 51091684.0 |
| 2006-07-03 13:00:00 | AAPL | Stock | 2.07 | 2.07 | 2.0696 | 2.0696 | 708456.0 |
| 2006-07-03 07:00:00 | MSFT | Stock | 23.45 | 23.45 | 23.45 | 23.45 | 600.0 |
| 2006-07-03 08:00:00 | MSFT | Stock | 23.39 | 23.49 | 23.3 | 23.3 | 31915.0 |
| 2006-07-03 09:00:00 | MSFT | Stock | 23.48 | 23.65 | 23.3 | 23.582 | 4141448.0 |
| 2006-07-03 10:00:00 | MSFT | Stock | 23.58 | 23.62 | 23.57 | 23.62 | 5499073.0 |
| 2006-07-03 11:00:00 | MSFT | Stock | 23.61 | 23.63 | 23.58 | 23.6 | 4743429.0 |
| 2006-07-03 12:00:00 | MSFT | Stock | 23.6 | 23.72 | 23.59 | 23.68 | 10497290.0 |
| 2006-07-03 13:00:00 | MSFT | Stock | 23.7 | 23.7 | 23.7 | 23.7 | 295203.0 |
| 2006-07-03 09:00:00 | NVDA | Stock | 0.358 | 0.3633 | 0.3575 | 0.3587 | 34889460.0 |
| 2006-07-03 10:00:00 | NVDA | Stock | 0.3587 | 0.3603 | 0.3585 | 0.359 | 41288280.0 |
| 2006-07-03 11:00:00 | NVDA | Stock | 0.359 | 0.36 | 0.3577 | 0.358 | 34153320.0 |
| 2006-07-03 12:00:00 | NVDA | Stock | 0.358 | 0.3602 | 0.3577 | 0.3595 | 41829000.0 |
| 2006-07-03 13:00:00 | NVDA | Stock | 0.3595 | 0.36 | 0.3595 | 0.36 | 2793660.0 |
| 2006-07-03 08:00:00 | AMZN | Stock | 1.934 | 1.934 | 1.934 | 1.934 | 432000.0 |
| 2006-07-03 09:00:00 | AMZN | Stock | 1.934 | 1.9345 | 1.919 | 1.919 | 4558380.0 |
| 2006-07-03 10:00:00 | AMZN | Stock | 1.9195 | 1.9275 | 1.9115 | 1.9165 | 7476420.0 |
| 2006-07-03 11:00:00 | AMZN | Stock | 1.917 | 1.927 | 1.9145 | 1.9265 | 6277620.0 |
| 2006-07-03 12:00:00 | AMZN | Stock | 1.9265 | 1.9308 | 1.9225 | 1.9295 | 8530920.0 |
| 2006-07-03 13:00:00 | AMZN | Stock | 1.9305 | 1.9305 | 1.9305 | 1.9305 | 213220.0 |
| 2006-07-03 09:00:00 | CL | Stock | 29.635 | 29.77 | 29.635 | 29.745 | 550400.0 |
| 2006-07-03 10:00:00 | CL | Stock | 29.755 | 29.825 | 29.695 | 29.825 | 432400.0 |
| 2006-07-03 11:00:00 | CL | Stock | 29.83 | 29.985 | 29.79 | 29.965 | 411800.0 |
| 2006-07-03 12:00:00 | CL | Stock | 29.965 | 29.975 | 29.905 | 29.97 | 391000.0 |
| 2006-07-03 13:00:00 | CL | Stock | 29.95 | 29.95 | 29.94 | 29.94 | 64600.0 |
> showing 29 of 17,270 rows — these rows as CSV