PREVIEW / etf_30min / 2001-01-26
file: by_date/etf_30min/2001/2001-01-26.parquet size: 12 KB rows: 333
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-01-26 09:30:00 | SPY | ETF | 135.1562 | 135.5938 | 135.0625 | 135.5 | 774500.0 |
| 2001-01-26 10:00:00 | SPY | ETF | 135.4688 | 135.8438 | 135.0625 | 135.0938 | 842800.0 |
| 2001-01-26 10:30:00 | SPY | ETF | 135.25 | 135.2812 | 134.4375 | 134.6562 | 760000.0 |
| 2001-01-26 11:00:00 | SPY | ETF | 134.75 | 135.0938 | 134.4688 | 134.9688 | 173400.0 |
| 2001-01-26 11:30:00 | SPY | ETF | 134.875 | 135.0938 | 134.6875 | 134.8438 | 152200.0 |
| 2001-01-26 12:00:00 | SPY | ETF | 134.8438 | 135.5625 | 134.75 | 135.4375 | 238700.0 |
| 2001-01-26 12:30:00 | SPY | ETF | 135.4062 | 135.6562 | 135.1875 | 135.3438 | 887900.0 |
| 2001-01-26 13:00:00 | SPY | ETF | 135.5 | 135.8438 | 135.4062 | 135.5938 | 582200.0 |
| 2001-01-26 13:30:00 | SPY | ETF | 135.6875 | 136.0 | 135.375 | 135.75 | 410200.0 |
| 2001-01-26 14:00:00 | SPY | ETF | 135.8438 | 135.8438 | 135.3438 | 135.5312 | 424600.0 |
| 2001-01-26 14:30:00 | SPY | ETF | 135.6562 | 136.125 | 135.5 | 135.9062 | 475100.0 |
| 2001-01-26 15:00:00 | SPY | ETF | 135.9375 | 135.9688 | 135.6562 | 135.75 | 250600.0 |
| 2001-01-26 15:30:00 | SPY | ETF | 135.8125 | 135.9688 | 135.375 | 135.7812 | 368600.0 |
| 2001-01-26 16:00:00 | SPY | ETF | 135.7188 | 135.9062 | 135.6562 | 135.875 | 312200.0 |
| 2001-01-26 16:30:00 | SPY | ETF | 135.125 | 135.125 | 135.125 | 135.125 | 14000.0 |
| 2001-01-26 09:30:00 | QQQ | ETF | 63.5625 | 63.9375 | 63.0 | 63.9062 | 7746000.0 |
| 2001-01-26 10:00:00 | QQQ | ETF | 63.875 | 64.5938 | 63.625 | 63.7812 | 6014600.0 |
| 2001-01-26 10:30:00 | QQQ | ETF | 63.8125 | 64.0625 | 63.4375 | 63.875 | 2938200.0 |
| 2001-01-26 11:00:00 | QQQ | ETF | 63.875 | 63.9062 | 63.125 | 63.6562 | 1726400.0 |
| 2001-01-26 11:30:00 | QQQ | ETF | 63.5625 | 63.7188 | 63.3125 | 63.5625 | 1301500.0 |
| 2001-01-26 12:00:00 | QQQ | ETF | 63.5625 | 64.6562 | 63.5 | 64.4375 | 3546300.0 |
| 2001-01-26 12:30:00 | QQQ | ETF | 64.375 | 64.8125 | 64.25 | 64.5625 | 1873300.0 |
| 2001-01-26 13:00:00 | QQQ | ETF | 64.5625 | 65.3438 | 64.5625 | 65.3125 | 3547800.0 |
| 2001-01-26 13:30:00 | QQQ | ETF | 65.3125 | 65.75 | 65.0625 | 65.4375 | 4381200.0 |
| 2001-01-26 14:00:00 | QQQ | ETF | 65.4688 | 65.5 | 64.875 | 65.25 | 2212900.0 |
| 2001-01-26 14:30:00 | QQQ | ETF | 65.3438 | 65.75 | 65.125 | 65.5312 | 1725300.0 |
| 2001-01-26 15:00:00 | QQQ | ETF | 65.5 | 65.8125 | 65.125 | 65.4688 | 1813400.0 |
| 2001-01-26 15:30:00 | QQQ | ETF | 65.4375 | 65.625 | 64.875 | 65.5625 | 2884600.0 |
| 2001-01-26 16:00:00 | QQQ | ETF | 65.5625 | 65.8125 | 65.4375 | 65.75 | 954900.0 |
| 2001-01-26 16:30:00 | QQQ | ETF | 65.6875 | 66.25 | 65.0312 | 65.6875 | 29900.0 |
| 2001-01-26 17:00:00 | QQQ | ETF | 65.6875 | 65.75 | 62.625 | 65.6875 | 5700.0 |
| 2001-01-26 17:30:00 | QQQ | ETF | 65.6875 | 65.9375 | 65.6875 | 65.75 | 7200.0 |
| 2001-01-26 18:00:00 | QQQ | ETF | 65.75 | 65.75 | 65.625 | 65.625 | 1700.0 |
| 2001-01-26 09:30:00 | IWM | ETF | 49.5312 | 49.5312 | 49.25 | 49.5 | 140600.0 |
| 2001-01-26 10:00:00 | IWM | ETF | 49.4688 | 49.625 | 49.4688 | 49.5781 | 10400.0 |
| 2001-01-26 10:30:00 | IWM | ETF | 49.4062 | 49.4062 | 49.1719 | 49.1719 | 13000.0 |
| 2001-01-26 11:30:00 | IWM | ETF | 49.2656 | 49.2969 | 49.2656 | 49.2969 | 10000.0 |
| 2001-01-26 12:00:00 | IWM | ETF | 49.1719 | 49.375 | 49.1719 | 49.375 | 11600.0 |
| 2001-01-26 12:30:00 | IWM | ETF | 49.3438 | 49.3438 | 49.3438 | 49.3438 | 50000.0 |
| 2001-01-26 13:00:00 | IWM | ETF | 49.375 | 49.5312 | 49.375 | 49.5312 | 101000.0 |
| 2001-01-26 13:30:00 | IWM | ETF | 49.4688 | 49.7031 | 49.4688 | 49.6562 | 8200.0 |
| 2001-01-26 14:00:00 | IWM | ETF | 49.6875 | 49.6875 | 49.5 | 49.5781 | 1000.0 |
| 2001-01-26 14:30:00 | IWM | ETF | 49.5625 | 49.75 | 49.5625 | 49.75 | 11600.0 |
| 2001-01-26 15:00:00 | IWM | ETF | 49.9062 | 49.9062 | 49.6875 | 49.8438 | 46000.0 |
| 2001-01-26 15:30:00 | IWM | ETF | 49.9688 | 50.0 | 49.75 | 49.7812 | 29000.0 |
| 2001-01-26 16:00:00 | IWM | ETF | 49.8125 | 49.8125 | 49.8125 | 49.8125 | 800.0 |
| 2001-01-26 09:30:00 | DIA | ETF | 107.125 | 107.5938 | 106.9062 | 107.5 | 148300.0 |
| 2001-01-26 10:00:00 | DIA | ETF | 107.5 | 107.5 | 106.8125 | 106.9062 | 137800.0 |
| 2001-01-26 10:30:00 | DIA | ETF | 106.9375 | 106.9375 | 106.1875 | 106.4688 | 361900.0 |
| 2001-01-26 11:00:00 | DIA | ETF | 106.5 | 106.7812 | 106.375 | 106.6875 | 31300.0 |
> showing 50 of 333 rows — these rows as CSV