PREVIEW / etf_1hour / 2002-06-14
file: by_date/etf_1hour/2002/2002-06-14.parquet size: 14 KB rows: 313
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-06-14 09:00:00 | SPY | ETF | 100.31 | 100.4 | 98.5 | 98.61 | 6637700.0 |
| 2002-06-14 10:00:00 | SPY | ETF | 98.65 | 100.45 | 98.5 | 100.26 | 11302800.0 |
| 2002-06-14 11:00:00 | SPY | ETF | 100.26 | 100.99 | 99.8 | 100.6 | 5890100.0 |
| 2002-06-14 12:00:00 | SPY | ETF | 100.53 | 100.91 | 99.95 | 100.26 | 2311500.0 |
| 2002-06-14 13:00:00 | SPY | ETF | 100.3 | 100.56 | 100.05 | 100.54 | 1089300.0 |
| 2002-06-14 14:00:00 | SPY | ETF | 100.54 | 101.56 | 100.42 | 101.26 | 5901200.0 |
| 2002-06-14 15:00:00 | SPY | ETF | 101.22 | 101.49 | 100.74 | 101.29 | 3013900.0 |
| 2002-06-14 16:00:00 | SPY | ETF | 101.27 | 101.5 | 100.75 | 101.4 | 2274300.0 |
| 2002-06-14 17:00:00 | SPY | ETF | 101.4 | 101.53 | 101.4 | 101.53 | 9100.0 |
| 2002-06-14 09:00:00 | QQQ | ETF | 26.86 | 26.94 | 26.25 | 26.27 | 18971400.0 |
| 2002-06-14 10:00:00 | QQQ | ETF | 26.26 | 27.23 | 26.2 | 27.13 | 33552600.0 |
| 2002-06-14 11:00:00 | QQQ | ETF | 27.13 | 27.44 | 26.91 | 27.26 | 15502100.0 |
| 2002-06-14 12:00:00 | QQQ | ETF | 27.28 | 27.46 | 27.0 | 27.19 | 10739200.0 |
| 2002-06-14 13:00:00 | QQQ | ETF | 27.2 | 27.28 | 27.02 | 27.26 | 6156000.0 |
| 2002-06-14 14:00:00 | QQQ | ETF | 27.24 | 27.7 | 27.18 | 27.57 | 15446400.0 |
| 2002-06-14 15:00:00 | QQQ | ETF | 27.57 | 27.72 | 27.31 | 27.62 | 15964700.0 |
| 2002-06-14 16:00:00 | QQQ | ETF | 27.57 | 27.7 | 27.53 | 27.62 | 2271400.0 |
| 2002-06-14 17:00:00 | QQQ | ETF | 27.63 | 27.75 | 27.63 | 27.7 | 48000.0 |
| 2002-06-14 18:00:00 | QQQ | ETF | 27.68 | 27.7 | 27.66 | 27.69 | 20500.0 |
| 2002-06-14 09:00:00 | IWM | ETF | 44.8 | 45.01 | 44.445 | 44.495 | 136600.0 |
| 2002-06-14 10:00:00 | IWM | ETF | 44.495 | 44.875 | 44.255 | 44.875 | 512600.0 |
| 2002-06-14 11:00:00 | IWM | ETF | 44.875 | 45.5 | 44.875 | 45.485 | 493600.0 |
| 2002-06-14 12:00:00 | IWM | ETF | 45.415 | 45.625 | 45.23 | 45.245 | 595000.0 |
| 2002-06-14 13:00:00 | IWM | ETF | 45.33 | 45.415 | 45.245 | 45.4 | 219600.0 |
| 2002-06-14 14:00:00 | IWM | ETF | 45.405 | 45.6 | 45.405 | 45.575 | 481600.0 |
| 2002-06-14 15:00:00 | IWM | ETF | 45.595 | 45.75 | 45.25 | 45.75 | 459000.0 |
| 2002-06-14 16:00:00 | IWM | ETF | 45.8 | 45.8 | 45.55 | 45.55 | 379200.0 |
| 2002-06-14 09:00:00 | DIA | ETF | 94.01 | 94.31 | 92.75 | 93.0 | 1104200.0 |
| 2002-06-14 10:00:00 | DIA | ETF | 92.98 | 94.15 | 92.56 | 94.11 | 1355100.0 |
| 2002-06-14 11:00:00 | DIA | ETF | 94.1 | 94.65 | 93.57 | 94.35 | 641600.0 |
| 2002-06-14 12:00:00 | DIA | ETF | 94.39 | 94.7 | 93.79 | 94.12 | 457600.0 |
| 2002-06-14 13:00:00 | DIA | ETF | 94.09 | 94.17 | 93.66 | 94.06 | 943200.0 |
| 2002-06-14 14:00:00 | DIA | ETF | 94.06 | 95.11 | 94.0 | 94.75 | 1549900.0 |
| 2002-06-14 15:00:00 | DIA | ETF | 94.75 | 95.14 | 94.37 | 94.91 | 753400.0 |
| 2002-06-14 16:00:00 | DIA | ETF | 94.94 | 95.07 | 94.9 | 95.0 | 239200.0 |
| 2002-06-14 17:00:00 | DIA | ETF | 95.1 | 95.14 | 95.0 | 95.0 | 106600.0 |
> showing 36 of 313 rows — these rows as CSV