PREVIEW / etf_30min / 2000-10-11
file: by_date/etf_30min/2000/2000-10-11.parquet size: 12 KB rows: 303
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-11 09:30:00 | SPY | ETF | 137.625 | 138.3125 | 137.0 | 138.3125 | 1027200.0 |
| 2000-10-11 10:00:00 | SPY | ETF | 138.2188 | 138.25 | 137.0938 | 137.2188 | 519500.0 |
| 2000-10-11 10:30:00 | SPY | ETF | 137.0938 | 137.6875 | 136.0312 | 136.125 | 1261600.0 |
| 2000-10-11 11:00:00 | SPY | ETF | 136.0938 | 136.5 | 135.125 | 135.75 | 923000.0 |
| 2000-10-11 11:30:00 | SPY | ETF | 135.8438 | 136.9062 | 135.7812 | 136.625 | 687900.0 |
| 2000-10-11 12:00:00 | SPY | ETF | 136.4375 | 137.8125 | 136.3125 | 137.8125 | 679600.0 |
| 2000-10-11 12:30:00 | SPY | ETF | 137.8438 | 138.5625 | 137.6875 | 137.7812 | 789000.0 |
| 2000-10-11 13:00:00 | SPY | ETF | 137.8438 | 138.0625 | 137.2812 | 137.4062 | 329800.0 |
| 2000-10-11 13:30:00 | SPY | ETF | 137.4375 | 138.1875 | 137.4375 | 138.0625 | 375100.0 |
| 2000-10-11 14:00:00 | SPY | ETF | 138.1875 | 138.3125 | 137.3125 | 137.5312 | 674700.0 |
| 2000-10-11 14:30:00 | SPY | ETF | 137.625 | 137.7188 | 136.9062 | 137.4375 | 615100.0 |
| 2000-10-11 15:00:00 | SPY | ETF | 137.4062 | 137.5938 | 135.9375 | 136.5938 | 633400.0 |
| 2000-10-11 15:30:00 | SPY | ETF | 136.625 | 137.625 | 136.5625 | 136.5625 | 1376700.0 |
| 2000-10-11 16:00:00 | SPY | ETF | 136.5 | 136.7812 | 136.4062 | 136.5312 | 229000.0 |
| 2000-10-11 16:30:00 | SPY | ETF | 136.5312 | 136.5312 | 136.5312 | 136.5312 | 200.0 |
| 2000-10-11 09:30:00 | QQQ | ETF | 76.875 | 79.0 | 76.8125 | 78.6875 | 5738500.0 |
| 2000-10-11 10:00:00 | QQQ | ETF | 78.8125 | 79.0 | 77.2188 | 77.5312 | 3782100.0 |
| 2000-10-11 10:30:00 | QQQ | ETF | 77.5 | 78.1875 | 76.625 | 76.75 | 3420700.0 |
| 2000-10-11 11:00:00 | QQQ | ETF | 76.7812 | 77.25 | 76.0625 | 77.125 | 4114000.0 |
| 2000-10-11 11:30:00 | QQQ | ETF | 77.125 | 78.25 | 77.0 | 77.9062 | 3633400.0 |
| 2000-10-11 12:00:00 | QQQ | ETF | 77.9062 | 79.625 | 77.75 | 79.25 | 3353600.0 |
| 2000-10-11 12:30:00 | QQQ | ETF | 79.5625 | 80.4375 | 79.125 | 79.1875 | 4846800.0 |
| 2000-10-11 13:00:00 | QQQ | ETF | 79.1875 | 79.625 | 78.7812 | 78.875 | 1812600.0 |
| 2000-10-11 13:30:00 | QQQ | ETF | 78.8125 | 80.0 | 78.8125 | 79.9375 | 2435500.0 |
| 2000-10-11 14:00:00 | QQQ | ETF | 79.9375 | 80.125 | 79.1562 | 79.4062 | 2824000.0 |
| 2000-10-11 14:30:00 | QQQ | ETF | 79.4375 | 79.625 | 78.4688 | 79.25 | 2289600.0 |
| 2000-10-11 15:00:00 | QQQ | ETF | 79.25 | 79.4688 | 77.0 | 77.75 | 4115200.0 |
| 2000-10-11 15:30:00 | QQQ | ETF | 77.7188 | 79.2188 | 77.25 | 77.4688 | 4956400.0 |
| 2000-10-11 16:00:00 | QQQ | ETF | 77.4688 | 79.5938 | 76.25 | 77.375 | 850800.0 |
| 2000-10-11 16:30:00 | QQQ | ETF | 77.375 | 77.5625 | 77.25 | 77.375 | 4500.0 |
| 2000-10-11 17:00:00 | QQQ | ETF | 77.375 | 77.75 | 77.375 | 77.75 | 5000.0 |
| 2000-10-11 17:30:00 | QQQ | ETF | 77.75 | 78.0 | 77.25 | 77.5 | 7800.0 |
| 2000-10-11 18:00:00 | QQQ | ETF | 77.9688 | 78.0625 | 77.5 | 77.75 | 2700.0 |
| 2000-10-11 09:30:00 | IWM | ETF | 47.7188 | 47.7188 | 47.5625 | 47.5781 | 5000.0 |
| 2000-10-11 10:00:00 | IWM | ETF | 47.5625 | 47.6875 | 47.5625 | 47.6875 | 10400.0 |
| 2000-10-11 10:30:00 | IWM | ETF | 47.5 | 47.5 | 47.1562 | 47.1562 | 11600.0 |
| 2000-10-11 11:00:00 | IWM | ETF | 47.1875 | 47.1875 | 47.0 | 47.0 | 25200.0 |
| 2000-10-11 11:30:00 | IWM | ETF | 47.0 | 47.1562 | 47.0 | 47.1562 | 20400.0 |
| 2000-10-11 12:00:00 | IWM | ETF | 47.0625 | 47.3906 | 47.0625 | 47.3906 | 16600.0 |
| 2000-10-11 12:30:00 | IWM | ETF | 47.5312 | 47.6875 | 47.4688 | 47.4688 | 12200.0 |
| 2000-10-11 13:00:00 | IWM | ETF | 47.4375 | 47.5 | 47.4375 | 47.5 | 5400.0 |
| 2000-10-11 13:30:00 | IWM | ETF | 47.5938 | 47.6562 | 47.5938 | 47.6562 | 10800.0 |
| 2000-10-11 14:00:00 | IWM | ETF | 47.8125 | 47.8125 | 47.5625 | 47.5625 | 10800.0 |
| 2000-10-11 14:30:00 | IWM | ETF | 47.7188 | 47.7188 | 47.5938 | 47.5938 | 20400.0 |
| 2000-10-11 15:00:00 | IWM | ETF | 47.2812 | 47.2812 | 47.2812 | 47.2812 | 2000.0 |
| 2000-10-11 15:30:00 | IWM | ETF | 47.5312 | 47.5625 | 47.4062 | 47.4062 | 17400.0 |
| 2000-10-11 09:30:00 | DIA | ETF | 104.7812 | 105.8125 | 104.7188 | 105.8125 | 127900.0 |
| 2000-10-11 10:00:00 | DIA | ETF | 105.625 | 105.6562 | 104.875 | 104.9062 | 72900.0 |
| 2000-10-11 10:30:00 | DIA | ETF | 104.9062 | 105.2812 | 104.25 | 104.25 | 221700.0 |
| 2000-10-11 11:00:00 | DIA | ETF | 104.3125 | 104.5 | 103.5625 | 103.9375 | 187400.0 |
> showing 50 of 303 rows — these rows as CSV