PREVIEW / etf_1hour / 2002-07-16
file: by_date/etf_1hour/2002/2002-07-16.parquet size: 14 KB rows: 313
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-07-16 09:00:00 | SPY | ETF | 91.12 | 91.83 | 90.7 | 91.09 | 5466700.0 |
| 2002-07-16 10:00:00 | SPY | ETF | 91.09 | 91.49 | 89.87 | 91.19 | 12250400.0 |
| 2002-07-16 11:00:00 | SPY | ETF | 91.19 | 92.28 | 91.0 | 91.92 | 9797100.0 |
| 2002-07-16 12:00:00 | SPY | ETF | 91.9 | 92.25 | 91.4 | 92.04 | 4485600.0 |
| 2002-07-16 13:00:00 | SPY | ETF | 92.03 | 92.38 | 91.2 | 91.34 | 3852600.0 |
| 2002-07-16 14:00:00 | SPY | ETF | 91.38 | 91.95 | 91.1 | 91.65 | 5027800.0 |
| 2002-07-16 15:00:00 | SPY | ETF | 91.66 | 91.7 | 90.03 | 90.57 | 7659200.0 |
| 2002-07-16 16:00:00 | SPY | ETF | 90.45 | 90.72 | 90.36 | 90.56 | 1271800.0 |
| 2002-07-16 09:00:00 | QQQ | ETF | 25.25 | 25.55 | 25.2 | 25.3 | 18983800.0 |
| 2002-07-16 10:00:00 | QQQ | ETF | 25.28 | 25.8 | 25.05 | 25.76 | 26033100.0 |
| 2002-07-16 11:00:00 | QQQ | ETF | 25.79 | 26.02 | 25.47 | 25.87 | 26575500.0 |
| 2002-07-16 12:00:00 | QQQ | ETF | 25.87 | 26.01 | 25.73 | 25.92 | 14289500.0 |
| 2002-07-16 13:00:00 | QQQ | ETF | 25.95 | 25.99 | 25.34 | 25.38 | 17447400.0 |
| 2002-07-16 14:00:00 | QQQ | ETF | 25.39 | 25.65 | 25.28 | 25.47 | 12466100.0 |
| 2002-07-16 15:00:00 | QQQ | ETF | 25.46 | 25.49 | 24.9 | 25.17 | 21703300.0 |
| 2002-07-16 16:00:00 | QQQ | ETF | 25.17 | 25.3 | 25.1 | 25.19 | 1265900.0 |
| 2002-07-16 09:00:00 | IWM | ETF | 40.475 | 40.75 | 40.475 | 40.53 | 113000.0 |
| 2002-07-16 10:00:00 | IWM | ETF | 40.605 | 40.825 | 40.3 | 40.825 | 346600.0 |
| 2002-07-16 11:00:00 | IWM | ETF | 40.765 | 41.065 | 40.765 | 41.045 | 902600.0 |
| 2002-07-16 12:00:00 | IWM | ETF | 41.085 | 41.215 | 41.025 | 41.155 | 134200.0 |
| 2002-07-16 13:00:00 | IWM | ETF | 41.205 | 41.25 | 40.865 | 40.865 | 233800.0 |
| 2002-07-16 14:00:00 | IWM | ETF | 40.875 | 41.01 | 40.84 | 40.925 | 99800.0 |
| 2002-07-16 15:00:00 | IWM | ETF | 40.9 | 40.955 | 40.22 | 40.57 | 586400.0 |
| 2002-07-16 16:00:00 | IWM | ETF | 40.475 | 40.5 | 40.475 | 40.5 | 30200.0 |
| 2002-07-16 09:00:00 | DIA | ETF | 85.5 | 86.0 | 84.9 | 85.29 | 2225900.0 |
| 2002-07-16 10:00:00 | DIA | ETF | 85.32 | 85.64 | 84.16 | 85.5 | 2422700.0 |
| 2002-07-16 11:00:00 | DIA | ETF | 85.5 | 86.56 | 85.3 | 86.25 | 1566300.0 |
| 2002-07-16 12:00:00 | DIA | ETF | 86.23 | 86.5 | 85.63 | 86.35 | 1083300.0 |
| 2002-07-16 13:00:00 | DIA | ETF | 86.21 | 86.5 | 85.45 | 85.63 | 1293700.0 |
| 2002-07-16 14:00:00 | DIA | ETF | 85.7 | 86.36 | 85.4 | 86.07 | 827400.0 |
| 2002-07-16 15:00:00 | DIA | ETF | 86.08 | 86.08 | 84.4 | 84.88 | 1881300.0 |
| 2002-07-16 16:00:00 | DIA | ETF | 84.96 | 85.11 | 84.85 | 85.05 | 80000.0 |
> showing 32 of 313 rows — these rows as CSV