PREVIEW / etf_1hour / 2002-04-09
file: by_date/etf_1hour/2002/2002-04-09.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-04-09 09:00:00 | SPY | ETF | 113.18 | 113.18 | 112.83 | 113.09 | 3027900.0 |
| 2002-04-09 10:00:00 | SPY | ETF | 113.07 | 113.17 | 112.51 | 112.67 | 1912400.0 |
| 2002-04-09 11:00:00 | SPY | ETF | 112.66 | 112.74 | 112.37 | 112.58 | 1464200.0 |
| 2002-04-09 12:00:00 | SPY | ETF | 112.56 | 112.77 | 112.39 | 112.59 | 1034900.0 |
| 2002-04-09 13:00:00 | SPY | ETF | 112.59 | 112.6 | 112.18 | 112.21 | 1119600.0 |
| 2002-04-09 14:00:00 | SPY | ETF | 112.21 | 112.68 | 112.1 | 112.5 | 1653200.0 |
| 2002-04-09 15:00:00 | SPY | ETF | 112.51 | 112.54 | 111.93 | 112.07 | 2524800.0 |
| 2002-04-09 16:00:00 | SPY | ETF | 112.05 | 112.22 | 112.02 | 112.17 | 2058200.0 |
| 2002-04-09 17:00:00 | SPY | ETF | 112.14 | 112.14 | 112.14 | 112.14 | 500.0 |
| 2002-04-09 09:00:00 | QQQ | ETF | 34.78 | 34.98 | 34.63 | 34.68 | 9974200.0 |
| 2002-04-09 10:00:00 | QQQ | ETF | 34.68 | 34.71 | 34.29 | 34.37 | 13331900.0 |
| 2002-04-09 11:00:00 | QQQ | ETF | 34.38 | 34.44 | 34.1 | 34.11 | 9115800.0 |
| 2002-04-09 12:00:00 | QQQ | ETF | 34.15 | 34.19 | 33.93 | 33.93 | 5661300.0 |
| 2002-04-09 13:00:00 | QQQ | ETF | 33.94 | 34.0 | 33.71 | 33.72 | 9486700.0 |
| 2002-04-09 14:00:00 | QQQ | ETF | 33.72 | 34.09 | 33.66 | 33.94 | 11521300.0 |
| 2002-04-09 15:00:00 | QQQ | ETF | 33.91 | 33.95 | 33.49 | 33.5 | 13898600.0 |
| 2002-04-09 16:00:00 | QQQ | ETF | 33.52 | 33.68 | 33.49 | 33.59 | 4091900.0 |
| 2002-04-09 17:00:00 | QQQ | ETF | 33.58 | 33.64 | 33.55 | 33.57 | 283300.0 |
| 2002-04-09 18:00:00 | QQQ | ETF | 33.57 | 33.64 | 33.55 | 33.55 | 25300.0 |
| 2002-04-09 09:00:00 | IWM | ETF | 50.17 | 50.27 | 50.02 | 50.25 | 208000.0 |
| 2002-04-09 10:00:00 | IWM | ETF | 50.27 | 50.345 | 50.11 | 50.29 | 49000.0 |
| 2002-04-09 11:00:00 | IWM | ETF | 50.345 | 50.345 | 50.17 | 50.25 | 18400.0 |
| 2002-04-09 12:00:00 | IWM | ETF | 50.225 | 50.325 | 50.225 | 50.295 | 245000.0 |
| 2002-04-09 13:00:00 | IWM | ETF | 50.295 | 50.295 | 50.125 | 50.125 | 98000.0 |
| 2002-04-09 14:00:00 | IWM | ETF | 50.125 | 50.27 | 50.125 | 50.25 | 61000.0 |
| 2002-04-09 15:00:00 | IWM | ETF | 50.25 | 50.25 | 49.965 | 49.985 | 248000.0 |
| 2002-04-09 16:00:00 | IWM | ETF | 50.575 | 50.575 | 50.575 | 50.575 | 5200.0 |
| 2002-04-09 09:00:00 | DIA | ETF | 103.17 | 103.22 | 102.76 | 103.15 | 1425100.0 |
| 2002-04-09 10:00:00 | DIA | ETF | 103.15 | 103.2 | 102.66 | 102.82 | 965800.0 |
| 2002-04-09 11:00:00 | DIA | ETF | 102.82 | 102.94 | 102.62 | 102.78 | 299100.0 |
| 2002-04-09 12:00:00 | DIA | ETF | 102.73 | 103.07 | 102.65 | 102.91 | 218600.0 |
| 2002-04-09 13:00:00 | DIA | ETF | 102.96 | 102.97 | 102.44 | 102.46 | 799100.0 |
| 2002-04-09 14:00:00 | DIA | ETF | 102.48 | 102.85 | 102.35 | 102.62 | 1941400.0 |
| 2002-04-09 15:00:00 | DIA | ETF | 102.64 | 102.64 | 102.06 | 102.16 | 1766000.0 |
| 2002-04-09 16:00:00 | DIA | ETF | 102.22 | 102.34 | 102.16 | 102.34 | 86400.0 |
| 2002-04-09 18:00:00 | DIA | ETF | 102.4 | 102.4 | 102.4 | 102.4 | 100.0 |
> showing 36 of 301 rows — these rows as CSV