PREVIEW / etf_1hour / 2002-05-13
file: by_date/etf_1hour/2002/2002-05-13.parquet size: 14 KB rows: 298
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-05-13 09:00:00 | SPY | ETF | 106.22 | 106.33 | 105.79 | 106.21 | 2524300.0 |
| 2002-05-13 10:00:00 | SPY | ETF | 106.23 | 107.18 | 106.18 | 106.9 | 3198100.0 |
| 2002-05-13 11:00:00 | SPY | ETF | 106.91 | 107.59 | 106.87 | 107.48 | 1809600.0 |
| 2002-05-13 12:00:00 | SPY | ETF | 107.52 | 107.57 | 107.2 | 107.32 | 1048900.0 |
| 2002-05-13 13:00:00 | SPY | ETF | 107.34 | 107.68 | 107.12 | 107.28 | 829400.0 |
| 2002-05-13 14:00:00 | SPY | ETF | 107.3 | 107.6 | 107.14 | 107.5 | 906600.0 |
| 2002-05-13 15:00:00 | SPY | ETF | 107.53 | 107.95 | 107.45 | 107.82 | 2791900.0 |
| 2002-05-13 16:00:00 | SPY | ETF | 107.82 | 107.95 | 107.72 | 107.9 | 1139200.0 |
| 2002-05-13 17:00:00 | SPY | ETF | 107.85 | 108.1 | 107.85 | 108.06 | 33600.0 |
| 2002-05-13 18:00:00 | SPY | ETF | 108.08 | 108.08 | 108.08 | 108.08 | 100.0 |
| 2002-05-13 09:00:00 | QQQ | ETF | 29.87 | 30.15 | 29.67 | 30.05 | 12280900.0 |
| 2002-05-13 10:00:00 | QQQ | ETF | 30.02 | 30.61 | 30.0 | 30.46 | 21540800.0 |
| 2002-05-13 11:00:00 | QQQ | ETF | 30.46 | 30.8 | 30.4 | 30.75 | 9079600.0 |
| 2002-05-13 12:00:00 | QQQ | ETF | 30.77 | 30.78 | 30.5 | 30.63 | 9163400.0 |
| 2002-05-13 13:00:00 | QQQ | ETF | 30.63 | 30.82 | 30.38 | 30.49 | 11732300.0 |
| 2002-05-13 14:00:00 | QQQ | ETF | 30.5 | 30.74 | 30.44 | 30.72 | 7209500.0 |
| 2002-05-13 15:00:00 | QQQ | ETF | 30.72 | 30.98 | 30.65 | 30.87 | 16659900.0 |
| 2002-05-13 16:00:00 | QQQ | ETF | 30.86 | 30.9 | 30.76 | 30.84 | 1975400.0 |
| 2002-05-13 17:00:00 | QQQ | ETF | 30.8 | 30.84 | 30.78 | 30.82 | 47300.0 |
| 2002-05-13 18:00:00 | QQQ | ETF | 30.83 | 30.87 | 30.83 | 30.84 | 11000.0 |
| 2002-05-13 09:00:00 | IWM | ETF | 49.075 | 49.15 | 49.0 | 49.135 | 365800.0 |
| 2002-05-13 10:00:00 | IWM | ETF | 49.13 | 49.57 | 49.09 | 49.53 | 505600.0 |
| 2002-05-13 11:00:00 | IWM | ETF | 49.48 | 49.69 | 49.455 | 49.625 | 86800.0 |
| 2002-05-13 12:00:00 | IWM | ETF | 49.625 | 49.625 | 49.455 | 49.53 | 315600.0 |
| 2002-05-13 13:00:00 | IWM | ETF | 49.455 | 49.505 | 49.315 | 49.32 | 38800.0 |
| 2002-05-13 14:00:00 | IWM | ETF | 49.31 | 49.435 | 49.29 | 49.385 | 92400.0 |
| 2002-05-13 15:00:00 | IWM | ETF | 49.4 | 49.725 | 49.38 | 49.71 | 290600.0 |
| 2002-05-13 16:00:00 | IWM | ETF | 49.7 | 49.7 | 49.65 | 49.65 | 18800.0 |
| 2002-05-13 09:00:00 | DIA | ETF | 99.92 | 99.92 | 99.33 | 99.77 | 658600.0 |
| 2002-05-13 10:00:00 | DIA | ETF | 99.75 | 100.82 | 99.75 | 100.52 | 1054400.0 |
| 2002-05-13 11:00:00 | DIA | ETF | 100.58 | 101.1 | 100.45 | 101.0 | 525300.0 |
| 2002-05-13 12:00:00 | DIA | ETF | 101.04 | 101.08 | 100.75 | 100.88 | 319800.0 |
| 2002-05-13 13:00:00 | DIA | ETF | 100.93 | 101.07 | 100.66 | 100.79 | 113900.0 |
| 2002-05-13 14:00:00 | DIA | ETF | 100.76 | 100.96 | 100.56 | 100.85 | 193600.0 |
| 2002-05-13 15:00:00 | DIA | ETF | 100.88 | 101.25 | 100.86 | 101.22 | 591700.0 |
| 2002-05-13 16:00:00 | DIA | ETF | 101.21 | 101.25 | 101.08 | 101.24 | 120000.0 |
| 2002-05-13 17:00:00 | DIA | ETF | 101.25 | 101.25 | 101.25 | 101.25 | 400.0 |
> showing 37 of 298 rows — these rows as CSV