PREVIEW / etf_30min / 2000-02-23
file: by_date/etf_30min/2000/2000-02-23.parquet size: 10 KB rows: 223
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-02-23 09:30:00 | SPY | ETF | 135.625 | 135.625 | 134.6562 | 135.0625 | 918500.0 |
| 2000-02-23 10:00:00 | SPY | ETF | 135.2188 | 135.75 | 134.8125 | 135.125 | 453900.0 |
| 2000-02-23 10:30:00 | SPY | ETF | 135.125 | 135.4688 | 134.9375 | 135.0625 | 434400.0 |
| 2000-02-23 11:00:00 | SPY | ETF | 135.0312 | 135.375 | 134.5 | 134.625 | 375400.0 |
| 2000-02-23 11:30:00 | SPY | ETF | 134.7812 | 135.4375 | 134.625 | 135.3125 | 260900.0 |
| 2000-02-23 12:00:00 | SPY | ETF | 135.375 | 135.75 | 135.125 | 135.4375 | 711400.0 |
| 2000-02-23 12:30:00 | SPY | ETF | 135.5625 | 136.0312 | 135.4062 | 135.5938 | 546200.0 |
| 2000-02-23 13:00:00 | SPY | ETF | 135.5 | 135.875 | 135.4375 | 135.8125 | 775000.0 |
| 2000-02-23 13:30:00 | SPY | ETF | 135.8125 | 136.7812 | 135.5 | 136.625 | 1474100.0 |
| 2000-02-23 14:00:00 | SPY | ETF | 136.5938 | 137.125 | 136.5 | 136.5938 | 1923700.0 |
| 2000-02-23 14:30:00 | SPY | ETF | 136.5938 | 136.875 | 136.25 | 136.625 | 233100.0 |
| 2000-02-23 15:00:00 | SPY | ETF | 136.7188 | 137.4688 | 136.625 | 137.375 | 2317100.0 |
| 2000-02-23 15:30:00 | SPY | ETF | 137.1875 | 137.4062 | 136.375 | 136.5 | 1083300.0 |
| 2000-02-23 16:00:00 | SPY | ETF | 136.5 | 136.625 | 136.2188 | 136.5625 | 515200.0 |
| 2000-02-23 09:30:00 | QQQ | ETF | 99.6719 | 100.0312 | 99.1562 | 99.75 | 3585400.0 |
| 2000-02-23 10:00:00 | QQQ | ETF | 99.75 | 100.3594 | 99.4375 | 100.0 | 1760200.0 |
| 2000-02-23 10:30:00 | QQQ | ETF | 100.0 | 100.6094 | 99.75 | 100.25 | 1500400.0 |
| 2000-02-23 11:00:00 | QQQ | ETF | 100.2812 | 100.5312 | 99.75 | 99.875 | 1272800.0 |
| 2000-02-23 11:30:00 | QQQ | ETF | 99.9375 | 100.75 | 99.9062 | 100.6406 | 918400.0 |
| 2000-02-23 12:00:00 | QQQ | ETF | 100.7188 | 101.125 | 100.5625 | 101.0156 | 1509000.0 |
| 2000-02-23 12:30:00 | QQQ | ETF | 101.0469 | 101.375 | 101.0 | 101.3281 | 1800200.0 |
| 2000-02-23 13:00:00 | QQQ | ETF | 101.0781 | 101.75 | 101.0 | 101.7188 | 1400400.0 |
| 2000-02-23 13:30:00 | QQQ | ETF | 101.7188 | 102.6094 | 101.5938 | 102.6094 | 1783200.0 |
| 2000-02-23 14:00:00 | QQQ | ETF | 102.6094 | 103.1875 | 102.4375 | 102.5781 | 3824800.0 |
| 2000-02-23 14:30:00 | QQQ | ETF | 102.5781 | 103.25 | 102.4375 | 103.1875 | 2673400.0 |
| 2000-02-23 15:00:00 | QQQ | ETF | 103.2031 | 104.9844 | 103.0 | 104.9062 | 6290000.0 |
| 2000-02-23 15:30:00 | QQQ | ETF | 104.9062 | 104.9531 | 103.625 | 104.2188 | 2792800.0 |
| 2000-02-23 16:00:00 | QQQ | ETF | 104.2188 | 104.5 | 103.7031 | 104.1875 | 947200.0 |
| 2000-02-23 16:30:00 | QQQ | ETF | 104.375 | 104.375 | 104.0625 | 104.125 | 1600.0 |
| 2000-02-23 17:00:00 | QQQ | ETF | 104.1562 | 104.375 | 104.1562 | 104.375 | 2200.0 |
| 2000-02-23 17:30:00 | QQQ | ETF | 104.2188 | 104.25 | 104.2188 | 104.25 | 1000.0 |
| 2000-02-23 09:30:00 | DIA | ETF | 102.9688 | 103.0938 | 102.0625 | 102.375 | 246100.0 |
| 2000-02-23 10:00:00 | DIA | ETF | 102.4062 | 102.75 | 102.25 | 102.4375 | 45100.0 |
| 2000-02-23 10:30:00 | DIA | ETF | 102.375 | 102.7188 | 102.1562 | 102.3438 | 30300.0 |
| 2000-02-23 11:00:00 | DIA | ETF | 102.4688 | 102.4688 | 101.625 | 101.9688 | 158700.0 |
| 2000-02-23 11:30:00 | DIA | ETF | 102.0 | 102.4062 | 101.7812 | 102.4062 | 93100.0 |
| 2000-02-23 12:00:00 | DIA | ETF | 102.3125 | 102.7188 | 102.25 | 102.4688 | 51000.0 |
| 2000-02-23 12:30:00 | DIA | ETF | 102.4688 | 102.7812 | 102.3125 | 102.375 | 107600.0 |
| 2000-02-23 13:00:00 | DIA | ETF | 102.2812 | 102.5625 | 102.125 | 102.4062 | 24400.0 |
| 2000-02-23 13:30:00 | DIA | ETF | 102.375 | 103.1875 | 102.1875 | 103.1875 | 303800.0 |
| 2000-02-23 14:00:00 | DIA | ETF | 103.25 | 103.5 | 102.7188 | 102.9688 | 176900.0 |
| 2000-02-23 14:30:00 | DIA | ETF | 103.0 | 103.2812 | 102.6875 | 103.0312 | 49400.0 |
| 2000-02-23 15:00:00 | DIA | ETF | 103.0625 | 103.4688 | 102.9375 | 103.2188 | 118100.0 |
| 2000-02-23 15:30:00 | DIA | ETF | 103.2812 | 103.2812 | 102.25 | 102.375 | 151500.0 |
| 2000-02-23 16:00:00 | DIA | ETF | 102.2812 | 102.2812 | 102.2188 | 102.25 | 1900.0 |
> showing 45 of 223 rows — these rows as CSV