PREVIEW / etf_1hour / 2000-10-20
file: by_date/etf_1hour/2000/2000-10-20.parquet size: 9 KB rows: 176
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 |
|---|---|---|---|---|---|---|---|
| 2000-10-20 09:00:00 | SPY | ETF | 138.375 | 139.4375 | 138.375 | 139.125 | 1072400.0 |
| 2000-10-20 10:00:00 | SPY | ETF | 138.9062 | 139.8438 | 138.9062 | 139.5938 | 544100.0 |
| 2000-10-20 11:00:00 | SPY | ETF | 139.5938 | 140.25 | 139.375 | 140.2188 | 668200.0 |
| 2000-10-20 12:00:00 | SPY | ETF | 140.2188 | 140.5 | 139.9375 | 140.4375 | 1483800.0 |
| 2000-10-20 13:00:00 | SPY | ETF | 140.4375 | 141.1875 | 140.3125 | 140.875 | 860800.0 |
| 2000-10-20 14:00:00 | SPY | ETF | 140.875 | 140.9375 | 140.0312 | 140.25 | 906500.0 |
| 2000-10-20 15:00:00 | SPY | ETF | 140.25 | 140.4062 | 139.6875 | 139.875 | 976200.0 |
| 2000-10-20 16:00:00 | SPY | ETF | 139.9375 | 140.3438 | 139.8125 | 139.9062 | 469900.0 |
| 2000-10-20 09:00:00 | QQQ | ETF | 84.5 | 85.875 | 84.375 | 84.9688 | 9049500.0 |
| 2000-10-20 10:00:00 | QQQ | ETF | 84.75 | 86.4375 | 84.75 | 86.1562 | 8187100.0 |
| 2000-10-20 11:00:00 | QQQ | ETF | 86.1562 | 87.0625 | 86.0 | 86.8125 | 5076000.0 |
| 2000-10-20 12:00:00 | QQQ | ETF | 86.8125 | 86.875 | 86.3125 | 86.75 | 3415700.0 |
| 2000-10-20 13:00:00 | QQQ | ETF | 86.75 | 87.75 | 86.5625 | 87.375 | 4075000.0 |
| 2000-10-20 14:00:00 | QQQ | ETF | 87.3438 | 87.5 | 86.375 | 86.75 | 3414400.0 |
| 2000-10-20 15:00:00 | QQQ | ETF | 86.7188 | 86.75 | 85.75 | 85.9375 | 6153200.0 |
| 2000-10-20 16:00:00 | QQQ | ETF | 86.0625 | 86.375 | 85.8125 | 86.3125 | 911600.0 |
| 2000-10-20 17:00:00 | QQQ | ETF | 86.25 | 87.0 | 86.25 | 86.375 | 16700.0 |
| 2000-10-20 18:00:00 | QQQ | ETF | 86.375 | 86.6875 | 86.25 | 86.25 | 1300.0 |
| 2000-10-20 09:00:00 | IWM | ETF | 48.3438 | 48.4062 | 48.3438 | 48.4062 | 1400.0 |
| 2000-10-20 10:00:00 | IWM | ETF | 48.3125 | 48.5938 | 48.3125 | 48.5938 | 96200.0 |
| 2000-10-20 11:00:00 | IWM | ETF | 48.5156 | 48.7969 | 48.5156 | 48.7969 | 17800.0 |
| 2000-10-20 12:00:00 | IWM | ETF | 48.8125 | 48.8125 | 48.6406 | 48.7188 | 85600.0 |
| 2000-10-20 13:00:00 | IWM | ETF | 48.8438 | 49.0312 | 48.8438 | 48.9062 | 24000.0 |
| 2000-10-20 14:00:00 | IWM | ETF | 49.0 | 49.0312 | 48.75 | 48.9062 | 10400.0 |
| 2000-10-20 15:00:00 | IWM | ETF | 48.7188 | 48.8125 | 48.625 | 48.6875 | 25600.0 |
| 2000-10-20 16:00:00 | IWM | ETF | 48.6875 | 48.6875 | 48.5781 | 48.5781 | 2200.0 |
| 2000-10-20 09:00:00 | DIA | ETF | 100.875 | 101.625 | 100.875 | 101.375 | 118000.0 |
| 2000-10-20 10:00:00 | DIA | ETF | 101.3438 | 101.3438 | 100.8125 | 100.9375 | 102400.0 |
| 2000-10-20 11:00:00 | DIA | ETF | 101.0 | 101.5 | 100.875 | 101.4375 | 121300.0 |
| 2000-10-20 12:00:00 | DIA | ETF | 101.4375 | 102.0 | 101.2188 | 101.9375 | 202400.0 |
| 2000-10-20 13:00:00 | DIA | ETF | 101.8438 | 102.4688 | 101.8438 | 102.125 | 282500.0 |
| 2000-10-20 14:00:00 | DIA | ETF | 102.2188 | 102.5 | 101.875 | 102.375 | 344600.0 |
| 2000-10-20 15:00:00 | DIA | ETF | 102.2812 | 102.6875 | 102.0 | 102.125 | 477100.0 |
| 2000-10-20 16:00:00 | DIA | ETF | 102.25 | 102.375 | 102.1875 | 102.375 | 22600.0 |
| 2000-10-20 17:00:00 | DIA | ETF | 103.0 | 103.0 | 103.0 | 103.0 | 100.0 |
> showing 35 of 176 rows — these rows as CSV