PREVIEW / etf_1hour / 2002-04-12
file: by_date/etf_1hour/2002/2002-04-12.parquet size: 14 KB rows: 294
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-12 09:00:00 | SPY | ETF | 111.02 | 111.25 | 110.66 | 111.15 | 2292600.0 |
| 2002-04-12 10:00:00 | SPY | ETF | 111.22 | 111.58 | 111.1 | 111.22 | 2361200.0 |
| 2002-04-12 11:00:00 | SPY | ETF | 111.21 | 111.31 | 110.57 | 110.85 | 2292700.0 |
| 2002-04-12 12:00:00 | SPY | ETF | 110.85 | 111.38 | 110.85 | 111.24 | 1665900.0 |
| 2002-04-12 13:00:00 | SPY | ETF | 111.26 | 111.45 | 110.97 | 111.09 | 1386500.0 |
| 2002-04-12 14:00:00 | SPY | ETF | 111.09 | 111.65 | 111.07 | 111.35 | 1450100.0 |
| 2002-04-12 15:00:00 | SPY | ETF | 111.33 | 111.62 | 111.03 | 111.33 | 1712300.0 |
| 2002-04-12 16:00:00 | SPY | ETF | 111.32 | 111.46 | 111.25 | 111.43 | 922900.0 |
| 2002-04-12 09:00:00 | QQQ | ETF | 33.32 | 33.38 | 32.95 | 33.35 | 15514800.0 |
| 2002-04-12 10:00:00 | QQQ | ETF | 33.36 | 33.57 | 33.28 | 33.35 | 14289300.0 |
| 2002-04-12 11:00:00 | QQQ | ETF | 33.36 | 33.4 | 32.99 | 33.2 | 12839200.0 |
| 2002-04-12 12:00:00 | QQQ | ETF | 33.18 | 33.45 | 33.18 | 33.37 | 7962800.0 |
| 2002-04-12 13:00:00 | QQQ | ETF | 33.37 | 33.48 | 33.2 | 33.34 | 3177200.0 |
| 2002-04-12 14:00:00 | QQQ | ETF | 33.34 | 33.8 | 33.34 | 33.59 | 9738300.0 |
| 2002-04-12 15:00:00 | QQQ | ETF | 33.59 | 33.7 | 33.4 | 33.62 | 9716500.0 |
| 2002-04-12 16:00:00 | QQQ | ETF | 33.58 | 33.64 | 33.51 | 33.54 | 1529100.0 |
| 2002-04-12 17:00:00 | QQQ | ETF | 33.54 | 33.6 | 33.5 | 33.55 | 36400.0 |
| 2002-04-12 18:00:00 | QQQ | ETF | 33.53 | 33.56 | 33.53 | 33.55 | 2200.0 |
| 2002-04-12 09:00:00 | IWM | ETF | 50.5 | 50.52 | 50.125 | 50.385 | 214400.0 |
| 2002-04-12 10:00:00 | IWM | ETF | 50.385 | 50.52 | 50.36 | 50.36 | 129400.0 |
| 2002-04-12 11:00:00 | IWM | ETF | 50.385 | 50.385 | 50.15 | 50.245 | 508400.0 |
| 2002-04-12 12:00:00 | IWM | ETF | 50.25 | 50.575 | 50.245 | 50.575 | 128800.0 |
| 2002-04-12 13:00:00 | IWM | ETF | 50.575 | 50.68 | 50.555 | 50.575 | 115000.0 |
| 2002-04-12 14:00:00 | IWM | ETF | 50.565 | 51.01 | 50.565 | 50.845 | 149600.0 |
| 2002-04-12 15:00:00 | IWM | ETF | 50.81 | 51.235 | 50.8 | 51.15 | 1567800.0 |
| 2002-04-12 16:00:00 | IWM | ETF | 51.175 | 51.35 | 51.175 | 51.35 | 23200.0 |
| 2002-04-12 09:00:00 | DIA | ETF | 102.4 | 102.42 | 101.76 | 102.08 | 2067700.0 |
| 2002-04-12 10:00:00 | DIA | ETF | 102.14 | 102.53 | 102.09 | 102.12 | 653900.0 |
| 2002-04-12 11:00:00 | DIA | ETF | 102.15 | 102.29 | 101.51 | 101.71 | 607600.0 |
| 2002-04-12 12:00:00 | DIA | ETF | 101.7 | 102.24 | 101.68 | 102.15 | 974000.0 |
| 2002-04-12 13:00:00 | DIA | ETF | 102.07 | 102.29 | 101.87 | 102.0 | 228300.0 |
| 2002-04-12 14:00:00 | DIA | ETF | 102.04 | 102.46 | 101.98 | 101.98 | 357100.0 |
| 2002-04-12 15:00:00 | DIA | ETF | 102.05 | 102.2 | 101.76 | 101.99 | 334000.0 |
| 2002-04-12 16:00:00 | DIA | ETF | 101.97 | 102.09 | 101.9 | 101.99 | 75200.0 |
> showing 34 of 294 rows — these rows as CSV