PREVIEW / etf_30min / 2000-10-27
file: by_date/etf_30min/2000/2000-10-27.parquet size: 11 KB rows: 274
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-10-27 09:30:00 | SPY | ETF | 137.875 | 138.3438 | 136.875 | 137.25 | 1758000.0 |
| 2000-10-27 10:00:00 | SPY | ETF | 137.1875 | 137.7812 | 136.9062 | 137.6875 | 465000.0 |
| 2000-10-27 10:30:00 | SPY | ETF | 137.625 | 138.0 | 136.7812 | 137.0312 | 318500.0 |
| 2000-10-27 11:00:00 | SPY | ETF | 136.8438 | 137.875 | 136.625 | 137.4375 | 437300.0 |
| 2000-10-27 11:30:00 | SPY | ETF | 137.375 | 138.5 | 137.25 | 138.4375 | 495000.0 |
| 2000-10-27 12:00:00 | SPY | ETF | 138.375 | 138.4375 | 137.5312 | 137.8125 | 324300.0 |
| 2000-10-27 12:30:00 | SPY | ETF | 137.875 | 138.3125 | 137.5938 | 137.9375 | 268500.0 |
| 2000-10-27 13:00:00 | SPY | ETF | 137.7812 | 138.375 | 137.6875 | 138.25 | 368500.0 |
| 2000-10-27 13:30:00 | SPY | ETF | 138.2812 | 138.75 | 138.0625 | 138.625 | 544800.0 |
| 2000-10-27 14:00:00 | SPY | ETF | 138.625 | 138.8438 | 138.1875 | 138.6562 | 690600.0 |
| 2000-10-27 14:30:00 | SPY | ETF | 138.6875 | 138.6875 | 137.5312 | 138.0938 | 677100.0 |
| 2000-10-27 15:00:00 | SPY | ETF | 138.0938 | 138.1562 | 137.5 | 137.9688 | 372900.0 |
| 2000-10-27 15:30:00 | SPY | ETF | 137.9062 | 138.5938 | 137.7812 | 138.375 | 1151100.0 |
| 2000-10-27 16:00:00 | SPY | ETF | 138.4375 | 139.2812 | 138.4375 | 139.2812 | 1048600.0 |
| 2000-10-27 09:30:00 | QQQ | ETF | 80.8438 | 81.8438 | 80.1875 | 80.3125 | 7272700.0 |
| 2000-10-27 10:00:00 | QQQ | ETF | 80.4375 | 81.0 | 79.5625 | 80.25 | 5260200.0 |
| 2000-10-27 10:30:00 | QQQ | ETF | 80.25 | 80.5 | 77.75 | 78.0 | 4263300.0 |
| 2000-10-27 11:00:00 | QQQ | ETF | 77.875 | 79.875 | 77.4688 | 78.8125 | 6020000.0 |
| 2000-10-27 11:30:00 | QQQ | ETF | 78.875 | 80.625 | 78.5 | 80.1875 | 3004500.0 |
| 2000-10-27 12:00:00 | QQQ | ETF | 80.25 | 80.3125 | 78.5 | 79.125 | 2775900.0 |
| 2000-10-27 12:30:00 | QQQ | ETF | 79.1875 | 79.8438 | 79.0 | 79.375 | 2067500.0 |
| 2000-10-27 13:00:00 | QQQ | ETF | 79.4375 | 80.375 | 79.25 | 80.0312 | 2351700.0 |
| 2000-10-27 13:30:00 | QQQ | ETF | 80.0312 | 81.2812 | 79.625 | 80.8438 | 2860700.0 |
| 2000-10-27 14:00:00 | QQQ | ETF | 80.875 | 81.0 | 80.25 | 80.5938 | 2302300.0 |
| 2000-10-27 14:30:00 | QQQ | ETF | 80.5 | 80.6875 | 78.625 | 79.4062 | 4448900.0 |
| 2000-10-27 15:00:00 | QQQ | ETF | 79.375 | 79.625 | 78.25 | 79.0 | 2743100.0 |
| 2000-10-27 15:30:00 | QQQ | ETF | 78.875 | 80.125 | 78.875 | 79.125 | 3389100.0 |
| 2000-10-27 16:00:00 | QQQ | ETF | 79.125 | 80.75 | 79.0312 | 79.75 | 488900.0 |
| 2000-10-27 16:30:00 | QQQ | ETF | 79.7188 | 79.875 | 79.1875 | 79.625 | 11200.0 |
| 2000-10-27 17:00:00 | QQQ | ETF | 79.75 | 79.75 | 79.4375 | 79.4375 | 600.0 |
| 2000-10-27 17:30:00 | QQQ | ETF | 79.5 | 79.5312 | 79.3125 | 79.5 | 1600.0 |
| 2000-10-27 18:00:00 | QQQ | ETF | 79.25 | 79.5 | 79.25 | 79.5 | 2000.0 |
| 2000-10-27 09:30:00 | IWM | ETF | 47.625 | 48.1562 | 47.625 | 47.9688 | 24800.0 |
| 2000-10-27 10:00:00 | IWM | ETF | 48.2344 | 48.25 | 48.2188 | 48.25 | 54800.0 |
| 2000-10-27 10:30:00 | IWM | ETF | 48.125 | 48.125 | 47.875 | 47.875 | 5800.0 |
| 2000-10-27 11:00:00 | IWM | ETF | 47.7812 | 48.0 | 47.7656 | 48.0 | 20600.0 |
| 2000-10-27 11:30:00 | IWM | ETF | 48.0 | 48.0312 | 48.0 | 48.0312 | 5400.0 |
| 2000-10-27 12:00:00 | IWM | ETF | 48.1094 | 48.125 | 48.1094 | 48.125 | 400.0 |
| 2000-10-27 12:30:00 | IWM | ETF | 48.0938 | 48.1562 | 48.0938 | 48.1562 | 8600.0 |
| 2000-10-27 14:00:00 | IWM | ETF | 48.25 | 48.25 | 48.25 | 48.25 | 400.0 |
| 2000-10-27 14:30:00 | IWM | ETF | 48.0625 | 48.125 | 48.0625 | 48.0938 | 6000.0 |
| 2000-10-27 15:00:00 | IWM | ETF | 48.1562 | 48.1562 | 48.0938 | 48.0938 | 10600.0 |
| 2000-10-27 15:30:00 | IWM | ETF | 48.125 | 48.125 | 48.0312 | 48.0312 | 1000.0 |
| 2000-10-27 09:30:00 | DIA | ETF | 104.3125 | 104.4375 | 103.875 | 103.875 | 177400.0 |
| 2000-10-27 10:00:00 | DIA | ETF | 103.875 | 104.375 | 103.75 | 104.2188 | 53700.0 |
| 2000-10-27 10:30:00 | DIA | ETF | 104.25 | 104.5625 | 104.125 | 104.125 | 108700.0 |
| 2000-10-27 11:00:00 | DIA | ETF | 104.2188 | 104.9688 | 104.0312 | 104.875 | 114000.0 |
| 2000-10-27 11:30:00 | DIA | ETF | 104.8438 | 105.4375 | 104.75 | 105.4375 | 320200.0 |
| 2000-10-27 12:00:00 | DIA | ETF | 105.3125 | 105.4375 | 104.9375 | 105.1562 | 62100.0 |
| 2000-10-27 12:30:00 | DIA | ETF | 105.125 | 105.3125 | 105.0 | 105.1562 | 11000.0 |
> showing 50 of 274 rows — these rows as CSV