PREVIEW / etf_30min / 2000-12-20
file: by_date/etf_30min/2000/2000-12-20.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-20 09:30:00 | SPY | ETF | 128.625 | 128.7188 | 127.125 | 128.0 | 2134400.0 |
| 2000-12-20 10:00:00 | SPY | ETF | 128.0312 | 128.75 | 127.6875 | 128.0312 | 1034800.0 |
| 2000-12-20 10:30:00 | SPY | ETF | 128.0312 | 128.5625 | 127.5625 | 128.5625 | 736500.0 |
| 2000-12-20 11:00:00 | SPY | ETF | 128.625 | 128.9375 | 127.8438 | 128.2188 | 510900.0 |
| 2000-12-20 11:30:00 | SPY | ETF | 128.3125 | 128.7188 | 127.875 | 128.625 | 393500.0 |
| 2000-12-20 12:00:00 | SPY | ETF | 128.6562 | 128.75 | 127.875 | 128.125 | 305300.0 |
| 2000-12-20 12:30:00 | SPY | ETF | 128.0625 | 128.3125 | 127.4375 | 127.75 | 568100.0 |
| 2000-12-20 13:00:00 | SPY | ETF | 127.625 | 127.8438 | 127.1875 | 127.5 | 231600.0 |
| 2000-12-20 13:30:00 | SPY | ETF | 127.4688 | 127.7188 | 127.0938 | 127.4688 | 363900.0 |
| 2000-12-20 14:00:00 | SPY | ETF | 127.4375 | 128.0 | 126.7188 | 127.0312 | 794100.0 |
| 2000-12-20 14:30:00 | SPY | ETF | 127.0938 | 127.375 | 126.6875 | 126.9375 | 462700.0 |
| 2000-12-20 15:00:00 | SPY | ETF | 126.875 | 126.9688 | 126.0938 | 126.9688 | 554500.0 |
| 2000-12-20 15:30:00 | SPY | ETF | 126.9688 | 127.7188 | 126.3125 | 126.6875 | 986200.0 |
| 2000-12-20 16:00:00 | SPY | ETF | 126.6875 | 126.9062 | 126.1562 | 126.25 | 510500.0 |
| 2000-12-20 16:30:00 | SPY | ETF | 126.75 | 126.75 | 126.375 | 126.625 | 23900.0 |
| 2000-12-20 17:00:00 | SPY | ETF | 126.4375 | 126.5 | 126.4375 | 126.5 | 100200.0 |
| 2000-12-20 18:00:00 | SPY | ETF | 126.75 | 126.75 | 126.75 | 126.75 | 100.0 |
| 2000-12-20 09:30:00 | QQQ | ETF | 57.3125 | 58.3125 | 56.1875 | 57.5 | 14072600.0 |
| 2000-12-20 10:00:00 | QQQ | ETF | 57.5 | 58.375 | 56.875 | 57.4688 | 6978200.0 |
| 2000-12-20 10:30:00 | QQQ | ETF | 57.25 | 57.875 | 56.5625 | 57.625 | 5467200.0 |
| 2000-12-20 11:00:00 | QQQ | ETF | 57.75 | 58.125 | 57.0 | 57.25 | 3490600.0 |
| 2000-12-20 11:30:00 | QQQ | ETF | 57.3125 | 57.5 | 56.6875 | 57.4375 | 3406200.0 |
| 2000-12-20 12:00:00 | QQQ | ETF | 57.4688 | 57.7188 | 56.5625 | 56.8438 | 2584400.0 |
| 2000-12-20 12:30:00 | QQQ | ETF | 56.75 | 57.0 | 56.25 | 56.375 | 3545900.0 |
| 2000-12-20 13:00:00 | QQQ | ETF | 56.4062 | 56.75 | 56.0312 | 56.5 | 3787900.0 |
| 2000-12-20 13:30:00 | QQQ | ETF | 56.4375 | 56.6875 | 55.75 | 56.0625 | 3834100.0 |
| 2000-12-20 14:00:00 | QQQ | ETF | 56.2188 | 56.9375 | 55.875 | 55.875 | 4133200.0 |
| 2000-12-20 14:30:00 | QQQ | ETF | 55.9688 | 56.3125 | 55.5 | 55.625 | 4062900.0 |
| 2000-12-20 15:00:00 | QQQ | ETF | 55.6562 | 55.875 | 54.75 | 55.75 | 7119600.0 |
| 2000-12-20 15:30:00 | QQQ | ETF | 55.75 | 56.5312 | 55.125 | 55.4375 | 8455900.0 |
| 2000-12-20 16:00:00 | QQQ | ETF | 55.4062 | 56.25 | 55.0 | 55.625 | 2397800.0 |
| 2000-12-20 16:30:00 | QQQ | ETF | 55.6875 | 56.375 | 55.5 | 55.8125 | 264800.0 |
| 2000-12-20 17:00:00 | QQQ | ETF | 55.875 | 56.0 | 55.7188 | 55.7188 | 122600.0 |
| 2000-12-20 17:30:00 | QQQ | ETF | 55.875 | 56.25 | 55.75 | 55.875 | 69200.0 |
| 2000-12-20 18:00:00 | QQQ | ETF | 55.8125 | 55.875 | 55.625 | 55.7188 | 41700.0 |
| 2000-12-20 09:30:00 | IWM | ETF | 44.7344 | 45.0 | 44.5625 | 44.875 | 48600.0 |
| 2000-12-20 10:00:00 | IWM | ETF | 44.9062 | 44.9062 | 44.8125 | 44.8125 | 3800.0 |
| 2000-12-20 10:30:00 | IWM | ETF | 44.6875 | 44.6875 | 44.5156 | 44.6562 | 14400.0 |
| 2000-12-20 11:00:00 | IWM | ETF | 44.6875 | 44.7188 | 44.3438 | 44.5312 | 2400.0 |
| 2000-12-20 11:30:00 | IWM | ETF | 44.5 | 44.5938 | 44.4062 | 44.4062 | 18400.0 |
| 2000-12-20 12:00:00 | IWM | ETF | 44.5312 | 44.5469 | 44.3438 | 44.3438 | 23600.0 |
| 2000-12-20 12:30:00 | IWM | ETF | 44.5625 | 44.5625 | 44.3125 | 44.375 | 34400.0 |
| 2000-12-20 13:00:00 | IWM | ETF | 44.4219 | 44.4219 | 44.2812 | 44.2812 | 7600.0 |
| 2000-12-20 13:30:00 | IWM | ETF | 44.4219 | 44.4219 | 44.2188 | 44.3125 | 8600.0 |
| 2000-12-20 14:00:00 | IWM | ETF | 44.3125 | 44.375 | 44.1875 | 44.1875 | 20400.0 |
| 2000-12-20 14:30:00 | IWM | ETF | 44.125 | 44.3125 | 44.125 | 44.125 | 30800.0 |
| 2000-12-20 15:00:00 | IWM | ETF | 44.0625 | 44.1719 | 43.9062 | 44.125 | 34400.0 |
| 2000-12-20 15:30:00 | IWM | ETF | 44.125 | 44.3438 | 44.125 | 44.2188 | 5600.0 |
| 2000-12-20 16:00:00 | IWM | ETF | 44.0625 | 44.0625 | 44.0625 | 44.0625 | 3600.0 |
| 2000-12-20 09:30:00 | DIA | ETF | 104.0938 | 104.5 | 103.5 | 104.2188 | 447300.0 |
> showing 50 of 326 rows — these rows as CSV