PREVIEW / etf_1hour / 2002-09-13
file: by_date/etf_1hour/2002/2002-09-13.parquet size: 14 KB rows: 320
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-09-13 09:00:00 | SPY | ETF | 88.69 | 88.82 | 88.25 | 88.53 | 5915500.0 |
| 2002-09-13 10:00:00 | SPY | ETF | 88.52 | 89.66 | 88.34 | 89.08 | 9966800.0 |
| 2002-09-13 11:00:00 | SPY | ETF | 89.1 | 89.38 | 88.6 | 89.35 | 4162600.0 |
| 2002-09-13 12:00:00 | SPY | ETF | 89.3 | 89.59 | 89.09 | 89.56 | 4532200.0 |
| 2002-09-13 13:00:00 | SPY | ETF | 89.53 | 89.9 | 89.2 | 89.24 | 3210400.0 |
| 2002-09-13 14:00:00 | SPY | ETF | 89.24 | 89.4 | 88.9 | 89.16 | 5013500.0 |
| 2002-09-13 15:00:00 | SPY | ETF | 89.16 | 89.85 | 89.06 | 89.54 | 5825200.0 |
| 2002-09-13 16:00:00 | SPY | ETF | 89.48 | 89.8 | 89.42 | 89.67 | 1287300.0 |
| 2002-09-13 09:00:00 | QQQ | ETF | 22.6 | 22.8 | 22.52 | 22.78 | 14819700.0 |
| 2002-09-13 10:00:00 | QQQ | ETF | 22.77 | 23.08 | 22.65 | 22.82 | 19438700.0 |
| 2002-09-13 11:00:00 | QQQ | ETF | 22.81 | 22.88 | 22.56 | 22.86 | 8749200.0 |
| 2002-09-13 12:00:00 | QQQ | ETF | 22.85 | 22.98 | 22.73 | 22.94 | 5851000.0 |
| 2002-09-13 13:00:00 | QQQ | ETF | 22.94 | 23.07 | 22.82 | 22.84 | 8596500.0 |
| 2002-09-13 14:00:00 | QQQ | ETF | 22.84 | 22.92 | 22.71 | 22.87 | 6752800.0 |
| 2002-09-13 15:00:00 | QQQ | ETF | 22.85 | 23.03 | 22.8 | 22.95 | 9251300.0 |
| 2002-09-13 16:00:00 | QQQ | ETF | 22.95 | 23.03 | 22.94 | 22.99 | 1314400.0 |
| 2002-09-13 09:00:00 | IWM | ETF | 38.3 | 38.3 | 38.125 | 38.2 | 320000.0 |
| 2002-09-13 10:00:00 | IWM | ETF | 38.215 | 38.61 | 38.2 | 38.545 | 302600.0 |
| 2002-09-13 11:00:00 | IWM | ETF | 38.475 | 38.555 | 38.375 | 38.52 | 127400.0 |
| 2002-09-13 12:00:00 | IWM | ETF | 38.52 | 38.59 | 38.445 | 38.59 | 86600.0 |
| 2002-09-13 13:00:00 | IWM | ETF | 38.515 | 38.7 | 38.515 | 38.63 | 118400.0 |
| 2002-09-13 14:00:00 | IWM | ETF | 38.65 | 38.7 | 38.51 | 38.585 | 139200.0 |
| 2002-09-13 15:00:00 | IWM | ETF | 38.6 | 38.86 | 38.6 | 38.775 | 235400.0 |
| 2002-09-13 16:00:00 | IWM | ETF | 38.86 | 38.86 | 38.825 | 38.85 | 74000.0 |
| 2002-09-13 09:00:00 | DIA | ETF | 83.44 | 83.44 | 82.7 | 82.98 | 1801100.0 |
| 2002-09-13 10:00:00 | DIA | ETF | 82.9 | 83.73 | 82.77 | 83.23 | 2484600.0 |
| 2002-09-13 11:00:00 | DIA | ETF | 83.22 | 83.45 | 82.77 | 83.4 | 1183100.0 |
| 2002-09-13 12:00:00 | DIA | ETF | 83.36 | 83.66 | 83.15 | 83.6 | 598300.0 |
| 2002-09-13 13:00:00 | DIA | ETF | 83.6 | 83.87 | 83.23 | 83.28 | 667300.0 |
| 2002-09-13 14:00:00 | DIA | ETF | 83.27 | 83.38 | 82.85 | 83.05 | 1487900.0 |
| 2002-09-13 15:00:00 | DIA | ETF | 83.03 | 83.65 | 82.95 | 83.35 | 1047700.0 |
| 2002-09-13 16:00:00 | DIA | ETF | 83.34 | 83.53 | 83.27 | 83.53 | 122000.0 |
| 2002-09-13 09:00:00 | TLT | ETF | 88.33 | 88.49 | 88.22 | 88.35 | 25200.0 |
| 2002-09-13 10:00:00 | TLT | ETF | 88.34 | 88.37 | 88.18 | 88.3 | 76700.0 |
| 2002-09-13 11:00:00 | TLT | ETF | 88.48 | 88.66 | 88.4 | 88.46 | 6200.0 |
| 2002-09-13 12:00:00 | TLT | ETF | 88.44 | 88.56 | 88.3 | 88.3 | 4200.0 |
| 2002-09-13 13:00:00 | TLT | ETF | 88.25 | 88.63 | 88.25 | 88.63 | 1600.0 |
| 2002-09-13 14:00:00 | TLT | ETF | 88.66 | 88.94 | 88.66 | 88.86 | 1500.0 |
| 2002-09-13 15:00:00 | TLT | ETF | 88.67 | 88.78 | 88.66 | 88.78 | 39700.0 |
> showing 39 of 320 rows — these rows as CSV