PREVIEW / etf_1hour / 2001-11-08
file: by_date/etf_1hour/2001/2001-11-08.parquet size: 13 KB rows: 284
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-11-08 09:00:00 | SPY | ETF | 112.87 | 113.06 | 112.6 | 112.91 | 2897600.0 |
| 2001-11-08 10:00:00 | SPY | ETF | 112.9 | 113.95 | 112.7 | 113.93 | 3372100.0 |
| 2001-11-08 11:00:00 | SPY | ETF | 113.9 | 114.08 | 113.37 | 113.66 | 3661100.0 |
| 2001-11-08 12:00:00 | SPY | ETF | 113.64 | 113.74 | 113.2 | 113.34 | 1606900.0 |
| 2001-11-08 13:00:00 | SPY | ETF | 113.42 | 113.7 | 113.1 | 113.35 | 1842200.0 |
| 2001-11-08 14:00:00 | SPY | ETF | 113.33 | 113.4 | 112.67 | 112.71 | 2724600.0 |
| 2001-11-08 15:00:00 | SPY | ETF | 112.73 | 112.75 | 111.9 | 112.35 | 4306700.0 |
| 2001-11-08 16:00:00 | SPY | ETF | 112.3 | 112.68 | 112.26 | 112.62 | 1856300.0 |
| 2001-11-08 17:00:00 | SPY | ETF | 112.62 | 113.26 | 112.49 | 112.6 | 184600.0 |
| 2001-11-08 18:00:00 | SPY | ETF | 112.5 | 112.53 | 112.5 | 112.53 | 1400.0 |
| 2001-11-08 09:00:00 | QQQ | ETF | 38.55 | 38.81 | 38.35 | 38.73 | 14309000.0 |
| 2001-11-08 10:00:00 | QQQ | ETF | 38.72 | 39.33 | 38.59 | 39.28 | 18407800.0 |
| 2001-11-08 11:00:00 | QQQ | ETF | 39.28 | 39.4 | 38.98 | 39.16 | 15354900.0 |
| 2001-11-08 12:00:00 | QQQ | ETF | 39.18 | 39.2 | 38.88 | 39.16 | 7541400.0 |
| 2001-11-08 13:00:00 | QQQ | ETF | 39.12 | 39.3 | 38.9 | 38.97 | 6739200.0 |
| 2001-11-08 14:00:00 | QQQ | ETF | 38.99 | 39.01 | 38.15 | 38.18 | 17423800.0 |
| 2001-11-08 15:00:00 | QQQ | ETF | 38.19 | 38.2 | 37.28 | 37.65 | 21739400.0 |
| 2001-11-08 16:00:00 | QQQ | ETF | 37.67 | 37.98 | 36.92 | 37.68 | 2346500.0 |
| 2001-11-08 17:00:00 | QQQ | ETF | 37.68 | 38.74 | 37.65 | 37.72 | 54600.0 |
| 2001-11-08 18:00:00 | QQQ | ETF | 37.72 | 37.75 | 37.68 | 37.75 | 34100.0 |
| 2001-11-08 09:00:00 | IWM | ETF | 44.175 | 44.195 | 43.905 | 44.155 | 9400.0 |
| 2001-11-08 10:00:00 | IWM | ETF | 44.09 | 44.45 | 44.09 | 44.445 | 63800.0 |
| 2001-11-08 11:00:00 | IWM | ETF | 44.45 | 44.45 | 44.185 | 44.21 | 68400.0 |
| 2001-11-08 12:00:00 | IWM | ETF | 44.205 | 44.225 | 43.955 | 44.105 | 78800.0 |
| 2001-11-08 13:00:00 | IWM | ETF | 44.12 | 44.275 | 44.1 | 44.22 | 46200.0 |
| 2001-11-08 14:00:00 | IWM | ETF | 44.18 | 44.19 | 44.0 | 44.02 | 35200.0 |
| 2001-11-08 15:00:00 | IWM | ETF | 43.975 | 43.975 | 43.475 | 43.725 | 155000.0 |
| 2001-11-08 16:00:00 | IWM | ETF | 43.85 | 43.85 | 43.85 | 43.85 | 26000.0 |
| 2001-11-08 09:00:00 | DIA | ETF | 96.3 | 96.48 | 95.95 | 96.34 | 708400.0 |
| 2001-11-08 10:00:00 | DIA | ETF | 96.27 | 97.29 | 96.14 | 97.29 | 729200.0 |
| 2001-11-08 11:00:00 | DIA | ETF | 97.24 | 97.4 | 96.73 | 96.99 | 620100.0 |
| 2001-11-08 12:00:00 | DIA | ETF | 97.09 | 97.11 | 96.65 | 96.8 | 313000.0 |
| 2001-11-08 13:00:00 | DIA | ETF | 96.83 | 97.18 | 96.55 | 96.83 | 182300.0 |
| 2001-11-08 14:00:00 | DIA | ETF | 96.8 | 96.81 | 96.24 | 96.24 | 480700.0 |
| 2001-11-08 15:00:00 | DIA | ETF | 96.3 | 96.3 | 95.66 | 96.0 | 781000.0 |
| 2001-11-08 16:00:00 | DIA | ETF | 96.0 | 97.0 | 95.92 | 96.23 | 134300.0 |
> showing 36 of 284 rows — these rows as CSV