PREVIEW / etf_1hour / 2002-04-16
file: by_date/etf_1hour/2002/2002-04-16.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-04-16 09:00:00 | SPY | ETF | 111.7 | 112.4 | 111.67 | 112.26 | 2414200.0 |
| 2002-04-16 10:00:00 | SPY | ETF | 112.28 | 112.68 | 112.25 | 112.61 | 2813800.0 |
| 2002-04-16 11:00:00 | SPY | ETF | 112.55 | 112.88 | 112.55 | 112.66 | 1503600.0 |
| 2002-04-16 12:00:00 | SPY | ETF | 112.65 | 112.9 | 112.53 | 112.6 | 1256200.0 |
| 2002-04-16 13:00:00 | SPY | ETF | 112.6 | 112.95 | 112.55 | 112.82 | 988900.0 |
| 2002-04-16 14:00:00 | SPY | ETF | 112.83 | 113.09 | 112.75 | 113.06 | 1008800.0 |
| 2002-04-16 15:00:00 | SPY | ETF | 113.01 | 113.32 | 112.97 | 113.12 | 2829300.0 |
| 2002-04-16 16:00:00 | SPY | ETF | 113.09 | 113.65 | 112.64 | 113.65 | 1231800.0 |
| 2002-04-16 17:00:00 | SPY | ETF | 113.65 | 113.72 | 113.33 | 113.56 | 275300.0 |
| 2002-04-16 18:00:00 | SPY | ETF | 113.53 | 113.57 | 113.42 | 113.57 | 19800.0 |
| 2002-04-16 09:00:00 | QQQ | ETF | 34.43 | 34.74 | 34.41 | 34.68 | 14065300.0 |
| 2002-04-16 10:00:00 | QQQ | ETF | 34.67 | 34.98 | 34.61 | 34.9 | 18821300.0 |
| 2002-04-16 11:00:00 | QQQ | ETF | 34.9 | 35.07 | 34.86 | 34.93 | 6600600.0 |
| 2002-04-16 12:00:00 | QQQ | ETF | 34.93 | 35.02 | 34.87 | 34.94 | 4542200.0 |
| 2002-04-16 13:00:00 | QQQ | ETF | 34.92 | 35.05 | 34.86 | 35.02 | 4125100.0 |
| 2002-04-16 14:00:00 | QQQ | ETF | 35.0 | 35.18 | 34.96 | 35.14 | 6337500.0 |
| 2002-04-16 15:00:00 | QQQ | ETF | 35.13 | 35.22 | 34.99 | 35.15 | 8920500.0 |
| 2002-04-16 16:00:00 | QQQ | ETF | 35.15 | 35.7 | 34.2 | 35.66 | 5138500.0 |
| 2002-04-16 17:00:00 | QQQ | ETF | 35.68 | 35.74 | 35.3 | 35.45 | 1514100.0 |
| 2002-04-16 18:00:00 | QQQ | ETF | 35.45 | 35.57 | 35.41 | 35.57 | 86800.0 |
| 2002-04-16 09:00:00 | IWM | ETF | 51.45 | 51.62 | 51.375 | 51.55 | 128400.0 |
| 2002-04-16 10:00:00 | IWM | ETF | 51.7 | 51.74 | 51.55 | 51.62 | 131400.0 |
| 2002-04-16 11:00:00 | IWM | ETF | 51.615 | 51.75 | 51.615 | 51.7 | 387200.0 |
| 2002-04-16 12:00:00 | IWM | ETF | 51.695 | 51.825 | 51.635 | 51.715 | 62800.0 |
| 2002-04-16 13:00:00 | IWM | ETF | 51.76 | 51.845 | 51.68 | 51.845 | 35800.0 |
| 2002-04-16 14:00:00 | IWM | ETF | 51.865 | 51.945 | 51.78 | 51.945 | 113400.0 |
| 2002-04-16 15:00:00 | IWM | ETF | 51.89 | 52.105 | 51.885 | 52.105 | 384200.0 |
| 2002-04-16 16:00:00 | IWM | ETF | 52.12 | 52.15 | 52.06 | 52.06 | 40600.0 |
| 2002-04-16 09:00:00 | DIA | ETF | 102.27 | 102.54 | 102.01 | 102.47 | 710100.0 |
| 2002-04-16 10:00:00 | DIA | ETF | 102.47 | 102.84 | 102.38 | 102.73 | 381700.0 |
| 2002-04-16 11:00:00 | DIA | ETF | 102.77 | 103.0 | 102.76 | 102.83 | 292200.0 |
| 2002-04-16 12:00:00 | DIA | ETF | 102.8 | 102.99 | 102.64 | 102.7 | 120400.0 |
| 2002-04-16 13:00:00 | DIA | ETF | 102.71 | 102.97 | 102.63 | 102.81 | 102700.0 |
| 2002-04-16 14:00:00 | DIA | ETF | 102.89 | 103.03 | 102.74 | 102.98 | 182200.0 |
| 2002-04-16 15:00:00 | DIA | ETF | 102.96 | 103.23 | 102.96 | 103.09 | 627400.0 |
| 2002-04-16 16:00:00 | DIA | ETF | 103.12 | 103.82 | 103.08 | 103.82 | 86200.0 |
| 2002-04-16 17:00:00 | DIA | ETF | 103.8 | 103.85 | 103.75 | 103.8 | 3600.0 |
| 2002-04-16 18:00:00 | DIA | ETF | 103.9 | 103.99 | 103.85 | 103.99 | 1800.0 |
> showing 38 of 308 rows — these rows as CSV