PREVIEW / etf_1hour / 2001-04-24
file: by_date/etf_1hour/2001/2001-04-24.parquet size: 11 KB rows: 214
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-04-24 09:00:00 | SPY | ETF | 122.52 | 122.99 | 122.35 | 122.7 | 1196200.0 |
| 2001-04-24 10:00:00 | SPY | ETF | 122.61 | 123.65 | 122.26 | 123.09 | 1709700.0 |
| 2001-04-24 11:00:00 | SPY | ETF | 123.09 | 123.16 | 122.72 | 122.96 | 769600.0 |
| 2001-04-24 12:00:00 | SPY | ETF | 122.85 | 122.85 | 122.27 | 122.5 | 1876000.0 |
| 2001-04-24 13:00:00 | SPY | ETF | 122.65 | 122.88 | 122.22 | 122.4 | 989100.0 |
| 2001-04-24 14:00:00 | SPY | ETF | 122.4 | 122.49 | 121.81 | 122.11 | 635100.0 |
| 2001-04-24 15:00:00 | SPY | ETF | 122.1 | 122.19 | 121.1 | 121.13 | 1919800.0 |
| 2001-04-24 16:00:00 | SPY | ETF | 121.13 | 122.29 | 121.1 | 121.65 | 784400.0 |
| 2001-04-24 17:00:00 | SPY | ETF | 121.65 | 121.65 | 121.35 | 121.36 | 6000.0 |
| 2001-04-24 18:00:00 | SPY | ETF | 121.35 | 121.35 | 121.25 | 121.3 | 2100.0 |
| 2001-04-24 09:00:00 | QQQ | ETF | 45.1 | 45.22 | 44.52 | 44.86 | 12123100.0 |
| 2001-04-24 10:00:00 | QQQ | ETF | 44.95 | 46.42 | 44.67 | 45.75 | 20963600.0 |
| 2001-04-24 11:00:00 | QQQ | ETF | 45.7 | 45.9 | 45.36 | 45.65 | 10705100.0 |
| 2001-04-24 12:00:00 | QQQ | ETF | 45.66 | 45.85 | 45.15 | 45.51 | 6539400.0 |
| 2001-04-24 13:00:00 | QQQ | ETF | 45.54 | 45.66 | 45.22 | 45.29 | 4738200.0 |
| 2001-04-24 14:00:00 | QQQ | ETF | 45.27 | 45.31 | 44.1 | 44.36 | 12052800.0 |
| 2001-04-24 15:00:00 | QQQ | ETF | 44.38 | 44.5 | 43.75 | 43.95 | 14436200.0 |
| 2001-04-24 16:00:00 | QQQ | ETF | 43.96 | 44.5 | 43.92 | 44.05 | 2762000.0 |
| 2001-04-24 17:00:00 | QQQ | ETF | 44.09 | 44.25 | 43.86 | 43.87 | 106600.0 |
| 2001-04-24 18:00:00 | QQQ | ETF | 43.9 | 44.17 | 43.9 | 44.05 | 14700.0 |
| 2001-04-24 09:00:00 | IWM | ETF | 46.1 | 46.1 | 45.875 | 45.975 | 17400.0 |
| 2001-04-24 10:00:00 | IWM | ETF | 46.045 | 46.5 | 46.045 | 46.45 | 171400.0 |
| 2001-04-24 11:00:00 | IWM | ETF | 46.425 | 46.45 | 46.28 | 46.425 | 8400.0 |
| 2001-04-24 12:00:00 | IWM | ETF | 46.28 | 46.375 | 46.1 | 46.35 | 72600.0 |
| 2001-04-24 13:00:00 | IWM | ETF | 46.25 | 46.25 | 46.075 | 46.225 | 7800.0 |
| 2001-04-24 14:00:00 | IWM | ETF | 46.35 | 46.35 | 46.025 | 46.055 | 8000.0 |
| 2001-04-24 15:00:00 | IWM | ETF | 46.005 | 46.025 | 45.825 | 45.85 | 11200.0 |
| 2001-04-24 16:00:00 | IWM | ETF | 45.995 | 46.15 | 45.995 | 46.15 | 8800.0 |
| 2001-04-24 09:00:00 | DIA | ETF | 105.61 | 105.95 | 105.36 | 105.77 | 222700.0 |
| 2001-04-24 10:00:00 | DIA | ETF | 105.67 | 106.48 | 105.46 | 106.1 | 589500.0 |
| 2001-04-24 11:00:00 | DIA | ETF | 106.15 | 106.19 | 105.72 | 105.84 | 243000.0 |
| 2001-04-24 12:00:00 | DIA | ETF | 105.78 | 105.8 | 105.3 | 105.49 | 521400.0 |
| 2001-04-24 13:00:00 | DIA | ETF | 105.52 | 105.82 | 105.35 | 105.58 | 252100.0 |
| 2001-04-24 14:00:00 | DIA | ETF | 105.54 | 105.6 | 105.06 | 105.44 | 386700.0 |
| 2001-04-24 15:00:00 | DIA | ETF | 105.5 | 105.5 | 104.45 | 104.65 | 444500.0 |
| 2001-04-24 16:00:00 | DIA | ETF | 104.58 | 104.9 | 104.45 | 104.8 | 71900.0 |
> showing 36 of 214 rows — these rows as CSV