PREVIEW / etf_30min / 2000-11-13
file: by_date/etf_30min/2000/2000-11-13.parquet size: 13 KB rows: 314
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-13 09:30:00 | SPY | ETF | 135.625 | 135.8125 | 134.625 | 135.4375 | 2908000.0 |
| 2000-11-13 10:00:00 | SPY | ETF | 135.375 | 136.1875 | 135.25 | 135.3438 | 876200.0 |
| 2000-11-13 10:30:00 | SPY | ETF | 135.375 | 135.5 | 134.25 | 134.7812 | 2203800.0 |
| 2000-11-13 11:00:00 | SPY | ETF | 134.8125 | 134.9688 | 133.875 | 134.1875 | 810500.0 |
| 2000-11-13 11:30:00 | SPY | ETF | 134.2812 | 134.4062 | 133.2812 | 133.5312 | 453700.0 |
| 2000-11-13 12:00:00 | SPY | ETF | 133.4375 | 133.875 | 133.0312 | 133.1875 | 2117800.0 |
| 2000-11-13 12:30:00 | SPY | ETF | 133.0938 | 133.8438 | 133.0312 | 133.4375 | 775200.0 |
| 2000-11-13 13:00:00 | SPY | ETF | 133.375 | 134.625 | 133.25 | 134.625 | 1082500.0 |
| 2000-11-13 13:30:00 | SPY | ETF | 134.5 | 135.3125 | 134.4375 | 134.9688 | 1121000.0 |
| 2000-11-13 14:00:00 | SPY | ETF | 135.0625 | 136.0 | 134.75 | 135.9375 | 805500.0 |
| 2000-11-13 14:30:00 | SPY | ETF | 135.8125 | 136.4062 | 135.625 | 135.875 | 1314200.0 |
| 2000-11-13 15:00:00 | SPY | ETF | 135.8438 | 136.9688 | 135.8438 | 136.6562 | 676500.0 |
| 2000-11-13 15:30:00 | SPY | ETF | 136.5 | 136.5312 | 135.25 | 135.375 | 762400.0 |
| 2000-11-13 16:00:00 | SPY | ETF | 135.4688 | 136.1875 | 135.0312 | 135.5625 | 605000.0 |
| 2000-11-13 09:30:00 | QQQ | ETF | 70.9375 | 71.0 | 69.0625 | 69.9688 | 13011400.0 |
| 2000-11-13 10:00:00 | QQQ | ETF | 69.875 | 71.25 | 69.5625 | 70.1562 | 6510200.0 |
| 2000-11-13 10:30:00 | QQQ | ETF | 70.1562 | 70.375 | 69.25 | 69.8125 | 3696300.0 |
| 2000-11-13 11:00:00 | QQQ | ETF | 69.9375 | 70.1875 | 69.125 | 69.5 | 3744800.0 |
| 2000-11-13 11:30:00 | QQQ | ETF | 69.6875 | 69.75 | 68.875 | 69.2188 | 4220800.0 |
| 2000-11-13 12:00:00 | QQQ | ETF | 69.25 | 69.25 | 68.2812 | 68.5312 | 4298300.0 |
| 2000-11-13 12:30:00 | QQQ | ETF | 68.5 | 69.375 | 68.25 | 68.875 | 4023200.0 |
| 2000-11-13 13:00:00 | QQQ | ETF | 68.75 | 69.9062 | 68.625 | 69.8438 | 4933000.0 |
| 2000-11-13 13:30:00 | QQQ | ETF | 69.9375 | 70.75 | 69.8438 | 70.625 | 4527800.0 |
| 2000-11-13 14:00:00 | QQQ | ETF | 70.625 | 72.25 | 70.5 | 72.0 | 4712100.0 |
| 2000-11-13 14:30:00 | QQQ | ETF | 72.2188 | 73.125 | 72.0 | 72.5 | 7097900.0 |
| 2000-11-13 15:00:00 | QQQ | ETF | 72.5 | 74.1875 | 72.4375 | 73.5625 | 5327700.0 |
| 2000-11-13 15:30:00 | QQQ | ETF | 73.5312 | 73.5625 | 70.6875 | 71.0 | 4549800.0 |
| 2000-11-13 16:00:00 | QQQ | ETF | 70.875 | 71.125 | 69.875 | 70.0 | 1548100.0 |
| 2000-11-13 16:30:00 | QQQ | ETF | 70.0625 | 70.625 | 70.0 | 70.3438 | 16400.0 |
| 2000-11-13 17:00:00 | QQQ | ETF | 70.2188 | 70.4688 | 70.0 | 70.3125 | 5900.0 |
| 2000-11-13 17:30:00 | QQQ | ETF | 70.3125 | 70.7188 | 70.0 | 70.0 | 10400.0 |
| 2000-11-13 18:00:00 | QQQ | ETF | 70.3125 | 71.0 | 70.3125 | 71.0 | 8300.0 |
| 2000-11-13 09:30:00 | IWM | ETF | 47.5 | 47.5 | 46.9219 | 47.125 | 14200.0 |
| 2000-11-13 10:00:00 | IWM | ETF | 47.3125 | 47.3125 | 47.3125 | 47.3125 | 200.0 |
| 2000-11-13 10:30:00 | IWM | ETF | 46.9062 | 46.9375 | 46.7812 | 46.8125 | 44000.0 |
| 2000-11-13 11:00:00 | IWM | ETF | 46.8438 | 46.875 | 46.7188 | 46.7188 | 9800.0 |
| 2000-11-13 11:30:00 | IWM | ETF | 46.8125 | 46.8125 | 46.5781 | 46.5781 | 1800.0 |
| 2000-11-13 12:00:00 | IWM | ETF | 46.5625 | 46.5625 | 46.4062 | 46.4062 | 6000.0 |
| 2000-11-13 12:30:00 | IWM | ETF | 46.3125 | 46.4531 | 46.3125 | 46.4531 | 1800.0 |
| 2000-11-13 13:00:00 | IWM | ETF | 46.4688 | 46.5312 | 46.3438 | 46.5312 | 2000.0 |
| 2000-11-13 13:30:00 | IWM | ETF | 46.7812 | 46.7812 | 46.75 | 46.75 | 600.0 |
| 2000-11-13 14:00:00 | IWM | ETF | 46.8438 | 47.1875 | 46.8438 | 47.1875 | 400.0 |
| 2000-11-13 14:30:00 | IWM | ETF | 47.5 | 47.6875 | 47.5 | 47.6875 | 9400.0 |
| 2000-11-13 15:00:00 | IWM | ETF | 47.6875 | 47.7812 | 47.6562 | 47.7812 | 19600.0 |
| 2000-11-13 15:30:00 | IWM | ETF | 47.8906 | 47.8906 | 47.625 | 47.6562 | 7200.0 |
| 2000-11-13 16:00:00 | IWM | ETF | 47.625 | 47.75 | 47.4688 | 47.5156 | 43800.0 |
| 2000-11-13 09:30:00 | DIA | ETF | 105.0 | 105.25 | 104.3438 | 105.0625 | 605200.0 |
| 2000-11-13 10:00:00 | DIA | ETF | 105.0625 | 105.7812 | 105.0625 | 105.25 | 353300.0 |
| 2000-11-13 10:30:00 | DIA | ETF | 105.2188 | 105.25 | 104.4062 | 104.625 | 138900.0 |
| 2000-11-13 11:00:00 | DIA | ETF | 104.7812 | 104.9375 | 104.25 | 104.625 | 97400.0 |
> showing 50 of 314 rows — these rows as CSV