PREVIEW / stock_1hour / 2002-06-10
file: by_date/stock_1hour/2002/2002-06-10.parquet size: 404 KB rows: 19,220 symbols: 1,442
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-06-10 08:00:00 | AAPL | Stock | 0.382 | 0.3825 | 0.382 | 0.3825 | 22400.0 |
| 2002-06-10 09:00:00 | AAPL | Stock | 0.3828 | 0.3854 | 0.3813 | 0.3838 | 48451200.0 |
| 2002-06-10 10:00:00 | AAPL | Stock | 0.3836 | 0.3845 | 0.3811 | 0.3844 | 33672800.0 |
| 2002-06-10 11:00:00 | AAPL | Stock | 0.3845 | 0.3871 | 0.3838 | 0.3859 | 55020000.0 |
| 2002-06-10 12:00:00 | AAPL | Stock | 0.3857 | 0.3875 | 0.3846 | 0.387 | 20204800.0 |
| 2002-06-10 13:00:00 | AAPL | Stock | 0.387 | 0.3879 | 0.3861 | 0.3871 | 16693600.0 |
| 2002-06-10 14:00:00 | AAPL | Stock | 0.3868 | 0.3891 | 0.3868 | 0.3891 | 25692800.0 |
| 2002-06-10 15:00:00 | AAPL | Stock | 0.3891 | 0.39 | 0.3821 | 0.3839 | 42240800.0 |
| 2002-06-10 16:00:00 | AAPL | Stock | 0.3834 | 0.3866 | 0.3786 | 0.3786 | 17729600.0 |
| 2002-06-10 17:00:00 | AAPL | Stock | 0.3818 | 0.3836 | 0.3786 | 0.3836 | 4485600.0 |
| 2002-06-10 08:00:00 | MSFT | Stock | 26.005 | 26.125 | 25.95 | 26.015 | 16200.0 |
| 2002-06-10 09:00:00 | MSFT | Stock | 26.015 | 26.19 | 25.75 | 26.1225 | 10623000.0 |
| 2002-06-10 10:00:00 | MSFT | Stock | 26.1 | 26.47 | 26.055 | 26.45 | 15074600.0 |
| 2002-06-10 11:00:00 | MSFT | Stock | 26.439 | 26.46 | 26.275 | 26.415 | 7074800.0 |
| 2002-06-10 12:00:00 | MSFT | Stock | 26.4145 | 26.5505 | 26.335 | 26.505 | 8200200.0 |
| 2002-06-10 13:00:00 | MSFT | Stock | 26.5 | 26.525 | 26.33 | 26.385 | 6162600.0 |
| 2002-06-10 14:00:00 | MSFT | Stock | 26.38 | 26.6 | 26.25 | 26.6 | 7602600.0 |
| 2002-06-10 15:00:00 | MSFT | Stock | 26.595 | 26.65 | 26.22 | 26.41 | 12848800.0 |
| 2002-06-10 16:00:00 | MSFT | Stock | 26.41 | 26.4418 | 25.41 | 26.385 | 2671200.0 |
| 2002-06-10 17:00:00 | MSFT | Stock | 26.38 | 26.415 | 26.35 | 26.4 | 141800.0 |
| 2002-06-10 18:00:00 | MSFT | Stock | 26.375 | 26.44 | 26.375 | 26.44 | 4400.0 |
| 2002-06-10 08:00:00 | NVDA | Stock | 0.2708 | 0.275 | 0.2702 | 0.2733 | 756000.0 |
| 2002-06-10 09:00:00 | NVDA | Stock | 0.275 | 0.275 | 0.2673 | 0.2711 | 106116000.0 |
| 2002-06-10 10:00:00 | NVDA | Stock | 0.2709 | 0.2804 | 0.2702 | 0.2748 | 260100000.0 |
| 2002-06-10 11:00:00 | NVDA | Stock | 0.2748 | 0.276 | 0.2733 | 0.2743 | 66048000.0 |
| 2002-06-10 12:00:00 | NVDA | Stock | 0.2742 | 0.2751 | 0.2715 | 0.2746 | 69480000.0 |
| 2002-06-10 13:00:00 | NVDA | Stock | 0.2746 | 0.2748 | 0.2717 | 0.2718 | 54048000.0 |
| 2002-06-10 14:00:00 | NVDA | Stock | 0.2718 | 0.2737 | 0.2708 | 0.2732 | 56256000.0 |
| 2002-06-10 15:00:00 | NVDA | Stock | 0.2727 | 0.2732 | 0.2663 | 0.2668 | 106980000.0 |
| 2002-06-10 16:00:00 | NVDA | Stock | 0.2669 | 0.2703 | 0.2662 | 0.2669 | 15864000.0 |
| 2002-06-10 17:00:00 | NVDA | Stock | 0.2669 | 0.2675 | 0.2646 | 0.2669 | 768000.0 |
| 2002-06-10 18:00:00 | NVDA | Stock | 0.2657 | 0.2657 | 0.2657 | 0.2657 | 36000.0 |
| 2002-06-10 08:00:00 | AMZN | Stock | 0.888 | 0.929 | 0.881 | 0.897 | 1016000.0 |
| 2002-06-10 09:00:00 | AMZN | Stock | 0.897 | 0.906 | 0.89 | 0.8945 | 24918000.0 |
| 2002-06-10 10:00:00 | AMZN | Stock | 0.8945 | 0.897 | 0.852 | 0.8625 | 61046000.0 |
| 2002-06-10 11:00:00 | AMZN | Stock | 0.863 | 0.867 | 0.851 | 0.8525 | 22274000.0 |
| 2002-06-10 12:00:00 | AMZN | Stock | 0.8534 | 0.8665 | 0.8515 | 0.8645 | 18024000.0 |
| 2002-06-10 13:00:00 | AMZN | Stock | 0.8645 | 0.869 | 0.8565 | 0.8575 | 15014000.0 |
| 2002-06-10 14:00:00 | AMZN | Stock | 0.8575 | 0.8775 | 0.8575 | 0.861 | 21804000.0 |
| 2002-06-10 15:00:00 | AMZN | Stock | 0.8605 | 0.88 | 0.856 | 0.8625 | 50158000.0 |
| 2002-06-10 16:00:00 | AMZN | Stock | 0.865 | 0.8955 | 0.8545 | 0.8565 | 2558000.0 |
| 2002-06-10 17:00:00 | AMZN | Stock | 0.8545 | 0.865 | 0.8545 | 0.86 | 132000.0 |
| 2002-06-10 18:00:00 | AMZN | Stock | 0.86 | 0.861 | 0.8575 | 0.861 | 136000.0 |
| 2002-06-10 09:00:00 | CL | Stock | 27.2 | 27.325 | 27.1 | 27.215 | 560000.0 |
| 2002-06-10 10:00:00 | CL | Stock | 27.225 | 27.34 | 27.165 | 27.225 | 792600.0 |
| 2002-06-10 11:00:00 | CL | Stock | 27.24 | 27.24 | 27.05 | 27.055 | 466200.0 |
| 2002-06-10 12:00:00 | CL | Stock | 27.065 | 27.15 | 27.015 | 27.1 | 494000.0 |
| 2002-06-10 13:00:00 | CL | Stock | 27.115 | 27.12 | 26.775 | 26.84 | 1309600.0 |
| 2002-06-10 14:00:00 | CL | Stock | 26.835 | 27.005 | 26.775 | 26.9 | 1574400.0 |
| 2002-06-10 15:00:00 | CL | Stock | 26.9 | 27.07 | 26.8 | 26.96 | 2147400.0 |
> showing 50 of 19,220 rows — these rows as CSV