PREVIEW / etf_1hour / 2002-04-04
file: by_date/etf_1hour/2002/2002-04-04.parquet size: 14 KB rows: 287
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-04 09:00:00 | SPY | ETF | 112.6 | 113.07 | 112.35 | 112.87 | 4085000.0 |
| 2002-04-04 10:00:00 | SPY | ETF | 112.84 | 113.4 | 112.67 | 112.89 | 5535600.0 |
| 2002-04-04 11:00:00 | SPY | ETF | 112.9 | 113.05 | 112.62 | 112.85 | 3871800.0 |
| 2002-04-04 12:00:00 | SPY | ETF | 112.88 | 113.14 | 112.7 | 112.71 | 821500.0 |
| 2002-04-04 13:00:00 | SPY | ETF | 112.73 | 112.87 | 112.32 | 112.6 | 1589200.0 |
| 2002-04-04 14:00:00 | SPY | ETF | 112.63 | 112.8 | 112.32 | 112.5 | 2791500.0 |
| 2002-04-04 15:00:00 | SPY | ETF | 112.49 | 112.99 | 112.23 | 112.89 | 3402100.0 |
| 2002-04-04 16:00:00 | SPY | ETF | 112.94 | 112.94 | 112.66 | 112.79 | 1120200.0 |
| 2002-04-04 17:00:00 | SPY | ETF | 112.78 | 112.78 | 112.7 | 112.75 | 18500.0 |
| 2002-04-04 18:00:00 | SPY | ETF | 112.66 | 112.67 | 112.66 | 112.67 | 400.0 |
| 2002-04-04 09:00:00 | QQQ | ETF | 34.5 | 34.88 | 34.36 | 34.78 | 16500900.0 |
| 2002-04-04 10:00:00 | QQQ | ETF | 34.78 | 35.16 | 34.6 | 34.91 | 19991500.0 |
| 2002-04-04 11:00:00 | QQQ | ETF | 34.9 | 34.93 | 34.54 | 34.68 | 12800300.0 |
| 2002-04-04 12:00:00 | QQQ | ETF | 34.63 | 34.85 | 34.58 | 34.62 | 3935000.0 |
| 2002-04-04 13:00:00 | QQQ | ETF | 34.61 | 34.76 | 34.47 | 34.6 | 7932600.0 |
| 2002-04-04 14:00:00 | QQQ | ETF | 34.6 | 34.7 | 34.33 | 34.45 | 7065000.0 |
| 2002-04-04 15:00:00 | QQQ | ETF | 34.45 | 34.84 | 34.28 | 34.76 | 17112900.0 |
| 2002-04-04 16:00:00 | QQQ | ETF | 34.75 | 34.82 | 34.7 | 34.7 | 2668700.0 |
| 2002-04-04 17:00:00 | QQQ | ETF | 34.74 | 34.77 | 34.63 | 34.63 | 617800.0 |
| 2002-04-04 18:00:00 | QQQ | ETF | 34.65 | 34.8 | 34.63 | 34.65 | 9900.0 |
| 2002-04-04 09:00:00 | IWM | ETF | 49.2 | 49.52 | 49.175 | 49.43 | 149200.0 |
| 2002-04-04 10:00:00 | IWM | ETF | 49.52 | 49.67 | 49.35 | 49.57 | 322000.0 |
| 2002-04-04 11:00:00 | IWM | ETF | 49.57 | 49.57 | 49.4 | 49.5 | 164800.0 |
| 2002-04-04 12:00:00 | IWM | ETF | 49.495 | 49.595 | 49.495 | 49.52 | 202400.0 |
| 2002-04-04 13:00:00 | IWM | ETF | 49.52 | 49.555 | 49.355 | 49.45 | 327400.0 |
| 2002-04-04 14:00:00 | IWM | ETF | 49.465 | 49.505 | 49.35 | 49.355 | 132400.0 |
| 2002-04-04 15:00:00 | IWM | ETF | 49.4 | 49.685 | 49.32 | 49.685 | 724800.0 |
| 2002-04-04 16:00:00 | IWM | ETF | 49.625 | 49.65 | 49.62 | 49.62 | 55400.0 |
| 2002-04-04 09:00:00 | DIA | ETF | 101.95 | 102.36 | 101.63 | 102.2 | 2215000.0 |
| 2002-04-04 10:00:00 | DIA | ETF | 102.29 | 102.78 | 102.07 | 102.32 | 2073500.0 |
| 2002-04-04 11:00:00 | DIA | ETF | 102.3 | 102.56 | 102.08 | 102.37 | 1813100.0 |
| 2002-04-04 12:00:00 | DIA | ETF | 102.39 | 102.68 | 102.29 | 102.3 | 293500.0 |
| 2002-04-04 13:00:00 | DIA | ETF | 102.3 | 102.48 | 101.94 | 102.14 | 646700.0 |
| 2002-04-04 14:00:00 | DIA | ETF | 102.17 | 102.37 | 101.94 | 102.09 | 417200.0 |
| 2002-04-04 15:00:00 | DIA | ETF | 102.17 | 102.49 | 101.91 | 102.43 | 409000.0 |
| 2002-04-04 16:00:00 | DIA | ETF | 102.39 | 102.54 | 102.23 | 102.47 | 171000.0 |
| 2002-04-04 17:00:00 | DIA | ETF | 102.35 | 102.35 | 102.25 | 102.25 | 1500.0 |
> showing 37 of 287 rows — these rows as CSV