PREVIEW / etf_1hour / 2002-09-05
file: by_date/etf_1hour/2002/2002-09-05.parquet size: 15 KB rows: 335
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-05 09:00:00 | SPY | ETF | 88.49 | 88.6 | 88.05 | 88.2 | 5509700.0 |
| 2002-09-05 10:00:00 | SPY | ETF | 88.25 | 88.5 | 87.5 | 88.3 | 13003200.0 |
| 2002-09-05 11:00:00 | SPY | ETF | 88.24 | 89.43 | 88.23 | 88.8 | 7721400.0 |
| 2002-09-05 12:00:00 | SPY | ETF | 88.76 | 88.93 | 88.35 | 88.87 | 3898500.0 |
| 2002-09-05 13:00:00 | SPY | ETF | 88.87 | 89.35 | 88.67 | 88.71 | 3461600.0 |
| 2002-09-05 14:00:00 | SPY | ETF | 88.73 | 89.09 | 88.1 | 88.39 | 7045300.0 |
| 2002-09-05 15:00:00 | SPY | ETF | 88.41 | 88.73 | 88.22 | 88.46 | 6363800.0 |
| 2002-09-05 16:00:00 | SPY | ETF | 88.47 | 88.88 | 88.43 | 88.78 | 1207800.0 |
| 2002-09-05 09:00:00 | QQQ | ETF | 22.4 | 22.42 | 22.2 | 22.22 | 9208300.0 |
| 2002-09-05 10:00:00 | QQQ | ETF | 22.25 | 22.36 | 21.96 | 22.12 | 19784700.0 |
| 2002-09-05 11:00:00 | QQQ | ETF | 22.12 | 22.36 | 22.1 | 22.17 | 12962800.0 |
| 2002-09-05 12:00:00 | QQQ | ETF | 22.15 | 22.22 | 22.02 | 22.15 | 5650600.0 |
| 2002-09-05 13:00:00 | QQQ | ETF | 22.15 | 22.29 | 22.04 | 22.04 | 7239300.0 |
| 2002-09-05 14:00:00 | QQQ | ETF | 22.06 | 22.19 | 21.93 | 22.01 | 8629000.0 |
| 2002-09-05 15:00:00 | QQQ | ETF | 22.01 | 22.1 | 21.96 | 21.99 | 17015200.0 |
| 2002-09-05 16:00:00 | QQQ | ETF | 21.99 | 22.19 | 21.96 | 22.17 | 1107100.0 |
| 2002-09-05 09:00:00 | IWM | ETF | 38.125 | 38.43 | 38.0 | 38.28 | 129200.0 |
| 2002-09-05 10:00:00 | IWM | ETF | 38.28 | 38.355 | 38.08 | 38.355 | 329600.0 |
| 2002-09-05 11:00:00 | IWM | ETF | 38.345 | 38.555 | 38.34 | 38.4 | 342400.0 |
| 2002-09-05 12:00:00 | IWM | ETF | 38.4 | 38.5 | 38.34 | 38.405 | 110000.0 |
| 2002-09-05 13:00:00 | IWM | ETF | 38.37 | 38.5 | 38.3 | 38.305 | 133600.0 |
| 2002-09-05 14:00:00 | IWM | ETF | 38.305 | 38.37 | 38.015 | 38.04 | 243200.0 |
| 2002-09-05 15:00:00 | IWM | ETF | 38.015 | 38.2 | 38.015 | 38.025 | 172000.0 |
| 2002-09-05 16:00:00 | IWM | ETF | 38.0 | 38.0 | 37.9 | 37.9 | 14200.0 |
| 2002-09-05 09:00:00 | DIA | ETF | 83.13 | 83.25 | 82.75 | 83.05 | 1545400.0 |
| 2002-09-05 10:00:00 | DIA | ETF | 83.05 | 83.22 | 82.26 | 82.95 | 2984800.0 |
| 2002-09-05 11:00:00 | DIA | ETF | 82.88 | 83.92 | 82.88 | 83.38 | 2709900.0 |
| 2002-09-05 12:00:00 | DIA | ETF | 83.38 | 83.58 | 83.05 | 83.49 | 856400.0 |
| 2002-09-05 13:00:00 | DIA | ETF | 83.5 | 83.95 | 83.3 | 83.34 | 1441700.0 |
| 2002-09-05 14:00:00 | DIA | ETF | 83.32 | 83.7 | 82.7 | 83.01 | 1900600.0 |
| 2002-09-05 15:00:00 | DIA | ETF | 83.01 | 83.35 | 82.81 | 83.06 | 1230100.0 |
| 2002-09-05 16:00:00 | DIA | ETF | 83.08 | 83.4 | 83.04 | 83.4 | 210100.0 |
| 2002-09-05 09:00:00 | TLT | ETF | 88.57 | 88.57 | 87.38 | 88.4 | 12100.0 |
| 2002-09-05 10:00:00 | TLT | ETF | 88.52 | 88.65 | 88.04 | 88.1 | 29900.0 |
| 2002-09-05 11:00:00 | TLT | ETF | 88.1 | 88.16 | 87.91 | 88.07 | 14200.0 |
| 2002-09-05 12:00:00 | TLT | ETF | 88.2 | 88.24 | 88.12 | 88.24 | 10800.0 |
| 2002-09-05 13:00:00 | TLT | ETF | 88.24 | 88.45 | 88.24 | 88.36 | 506800.0 |
| 2002-09-05 14:00:00 | TLT | ETF | 88.44 | 88.64 | 88.44 | 88.55 | 24200.0 |
| 2002-09-05 15:00:00 | TLT | ETF | 88.55 | 88.57 | 88.4 | 88.52 | 50200.0 |
| 2002-09-05 16:00:00 | TLT | ETF | 88.5 | 88.5 | 88.5 | 88.5 | 200.0 |
> showing 40 of 335 rows — these rows as CSV