PREVIEW / stock_1hour / 2001-04-30
file: by_date/stock_1hour/2001/2001-04-30.parquet size: 359 KB rows: 16,903 symbols: 1,291
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-04-30 08:00:00 | AAPL | Stock | 0.4723 | 0.4732 | 0.4695 | 0.4732 | 156800.0 |
| 2001-04-30 09:00:00 | AAPL | Stock | 0.475 | 0.4771 | 0.4643 | 0.4718 | 56632800.0 |
| 2001-04-30 10:00:00 | AAPL | Stock | 0.4721 | 0.4843 | 0.4705 | 0.4768 | 123720800.0 |
| 2001-04-30 11:00:00 | AAPL | Stock | 0.4771 | 0.4777 | 0.4714 | 0.4725 | 34972000.0 |
| 2001-04-30 12:00:00 | AAPL | Stock | 0.4725 | 0.4766 | 0.4721 | 0.4738 | 20916000.0 |
| 2001-04-30 13:00:00 | AAPL | Stock | 0.4738 | 0.4739 | 0.4554 | 0.4561 | 64450400.0 |
| 2001-04-30 14:00:00 | AAPL | Stock | 0.4559 | 0.4595 | 0.4446 | 0.4446 | 82605600.0 |
| 2001-04-30 15:00:00 | AAPL | Stock | 0.4446 | 0.4589 | 0.4441 | 0.4552 | 60071200.0 |
| 2001-04-30 16:00:00 | AAPL | Stock | 0.4559 | 0.4618 | 0.4464 | 0.4554 | 11648000.0 |
| 2001-04-30 17:00:00 | AAPL | Stock | 0.4552 | 0.4564 | 0.4552 | 0.4564 | 61600.0 |
| 2001-04-30 18:00:00 | AAPL | Stock | 0.4616 | 0.4616 | 0.4568 | 0.4568 | 84000.0 |
| 2001-04-30 08:00:00 | MSFT | Stock | 33.75 | 34.3 | 33.56 | 34.225 | 309000.0 |
| 2001-04-30 09:00:00 | MSFT | Stock | 34.225 | 34.44 | 34.15 | 34.22 | 13066200.0 |
| 2001-04-30 10:00:00 | MSFT | Stock | 34.22 | 34.45 | 34.0 | 34.285 | 11421600.0 |
| 2001-04-30 11:00:00 | MSFT | Stock | 34.285 | 34.4 | 34.2 | 34.33 | 6065000.0 |
| 2001-04-30 12:00:00 | MSFT | Stock | 34.325 | 34.49 | 34.295 | 34.445 | 5398400.0 |
| 2001-04-30 13:00:00 | MSFT | Stock | 34.445 | 34.53 | 34.275 | 34.31 | 7050200.0 |
| 2001-04-30 14:00:00 | MSFT | Stock | 34.31 | 34.4 | 34.11 | 34.14 | 9175800.0 |
| 2001-04-30 15:00:00 | MSFT | Stock | 34.15 | 34.235 | 33.85 | 33.875 | 10907000.0 |
| 2001-04-30 16:00:00 | MSFT | Stock | 33.875 | 34.31 | 33.7 | 33.9 | 4386400.0 |
| 2001-04-30 17:00:00 | MSFT | Stock | 33.9 | 33.925 | 33.78 | 33.865 | 19800.0 |
| 2001-04-30 18:00:00 | MSFT | Stock | 33.85 | 33.925 | 33.825 | 33.925 | 1428800.0 |
| 2001-04-30 08:00:00 | NVDA | Stock | 0.3354 | 0.3415 | 0.3354 | 0.3375 | 1440000.0 |
| 2001-04-30 09:00:00 | NVDA | Stock | 0.3375 | 0.3454 | 0.331 | 0.3432 | 116472000.0 |
| 2001-04-30 10:00:00 | NVDA | Stock | 0.3435 | 0.3602 | 0.3423 | 0.3554 | 331536000.0 |
| 2001-04-30 11:00:00 | NVDA | Stock | 0.3557 | 0.3604 | 0.3535 | 0.3594 | 155904000.0 |
| 2001-04-30 12:00:00 | NVDA | Stock | 0.3594 | 0.3601 | 0.3551 | 0.359 | 135768000.0 |
| 2001-04-30 13:00:00 | NVDA | Stock | 0.359 | 0.3665 | 0.3584 | 0.3591 | 166080000.0 |
| 2001-04-30 14:00:00 | NVDA | Stock | 0.3591 | 0.3603 | 0.3469 | 0.3472 | 245112000.0 |
| 2001-04-30 15:00:00 | NVDA | Stock | 0.3471 | 0.3563 | 0.3421 | 0.3482 | 311616000.0 |
| 2001-04-30 16:00:00 | NVDA | Stock | 0.3482 | 0.3562 | 0.3471 | 0.3473 | 23328000.0 |
| 2001-04-30 17:00:00 | NVDA | Stock | 0.349 | 0.349 | 0.3479 | 0.3479 | 312000.0 |
| 2001-04-30 18:00:00 | NVDA | Stock | 0.3479 | 0.3479 | 0.3477 | 0.3477 | 144000.0 |
| 2001-04-30 08:00:00 | AMZN | Stock | 0.7625 | 0.8 | 0.7625 | 0.78 | 194000.0 |
| 2001-04-30 09:00:00 | AMZN | Stock | 0.78 | 0.7995 | 0.778 | 0.797 | 8754000.0 |
| 2001-04-30 10:00:00 | AMZN | Stock | 0.7985 | 0.8295 | 0.7965 | 0.806 | 20564000.0 |
| 2001-04-30 11:00:00 | AMZN | Stock | 0.806 | 0.8235 | 0.806 | 0.8205 | 9706000.0 |
| 2001-04-30 12:00:00 | AMZN | Stock | 0.8205 | 0.83 | 0.816 | 0.83 | 10270000.0 |
| 2001-04-30 13:00:00 | AMZN | Stock | 0.83 | 0.8415 | 0.82 | 0.82 | 16388000.0 |
| 2001-04-30 14:00:00 | AMZN | Stock | 0.82 | 0.825 | 0.8095 | 0.81 | 15970000.0 |
| 2001-04-30 15:00:00 | AMZN | Stock | 0.809 | 0.816 | 0.7885 | 0.789 | 17552000.0 |
| 2001-04-30 16:00:00 | AMZN | Stock | 0.789 | 0.795 | 0.785 | 0.789 | 6376000.0 |
| 2001-04-30 17:00:00 | AMZN | Stock | 0.7935 | 0.7935 | 0.7935 | 0.7935 | 10000.0 |
| 2001-04-30 18:00:00 | AMZN | Stock | 0.81 | 0.81 | 0.81 | 0.81 | 2000.0 |
| 2001-04-30 09:00:00 | CL | Stock | 28.15 | 28.375 | 28.105 | 28.375 | 413000.0 |
| 2001-04-30 10:00:00 | CL | Stock | 28.375 | 28.45 | 28.35 | 28.355 | 403400.0 |
| 2001-04-30 11:00:00 | CL | Stock | 28.355 | 28.4 | 28.23 | 28.255 | 331800.0 |
| 2001-04-30 12:00:00 | CL | Stock | 28.275 | 28.36 | 28.24 | 28.265 | 263200.0 |
| 2001-04-30 13:00:00 | CL | Stock | 28.23 | 28.265 | 28.0 | 28.0 | 358600.0 |
| 2001-04-30 14:00:00 | CL | Stock | 28.005 | 28.045 | 27.75 | 27.77 | 537000.0 |
> showing 50 of 16,903 rows — these rows as CSV