PREVIEW / etf_30min / 2000-05-12
file: by_date/etf_30min/2000/2000-05-12.parquet size: 9 KB rows: 187
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-12 09:30:00 | SPY | ETF | 141.8125 | 142.5938 | 141.625 | 142.3125 | 2599300.0 |
| 2000-05-12 10:00:00 | SPY | ETF | 142.4375 | 143.2188 | 142.4375 | 142.5625 | 464700.0 |
| 2000-05-12 10:30:00 | SPY | ETF | 142.75 | 143.1562 | 142.625 | 142.9688 | 320300.0 |
| 2000-05-12 11:00:00 | SPY | ETF | 142.875 | 143.1562 | 142.75 | 143.1562 | 265300.0 |
| 2000-05-12 11:30:00 | SPY | ETF | 143.0625 | 143.4688 | 143.0625 | 143.375 | 273700.0 |
| 2000-05-12 12:00:00 | SPY | ETF | 143.4375 | 143.4688 | 142.9375 | 143.0 | 263900.0 |
| 2000-05-12 12:30:00 | SPY | ETF | 143.125 | 143.375 | 143.0 | 143.0312 | 178000.0 |
| 2000-05-12 13:00:00 | SPY | ETF | 143.0 | 143.25 | 142.875 | 142.875 | 125700.0 |
| 2000-05-12 13:30:00 | SPY | ETF | 142.875 | 143.0 | 142.5312 | 142.9375 | 288800.0 |
| 2000-05-12 14:00:00 | SPY | ETF | 142.9375 | 143.0625 | 142.2812 | 142.4375 | 144700.0 |
| 2000-05-12 14:30:00 | SPY | ETF | 142.625 | 143.1875 | 142.25 | 143.0 | 280100.0 |
| 2000-05-12 15:00:00 | SPY | ETF | 143.0 | 143.0938 | 142.3125 | 142.625 | 249700.0 |
| 2000-05-12 15:30:00 | SPY | ETF | 142.75 | 143.1562 | 142.1562 | 142.4062 | 276300.0 |
| 2000-05-12 16:00:00 | SPY | ETF | 142.2812 | 142.8125 | 142.2812 | 142.8125 | 225700.0 |
| 2000-05-12 16:30:00 | SPY | ETF | 142.8125 | 142.8125 | 142.8125 | 142.8125 | 100.0 |
| 2000-05-12 09:30:00 | QQQ | ETF | 85.375 | 87.0 | 84.0 | 86.6875 | 3091400.0 |
| 2000-05-12 10:00:00 | QQQ | ETF | 86.5625 | 87.4375 | 86.5 | 86.75 | 2477400.0 |
| 2000-05-12 10:30:00 | QQQ | ETF | 86.75 | 87.5 | 86.6875 | 87.2188 | 1144600.0 |
| 2000-05-12 11:00:00 | QQQ | ETF | 87.0625 | 87.375 | 86.8125 | 87.375 | 753000.0 |
| 2000-05-12 11:30:00 | QQQ | ETF | 87.1875 | 87.5625 | 87.0312 | 87.125 | 894400.0 |
| 2000-05-12 12:00:00 | QQQ | ETF | 87.25 | 87.4375 | 86.8125 | 86.875 | 1020500.0 |
| 2000-05-12 12:30:00 | QQQ | ETF | 86.875 | 87.0938 | 86.75 | 86.75 | 701000.0 |
| 2000-05-12 13:00:00 | QQQ | ETF | 86.75 | 87.0 | 86.375 | 86.4375 | 910900.0 |
| 2000-05-12 13:30:00 | QQQ | ETF | 86.375 | 86.75 | 86.125 | 86.6562 | 987200.0 |
| 2000-05-12 14:00:00 | QQQ | ETF | 86.6875 | 86.75 | 85.875 | 86.125 | 950000.0 |
| 2000-05-12 14:30:00 | QQQ | ETF | 86.0938 | 86.5 | 85.4688 | 86.125 | 1100100.0 |
| 2000-05-12 15:00:00 | QQQ | ETF | 86.125 | 86.375 | 85.0625 | 85.375 | 1321600.0 |
| 2000-05-12 15:30:00 | QQQ | ETF | 85.375 | 86.0 | 84.5625 | 84.8125 | 2055500.0 |
| 2000-05-12 16:00:00 | QQQ | ETF | 84.75 | 85.0 | 84.5 | 84.5938 | 383000.0 |
| 2000-05-12 16:30:00 | QQQ | ETF | 84.625 | 84.625 | 84.5312 | 84.625 | 1200.0 |
| 2000-05-12 17:00:00 | QQQ | ETF | 84.6875 | 84.6875 | 84.6875 | 84.6875 | 1200.0 |
| 2000-05-12 17:30:00 | QQQ | ETF | 84.625 | 84.625 | 84.5312 | 84.5312 | 300.0 |
| 2000-05-12 18:00:00 | QQQ | ETF | 84.625 | 84.625 | 84.625 | 84.625 | 200.0 |
| 2000-05-12 09:30:00 | DIA | ETF | 106.0 | 106.375 | 105.75 | 106.25 | 345900.0 |
| 2000-05-12 10:00:00 | DIA | ETF | 106.25 | 106.6875 | 106.0 | 106.3438 | 220600.0 |
| 2000-05-12 10:30:00 | DIA | ETF | 106.125 | 106.5 | 106.125 | 106.25 | 30500.0 |
| 2000-05-12 11:00:00 | DIA | ETF | 106.4375 | 106.5 | 106.125 | 106.5 | 16500.0 |
| 2000-05-12 11:30:00 | DIA | ETF | 106.5625 | 106.7812 | 106.4375 | 106.5312 | 26200.0 |
| 2000-05-12 12:00:00 | DIA | ETF | 106.5312 | 106.75 | 106.5 | 106.6875 | 45200.0 |
| 2000-05-12 12:30:00 | DIA | ETF | 106.7188 | 106.75 | 106.4375 | 106.625 | 16400.0 |
| 2000-05-12 13:00:00 | DIA | ETF | 106.625 | 106.6875 | 106.375 | 106.5625 | 7700.0 |
| 2000-05-12 13:30:00 | DIA | ETF | 106.375 | 106.5938 | 106.3125 | 106.5 | 17800.0 |
| 2000-05-12 14:00:00 | DIA | ETF | 106.4375 | 106.5312 | 106.125 | 106.125 | 32200.0 |
| 2000-05-12 14:30:00 | DIA | ETF | 106.125 | 106.5312 | 105.8125 | 106.375 | 41800.0 |
| 2000-05-12 15:00:00 | DIA | ETF | 106.4688 | 106.4688 | 105.9062 | 106.0938 | 65100.0 |
| 2000-05-12 15:30:00 | DIA | ETF | 106.2188 | 106.6562 | 105.8125 | 106.0 | 98700.0 |
| 2000-05-12 16:00:00 | DIA | ETF | 106.125 | 106.3125 | 106.0 | 106.25 | 34800.0 |
> showing 47 of 187 rows — these rows as CSV