PREVIEW / stock_1hour / 2002-02-06
file: by_date/stock_1hour/2002/2002-02-06.parquet size: 378 KB rows: 18,560 symbols: 1,393
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-02-06 08:00:00 | AAPL | Stock | 0.4545 | 0.458 | 0.4545 | 0.4575 | 722400.0 |
| 2002-02-06 09:00:00 | AAPL | Stock | 0.4575 | 0.4639 | 0.4568 | 0.4616 | 71428000.0 |
| 2002-02-06 10:00:00 | AAPL | Stock | 0.4616 | 0.4634 | 0.433 | 0.4346 | 140431200.0 |
| 2002-02-06 11:00:00 | AAPL | Stock | 0.4345 | 0.4393 | 0.4336 | 0.4384 | 81524800.0 |
| 2002-02-06 12:00:00 | AAPL | Stock | 0.4384 | 0.4518 | 0.4377 | 0.4475 | 83367200.0 |
| 2002-02-06 13:00:00 | AAPL | Stock | 0.4475 | 0.4527 | 0.4448 | 0.45 | 41753600.0 |
| 2002-02-06 14:00:00 | AAPL | Stock | 0.4502 | 0.4536 | 0.4436 | 0.4454 | 49784000.0 |
| 2002-02-06 15:00:00 | AAPL | Stock | 0.4447 | 0.4473 | 0.4384 | 0.4409 | 63134400.0 |
| 2002-02-06 16:00:00 | AAPL | Stock | 0.4405 | 0.4491 | 0.4405 | 0.4405 | 18631200.0 |
| 2002-02-06 17:00:00 | AAPL | Stock | 0.442 | 0.442 | 0.4375 | 0.4375 | 795200.0 |
| 2002-02-06 18:00:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4332 | 0.4332 | 61600.0 |
| 2002-02-06 08:00:00 | MSFT | Stock | 30.49 | 30.78 | 30.35 | 30.755 | 107200.0 |
| 2002-02-06 09:00:00 | MSFT | Stock | 30.75 | 30.875 | 30.53 | 30.605 | 8480000.0 |
| 2002-02-06 10:00:00 | MSFT | Stock | 30.605 | 30.945 | 30.47 | 30.5445 | 12718400.0 |
| 2002-02-06 11:00:00 | MSFT | Stock | 30.58 | 30.71 | 30.3 | 30.4485 | 10268200.0 |
| 2002-02-06 12:00:00 | MSFT | Stock | 30.44 | 30.6795 | 30.225 | 30.485 | 10341600.0 |
| 2002-02-06 13:00:00 | MSFT | Stock | 30.49 | 30.755 | 30.385 | 30.435 | 6759200.0 |
| 2002-02-06 14:00:00 | MSFT | Stock | 30.43 | 30.67 | 30.2445 | 30.34 | 6625600.0 |
| 2002-02-06 15:00:00 | MSFT | Stock | 30.34 | 30.45 | 30.125 | 30.2 | 8724200.0 |
| 2002-02-06 16:00:00 | MSFT | Stock | 30.205 | 30.645 | 30.18 | 30.41 | 1196600.0 |
| 2002-02-06 17:00:00 | MSFT | Stock | 30.425 | 30.425 | 29.85 | 29.895 | 301000.0 |
| 2002-02-06 18:00:00 | MSFT | Stock | 29.85 | 29.95 | 29.805 | 29.84 | 22400.0 |
| 2002-02-06 08:00:00 | NVDA | Stock | 0.5114 | 0.5233 | 0.5083 | 0.5181 | 13296000.0 |
| 2002-02-06 09:00:00 | NVDA | Stock | 0.5183 | 0.5212 | 0.515 | 0.5163 | 209220000.0 |
| 2002-02-06 10:00:00 | NVDA | Stock | 0.5164 | 0.5196 | 0.5075 | 0.5142 | 349656000.0 |
| 2002-02-06 11:00:00 | NVDA | Stock | 0.5142 | 0.52 | 0.5133 | 0.5167 | 149532000.0 |
| 2002-02-06 12:00:00 | NVDA | Stock | 0.5167 | 0.525 | 0.5141 | 0.5222 | 117240000.0 |
| 2002-02-06 13:00:00 | NVDA | Stock | 0.5222 | 0.5257 | 0.52 | 0.522 | 93348000.0 |
| 2002-02-06 14:00:00 | NVDA | Stock | 0.5219 | 0.5246 | 0.5127 | 0.5182 | 120624000.0 |
| 2002-02-06 15:00:00 | NVDA | Stock | 0.5179 | 0.5219 | 0.5159 | 0.517 | 162384000.0 |
| 2002-02-06 16:00:00 | NVDA | Stock | 0.5168 | 0.5243 | 0.5166 | 0.5222 | 7596000.0 |
| 2002-02-06 17:00:00 | NVDA | Stock | 0.5205 | 0.5208 | 0.5127 | 0.5127 | 4728000.0 |
| 2002-02-06 18:00:00 | NVDA | Stock | 0.5127 | 0.5133 | 0.5108 | 0.5117 | 792000.0 |
| 2002-02-06 08:00:00 | AMZN | Stock | 0.57 | 0.5905 | 0.5625 | 0.5895 | 292000.0 |
| 2002-02-06 09:00:00 | AMZN | Stock | 0.5875 | 0.6 | 0.585 | 0.594 | 23752000.0 |
| 2002-02-06 10:00:00 | AMZN | Stock | 0.5934 | 0.595 | 0.566 | 0.5741 | 39700000.0 |
| 2002-02-06 11:00:00 | AMZN | Stock | 0.5745 | 0.5815 | 0.5625 | 0.5695 | 23852000.0 |
| 2002-02-06 12:00:00 | AMZN | Stock | 0.57 | 0.5845 | 0.5635 | 0.583 | 18122000.0 |
| 2002-02-06 13:00:00 | AMZN | Stock | 0.5835 | 0.592 | 0.5785 | 0.5825 | 18836000.0 |
| 2002-02-06 14:00:00 | AMZN | Stock | 0.583 | 0.587 | 0.5754 | 0.579 | 8370000.0 |
| 2002-02-06 15:00:00 | AMZN | Stock | 0.5785 | 0.5825 | 0.56 | 0.56 | 31362000.0 |
| 2002-02-06 16:00:00 | AMZN | Stock | 0.5606 | 0.5755 | 0.5575 | 0.5735 | 12316000.0 |
| 2002-02-06 17:00:00 | AMZN | Stock | 0.5735 | 0.5735 | 0.545 | 0.545 | 316000.0 |
| 2002-02-06 18:00:00 | AMZN | Stock | 0.541 | 0.541 | 0.5385 | 0.5385 | 104000.0 |
| 2002-02-06 09:00:00 | CL | Stock | 27.875 | 27.875 | 27.55 | 27.64 | 718600.0 |
| 2002-02-06 10:00:00 | CL | Stock | 27.64 | 27.7 | 27.45 | 27.65 | 1192600.0 |
| 2002-02-06 11:00:00 | CL | Stock | 27.625 | 27.75 | 27.6 | 27.74 | 938600.0 |
| 2002-02-06 12:00:00 | CL | Stock | 27.735 | 27.76 | 27.535 | 27.615 | 554800.0 |
| 2002-02-06 13:00:00 | CL | Stock | 27.615 | 27.775 | 27.575 | 27.685 | 512800.0 |
| 2002-02-06 14:00:00 | CL | Stock | 27.68 | 27.76 | 27.55 | 27.635 | 666800.0 |
> showing 50 of 18,560 rows — these rows as CSV