PREVIEW / etf_1hour / 2002-09-24
file: by_date/etf_1hour/2002/2002-09-24.parquet size: 15 KB rows: 361
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-09-24 09:00:00 | SPY | ETF | 82.44 | 83.06 | 82.3 | 82.49 | 5745300.0 |
| 2002-09-24 10:00:00 | SPY | ETF | 82.54 | 83.65 | 82.47 | 82.84 | 10928000.0 |
| 2002-09-24 11:00:00 | SPY | ETF | 82.82 | 83.13 | 82.53 | 82.9 | 5503700.0 |
| 2002-09-24 12:00:00 | SPY | ETF | 82.89 | 82.98 | 82.11 | 82.46 | 5273100.0 |
| 2002-09-24 13:00:00 | SPY | ETF | 82.47 | 83.25 | 82.34 | 83.15 | 4265600.0 |
| 2002-09-24 14:00:00 | SPY | ETF | 83.12 | 83.19 | 82.0 | 82.74 | 15204700.0 |
| 2002-09-24 15:00:00 | SPY | ETF | 82.74 | 83.3 | 81.85 | 82.15 | 11973800.0 |
| 2002-09-24 16:00:00 | SPY | ETF | 82.15 | 82.5 | 82.08 | 82.31 | 1408700.0 |
| 2002-09-24 09:00:00 | QQQ | ETF | 20.68 | 21.08 | 20.65 | 20.89 | 10899100.0 |
| 2002-09-24 10:00:00 | QQQ | ETF | 20.93 | 21.41 | 20.91 | 21.11 | 14829800.0 |
| 2002-09-24 11:00:00 | QQQ | ETF | 21.1 | 21.2 | 20.96 | 21.12 | 6719400.0 |
| 2002-09-24 12:00:00 | QQQ | ETF | 21.13 | 21.17 | 20.87 | 20.97 | 6684500.0 |
| 2002-09-24 13:00:00 | QQQ | ETF | 20.98 | 21.23 | 20.91 | 21.17 | 5475600.0 |
| 2002-09-24 14:00:00 | QQQ | ETF | 21.18 | 21.23 | 20.82 | 21.19 | 21472400.0 |
| 2002-09-24 15:00:00 | QQQ | ETF | 21.19 | 21.45 | 20.88 | 20.98 | 18143600.0 |
| 2002-09-24 16:00:00 | QQQ | ETF | 20.99 | 21.05 | 20.95 | 21.03 | 727700.0 |
| 2002-09-24 09:00:00 | IWM | ETF | 35.345 | 35.52 | 35.25 | 35.4 | 394000.0 |
| 2002-09-24 10:00:00 | IWM | ETF | 35.4 | 35.93 | 35.4 | 35.68 | 290200.0 |
| 2002-09-24 11:00:00 | IWM | ETF | 35.84 | 35.84 | 35.45 | 35.45 | 122000.0 |
| 2002-09-24 12:00:00 | IWM | ETF | 35.64 | 35.64 | 35.435 | 35.5 | 95400.0 |
| 2002-09-24 13:00:00 | IWM | ETF | 35.53 | 35.73 | 35.485 | 35.66 | 160200.0 |
| 2002-09-24 14:00:00 | IWM | ETF | 35.715 | 35.8 | 35.41 | 35.605 | 365800.0 |
| 2002-09-24 15:00:00 | IWM | ETF | 35.645 | 35.745 | 35.355 | 35.51 | 212200.0 |
| 2002-09-24 16:00:00 | IWM | ETF | 35.5 | 35.5 | 35.375 | 35.375 | 45400.0 |
| 2002-09-24 09:00:00 | DIA | ETF | 77.71 | 78.8 | 77.5 | 77.57 | 2049400.0 |
| 2002-09-24 10:00:00 | DIA | ETF | 77.55 | 78.59 | 77.55 | 78.05 | 2566400.0 |
| 2002-09-24 11:00:00 | DIA | ETF | 77.93 | 78.12 | 77.54 | 77.89 | 1362800.0 |
| 2002-09-24 12:00:00 | DIA | ETF | 77.89 | 77.95 | 77.12 | 77.53 | 1534700.0 |
| 2002-09-24 13:00:00 | DIA | ETF | 77.52 | 78.07 | 77.3 | 77.96 | 1255700.0 |
| 2002-09-24 14:00:00 | DIA | ETF | 77.99 | 78.08 | 76.9 | 77.48 | 3132400.0 |
| 2002-09-24 15:00:00 | DIA | ETF | 77.53 | 78.01 | 76.6 | 76.92 | 2756600.0 |
| 2002-09-24 16:00:00 | DIA | ETF | 76.92 | 77.25 | 76.81 | 77.07 | 258600.0 |
| 2002-09-24 09:00:00 | TLT | ETF | 90.3 | 90.49 | 90.28 | 90.48 | 14700.0 |
| 2002-09-24 10:00:00 | TLT | ETF | 90.45 | 90.49 | 90.21 | 90.48 | 37200.0 |
| 2002-09-24 11:00:00 | TLT | ETF | 90.49 | 90.6 | 90.38 | 90.49 | 16800.0 |
| 2002-09-24 12:00:00 | TLT | ETF | 90.48 | 90.6 | 90.33 | 90.53 | 11400.0 |
| 2002-09-24 13:00:00 | TLT | ETF | 90.58 | 90.58 | 90.42 | 90.44 | 5300.0 |
| 2002-09-24 14:00:00 | TLT | ETF | 90.55 | 90.94 | 90.5 | 90.63 | 91800.0 |
| 2002-09-24 15:00:00 | TLT | ETF | 90.55 | 90.7 | 90.33 | 90.57 | 74600.0 |
| 2002-09-24 16:00:00 | TLT | ETF | 90.68 | 90.68 | 90.68 | 90.68 | 100.0 |
> showing 40 of 361 rows — these rows as CSV