PREVIEW / etf_1hour / 2002-04-08
file: by_date/etf_1hour/2002/2002-04-08.parquet size: 14 KB rows: 304
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-08 09:00:00 | SPY | ETF | 111.32 | 111.85 | 111.23 | 111.79 | 2465800.0 |
| 2002-04-08 10:00:00 | SPY | ETF | 111.84 | 112.14 | 111.58 | 111.8 | 3325400.0 |
| 2002-04-08 11:00:00 | SPY | ETF | 111.81 | 112.09 | 111.64 | 111.97 | 1517400.0 |
| 2002-04-08 12:00:00 | SPY | ETF | 111.94 | 112.2 | 111.81 | 112.11 | 1209700.0 |
| 2002-04-08 13:00:00 | SPY | ETF | 112.11 | 112.49 | 112.1 | 112.28 | 1506100.0 |
| 2002-04-08 14:00:00 | SPY | ETF | 112.29 | 112.85 | 112.29 | 112.65 | 2414000.0 |
| 2002-04-08 15:00:00 | SPY | ETF | 112.66 | 112.88 | 112.44 | 112.8 | 1691800.0 |
| 2002-04-08 16:00:00 | SPY | ETF | 112.81 | 113.13 | 112.76 | 113.13 | 1487000.0 |
| 2002-04-08 17:00:00 | SPY | ETF | 113.12 | 113.19 | 113.08 | 113.18 | 44500.0 |
| 2002-04-08 18:00:00 | SPY | ETF | 113.18 | 113.19 | 113.05 | 113.19 | 6100.0 |
| 2002-04-08 09:00:00 | QQQ | ETF | 33.47 | 33.76 | 33.46 | 33.67 | 9805200.0 |
| 2002-04-08 10:00:00 | QQQ | ETF | 33.67 | 33.71 | 33.42 | 33.59 | 13233100.0 |
| 2002-04-08 11:00:00 | QQQ | ETF | 33.6 | 33.85 | 33.52 | 33.79 | 8092300.0 |
| 2002-04-08 12:00:00 | QQQ | ETF | 33.79 | 33.94 | 33.7 | 33.9 | 4545200.0 |
| 2002-04-08 13:00:00 | QQQ | ETF | 33.91 | 34.37 | 33.89 | 34.25 | 9806900.0 |
| 2002-04-08 14:00:00 | QQQ | ETF | 34.25 | 34.75 | 34.22 | 34.5 | 14885700.0 |
| 2002-04-08 15:00:00 | QQQ | ETF | 34.53 | 34.7 | 34.33 | 34.7 | 8431200.0 |
| 2002-04-08 16:00:00 | QQQ | ETF | 34.67 | 35.0 | 34.44 | 34.96 | 2291400.0 |
| 2002-04-08 17:00:00 | QQQ | ETF | 34.97 | 35.06 | 34.91 | 34.94 | 127700.0 |
| 2002-04-08 18:00:00 | QQQ | ETF | 34.93 | 34.97 | 34.92 | 34.97 | 27000.0 |
| 2002-04-08 09:00:00 | IWM | ETF | 49.005 | 49.24 | 49.0 | 49.2 | 61400.0 |
| 2002-04-08 10:00:00 | IWM | ETF | 49.16 | 49.25 | 49.13 | 49.23 | 85000.0 |
| 2002-04-08 11:00:00 | IWM | ETF | 49.23 | 49.31 | 49.14 | 49.23 | 129400.0 |
| 2002-04-08 12:00:00 | IWM | ETF | 49.24 | 49.51 | 49.24 | 49.48 | 553800.0 |
| 2002-04-08 13:00:00 | IWM | ETF | 49.52 | 49.785 | 49.52 | 49.77 | 85000.0 |
| 2002-04-08 14:00:00 | IWM | ETF | 49.77 | 50.045 | 49.77 | 49.925 | 56000.0 |
| 2002-04-08 15:00:00 | IWM | ETF | 49.905 | 50.07 | 49.9 | 50.07 | 127000.0 |
| 2002-04-08 16:00:00 | IWM | ETF | 50.07 | 50.17 | 50.065 | 50.17 | 46000.0 |
| 2002-04-08 09:00:00 | DIA | ETF | 101.3 | 101.74 | 101.1 | 101.55 | 1173000.0 |
| 2002-04-08 10:00:00 | DIA | ETF | 101.56 | 102.15 | 101.46 | 101.83 | 1294600.0 |
| 2002-04-08 11:00:00 | DIA | ETF | 101.79 | 102.14 | 101.71 | 101.99 | 426900.0 |
| 2002-04-08 12:00:00 | DIA | ETF | 101.99 | 102.11 | 101.9 | 102.05 | 146600.0 |
| 2002-04-08 13:00:00 | DIA | ETF | 102.1 | 102.43 | 102.04 | 102.16 | 251500.0 |
| 2002-04-08 14:00:00 | DIA | ETF | 102.24 | 102.64 | 102.18 | 102.56 | 334300.0 |
| 2002-04-08 15:00:00 | DIA | ETF | 102.54 | 102.7 | 102.35 | 102.64 | 597100.0 |
| 2002-04-08 16:00:00 | DIA | ETF | 102.6 | 102.99 | 102.55 | 102.99 | 70600.0 |
> showing 36 of 304 rows — these rows as CSV