PREVIEW / etf_1hour / 2002-08-16
file: by_date/etf_1hour/2002/2002-08-16.parquet size: 15 KB rows: 341
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-08-16 09:00:00 | SPY | ETF | 92.82 | 92.96 | 92.0 | 92.75 | 6556400.0 |
| 2002-08-16 10:00:00 | SPY | ETF | 92.77 | 93.48 | 92.57 | 93.3 | 6208500.0 |
| 2002-08-16 11:00:00 | SPY | ETF | 93.3 | 94.08 | 93.19 | 93.65 | 6451900.0 |
| 2002-08-16 12:00:00 | SPY | ETF | 93.58 | 93.8 | 93.09 | 93.31 | 2762900.0 |
| 2002-08-16 13:00:00 | SPY | ETF | 93.34 | 93.8 | 93.19 | 93.5 | 2359800.0 |
| 2002-08-16 14:00:00 | SPY | ETF | 93.5 | 93.83 | 93.25 | 93.74 | 1774500.0 |
| 2002-08-16 15:00:00 | SPY | ETF | 93.74 | 94.07 | 93.0 | 93.24 | 6498600.0 |
| 2002-08-16 16:00:00 | SPY | ETF | 93.22 | 93.39 | 93.15 | 93.22 | 1440200.0 |
| 2002-08-16 09:00:00 | QQQ | ETF | 24.13 | 24.3 | 23.73 | 24.21 | 21367200.0 |
| 2002-08-16 10:00:00 | QQQ | ETF | 24.18 | 24.59 | 24.05 | 24.56 | 19733500.0 |
| 2002-08-16 11:00:00 | QQQ | ETF | 24.58 | 24.96 | 24.53 | 24.67 | 16715100.0 |
| 2002-08-16 12:00:00 | QQQ | ETF | 24.72 | 24.8 | 24.51 | 24.62 | 7152900.0 |
| 2002-08-16 13:00:00 | QQQ | ETF | 24.63 | 24.85 | 24.56 | 24.76 | 5348500.0 |
| 2002-08-16 14:00:00 | QQQ | ETF | 24.76 | 24.92 | 24.66 | 24.86 | 5879900.0 |
| 2002-08-16 15:00:00 | QQQ | ETF | 24.87 | 25.0 | 24.66 | 24.73 | 13980800.0 |
| 2002-08-16 16:00:00 | QQQ | ETF | 24.71 | 24.79 | 24.7 | 24.7 | 724500.0 |
| 2002-08-16 09:00:00 | IWM | ETF | 38.825 | 38.935 | 38.64 | 38.885 | 508000.0 |
| 2002-08-16 10:00:00 | IWM | ETF | 38.9 | 39.13 | 38.885 | 39.13 | 145200.0 |
| 2002-08-16 11:00:00 | IWM | ETF | 39.075 | 39.6 | 39.075 | 39.43 | 829800.0 |
| 2002-08-16 12:00:00 | IWM | ETF | 39.5 | 39.5 | 39.205 | 39.25 | 247400.0 |
| 2002-08-16 13:00:00 | IWM | ETF | 39.3 | 39.455 | 39.245 | 39.335 | 100200.0 |
| 2002-08-16 14:00:00 | IWM | ETF | 39.4 | 39.555 | 39.315 | 39.53 | 158200.0 |
| 2002-08-16 15:00:00 | IWM | ETF | 39.54 | 39.665 | 39.275 | 39.45 | 194400.0 |
| 2002-08-16 16:00:00 | IWM | ETF | 39.45 | 39.625 | 39.45 | 39.475 | 55400.0 |
| 2002-08-16 09:00:00 | DIA | ETF | 87.62 | 87.92 | 87.12 | 87.59 | 1428900.0 |
| 2002-08-16 10:00:00 | DIA | ETF | 87.58 | 88.1 | 87.3 | 87.96 | 1636600.0 |
| 2002-08-16 11:00:00 | DIA | ETF | 87.88 | 88.56 | 87.71 | 88.01 | 1473300.0 |
| 2002-08-16 12:00:00 | DIA | ETF | 88.09 | 88.4 | 87.52 | 87.63 | 769400.0 |
| 2002-08-16 13:00:00 | DIA | ETF | 87.62 | 88.11 | 87.53 | 87.84 | 691300.0 |
| 2002-08-16 14:00:00 | DIA | ETF | 87.86 | 88.25 | 87.63 | 88.2 | 847500.0 |
| 2002-08-16 15:00:00 | DIA | ETF | 88.19 | 88.52 | 87.63 | 87.74 | 1446000.0 |
| 2002-08-16 16:00:00 | DIA | ETF | 87.76 | 87.85 | 87.7 | 87.73 | 85400.0 |
| 2002-08-16 09:00:00 | TLT | ETF | 86.44 | 86.52 | 86.26 | 86.26 | 5500.0 |
| 2002-08-16 10:00:00 | TLT | ETF | 86.24 | 86.24 | 85.37 | 85.37 | 24600.0 |
| 2002-08-16 11:00:00 | TLT | ETF | 85.25 | 85.39 | 85.0 | 85.28 | 14700.0 |
| 2002-08-16 12:00:00 | TLT | ETF | 85.24 | 85.38 | 85.1 | 85.37 | 19200.0 |
| 2002-08-16 13:00:00 | TLT | ETF | 85.35 | 85.4 | 84.9 | 84.9 | 14000.0 |
| 2002-08-16 14:00:00 | TLT | ETF | 84.94 | 85.07 | 84.82 | 84.88 | 2900.0 |
| 2002-08-16 15:00:00 | TLT | ETF | 84.96 | 85.06 | 84.85 | 85.06 | 4100.0 |
> showing 39 of 341 rows — these rows as CSV