PREVIEW / etf_1hour / 2002-06-12
file: by_date/etf_1hour/2002/2002-06-12.parquet size: 14 KB rows: 308
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-12 09:00:00 | SPY | ETF | 101.71 | 102.38 | 101.58 | 102.37 | 2591300.0 |
| 2002-06-12 10:00:00 | SPY | ETF | 102.4 | 102.47 | 101.71 | 101.71 | 3756500.0 |
| 2002-06-12 11:00:00 | SPY | ETF | 101.78 | 102.13 | 100.94 | 100.94 | 4921500.0 |
| 2002-06-12 12:00:00 | SPY | ETF | 100.97 | 101.48 | 100.78 | 101.47 | 2365500.0 |
| 2002-06-12 13:00:00 | SPY | ETF | 101.43 | 102.45 | 101.37 | 102.1 | 4690700.0 |
| 2002-06-12 14:00:00 | SPY | ETF | 102.1 | 102.35 | 101.4 | 101.74 | 3992400.0 |
| 2002-06-12 15:00:00 | SPY | ETF | 101.77 | 102.81 | 101.6 | 102.61 | 5157600.0 |
| 2002-06-12 16:00:00 | SPY | ETF | 102.64 | 102.8 | 102.45 | 102.8 | 2513500.0 |
| 2002-06-12 17:00:00 | SPY | ETF | 102.81 | 103.19 | 102.81 | 103.15 | 205400.0 |
| 2002-06-12 18:00:00 | SPY | ETF | 103.2 | 103.2 | 103.05 | 103.19 | 6500.0 |
| 2002-06-12 09:00:00 | QQQ | ETF | 27.24 | 27.57 | 27.11 | 27.57 | 13356500.0 |
| 2002-06-12 10:00:00 | QQQ | ETF | 27.57 | 27.67 | 27.15 | 27.18 | 22219700.0 |
| 2002-06-12 11:00:00 | QQQ | ETF | 27.18 | 27.89 | 26.85 | 26.9 | 24049400.0 |
| 2002-06-12 12:00:00 | QQQ | ETF | 26.88 | 27.41 | 26.83 | 27.39 | 15474500.0 |
| 2002-06-12 13:00:00 | QQQ | ETF | 27.37 | 27.87 | 27.37 | 27.65 | 25895500.0 |
| 2002-06-12 14:00:00 | QQQ | ETF | 27.66 | 27.72 | 27.2 | 27.5 | 19341100.0 |
| 2002-06-12 15:00:00 | QQQ | ETF | 27.51 | 27.96 | 27.35 | 27.92 | 23987900.0 |
| 2002-06-12 16:00:00 | QQQ | ETF | 27.93 | 27.96 | 27.78 | 27.96 | 2890100.0 |
| 2002-06-12 17:00:00 | QQQ | ETF | 27.97 | 28.14 | 27.92 | 28.12 | 879000.0 |
| 2002-06-12 18:00:00 | QQQ | ETF | 28.1 | 28.14 | 28.08 | 28.11 | 74100.0 |
| 2002-06-12 09:00:00 | IWM | ETF | 46.005 | 46.12 | 45.925 | 46.12 | 89800.0 |
| 2002-06-12 10:00:00 | IWM | ETF | 46.145 | 46.345 | 46.05 | 46.065 | 728600.0 |
| 2002-06-12 11:00:00 | IWM | ETF | 46.0 | 46.015 | 45.475 | 45.52 | 215400.0 |
| 2002-06-12 12:00:00 | IWM | ETF | 45.555 | 45.79 | 45.505 | 45.75 | 134600.0 |
| 2002-06-12 13:00:00 | IWM | ETF | 45.81 | 46.065 | 45.81 | 45.89 | 269800.0 |
| 2002-06-12 14:00:00 | IWM | ETF | 45.885 | 45.885 | 45.595 | 45.65 | 55000.0 |
| 2002-06-12 15:00:00 | IWM | ETF | 45.64 | 46.185 | 45.59 | 46.1 | 921800.0 |
| 2002-06-12 16:00:00 | IWM | ETF | 46.09 | 46.19 | 46.05 | 46.095 | 209400.0 |
| 2002-06-12 17:00:00 | IWM | ETF | 46.165 | 46.165 | 46.165 | 46.165 | 1562000.0 |
| 2002-06-12 09:00:00 | DIA | ETF | 95.14 | 95.86 | 95.07 | 95.77 | 347900.0 |
| 2002-06-12 10:00:00 | DIA | ETF | 95.8 | 95.82 | 95.35 | 95.36 | 563200.0 |
| 2002-06-12 11:00:00 | DIA | ETF | 95.35 | 95.65 | 94.84 | 94.87 | 455000.0 |
| 2002-06-12 12:00:00 | DIA | ETF | 94.87 | 95.24 | 94.68 | 95.15 | 820300.0 |
| 2002-06-12 13:00:00 | DIA | ETF | 95.16 | 95.99 | 95.12 | 95.7 | 806900.0 |
| 2002-06-12 14:00:00 | DIA | ETF | 95.83 | 95.87 | 95.09 | 95.42 | 663000.0 |
| 2002-06-12 15:00:00 | DIA | ETF | 95.46 | 96.62 | 95.28 | 96.45 | 875500.0 |
| 2002-06-12 16:00:00 | DIA | ETF | 96.39 | 96.5 | 96.3 | 96.45 | 126200.0 |
| 2002-06-12 17:00:00 | DIA | ETF | 96.73 | 96.75 | 96.49 | 96.49 | 1700.0 |
> showing 38 of 308 rows — these rows as CSV