PREVIEW / etf_1hour / 2001-07-12
file: by_date/etf_1hour/2001/2001-07-12.parquet size: 12 KB rows: 230
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-07-12 09:00:00 | SPY | ETF | 119.5 | 120.13 | 119.31 | 120.1 | 2029600.0 |
| 2001-07-12 10:00:00 | SPY | ETF | 120.08 | 120.62 | 119.95 | 120.37 | 1375100.0 |
| 2001-07-12 11:00:00 | SPY | ETF | 120.38 | 120.45 | 120.05 | 120.27 | 830100.0 |
| 2001-07-12 12:00:00 | SPY | ETF | 120.28 | 120.58 | 120.01 | 120.41 | 1111500.0 |
| 2001-07-12 13:00:00 | SPY | ETF | 120.34 | 120.67 | 120.21 | 120.35 | 1151700.0 |
| 2001-07-12 14:00:00 | SPY | ETF | 120.31 | 120.72 | 120.21 | 120.62 | 1439800.0 |
| 2001-07-12 15:00:00 | SPY | ETF | 120.68 | 121.47 | 120.57 | 121.24 | 2860500.0 |
| 2001-07-12 16:00:00 | SPY | ETF | 121.16 | 121.32 | 121.07 | 121.15 | 819000.0 |
| 2001-07-12 17:00:00 | SPY | ETF | 121.15 | 121.3 | 120.7 | 121.2 | 7700.0 |
| 2001-07-12 18:00:00 | SPY | ETF | 121.35 | 121.35 | 121.35 | 121.35 | 1000.0 |
| 2001-07-12 09:00:00 | QQQ | ETF | 42.63 | 42.94 | 42.3 | 42.79 | 12883700.0 |
| 2001-07-12 10:00:00 | QQQ | ETF | 42.79 | 43.0 | 42.59 | 42.65 | 10619500.0 |
| 2001-07-12 11:00:00 | QQQ | ETF | 42.65 | 42.76 | 42.42 | 42.67 | 6663800.0 |
| 2001-07-12 12:00:00 | QQQ | ETF | 42.69 | 43.14 | 42.55 | 42.98 | 8179200.0 |
| 2001-07-12 13:00:00 | QQQ | ETF | 42.98 | 43.2 | 42.81 | 43.01 | 4990900.0 |
| 2001-07-12 14:00:00 | QQQ | ETF | 43.02 | 43.43 | 42.85 | 43.38 | 7511700.0 |
| 2001-07-12 15:00:00 | QQQ | ETF | 43.35 | 43.83 | 43.27 | 43.62 | 13994200.0 |
| 2001-07-12 16:00:00 | QQQ | ETF | 43.59 | 43.75 | 43.4 | 43.5 | 2569000.0 |
| 2001-07-12 17:00:00 | QQQ | ETF | 43.49 | 44.0 | 43.4 | 43.95 | 912800.0 |
| 2001-07-12 18:00:00 | QQQ | ETF | 43.94 | 43.98 | 43.9 | 43.94 | 53000.0 |
| 2001-07-12 09:00:00 | IWM | ETF | 47.9 | 48.09 | 47.875 | 48.09 | 63400.0 |
| 2001-07-12 10:00:00 | IWM | ETF | 48.175 | 48.45 | 48.11 | 48.28 | 226000.0 |
| 2001-07-12 11:00:00 | IWM | ETF | 48.21 | 48.24 | 48.125 | 48.22 | 12000.0 |
| 2001-07-12 12:00:00 | IWM | ETF | 48.2 | 48.35 | 48.175 | 48.285 | 8000.0 |
| 2001-07-12 13:00:00 | IWM | ETF | 48.28 | 48.39 | 48.28 | 48.35 | 7600.0 |
| 2001-07-12 14:00:00 | IWM | ETF | 48.275 | 48.45 | 48.175 | 48.45 | 831600.0 |
| 2001-07-12 15:00:00 | IWM | ETF | 48.5 | 48.75 | 48.39 | 48.72 | 68400.0 |
| 2001-07-12 16:00:00 | IWM | ETF | 48.735 | 48.735 | 48.665 | 48.665 | 2800.0 |
| 2001-07-12 09:00:00 | DIA | ETF | 103.45 | 103.94 | 103.21 | 103.81 | 574500.0 |
| 2001-07-12 10:00:00 | DIA | ETF | 103.88 | 104.29 | 103.72 | 104.09 | 694100.0 |
| 2001-07-12 11:00:00 | DIA | ETF | 104.1 | 104.2 | 103.92 | 104.12 | 161300.0 |
| 2001-07-12 12:00:00 | DIA | ETF | 104.12 | 104.3 | 103.8 | 104.06 | 278700.0 |
| 2001-07-12 13:00:00 | DIA | ETF | 104.02 | 104.35 | 103.97 | 104.13 | 112100.0 |
| 2001-07-12 14:00:00 | DIA | ETF | 104.01 | 104.37 | 103.97 | 104.35 | 287200.0 |
| 2001-07-12 15:00:00 | DIA | ETF | 104.34 | 105.14 | 104.34 | 104.99 | 724800.0 |
| 2001-07-12 16:00:00 | DIA | ETF | 104.99 | 105.3 | 104.99 | 105.1 | 306300.0 |
> showing 36 of 230 rows — these rows as CSV