PREVIEW / etf_1hour / 2002-06-10
file: by_date/etf_1hour/2002/2002-06-10.parquet size: 14 KB rows: 301
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-06-10 09:00:00 | SPY | ETF | 103.24 | 103.5 | 103.1 | 103.36 | 2082000.0 |
| 2002-06-10 10:00:00 | SPY | ETF | 103.3 | 104.05 | 103.02 | 103.71 | 6544000.0 |
| 2002-06-10 11:00:00 | SPY | ETF | 103.71 | 103.73 | 103.26 | 103.55 | 843000.0 |
| 2002-06-10 12:00:00 | SPY | ETF | 103.59 | 104.24 | 103.44 | 104.2 | 1285800.0 |
| 2002-06-10 13:00:00 | SPY | ETF | 104.2 | 104.24 | 103.78 | 103.88 | 1225100.0 |
| 2002-06-10 14:00:00 | SPY | ETF | 103.88 | 104.4 | 103.78 | 104.4 | 1376500.0 |
| 2002-06-10 15:00:00 | SPY | ETF | 104.4 | 104.46 | 103.42 | 103.56 | 3852100.0 |
| 2002-06-10 16:00:00 | SPY | ETF | 103.56 | 103.8 | 103.34 | 103.73 | 942500.0 |
| 2002-06-10 17:00:00 | SPY | ETF | 103.73 | 103.73 | 103.73 | 103.73 | 500.0 |
| 2002-06-10 18:00:00 | SPY | ETF | 103.69 | 103.72 | 103.61 | 103.61 | 300.0 |
| 2002-06-10 09:00:00 | QQQ | ETF | 28.36 | 28.49 | 28.18 | 28.33 | 10683800.0 |
| 2002-06-10 10:00:00 | QQQ | ETF | 28.35 | 28.75 | 28.26 | 28.59 | 19446300.0 |
| 2002-06-10 11:00:00 | QQQ | ETF | 28.6 | 28.62 | 28.35 | 28.46 | 6240700.0 |
| 2002-06-10 12:00:00 | QQQ | ETF | 28.46 | 28.75 | 28.37 | 28.72 | 5633500.0 |
| 2002-06-10 13:00:00 | QQQ | ETF | 28.7 | 28.74 | 28.5 | 28.54 | 5712200.0 |
| 2002-06-10 14:00:00 | QQQ | ETF | 28.54 | 28.73 | 28.45 | 28.7 | 7671300.0 |
| 2002-06-10 15:00:00 | QQQ | ETF | 28.7 | 28.74 | 28.14 | 28.27 | 15477600.0 |
| 2002-06-10 16:00:00 | QQQ | ETF | 28.24 | 28.7 | 28.22 | 28.3 | 1151300.0 |
| 2002-06-10 17:00:00 | QQQ | ETF | 28.29 | 28.3 | 28.24 | 28.27 | 77200.0 |
| 2002-06-10 18:00:00 | QQQ | ETF | 28.24 | 28.26 | 28.24 | 28.25 | 8900.0 |
| 2002-06-10 09:00:00 | IWM | ETF | 46.9 | 47.015 | 46.775 | 46.995 | 369600.0 |
| 2002-06-10 10:00:00 | IWM | ETF | 46.985 | 47.225 | 46.875 | 47.01 | 402600.0 |
| 2002-06-10 11:00:00 | IWM | ETF | 47.035 | 47.065 | 46.89 | 46.985 | 406800.0 |
| 2002-06-10 12:00:00 | IWM | ETF | 46.985 | 47.095 | 46.88 | 47.095 | 150600.0 |
| 2002-06-10 13:00:00 | IWM | ETF | 47.085 | 47.125 | 47.0 | 47.005 | 339200.0 |
| 2002-06-10 14:00:00 | IWM | ETF | 47.01 | 47.135 | 46.975 | 47.135 | 184200.0 |
| 2002-06-10 15:00:00 | IWM | ETF | 47.135 | 47.17 | 46.6 | 46.725 | 323200.0 |
| 2002-06-10 16:00:00 | IWM | ETF | 46.745 | 46.75 | 46.745 | 46.75 | 23000.0 |
| 2002-06-10 09:00:00 | DIA | ETF | 96.25 | 96.26 | 95.94 | 96.12 | 450500.0 |
| 2002-06-10 10:00:00 | DIA | ETF | 96.1 | 96.71 | 95.74 | 96.4 | 1020900.0 |
| 2002-06-10 11:00:00 | DIA | ETF | 96.42 | 96.47 | 96.09 | 96.36 | 279800.0 |
| 2002-06-10 12:00:00 | DIA | ETF | 96.36 | 96.95 | 96.23 | 96.93 | 338800.0 |
| 2002-06-10 13:00:00 | DIA | ETF | 96.95 | 96.97 | 96.65 | 96.72 | 306800.0 |
| 2002-06-10 14:00:00 | DIA | ETF | 96.75 | 97.25 | 96.71 | 97.18 | 200500.0 |
| 2002-06-10 15:00:00 | DIA | ETF | 97.19 | 97.39 | 96.5 | 96.58 | 901800.0 |
| 2002-06-10 16:00:00 | DIA | ETF | 96.58 | 96.76 | 96.48 | 96.48 | 290900.0 |
| 2002-06-10 18:00:00 | DIA | ETF | 96.55 | 96.55 | 96.55 | 96.55 | 100.0 |
> showing 37 of 301 rows — these rows as CSV