PREVIEW / etf_1hour / 2002-04-19
file: by_date/etf_1hour/2002/2002-04-19.parquet size: 13 KB rows: 292
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-19 09:00:00 | SPY | ETF | 113.2 | 113.24 | 112.89 | 112.9 | 2328300.0 |
| 2002-04-19 10:00:00 | SPY | ETF | 112.91 | 113.04 | 112.58 | 112.77 | 1588700.0 |
| 2002-04-19 11:00:00 | SPY | ETF | 112.77 | 113.09 | 112.62 | 112.95 | 1080800.0 |
| 2002-04-19 12:00:00 | SPY | ETF | 112.98 | 113.15 | 112.87 | 113.01 | 679700.0 |
| 2002-04-19 13:00:00 | SPY | ETF | 113.04 | 113.14 | 112.56 | 112.75 | 1687500.0 |
| 2002-04-19 14:00:00 | SPY | ETF | 112.76 | 112.98 | 112.67 | 112.83 | 1131700.0 |
| 2002-04-19 15:00:00 | SPY | ETF | 112.84 | 112.97 | 112.67 | 112.85 | 836700.0 |
| 2002-04-19 16:00:00 | SPY | ETF | 112.83 | 112.93 | 112.72 | 112.84 | 606200.0 |
| 2002-04-19 09:00:00 | QQQ | ETF | 35.05 | 35.06 | 34.75 | 34.76 | 11574900.0 |
| 2002-04-19 10:00:00 | QQQ | ETF | 34.77 | 34.85 | 34.48 | 34.58 | 15185900.0 |
| 2002-04-19 11:00:00 | QQQ | ETF | 34.58 | 34.66 | 34.42 | 34.58 | 6256900.0 |
| 2002-04-19 12:00:00 | QQQ | ETF | 34.57 | 34.74 | 34.54 | 34.68 | 2795100.0 |
| 2002-04-19 13:00:00 | QQQ | ETF | 34.68 | 34.79 | 34.38 | 34.53 | 5401300.0 |
| 2002-04-19 14:00:00 | QQQ | ETF | 34.53 | 34.73 | 34.48 | 34.67 | 5020100.0 |
| 2002-04-19 15:00:00 | QQQ | ETF | 34.66 | 34.68 | 34.46 | 34.5 | 7202400.0 |
| 2002-04-19 16:00:00 | QQQ | ETF | 34.48 | 34.65 | 34.42 | 34.47 | 4579000.0 |
| 2002-04-19 17:00:00 | QQQ | ETF | 34.46 | 34.5 | 34.4 | 34.48 | 67800.0 |
| 2002-04-19 18:00:00 | QQQ | ETF | 34.49 | 34.5 | 34.43 | 34.43 | 11200.0 |
| 2002-04-19 09:00:00 | IWM | ETF | 51.8 | 51.82 | 51.625 | 51.68 | 142000.0 |
| 2002-04-19 10:00:00 | IWM | ETF | 51.65 | 51.68 | 51.5 | 51.525 | 151400.0 |
| 2002-04-19 11:00:00 | IWM | ETF | 51.55 | 51.595 | 51.485 | 51.595 | 21400.0 |
| 2002-04-19 12:00:00 | IWM | ETF | 51.605 | 51.655 | 51.53 | 51.64 | 153800.0 |
| 2002-04-19 13:00:00 | IWM | ETF | 51.655 | 51.7 | 51.575 | 51.61 | 41200.0 |
| 2002-04-19 14:00:00 | IWM | ETF | 51.61 | 51.68 | 51.54 | 51.59 | 15600.0 |
| 2002-04-19 15:00:00 | IWM | ETF | 51.66 | 51.69 | 51.46 | 51.535 | 213600.0 |
| 2002-04-19 16:00:00 | IWM | ETF | 51.45 | 51.45 | 51.45 | 51.45 | 200.0 |
| 2002-04-19 09:00:00 | DIA | ETF | 102.85 | 102.91 | 102.48 | 102.49 | 822700.0 |
| 2002-04-19 10:00:00 | DIA | ETF | 102.5 | 102.62 | 102.2 | 102.31 | 385000.0 |
| 2002-04-19 11:00:00 | DIA | ETF | 102.37 | 102.65 | 102.2 | 102.57 | 132100.0 |
| 2002-04-19 12:00:00 | DIA | ETF | 102.6 | 102.74 | 102.48 | 102.6 | 167400.0 |
| 2002-04-19 13:00:00 | DIA | ETF | 102.6 | 102.78 | 102.2 | 102.4 | 221900.0 |
| 2002-04-19 14:00:00 | DIA | ETF | 102.4 | 102.62 | 102.3 | 102.44 | 210600.0 |
| 2002-04-19 15:00:00 | DIA | ETF | 102.44 | 102.63 | 102.3 | 102.59 | 178500.0 |
| 2002-04-19 16:00:00 | DIA | ETF | 102.57 | 102.8 | 102.54 | 102.8 | 63200.0 |
| 2002-04-19 17:00:00 | DIA | ETF | 102.82 | 102.87 | 102.82 | 102.87 | 2200.0 |
> showing 35 of 292 rows — these rows as CSV