PREVIEW / etf_30min / 2000-12-19
file: by_date/etf_30min/2000/2000-12-19.parquet size: 13 KB rows: 326
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-19 09:30:00 | SPY | ETF | 132.4688 | 133.3438 | 132.0 | 133.2188 | 655600.0 |
| 2000-12-19 10:00:00 | SPY | ETF | 133.375 | 133.5625 | 133.0 | 133.25 | 489300.0 |
| 2000-12-19 10:30:00 | SPY | ETF | 133.1562 | 133.5938 | 133.0312 | 133.1875 | 270800.0 |
| 2000-12-19 11:00:00 | SPY | ETF | 133.125 | 133.5938 | 133.0625 | 133.5625 | 179400.0 |
| 2000-12-19 11:30:00 | SPY | ETF | 133.4375 | 133.75 | 133.2812 | 133.75 | 410900.0 |
| 2000-12-19 12:00:00 | SPY | ETF | 133.75 | 133.9688 | 133.625 | 133.8125 | 250200.0 |
| 2000-12-19 12:30:00 | SPY | ETF | 133.7188 | 134.0 | 133.625 | 133.9688 | 150800.0 |
| 2000-12-19 13:00:00 | SPY | ETF | 134.0 | 134.4062 | 133.875 | 134.3438 | 330800.0 |
| 2000-12-19 13:30:00 | SPY | ETF | 134.2188 | 134.9688 | 134.1875 | 134.7188 | 462200.0 |
| 2000-12-19 14:00:00 | SPY | ETF | 134.8125 | 134.875 | 132.5 | 133.8125 | 1710000.0 |
| 2000-12-19 14:30:00 | SPY | ETF | 134.0 | 134.3438 | 132.5625 | 132.7188 | 589700.0 |
| 2000-12-19 15:00:00 | SPY | ETF | 132.625 | 132.8438 | 131.0312 | 131.7188 | 1797500.0 |
| 2000-12-19 15:30:00 | SPY | ETF | 131.6875 | 131.6875 | 130.5 | 130.5625 | 1162900.0 |
| 2000-12-19 16:00:00 | SPY | ETF | 130.7188 | 130.7188 | 130.0312 | 130.0312 | 523500.0 |
| 2000-12-19 16:30:00 | SPY | ETF | 130.0 | 130.0312 | 130.0 | 130.0 | 2600.0 |
| 2000-12-19 17:00:00 | SPY | ETF | 130.0 | 130.0 | 130.0 | 130.0 | 700.0 |
| 2000-12-19 17:30:00 | SPY | ETF | 130.0 | 130.0 | 130.0 | 130.0 | 100.0 |
| 2000-12-19 18:00:00 | SPY | ETF | 130.25 | 130.25 | 130.25 | 130.25 | 8000.0 |
| 2000-12-19 09:30:00 | QQQ | ETF | 63.4375 | 64.9375 | 62.875 | 64.75 | 5678300.0 |
| 2000-12-19 10:00:00 | QQQ | ETF | 64.6562 | 65.125 | 64.25 | 65.0625 | 4416200.0 |
| 2000-12-19 10:30:00 | QQQ | ETF | 64.9375 | 65.3438 | 64.625 | 64.625 | 3706800.0 |
| 2000-12-19 11:00:00 | QQQ | ETF | 64.625 | 65.125 | 64.5 | 65.0 | 1339300.0 |
| 2000-12-19 11:30:00 | QQQ | ETF | 65.0 | 65.625 | 64.7812 | 65.5312 | 1773800.0 |
| 2000-12-19 12:00:00 | QQQ | ETF | 65.5 | 65.7188 | 65.0312 | 65.0625 | 2490400.0 |
| 2000-12-19 12:30:00 | QQQ | ETF | 65.125 | 65.4375 | 65.0312 | 65.4062 | 1475900.0 |
| 2000-12-19 13:00:00 | QQQ | ETF | 65.3125 | 65.5625 | 65.1875 | 65.375 | 1739300.0 |
| 2000-12-19 13:30:00 | QQQ | ETF | 65.375 | 65.8438 | 65.125 | 65.25 | 4217500.0 |
| 2000-12-19 14:00:00 | QQQ | ETF | 65.3125 | 65.4375 | 62.375 | 64.25 | 16937100.0 |
| 2000-12-19 14:30:00 | QQQ | ETF | 64.25 | 65.0 | 62.25 | 62.375 | 7646900.0 |
| 2000-12-19 15:00:00 | QQQ | ETF | 62.3125 | 62.5 | 60.5625 | 61.375 | 10574700.0 |
| 2000-12-19 15:30:00 | QQQ | ETF | 61.4375 | 61.625 | 59.7812 | 60.0 | 12653600.0 |
| 2000-12-19 16:00:00 | QQQ | ETF | 59.8125 | 60.25 | 58.75 | 59.0 | 2172300.0 |
| 2000-12-19 16:30:00 | QQQ | ETF | 59.0938 | 65.75 | 58.75 | 59.0938 | 120100.0 |
| 2000-12-19 17:00:00 | QQQ | ETF | 59.125 | 60.0625 | 58.75 | 59.0625 | 154900.0 |
| 2000-12-19 17:30:00 | QQQ | ETF | 59.0312 | 60.0 | 59.0 | 59.1875 | 45200.0 |
| 2000-12-19 18:00:00 | QQQ | ETF | 59.25 | 59.5 | 59.0 | 59.25 | 19400.0 |
| 2000-12-19 09:30:00 | IWM | ETF | 46.25 | 46.25 | 45.9375 | 46.125 | 15200.0 |
| 2000-12-19 10:00:00 | IWM | ETF | 46.3125 | 46.3281 | 46.3125 | 46.3125 | 9800.0 |
| 2000-12-19 10:30:00 | IWM | ETF | 46.4688 | 46.4688 | 46.375 | 46.375 | 28200.0 |
| 2000-12-19 11:00:00 | IWM | ETF | 46.375 | 46.5312 | 46.3438 | 46.5312 | 7000.0 |
| 2000-12-19 11:30:00 | IWM | ETF | 46.375 | 46.4375 | 46.375 | 46.4375 | 5400.0 |
| 2000-12-19 12:00:00 | IWM | ETF | 46.4375 | 46.5938 | 46.4375 | 46.5938 | 25200.0 |
| 2000-12-19 12:30:00 | IWM | ETF | 46.5938 | 46.5938 | 46.5781 | 46.5781 | 5200.0 |
| 2000-12-19 13:00:00 | IWM | ETF | 46.5781 | 46.5781 | 46.5781 | 46.5781 | 1000.0 |
| 2000-12-19 13:30:00 | IWM | ETF | 46.6094 | 46.6875 | 46.5625 | 46.6875 | 114400.0 |
| 2000-12-19 14:00:00 | IWM | ETF | 46.5625 | 46.75 | 46.1875 | 46.5938 | 39800.0 |
| 2000-12-19 14:30:00 | IWM | ETF | 46.5 | 46.5312 | 46.1875 | 46.1875 | 39400.0 |
| 2000-12-19 15:00:00 | IWM | ETF | 46.1562 | 46.1562 | 45.6562 | 46.0 | 70600.0 |
| 2000-12-19 15:30:00 | IWM | ETF | 45.9375 | 46.0 | 45.5 | 45.625 | 46200.0 |
| 2000-12-19 16:00:00 | IWM | ETF | 45.5 | 45.5625 | 45.5 | 45.5625 | 34000.0 |
> showing 50 of 326 rows — these rows as CSV