PREVIEW / etf_30min / 2000-05-04
file: by_date/etf_30min/2000/2000-05-04.parquet size: 9 KB rows: 194
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-05-04 09:30:00 | SPY | ETF | 142.0 | 142.2188 | 141.0312 | 141.8125 | 792900.0 |
| 2000-05-04 10:00:00 | SPY | ETF | 141.7812 | 142.3438 | 141.1562 | 141.7188 | 701700.0 |
| 2000-05-04 10:30:00 | SPY | ETF | 141.75 | 142.2188 | 141.25 | 141.3125 | 807600.0 |
| 2000-05-04 11:00:00 | SPY | ETF | 141.4375 | 141.9375 | 141.2812 | 141.2812 | 212600.0 |
| 2000-05-04 11:30:00 | SPY | ETF | 141.4375 | 141.5625 | 140.9688 | 141.125 | 281000.0 |
| 2000-05-04 12:00:00 | SPY | ETF | 141.125 | 141.5 | 140.9062 | 141.125 | 173900.0 |
| 2000-05-04 12:30:00 | SPY | ETF | 141.125 | 141.6875 | 140.875 | 141.625 | 188200.0 |
| 2000-05-04 13:00:00 | SPY | ETF | 141.6875 | 141.7188 | 141.0625 | 141.3125 | 203000.0 |
| 2000-05-04 13:30:00 | SPY | ETF | 141.1875 | 141.6875 | 141.1875 | 141.25 | 77400.0 |
| 2000-05-04 14:00:00 | SPY | ETF | 141.0938 | 141.3438 | 140.75 | 141.25 | 227800.0 |
| 2000-05-04 14:30:00 | SPY | ETF | 141.0938 | 141.2812 | 140.75 | 141.1875 | 178400.0 |
| 2000-05-04 15:00:00 | SPY | ETF | 141.0625 | 141.5625 | 140.875 | 141.0 | 428000.0 |
| 2000-05-04 15:30:00 | SPY | ETF | 140.9375 | 142.1875 | 140.875 | 141.3125 | 1322700.0 |
| 2000-05-04 16:00:00 | SPY | ETF | 141.4375 | 141.8125 | 141.0312 | 141.8125 | 352100.0 |
| 2000-05-04 09:30:00 | QQQ | ETF | 89.0 | 89.75 | 87.625 | 89.5 | 2968000.0 |
| 2000-05-04 10:00:00 | QQQ | ETF | 89.75 | 90.75 | 88.875 | 89.875 | 3142000.0 |
| 2000-05-04 10:30:00 | QQQ | ETF | 89.875 | 90.25 | 88.75 | 88.9375 | 1239300.0 |
| 2000-05-04 11:00:00 | QQQ | ETF | 88.9375 | 89.625 | 88.75 | 89.0 | 849200.0 |
| 2000-05-04 11:30:00 | QQQ | ETF | 88.875 | 89.125 | 88.25 | 88.25 | 850200.0 |
| 2000-05-04 12:00:00 | QQQ | ETF | 88.25 | 88.5 | 87.75 | 88.125 | 1183100.0 |
| 2000-05-04 12:30:00 | QQQ | ETF | 88.1875 | 88.9375 | 87.875 | 88.875 | 853600.0 |
| 2000-05-04 13:00:00 | QQQ | ETF | 88.8125 | 88.9375 | 88.125 | 88.375 | 467800.0 |
| 2000-05-04 13:30:00 | QQQ | ETF | 88.3125 | 88.9688 | 88.3125 | 88.375 | 294100.0 |
| 2000-05-04 14:00:00 | QQQ | ETF | 88.5 | 88.75 | 87.8125 | 88.6875 | 538500.0 |
| 2000-05-04 14:30:00 | QQQ | ETF | 88.625 | 88.875 | 88.0 | 88.375 | 773700.0 |
| 2000-05-04 15:00:00 | QQQ | ETF | 88.5 | 89.5 | 88.125 | 88.5625 | 1197200.0 |
| 2000-05-04 15:30:00 | QQQ | ETF | 88.5625 | 90.0 | 88.375 | 89.125 | 2482500.0 |
| 2000-05-04 16:00:00 | QQQ | ETF | 89.0625 | 89.25 | 88.625 | 88.9375 | 826600.0 |
| 2000-05-04 16:30:00 | QQQ | ETF | 89.125 | 89.125 | 89.125 | 89.125 | 500.0 |
| 2000-05-04 17:00:00 | QQQ | ETF | 89.125 | 89.125 | 89.0625 | 89.125 | 1500.0 |
| 2000-05-04 17:30:00 | QQQ | ETF | 89.125 | 89.375 | 89.125 | 89.375 | 300.0 |
| 2000-05-04 18:00:00 | QQQ | ETF | 89.125 | 89.3125 | 88.875 | 89.3125 | 1100.0 |
| 2000-05-04 09:30:00 | DIA | ETF | 105.2812 | 105.2812 | 104.25 | 105.0 | 274500.0 |
| 2000-05-04 10:00:00 | DIA | ETF | 105.0312 | 105.0625 | 103.7812 | 104.375 | 130500.0 |
| 2000-05-04 10:30:00 | DIA | ETF | 104.375 | 104.75 | 104.125 | 104.3438 | 49000.0 |
| 2000-05-04 11:00:00 | DIA | ETF | 104.375 | 104.6562 | 104.2188 | 104.25 | 51600.0 |
| 2000-05-04 11:30:00 | DIA | ETF | 104.3125 | 104.4375 | 104.125 | 104.1875 | 37100.0 |
| 2000-05-04 12:00:00 | DIA | ETF | 104.1875 | 104.4062 | 104.0312 | 104.375 | 22900.0 |
| 2000-05-04 12:30:00 | DIA | ETF | 104.2812 | 104.875 | 104.1875 | 104.875 | 66000.0 |
| 2000-05-04 13:00:00 | DIA | ETF | 104.7188 | 104.875 | 104.2188 | 104.4062 | 29600.0 |
| 2000-05-04 13:30:00 | DIA | ETF | 104.375 | 104.9375 | 104.375 | 104.5625 | 53100.0 |
| 2000-05-04 14:00:00 | DIA | ETF | 104.5 | 104.5938 | 104.1875 | 104.5 | 25000.0 |
| 2000-05-04 14:30:00 | DIA | ETF | 104.5 | 104.5625 | 103.7812 | 104.4688 | 90100.0 |
| 2000-05-04 15:00:00 | DIA | ETF | 104.25 | 104.6875 | 104.0625 | 104.0625 | 121200.0 |
| 2000-05-04 15:30:00 | DIA | ETF | 104.0312 | 104.75 | 103.9375 | 104.0 | 160000.0 |
| 2000-05-04 16:00:00 | DIA | ETF | 104.125 | 104.4375 | 103.9375 | 104.3125 | 41300.0 |
> showing 46 of 194 rows — these rows as CSV