PREVIEW / etf_30min / 2000-12-14
file: by_date/etf_30min/2000/2000-12-14.parquet size: 12 KB rows: 314
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-12-14 09:30:00 | SPY | ETF | 135.875 | 136.5 | 135.75 | 136.125 | 742800.0 |
| 2000-12-14 10:00:00 | SPY | ETF | 136.125 | 136.1562 | 135.3438 | 135.4062 | 319300.0 |
| 2000-12-14 10:30:00 | SPY | ETF | 135.375 | 135.5312 | 134.5625 | 135.25 | 1028000.0 |
| 2000-12-14 11:00:00 | SPY | ETF | 135.5 | 135.7812 | 135.0625 | 135.1875 | 843300.0 |
| 2000-12-14 11:30:00 | SPY | ETF | 135.25 | 135.875 | 135.0312 | 135.875 | 357900.0 |
| 2000-12-14 12:00:00 | SPY | ETF | 135.875 | 136.1875 | 135.5 | 135.6875 | 474300.0 |
| 2000-12-14 12:30:00 | SPY | ETF | 135.6875 | 135.9062 | 135.1562 | 135.5 | 267900.0 |
| 2000-12-14 13:00:00 | SPY | ETF | 135.5 | 135.7188 | 135.2188 | 135.5312 | 134300.0 |
| 2000-12-14 13:30:00 | SPY | ETF | 135.5 | 135.6562 | 135.125 | 135.2812 | 227800.0 |
| 2000-12-14 14:00:00 | SPY | ETF | 135.125 | 135.375 | 134.9688 | 135.0938 | 228200.0 |
| 2000-12-14 14:30:00 | SPY | ETF | 135.0625 | 135.3125 | 134.75 | 135.3125 | 466600.0 |
| 2000-12-14 15:00:00 | SPY | ETF | 135.4062 | 135.7812 | 134.9375 | 134.9375 | 462600.0 |
| 2000-12-14 15:30:00 | SPY | ETF | 134.875 | 135.3125 | 134.1875 | 134.1875 | 1531900.0 |
| 2000-12-14 16:00:00 | SPY | ETF | 134.375 | 134.5 | 133.625 | 133.6875 | 426700.0 |
| 2000-12-14 16:30:00 | SPY | ETF | 134.4062 | 134.4062 | 134.0 | 134.0 | 800.0 |
| 2000-12-14 17:00:00 | SPY | ETF | 134.0 | 134.0 | 134.0 | 134.0 | 100.0 |
| 2000-12-14 17:30:00 | SPY | ETF | 133.625 | 133.625 | 133.625 | 133.625 | 400.0 |
| 2000-12-14 09:30:00 | QQQ | ETF | 68.5 | 69.6875 | 68.0625 | 68.9062 | 4448900.0 |
| 2000-12-14 10:00:00 | QQQ | ETF | 68.875 | 69.0312 | 67.8125 | 68.0 | 3710700.0 |
| 2000-12-14 10:30:00 | QQQ | ETF | 67.9375 | 68.3125 | 67.125 | 68.0 | 5342300.0 |
| 2000-12-14 11:00:00 | QQQ | ETF | 67.9375 | 68.625 | 67.75 | 67.875 | 2485800.0 |
| 2000-12-14 11:30:00 | QQQ | ETF | 67.9375 | 68.5312 | 67.7188 | 68.5 | 1806300.0 |
| 2000-12-14 12:00:00 | QQQ | ETF | 68.4375 | 68.9375 | 68.25 | 68.5625 | 2071800.0 |
| 2000-12-14 12:30:00 | QQQ | ETF | 68.5938 | 68.6875 | 68.0 | 68.0625 | 843900.0 |
| 2000-12-14 13:00:00 | QQQ | ETF | 68.0312 | 68.2188 | 67.625 | 67.9062 | 1069400.0 |
| 2000-12-14 13:30:00 | QQQ | ETF | 67.875 | 68.125 | 67.5 | 67.5625 | 1513600.0 |
| 2000-12-14 14:00:00 | QQQ | ETF | 67.5 | 67.625 | 67.0312 | 67.3125 | 2072400.0 |
| 2000-12-14 14:30:00 | QQQ | ETF | 67.25 | 67.5 | 66.8125 | 67.5 | 2627800.0 |
| 2000-12-14 15:00:00 | QQQ | ETF | 67.5 | 67.875 | 67.0625 | 67.1875 | 2733700.0 |
| 2000-12-14 15:30:00 | QQQ | ETF | 67.1875 | 67.375 | 65.625 | 65.875 | 5439200.0 |
| 2000-12-14 16:00:00 | QQQ | ETF | 65.75 | 66.375 | 63.0 | 64.375 | 2249500.0 |
| 2000-12-14 16:30:00 | QQQ | ETF | 64.7188 | 65.125 | 64.0 | 64.8125 | 725800.0 |
| 2000-12-14 17:00:00 | QQQ | ETF | 64.6875 | 65.5 | 64.25 | 64.375 | 195400.0 |
| 2000-12-14 17:30:00 | QQQ | ETF | 64.1875 | 65.0 | 64.0 | 64.125 | 210000.0 |
| 2000-12-14 18:00:00 | QQQ | ETF | 64.125 | 64.25 | 64.0625 | 64.0625 | 89700.0 |
| 2000-12-14 18:30:00 | QQQ | ETF | 64.125 | 64.125 | 64.125 | 64.125 | 100.0 |
| 2000-12-14 09:30:00 | IWM | ETF | 46.5 | 46.8438 | 46.5 | 46.6562 | 14000.0 |
| 2000-12-14 10:00:00 | IWM | ETF | 46.5625 | 46.5625 | 46.3438 | 46.5 | 29000.0 |
| 2000-12-14 10:30:00 | IWM | ETF | 46.3594 | 46.3594 | 45.9062 | 46.25 | 34200.0 |
| 2000-12-14 11:00:00 | IWM | ETF | 46.125 | 46.375 | 46.125 | 46.1875 | 47600.0 |
| 2000-12-14 11:30:00 | IWM | ETF | 46.1562 | 46.2812 | 46.1562 | 46.25 | 28200.0 |
| 2000-12-14 12:00:00 | IWM | ETF | 46.25 | 46.25 | 46.125 | 46.125 | 22400.0 |
| 2000-12-14 12:30:00 | IWM | ETF | 46.2188 | 46.2188 | 46.125 | 46.125 | 40200.0 |
| 2000-12-14 13:00:00 | IWM | ETF | 46.1406 | 46.1406 | 46.1406 | 46.1406 | 600.0 |
| 2000-12-14 13:30:00 | IWM | ETF | 46.0 | 46.125 | 46.0 | 46.0625 | 16000.0 |
| 2000-12-14 14:00:00 | IWM | ETF | 45.9375 | 45.9375 | 45.875 | 45.875 | 2200.0 |
| 2000-12-14 14:30:00 | IWM | ETF | 45.9062 | 45.9688 | 45.9062 | 45.9219 | 87400.0 |
| 2000-12-14 15:00:00 | IWM | ETF | 45.875 | 46.1562 | 45.875 | 46.0 | 42000.0 |
| 2000-12-14 15:30:00 | IWM | ETF | 45.8906 | 46.0625 | 45.875 | 46.0 | 146800.0 |
| 2000-12-14 16:00:00 | IWM | ETF | 45.875 | 45.875 | 45.875 | 45.875 | 50000.0 |
> showing 50 of 314 rows — these rows as CSV