PREVIEW / etf_30min / 2000-11-28
file: by_date/etf_30min/2000/2000-11-28.parquet size: 12 KB rows: 295
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 |
|---|---|---|---|---|---|---|---|
| 2000-11-28 09:30:00 | SPY | ETF | 135.125 | 136.0625 | 135.0312 | 136.0 | 494000.0 |
| 2000-11-28 10:00:00 | SPY | ETF | 135.9062 | 136.5938 | 135.1875 | 135.3438 | 562400.0 |
| 2000-11-28 10:30:00 | SPY | ETF | 135.25 | 135.4688 | 134.7188 | 135.25 | 441000.0 |
| 2000-11-28 11:00:00 | SPY | ETF | 135.0938 | 135.375 | 134.2188 | 134.7188 | 278600.0 |
| 2000-11-28 11:30:00 | SPY | ETF | 134.625 | 134.9375 | 134.375 | 134.9375 | 213800.0 |
| 2000-11-28 12:00:00 | SPY | ETF | 134.7812 | 134.9062 | 134.3438 | 134.4375 | 136800.0 |
| 2000-11-28 12:30:00 | SPY | ETF | 134.4375 | 135.3438 | 134.4375 | 135.125 | 104800.0 |
| 2000-11-28 13:00:00 | SPY | ETF | 135.25 | 135.2812 | 134.6875 | 135.125 | 256100.0 |
| 2000-11-28 13:30:00 | SPY | ETF | 135.125 | 135.75 | 134.9062 | 135.75 | 138400.0 |
| 2000-11-28 14:00:00 | SPY | ETF | 135.8438 | 135.875 | 134.9375 | 135.0312 | 385400.0 |
| 2000-11-28 14:30:00 | SPY | ETF | 135.2812 | 135.3438 | 134.5625 | 134.6875 | 273000.0 |
| 2000-11-28 15:00:00 | SPY | ETF | 134.8125 | 134.8125 | 134.0625 | 134.2812 | 240600.0 |
| 2000-11-28 15:30:00 | SPY | ETF | 134.4062 | 134.5938 | 133.8125 | 133.8125 | 515900.0 |
| 2000-11-28 16:00:00 | SPY | ETF | 133.8125 | 134.0 | 133.625 | 133.6875 | 299500.0 |
| 2000-11-28 16:30:00 | SPY | ETF | 133.6875 | 133.6875 | 133.6875 | 133.6875 | 862600.0 |
| 2000-11-28 17:00:00 | SPY | ETF | 133.75 | 133.75 | 133.75 | 133.75 | 200.0 |
| 2000-11-28 09:30:00 | QQQ | ETF | 68.9375 | 69.5 | 68.5 | 69.25 | 4398200.0 |
| 2000-11-28 10:00:00 | QQQ | ETF | 69.25 | 69.875 | 68.125 | 68.1875 | 2950000.0 |
| 2000-11-28 10:30:00 | QQQ | ETF | 68.1875 | 68.375 | 67.375 | 67.75 | 3696000.0 |
| 2000-11-28 11:00:00 | QQQ | ETF | 67.75 | 67.9375 | 66.875 | 67.25 | 3729200.0 |
| 2000-11-28 11:30:00 | QQQ | ETF | 67.25 | 67.6562 | 66.9062 | 67.625 | 2769700.0 |
| 2000-11-28 12:00:00 | QQQ | ETF | 67.625 | 67.6875 | 66.625 | 66.7188 | 1887700.0 |
| 2000-11-28 12:30:00 | QQQ | ETF | 66.7188 | 67.375 | 66.5312 | 67.1875 | 3263900.0 |
| 2000-11-28 13:00:00 | QQQ | ETF | 67.1875 | 67.4375 | 66.625 | 67.25 | 2113000.0 |
| 2000-11-28 13:30:00 | QQQ | ETF | 67.1562 | 68.1562 | 67.0312 | 68.0625 | 2611000.0 |
| 2000-11-28 14:00:00 | QQQ | ETF | 68.125 | 68.125 | 66.625 | 66.875 | 3926400.0 |
| 2000-11-28 14:30:00 | QQQ | ETF | 66.75 | 67.75 | 65.7812 | 66.1875 | 4854400.0 |
| 2000-11-28 15:00:00 | QQQ | ETF | 66.2812 | 66.375 | 65.5 | 65.8438 | 4441000.0 |
| 2000-11-28 15:30:00 | QQQ | ETF | 65.8438 | 66.375 | 65.3125 | 65.4688 | 4703400.0 |
| 2000-11-28 16:00:00 | QQQ | ETF | 65.4688 | 65.8438 | 65.3125 | 65.5625 | 1081800.0 |
| 2000-11-28 16:30:00 | QQQ | ETF | 65.625 | 65.9375 | 65.5 | 65.625 | 13400.0 |
| 2000-11-28 17:00:00 | QQQ | ETF | 65.625 | 65.75 | 65.5 | 65.6875 | 21900.0 |
| 2000-11-28 17:30:00 | QQQ | ETF | 65.5625 | 66.0 | 65.5625 | 65.75 | 13200.0 |
| 2000-11-28 18:00:00 | QQQ | ETF | 65.75 | 66.0 | 65.5312 | 65.6875 | 7500.0 |
| 2000-11-28 09:30:00 | IWM | ETF | 46.875 | 47.0156 | 46.75 | 46.75 | 33600.0 |
| 2000-11-28 10:00:00 | IWM | ETF | 47.0 | 47.2188 | 46.75 | 46.75 | 40800.0 |
| 2000-11-28 10:30:00 | IWM | ETF | 46.75 | 46.75 | 46.5625 | 46.5938 | 10600.0 |
| 2000-11-28 11:00:00 | IWM | ETF | 46.5 | 46.5 | 46.3438 | 46.4062 | 4200.0 |
| 2000-11-28 11:30:00 | IWM | ETF | 46.3438 | 46.3438 | 46.1562 | 46.1562 | 1000.0 |
| 2000-11-28 12:00:00 | IWM | ETF | 46.375 | 46.375 | 46.0938 | 46.125 | 3000.0 |
| 2000-11-28 12:30:00 | IWM | ETF | 46.25 | 46.375 | 46.25 | 46.3438 | 13000.0 |
| 2000-11-28 13:00:00 | IWM | ETF | 46.375 | 46.375 | 46.1875 | 46.375 | 6600.0 |
| 2000-11-28 13:30:00 | IWM | ETF | 46.375 | 46.4375 | 46.3438 | 46.4375 | 3000.0 |
| 2000-11-28 14:00:00 | IWM | ETF | 46.3125 | 46.3125 | 46.3125 | 46.3125 | 4800.0 |
| 2000-11-28 14:30:00 | IWM | ETF | 46.3438 | 46.3438 | 46.2812 | 46.2812 | 800.0 |
| 2000-11-28 15:00:00 | IWM | ETF | 46.125 | 46.125 | 46.0 | 46.0 | 5600.0 |
| 2000-11-28 15:30:00 | IWM | ETF | 46.0 | 46.0 | 45.5 | 45.8438 | 9600.0 |
| 2000-11-28 16:00:00 | IWM | ETF | 45.6875 | 45.6875 | 45.6562 | 45.6562 | 400.0 |
| 2000-11-28 09:30:00 | DIA | ETF | 105.5 | 105.9688 | 105.0625 | 105.8438 | 134100.0 |
| 2000-11-28 10:00:00 | DIA | ETF | 105.9688 | 106.375 | 105.6562 | 105.6562 | 108700.0 |
> showing 50 of 295 rows — these rows as CSV