PREVIEW / stock_1hour / 2003-06-13
file: by_date/stock_1hour/2003/2003-06-13.parquet size: 456 KB rows: 22,366 symbols: 1,586
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-06-13 09:00:00 | AAPL | Stock | 0.3166 | 0.3205 | 0.3164 | 0.3173 | 16353288.0 |
| 2003-06-13 10:00:00 | AAPL | Stock | 0.3171 | 0.3171 | 0.307 | 0.3082 | 49849968.0 |
| 2003-06-13 11:00:00 | AAPL | Stock | 0.308 | 0.3096 | 0.3059 | 0.3073 | 23370928.0 |
| 2003-06-13 12:00:00 | AAPL | Stock | 0.3073 | 0.3107 | 0.3073 | 0.3102 | 16938936.0 |
| 2003-06-13 13:00:00 | AAPL | Stock | 0.31 | 0.3114 | 0.31 | 0.3105 | 13449408.0 |
| 2003-06-13 14:00:00 | AAPL | Stock | 0.3107 | 0.3127 | 0.3105 | 0.312 | 20938960.0 |
| 2003-06-13 15:00:00 | AAPL | Stock | 0.3118 | 0.3145 | 0.31 | 0.3111 | 35622440.0 |
| 2003-06-13 16:00:00 | AAPL | Stock | 0.3109 | 0.3134 | 0.3089 | 0.3109 | 3231312.0 |
| 2003-06-13 17:00:00 | AAPL | Stock | 0.3111 | 0.3111 | 0.3111 | 0.3111 | 95200.0 |
| 2003-06-13 08:00:00 | MSFT | Stock | 25.0 | 25.23 | 24.89 | 25.15 | 187309.0 |
| 2003-06-13 09:00:00 | MSFT | Stock | 25.15 | 25.25 | 24.98 | 25.034 | 9955252.0 |
| 2003-06-13 10:00:00 | MSFT | Stock | 25.04 | 25.089 | 24.75 | 24.76 | 10170180.0 |
| 2003-06-13 11:00:00 | MSFT | Stock | 24.76 | 24.77 | 24.61 | 24.69 | 8108644.0 |
| 2003-06-13 12:00:00 | MSFT | Stock | 24.68 | 24.73 | 24.61 | 24.667 | 3988348.0 |
| 2003-06-13 13:00:00 | MSFT | Stock | 24.67 | 24.7 | 24.53 | 24.57 | 3694809.0 |
| 2003-06-13 14:00:00 | MSFT | Stock | 24.56 | 24.67 | 24.53 | 24.59 | 3875051.0 |
| 2003-06-13 15:00:00 | MSFT | Stock | 24.58 | 24.7 | 24.49 | 24.67 | 9858291.0 |
| 2003-06-13 16:00:00 | MSFT | Stock | 24.67 | 24.73 | 24.6 | 24.658 | 1476906.0 |
| 2003-06-13 17:00:00 | MSFT | Stock | 24.64 | 24.658 | 24.62 | 24.63 | 35248.0 |
| 2003-06-13 18:00:00 | MSFT | Stock | 24.63 | 24.6642 | 24.62 | 24.62 | 6648.0 |
| 2003-06-13 08:00:00 | NVDA | Stock | 0.2117 | 0.2122 | 0.2092 | 0.2092 | 2448000.0 |
| 2003-06-13 09:00:00 | NVDA | Stock | 0.2092 | 0.2122 | 0.2 | 0.2046 | 404795400.0 |
| 2003-06-13 10:00:00 | NVDA | Stock | 0.2045 | 0.2045 | 0.1972 | 0.1986 | 420351960.0 |
| 2003-06-13 11:00:00 | NVDA | Stock | 0.1986 | 0.1986 | 0.1952 | 0.1966 | 213418680.0 |
| 2003-06-13 12:00:00 | NVDA | Stock | 0.1966 | 0.1989 | 0.196 | 0.1967 | 116544120.0 |
| 2003-06-13 13:00:00 | NVDA | Stock | 0.1967 | 0.197 | 0.1947 | 0.1955 | 139558680.0 |
| 2003-06-13 14:00:00 | NVDA | Stock | 0.1955 | 0.1965 | 0.1942 | 0.1953 | 180798360.0 |
| 2003-06-13 15:00:00 | NVDA | Stock | 0.1954 | 0.1991 | 0.1943 | 0.1957 | 233618760.0 |
| 2003-06-13 16:00:00 | NVDA | Stock | 0.1957 | 0.1968 | 0.195 | 0.195 | 11477520.0 |
| 2003-06-13 17:00:00 | NVDA | Stock | 0.1951 | 0.1956 | 0.1951 | 0.1954 | 528000.0 |
| 2003-06-13 18:00:00 | NVDA | Stock | 0.1954 | 0.1958 | 0.1954 | 0.1958 | 324000.0 |
| 2003-06-13 08:00:00 | AMZN | Stock | 1.756 | 1.76 | 1.7515 | 1.76 | 12000.0 |
| 2003-06-13 09:00:00 | AMZN | Stock | 1.76 | 1.7725 | 1.739 | 1.7495 | 18323220.0 |
| 2003-06-13 10:00:00 | AMZN | Stock | 1.7495 | 1.7525 | 1.703 | 1.7165 | 34621000.0 |
| 2003-06-13 11:00:00 | AMZN | Stock | 1.716 | 1.7225 | 1.7095 | 1.7135 | 14494220.0 |
| 2003-06-13 12:00:00 | AMZN | Stock | 1.7135 | 1.725 | 1.7025 | 1.713 | 14552140.0 |
| 2003-06-13 13:00:00 | AMZN | Stock | 1.713 | 1.7205 | 1.7065 | 1.711 | 6932620.0 |
| 2003-06-13 14:00:00 | AMZN | Stock | 1.711 | 1.7195 | 1.705 | 1.7075 | 6984820.0 |
| 2003-06-13 15:00:00 | AMZN | Stock | 1.7075 | 1.7185 | 1.7045 | 1.707 | 16982280.0 |
| 2003-06-13 16:00:00 | AMZN | Stock | 1.707 | 1.7075 | 1.7045 | 1.7045 | 603700.0 |
| 2003-06-13 17:00:00 | AMZN | Stock | 1.707 | 1.707 | 1.7055 | 1.7055 | 90500.0 |
| 2003-06-13 18:00:00 | AMZN | Stock | 1.7065 | 1.7065 | 1.7065 | 1.7065 | 12000.0 |
| 2003-06-13 09:00:00 | CL | Stock | 29.8 | 29.865 | 29.745 | 29.76 | 345000.0 |
| 2003-06-13 10:00:00 | CL | Stock | 29.76 | 29.85 | 29.745 | 29.84 | 547400.0 |
| 2003-06-13 11:00:00 | CL | Stock | 29.84 | 30.075 | 29.84 | 29.985 | 820600.0 |
| 2003-06-13 12:00:00 | CL | Stock | 29.97 | 29.97 | 29.88 | 29.92 | 357400.0 |
| 2003-06-13 13:00:00 | CL | Stock | 29.92 | 29.95 | 29.895 | 29.925 | 274000.0 |
| 2003-06-13 14:00:00 | CL | Stock | 29.92 | 30.03 | 29.91 | 29.98 | 401600.0 |
| 2003-06-13 15:00:00 | CL | Stock | 29.98 | 30.05 | 29.925 | 29.985 | 761400.0 |
| 2003-06-13 16:00:00 | CL | Stock | 29.985 | 29.99 | 29.985 | 29.99 | 59200.0 |
> showing 50 of 22,366 rows — these rows as CSV