PREVIEW / etf_1hour / 2002-01-03
file: by_date/etf_1hour/2002/2002-01-03.parquet size: 13 KB rows: 282
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-01-03 09:00:00 | SPY | ETF | 115.65 | 116.3 | 115.54 | 116.25 | 2700800.0 |
| 2002-01-03 10:00:00 | SPY | ETF | 116.2 | 116.38 | 115.9 | 116.31 | 3950500.0 |
| 2002-01-03 11:00:00 | SPY | ETF | 116.25 | 116.49 | 116.06 | 116.18 | 1318400.0 |
| 2002-01-03 12:00:00 | SPY | ETF | 116.19 | 116.24 | 115.8 | 116.18 | 1143300.0 |
| 2002-01-03 13:00:00 | SPY | ETF | 116.21 | 116.35 | 116.03 | 116.14 | 1038900.0 |
| 2002-01-03 14:00:00 | SPY | ETF | 116.16 | 116.3 | 115.92 | 116.29 | 1221600.0 |
| 2002-01-03 15:00:00 | SPY | ETF | 116.25 | 116.83 | 116.11 | 116.76 | 3043200.0 |
| 2002-01-03 16:00:00 | SPY | ETF | 116.82 | 116.95 | 116.72 | 116.8 | 1294400.0 |
| 2002-01-03 17:00:00 | SPY | ETF | 116.78 | 116.84 | 116.77 | 116.77 | 2600.0 |
| 2002-01-03 18:00:00 | SPY | ETF | 116.8 | 116.94 | 116.73 | 116.78 | 11300.0 |
| 2002-01-03 09:00:00 | QQQ | ETF | 40.31 | 40.95 | 40.26 | 40.9 | 11200200.0 |
| 2002-01-03 10:00:00 | QQQ | ETF | 40.92 | 41.21 | 40.83 | 41.2 | 18016000.0 |
| 2002-01-03 11:00:00 | QQQ | ETF | 41.18 | 41.34 | 41.07 | 41.2 | 11395100.0 |
| 2002-01-03 12:00:00 | QQQ | ETF | 41.2 | 41.31 | 40.95 | 41.27 | 6943900.0 |
| 2002-01-03 13:00:00 | QQQ | ETF | 41.28 | 41.3 | 41.07 | 41.22 | 5897000.0 |
| 2002-01-03 14:00:00 | QQQ | ETF | 41.27 | 41.34 | 41.02 | 41.27 | 9540500.0 |
| 2002-01-03 15:00:00 | QQQ | ETF | 41.27 | 41.54 | 41.15 | 41.44 | 16330000.0 |
| 2002-01-03 16:00:00 | QQQ | ETF | 41.45 | 41.55 | 40.9 | 41.49 | 4688900.0 |
| 2002-01-03 17:00:00 | QQQ | ETF | 41.49 | 41.53 | 41.44 | 41.48 | 68400.0 |
| 2002-01-03 18:00:00 | QQQ | ETF | 41.5 | 41.5 | 41.46 | 41.5 | 14800.0 |
| 2002-01-03 09:00:00 | IWM | ETF | 48.5 | 49.0 | 48.5 | 49.0 | 162600.0 |
| 2002-01-03 10:00:00 | IWM | ETF | 49.1 | 49.165 | 48.875 | 49.075 | 157800.0 |
| 2002-01-03 11:00:00 | IWM | ETF | 49.075 | 49.135 | 48.87 | 48.965 | 229000.0 |
| 2002-01-03 12:00:00 | IWM | ETF | 48.89 | 48.965 | 48.735 | 48.8 | 59000.0 |
| 2002-01-03 13:00:00 | IWM | ETF | 48.895 | 48.915 | 48.77 | 48.885 | 79000.0 |
| 2002-01-03 14:00:00 | IWM | ETF | 48.865 | 48.925 | 48.765 | 48.805 | 67000.0 |
| 2002-01-03 15:00:00 | IWM | ETF | 48.87 | 49.275 | 48.81 | 49.275 | 244000.0 |
| 2002-01-03 16:00:00 | IWM | ETF | 49.25 | 49.295 | 49.25 | 49.295 | 8000.0 |
| 2002-01-03 09:00:00 | DIA | ETF | 100.8 | 101.29 | 100.63 | 101.21 | 340500.0 |
| 2002-01-03 10:00:00 | DIA | ETF | 101.18 | 101.52 | 101.1 | 101.41 | 274500.0 |
| 2002-01-03 11:00:00 | DIA | ETF | 101.5 | 101.7 | 101.36 | 101.47 | 144600.0 |
| 2002-01-03 12:00:00 | DIA | ETF | 101.54 | 101.56 | 101.26 | 101.5 | 132200.0 |
| 2002-01-03 13:00:00 | DIA | ETF | 101.49 | 101.55 | 101.31 | 101.33 | 66400.0 |
| 2002-01-03 14:00:00 | DIA | ETF | 101.4 | 101.52 | 101.19 | 101.4 | 91800.0 |
| 2002-01-03 15:00:00 | DIA | ETF | 101.39 | 101.88 | 101.38 | 101.86 | 372600.0 |
| 2002-01-03 16:00:00 | DIA | ETF | 101.87 | 101.99 | 101.82 | 101.95 | 41100.0 |
> showing 36 of 282 rows — these rows as CSV