PREVIEW / etf_30min / 2000-10-17
file: by_date/etf_30min/2000/2000-10-17.parquet size: 12 KB rows: 286
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-17 09:30:00 | SPY | ETF | 138.4375 | 138.5625 | 137.625 | 137.625 | 913400.0 |
| 2000-10-17 10:00:00 | SPY | ETF | 137.6875 | 137.6875 | 136.75 | 136.9688 | 629800.0 |
| 2000-10-17 10:30:00 | SPY | ETF | 137.0938 | 137.25 | 136.5 | 136.625 | 461300.0 |
| 2000-10-17 11:00:00 | SPY | ETF | 136.7188 | 136.8438 | 136.0312 | 136.125 | 603400.0 |
| 2000-10-17 11:30:00 | SPY | ETF | 136.25 | 136.4688 | 135.7812 | 135.9375 | 236200.0 |
| 2000-10-17 12:00:00 | SPY | ETF | 135.9375 | 136.0 | 135.625 | 135.6875 | 130400.0 |
| 2000-10-17 12:30:00 | SPY | ETF | 135.7812 | 136.125 | 135.75 | 135.75 | 166400.0 |
| 2000-10-17 13:00:00 | SPY | ETF | 135.7812 | 136.1875 | 135.4062 | 135.4062 | 451300.0 |
| 2000-10-17 13:30:00 | SPY | ETF | 135.625 | 135.7188 | 134.9375 | 134.9375 | 387800.0 |
| 2000-10-17 14:00:00 | SPY | ETF | 134.9375 | 135.0 | 134.4062 | 135.0 | 440900.0 |
| 2000-10-17 14:30:00 | SPY | ETF | 135.0 | 135.2812 | 134.4062 | 134.625 | 537700.0 |
| 2000-10-17 15:00:00 | SPY | ETF | 134.5625 | 135.125 | 134.4375 | 134.9062 | 810700.0 |
| 2000-10-17 15:30:00 | SPY | ETF | 135.0 | 135.5625 | 134.9375 | 135.4688 | 1324800.0 |
| 2000-10-17 16:00:00 | SPY | ETF | 135.375 | 135.4375 | 134.5938 | 134.5938 | 527800.0 |
| 2000-10-17 16:30:00 | SPY | ETF | 134.5 | 134.5 | 134.5 | 134.5 | 500.0 |
| 2000-10-17 17:00:00 | SPY | ETF | 134.4375 | 135.0 | 134.3125 | 134.375 | 8000.0 |
| 2000-10-17 17:30:00 | SPY | ETF | 134.75 | 134.75 | 134.75 | 134.75 | 500.0 |
| 2000-10-17 09:30:00 | QQQ | ETF | 83.125 | 83.1562 | 81.5625 | 81.875 | 13410600.0 |
| 2000-10-17 10:00:00 | QQQ | ETF | 81.8438 | 81.9375 | 80.4375 | 80.9375 | 4575600.0 |
| 2000-10-17 10:30:00 | QQQ | ETF | 80.9375 | 81.0625 | 79.9688 | 80.4688 | 3914600.0 |
| 2000-10-17 11:00:00 | QQQ | ETF | 80.4688 | 80.7188 | 79.1562 | 79.5938 | 3344400.0 |
| 2000-10-17 11:30:00 | QQQ | ETF | 79.5 | 80.0625 | 79.0312 | 79.25 | 2816900.0 |
| 2000-10-17 12:00:00 | QQQ | ETF | 79.0312 | 79.5 | 78.75 | 79.0 | 2050700.0 |
| 2000-10-17 12:30:00 | QQQ | ETF | 79.0625 | 79.6875 | 78.9688 | 79.2812 | 2038700.0 |
| 2000-10-17 13:00:00 | QQQ | ETF | 79.25 | 80.0 | 79.0625 | 79.125 | 1773900.0 |
| 2000-10-17 13:30:00 | QQQ | ETF | 79.0625 | 79.375 | 78.375 | 78.4688 | 2078800.0 |
| 2000-10-17 14:00:00 | QQQ | ETF | 78.4688 | 78.625 | 78.0625 | 78.625 | 2463600.0 |
| 2000-10-17 14:30:00 | QQQ | ETF | 78.625 | 78.875 | 78.0 | 78.5 | 2802300.0 |
| 2000-10-17 15:00:00 | QQQ | ETF | 78.5625 | 79.1875 | 78.25 | 78.875 | 2382400.0 |
| 2000-10-17 15:30:00 | QQQ | ETF | 78.9375 | 79.5 | 78.6875 | 79.3125 | 4549700.0 |
| 2000-10-17 16:00:00 | QQQ | ETF | 79.3125 | 79.5938 | 78.1562 | 79.25 | 1790300.0 |
| 2000-10-17 16:30:00 | QQQ | ETF | 79.25 | 79.4375 | 78.5 | 79.0 | 241300.0 |
| 2000-10-17 17:00:00 | QQQ | ETF | 79.0 | 79.0 | 78.625 | 78.9375 | 40500.0 |
| 2000-10-17 17:30:00 | QQQ | ETF | 78.75 | 79.0 | 78.25 | 78.4375 | 65300.0 |
| 2000-10-17 18:00:00 | QQQ | ETF | 78.375 | 79.25 | 77.8125 | 79.25 | 45900.0 |
| 2000-10-17 09:30:00 | IWM | ETF | 48.125 | 48.25 | 48.0625 | 48.0625 | 9400.0 |
| 2000-10-17 10:00:00 | IWM | ETF | 48.0625 | 48.0625 | 47.6875 | 47.8125 | 12200.0 |
| 2000-10-17 10:30:00 | IWM | ETF | 47.875 | 47.875 | 47.7812 | 47.7812 | 2000.0 |
| 2000-10-17 11:00:00 | IWM | ETF | 47.4688 | 47.5938 | 47.3125 | 47.4375 | 5000.0 |
| 2000-10-17 11:30:00 | IWM | ETF | 47.3125 | 47.4375 | 47.1562 | 47.1562 | 17400.0 |
| 2000-10-17 12:00:00 | IWM | ETF | 47.0938 | 47.0938 | 47.0 | 47.0625 | 77800.0 |
| 2000-10-17 12:30:00 | IWM | ETF | 47.0625 | 47.0625 | 47.0625 | 47.0625 | 200.0 |
| 2000-10-17 13:00:00 | IWM | ETF | 47.1562 | 47.1562 | 47.1094 | 47.1094 | 18200.0 |
| 2000-10-17 13:30:00 | IWM | ETF | 47.0625 | 47.125 | 46.8125 | 46.8125 | 11200.0 |
| 2000-10-17 14:00:00 | IWM | ETF | 46.75 | 46.8125 | 46.5781 | 46.5781 | 16600.0 |
| 2000-10-17 14:30:00 | IWM | ETF | 46.9219 | 46.9219 | 46.5625 | 46.9062 | 40800.0 |
| 2000-10-17 15:00:00 | IWM | ETF | 46.75 | 46.875 | 46.75 | 46.875 | 400.0 |
| 2000-10-17 15:30:00 | IWM | ETF | 47.0938 | 47.25 | 46.9688 | 46.9688 | 51200.0 |
| 2000-10-17 16:00:00 | IWM | ETF | 47.0312 | 47.0312 | 46.9062 | 46.9062 | 400.0 |
| 2000-10-17 09:30:00 | DIA | ETF | 102.9688 | 103.1562 | 102.625 | 102.6875 | 57800.0 |
> showing 50 of 286 rows — these rows as CSV