PREVIEW / etf_1hour / 2002-05-14
file: by_date/etf_1hour/2002/2002-05-14.parquet size: 14 KB rows: 318
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-14 09:00:00 | SPY | ETF | 109.62 | 109.8 | 109.15 | 109.38 | 5095900.0 |
| 2002-05-14 10:00:00 | SPY | ETF | 109.36 | 109.68 | 109.0 | 109.54 | 3082200.0 |
| 2002-05-14 11:00:00 | SPY | ETF | 109.57 | 109.75 | 109.3 | 109.56 | 1758100.0 |
| 2002-05-14 12:00:00 | SPY | ETF | 109.59 | 109.8 | 109.55 | 109.58 | 1132000.0 |
| 2002-05-14 13:00:00 | SPY | ETF | 109.59 | 109.73 | 109.37 | 109.46 | 718400.0 |
| 2002-05-14 14:00:00 | SPY | ETF | 109.42 | 110.15 | 109.36 | 109.99 | 2988600.0 |
| 2002-05-14 15:00:00 | SPY | ETF | 109.97 | 110.26 | 109.84 | 110.09 | 3357100.0 |
| 2002-05-14 16:00:00 | SPY | ETF | 110.13 | 110.51 | 109.72 | 110.34 | 15398700.0 |
| 2002-05-14 17:00:00 | SPY | ETF | 110.34 | 110.35 | 110.2 | 110.2 | 11900.0 |
| 2002-05-14 18:00:00 | SPY | ETF | 110.27 | 110.3 | 110.13 | 110.2 | 15600.0 |
| 2002-05-14 09:00:00 | QQQ | ETF | 32.05 | 32.32 | 31.96 | 32.18 | 20008500.0 |
| 2002-05-14 10:00:00 | QQQ | ETF | 32.18 | 32.21 | 31.87 | 32.16 | 15260600.0 |
| 2002-05-14 11:00:00 | QQQ | ETF | 32.18 | 32.29 | 32.05 | 32.23 | 9522200.0 |
| 2002-05-14 12:00:00 | QQQ | ETF | 32.23 | 32.4 | 32.15 | 32.2 | 9778700.0 |
| 2002-05-14 13:00:00 | QQQ | ETF | 32.21 | 32.32 | 32.05 | 32.11 | 7016100.0 |
| 2002-05-14 14:00:00 | QQQ | ETF | 32.11 | 32.55 | 32.07 | 32.44 | 11886700.0 |
| 2002-05-14 15:00:00 | QQQ | ETF | 32.45 | 32.61 | 32.31 | 32.5 | 21028800.0 |
| 2002-05-14 16:00:00 | QQQ | ETF | 32.49 | 32.84 | 32.42 | 32.7 | 8813400.0 |
| 2002-05-14 17:00:00 | QQQ | ETF | 32.7 | 32.73 | 32.64 | 32.72 | 496900.0 |
| 2002-05-14 18:00:00 | QQQ | ETF | 32.72 | 32.73 | 32.68 | 32.7 | 24300.0 |
| 2002-05-14 09:00:00 | IWM | ETF | 50.35 | 50.445 | 50.11 | 50.185 | 168200.0 |
| 2002-05-14 10:00:00 | IWM | ETF | 50.22 | 50.455 | 50.115 | 50.45 | 1062200.0 |
| 2002-05-14 11:00:00 | IWM | ETF | 50.48 | 50.615 | 50.47 | 50.6 | 2452000.0 |
| 2002-05-14 12:00:00 | IWM | ETF | 50.6 | 50.795 | 50.585 | 50.685 | 1111200.0 |
| 2002-05-14 13:00:00 | IWM | ETF | 50.685 | 50.825 | 50.675 | 50.725 | 1606600.0 |
| 2002-05-14 14:00:00 | IWM | ETF | 50.725 | 51.04 | 50.7 | 51.03 | 1694200.0 |
| 2002-05-14 15:00:00 | IWM | ETF | 51.0 | 51.1 | 50.87 | 50.95 | 376800.0 |
| 2002-05-14 16:00:00 | IWM | ETF | 50.95 | 51.2 | 50.95 | 51.09 | 25200.0 |
| 2002-05-14 17:00:00 | IWM | ETF | 51.25 | 51.25 | 50.96 | 50.96 | 67000.0 |
| 2002-05-14 09:00:00 | DIA | ETF | 102.75 | 102.85 | 102.32 | 102.56 | 1275300.0 |
| 2002-05-14 10:00:00 | DIA | ETF | 102.55 | 102.79 | 102.15 | 102.68 | 764500.0 |
| 2002-05-14 11:00:00 | DIA | ETF | 102.72 | 102.9 | 102.54 | 102.66 | 250200.0 |
| 2002-05-14 12:00:00 | DIA | ETF | 102.72 | 102.82 | 102.55 | 102.58 | 278600.0 |
| 2002-05-14 13:00:00 | DIA | ETF | 102.58 | 102.7 | 102.4 | 102.47 | 147600.0 |
| 2002-05-14 14:00:00 | DIA | ETF | 102.46 | 103.06 | 102.42 | 102.94 | 518800.0 |
| 2002-05-14 15:00:00 | DIA | ETF | 102.9 | 103.2 | 102.79 | 103.02 | 826000.0 |
| 2002-05-14 16:00:00 | DIA | ETF | 103.01 | 103.48 | 102.98 | 103.48 | 290700.0 |
| 2002-05-14 17:00:00 | DIA | ETF | 103.15 | 103.15 | 103.15 | 103.15 | 200.0 |
> showing 38 of 318 rows — these rows as CSV