PREVIEW / etf_30min / 2000-10-10
file: by_date/etf_30min/2000/2000-10-10.parquet size: 12 KB rows: 275
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-10 09:30:00 | SPY | ETF | 140.0938 | 141.1562 | 140.0938 | 141.1562 | 1205700.0 |
| 2000-10-10 10:00:00 | SPY | ETF | 141.0625 | 141.25 | 140.4375 | 140.5312 | 479200.0 |
| 2000-10-10 10:30:00 | SPY | ETF | 140.625 | 141.0312 | 140.0312 | 140.125 | 227900.0 |
| 2000-10-10 11:00:00 | SPY | ETF | 140.0312 | 141.0 | 140.0312 | 140.3125 | 443200.0 |
| 2000-10-10 11:30:00 | SPY | ETF | 140.3438 | 140.5 | 139.75 | 139.75 | 322900.0 |
| 2000-10-10 12:00:00 | SPY | ETF | 139.6562 | 140.0 | 139.5 | 139.5312 | 345100.0 |
| 2000-10-10 12:30:00 | SPY | ETF | 139.5312 | 139.75 | 139.0 | 139.25 | 785500.0 |
| 2000-10-10 13:00:00 | SPY | ETF | 139.2812 | 140.125 | 139.2812 | 140.125 | 237500.0 |
| 2000-10-10 13:30:00 | SPY | ETF | 140.2812 | 140.2812 | 139.5938 | 140.0 | 118700.0 |
| 2000-10-10 14:00:00 | SPY | ETF | 140.0625 | 140.2188 | 138.75 | 139.3125 | 292500.0 |
| 2000-10-10 14:30:00 | SPY | ETF | 139.2812 | 139.625 | 138.6875 | 139.0625 | 336600.0 |
| 2000-10-10 15:00:00 | SPY | ETF | 139.1562 | 139.4062 | 138.5625 | 138.7812 | 358300.0 |
| 2000-10-10 15:30:00 | SPY | ETF | 138.9375 | 139.6562 | 138.7812 | 138.875 | 534700.0 |
| 2000-10-10 16:00:00 | SPY | ETF | 138.8125 | 138.9375 | 137.6875 | 137.6875 | 385300.0 |
| 2000-10-10 16:30:00 | SPY | ETF | 137.6875 | 137.6875 | 137.6875 | 137.6875 | 1700.0 |
| 2000-10-10 17:30:00 | SPY | ETF | 138.0 | 138.0 | 138.0 | 138.0 | 200.0 |
| 2000-10-10 09:30:00 | QQQ | ETF | 81.8125 | 83.25 | 81.375 | 83.25 | 4689000.0 |
| 2000-10-10 10:00:00 | QQQ | ETF | 83.25 | 83.3125 | 81.8125 | 82.125 | 3055200.0 |
| 2000-10-10 10:30:00 | QQQ | ETF | 82.2188 | 82.5625 | 81.125 | 81.375 | 2623400.0 |
| 2000-10-10 11:00:00 | QQQ | ETF | 81.25 | 82.0 | 80.75 | 80.9375 | 1673900.0 |
| 2000-10-10 11:30:00 | QQQ | ETF | 80.9375 | 81.1875 | 80.3125 | 80.375 | 2226100.0 |
| 2000-10-10 12:00:00 | QQQ | ETF | 80.25 | 81.0 | 80.125 | 80.4688 | 1948300.0 |
| 2000-10-10 12:30:00 | QQQ | ETF | 80.375 | 80.75 | 80.0 | 80.4375 | 1842800.0 |
| 2000-10-10 13:00:00 | QQQ | ETF | 80.375 | 81.375 | 80.375 | 81.3125 | 1707900.0 |
| 2000-10-10 13:30:00 | QQQ | ETF | 81.25 | 81.4375 | 80.625 | 81.0312 | 1540700.0 |
| 2000-10-10 14:00:00 | QQQ | ETF | 81.0 | 81.125 | 79.75 | 80.25 | 2446400.0 |
| 2000-10-10 14:30:00 | QQQ | ETF | 80.1875 | 80.6562 | 79.625 | 79.8125 | 2117700.0 |
| 2000-10-10 15:00:00 | QQQ | ETF | 79.9375 | 80.25 | 79.125 | 79.8125 | 2995000.0 |
| 2000-10-10 15:30:00 | QQQ | ETF | 79.6875 | 80.75 | 79.5 | 79.5 | 3553000.0 |
| 2000-10-10 16:00:00 | QQQ | ETF | 79.5 | 79.75 | 77.625 | 78.125 | 2324700.0 |
| 2000-10-10 16:30:00 | QQQ | ETF | 78.0 | 80.75 | 78.0 | 78.5625 | 123200.0 |
| 2000-10-10 17:00:00 | QQQ | ETF | 78.5625 | 78.75 | 78.1875 | 78.5 | 105000.0 |
| 2000-10-10 17:30:00 | QQQ | ETF | 78.5 | 78.5 | 77.75 | 77.75 | 83100.0 |
| 2000-10-10 18:00:00 | QQQ | ETF | 77.8125 | 78.6875 | 77.375 | 77.6875 | 48000.0 |
| 2000-10-10 09:30:00 | IWM | ETF | 48.7969 | 48.9688 | 48.6562 | 48.875 | 88400.0 |
| 2000-10-10 10:00:00 | IWM | ETF | 49.0 | 49.0469 | 48.8125 | 48.8125 | 5200.0 |
| 2000-10-10 10:30:00 | IWM | ETF | 48.8125 | 48.8125 | 48.75 | 48.75 | 21200.0 |
| 2000-10-10 11:30:00 | IWM | ETF | 48.7656 | 48.7656 | 48.75 | 48.75 | 4800.0 |
| 2000-10-10 12:00:00 | IWM | ETF | 48.5312 | 48.6406 | 48.5312 | 48.6406 | 1600.0 |
| 2000-10-10 12:30:00 | IWM | ETF | 48.375 | 48.375 | 48.375 | 48.375 | 4200.0 |
| 2000-10-10 13:00:00 | IWM | ETF | 48.4375 | 48.4844 | 48.4375 | 48.4844 | 3800.0 |
| 2000-10-10 13:30:00 | IWM | ETF | 48.5312 | 48.5312 | 48.5312 | 48.5312 | 1400.0 |
| 2000-10-10 14:00:00 | IWM | ETF | 48.2969 | 48.2969 | 48.2969 | 48.2969 | 1200.0 |
| 2000-10-10 14:30:00 | IWM | ETF | 48.25 | 48.25 | 48.1094 | 48.1094 | 400.0 |
| 2000-10-10 15:00:00 | IWM | ETF | 48.1406 | 48.2656 | 47.9688 | 47.9688 | 4800.0 |
| 2000-10-10 15:30:00 | IWM | ETF | 48.0 | 48.125 | 47.9688 | 48.125 | 282800.0 |
| 2000-10-10 16:00:00 | IWM | ETF | 47.875 | 47.875 | 47.5625 | 47.5625 | 600.0 |
| 2000-10-10 09:30:00 | DIA | ETF | 106.0 | 106.25 | 105.7188 | 106.0312 | 53200.0 |
| 2000-10-10 10:00:00 | DIA | ETF | 106.125 | 106.1875 | 105.7812 | 105.9375 | 30200.0 |
| 2000-10-10 10:30:00 | DIA | ETF | 105.8438 | 106.2188 | 105.8438 | 105.9375 | 25900.0 |
> showing 50 of 275 rows — these rows as CSV