PREVIEW / etf_1hour / 2002-11-29
file: by_date/etf_1hour/2002/2002-11-29.parquet size: 12 KB rows: 226
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-29 08:00:00 | SPY | ETF | 94.52 | 94.75 | 94.48 | 94.69 | 17100.0 |
| 2002-11-29 09:00:00 | SPY | ETF | 94.67 | 94.74 | 94.34 | 94.55 | 2027600.0 |
| 2002-11-29 10:00:00 | SPY | ETF | 94.51 | 94.56 | 94.05 | 94.42 | 2716400.0 |
| 2002-11-29 11:00:00 | SPY | ETF | 94.4 | 94.73 | 94.3 | 94.71 | 5025400.0 |
| 2002-11-29 12:00:00 | SPY | ETF | 94.7 | 94.75 | 93.96 | 94.07 | 5000300.0 |
| 2002-11-29 13:00:00 | SPY | ETF | 93.99 | 94.15 | 93.77 | 94.11 | 1736300.0 |
| 2002-11-29 14:00:00 | SPY | ETF | 93.98 | 93.98 | 93.98 | 93.98 | 200.0 |
| 2002-11-29 08:00:00 | QQQ | ETF | 28.06 | 28.22 | 28.06 | 28.2 | 27500.0 |
| 2002-11-29 09:00:00 | QQQ | ETF | 28.17 | 28.2 | 28.07 | 28.16 | 4200900.0 |
| 2002-11-29 10:00:00 | QQQ | ETF | 28.16 | 28.18 | 27.76 | 27.89 | 9112400.0 |
| 2002-11-29 11:00:00 | QQQ | ETF | 27.89 | 28.04 | 27.82 | 28.03 | 3591800.0 |
| 2002-11-29 12:00:00 | QQQ | ETF | 28.02 | 28.06 | 27.75 | 27.78 | 9230800.0 |
| 2002-11-29 13:00:00 | QQQ | ETF | 27.79 | 27.81 | 27.46 | 27.63 | 1312100.0 |
| 2002-11-29 14:00:00 | QQQ | ETF | 27.6 | 27.83 | 27.6 | 27.72 | 72200.0 |
| 2002-11-29 09:00:00 | IWM | ETF | 40.925 | 41.115 | 40.925 | 41.025 | 163800.0 |
| 2002-11-29 10:00:00 | IWM | ETF | 41.06 | 41.06 | 40.495 | 40.695 | 277600.0 |
| 2002-11-29 11:00:00 | IWM | ETF | 40.665 | 40.925 | 40.65 | 40.925 | 43800.0 |
| 2002-11-29 12:00:00 | IWM | ETF | 40.9 | 40.96 | 40.4 | 40.4 | 400400.0 |
| 2002-11-29 13:00:00 | IWM | ETF | 40.405 | 40.405 | 40.4 | 40.405 | 27600.0 |
| 2002-11-29 08:00:00 | DIA | ETF | 89.65 | 89.65 | 89.63 | 89.63 | 700.0 |
| 2002-11-29 09:00:00 | DIA | ETF | 89.68 | 89.8 | 89.3 | 89.62 | 683700.0 |
| 2002-11-29 10:00:00 | DIA | ETF | 89.58 | 89.62 | 89.21 | 89.53 | 621100.0 |
| 2002-11-29 11:00:00 | DIA | ETF | 89.52 | 89.63 | 89.36 | 89.61 | 379400.0 |
| 2002-11-29 12:00:00 | DIA | ETF | 89.6 | 89.68 | 89.08 | 89.09 | 959600.0 |
| 2002-11-29 13:00:00 | DIA | ETF | 89.15 | 89.28 | 88.85 | 89.2 | 60200.0 |
| 2002-11-29 14:00:00 | DIA | ETF | 88.82 | 88.9 | 88.82 | 88.9 | 300.0 |
| 2002-11-29 09:00:00 | TLT | ETF | 85.16 | 85.26 | 85.16 | 85.18 | 2100.0 |
| 2002-11-29 10:00:00 | TLT | ETF | 85.14 | 85.5 | 85.14 | 85.5 | 20800.0 |
| 2002-11-29 11:00:00 | TLT | ETF | 85.28 | 85.28 | 85.27 | 85.27 | 400.0 |
| 2002-11-29 12:00:00 | TLT | ETF | 85.4 | 85.63 | 85.4 | 85.55 | 6700.0 |
> showing 30 of 226 rows — these rows as CSV