PREVIEW / stock_1hour / 2003-02-18
file: by_date/stock_1hour/2003/2003-02-18.parquet size: 417 KB rows: 20,434 symbols: 1,548
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-18 08:00:00 | AAPL | Stock | 0.2618 | 0.262 | 0.2618 | 0.262 | 39200.0 |
| 2003-02-18 09:00:00 | AAPL | Stock | 0.2636 | 0.2679 | 0.2627 | 0.2668 | 39662448.0 |
| 2003-02-18 10:00:00 | AAPL | Stock | 0.267 | 0.2684 | 0.2646 | 0.2666 | 48910344.0 |
| 2003-02-18 11:00:00 | AAPL | Stock | 0.2664 | 0.2677 | 0.2643 | 0.2661 | 22846768.0 |
| 2003-02-18 12:00:00 | AAPL | Stock | 0.2659 | 0.2671 | 0.2657 | 0.267 | 14737072.0 |
| 2003-02-18 13:00:00 | AAPL | Stock | 0.267 | 0.2673 | 0.2657 | 0.2669 | 15803200.0 |
| 2003-02-18 14:00:00 | AAPL | Stock | 0.2668 | 0.2679 | 0.2666 | 0.2671 | 25670904.0 |
| 2003-02-18 15:00:00 | AAPL | Stock | 0.2671 | 0.2732 | 0.2664 | 0.2726 | 63234136.0 |
| 2003-02-18 16:00:00 | AAPL | Stock | 0.273 | 0.2734 | 0.2661 | 0.2727 | 33878208.0 |
| 2003-02-18 17:00:00 | AAPL | Stock | 0.2723 | 0.2729 | 0.2718 | 0.2723 | 96152.0 |
| 2003-02-18 18:00:00 | AAPL | Stock | 0.2705 | 0.2705 | 0.2705 | 0.2705 | 16800.0 |
| 2003-02-18 08:00:00 | MSFT | Stock | 24.43 | 24.59 | 24.25 | 24.49 | 298496.0 |
| 2003-02-18 09:00:00 | MSFT | Stock | 24.49 | 25.0 | 24.33 | 24.85 | 10883970.0 |
| 2003-02-18 10:00:00 | MSFT | Stock | 24.856 | 24.97 | 24.68 | 24.87 | 11669430.0 |
| 2003-02-18 11:00:00 | MSFT | Stock | 24.87 | 24.91 | 24.73 | 24.83 | 4751272.0 |
| 2003-02-18 12:00:00 | MSFT | Stock | 24.83 | 24.91 | 24.8 | 24.87 | 3279264.0 |
| 2003-02-18 13:00:00 | MSFT | Stock | 24.86 | 24.93 | 24.73 | 24.8 | 3929453.0 |
| 2003-02-18 14:00:00 | MSFT | Stock | 24.81 | 24.91 | 24.78 | 24.815 | 3901940.0 |
| 2003-02-18 15:00:00 | MSFT | Stock | 24.82 | 24.99 | 24.53 | 24.96 | 10688614.0 |
| 2003-02-18 16:00:00 | MSFT | Stock | 24.96 | 25.0 | 24.84 | 24.92 | 1086878.0 |
| 2003-02-18 17:00:00 | MSFT | Stock | 24.9 | 24.96 | 24.894 | 24.93 | 325970.0 |
| 2003-02-18 18:00:00 | MSFT | Stock | 24.93 | 24.95 | 24.91 | 24.92 | 12140.0 |
| 2003-02-18 08:00:00 | NVDA | Stock | 0.1008 | 0.1056 | 0.1001 | 0.1042 | 26731200.0 |
| 2003-02-18 09:00:00 | NVDA | Stock | 0.1045 | 0.1126 | 0.1029 | 0.1067 | 516747360.0 |
| 2003-02-18 10:00:00 | NVDA | Stock | 0.1066 | 0.1069 | 0.1042 | 0.1057 | 385438080.0 |
| 2003-02-18 11:00:00 | NVDA | Stock | 0.1057 | 0.1058 | 0.1044 | 0.1053 | 131955480.0 |
| 2003-02-18 12:00:00 | NVDA | Stock | 0.1054 | 0.1062 | 0.1052 | 0.1062 | 76202520.0 |
| 2003-02-18 13:00:00 | NVDA | Stock | 0.1062 | 0.1066 | 0.1058 | 0.1062 | 79166880.0 |
| 2003-02-18 14:00:00 | NVDA | Stock | 0.1061 | 0.1075 | 0.1061 | 0.1067 | 143619720.0 |
| 2003-02-18 15:00:00 | NVDA | Stock | 0.1067 | 0.1069 | 0.1051 | 0.1062 | 202848360.0 |
| 2003-02-18 16:00:00 | NVDA | Stock | 0.1061 | 0.1062 | 0.1058 | 0.1058 | 13907640.0 |
| 2003-02-18 17:00:00 | NVDA | Stock | 0.1058 | 0.1061 | 0.1054 | 0.1057 | 3816000.0 |
| 2003-02-18 18:00:00 | NVDA | Stock | 0.1057 | 0.1058 | 0.1055 | 0.1058 | 1578000.0 |
| 2003-02-18 08:00:00 | AMZN | Stock | 1.0028 | 1.0075 | 1.0028 | 1.005 | 124000.0 |
| 2003-02-18 09:00:00 | AMZN | Stock | 1.0075 | 1.026 | 1.004 | 1.0235 | 18906100.0 |
| 2003-02-18 10:00:00 | AMZN | Stock | 1.0235 | 1.067 | 1.023 | 1.06 | 34469300.0 |
| 2003-02-18 11:00:00 | AMZN | Stock | 1.0595 | 1.0625 | 1.052 | 1.0555 | 19634460.0 |
| 2003-02-18 12:00:00 | AMZN | Stock | 1.0555 | 1.0615 | 1.055 | 1.0595 | 12967440.0 |
| 2003-02-18 13:00:00 | AMZN | Stock | 1.0605 | 1.0625 | 1.0585 | 1.062 | 10232160.0 |
| 2003-02-18 14:00:00 | AMZN | Stock | 1.0625 | 1.0681 | 1.062 | 1.065 | 12765200.0 |
| 2003-02-18 15:00:00 | AMZN | Stock | 1.065 | 1.07 | 1.0555 | 1.07 | 24978600.0 |
| 2003-02-18 16:00:00 | AMZN | Stock | 1.07 | 1.072 | 1.067 | 1.0705 | 1359080.0 |
| 2003-02-18 17:00:00 | AMZN | Stock | 1.072 | 1.0725 | 1.0695 | 1.0725 | 748000.0 |
| 2003-02-18 18:00:00 | AMZN | Stock | 1.0706 | 1.0706 | 1.0706 | 1.0706 | 4000.0 |
| 2003-02-18 09:00:00 | CL | Stock | 25.4 | 25.55 | 25.4 | 25.51 | 285000.0 |
| 2003-02-18 10:00:00 | CL | Stock | 25.515 | 25.575 | 25.395 | 25.485 | 545600.0 |
| 2003-02-18 11:00:00 | CL | Stock | 25.49 | 25.52 | 25.43 | 25.47 | 296800.0 |
| 2003-02-18 12:00:00 | CL | Stock | 25.47 | 25.495 | 25.41 | 25.455 | 181000.0 |
| 2003-02-18 13:00:00 | CL | Stock | 25.465 | 25.5 | 25.42 | 25.46 | 145400.0 |
| 2003-02-18 14:00:00 | CL | Stock | 25.46 | 25.46 | 25.33 | 25.335 | 272400.0 |
> showing 50 of 20,434 rows — these rows as CSV