PREVIEW / etf_30min / 2000-12-06
file: by_date/etf_30min/2000/2000-12-06.parquet size: 12 KB rows: 316
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-12-06 09:30:00 | SPY | ETF | 137.7812 | 138.3438 | 137.25 | 137.5 | 2171600.0 |
| 2000-12-06 10:00:00 | SPY | ETF | 137.5938 | 138.0 | 137.125 | 137.75 | 1543100.0 |
| 2000-12-06 10:30:00 | SPY | ETF | 137.6875 | 137.9062 | 137.2812 | 137.7188 | 859900.0 |
| 2000-12-06 11:00:00 | SPY | ETF | 137.6875 | 137.9688 | 137.4375 | 137.4375 | 738000.0 |
| 2000-12-06 11:30:00 | SPY | ETF | 137.5625 | 137.7812 | 137.125 | 137.125 | 527600.0 |
| 2000-12-06 12:00:00 | SPY | ETF | 137.0938 | 137.4375 | 137.0312 | 137.375 | 183500.0 |
| 2000-12-06 12:30:00 | SPY | ETF | 137.2812 | 137.4062 | 137.0938 | 137.1875 | 278700.0 |
| 2000-12-06 13:00:00 | SPY | ETF | 137.1875 | 137.3438 | 136.875 | 137.125 | 226000.0 |
| 2000-12-06 13:30:00 | SPY | ETF | 137.0 | 137.3125 | 135.375 | 136.25 | 1851200.0 |
| 2000-12-06 14:00:00 | SPY | ETF | 136.25 | 136.5938 | 135.625 | 135.6562 | 784500.0 |
| 2000-12-06 14:30:00 | SPY | ETF | 135.5 | 136.0938 | 135.375 | 135.6875 | 1029900.0 |
| 2000-12-06 15:00:00 | SPY | ETF | 135.625 | 136.125 | 135.1875 | 135.4062 | 954800.0 |
| 2000-12-06 15:30:00 | SPY | ETF | 135.4375 | 136.25 | 135.0312 | 135.5312 | 574200.0 |
| 2000-12-06 16:00:00 | SPY | ETF | 135.6875 | 136.0 | 135.1562 | 135.5 | 340400.0 |
| 2000-12-06 16:30:00 | SPY | ETF | 135.6875 | 135.6875 | 135.6875 | 135.6875 | 50000.0 |
| 2000-12-06 09:30:00 | QQQ | ETF | 70.5938 | 72.2812 | 70.0 | 71.125 | 12156800.0 |
| 2000-12-06 10:00:00 | QQQ | ETF | 71.125 | 71.3125 | 69.8125 | 70.625 | 8128700.0 |
| 2000-12-06 10:30:00 | QQQ | ETF | 70.5625 | 71.3438 | 70.2812 | 71.3125 | 4153200.0 |
| 2000-12-06 11:00:00 | QQQ | ETF | 71.2188 | 72.0 | 71.0625 | 71.0938 | 3958600.0 |
| 2000-12-06 11:30:00 | QQQ | ETF | 71.0625 | 71.4375 | 70.0 | 70.0 | 3808000.0 |
| 2000-12-06 12:00:00 | QQQ | ETF | 70.0 | 70.625 | 69.875 | 70.4375 | 2752500.0 |
| 2000-12-06 12:30:00 | QQQ | ETF | 70.4062 | 70.75 | 70.2188 | 70.4375 | 881600.0 |
| 2000-12-06 13:00:00 | QQQ | ETF | 70.4688 | 70.5625 | 69.9688 | 70.0625 | 1623800.0 |
| 2000-12-06 13:30:00 | QQQ | ETF | 70.0938 | 70.6875 | 68.875 | 69.5312 | 4357300.0 |
| 2000-12-06 14:00:00 | QQQ | ETF | 69.75 | 69.9062 | 68.75 | 68.75 | 3830900.0 |
| 2000-12-06 14:30:00 | QQQ | ETF | 68.75 | 69.1875 | 68.4375 | 68.9062 | 3806200.0 |
| 2000-12-06 15:00:00 | QQQ | ETF | 68.9062 | 69.4375 | 68.25 | 68.5312 | 3614200.0 |
| 2000-12-06 15:30:00 | QQQ | ETF | 68.5 | 69.1875 | 67.75 | 68.8125 | 5565700.0 |
| 2000-12-06 16:00:00 | QQQ | ETF | 68.8125 | 72.0 | 65.75 | 68.125 | 1314400.0 |
| 2000-12-06 16:30:00 | QQQ | ETF | 68.125 | 70.0 | 67.75 | 68.0 | 274300.0 |
| 2000-12-06 17:00:00 | QQQ | ETF | 68.0 | 68.25 | 67.75 | 68.25 | 62400.0 |
| 2000-12-06 17:30:00 | QQQ | ETF | 68.0625 | 68.25 | 67.25 | 68.0938 | 4800.0 |
| 2000-12-06 18:00:00 | QQQ | ETF | 68.125 | 68.25 | 67.875 | 67.875 | 10000.0 |
| 2000-12-06 09:30:00 | IWM | ETF | 47.0938 | 47.5312 | 47.0938 | 47.5312 | 16800.0 |
| 2000-12-06 10:00:00 | IWM | ETF | 47.4375 | 47.4375 | 47.2812 | 47.4062 | 5200.0 |
| 2000-12-06 10:30:00 | IWM | ETF | 47.4375 | 47.4688 | 47.375 | 47.375 | 2400.0 |
| 2000-12-06 11:00:00 | IWM | ETF | 47.5 | 47.5 | 47.4375 | 47.4375 | 1000.0 |
| 2000-12-06 11:30:00 | IWM | ETF | 47.2812 | 47.3438 | 47.2812 | 47.3438 | 41600.0 |
| 2000-12-06 12:00:00 | IWM | ETF | 47.3438 | 47.375 | 47.3438 | 47.375 | 1000.0 |
| 2000-12-06 12:30:00 | IWM | ETF | 47.1875 | 47.4062 | 47.1875 | 47.3125 | 19200.0 |
| 2000-12-06 13:00:00 | IWM | ETF | 47.3281 | 47.3281 | 47.3125 | 47.3125 | 16200.0 |
| 2000-12-06 13:30:00 | IWM | ETF | 47.3125 | 47.3125 | 46.9062 | 47.0625 | 37200.0 |
| 2000-12-06 14:00:00 | IWM | ETF | 47.0312 | 47.0312 | 46.6562 | 46.6875 | 57800.0 |
| 2000-12-06 14:30:00 | IWM | ETF | 46.6562 | 46.7812 | 46.4062 | 46.4688 | 24200.0 |
| 2000-12-06 15:00:00 | IWM | ETF | 46.5312 | 46.5312 | 46.3125 | 46.3125 | 4600.0 |
| 2000-12-06 15:30:00 | IWM | ETF | 46.375 | 46.5625 | 46.25 | 46.5 | 15200.0 |
| 2000-12-06 16:00:00 | IWM | ETF | 46.1562 | 46.1562 | 46.1562 | 46.1562 | 200.0 |
| 2000-12-06 09:30:00 | DIA | ETF | 108.5 | 108.8438 | 108.375 | 108.4375 | 158200.0 |
| 2000-12-06 10:00:00 | DIA | ETF | 108.3438 | 108.8438 | 108.125 | 108.6875 | 508500.0 |
| 2000-12-06 10:30:00 | DIA | ETF | 108.6875 | 108.75 | 108.25 | 108.5 | 56500.0 |
> showing 50 of 316 rows — these rows as CSV