PREVIEW / etf_1hour / 2002-08-22
file: by_date/etf_1hour/2002/2002-08-22.parquet size: 15 KB rows: 349
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-08-22 09:00:00 | SPY | ETF | 95.49 | 95.76 | 95.07 | 95.21 | 3853000.0 |
| 2002-08-22 10:00:00 | SPY | ETF | 95.22 | 96.69 | 95.21 | 96.35 | 7754000.0 |
| 2002-08-22 11:00:00 | SPY | ETF | 96.39 | 96.66 | 96.12 | 96.16 | 3060300.0 |
| 2002-08-22 12:00:00 | SPY | ETF | 96.14 | 96.36 | 95.85 | 96.15 | 2488100.0 |
| 2002-08-22 13:00:00 | SPY | ETF | 96.15 | 96.48 | 95.65 | 96.05 | 4332200.0 |
| 2002-08-22 14:00:00 | SPY | ETF | 96.04 | 96.65 | 95.85 | 96.55 | 2668200.0 |
| 2002-08-22 15:00:00 | SPY | ETF | 96.58 | 97.15 | 96.44 | 96.76 | 11145300.0 |
| 2002-08-22 16:00:00 | SPY | ETF | 96.79 | 96.85 | 96.63 | 96.68 | 765600.0 |
| 2002-08-22 09:00:00 | QQQ | ETF | 25.74 | 25.82 | 25.42 | 25.5 | 11392700.0 |
| 2002-08-22 10:00:00 | QQQ | ETF | 25.5 | 26.17 | 25.48 | 26.04 | 23193700.0 |
| 2002-08-22 11:00:00 | QQQ | ETF | 26.04 | 26.09 | 25.78 | 25.8 | 9107900.0 |
| 2002-08-22 12:00:00 | QQQ | ETF | 25.8 | 26.04 | 25.75 | 25.97 | 6369600.0 |
| 2002-08-22 13:00:00 | QQQ | ETF | 25.96 | 26.08 | 25.76 | 25.88 | 8183100.0 |
| 2002-08-22 14:00:00 | QQQ | ETF | 25.9 | 26.09 | 25.78 | 26.09 | 5492500.0 |
| 2002-08-22 15:00:00 | QQQ | ETF | 26.08 | 26.21 | 25.98 | 26.1 | 11800700.0 |
| 2002-08-22 16:00:00 | QQQ | ETF | 26.1 | 26.16 | 26.05 | 26.16 | 998000.0 |
| 2002-08-22 09:00:00 | IWM | ETF | 40.6 | 40.6 | 40.325 | 40.44 | 235800.0 |
| 2002-08-22 10:00:00 | IWM | ETF | 40.46 | 40.81 | 40.46 | 40.71 | 522600.0 |
| 2002-08-22 11:00:00 | IWM | ETF | 40.71 | 40.775 | 40.63 | 40.695 | 233600.0 |
| 2002-08-22 12:00:00 | IWM | ETF | 40.63 | 40.685 | 40.57 | 40.68 | 93800.0 |
| 2002-08-22 13:00:00 | IWM | ETF | 40.63 | 40.725 | 40.54 | 40.595 | 71000.0 |
| 2002-08-22 14:00:00 | IWM | ETF | 40.625 | 40.825 | 40.625 | 40.825 | 109200.0 |
| 2002-08-22 15:00:00 | IWM | ETF | 40.815 | 41.125 | 40.815 | 40.86 | 520200.0 |
| 2002-08-22 16:00:00 | IWM | ETF | 40.875 | 40.9 | 40.875 | 40.9 | 12200.0 |
| 2002-08-22 09:00:00 | DIA | ETF | 89.75 | 90.01 | 89.35 | 89.52 | 1319000.0 |
| 2002-08-22 10:00:00 | DIA | ETF | 89.52 | 90.73 | 89.4 | 90.33 | 2454400.0 |
| 2002-08-22 11:00:00 | DIA | ETF | 90.34 | 90.61 | 90.13 | 90.22 | 956800.0 |
| 2002-08-22 12:00:00 | DIA | ETF | 90.2 | 90.43 | 89.95 | 90.26 | 676700.0 |
| 2002-08-22 13:00:00 | DIA | ETF | 90.3 | 90.4 | 89.56 | 89.99 | 1117500.0 |
| 2002-08-22 14:00:00 | DIA | ETF | 90.0 | 90.62 | 89.79 | 90.47 | 590200.0 |
| 2002-08-22 15:00:00 | DIA | ETF | 90.5 | 91.0 | 90.37 | 90.69 | 1671900.0 |
| 2002-08-22 16:00:00 | DIA | ETF | 90.68 | 90.7 | 90.51 | 90.63 | 67800.0 |
| 2002-08-22 09:00:00 | TLT | ETF | 85.55 | 85.55 | 85.4 | 85.41 | 7700.0 |
| 2002-08-22 10:00:00 | TLT | ETF | 85.4 | 85.4 | 85.16 | 85.16 | 3400.0 |
| 2002-08-22 11:00:00 | TLT | ETF | 85.17 | 85.27 | 85.1 | 85.16 | 2900.0 |
| 2002-08-22 12:00:00 | TLT | ETF | 85.18 | 85.3 | 85.18 | 85.24 | 3000.0 |
| 2002-08-22 13:00:00 | TLT | ETF | 85.15 | 85.37 | 85.15 | 85.25 | 10000.0 |
| 2002-08-22 14:00:00 | TLT | ETF | 85.34 | 85.34 | 85.12 | 85.12 | 2800.0 |
| 2002-08-22 15:00:00 | TLT | ETF | 85.09 | 85.1 | 85.06 | 85.06 | 4600.0 |
> showing 39 of 349 rows — these rows as CSV