PREVIEW / stock_1hour / 2002-07-05
file: by_date/stock_1hour/2002/2002-07-05.parquet size: 261 KB rows: 11,236 symbols: 1,396
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-07-05 08:00:00 | AAPL | Stock | 0.32 | 0.3213 | 0.3179 | 0.3179 | 61600.0 |
| 2002-07-05 09:00:00 | AAPL | Stock | 0.3213 | 0.3232 | 0.3159 | 0.3229 | 22932000.0 |
| 2002-07-05 10:00:00 | AAPL | Stock | 0.323 | 0.3286 | 0.322 | 0.3284 | 34120800.0 |
| 2002-07-05 11:00:00 | AAPL | Stock | 0.3282 | 0.3348 | 0.3282 | 0.333 | 44889600.0 |
| 2002-07-05 12:00:00 | AAPL | Stock | 0.333 | 0.3348 | 0.3302 | 0.3346 | 49492800.0 |
| 2002-07-05 13:00:00 | AAPL | Stock | 0.3346 | 0.3346 | 0.3345 | 0.3346 | 44800.0 |
| 2002-07-05 08:00:00 | MSFT | Stock | 26.55 | 26.675 | 26.3 | 26.675 | 108000.0 |
| 2002-07-05 09:00:00 | MSFT | Stock | 26.62 | 26.825 | 26.45 | 26.75 | 8754000.0 |
| 2002-07-05 10:00:00 | MSFT | Stock | 26.75 | 26.985 | 26.695 | 26.745 | 9642600.0 |
| 2002-07-05 11:00:00 | MSFT | Stock | 26.749 | 27.045 | 26.74 | 26.97 | 6132600.0 |
| 2002-07-05 12:00:00 | MSFT | Stock | 26.98 | 27.45 | 26.93 | 27.405 | 9281200.0 |
| 2002-07-05 13:00:00 | MSFT | Stock | 27.4 | 27.445 | 27.4 | 27.445 | 61800.0 |
| 2002-07-05 08:00:00 | NVDA | Stock | 0.149 | 0.1528 | 0.1447 | 0.1521 | 3924000.0 |
| 2002-07-05 09:00:00 | NVDA | Stock | 0.1522 | 0.1572 | 0.1517 | 0.1544 | 226368000.0 |
| 2002-07-05 10:00:00 | NVDA | Stock | 0.1544 | 0.1562 | 0.1514 | 0.153 | 177516000.0 |
| 2002-07-05 11:00:00 | NVDA | Stock | 0.153 | 0.1561 | 0.1529 | 0.1554 | 82200000.0 |
| 2002-07-05 12:00:00 | NVDA | Stock | 0.1552 | 0.1583 | 0.1545 | 0.1583 | 189804000.0 |
| 2002-07-05 13:00:00 | NVDA | Stock | 0.1583 | 0.1583 | 0.1575 | 0.1582 | 1668000.0 |
| 2002-07-05 08:00:00 | AMZN | Stock | 0.7325 | 0.75 | 0.708 | 0.7275 | 396000.0 |
| 2002-07-05 09:00:00 | AMZN | Stock | 0.7275 | 0.7375 | 0.7 | 0.735 | 10942000.0 |
| 2002-07-05 10:00:00 | AMZN | Stock | 0.735 | 0.7555 | 0.73 | 0.748 | 25150000.0 |
| 2002-07-05 11:00:00 | AMZN | Stock | 0.746 | 0.752 | 0.7445 | 0.7485 | 10206000.0 |
| 2002-07-05 12:00:00 | AMZN | Stock | 0.748 | 0.761 | 0.7475 | 0.761 | 17804000.0 |
| 2002-07-05 13:00:00 | AMZN | Stock | 0.7615 | 0.7615 | 0.7566 | 0.7605 | 84000.0 |
| 2002-07-05 09:00:00 | CL | Stock | 25.45 | 25.47 | 25.2 | 25.295 | 527200.0 |
| 2002-07-05 10:00:00 | CL | Stock | 25.275 | 25.575 | 25.255 | 25.505 | 1148800.0 |
| 2002-07-05 11:00:00 | CL | Stock | 25.505 | 25.745 | 25.505 | 25.665 | 419400.0 |
| 2002-07-05 12:00:00 | CL | Stock | 25.65 | 25.86 | 25.625 | 25.825 | 494600.0 |
| 2002-07-05 13:00:00 | CL | Stock | 25.83 | 25.87 | 25.83 | 25.87 | 56200.0 |
| 2002-07-05 17:00:00 | CL | Stock | 25.45 | 25.47 | 25.21 | 25.25 | 347000.0 |
> showing 30 of 11,236 rows — these rows as CSV