PREVIEW / etf_30min / 2000-11-15
file: by_date/etf_30min/2000/2000-11-15.parquet size: 12 KB rows: 288
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-15 09:30:00 | SPY | ETF | 139.0625 | 139.0625 | 138.3125 | 138.4375 | 617300.0 |
| 2000-11-15 10:00:00 | SPY | ETF | 138.375 | 138.9375 | 138.0938 | 138.75 | 445000.0 |
| 2000-11-15 10:30:00 | SPY | ETF | 138.9375 | 139.4062 | 138.5312 | 139.2812 | 562100.0 |
| 2000-11-15 11:00:00 | SPY | ETF | 139.3438 | 139.375 | 138.875 | 138.875 | 214700.0 |
| 2000-11-15 11:30:00 | SPY | ETF | 138.9688 | 139.3438 | 138.8438 | 139.3125 | 293800.0 |
| 2000-11-15 12:00:00 | SPY | ETF | 139.375 | 139.625 | 139.2812 | 139.4688 | 200200.0 |
| 2000-11-15 12:30:00 | SPY | ETF | 139.4688 | 139.75 | 139.375 | 139.375 | 358600.0 |
| 2000-11-15 13:00:00 | SPY | ETF | 139.4375 | 139.9375 | 139.375 | 139.75 | 294200.0 |
| 2000-11-15 13:30:00 | SPY | ETF | 139.75 | 139.9062 | 139.5 | 139.5 | 424100.0 |
| 2000-11-15 14:00:00 | SPY | ETF | 139.5938 | 140.0938 | 138.4062 | 138.5312 | 1436300.0 |
| 2000-11-15 14:30:00 | SPY | ETF | 138.625 | 139.1562 | 137.75 | 138.2188 | 1133200.0 |
| 2000-11-15 15:00:00 | SPY | ETF | 138.25 | 138.625 | 138.0 | 138.4375 | 549600.0 |
| 2000-11-15 15:30:00 | SPY | ETF | 138.3438 | 139.25 | 138.25 | 139.1875 | 973000.0 |
| 2000-11-15 16:00:00 | SPY | ETF | 139.125 | 139.625 | 137.9688 | 139.5625 | 980300.0 |
| 2000-11-15 16:30:00 | SPY | ETF | 139.5625 | 139.5625 | 139.5 | 139.5 | 4600.0 |
| 2000-11-15 18:00:00 | SPY | ETF | 139.0 | 139.0 | 139.0 | 139.0 | 300.0 |
| 2000-11-15 09:30:00 | QQQ | ETF | 75.5625 | 76.25 | 75.375 | 75.4375 | 3554000.0 |
| 2000-11-15 10:00:00 | QQQ | ETF | 75.4062 | 76.2188 | 75.25 | 76.0938 | 2624100.0 |
| 2000-11-15 10:30:00 | QQQ | ETF | 76.0938 | 76.9375 | 75.75 | 76.8438 | 2869700.0 |
| 2000-11-15 11:00:00 | QQQ | ETF | 76.8438 | 77.125 | 76.4062 | 76.5312 | 2039000.0 |
| 2000-11-15 11:30:00 | QQQ | ETF | 76.5312 | 77.1875 | 76.5 | 77.1875 | 1086000.0 |
| 2000-11-15 12:00:00 | QQQ | ETF | 77.1875 | 77.4688 | 77.0 | 77.375 | 1259900.0 |
| 2000-11-15 12:30:00 | QQQ | ETF | 77.4375 | 77.75 | 77.375 | 77.4375 | 1790400.0 |
| 2000-11-15 13:00:00 | QQQ | ETF | 77.4375 | 78.0312 | 77.0 | 77.7812 | 1476400.0 |
| 2000-11-15 13:30:00 | QQQ | ETF | 77.8125 | 78.0625 | 77.375 | 77.4375 | 2115000.0 |
| 2000-11-15 14:00:00 | QQQ | ETF | 77.4375 | 77.875 | 76.0625 | 76.375 | 6744100.0 |
| 2000-11-15 14:30:00 | QQQ | ETF | 76.3125 | 77.1875 | 75.25 | 75.625 | 3898500.0 |
| 2000-11-15 15:00:00 | QQQ | ETF | 75.625 | 75.875 | 74.7812 | 75.625 | 3053200.0 |
| 2000-11-15 15:30:00 | QQQ | ETF | 75.5625 | 76.875 | 75.25 | 76.8125 | 2611300.0 |
| 2000-11-15 16:00:00 | QQQ | ETF | 76.8125 | 77.375 | 76.625 | 77.1875 | 774100.0 |
| 2000-11-15 16:30:00 | QQQ | ETF | 77.25 | 77.75 | 76.9688 | 77.5 | 74600.0 |
| 2000-11-15 17:00:00 | QQQ | ETF | 77.4375 | 77.625 | 76.875 | 77.0 | 25500.0 |
| 2000-11-15 17:30:00 | QQQ | ETF | 76.9375 | 77.4375 | 76.875 | 77.0 | 3800.0 |
| 2000-11-15 18:00:00 | QQQ | ETF | 77.0 | 77.1875 | 76.8125 | 77.0625 | 5900.0 |
| 2000-11-15 09:30:00 | IWM | ETF | 48.7188 | 48.75 | 48.5625 | 48.5625 | 26600.0 |
| 2000-11-15 10:00:00 | IWM | ETF | 48.6562 | 48.7812 | 48.6562 | 48.7812 | 170400.0 |
| 2000-11-15 10:30:00 | IWM | ETF | 48.9062 | 49.1094 | 48.8125 | 48.9375 | 27800.0 |
| 2000-11-15 11:00:00 | IWM | ETF | 49.125 | 49.125 | 49.0 | 49.0 | 11200.0 |
| 2000-11-15 11:30:00 | IWM | ETF | 49.0312 | 49.1875 | 48.9688 | 49.1875 | 42400.0 |
| 2000-11-15 12:00:00 | IWM | ETF | 49.1719 | 49.2188 | 49.1719 | 49.2188 | 1400.0 |
| 2000-11-15 12:30:00 | IWM | ETF | 49.0781 | 49.2656 | 49.0781 | 49.25 | 5600.0 |
| 2000-11-15 13:30:00 | IWM | ETF | 49.4062 | 49.4062 | 49.4062 | 49.4062 | 800.0 |
| 2000-11-15 14:00:00 | IWM | ETF | 49.4375 | 49.4375 | 49.1406 | 49.2812 | 5600.0 |
| 2000-11-15 14:30:00 | IWM | ETF | 49.0938 | 49.0938 | 49.0938 | 49.0938 | 200.0 |
| 2000-11-15 15:00:00 | IWM | ETF | 48.9062 | 48.9062 | 48.75 | 48.75 | 23800.0 |
| 2000-11-15 15:30:00 | IWM | ETF | 49.0938 | 49.3125 | 49.0938 | 49.2188 | 9800.0 |
| 2000-11-15 16:00:00 | IWM | ETF | 49.3125 | 49.3125 | 49.0938 | 49.2812 | 95400.0 |
| 2000-11-15 09:30:00 | DIA | ETF | 106.875 | 107.1562 | 106.625 | 106.625 | 38500.0 |
| 2000-11-15 10:00:00 | DIA | ETF | 106.625 | 107.25 | 106.625 | 107.125 | 21800.0 |
| 2000-11-15 10:30:00 | DIA | ETF | 107.25 | 107.5625 | 107.125 | 107.4688 | 38900.0 |
> showing 50 of 288 rows — these rows as CSV