PREVIEW / etf_1hour / 2001-11-15
file: by_date/etf_1hour/2001/2001-11-15.parquet size: 13 KB rows: 270
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-15 09:00:00 | SPY | ETF | 114.37 | 114.44 | 114.07 | 114.18 | 771000.0 |
| 2001-11-15 10:00:00 | SPY | ETF | 114.17 | 115.18 | 113.98 | 114.93 | 2687800.0 |
| 2001-11-15 11:00:00 | SPY | ETF | 114.9 | 115.0 | 114.52 | 114.67 | 1340400.0 |
| 2001-11-15 12:00:00 | SPY | ETF | 114.72 | 114.99 | 114.53 | 114.96 | 1720600.0 |
| 2001-11-15 13:00:00 | SPY | ETF | 114.92 | 115.01 | 114.24 | 114.27 | 4731000.0 |
| 2001-11-15 14:00:00 | SPY | ETF | 114.32 | 114.55 | 113.93 | 114.41 | 2879600.0 |
| 2001-11-15 15:00:00 | SPY | ETF | 114.41 | 114.68 | 114.12 | 114.6 | 1465100.0 |
| 2001-11-15 16:00:00 | SPY | ETF | 114.64 | 115.05 | 114.57 | 114.8 | 1036000.0 |
| 2001-11-15 17:00:00 | SPY | ETF | 114.79 | 114.86 | 114.79 | 114.86 | 5300.0 |
| 2001-11-15 18:00:00 | SPY | ETF | 114.84 | 114.9 | 114.78 | 114.78 | 1200.0 |
| 2001-11-15 09:00:00 | QQQ | ETF | 39.16 | 39.4 | 39.06 | 39.3 | 3981600.0 |
| 2001-11-15 10:00:00 | QQQ | ETF | 39.3 | 40.11 | 39.18 | 39.85 | 20275600.0 |
| 2001-11-15 11:00:00 | QQQ | ETF | 39.86 | 39.92 | 39.45 | 39.53 | 11812000.0 |
| 2001-11-15 12:00:00 | QQQ | ETF | 39.53 | 39.9 | 39.4 | 39.9 | 7027300.0 |
| 2001-11-15 13:00:00 | QQQ | ETF | 39.86 | 39.93 | 39.3 | 39.36 | 8214800.0 |
| 2001-11-15 14:00:00 | QQQ | ETF | 39.35 | 39.47 | 39.1 | 39.36 | 9996500.0 |
| 2001-11-15 15:00:00 | QQQ | ETF | 39.37 | 39.5 | 39.15 | 39.41 | 10842200.0 |
| 2001-11-15 16:00:00 | QQQ | ETF | 39.42 | 39.71 | 39.3 | 39.3 | 4415600.0 |
| 2001-11-15 17:00:00 | QQQ | ETF | 39.4 | 39.41 | 39.25 | 39.36 | 224900.0 |
| 2001-11-15 18:00:00 | QQQ | ETF | 39.36 | 39.36 | 39.35 | 39.35 | 8500.0 |
| 2001-11-15 09:00:00 | IWM | ETF | 44.875 | 44.925 | 44.675 | 44.925 | 4200.0 |
| 2001-11-15 10:00:00 | IWM | ETF | 44.75 | 45.2 | 44.75 | 45.1 | 62200.0 |
| 2001-11-15 11:00:00 | IWM | ETF | 45.085 | 45.125 | 44.935 | 44.94 | 27400.0 |
| 2001-11-15 12:00:00 | IWM | ETF | 44.88 | 45.125 | 44.88 | 45.045 | 39000.0 |
| 2001-11-15 13:00:00 | IWM | ETF | 45.07 | 45.07 | 44.88 | 44.925 | 40200.0 |
| 2001-11-15 14:00:00 | IWM | ETF | 44.875 | 44.9 | 44.795 | 44.85 | 44800.0 |
| 2001-11-15 15:00:00 | IWM | ETF | 44.855 | 44.895 | 44.8 | 44.815 | 67400.0 |
| 2001-11-15 16:00:00 | IWM | ETF | 44.755 | 44.95 | 44.755 | 44.95 | 49800.0 |
| 2001-11-15 09:00:00 | DIA | ETF | 98.3 | 98.57 | 98.21 | 98.46 | 206300.0 |
| 2001-11-15 10:00:00 | DIA | ETF | 98.48 | 99.23 | 98.3 | 99.1 | 693300.0 |
| 2001-11-15 11:00:00 | DIA | ETF | 99.09 | 99.16 | 98.76 | 98.93 | 287300.0 |
| 2001-11-15 12:00:00 | DIA | ETF | 98.98 | 99.15 | 98.79 | 99.15 | 112600.0 |
| 2001-11-15 13:00:00 | DIA | ETF | 99.18 | 99.24 | 98.67 | 98.71 | 211300.0 |
| 2001-11-15 14:00:00 | DIA | ETF | 98.73 | 98.9 | 98.39 | 98.76 | 792500.0 |
| 2001-11-15 15:00:00 | DIA | ETF | 98.76 | 98.92 | 98.45 | 98.85 | 670200.0 |
| 2001-11-15 16:00:00 | DIA | ETF | 98.86 | 99.25 | 98.85 | 99.14 | 84400.0 |
> showing 36 of 270 rows — these rows as CSV