PREVIEW / etf_1hour / 2002-07-24
file: by_date/etf_1hour/2002/2002-07-24.parquet size: 15 KB rows: 328
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-24 09:00:00 | SPY | ETF | 78.13 | 79.0 | 77.68 | 78.39 | 9010300.0 |
| 2002-07-24 10:00:00 | SPY | ETF | 78.38 | 80.5 | 78.1 | 79.78 | 15232100.0 |
| 2002-07-24 11:00:00 | SPY | ETF | 79.85 | 82.3 | 79.45 | 81.85 | 14258600.0 |
| 2002-07-24 12:00:00 | SPY | ETF | 81.87 | 82.64 | 80.81 | 81.5 | 13393800.0 |
| 2002-07-24 13:00:00 | SPY | ETF | 81.43 | 82.0 | 80.8 | 81.44 | 8822700.0 |
| 2002-07-24 14:00:00 | SPY | ETF | 81.46 | 83.0 | 81.44 | 82.57 | 14323600.0 |
| 2002-07-24 15:00:00 | SPY | ETF | 82.5 | 84.94 | 82.4 | 84.8 | 18769400.0 |
| 2002-07-24 16:00:00 | SPY | ETF | 84.75 | 85.12 | 84.65 | 84.72 | 1799800.0 |
| 2002-07-24 09:00:00 | QQQ | ETF | 21.81 | 22.19 | 21.64 | 21.91 | 24825600.0 |
| 2002-07-24 10:00:00 | QQQ | ETF | 21.91 | 22.69 | 21.86 | 22.4 | 34167100.0 |
| 2002-07-24 11:00:00 | QQQ | ETF | 22.39 | 22.92 | 22.1 | 22.68 | 27201800.0 |
| 2002-07-24 12:00:00 | QQQ | ETF | 22.62 | 22.92 | 22.31 | 22.51 | 19509400.0 |
| 2002-07-24 13:00:00 | QQQ | ETF | 22.51 | 22.68 | 22.31 | 22.52 | 13055900.0 |
| 2002-07-24 14:00:00 | QQQ | ETF | 22.52 | 22.91 | 22.41 | 22.76 | 19316200.0 |
| 2002-07-24 15:00:00 | QQQ | ETF | 22.76 | 23.65 | 22.65 | 23.62 | 38009800.0 |
| 2002-07-24 16:00:00 | QQQ | ETF | 23.62 | 23.66 | 23.51 | 23.62 | 1956500.0 |
| 2002-07-24 09:00:00 | IWM | ETF | 35.2 | 35.5 | 34.75 | 35.14 | 790600.0 |
| 2002-07-24 10:00:00 | IWM | ETF | 35.005 | 36.25 | 35.005 | 35.7 | 2507400.0 |
| 2002-07-24 11:00:00 | IWM | ETF | 35.7 | 36.73 | 35.7 | 36.725 | 540600.0 |
| 2002-07-24 12:00:00 | IWM | ETF | 36.6 | 36.8 | 36.3 | 36.515 | 323200.0 |
| 2002-07-24 13:00:00 | IWM | ETF | 36.525 | 36.65 | 36.3 | 36.545 | 219400.0 |
| 2002-07-24 14:00:00 | IWM | ETF | 36.535 | 37.1 | 36.455 | 36.995 | 977200.0 |
| 2002-07-24 15:00:00 | IWM | ETF | 37.115 | 37.75 | 36.9 | 37.675 | 745200.0 |
| 2002-07-24 16:00:00 | IWM | ETF | 37.6 | 38.0 | 37.55 | 38.0 | 36200.0 |
| 2002-07-24 09:00:00 | DIA | ETF | 75.75 | 76.95 | 75.28 | 76.15 | 2835200.0 |
| 2002-07-24 10:00:00 | DIA | ETF | 76.05 | 78.3 | 75.75 | 77.5 | 4294500.0 |
| 2002-07-24 11:00:00 | DIA | ETF | 77.54 | 79.68 | 77.1 | 79.39 | 3696300.0 |
| 2002-07-24 12:00:00 | DIA | ETF | 79.3 | 79.98 | 78.19 | 79.0 | 2635300.0 |
| 2002-07-24 13:00:00 | DIA | ETF | 78.92 | 79.45 | 78.2 | 78.82 | 2102500.0 |
| 2002-07-24 14:00:00 | DIA | ETF | 78.82 | 80.5 | 78.82 | 80.11 | 3180700.0 |
| 2002-07-24 15:00:00 | DIA | ETF | 80.1 | 82.3 | 79.91 | 82.05 | 5439700.0 |
| 2002-07-24 16:00:00 | DIA | ETF | 82.09 | 82.45 | 81.87 | 82.1 | 137100.0 |
> showing 32 of 328 rows — these rows as CSV