PREVIEW / etf_1hour / 2001-02-22
file: by_date/etf_1hour/2001/2001-02-22.parquet size: 11 KB rows: 204
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 |
|---|---|---|---|---|---|---|---|
| 2001-02-22 09:00:00 | SPY | ETF | 126.35 | 126.35 | 125.16 | 125.2 | 2329300.0 |
| 2001-02-22 10:00:00 | SPY | ETF | 125.13 | 125.5 | 123.02 | 124.7 | 5170700.0 |
| 2001-02-22 11:00:00 | SPY | ETF | 124.73 | 125.7 | 124.2 | 124.98 | 3793500.0 |
| 2001-02-22 12:00:00 | SPY | ETF | 124.98 | 125.68 | 124.65 | 125.36 | 2911400.0 |
| 2001-02-22 13:00:00 | SPY | ETF | 125.49 | 126.3 | 125.34 | 125.94 | 1671900.0 |
| 2001-02-22 14:00:00 | SPY | ETF | 126.0 | 126.54 | 124.78 | 125.15 | 1852000.0 |
| 2001-02-22 15:00:00 | SPY | ETF | 125.04 | 125.94 | 123.92 | 125.52 | 1975400.0 |
| 2001-02-22 16:00:00 | SPY | ETF | 125.34 | 125.96 | 125.1 | 125.1 | 618000.0 |
| 2001-02-22 09:00:00 | QQQ | ETF | 51.45 | 51.62 | 50.38 | 50.5 | 9724600.0 |
| 2001-02-22 10:00:00 | QQQ | ETF | 50.5 | 50.73 | 48.89 | 50.5 | 23406100.0 |
| 2001-02-22 11:00:00 | QQQ | ETF | 50.55 | 51.57 | 49.88 | 50.56 | 17004100.0 |
| 2001-02-22 12:00:00 | QQQ | ETF | 50.54 | 51.26 | 50.0 | 50.95 | 9295400.0 |
| 2001-02-22 13:00:00 | QQQ | ETF | 50.8 | 52.1 | 50.8 | 51.9 | 10594700.0 |
| 2001-02-22 14:00:00 | QQQ | ETF | 51.9 | 52.16 | 50.43 | 50.65 | 10482000.0 |
| 2001-02-22 15:00:00 | QQQ | ETF | 50.66 | 50.87 | 49.38 | 50.65 | 16136500.0 |
| 2001-02-22 16:00:00 | QQQ | ETF | 50.64 | 51.5 | 50.0 | 50.0 | 1996100.0 |
| 2001-02-22 17:00:00 | QQQ | ETF | 50.01 | 50.37 | 49.7 | 50.15 | 293200.0 |
| 2001-02-22 18:00:00 | QQQ | ETF | 50.2 | 50.75 | 50.2 | 50.55 | 54300.0 |
| 2001-02-22 09:00:00 | IWM | ETF | 48.175 | 48.245 | 47.93 | 48.025 | 25200.0 |
| 2001-02-22 10:00:00 | IWM | ETF | 48.0 | 48.0 | 47.2 | 47.55 | 14000.0 |
| 2001-02-22 11:00:00 | IWM | ETF | 47.5 | 47.745 | 47.485 | 47.745 | 26600.0 |
| 2001-02-22 12:00:00 | IWM | ETF | 47.415 | 47.55 | 47.15 | 47.425 | 94600.0 |
| 2001-02-22 13:00:00 | IWM | ETF | 47.3 | 47.675 | 47.3 | 47.425 | 130800.0 |
| 2001-02-22 14:00:00 | IWM | ETF | 47.5 | 47.75 | 47.425 | 47.425 | 119200.0 |
| 2001-02-22 15:00:00 | IWM | ETF | 47.5 | 47.735 | 47.125 | 47.5 | 104800.0 |
| 2001-02-22 09:00:00 | DIA | ETF | 105.6 | 105.85 | 105.15 | 105.2 | 540500.0 |
| 2001-02-22 10:00:00 | DIA | ETF | 105.2 | 105.55 | 103.8 | 104.96 | 818800.0 |
| 2001-02-22 11:00:00 | DIA | ETF | 104.96 | 105.48 | 104.44 | 105.1 | 345100.0 |
| 2001-02-22 12:00:00 | DIA | ETF | 104.9 | 105.25 | 104.6 | 105.14 | 230500.0 |
| 2001-02-22 13:00:00 | DIA | ETF | 105.05 | 105.75 | 105.01 | 105.44 | 176700.0 |
| 2001-02-22 14:00:00 | DIA | ETF | 105.5 | 105.85 | 104.7 | 104.85 | 166100.0 |
| 2001-02-22 15:00:00 | DIA | ETF | 104.85 | 105.75 | 104.16 | 105.3 | 276100.0 |
| 2001-02-22 16:00:00 | DIA | ETF | 105.24 | 105.65 | 104.2 | 105.65 | 6600.0 |
> showing 33 of 204 rows — these rows as CSV