PREVIEW / etf_30min / 2000-02-22
file: by_date/etf_30min/2000/2000-02-22.parquet size: 10 KB rows: 216
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-22 09:30:00 | SPY | ETF | 135.1875 | 135.9688 | 135.0625 | 135.125 | 1563500.0 |
| 2000-02-22 10:00:00 | SPY | ETF | 135.0938 | 135.3125 | 133.75 | 134.1562 | 1489800.0 |
| 2000-02-22 10:30:00 | SPY | ETF | 134.1562 | 134.5938 | 133.7188 | 133.9375 | 1286900.0 |
| 2000-02-22 11:00:00 | SPY | ETF | 133.9688 | 134.2188 | 133.5312 | 134.0 | 1625600.0 |
| 2000-02-22 11:30:00 | SPY | ETF | 134.0938 | 134.75 | 133.75 | 134.5625 | 1223200.0 |
| 2000-02-22 12:00:00 | SPY | ETF | 134.625 | 134.6875 | 133.875 | 134.0625 | 665500.0 |
| 2000-02-22 12:30:00 | SPY | ETF | 134.0 | 134.2188 | 133.8125 | 134.0312 | 139500.0 |
| 2000-02-22 13:00:00 | SPY | ETF | 134.0938 | 134.5 | 133.8125 | 134.4688 | 296900.0 |
| 2000-02-22 13:30:00 | SPY | ETF | 134.5 | 134.6875 | 133.9688 | 134.4062 | 873100.0 |
| 2000-02-22 14:00:00 | SPY | ETF | 134.3125 | 134.3125 | 133.6562 | 133.75 | 393200.0 |
| 2000-02-22 14:30:00 | SPY | ETF | 133.7812 | 134.6562 | 133.5312 | 134.6562 | 786800.0 |
| 2000-02-22 15:00:00 | SPY | ETF | 134.5 | 136.3438 | 134.5 | 136.125 | 3480900.0 |
| 2000-02-22 15:30:00 | SPY | ETF | 136.125 | 136.3125 | 135.1875 | 135.4062 | 1321100.0 |
| 2000-02-22 16:00:00 | SPY | ETF | 135.5312 | 135.5938 | 134.7188 | 134.9688 | 426900.0 |
| 2000-02-22 09:30:00 | QQQ | ETF | 99.0 | 99.9375 | 98.7812 | 99.2188 | 2968200.0 |
| 2000-02-22 10:00:00 | QQQ | ETF | 99.0625 | 99.1719 | 96.875 | 97.625 | 5907000.0 |
| 2000-02-22 10:30:00 | QQQ | ETF | 97.75 | 97.9688 | 97.0156 | 97.25 | 2902800.0 |
| 2000-02-22 11:00:00 | QQQ | ETF | 97.0625 | 97.4688 | 96.25 | 97.0 | 2951600.0 |
| 2000-02-22 11:30:00 | QQQ | ETF | 97.125 | 98.1875 | 96.75 | 98.125 | 3515600.0 |
| 2000-02-22 12:00:00 | QQQ | ETF | 98.125 | 98.2188 | 97.25 | 97.375 | 1399400.0 |
| 2000-02-22 12:30:00 | QQQ | ETF | 97.3125 | 97.6094 | 97.0938 | 97.1875 | 1019200.0 |
| 2000-02-22 13:00:00 | QQQ | ETF | 97.1875 | 97.8594 | 97.0 | 97.7656 | 534200.0 |
| 2000-02-22 13:30:00 | QQQ | ETF | 97.8125 | 98.1875 | 97.3594 | 97.625 | 2051200.0 |
| 2000-02-22 14:00:00 | QQQ | ETF | 97.6875 | 97.6875 | 96.875 | 97.0 | 1293400.0 |
| 2000-02-22 14:30:00 | QQQ | ETF | 96.875 | 98.0 | 96.75 | 98.0 | 2520800.0 |
| 2000-02-22 15:00:00 | QQQ | ETF | 98.0 | 99.5 | 97.9375 | 99.5 | 5283000.0 |
| 2000-02-22 15:30:00 | QQQ | ETF | 99.5312 | 99.7031 | 98.4375 | 98.8438 | 3751000.0 |
| 2000-02-22 16:00:00 | QQQ | ETF | 98.875 | 98.9375 | 98.4375 | 98.6875 | 259000.0 |
| 2000-02-22 16:30:00 | QQQ | ETF | 98.5 | 98.5 | 98.5 | 98.5 | 400.0 |
| 2000-02-22 17:00:00 | QQQ | ETF | 98.625 | 98.6562 | 98.625 | 98.6562 | 400.0 |
| 2000-02-22 17:30:00 | QQQ | ETF | 98.75 | 98.75 | 98.75 | 98.75 | 400.0 |
| 2000-02-22 09:30:00 | DIA | ETF | 102.875 | 103.0312 | 102.0625 | 102.2812 | 238800.0 |
| 2000-02-22 10:00:00 | DIA | ETF | 102.0938 | 102.3125 | 101.0 | 101.3438 | 185300.0 |
| 2000-02-22 10:30:00 | DIA | ETF | 101.4688 | 101.75 | 101.125 | 101.4688 | 43500.0 |
| 2000-02-22 11:00:00 | DIA | ETF | 101.4688 | 101.8438 | 101.1875 | 101.7812 | 52600.0 |
| 2000-02-22 11:30:00 | DIA | ETF | 101.6875 | 102.3125 | 101.4688 | 102.3125 | 116900.0 |
| 2000-02-22 12:00:00 | DIA | ETF | 102.125 | 102.2812 | 101.5938 | 101.5938 | 109300.0 |
| 2000-02-22 12:30:00 | DIA | ETF | 101.7812 | 102.0625 | 101.5625 | 101.8438 | 32800.0 |
| 2000-02-22 13:00:00 | DIA | ETF | 101.875 | 102.3125 | 101.6875 | 102.3125 | 23700.0 |
| 2000-02-22 13:30:00 | DIA | ETF | 102.125 | 102.4375 | 101.7188 | 102.0 | 109100.0 |
| 2000-02-22 14:00:00 | DIA | ETF | 101.875 | 102.0 | 101.4375 | 101.4375 | 70200.0 |
| 2000-02-22 14:30:00 | DIA | ETF | 101.5 | 102.1562 | 101.375 | 102.1562 | 86100.0 |
| 2000-02-22 15:00:00 | DIA | ETF | 102.1562 | 103.3438 | 102.0938 | 103.25 | 221100.0 |
| 2000-02-22 15:30:00 | DIA | ETF | 103.375 | 103.4688 | 102.75 | 103.0312 | 169200.0 |
| 2000-02-22 16:00:00 | DIA | ETF | 103.0312 | 103.0312 | 102.625 | 102.8125 | 58100.0 |
> showing 45 of 216 rows — these rows as CSV