PREVIEW / etf_1hour / 2002-08-13
file: by_date/etf_1hour/2002/2002-08-13.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-13 09:00:00 | SPY | ETF | 90.15 | 90.6 | 90.08 | 90.43 | 2106800.0 |
| 2002-08-13 10:00:00 | SPY | ETF | 90.4 | 91.39 | 90.26 | 91.36 | 4629800.0 |
| 2002-08-13 11:00:00 | SPY | ETF | 91.3 | 91.66 | 91.26 | 91.41 | 2665700.0 |
| 2002-08-13 12:00:00 | SPY | ETF | 91.4 | 91.48 | 91.17 | 91.3 | 2884300.0 |
| 2002-08-13 13:00:00 | SPY | ETF | 91.27 | 91.4 | 90.96 | 91.35 | 2265200.0 |
| 2002-08-13 14:00:00 | SPY | ETF | 91.34 | 91.58 | 90.12 | 90.5 | 16342700.0 |
| 2002-08-13 15:00:00 | SPY | ETF | 90.51 | 90.75 | 88.67 | 88.75 | 13887800.0 |
| 2002-08-13 16:00:00 | SPY | ETF | 88.73 | 88.99 | 88.66 | 88.97 | 1705800.0 |
| 2002-08-13 09:00:00 | QQQ | ETF | 23.23 | 23.52 | 23.17 | 23.4 | 8121300.0 |
| 2002-08-13 10:00:00 | QQQ | ETF | 23.41 | 23.85 | 23.36 | 23.81 | 11074600.0 |
| 2002-08-13 11:00:00 | QQQ | ETF | 23.8 | 23.87 | 23.7 | 23.71 | 5772700.0 |
| 2002-08-13 12:00:00 | QQQ | ETF | 23.71 | 23.74 | 23.56 | 23.64 | 3974900.0 |
| 2002-08-13 13:00:00 | QQQ | ETF | 23.63 | 23.65 | 23.45 | 23.56 | 4632500.0 |
| 2002-08-13 14:00:00 | QQQ | ETF | 23.56 | 23.75 | 23.1 | 23.21 | 22114200.0 |
| 2002-08-13 15:00:00 | QQQ | ETF | 23.21 | 23.35 | 22.55 | 22.6 | 25462300.0 |
| 2002-08-13 16:00:00 | QQQ | ETF | 22.6 | 22.65 | 22.57 | 22.6 | 508300.0 |
| 2002-08-13 09:00:00 | IWM | ETF | 38.55 | 38.73 | 38.44 | 38.7 | 165600.0 |
| 2002-08-13 10:00:00 | IWM | ETF | 38.665 | 38.9 | 38.61 | 38.895 | 274400.0 |
| 2002-08-13 11:00:00 | IWM | ETF | 38.91 | 38.91 | 38.735 | 38.735 | 158400.0 |
| 2002-08-13 12:00:00 | IWM | ETF | 38.75 | 38.8 | 38.575 | 38.615 | 92600.0 |
| 2002-08-13 13:00:00 | IWM | ETF | 38.615 | 38.65 | 38.5 | 38.5 | 51800.0 |
| 2002-08-13 14:00:00 | IWM | ETF | 38.51 | 38.75 | 38.11 | 38.12 | 428200.0 |
| 2002-08-13 15:00:00 | IWM | ETF | 38.15 | 38.3 | 37.575 | 37.65 | 786000.0 |
| 2002-08-13 16:00:00 | IWM | ETF | 37.575 | 37.645 | 37.45 | 37.5 | 56400.0 |
| 2002-08-13 09:00:00 | DIA | ETF | 86.53 | 86.61 | 86.2 | 86.39 | 754500.0 |
| 2002-08-13 10:00:00 | DIA | ETF | 86.39 | 87.36 | 86.3 | 87.35 | 957400.0 |
| 2002-08-13 11:00:00 | DIA | ETF | 87.31 | 87.66 | 87.2 | 87.35 | 948300.0 |
| 2002-08-13 12:00:00 | DIA | ETF | 87.32 | 87.45 | 87.13 | 87.25 | 397700.0 |
| 2002-08-13 13:00:00 | DIA | ETF | 87.22 | 87.28 | 86.83 | 87.2 | 764500.0 |
| 2002-08-13 14:00:00 | DIA | ETF | 87.12 | 87.44 | 86.05 | 86.29 | 4384100.0 |
| 2002-08-13 15:00:00 | DIA | ETF | 86.3 | 86.58 | 84.72 | 84.85 | 3092200.0 |
| 2002-08-13 16:00:00 | DIA | ETF | 84.77 | 85.05 | 84.75 | 84.95 | 51400.0 |
| 2002-08-13 09:00:00 | TLT | ETF | 85.78 | 85.78 | 85.63 | 85.69 | 3700.0 |
| 2002-08-13 10:00:00 | TLT | ETF | 85.7 | 85.74 | 85.46 | 85.58 | 3500.0 |
| 2002-08-13 11:00:00 | TLT | ETF | 85.5 | 85.76 | 85.5 | 85.64 | 5000.0 |
| 2002-08-13 12:00:00 | TLT | ETF | 85.72 | 85.72 | 85.52 | 85.55 | 6400.0 |
| 2002-08-13 13:00:00 | TLT | ETF | 85.48 | 85.63 | 85.46 | 85.63 | 13300.0 |
| 2002-08-13 14:00:00 | TLT | ETF | 85.4 | 86.23 | 85.37 | 86.23 | 21700.0 |
| 2002-08-13 15:00:00 | TLT | ETF | 86.03 | 86.47 | 86.03 | 86.47 | 19400.0 |
| 2002-08-13 16:00:00 | TLT | ETF | 86.45 | 86.45 | 86.45 | 86.45 | 1000.0 |
> showing 40 of 341 rows — these rows as CSV