PREVIEW / etf_1hour / 2002-04-05
file: by_date/etf_1hour/2002/2002-04-05.parquet size: 14 KB rows: 292
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-05 09:00:00 | SPY | ETF | 113.19 | 113.63 | 113.0 | 113.25 | 4143900.0 |
| 2002-04-05 10:00:00 | SPY | ETF | 113.26 | 113.46 | 112.86 | 112.96 | 2184100.0 |
| 2002-04-05 11:00:00 | SPY | ETF | 112.95 | 113.1 | 112.6 | 112.74 | 1498200.0 |
| 2002-04-05 12:00:00 | SPY | ETF | 112.76 | 112.76 | 112.18 | 112.62 | 2304500.0 |
| 2002-04-05 13:00:00 | SPY | ETF | 112.65 | 113.03 | 112.4 | 112.91 | 2875200.0 |
| 2002-04-05 14:00:00 | SPY | ETF | 112.93 | 113.09 | 112.71 | 112.73 | 1513900.0 |
| 2002-04-05 15:00:00 | SPY | ETF | 112.73 | 112.88 | 112.46 | 112.53 | 3067400.0 |
| 2002-04-05 16:00:00 | SPY | ETF | 112.48 | 112.7 | 112.46 | 112.65 | 961700.0 |
| 2002-04-05 09:00:00 | QQQ | ETF | 35.01 | 35.17 | 34.75 | 34.77 | 9544100.0 |
| 2002-04-05 10:00:00 | QQQ | ETF | 34.78 | 34.87 | 34.36 | 34.41 | 14385100.0 |
| 2002-04-05 11:00:00 | QQQ | ETF | 34.41 | 34.54 | 34.26 | 34.43 | 7321900.0 |
| 2002-04-05 12:00:00 | QQQ | ETF | 34.43 | 34.48 | 34.2 | 34.45 | 8107900.0 |
| 2002-04-05 13:00:00 | QQQ | ETF | 34.45 | 34.68 | 34.32 | 34.66 | 9080500.0 |
| 2002-04-05 14:00:00 | QQQ | ETF | 34.65 | 34.69 | 34.38 | 34.41 | 5442400.0 |
| 2002-04-05 15:00:00 | QQQ | ETF | 34.4 | 34.5 | 34.18 | 34.3 | 10295800.0 |
| 2002-04-05 16:00:00 | QQQ | ETF | 34.3 | 34.8 | 34.2 | 34.4 | 2908300.0 |
| 2002-04-05 17:00:00 | QQQ | ETF | 34.4 | 34.41 | 34.32 | 34.35 | 39900.0 |
| 2002-04-05 18:00:00 | QQQ | ETF | 34.37 | 34.41 | 34.37 | 34.41 | 17100.0 |
| 2002-04-05 09:00:00 | IWM | ETF | 49.8 | 49.91 | 49.725 | 49.76 | 92000.0 |
| 2002-04-05 10:00:00 | IWM | ETF | 49.825 | 49.95 | 49.755 | 49.785 | 335200.0 |
| 2002-04-05 11:00:00 | IWM | ETF | 49.79 | 49.845 | 49.665 | 49.745 | 95000.0 |
| 2002-04-05 12:00:00 | IWM | ETF | 49.695 | 49.74 | 49.58 | 49.65 | 98400.0 |
| 2002-04-05 13:00:00 | IWM | ETF | 49.71 | 49.785 | 49.61 | 49.785 | 29000.0 |
| 2002-04-05 14:00:00 | IWM | ETF | 49.87 | 49.87 | 49.72 | 49.78 | 59200.0 |
| 2002-04-05 15:00:00 | IWM | ETF | 49.695 | 49.75 | 49.525 | 49.525 | 96000.0 |
| 2002-04-05 16:00:00 | IWM | ETF | 49.525 | 49.55 | 49.35 | 49.55 | 6200.0 |
| 2002-04-05 09:00:00 | DIA | ETF | 103.02 | 103.48 | 103.0 | 103.05 | 1643000.0 |
| 2002-04-05 10:00:00 | DIA | ETF | 103.15 | 103.33 | 102.89 | 102.98 | 988800.0 |
| 2002-04-05 11:00:00 | DIA | ETF | 102.98 | 103.15 | 102.81 | 102.93 | 308800.0 |
| 2002-04-05 12:00:00 | DIA | ETF | 102.9 | 102.9 | 102.24 | 102.8 | 1147300.0 |
| 2002-04-05 13:00:00 | DIA | ETF | 102.81 | 103.28 | 102.6 | 103.1 | 776900.0 |
| 2002-04-05 14:00:00 | DIA | ETF | 103.18 | 103.32 | 103.0 | 103.04 | 1053300.0 |
| 2002-04-05 15:00:00 | DIA | ETF | 103.0 | 103.12 | 102.7 | 102.82 | 849300.0 |
| 2002-04-05 16:00:00 | DIA | ETF | 102.8 | 102.97 | 102.8 | 102.95 | 701600.0 |
> showing 34 of 292 rows — these rows as CSV