PREVIEW / etf_1hour / 2002-11-13
file: by_date/etf_1hour/2002/2002-11-13.parquet size: 16 KB rows: 362
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-11-13 08:00:00 | SPY | ETF | 88.46 | 88.54 | 88.45 | 88.52 | 5500.0 |
| 2002-11-13 09:00:00 | SPY | ETF | 88.46 | 88.6 | 88.05 | 88.26 | 5037600.0 |
| 2002-11-13 10:00:00 | SPY | ETF | 88.38 | 89.57 | 87.45 | 88.62 | 14089900.0 |
| 2002-11-13 11:00:00 | SPY | ETF | 88.64 | 89.74 | 88.5 | 89.57 | 9466900.0 |
| 2002-11-13 12:00:00 | SPY | ETF | 89.57 | 89.7 | 89.19 | 89.38 | 4039000.0 |
| 2002-11-13 13:00:00 | SPY | ETF | 89.4 | 89.43 | 88.71 | 88.73 | 4881000.0 |
| 2002-11-13 14:00:00 | SPY | ETF | 88.76 | 88.97 | 87.77 | 87.81 | 6411500.0 |
| 2002-11-13 15:00:00 | SPY | ETF | 87.81 | 88.8 | 87.74 | 88.68 | 8170300.0 |
| 2002-11-13 16:00:00 | SPY | ETF | 88.71 | 89.49 | 88.66 | 88.85 | 3543800.0 |
| 2002-11-13 17:00:00 | SPY | ETF | 88.82 | 88.96 | 88.64 | 88.92 | 112500.0 |
| 2002-11-13 18:00:00 | SPY | ETF | 88.9 | 88.9 | 88.76 | 88.9 | 19500.0 |
| 2002-11-13 08:00:00 | QQQ | ETF | 24.73 | 24.8 | 24.73 | 24.74 | 13600.0 |
| 2002-11-13 09:00:00 | QQQ | ETF | 24.74 | 24.98 | 24.61 | 24.86 | 13393100.0 |
| 2002-11-13 10:00:00 | QQQ | ETF | 24.85 | 25.27 | 24.49 | 25.07 | 27629500.0 |
| 2002-11-13 11:00:00 | QQQ | ETF | 25.05 | 25.45 | 24.96 | 25.36 | 20159200.0 |
| 2002-11-13 12:00:00 | QQQ | ETF | 25.36 | 25.44 | 25.27 | 25.35 | 8324100.0 |
| 2002-11-13 13:00:00 | QQQ | ETF | 25.35 | 25.41 | 25.06 | 25.09 | 6608100.0 |
| 2002-11-13 14:00:00 | QQQ | ETF | 25.09 | 25.2 | 24.74 | 24.76 | 12146200.0 |
| 2002-11-13 15:00:00 | QQQ | ETF | 24.76 | 25.2 | 24.71 | 25.16 | 14554800.0 |
| 2002-11-13 16:00:00 | QQQ | ETF | 25.18 | 25.29 | 24.9 | 24.94 | 6934500.0 |
| 2002-11-13 17:00:00 | QQQ | ETF | 24.93 | 25.05 | 24.88 | 25.0 | 1392700.0 |
| 2002-11-13 18:00:00 | QQQ | ETF | 25.0 | 25.03 | 24.97 | 25.03 | 21900.0 |
| 2002-11-13 19:00:00 | QQQ | ETF | 25.02 | 25.05 | 25.02 | 25.05 | 3400.0 |
| 2002-11-13 09:00:00 | IWM | ETF | 37.3 | 37.325 | 37.155 | 37.25 | 143200.0 |
| 2002-11-13 10:00:00 | IWM | ETF | 37.255 | 37.625 | 37.025 | 37.45 | 709600.0 |
| 2002-11-13 11:00:00 | IWM | ETF | 37.46 | 38.0 | 37.38 | 37.82 | 286400.0 |
| 2002-11-13 12:00:00 | IWM | ETF | 37.905 | 37.94 | 37.725 | 37.86 | 211400.0 |
| 2002-11-13 13:00:00 | IWM | ETF | 37.86 | 37.86 | 37.615 | 37.68 | 505400.0 |
| 2002-11-13 14:00:00 | IWM | ETF | 37.595 | 37.695 | 37.33 | 37.4 | 266600.0 |
| 2002-11-13 15:00:00 | IWM | ETF | 37.375 | 37.65 | 37.3 | 37.625 | 258600.0 |
| 2002-11-13 16:00:00 | IWM | ETF | 37.6 | 37.72 | 37.57 | 37.65 | 16200.0 |
| 2002-11-13 08:00:00 | DIA | ETF | 83.77 | 83.9 | 83.76 | 83.82 | 3300.0 |
| 2002-11-13 09:00:00 | DIA | ETF | 83.85 | 84.09 | 83.6 | 83.88 | 785500.0 |
| 2002-11-13 10:00:00 | DIA | ETF | 83.88 | 85.12 | 83.18 | 84.25 | 5423300.0 |
| 2002-11-13 11:00:00 | DIA | ETF | 84.25 | 85.24 | 84.08 | 85.05 | 1971400.0 |
| 2002-11-13 12:00:00 | DIA | ETF | 85.08 | 85.2 | 84.82 | 84.93 | 693400.0 |
| 2002-11-13 13:00:00 | DIA | ETF | 84.95 | 84.98 | 84.3 | 84.33 | 2069800.0 |
| 2002-11-13 14:00:00 | DIA | ETF | 84.31 | 84.6 | 83.46 | 83.5 | 2550500.0 |
| 2002-11-13 15:00:00 | DIA | ETF | 83.48 | 84.3 | 83.33 | 84.29 | 2413900.0 |
| 2002-11-13 16:00:00 | DIA | ETF | 84.24 | 84.7 | 84.1 | 84.1 | 298700.0 |
| 2002-11-13 17:00:00 | DIA | ETF | 84.3 | 84.45 | 84.25 | 84.45 | 19800.0 |
| 2002-11-13 09:00:00 | TLT | ETF | 88.45 | 88.49 | 88.4 | 88.4 | 6200.0 |
| 2002-11-13 10:00:00 | TLT | ETF | 88.47 | 88.69 | 87.96 | 88.2 | 9900.0 |
| 2002-11-13 11:00:00 | TLT | ETF | 88.13 | 88.3 | 88.13 | 88.18 | 11200.0 |
| 2002-11-13 12:00:00 | TLT | ETF | 88.2 | 88.3 | 88.2 | 88.26 | 4700.0 |
| 2002-11-13 13:00:00 | TLT | ETF | 88.41 | 88.44 | 88.3 | 88.44 | 11500.0 |
| 2002-11-13 14:00:00 | TLT | ETF | 88.5 | 88.6 | 88.46 | 88.6 | 10300.0 |
| 2002-11-13 15:00:00 | TLT | ETF | 88.65 | 88.69 | 88.46 | 88.6 | 49800.0 |
> showing 48 of 362 rows — these rows as CSV