PREVIEW / etf_30min / 2001-01-18
file: by_date/etf_30min/2001/2001-01-18.parquet size: 12 KB rows: 337
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-18 09:30:00 | SPY | ETF | 133.4375 | 133.6562 | 132.9375 | 133.375 | 1262400.0 |
| 2001-01-18 10:00:00 | SPY | ETF | 133.4062 | 133.5938 | 132.9375 | 133.3438 | 509700.0 |
| 2001-01-18 10:30:00 | SPY | ETF | 133.375 | 133.9688 | 133.2188 | 133.875 | 711100.0 |
| 2001-01-18 11:00:00 | SPY | ETF | 133.8125 | 134.25 | 133.6875 | 133.9375 | 688500.0 |
| 2001-01-18 11:30:00 | SPY | ETF | 134.0312 | 134.4375 | 133.875 | 134.1562 | 909000.0 |
| 2001-01-18 12:00:00 | SPY | ETF | 134.125 | 134.7188 | 134.0 | 134.5625 | 484100.0 |
| 2001-01-18 12:30:00 | SPY | ETF | 134.6875 | 134.9062 | 134.4688 | 134.6875 | 187800.0 |
| 2001-01-18 13:00:00 | SPY | ETF | 134.8125 | 135.3438 | 134.6562 | 135.1875 | 437000.0 |
| 2001-01-18 13:30:00 | SPY | ETF | 135.1562 | 135.3125 | 134.7812 | 135.3125 | 448100.0 |
| 2001-01-18 14:00:00 | SPY | ETF | 135.3438 | 135.5938 | 135.1562 | 135.1562 | 479300.0 |
| 2001-01-18 14:30:00 | SPY | ETF | 135.1875 | 135.375 | 134.7812 | 134.875 | 314700.0 |
| 2001-01-18 15:00:00 | SPY | ETF | 134.9062 | 135.6875 | 134.875 | 135.3125 | 381300.0 |
| 2001-01-18 15:30:00 | SPY | ETF | 135.25 | 135.5 | 134.8438 | 135.0312 | 756100.0 |
| 2001-01-18 16:00:00 | SPY | ETF | 135.0 | 135.0938 | 134.625 | 135.0 | 303200.0 |
| 2001-01-18 16:30:00 | SPY | ETF | 135.125 | 135.4375 | 135.125 | 135.4375 | 700.0 |
| 2001-01-18 17:00:00 | SPY | ETF | 135.4375 | 135.4375 | 135.4375 | 135.4375 | 100.0 |
| 2001-01-18 18:00:00 | SPY | ETF | 135.0 | 135.0 | 135.0 | 135.0 | 100.0 |
| 2001-01-18 09:30:00 | QQQ | ETF | 64.125 | 64.1875 | 63.0312 | 63.9375 | 7367300.0 |
| 2001-01-18 10:00:00 | QQQ | ETF | 64.0 | 64.6562 | 63.0625 | 64.0 | 5065000.0 |
| 2001-01-18 10:30:00 | QQQ | ETF | 64.0 | 64.875 | 63.9375 | 64.625 | 3206000.0 |
| 2001-01-18 11:00:00 | QQQ | ETF | 64.7812 | 65.4688 | 64.625 | 64.9688 | 4932900.0 |
| 2001-01-18 11:30:00 | QQQ | ETF | 65.0312 | 65.25 | 64.625 | 64.75 | 2402000.0 |
| 2001-01-18 12:00:00 | QQQ | ETF | 64.75 | 65.4375 | 64.625 | 65.3125 | 1979700.0 |
| 2001-01-18 12:30:00 | QQQ | ETF | 65.3125 | 65.625 | 65.125 | 65.375 | 3115700.0 |
| 2001-01-18 13:00:00 | QQQ | ETF | 65.375 | 65.9375 | 65.3125 | 65.75 | 3016500.0 |
| 2001-01-18 13:30:00 | QQQ | ETF | 65.75 | 65.875 | 65.375 | 65.8125 | 1896200.0 |
| 2001-01-18 14:00:00 | QQQ | ETF | 65.875 | 66.5 | 65.75 | 65.8125 | 5908500.0 |
| 2001-01-18 14:30:00 | QQQ | ETF | 65.8438 | 66.1875 | 65.625 | 65.75 | 2034900.0 |
| 2001-01-18 15:00:00 | QQQ | ETF | 65.75 | 66.6562 | 65.7188 | 66.375 | 4373000.0 |
| 2001-01-18 15:30:00 | QQQ | ETF | 66.375 | 66.75 | 66.1875 | 66.5 | 5281200.0 |
| 2001-01-18 16:00:00 | QQQ | ETF | 66.5 | 67.0 | 64.9375 | 67.0 | 1288400.0 |
| 2001-01-18 16:30:00 | QQQ | ETF | 67.0 | 68.0 | 66.5 | 67.4688 | 444200.0 |
| 2001-01-18 17:00:00 | QQQ | ETF | 67.4688 | 68.0 | 67.375 | 67.875 | 147400.0 |
| 2001-01-18 17:30:00 | QQQ | ETF | 67.75 | 68.0 | 67.625 | 67.875 | 105300.0 |
| 2001-01-18 18:00:00 | QQQ | ETF | 67.875 | 68.5 | 67.75 | 68.0 | 59100.0 |
| 2001-01-18 09:30:00 | IWM | ETF | 49.4375 | 49.4375 | 48.9375 | 49.1562 | 36600.0 |
| 2001-01-18 10:00:00 | IWM | ETF | 49.0 | 49.0 | 48.8438 | 48.8438 | 14200.0 |
| 2001-01-18 10:30:00 | IWM | ETF | 48.8438 | 49.0312 | 48.8438 | 49.0 | 167400.0 |
| 2001-01-18 11:00:00 | IWM | ETF | 49.0 | 49.125 | 49.0 | 49.125 | 28400.0 |
| 2001-01-18 11:30:00 | IWM | ETF | 49.0938 | 49.125 | 49.0 | 49.125 | 4400.0 |
| 2001-01-18 12:00:00 | IWM | ETF | 48.9375 | 48.9375 | 48.8438 | 48.8438 | 28600.0 |
| 2001-01-18 12:30:00 | IWM | ETF | 48.9375 | 48.9375 | 48.9219 | 48.9219 | 2600.0 |
| 2001-01-18 13:00:00 | IWM | ETF | 48.9375 | 49.0469 | 48.9062 | 49.0312 | 7200.0 |
| 2001-01-18 13:30:00 | IWM | ETF | 49.0312 | 49.0312 | 48.7812 | 48.9062 | 16400.0 |
| 2001-01-18 14:00:00 | IWM | ETF | 48.9062 | 49.0312 | 48.9062 | 48.9688 | 37400.0 |
| 2001-01-18 14:30:00 | IWM | ETF | 48.9688 | 49.0312 | 48.9688 | 49.0312 | 25800.0 |
| 2001-01-18 15:00:00 | IWM | ETF | 49.0312 | 49.3438 | 49.0312 | 49.3438 | 30400.0 |
| 2001-01-18 15:30:00 | IWM | ETF | 49.3125 | 49.4688 | 49.1562 | 49.4219 | 372000.0 |
| 2001-01-18 16:00:00 | IWM | ETF | 49.25 | 49.5 | 49.25 | 49.5 | 121400.0 |
| 2001-01-18 09:30:00 | DIA | ETF | 106.3125 | 106.4375 | 105.8125 | 106.0312 | 279900.0 |
> showing 50 of 337 rows — these rows as CSV