PREVIEW / etf_30min / 2000-12-29
file: by_date/etf_30min/2000/2000-12-29.parquet size: 13 KB rows: 365
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-29 09:30:00 | SPY | ETF | 134.0625 | 134.2812 | 133.7188 | 133.8125 | 571500.0 |
| 2000-12-29 10:00:00 | SPY | ETF | 133.75 | 133.875 | 133.3125 | 133.5625 | 623200.0 |
| 2000-12-29 10:30:00 | SPY | ETF | 133.625 | 133.8125 | 133.25 | 133.5 | 374600.0 |
| 2000-12-29 11:00:00 | SPY | ETF | 133.4062 | 133.5312 | 132.875 | 132.9375 | 424900.0 |
| 2000-12-29 11:30:00 | SPY | ETF | 133.0312 | 133.5 | 133.0312 | 133.3438 | 313000.0 |
| 2000-12-29 12:00:00 | SPY | ETF | 133.3438 | 133.5938 | 133.25 | 133.4062 | 339800.0 |
| 2000-12-29 12:30:00 | SPY | ETF | 133.375 | 133.5 | 133.1875 | 133.375 | 161200.0 |
| 2000-12-29 13:00:00 | SPY | ETF | 133.375 | 133.5 | 132.7812 | 132.9062 | 508800.0 |
| 2000-12-29 13:30:00 | SPY | ETF | 132.9375 | 133.2812 | 132.625 | 133.1875 | 490200.0 |
| 2000-12-29 14:00:00 | SPY | ETF | 133.2188 | 133.4375 | 132.8125 | 133.0625 | 455300.0 |
| 2000-12-29 14:30:00 | SPY | ETF | 133.0312 | 133.4375 | 133.0312 | 133.3125 | 339400.0 |
| 2000-12-29 15:00:00 | SPY | ETF | 133.375 | 133.4062 | 132.0625 | 132.4062 | 913200.0 |
| 2000-12-29 15:30:00 | SPY | ETF | 132.4688 | 132.8438 | 131.875 | 132.25 | 1855800.0 |
| 2000-12-29 16:00:00 | SPY | ETF | 132.25 | 134.2812 | 131.1875 | 131.1875 | 1348400.0 |
| 2000-12-29 16:30:00 | SPY | ETF | 131.375 | 131.6875 | 131.3125 | 131.5 | 14000.0 |
| 2000-12-29 17:00:00 | SPY | ETF | 131.5 | 131.5 | 131.5 | 131.5 | 3000.0 |
| 2000-12-29 09:30:00 | QQQ | ETF | 61.5625 | 62.2188 | 61.25 | 61.2812 | 4490400.0 |
| 2000-12-29 10:00:00 | QQQ | ETF | 61.25 | 61.4375 | 60.375 | 60.5312 | 4402300.0 |
| 2000-12-29 10:30:00 | QQQ | ETF | 60.5938 | 60.75 | 59.9375 | 60.375 | 3795500.0 |
| 2000-12-29 11:00:00 | QQQ | ETF | 60.375 | 60.5 | 59.4688 | 59.5625 | 3394100.0 |
| 2000-12-29 11:30:00 | QQQ | ETF | 59.5625 | 60.3125 | 59.5 | 60.2812 | 2655500.0 |
| 2000-12-29 12:00:00 | QQQ | ETF | 60.25 | 60.3125 | 59.8125 | 59.9688 | 1243100.0 |
| 2000-12-29 12:30:00 | QQQ | ETF | 59.875 | 60.2188 | 59.8125 | 60.125 | 1225300.0 |
| 2000-12-29 13:00:00 | QQQ | ETF | 60.125 | 60.125 | 59.2812 | 59.2812 | 2503600.0 |
| 2000-12-29 13:30:00 | QQQ | ETF | 59.4062 | 59.875 | 59.0625 | 59.8438 | 3137400.0 |
| 2000-12-29 14:00:00 | QQQ | ETF | 59.8125 | 59.9688 | 59.125 | 59.3125 | 2352900.0 |
| 2000-12-29 14:30:00 | QQQ | ETF | 59.4062 | 59.875 | 59.25 | 59.4688 | 2063400.0 |
| 2000-12-29 15:00:00 | QQQ | ETF | 59.4375 | 59.5625 | 58.0 | 58.2812 | 5735200.0 |
| 2000-12-29 15:30:00 | QQQ | ETF | 58.3125 | 59.0 | 58.0 | 58.4375 | 9265400.0 |
| 2000-12-29 16:00:00 | QQQ | ETF | 58.4375 | 58.75 | 58.25 | 58.6875 | 2172500.0 |
| 2000-12-29 16:30:00 | QQQ | ETF | 58.5625 | 58.75 | 58.375 | 58.625 | 395200.0 |
| 2000-12-29 17:00:00 | QQQ | ETF | 58.625 | 58.9375 | 58.5 | 58.6875 | 6400.0 |
| 2000-12-29 17:30:00 | QQQ | ETF | 58.6875 | 58.6875 | 58.5 | 58.625 | 8500.0 |
| 2000-12-29 18:00:00 | QQQ | ETF | 58.625 | 58.625 | 58.5 | 58.5 | 8700.0 |
| 2000-12-29 09:30:00 | IWM | ETF | 49.4688 | 49.6094 | 49.4219 | 49.5312 | 234400.0 |
| 2000-12-29 10:00:00 | IWM | ETF | 49.5312 | 49.5625 | 49.1875 | 49.3125 | 87800.0 |
| 2000-12-29 10:30:00 | IWM | ETF | 49.2812 | 49.2812 | 49.0312 | 49.2031 | 37200.0 |
| 2000-12-29 11:00:00 | IWM | ETF | 49.1875 | 49.2344 | 48.8125 | 48.9219 | 53200.0 |
| 2000-12-29 11:30:00 | IWM | ETF | 48.9219 | 49.0 | 48.875 | 48.9375 | 105400.0 |
| 2000-12-29 12:00:00 | IWM | ETF | 49.0 | 49.125 | 48.9062 | 49.125 | 16400.0 |
| 2000-12-29 12:30:00 | IWM | ETF | 49.125 | 49.1406 | 49.0625 | 49.0625 | 106400.0 |
| 2000-12-29 13:00:00 | IWM | ETF | 49.0 | 49.0 | 48.9375 | 49.0 | 28800.0 |
| 2000-12-29 13:30:00 | IWM | ETF | 49.0 | 49.0 | 48.7812 | 48.9844 | 158200.0 |
| 2000-12-29 14:00:00 | IWM | ETF | 49.0 | 49.0312 | 48.9062 | 49.0 | 41600.0 |
| 2000-12-29 14:30:00 | IWM | ETF | 49.0 | 49.0312 | 48.875 | 49.0312 | 10600.0 |
| 2000-12-29 15:00:00 | IWM | ETF | 48.875 | 49.0 | 48.2188 | 48.4062 | 141000.0 |
| 2000-12-29 15:30:00 | IWM | ETF | 48.4375 | 48.5625 | 47.8125 | 48.0156 | 714800.0 |
| 2000-12-29 16:00:00 | IWM | ETF | 48.0625 | 48.0625 | 47.875 | 47.875 | 68000.0 |
| 2000-12-29 09:30:00 | DIA | ETF | 109.1562 | 109.1562 | 108.5 | 108.5 | 277100.0 |
| 2000-12-29 10:00:00 | DIA | ETF | 108.75 | 108.9688 | 108.4375 | 108.75 | 86200.0 |
> showing 50 of 365 rows — these rows as CSV