PREVIEW / etf_1hour / 2002-06-05
file: by_date/etf_1hour/2002/2002-06-05.parquet size: 14 KB rows: 308
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-06-05 09:00:00 | SPY | ETF | 104.95 | 105.08 | 104.63 | 105.07 | 2857100.0 |
| 2002-06-05 10:00:00 | SPY | ETF | 105.05 | 105.55 | 104.78 | 104.86 | 3460800.0 |
| 2002-06-05 11:00:00 | SPY | ETF | 104.88 | 105.13 | 104.35 | 104.57 | 1884700.0 |
| 2002-06-05 12:00:00 | SPY | ETF | 104.58 | 105.06 | 104.48 | 104.95 | 1345400.0 |
| 2002-06-05 13:00:00 | SPY | ETF | 104.91 | 105.26 | 104.76 | 104.93 | 934800.0 |
| 2002-06-05 14:00:00 | SPY | ETF | 104.95 | 105.2 | 104.81 | 105.05 | 1350600.0 |
| 2002-06-05 15:00:00 | SPY | ETF | 105.03 | 105.62 | 104.94 | 105.5 | 3271000.0 |
| 2002-06-05 16:00:00 | SPY | ETF | 105.47 | 105.69 | 105.32 | 105.63 | 1406300.0 |
| 2002-06-05 17:00:00 | SPY | ETF | 105.68 | 105.68 | 105.63 | 105.66 | 22600.0 |
| 2002-06-05 18:00:00 | SPY | ETF | 105.69 | 105.69 | 105.55 | 105.68 | 600.0 |
| 2002-06-05 09:00:00 | QQQ | ETF | 29.42 | 29.68 | 29.2 | 29.49 | 14168900.0 |
| 2002-06-05 10:00:00 | QQQ | ETF | 29.49 | 29.8 | 29.27 | 29.3 | 19616000.0 |
| 2002-06-05 11:00:00 | QQQ | ETF | 29.29 | 29.44 | 28.98 | 29.12 | 11687600.0 |
| 2002-06-05 12:00:00 | QQQ | ETF | 29.12 | 29.33 | 28.97 | 29.24 | 7219100.0 |
| 2002-06-05 13:00:00 | QQQ | ETF | 29.24 | 29.45 | 29.11 | 29.22 | 6422800.0 |
| 2002-06-05 14:00:00 | QQQ | ETF | 29.22 | 29.43 | 29.15 | 29.29 | 7375200.0 |
| 2002-06-05 15:00:00 | QQQ | ETF | 29.34 | 29.75 | 29.2 | 29.71 | 19798500.0 |
| 2002-06-05 16:00:00 | QQQ | ETF | 29.72 | 29.85 | 29.45 | 29.74 | 3983600.0 |
| 2002-06-05 17:00:00 | QQQ | ETF | 29.74 | 29.74 | 29.69 | 29.73 | 60600.0 |
| 2002-06-05 18:00:00 | QQQ | ETF | 29.73 | 29.75 | 29.72 | 29.72 | 8000.0 |
| 2002-06-05 09:00:00 | IWM | ETF | 47.275 | 47.275 | 47.0 | 47.075 | 463800.0 |
| 2002-06-05 10:00:00 | IWM | ETF | 47.155 | 47.425 | 47.05 | 47.1 | 267800.0 |
| 2002-06-05 11:00:00 | IWM | ETF | 47.125 | 47.125 | 46.86 | 46.925 | 58000.0 |
| 2002-06-05 12:00:00 | IWM | ETF | 46.925 | 47.105 | 46.9 | 47.03 | 68200.0 |
| 2002-06-05 13:00:00 | IWM | ETF | 47.025 | 47.14 | 47.005 | 47.05 | 87200.0 |
| 2002-06-05 14:00:00 | IWM | ETF | 47.1 | 47.235 | 47.06 | 47.115 | 230200.0 |
| 2002-06-05 15:00:00 | IWM | ETF | 47.115 | 47.3 | 47.1 | 47.26 | 290200.0 |
| 2002-06-05 16:00:00 | IWM | ETF | 47.33 | 47.35 | 47.22 | 47.28 | 26600.0 |
| 2002-06-05 17:00:00 | IWM | ETF | 47.8 | 47.8 | 47.8 | 47.8 | 800.0 |
| 2002-06-05 09:00:00 | DIA | ETF | 97.28 | 97.7 | 97.14 | 97.64 | 425900.0 |
| 2002-06-05 10:00:00 | DIA | ETF | 97.65 | 98.19 | 97.5 | 97.65 | 799700.0 |
| 2002-06-05 11:00:00 | DIA | ETF | 97.58 | 97.8 | 97.1 | 97.33 | 559800.0 |
| 2002-06-05 12:00:00 | DIA | ETF | 97.34 | 97.75 | 97.24 | 97.63 | 168700.0 |
| 2002-06-05 13:00:00 | DIA | ETF | 97.6 | 97.92 | 97.46 | 97.61 | 323900.0 |
| 2002-06-05 14:00:00 | DIA | ETF | 97.63 | 97.85 | 97.5 | 97.71 | 281700.0 |
| 2002-06-05 15:00:00 | DIA | ETF | 97.72 | 98.3 | 97.61 | 98.18 | 995200.0 |
| 2002-06-05 16:00:00 | DIA | ETF | 98.18 | 98.3 | 97.94 | 98.25 | 58400.0 |
| 2002-06-05 17:00:00 | DIA | ETF | 98.23 | 98.23 | 98.2 | 98.2 | 400.0 |
> showing 38 of 308 rows — these rows as CSV