PREVIEW / stock_1hour / 2002-05-03
file: by_date/stock_1hour/2002/2002-05-03.parquet size: 410 KB rows: 19,117 symbols: 1,398
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-05-03 08:00:00 | AAPL | Stock | 0.4232 | 0.4232 | 0.4223 | 0.4228 | 72800.0 |
| 2002-05-03 09:00:00 | AAPL | Stock | 0.4214 | 0.4261 | 0.4202 | 0.423 | 21509600.0 |
| 2002-05-03 10:00:00 | AAPL | Stock | 0.4227 | 0.4289 | 0.4211 | 0.4223 | 29864800.0 |
| 2002-05-03 11:00:00 | AAPL | Stock | 0.4223 | 0.4231 | 0.4209 | 0.4213 | 25228000.0 |
| 2002-05-03 12:00:00 | AAPL | Stock | 0.4213 | 0.4225 | 0.4186 | 0.4205 | 26174400.0 |
| 2002-05-03 13:00:00 | AAPL | Stock | 0.4204 | 0.4229 | 0.4198 | 0.4204 | 15517600.0 |
| 2002-05-03 14:00:00 | AAPL | Stock | 0.4207 | 0.4229 | 0.4184 | 0.4205 | 54146400.0 |
| 2002-05-03 15:00:00 | AAPL | Stock | 0.4205 | 0.4223 | 0.4186 | 0.4198 | 40784800.0 |
| 2002-05-03 16:00:00 | AAPL | Stock | 0.4209 | 0.4214 | 0.4198 | 0.4198 | 16660000.0 |
| 2002-05-03 17:00:00 | AAPL | Stock | 0.4286 | 0.4286 | 0.4179 | 0.4179 | 140000.0 |
| 2002-05-03 18:00:00 | AAPL | Stock | 0.4198 | 0.4198 | 0.4198 | 0.4198 | 28000.0 |
| 2002-05-03 08:00:00 | MSFT | Stock | 25.625 | 26.125 | 25.55 | 25.745 | 143800.0 |
| 2002-05-03 09:00:00 | MSFT | Stock | 25.75 | 25.84 | 25.415 | 25.45 | 9109400.0 |
| 2002-05-03 10:00:00 | MSFT | Stock | 25.45 | 25.725 | 25.255 | 25.565 | 11902400.0 |
| 2002-05-03 11:00:00 | MSFT | Stock | 25.554 | 25.575 | 25.215 | 25.285 | 7954200.0 |
| 2002-05-03 12:00:00 | MSFT | Stock | 25.285 | 25.3 | 25.015 | 25.0525 | 6939800.0 |
| 2002-05-03 13:00:00 | MSFT | Stock | 25.05 | 25.205 | 24.89 | 25.04 | 8138600.0 |
| 2002-05-03 14:00:00 | MSFT | Stock | 25.04 | 25.465 | 24.975 | 25.31 | 10259400.0 |
| 2002-05-03 15:00:00 | MSFT | Stock | 25.31 | 25.32 | 24.765 | 24.77 | 12263600.0 |
| 2002-05-03 16:00:00 | MSFT | Stock | 24.79 | 25.435 | 24.725 | 24.785 | 3944000.0 |
| 2002-05-03 17:00:00 | MSFT | Stock | 24.79 | 25.61 | 24.78 | 24.795 | 51000.0 |
| 2002-05-03 18:00:00 | MSFT | Stock | 24.795 | 25.62 | 24.78 | 24.815 | 21000.0 |
| 2002-05-03 08:00:00 | NVDA | Stock | 0.2829 | 0.2854 | 0.2824 | 0.2851 | 1392000.0 |
| 2002-05-03 09:00:00 | NVDA | Stock | 0.2852 | 0.2859 | 0.2775 | 0.2779 | 122868000.0 |
| 2002-05-03 10:00:00 | NVDA | Stock | 0.2777 | 0.2802 | 0.2739 | 0.2762 | 169908000.0 |
| 2002-05-03 11:00:00 | NVDA | Stock | 0.2762 | 0.2779 | 0.2737 | 0.274 | 76308000.0 |
| 2002-05-03 12:00:00 | NVDA | Stock | 0.2739 | 0.2763 | 0.2715 | 0.2744 | 112332000.0 |
| 2002-05-03 13:00:00 | NVDA | Stock | 0.2748 | 0.2767 | 0.2717 | 0.2733 | 109332000.0 |
| 2002-05-03 14:00:00 | NVDA | Stock | 0.2733 | 0.2804 | 0.2724 | 0.2767 | 118836000.0 |
| 2002-05-03 15:00:00 | NVDA | Stock | 0.2764 | 0.2771 | 0.2717 | 0.2729 | 99864000.0 |
| 2002-05-03 16:00:00 | NVDA | Stock | 0.2729 | 0.2785 | 0.2717 | 0.2725 | 31992000.0 |
| 2002-05-03 17:00:00 | NVDA | Stock | 0.2725 | 0.2797 | 0.2725 | 0.2726 | 1788000.0 |
| 2002-05-03 18:00:00 | NVDA | Stock | 0.2725 | 0.2791 | 0.2725 | 0.2767 | 1008000.0 |
| 2002-05-03 08:00:00 | AMZN | Stock | 0.8155 | 0.8155 | 0.815 | 0.815 | 32000.0 |
| 2002-05-03 09:00:00 | AMZN | Stock | 0.813 | 0.82 | 0.8085 | 0.813 | 16226000.0 |
| 2002-05-03 10:00:00 | AMZN | Stock | 0.813 | 0.817 | 0.7875 | 0.803 | 29026000.0 |
| 2002-05-03 11:00:00 | AMZN | Stock | 0.8035 | 0.8035 | 0.792 | 0.7925 | 9698000.0 |
| 2002-05-03 12:00:00 | AMZN | Stock | 0.7925 | 0.8025 | 0.79 | 0.8 | 11932000.0 |
| 2002-05-03 13:00:00 | AMZN | Stock | 0.7995 | 0.8025 | 0.7935 | 0.7945 | 3124000.0 |
| 2002-05-03 14:00:00 | AMZN | Stock | 0.794 | 0.806 | 0.7935 | 0.803 | 12200000.0 |
| 2002-05-03 15:00:00 | AMZN | Stock | 0.803 | 0.8033 | 0.794 | 0.8025 | 13268000.0 |
| 2002-05-03 16:00:00 | AMZN | Stock | 0.8025 | 0.8115 | 0.7985 | 0.8025 | 3604000.0 |
| 2002-05-03 17:00:00 | AMZN | Stock | 0.8015 | 0.8025 | 0.8 | 0.8015 | 940000.0 |
| 2002-05-03 18:00:00 | AMZN | Stock | 0.8025 | 0.8025 | 0.8025 | 0.8025 | 12000.0 |
| 2002-05-03 09:00:00 | CL | Stock | 27.395 | 27.575 | 27.38 | 27.575 | 426600.0 |
| 2002-05-03 10:00:00 | CL | Stock | 27.565 | 27.58 | 27.315 | 27.315 | 682600.0 |
| 2002-05-03 11:00:00 | CL | Stock | 27.315 | 27.45 | 27.3 | 27.36 | 748600.0 |
| 2002-05-03 12:00:00 | CL | Stock | 27.38 | 27.475 | 27.3 | 27.31 | 384800.0 |
| 2002-05-03 13:00:00 | CL | Stock | 27.305 | 27.375 | 27.25 | 27.26 | 513000.0 |
| 2002-05-03 14:00:00 | CL | Stock | 27.255 | 27.35 | 27.24 | 27.315 | 424600.0 |
> showing 50 of 19,117 rows — these rows as CSV