PREVIEW / etf_1hour / 2001-11-30
file: by_date/etf_1hour/2001/2001-11-30.parquet size: 13 KB rows: 278
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 |
|---|---|---|---|---|---|---|---|
| 2001-11-30 09:00:00 | SPY | ETF | 114.4 | 114.65 | 114.05 | 114.28 | 1495200.0 |
| 2001-11-30 10:00:00 | SPY | ETF | 114.1 | 114.82 | 114.02 | 114.39 | 3059600.0 |
| 2001-11-30 11:00:00 | SPY | ETF | 114.4 | 114.67 | 114.28 | 114.6 | 934600.0 |
| 2001-11-30 12:00:00 | SPY | ETF | 114.62 | 114.8 | 114.51 | 114.6 | 922700.0 |
| 2001-11-30 13:00:00 | SPY | ETF | 114.6 | 114.67 | 114.31 | 114.39 | 839500.0 |
| 2001-11-30 14:00:00 | SPY | ETF | 114.39 | 114.9 | 114.28 | 114.76 | 2258000.0 |
| 2001-11-30 15:00:00 | SPY | ETF | 114.77 | 114.91 | 114.24 | 114.3 | 2875800.0 |
| 2001-11-30 16:00:00 | SPY | ETF | 114.3 | 114.47 | 114.02 | 114.02 | 1092300.0 |
| 2001-11-30 09:00:00 | QQQ | ETF | 39.73 | 39.86 | 39.4 | 39.45 | 9760200.0 |
| 2001-11-30 10:00:00 | QQQ | ETF | 39.47 | 40.04 | 39.36 | 39.75 | 16603300.0 |
| 2001-11-30 11:00:00 | QQQ | ETF | 39.76 | 39.91 | 39.61 | 39.84 | 6154000.0 |
| 2001-11-30 12:00:00 | QQQ | ETF | 39.82 | 40.0 | 39.63 | 39.74 | 6346700.0 |
| 2001-11-30 13:00:00 | QQQ | ETF | 39.74 | 39.78 | 39.46 | 39.49 | 7238700.0 |
| 2001-11-30 14:00:00 | QQQ | ETF | 39.49 | 39.95 | 39.44 | 39.86 | 7437800.0 |
| 2001-11-30 15:00:00 | QQQ | ETF | 39.86 | 39.96 | 39.41 | 39.73 | 10145800.0 |
| 2001-11-30 16:00:00 | QQQ | ETF | 39.73 | 39.83 | 39.51 | 39.66 | 1763000.0 |
| 2001-11-30 17:00:00 | QQQ | ETF | 39.75 | 39.75 | 39.65 | 39.7 | 310600.0 |
| 2001-11-30 18:00:00 | QQQ | ETF | 39.7 | 39.75 | 39.65 | 39.65 | 3900.0 |
| 2001-11-30 09:00:00 | IWM | ETF | 46.2 | 46.2 | 45.975 | 45.975 | 58400.0 |
| 2001-11-30 10:00:00 | IWM | ETF | 45.955 | 46.285 | 45.885 | 46.235 | 127400.0 |
| 2001-11-30 11:00:00 | IWM | ETF | 46.15 | 46.205 | 46.08 | 46.165 | 15200.0 |
| 2001-11-30 12:00:00 | IWM | ETF | 46.115 | 46.19 | 46.025 | 46.11 | 46000.0 |
| 2001-11-30 13:00:00 | IWM | ETF | 46.05 | 46.095 | 45.935 | 46.03 | 11600.0 |
| 2001-11-30 14:00:00 | IWM | ETF | 45.955 | 46.165 | 45.955 | 46.165 | 23000.0 |
| 2001-11-30 15:00:00 | IWM | ETF | 46.1 | 46.17 | 45.85 | 45.85 | 354400.0 |
| 2001-11-30 16:00:00 | IWM | ETF | 45.7 | 45.8 | 45.7 | 45.8 | 103000.0 |
| 2001-11-30 09:00:00 | DIA | ETF | 98.42 | 98.76 | 98.32 | 98.35 | 435500.0 |
| 2001-11-30 10:00:00 | DIA | ETF | 98.1 | 98.94 | 98.1 | 98.52 | 611900.0 |
| 2001-11-30 11:00:00 | DIA | ETF | 98.57 | 98.81 | 98.48 | 98.77 | 94800.0 |
| 2001-11-30 12:00:00 | DIA | ETF | 98.82 | 98.95 | 98.67 | 98.8 | 780200.0 |
| 2001-11-30 13:00:00 | DIA | ETF | 98.79 | 98.91 | 98.61 | 98.67 | 460400.0 |
| 2001-11-30 14:00:00 | DIA | ETF | 98.68 | 99.14 | 98.6 | 99.0 | 357500.0 |
| 2001-11-30 15:00:00 | DIA | ETF | 99.0 | 99.15 | 98.5 | 98.68 | 378500.0 |
| 2001-11-30 16:00:00 | DIA | ETF | 98.78 | 98.78 | 98.56 | 98.59 | 123300.0 |
> showing 34 of 278 rows — these rows as CSV