PREVIEW / stock_1hour / 2003-02-07
file: by_date/stock_1hour/2003/2003-02-07.parquet size: 403 KB rows: 19,677 symbols: 1,537
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 |
|---|---|---|---|---|---|---|---|
| 2003-02-07 08:00:00 | AAPL | Stock | 0.2578 | 0.2578 | 0.2578 | 0.2578 | 168000.0 |
| 2003-02-07 09:00:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2575 | 0.2579 | 37748200.0 |
| 2003-02-07 10:00:00 | AAPL | Stock | 0.2579 | 0.2582 | 0.2536 | 0.2555 | 46692352.0 |
| 2003-02-07 11:00:00 | AAPL | Stock | 0.2555 | 0.2563 | 0.2543 | 0.255 | 17585848.0 |
| 2003-02-07 12:00:00 | AAPL | Stock | 0.255 | 0.255 | 0.2523 | 0.2527 | 34318200.0 |
| 2003-02-07 13:00:00 | AAPL | Stock | 0.2527 | 0.2538 | 0.2525 | 0.2532 | 24378312.0 |
| 2003-02-07 14:00:00 | AAPL | Stock | 0.2532 | 0.2532 | 0.2518 | 0.252 | 23015328.0 |
| 2003-02-07 15:00:00 | AAPL | Stock | 0.2521 | 0.2538 | 0.2513 | 0.2527 | 47170592.0 |
| 2003-02-07 16:00:00 | AAPL | Stock | 0.2527 | 0.257 | 0.2516 | 0.2527 | 9936864.0 |
| 2003-02-07 17:00:00 | AAPL | Stock | 0.2527 | 0.2527 | 0.2527 | 0.2527 | 2592800.0 |
| 2003-02-07 08:00:00 | MSFT | Stock | 23.72 | 24.05 | 23.335 | 23.925 | 927710.0 |
| 2003-02-07 09:00:00 | MSFT | Stock | 23.925 | 23.975 | 23.6505 | 23.685 | 11860324.0 |
| 2003-02-07 10:00:00 | MSFT | Stock | 23.685 | 23.745 | 23.32 | 23.505 | 17177334.0 |
| 2003-02-07 11:00:00 | MSFT | Stock | 23.505 | 23.57 | 23.39 | 23.535 | 6929272.0 |
| 2003-02-07 12:00:00 | MSFT | Stock | 23.5255 | 23.54 | 23.375 | 23.42 | 5568614.0 |
| 2003-02-07 13:00:00 | MSFT | Stock | 23.42 | 23.425 | 23.305 | 23.365 | 4850112.0 |
| 2003-02-07 14:00:00 | MSFT | Stock | 23.37 | 23.42 | 23.25 | 23.265 | 9139556.0 |
| 2003-02-07 15:00:00 | MSFT | Stock | 23.255 | 23.415 | 23.205 | 23.29 | 11916830.0 |
| 2003-02-07 16:00:00 | MSFT | Stock | 23.28 | 23.325 | 23.255 | 23.2855 | 771978.0 |
| 2003-02-07 17:00:00 | MSFT | Stock | 23.295 | 23.33 | 23.29 | 23.29 | 366402.0 |
| 2003-02-07 18:00:00 | MSFT | Stock | 23.28 | 23.295 | 23.28 | 23.2855 | 14838.0 |
| 2003-02-07 08:00:00 | NVDA | Stock | 0.0853 | 0.0879 | 0.0853 | 0.0867 | 4195200.0 |
| 2003-02-07 09:00:00 | NVDA | Stock | 0.0867 | 0.0872 | 0.0843 | 0.0843 | 154815120.0 |
| 2003-02-07 10:00:00 | NVDA | Stock | 0.0843 | 0.0852 | 0.0823 | 0.0839 | 231779160.0 |
| 2003-02-07 11:00:00 | NVDA | Stock | 0.0838 | 0.0844 | 0.0834 | 0.0838 | 78487560.0 |
| 2003-02-07 12:00:00 | NVDA | Stock | 0.0837 | 0.0839 | 0.0826 | 0.0827 | 68832600.0 |
| 2003-02-07 13:00:00 | NVDA | Stock | 0.0827 | 0.083 | 0.0824 | 0.0829 | 84603960.0 |
| 2003-02-07 14:00:00 | NVDA | Stock | 0.0828 | 0.0829 | 0.0814 | 0.0816 | 75952920.0 |
| 2003-02-07 15:00:00 | NVDA | Stock | 0.0816 | 0.0822 | 0.0812 | 0.0815 | 155829960.0 |
| 2003-02-07 16:00:00 | NVDA | Stock | 0.0813 | 0.0816 | 0.0808 | 0.0815 | 6028320.0 |
| 2003-02-07 17:00:00 | NVDA | Stock | 0.0816 | 0.0816 | 0.0812 | 0.0812 | 3057600.0 |
| 2003-02-07 18:00:00 | NVDA | Stock | 0.0812 | 0.0812 | 0.0812 | 0.0812 | 285600.0 |
| 2003-02-07 08:00:00 | AMZN | Stock | 1.1045 | 1.114 | 1.1 | 1.111 | 135000.0 |
| 2003-02-07 09:00:00 | AMZN | Stock | 1.1125 | 1.114 | 1.06 | 1.0675 | 40971780.0 |
| 2003-02-07 10:00:00 | AMZN | Stock | 1.0675 | 1.0825 | 1.065 | 1.075 | 28284300.0 |
| 2003-02-07 11:00:00 | AMZN | Stock | 1.0749 | 1.081 | 1.0685 | 1.0725 | 12118420.0 |
| 2003-02-07 12:00:00 | AMZN | Stock | 1.0725 | 1.078 | 1.07 | 1.07 | 9361900.0 |
| 2003-02-07 13:00:00 | AMZN | Stock | 1.07 | 1.072 | 1.0674 | 1.069 | 6556940.0 |
| 2003-02-07 14:00:00 | AMZN | Stock | 1.069 | 1.069 | 1.0645 | 1.065 | 7877720.0 |
| 2003-02-07 15:00:00 | AMZN | Stock | 1.0645 | 1.08 | 1.0625 | 1.0745 | 20430060.0 |
| 2003-02-07 16:00:00 | AMZN | Stock | 1.074 | 1.0745 | 1.065 | 1.071 | 1040380.0 |
| 2003-02-07 17:00:00 | AMZN | Stock | 1.072 | 1.072 | 1.072 | 1.072 | 506000.0 |
| 2003-02-07 18:00:00 | AMZN | Stock | 1.072 | 1.072 | 1.07 | 1.07 | 32000.0 |
| 2003-02-07 09:00:00 | CL | Stock | 25.8 | 25.9 | 25.75 | 25.855 | 353600.0 |
| 2003-02-07 10:00:00 | CL | Stock | 25.86 | 25.88 | 25.675 | 25.695 | 785200.0 |
| 2003-02-07 11:00:00 | CL | Stock | 25.675 | 25.775 | 25.63 | 25.745 | 529400.0 |
| 2003-02-07 12:00:00 | CL | Stock | 25.745 | 25.75 | 25.585 | 25.655 | 173000.0 |
| 2003-02-07 13:00:00 | CL | Stock | 25.665 | 25.705 | 25.575 | 25.6 | 168800.0 |
| 2003-02-07 14:00:00 | CL | Stock | 25.575 | 25.645 | 25.545 | 25.585 | 207000.0 |
| 2003-02-07 15:00:00 | CL | Stock | 25.585 | 25.705 | 25.565 | 25.605 | 396800.0 |
> showing 50 of 19,677 rows — these rows as CSV