PREVIEW / etf_1hour / 2002-07-08
file: by_date/etf_1hour/2002/2002-07-08.parquet size: 14 KB rows: 315
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-07-08 09:00:00 | SPY | ETF | 98.98 | 99.7 | 98.58 | 98.67 | 3226500.0 |
| 2002-07-08 10:00:00 | SPY | ETF | 98.68 | 99.08 | 98.07 | 98.23 | 3767500.0 |
| 2002-07-08 11:00:00 | SPY | ETF | 98.26 | 98.53 | 97.8 | 97.94 | 2376300.0 |
| 2002-07-08 12:00:00 | SPY | ETF | 97.94 | 98.35 | 97.67 | 98.28 | 1230300.0 |
| 2002-07-08 13:00:00 | SPY | ETF | 98.28 | 98.67 | 97.85 | 98.41 | 1655100.0 |
| 2002-07-08 14:00:00 | SPY | ETF | 98.42 | 98.78 | 97.82 | 98.03 | 1853100.0 |
| 2002-07-08 15:00:00 | SPY | ETF | 98.02 | 98.3 | 97.56 | 98.03 | 3235200.0 |
| 2002-07-08 16:00:00 | SPY | ETF | 98.0 | 98.3 | 97.84 | 98.11 | 880000.0 |
| 2002-07-08 17:00:00 | SPY | ETF | 98.18 | 98.2 | 98.07 | 98.13 | 10400.0 |
| 2002-07-08 18:00:00 | SPY | ETF | 98.12 | 98.29 | 98.12 | 98.19 | 2200.0 |
| 2002-07-08 09:00:00 | QQQ | ETF | 26.2 | 26.53 | 25.82 | 25.89 | 16051600.0 |
| 2002-07-08 10:00:00 | QQQ | ETF | 25.89 | 26.04 | 25.53 | 25.62 | 21025000.0 |
| 2002-07-08 11:00:00 | QQQ | ETF | 25.64 | 25.74 | 25.42 | 25.51 | 9965400.0 |
| 2002-07-08 12:00:00 | QQQ | ETF | 25.51 | 25.68 | 25.42 | 25.64 | 6658100.0 |
| 2002-07-08 13:00:00 | QQQ | ETF | 25.63 | 25.78 | 25.4 | 25.66 | 9710100.0 |
| 2002-07-08 14:00:00 | QQQ | ETF | 25.66 | 25.81 | 25.35 | 25.41 | 11853300.0 |
| 2002-07-08 15:00:00 | QQQ | ETF | 25.42 | 25.51 | 25.08 | 25.25 | 17608700.0 |
| 2002-07-08 16:00:00 | QQQ | ETF | 25.25 | 25.46 | 25.21 | 25.43 | 3091300.0 |
| 2002-07-08 17:00:00 | QQQ | ETF | 25.41 | 25.47 | 25.37 | 25.43 | 145200.0 |
| 2002-07-08 18:00:00 | QQQ | ETF | 25.43 | 25.49 | 25.4 | 25.44 | 18700.0 |
| 2002-07-08 09:00:00 | IWM | ETF | 43.875 | 44.12 | 43.6 | 43.6 | 309400.0 |
| 2002-07-08 10:00:00 | IWM | ETF | 43.57 | 43.8 | 43.525 | 43.78 | 157000.0 |
| 2002-07-08 11:00:00 | IWM | ETF | 43.775 | 44.025 | 43.67 | 43.81 | 170000.0 |
| 2002-07-08 12:00:00 | IWM | ETF | 43.805 | 43.84 | 43.66 | 43.84 | 293400.0 |
| 2002-07-08 13:00:00 | IWM | ETF | 43.84 | 43.95 | 43.79 | 43.865 | 61200.0 |
| 2002-07-08 14:00:00 | IWM | ETF | 43.885 | 43.98 | 43.75 | 43.75 | 120800.0 |
| 2002-07-08 15:00:00 | IWM | ETF | 43.73 | 43.85 | 43.15 | 43.15 | 372600.0 |
| 2002-07-08 16:00:00 | IWM | ETF | 43.295 | 43.295 | 43.025 | 43.2 | 296200.0 |
| 2002-07-08 09:00:00 | DIA | ETF | 93.65 | 94.19 | 93.38 | 93.41 | 1167200.0 |
| 2002-07-08 10:00:00 | DIA | ETF | 93.44 | 93.77 | 92.9 | 93.13 | 900400.0 |
| 2002-07-08 11:00:00 | DIA | ETF | 93.13 | 93.32 | 92.74 | 92.88 | 405400.0 |
| 2002-07-08 12:00:00 | DIA | ETF | 92.88 | 93.2 | 92.6 | 93.04 | 332600.0 |
| 2002-07-08 13:00:00 | DIA | ETF | 93.05 | 93.52 | 92.7 | 93.2 | 206300.0 |
| 2002-07-08 14:00:00 | DIA | ETF | 93.22 | 93.53 | 92.8 | 92.98 | 559500.0 |
| 2002-07-08 15:00:00 | DIA | ETF | 92.93 | 93.22 | 92.5 | 92.99 | 416100.0 |
| 2002-07-08 16:00:00 | DIA | ETF | 92.94 | 93.03 | 92.87 | 92.96 | 29400.0 |
| 2002-07-08 17:00:00 | DIA | ETF | 93.0 | 93.0 | 93.0 | 93.0 | 500.0 |
> showing 37 of 315 rows — these rows as CSV