PREVIEW / etf_1hour / 2002-04-11
file: by_date/etf_1hour/2002/2002-04-11.parquet size: 14 KB rows: 318
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-04-11 09:00:00 | SPY | ETF | 112.89 | 113.05 | 112.65 | 112.72 | 2524400.0 |
| 2002-04-11 10:00:00 | SPY | ETF | 112.72 | 112.98 | 111.62 | 111.71 | 4972300.0 |
| 2002-04-11 11:00:00 | SPY | ETF | 111.74 | 111.94 | 111.5 | 111.78 | 2105900.0 |
| 2002-04-11 12:00:00 | SPY | ETF | 111.77 | 111.81 | 111.32 | 111.47 | 1528600.0 |
| 2002-04-11 13:00:00 | SPY | ETF | 111.45 | 111.52 | 111.03 | 111.42 | 2453100.0 |
| 2002-04-11 14:00:00 | SPY | ETF | 111.41 | 111.54 | 111.02 | 111.14 | 2837900.0 |
| 2002-04-11 15:00:00 | SPY | ETF | 111.14 | 111.18 | 110.5 | 110.72 | 5912900.0 |
| 2002-04-11 16:00:00 | SPY | ETF | 110.72 | 111.18 | 110.51 | 110.6 | 1253100.0 |
| 2002-04-11 17:00:00 | SPY | ETF | 110.59 | 111.36 | 110.59 | 111.2 | 324000.0 |
| 2002-04-11 18:00:00 | SPY | ETF | 111.2 | 111.27 | 111.15 | 111.26 | 2000.0 |
| 2002-04-11 09:00:00 | QQQ | ETF | 33.66 | 33.85 | 33.51 | 33.6 | 6621800.0 |
| 2002-04-11 10:00:00 | QQQ | ETF | 33.6 | 33.85 | 33.17 | 33.27 | 16019200.0 |
| 2002-04-11 11:00:00 | QQQ | ETF | 33.28 | 33.52 | 33.17 | 33.37 | 11516000.0 |
| 2002-04-11 12:00:00 | QQQ | ETF | 33.37 | 33.41 | 33.11 | 33.25 | 12763400.0 |
| 2002-04-11 13:00:00 | QQQ | ETF | 33.24 | 33.39 | 33.05 | 33.32 | 9248300.0 |
| 2002-04-11 14:00:00 | QQQ | ETF | 33.33 | 33.43 | 33.14 | 33.21 | 6917400.0 |
| 2002-04-11 15:00:00 | QQQ | ETF | 33.22 | 33.25 | 32.88 | 33.0 | 20892000.0 |
| 2002-04-11 16:00:00 | QQQ | ETF | 33.0 | 33.4 | 32.9 | 33.05 | 2321000.0 |
| 2002-04-11 17:00:00 | QQQ | ETF | 33.08 | 33.48 | 33.05 | 33.36 | 558900.0 |
| 2002-04-11 18:00:00 | QQQ | ETF | 33.32 | 33.4 | 33.05 | 33.32 | 33100.0 |
| 2002-04-11 09:00:00 | IWM | ETF | 50.825 | 50.975 | 50.73 | 50.9 | 321200.0 |
| 2002-04-11 10:00:00 | IWM | ETF | 50.92 | 50.945 | 50.68 | 50.69 | 72200.0 |
| 2002-04-11 11:00:00 | IWM | ETF | 50.725 | 50.795 | 50.625 | 50.795 | 79400.0 |
| 2002-04-11 12:00:00 | IWM | ETF | 50.77 | 50.78 | 50.625 | 50.635 | 74400.0 |
| 2002-04-11 13:00:00 | IWM | ETF | 50.7 | 50.73 | 50.495 | 50.62 | 88400.0 |
| 2002-04-11 14:00:00 | IWM | ETF | 50.615 | 50.725 | 50.55 | 50.645 | 233200.0 |
| 2002-04-11 15:00:00 | IWM | ETF | 50.635 | 50.635 | 50.035 | 50.035 | 426800.0 |
| 2002-04-11 16:00:00 | IWM | ETF | 50.02 | 50.135 | 50.01 | 50.055 | 93600.0 |
| 2002-04-11 09:00:00 | DIA | ETF | 103.43 | 103.82 | 103.38 | 103.5 | 396500.0 |
| 2002-04-11 10:00:00 | DIA | ETF | 103.48 | 103.82 | 102.74 | 102.86 | 650700.0 |
| 2002-04-11 11:00:00 | DIA | ETF | 102.86 | 103.05 | 102.55 | 102.84 | 771600.0 |
| 2002-04-11 12:00:00 | DIA | ETF | 102.85 | 102.95 | 102.55 | 102.66 | 456600.0 |
| 2002-04-11 13:00:00 | DIA | ETF | 102.65 | 102.65 | 102.2 | 102.58 | 224500.0 |
| 2002-04-11 14:00:00 | DIA | ETF | 102.58 | 102.62 | 102.02 | 102.12 | 359700.0 |
| 2002-04-11 15:00:00 | DIA | ETF | 102.12 | 102.2 | 101.62 | 101.83 | 1205600.0 |
| 2002-04-11 16:00:00 | DIA | ETF | 101.82 | 101.88 | 101.5 | 101.5 | 158000.0 |
| 2002-04-11 17:00:00 | DIA | ETF | 102.2 | 102.4 | 102.0 | 102.28 | 3800.0 |
| 2002-04-11 18:00:00 | DIA | ETF | 102.2 | 102.2 | 102.2 | 102.2 | 400.0 |
> showing 38 of 318 rows — these rows as CSV