PREVIEW / etf_1hour / 2002-01-17
file: by_date/etf_1hour/2002/2002-01-17.parquet size: 13 KB rows: 285
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-01-17 09:00:00 | SPY | ETF | 113.76 | 113.9 | 113.52 | 113.61 | 2107000.0 |
| 2002-01-17 10:00:00 | SPY | ETF | 113.58 | 113.74 | 113.4 | 113.68 | 2531300.0 |
| 2002-01-17 11:00:00 | SPY | ETF | 113.65 | 113.85 | 113.44 | 113.66 | 1456400.0 |
| 2002-01-17 12:00:00 | SPY | ETF | 113.68 | 114.19 | 113.67 | 114.02 | 3086800.0 |
| 2002-01-17 13:00:00 | SPY | ETF | 113.97 | 114.07 | 113.75 | 113.89 | 2003100.0 |
| 2002-01-17 14:00:00 | SPY | ETF | 113.84 | 113.95 | 113.57 | 113.93 | 1827800.0 |
| 2002-01-17 15:00:00 | SPY | ETF | 113.91 | 114.24 | 113.8 | 114.13 | 2484100.0 |
| 2002-01-17 16:00:00 | SPY | ETF | 114.15 | 114.2 | 113.2 | 113.42 | 1045600.0 |
| 2002-01-17 17:00:00 | SPY | ETF | 113.25 | 113.4 | 113.15 | 113.28 | 500900.0 |
| 2002-01-17 18:00:00 | SPY | ETF | 113.25 | 113.4 | 112.65 | 113.02 | 409900.0 |
| 2002-01-17 09:00:00 | QQQ | ETF | 39.48 | 39.6 | 39.25 | 39.31 | 11472700.0 |
| 2002-01-17 10:00:00 | QQQ | ETF | 39.3 | 39.4 | 39.01 | 39.28 | 12137100.0 |
| 2002-01-17 11:00:00 | QQQ | ETF | 39.27 | 39.37 | 39.05 | 39.19 | 6339100.0 |
| 2002-01-17 12:00:00 | QQQ | ETF | 39.19 | 39.65 | 39.16 | 39.47 | 12067400.0 |
| 2002-01-17 13:00:00 | QQQ | ETF | 39.47 | 39.53 | 39.34 | 39.46 | 4405000.0 |
| 2002-01-17 14:00:00 | QQQ | ETF | 39.45 | 39.62 | 39.26 | 39.59 | 7902300.0 |
| 2002-01-17 15:00:00 | QQQ | ETF | 39.59 | 39.97 | 39.55 | 39.85 | 13359600.0 |
| 2002-01-17 16:00:00 | QQQ | ETF | 39.87 | 39.9 | 39.03 | 39.18 | 5038500.0 |
| 2002-01-17 17:00:00 | QQQ | ETF | 39.18 | 39.21 | 39.05 | 39.13 | 620900.0 |
| 2002-01-17 18:00:00 | QQQ | ETF | 39.15 | 39.4 | 38.81 | 38.82 | 1243600.0 |
| 2002-01-17 09:00:00 | IWM | ETF | 47.75 | 47.845 | 47.49 | 47.49 | 176000.0 |
| 2002-01-17 10:00:00 | IWM | ETF | 47.55 | 47.55 | 47.285 | 47.345 | 58000.0 |
| 2002-01-17 11:00:00 | IWM | ETF | 47.35 | 47.395 | 47.26 | 47.28 | 72200.0 |
| 2002-01-17 12:00:00 | IWM | ETF | 47.315 | 47.545 | 47.315 | 47.525 | 81400.0 |
| 2002-01-17 13:00:00 | IWM | ETF | 47.525 | 47.525 | 47.445 | 47.445 | 22400.0 |
| 2002-01-17 14:00:00 | IWM | ETF | 47.45 | 47.49 | 47.385 | 47.47 | 26600.0 |
| 2002-01-17 15:00:00 | IWM | ETF | 47.485 | 47.945 | 47.485 | 47.925 | 212800.0 |
| 2002-01-17 16:00:00 | IWM | ETF | 47.99 | 48.0 | 47.55 | 47.55 | 156600.0 |
| 2002-01-17 09:00:00 | DIA | ETF | 97.84 | 98.19 | 97.64 | 97.7 | 740700.0 |
| 2002-01-17 10:00:00 | DIA | ETF | 97.78 | 98.05 | 97.52 | 97.96 | 818200.0 |
| 2002-01-17 11:00:00 | DIA | ETF | 98.0 | 98.38 | 97.88 | 98.17 | 287600.0 |
| 2002-01-17 12:00:00 | DIA | ETF | 98.23 | 98.68 | 98.21 | 98.55 | 810000.0 |
| 2002-01-17 13:00:00 | DIA | ETF | 98.55 | 98.58 | 98.27 | 98.35 | 100700.0 |
| 2002-01-17 14:00:00 | DIA | ETF | 98.38 | 98.51 | 98.18 | 98.45 | 158200.0 |
| 2002-01-17 15:00:00 | DIA | ETF | 98.49 | 98.75 | 98.29 | 98.73 | 190700.0 |
| 2002-01-17 16:00:00 | DIA | ETF | 98.74 | 98.75 | 97.88 | 98.1 | 157200.0 |
| 2002-01-17 17:00:00 | DIA | ETF | 97.8 | 97.8 | 97.55 | 97.55 | 700.0 |
| 2002-01-17 18:00:00 | DIA | ETF | 97.69 | 97.7 | 97.65 | 97.65 | 600.0 |
> showing 38 of 285 rows — these rows as CSV