PREVIEW / stock_1hour / 2002-12-20
file: by_date/stock_1hour/2002/2002-12-20.parquet size: 443 KB rows: 21,275 symbols: 1,528
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-12-20 08:00:00 | AAPL | Stock | 0.2541 | 0.2545 | 0.2534 | 0.2536 | 588000.0 |
| 2002-12-20 09:00:00 | AAPL | Stock | 0.2545 | 0.2599 | 0.2461 | 0.2591 | 37525264.0 |
| 2002-12-20 10:00:00 | AAPL | Stock | 0.2591 | 0.26 | 0.2545 | 0.2561 | 37812880.0 |
| 2002-12-20 11:00:00 | AAPL | Stock | 0.256 | 0.2576 | 0.255 | 0.2566 | 20792408.0 |
| 2002-12-20 12:00:00 | AAPL | Stock | 0.2566 | 0.2584 | 0.2557 | 0.2564 | 15394904.0 |
| 2002-12-20 13:00:00 | AAPL | Stock | 0.2564 | 0.2577 | 0.2564 | 0.2573 | 9390304.0 |
| 2002-12-20 14:00:00 | AAPL | Stock | 0.2573 | 0.2573 | 0.2534 | 0.2534 | 20586944.0 |
| 2002-12-20 15:00:00 | AAPL | Stock | 0.2534 | 0.2555 | 0.2518 | 0.252 | 44203768.0 |
| 2002-12-20 16:00:00 | AAPL | Stock | 0.2532 | 0.2556 | 0.2514 | 0.2527 | 33571328.0 |
| 2002-12-20 17:00:00 | AAPL | Stock | 0.2523 | 0.2529 | 0.2522 | 0.2523 | 3298400.0 |
| 2002-12-20 18:00:00 | AAPL | Stock | 0.2525 | 0.2529 | 0.252 | 0.2529 | 851200.0 |
| 2002-12-20 08:00:00 | MSFT | Stock | 26.7 | 26.805 | 26.555 | 26.79 | 347900.0 |
| 2002-12-20 09:00:00 | MSFT | Stock | 26.785 | 26.84 | 25.0 | 26.73 | 13266970.0 |
| 2002-12-20 10:00:00 | MSFT | Stock | 26.73 | 26.785 | 26.55 | 26.615 | 9466632.0 |
| 2002-12-20 11:00:00 | MSFT | Stock | 26.615 | 26.695 | 26.54 | 26.685 | 5276712.0 |
| 2002-12-20 12:00:00 | MSFT | Stock | 26.675 | 26.835 | 26.67 | 26.765 | 5094984.0 |
| 2002-12-20 13:00:00 | MSFT | Stock | 26.765 | 26.845 | 26.73 | 26.73 | 4006346.0 |
| 2002-12-20 14:00:00 | MSFT | Stock | 26.739 | 26.755 | 26.56 | 26.575 | 6979428.0 |
| 2002-12-20 15:00:00 | MSFT | Stock | 26.57 | 26.775 | 26.48 | 26.54 | 9796678.0 |
| 2002-12-20 16:00:00 | MSFT | Stock | 26.4905 | 26.7455 | 26.06 | 26.535 | 5510374.0 |
| 2002-12-20 17:00:00 | MSFT | Stock | 26.52 | 26.57 | 26.5 | 26.51 | 2602900.0 |
| 2002-12-20 18:00:00 | MSFT | Stock | 26.5625 | 26.57 | 26.515 | 26.57 | 198000.0 |
| 2002-12-20 08:00:00 | NVDA | Stock | 0.1079 | 0.1092 | 0.1054 | 0.1092 | 3644400.0 |
| 2002-12-20 09:00:00 | NVDA | Stock | 0.1088 | 0.1092 | 0.1021 | 0.1082 | 139305360.0 |
| 2002-12-20 10:00:00 | NVDA | Stock | 0.1082 | 0.1087 | 0.1067 | 0.1077 | 106004760.0 |
| 2002-12-20 11:00:00 | NVDA | Stock | 0.1077 | 0.1083 | 0.107 | 0.1082 | 44557320.0 |
| 2002-12-20 12:00:00 | NVDA | Stock | 0.1082 | 0.1099 | 0.1079 | 0.1089 | 78354600.0 |
| 2002-12-20 13:00:00 | NVDA | Stock | 0.1088 | 0.1094 | 0.1083 | 0.1084 | 40826040.0 |
| 2002-12-20 14:00:00 | NVDA | Stock | 0.1084 | 0.1084 | 0.1062 | 0.1067 | 83863920.0 |
| 2002-12-20 15:00:00 | NVDA | Stock | 0.1067 | 0.109 | 0.1059 | 0.1067 | 73785480.0 |
| 2002-12-20 16:00:00 | NVDA | Stock | 0.1062 | 0.1092 | 0.1062 | 0.1069 | 44914080.0 |
| 2002-12-20 17:00:00 | NVDA | Stock | 0.1067 | 0.1074 | 0.1061 | 0.1074 | 24816000.0 |
| 2002-12-20 18:00:00 | NVDA | Stock | 0.1092 | 0.1092 | 0.1067 | 0.1068 | 1392000.0 |
| 2002-12-20 08:00:00 | AMZN | Stock | 1.0828 | 1.1 | 1.0828 | 1.0945 | 850000.0 |
| 2002-12-20 09:00:00 | AMZN | Stock | 1.0946 | 1.0995 | 1.0803 | 1.091 | 13093080.0 |
| 2002-12-20 10:00:00 | AMZN | Stock | 1.091 | 1.0935 | 1.086 | 1.091 | 9399260.0 |
| 2002-12-20 11:00:00 | AMZN | Stock | 1.0924 | 1.096 | 1.091 | 1.0925 | 7973680.0 |
| 2002-12-20 12:00:00 | AMZN | Stock | 1.092 | 1.0965 | 1.0896 | 1.0905 | 7562980.0 |
| 2002-12-20 13:00:00 | AMZN | Stock | 1.091 | 1.0935 | 1.0905 | 1.091 | 5933800.0 |
| 2002-12-20 14:00:00 | AMZN | Stock | 1.091 | 1.0955 | 1.0875 | 1.0885 | 8047240.0 |
| 2002-12-20 15:00:00 | AMZN | Stock | 1.0886 | 1.1005 | 1.0885 | 1.095 | 17747420.0 |
| 2002-12-20 16:00:00 | AMZN | Stock | 1.0955 | 1.101 | 1.09 | 1.094 | 4473000.0 |
| 2002-12-20 17:00:00 | AMZN | Stock | 1.0964 | 1.0969 | 1.0961 | 1.0965 | 2740000.0 |
| 2002-12-20 18:00:00 | AMZN | Stock | 1.096 | 1.097 | 1.09 | 1.0965 | 84000.0 |
| 2002-12-20 09:00:00 | CL | Stock | 26.0 | 26.245 | 26.0 | 26.22 | 1237600.0 |
| 2002-12-20 10:00:00 | CL | Stock | 26.21 | 26.225 | 26.11 | 26.2 | 413000.0 |
| 2002-12-20 11:00:00 | CL | Stock | 26.2 | 26.215 | 26.135 | 26.15 | 527800.0 |
| 2002-12-20 12:00:00 | CL | Stock | 26.15 | 26.17 | 26.075 | 26.11 | 418000.0 |
| 2002-12-20 13:00:00 | CL | Stock | 26.13 | 26.18 | 26.1 | 26.15 | 207800.0 |
| 2002-12-20 14:00:00 | CL | Stock | 26.135 | 26.155 | 26.1 | 26.13 | 464600.0 |
> showing 50 of 21,275 rows — these rows as CSV