PREVIEW / etf_1hour / 2002-09-25
file: by_date/etf_1hour/2002/2002-09-25.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-09-25 09:00:00 | SPY | ETF | 83.37 | 83.61 | 82.87 | 83.0 | 6146400.0 |
| 2002-09-25 10:00:00 | SPY | ETF | 83.01 | 83.14 | 82.26 | 82.5 | 7406600.0 |
| 2002-09-25 11:00:00 | SPY | ETF | 82.52 | 83.11 | 82.04 | 82.87 | 7624000.0 |
| 2002-09-25 12:00:00 | SPY | ETF | 82.86 | 83.43 | 82.83 | 83.25 | 3835200.0 |
| 2002-09-25 13:00:00 | SPY | ETF | 83.26 | 84.17 | 83.04 | 83.95 | 9076000.0 |
| 2002-09-25 14:00:00 | SPY | ETF | 83.95 | 84.77 | 83.88 | 84.31 | 10233700.0 |
| 2002-09-25 15:00:00 | SPY | ETF | 84.3 | 84.65 | 83.9 | 84.11 | 8983100.0 |
| 2002-09-25 16:00:00 | SPY | ETF | 84.12 | 84.53 | 84.05 | 84.35 | 1948600.0 |
| 2002-09-25 09:00:00 | QQQ | ETF | 21.35 | 21.49 | 21.23 | 21.3 | 13885400.0 |
| 2002-09-25 10:00:00 | QQQ | ETF | 21.3 | 21.42 | 21.14 | 21.25 | 14197000.0 |
| 2002-09-25 11:00:00 | QQQ | ETF | 21.24 | 21.46 | 21.1 | 21.35 | 16482400.0 |
| 2002-09-25 12:00:00 | QQQ | ETF | 21.36 | 21.59 | 21.35 | 21.54 | 9368800.0 |
| 2002-09-25 13:00:00 | QQQ | ETF | 21.53 | 21.9 | 21.48 | 21.8 | 14366200.0 |
| 2002-09-25 14:00:00 | QQQ | ETF | 21.79 | 22.0 | 21.75 | 21.86 | 11786500.0 |
| 2002-09-25 15:00:00 | QQQ | ETF | 21.86 | 22.04 | 21.76 | 21.87 | 13415700.0 |
| 2002-09-25 16:00:00 | QQQ | ETF | 21.88 | 21.9 | 21.82 | 21.87 | 1027900.0 |
| 2002-09-25 09:00:00 | IWM | ETF | 35.625 | 35.91 | 35.605 | 35.785 | 293600.0 |
| 2002-09-25 10:00:00 | IWM | ETF | 35.7 | 35.87 | 35.615 | 35.71 | 415800.0 |
| 2002-09-25 11:00:00 | IWM | ETF | 35.64 | 35.755 | 35.495 | 35.725 | 427600.0 |
| 2002-09-25 12:00:00 | IWM | ETF | 35.725 | 35.91 | 35.685 | 35.9 | 170200.0 |
| 2002-09-25 13:00:00 | IWM | ETF | 35.9 | 36.255 | 35.875 | 36.21 | 201400.0 |
| 2002-09-25 14:00:00 | IWM | ETF | 36.21 | 36.395 | 36.19 | 36.275 | 372000.0 |
| 2002-09-25 15:00:00 | IWM | ETF | 36.265 | 36.345 | 36.12 | 36.345 | 439600.0 |
| 2002-09-25 16:00:00 | IWM | ETF | 36.4 | 36.45 | 36.36 | 36.45 | 272400.0 |
| 2002-09-25 09:00:00 | DIA | ETF | 78.05 | 78.38 | 77.6 | 77.77 | 1504400.0 |
| 2002-09-25 10:00:00 | DIA | ETF | 77.7 | 77.81 | 76.95 | 77.19 | 2237200.0 |
| 2002-09-25 11:00:00 | DIA | ETF | 77.16 | 77.75 | 76.69 | 77.62 | 2022700.0 |
| 2002-09-25 12:00:00 | DIA | ETF | 77.62 | 78.0 | 77.55 | 77.82 | 1051600.0 |
| 2002-09-25 13:00:00 | DIA | ETF | 77.81 | 78.65 | 77.67 | 78.44 | 1451800.0 |
| 2002-09-25 14:00:00 | DIA | ETF | 78.46 | 79.09 | 78.33 | 78.7 | 1612400.0 |
| 2002-09-25 15:00:00 | DIA | ETF | 78.65 | 78.99 | 78.25 | 78.45 | 1654900.0 |
| 2002-09-25 16:00:00 | DIA | ETF | 78.45 | 78.73 | 78.4 | 78.66 | 41800.0 |
| 2002-09-25 09:00:00 | TLT | ETF | 90.1 | 90.14 | 90.0 | 90.1 | 13300.0 |
| 2002-09-25 10:00:00 | TLT | ETF | 90.15 | 90.24 | 90.14 | 90.24 | 3800.0 |
| 2002-09-25 11:00:00 | TLT | ETF | 90.24 | 90.36 | 90.04 | 90.26 | 18300.0 |
| 2002-09-25 12:00:00 | TLT | ETF | 90.1 | 90.18 | 89.92 | 90.02 | 26300.0 |
| 2002-09-25 13:00:00 | TLT | ETF | 89.96 | 89.96 | 89.7 | 89.71 | 36700.0 |
| 2002-09-25 14:00:00 | TLT | ETF | 89.6 | 89.6 | 89.26 | 89.4 | 19000.0 |
| 2002-09-25 15:00:00 | TLT | ETF | 89.47 | 89.58 | 89.41 | 89.58 | 9800.0 |
> showing 39 of 349 rows — these rows as CSV