PREVIEW / etf_30min / 2000-10-25
file: by_date/etf_30min/2000/2000-10-25.parquet size: 12 KB rows: 284
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-25 09:30:00 | SPY | ETF | 138.75 | 138.75 | 137.5312 | 138.2188 | 1271100.0 |
| 2000-10-25 10:00:00 | SPY | ETF | 138.1875 | 139.0625 | 137.9375 | 138.7812 | 801800.0 |
| 2000-10-25 10:30:00 | SPY | ETF | 138.75 | 139.4688 | 138.625 | 139.0312 | 753800.0 |
| 2000-10-25 11:00:00 | SPY | ETF | 139.0312 | 139.5625 | 138.8125 | 138.9375 | 282900.0 |
| 2000-10-25 11:30:00 | SPY | ETF | 139.0625 | 139.1562 | 138.25 | 138.3125 | 128700.0 |
| 2000-10-25 12:00:00 | SPY | ETF | 138.4375 | 138.6875 | 138.0625 | 138.1875 | 465800.0 |
| 2000-10-25 12:30:00 | SPY | ETF | 138.0625 | 138.625 | 138.0625 | 138.25 | 149200.0 |
| 2000-10-25 13:00:00 | SPY | ETF | 138.0625 | 138.2188 | 137.375 | 137.625 | 245100.0 |
| 2000-10-25 13:30:00 | SPY | ETF | 137.625 | 138.25 | 137.5 | 137.9688 | 409900.0 |
| 2000-10-25 14:00:00 | SPY | ETF | 137.875 | 138.5312 | 137.5 | 138.3125 | 490700.0 |
| 2000-10-25 14:30:00 | SPY | ETF | 138.375 | 138.375 | 137.3125 | 137.3125 | 290900.0 |
| 2000-10-25 15:00:00 | SPY | ETF | 137.2812 | 137.5625 | 136.6562 | 137.4062 | 1088000.0 |
| 2000-10-25 15:30:00 | SPY | ETF | 137.3438 | 137.375 | 136.375 | 136.9062 | 987400.0 |
| 2000-10-25 16:00:00 | SPY | ETF | 136.875 | 136.875 | 136.125 | 136.375 | 1382200.0 |
| 2000-10-25 16:30:00 | SPY | ETF | 136.3125 | 139.375 | 136.0625 | 136.0625 | 44800.0 |
| 2000-10-25 17:30:00 | SPY | ETF | 136.25 | 137.0 | 136.25 | 137.0 | 2200.0 |
| 2000-10-25 18:00:00 | SPY | ETF | 136.5 | 136.5 | 136.4375 | 136.4375 | 1500.0 |
| 2000-10-25 09:30:00 | QQQ | ETF | 81.25 | 81.5 | 79.6875 | 80.875 | 8600200.0 |
| 2000-10-25 10:00:00 | QQQ | ETF | 80.75 | 81.3438 | 80.3125 | 81.2188 | 5745500.0 |
| 2000-10-25 10:30:00 | QQQ | ETF | 81.1875 | 82.0 | 80.875 | 81.375 | 2878600.0 |
| 2000-10-25 11:00:00 | QQQ | ETF | 81.3125 | 82.0 | 81.0625 | 81.375 | 1297200.0 |
| 2000-10-25 11:30:00 | QQQ | ETF | 81.25 | 81.375 | 79.9375 | 80.0625 | 2733600.0 |
| 2000-10-25 12:00:00 | QQQ | ETF | 80.125 | 80.4375 | 79.25 | 79.25 | 2566400.0 |
| 2000-10-25 12:30:00 | QQQ | ETF | 79.375 | 80.1562 | 79.25 | 79.625 | 2374000.0 |
| 2000-10-25 13:00:00 | QQQ | ETF | 79.6875 | 80.0938 | 78.25 | 78.8438 | 3466500.0 |
| 2000-10-25 13:30:00 | QQQ | ETF | 78.75 | 79.6562 | 78.5625 | 79.1562 | 2275300.0 |
| 2000-10-25 14:00:00 | QQQ | ETF | 79.0312 | 79.8125 | 78.5 | 79.4688 | 1920100.0 |
| 2000-10-25 14:30:00 | QQQ | ETF | 79.5 | 79.625 | 78.1875 | 78.25 | 2356400.0 |
| 2000-10-25 15:00:00 | QQQ | ETF | 78.25 | 78.4688 | 77.5 | 78.375 | 4410200.0 |
| 2000-10-25 15:30:00 | QQQ | ETF | 78.3125 | 78.375 | 76.875 | 77.6875 | 5607300.0 |
| 2000-10-25 16:00:00 | QQQ | ETF | 77.6875 | 78.0 | 76.875 | 77.75 | 1245400.0 |
| 2000-10-25 16:30:00 | QQQ | ETF | 77.6875 | 79.9375 | 77.625 | 77.625 | 26300.0 |
| 2000-10-25 17:00:00 | QQQ | ETF | 77.6875 | 78.125 | 77.625 | 77.75 | 18000.0 |
| 2000-10-25 17:30:00 | QQQ | ETF | 77.9375 | 78.25 | 77.75 | 78.125 | 3400.0 |
| 2000-10-25 18:00:00 | QQQ | ETF | 78.125 | 78.4375 | 77.875 | 78.0 | 4200.0 |
| 2000-10-25 09:30:00 | IWM | ETF | 48.25 | 48.25 | 47.6875 | 48.0625 | 17000.0 |
| 2000-10-25 10:00:00 | IWM | ETF | 48.125 | 48.25 | 48.0938 | 48.0938 | 1200.0 |
| 2000-10-25 10:30:00 | IWM | ETF | 48.1719 | 48.1719 | 48.1719 | 48.1719 | 400.0 |
| 2000-10-25 11:00:00 | IWM | ETF | 48.4062 | 48.5 | 48.4062 | 48.4844 | 600.0 |
| 2000-10-25 11:30:00 | IWM | ETF | 48.25 | 48.25 | 48.25 | 48.25 | 200.0 |
| 2000-10-25 12:00:00 | IWM | ETF | 47.9531 | 47.9531 | 47.9531 | 47.9531 | 1400.0 |
| 2000-10-25 12:30:00 | IWM | ETF | 48.0312 | 48.0938 | 48.0312 | 48.0938 | 1400.0 |
| 2000-10-25 13:00:00 | IWM | ETF | 47.8125 | 47.8125 | 47.8125 | 47.8125 | 200.0 |
| 2000-10-25 14:00:00 | IWM | ETF | 47.75 | 47.8906 | 47.75 | 47.8906 | 1000.0 |
| 2000-10-25 14:30:00 | IWM | ETF | 47.7812 | 47.7812 | 47.7812 | 47.7812 | 1600.0 |
| 2000-10-25 15:00:00 | IWM | ETF | 47.7344 | 47.7344 | 47.4375 | 47.625 | 6400.0 |
| 2000-10-25 15:30:00 | IWM | ETF | 47.4375 | 47.4375 | 47.4375 | 47.4375 | 400.0 |
| 2000-10-25 16:00:00 | IWM | ETF | 47.2656 | 47.2656 | 47.2656 | 47.2656 | 200.0 |
| 2000-10-25 09:30:00 | DIA | ETF | 103.5625 | 103.5625 | 102.7188 | 103.25 | 216700.0 |
| 2000-10-25 10:00:00 | DIA | ETF | 103.25 | 103.9375 | 103.1875 | 103.9062 | 187400.0 |
> showing 50 of 284 rows — these rows as CSV