PREVIEW / stock_1hour / 2003-01-30
file: by_date/stock_1hour/2003/2003-01-30.parquet size: 424 KB rows: 20,418 symbols: 1,535
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-01-30 08:00:00 | AAPL | Stock | 0.2664 | 0.2664 | 0.2664 | 0.2664 | 16800.0 |
| 2003-01-30 09:00:00 | AAPL | Stock | 0.2663 | 0.2723 | 0.2634 | 0.2641 | 37289224.0 |
| 2003-01-30 10:00:00 | AAPL | Stock | 0.2639 | 0.2671 | 0.2625 | 0.2625 | 76498856.0 |
| 2003-01-30 11:00:00 | AAPL | Stock | 0.2629 | 0.2629 | 0.2577 | 0.2582 | 49830704.0 |
| 2003-01-30 12:00:00 | AAPL | Stock | 0.2582 | 0.2593 | 0.257 | 0.2588 | 40696712.0 |
| 2003-01-30 13:00:00 | AAPL | Stock | 0.2587 | 0.2593 | 0.258 | 0.2588 | 46427080.0 |
| 2003-01-30 14:00:00 | AAPL | Stock | 0.2588 | 0.2598 | 0.2566 | 0.2575 | 30659328.0 |
| 2003-01-30 15:00:00 | AAPL | Stock | 0.2575 | 0.2586 | 0.2552 | 0.2566 | 53307408.0 |
| 2003-01-30 16:00:00 | AAPL | Stock | 0.2554 | 0.2563 | 0.2554 | 0.2557 | 5045600.0 |
| 2003-01-30 17:00:00 | AAPL | Stock | 0.2557 | 0.2557 | 0.2557 | 0.2557 | 576800.0 |
| 2003-01-30 18:00:00 | AAPL | Stock | 0.2557 | 0.2557 | 0.2557 | 0.2557 | 308000.0 |
| 2003-01-30 08:00:00 | MSFT | Stock | 24.99 | 25.115 | 24.9435 | 25.08 | 515452.0 |
| 2003-01-30 09:00:00 | MSFT | Stock | 25.08 | 25.12 | 24.605 | 24.87 | 13460202.0 |
| 2003-01-30 10:00:00 | MSFT | Stock | 24.865 | 25.085 | 24.725 | 24.845 | 16636620.0 |
| 2003-01-30 11:00:00 | MSFT | Stock | 24.845 | 24.915 | 24.53 | 24.5545 | 8978508.0 |
| 2003-01-30 12:00:00 | MSFT | Stock | 24.55 | 24.7 | 24.495 | 24.66 | 7814994.0 |
| 2003-01-30 13:00:00 | MSFT | Stock | 24.659 | 24.735 | 24.55 | 24.68 | 5432242.0 |
| 2003-01-30 14:00:00 | MSFT | Stock | 24.685 | 24.755 | 24.545 | 24.57 | 8104184.0 |
| 2003-01-30 15:00:00 | MSFT | Stock | 24.57 | 24.585 | 24.095 | 24.115 | 17047984.0 |
| 2003-01-30 16:00:00 | MSFT | Stock | 24.115 | 24.895 | 23.975 | 24.015 | 2568330.0 |
| 2003-01-30 17:00:00 | MSFT | Stock | 24.0125 | 24.12 | 23.955 | 23.97 | 186932.0 |
| 2003-01-30 18:00:00 | MSFT | Stock | 24.12 | 24.12 | 23.96 | 23.99 | 190084.0 |
| 2003-01-30 08:00:00 | NVDA | Stock | 0.0883 | 0.0892 | 0.088 | 0.0892 | 1411200.0 |
| 2003-01-30 09:00:00 | NVDA | Stock | 0.0893 | 0.0907 | 0.0882 | 0.0893 | 109590360.0 |
| 2003-01-30 10:00:00 | NVDA | Stock | 0.0893 | 0.0904 | 0.0889 | 0.0893 | 145348800.0 |
| 2003-01-30 11:00:00 | NVDA | Stock | 0.0893 | 0.0896 | 0.0858 | 0.0869 | 96966000.0 |
| 2003-01-30 12:00:00 | NVDA | Stock | 0.0869 | 0.088 | 0.0862 | 0.0878 | 66047280.0 |
| 2003-01-30 13:00:00 | NVDA | Stock | 0.0878 | 0.0878 | 0.0861 | 0.0863 | 45774720.0 |
| 2003-01-30 14:00:00 | NVDA | Stock | 0.0863 | 0.0865 | 0.085 | 0.085 | 83442480.0 |
| 2003-01-30 15:00:00 | NVDA | Stock | 0.0851 | 0.0852 | 0.0837 | 0.0847 | 140041920.0 |
| 2003-01-30 16:00:00 | NVDA | Stock | 0.0847 | 0.0849 | 0.0842 | 0.0842 | 9155880.0 |
| 2003-01-30 17:00:00 | NVDA | Stock | 0.0844 | 0.0847 | 0.0837 | 0.0847 | 1092000.0 |
| 2003-01-30 18:00:00 | NVDA | Stock | 0.0842 | 0.0842 | 0.0842 | 0.0842 | 636000.0 |
| 2003-01-30 08:00:00 | AMZN | Stock | 1.104 | 1.1125 | 1.104 | 1.1125 | 59100.0 |
| 2003-01-30 09:00:00 | AMZN | Stock | 1.1075 | 1.115 | 1.102 | 1.105 | 16042440.0 |
| 2003-01-30 10:00:00 | AMZN | Stock | 1.105 | 1.1145 | 1.1025 | 1.1135 | 17070100.0 |
| 2003-01-30 11:00:00 | AMZN | Stock | 1.114 | 1.12 | 1.1115 | 1.1135 | 16572460.0 |
| 2003-01-30 12:00:00 | AMZN | Stock | 1.1135 | 1.1135 | 1.106 | 1.1105 | 13129080.0 |
| 2003-01-30 13:00:00 | AMZN | Stock | 1.111 | 1.113 | 1.104 | 1.1055 | 8077920.0 |
| 2003-01-30 14:00:00 | AMZN | Stock | 1.1055 | 1.108 | 1.099 | 1.1 | 13467660.0 |
| 2003-01-30 15:00:00 | AMZN | Stock | 1.1 | 1.102 | 1.089 | 1.0895 | 22078500.0 |
| 2003-01-30 16:00:00 | AMZN | Stock | 1.0885 | 1.0925 | 1.088 | 1.091 | 1222580.0 |
| 2003-01-30 17:00:00 | AMZN | Stock | 1.0905 | 1.091 | 1.0885 | 1.0885 | 307000.0 |
| 2003-01-30 18:00:00 | AMZN | Stock | 1.09 | 1.091 | 1.0885 | 1.091 | 216000.0 |
| 2003-01-30 09:00:00 | CL | Stock | 25.415 | 25.415 | 24.795 | 24.85 | 548600.0 |
| 2003-01-30 10:00:00 | CL | Stock | 24.85 | 25.025 | 24.75 | 24.955 | 798400.0 |
| 2003-01-30 11:00:00 | CL | Stock | 24.95 | 25.02 | 24.89 | 24.99 | 756400.0 |
| 2003-01-30 12:00:00 | CL | Stock | 24.975 | 25.0 | 24.865 | 24.97 | 969000.0 |
| 2003-01-30 13:00:00 | CL | Stock | 24.98 | 25.015 | 24.955 | 24.995 | 490800.0 |
| 2003-01-30 14:00:00 | CL | Stock | 24.99 | 24.99 | 24.885 | 24.905 | 1007600.0 |
> showing 50 of 20,418 rows — these rows as CSV