PREVIEW / stock_1hour / 2002-10-01
file: by_date/stock_1hour/2002/2002-10-01.parquet size: 435 KB rows: 20,265 symbols: 1,495
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-10-01 08:00:00 | AAPL | Stock | 0.2591 | 0.2591 | 0.2591 | 0.2591 | 84000.0 |
| 2002-10-01 09:00:00 | AAPL | Stock | 0.26 | 0.2607 | 0.2527 | 0.2529 | 35742560.0 |
| 2002-10-01 10:00:00 | AAPL | Stock | 0.2534 | 0.2557 | 0.25 | 0.2511 | 59328192.0 |
| 2002-10-01 11:00:00 | AAPL | Stock | 0.2509 | 0.253 | 0.2505 | 0.252 | 32950624.0 |
| 2002-10-01 12:00:00 | AAPL | Stock | 0.252 | 0.2538 | 0.2516 | 0.2536 | 19513984.0 |
| 2002-10-01 13:00:00 | AAPL | Stock | 0.2536 | 0.2554 | 0.253 | 0.2539 | 30971584.0 |
| 2002-10-01 14:00:00 | AAPL | Stock | 0.2538 | 0.2577 | 0.2529 | 0.2538 | 40631640.0 |
| 2002-10-01 15:00:00 | AAPL | Stock | 0.2538 | 0.2596 | 0.2538 | 0.2588 | 74720464.0 |
| 2002-10-01 16:00:00 | AAPL | Stock | 0.2589 | 0.2654 | 0.2545 | 0.2629 | 13930504.0 |
| 2002-10-01 17:00:00 | AAPL | Stock | 0.2591 | 0.2591 | 0.2591 | 0.2591 | 1668800.0 |
| 2002-10-01 18:00:00 | AAPL | Stock | 0.2591 | 0.2591 | 0.2591 | 0.2591 | 201600.0 |
| 2002-10-01 08:00:00 | MSFT | Stock | 22.1 | 23.0 | 21.75 | 22.1 | 122080.0 |
| 2002-10-01 09:00:00 | MSFT | Stock | 22.12 | 22.2005 | 21.83 | 21.93 | 13441248.0 |
| 2002-10-01 10:00:00 | MSFT | Stock | 21.93 | 22.0765 | 21.595 | 21.86 | 22092714.0 |
| 2002-10-01 11:00:00 | MSFT | Stock | 21.8605 | 22.03 | 21.69 | 21.88 | 11470738.0 |
| 2002-10-01 12:00:00 | MSFT | Stock | 21.8765 | 22.155 | 21.82 | 22.094 | 8719762.0 |
| 2002-10-01 13:00:00 | MSFT | Stock | 22.095 | 22.42 | 22.04 | 22.2645 | 11897544.0 |
| 2002-10-01 14:00:00 | MSFT | Stock | 22.26 | 22.6 | 22.155 | 22.485 | 13028310.0 |
| 2002-10-01 15:00:00 | MSFT | Stock | 22.485 | 23.115 | 22.439 | 23.1 | 21532308.0 |
| 2002-10-01 16:00:00 | MSFT | Stock | 23.11 | 23.625 | 23.015 | 23.45 | 3896208.0 |
| 2002-10-01 17:00:00 | MSFT | Stock | 23.45 | 23.495 | 21.83 | 23.455 | 475572.0 |
| 2002-10-01 18:00:00 | MSFT | Stock | 23.47 | 23.48 | 23.115 | 23.475 | 48376.0 |
| 2002-10-01 08:00:00 | NVDA | Stock | 0.0714 | 0.0733 | 0.0714 | 0.0726 | 646920.0 |
| 2002-10-01 09:00:00 | NVDA | Stock | 0.0713 | 0.0733 | 0.0701 | 0.0706 | 76484160.0 |
| 2002-10-01 10:00:00 | NVDA | Stock | 0.0705 | 0.0713 | 0.0693 | 0.071 | 144212880.0 |
| 2002-10-01 11:00:00 | NVDA | Stock | 0.071 | 0.0737 | 0.0706 | 0.0732 | 177965640.0 |
| 2002-10-01 12:00:00 | NVDA | Stock | 0.0731 | 0.0743 | 0.0727 | 0.0737 | 127212600.0 |
| 2002-10-01 13:00:00 | NVDA | Stock | 0.0737 | 0.0746 | 0.0733 | 0.0737 | 90857280.0 |
| 2002-10-01 14:00:00 | NVDA | Stock | 0.0737 | 0.0758 | 0.0736 | 0.0747 | 89497440.0 |
| 2002-10-01 15:00:00 | NVDA | Stock | 0.0747 | 0.0757 | 0.0742 | 0.0755 | 136425600.0 |
| 2002-10-01 16:00:00 | NVDA | Stock | 0.0753 | 0.0773 | 0.0749 | 0.0771 | 16596480.0 |
| 2002-10-01 17:00:00 | NVDA | Stock | 0.0773 | 0.0774 | 0.0752 | 0.0769 | 2952000.0 |
| 2002-10-01 18:00:00 | NVDA | Stock | 0.0769 | 0.0774 | 0.0752 | 0.0773 | 1248000.0 |
| 2002-10-01 08:00:00 | AMZN | Stock | 0.815 | 0.82 | 0.797 | 0.8131 | 244000.0 |
| 2002-10-01 09:00:00 | AMZN | Stock | 0.815 | 0.8195 | 0.8005 | 0.8065 | 25835620.0 |
| 2002-10-01 10:00:00 | AMZN | Stock | 0.807 | 0.832 | 0.8035 | 0.823 | 28969600.0 |
| 2002-10-01 11:00:00 | AMZN | Stock | 0.823 | 0.828 | 0.8145 | 0.8205 | 17134160.0 |
| 2002-10-01 12:00:00 | AMZN | Stock | 0.8205 | 0.8285 | 0.818 | 0.8241 | 17698520.0 |
| 2002-10-01 13:00:00 | AMZN | Stock | 0.8241 | 0.838 | 0.8215 | 0.835 | 27829300.0 |
| 2002-10-01 14:00:00 | AMZN | Stock | 0.834 | 0.8405 | 0.828 | 0.8375 | 17978300.0 |
| 2002-10-01 15:00:00 | AMZN | Stock | 0.8375 | 0.853 | 0.837 | 0.848 | 38889580.0 |
| 2002-10-01 16:00:00 | AMZN | Stock | 0.8475 | 0.8525 | 0.826 | 0.8525 | 4910000.0 |
| 2002-10-01 17:00:00 | AMZN | Stock | 0.8545 | 0.8565 | 0.8475 | 0.85 | 462000.0 |
| 2002-10-01 18:00:00 | AMZN | Stock | 0.85 | 0.85 | 0.8475 | 0.85 | 172000.0 |
| 2002-10-01 09:00:00 | CL | Stock | 27.0 | 27.175 | 27.0 | 27.175 | 306800.0 |
| 2002-10-01 10:00:00 | CL | Stock | 27.16 | 27.375 | 27.125 | 27.145 | 493400.0 |
| 2002-10-01 11:00:00 | CL | Stock | 27.13 | 27.205 | 27.05 | 27.06 | 368400.0 |
| 2002-10-01 12:00:00 | CL | Stock | 27.05 | 27.245 | 27.0 | 27.245 | 499400.0 |
| 2002-10-01 13:00:00 | CL | Stock | 27.25 | 27.455 | 27.135 | 27.29 | 513000.0 |
| 2002-10-01 14:00:00 | CL | Stock | 27.29 | 27.375 | 27.23 | 27.25 | 730200.0 |
> showing 50 of 20,265 rows — these rows as CSV