PREVIEW / etf_30min / 2000-05-22
file: by_date/etf_30min/2000/2000-05-22.parquet size: 10 KB rows: 222
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-05-22 09:30:00 | SPY | ETF | 141.25 | 141.4688 | 140.0 | 140.125 | 1638300.0 |
| 2000-05-22 10:00:00 | SPY | ETF | 140.125 | 140.2812 | 138.5312 | 138.8125 | 860100.0 |
| 2000-05-22 10:30:00 | SPY | ETF | 138.625 | 138.8438 | 137.375 | 138.0312 | 1554000.0 |
| 2000-05-22 11:00:00 | SPY | ETF | 138.1875 | 139.0 | 137.1875 | 138.75 | 832500.0 |
| 2000-05-22 11:30:00 | SPY | ETF | 138.3125 | 138.625 | 137.5625 | 137.6562 | 265600.0 |
| 2000-05-22 12:00:00 | SPY | ETF | 137.75 | 138.375 | 137.5 | 137.8438 | 226700.0 |
| 2000-05-22 12:30:00 | SPY | ETF | 137.75 | 138.5938 | 137.6875 | 138.1875 | 181900.0 |
| 2000-05-22 13:00:00 | SPY | ETF | 138.4062 | 138.5 | 137.75 | 138.125 | 384600.0 |
| 2000-05-22 13:30:00 | SPY | ETF | 138.0 | 138.125 | 137.25 | 137.5625 | 815000.0 |
| 2000-05-22 14:00:00 | SPY | ETF | 137.625 | 138.4688 | 137.0 | 138.3125 | 240400.0 |
| 2000-05-22 14:30:00 | SPY | ETF | 138.25 | 139.125 | 138.0312 | 138.625 | 627100.0 |
| 2000-05-22 15:00:00 | SPY | ETF | 138.625 | 140.75 | 138.5 | 140.5 | 1020200.0 |
| 2000-05-22 15:30:00 | SPY | ETF | 140.5938 | 140.7188 | 139.5 | 140.4062 | 1219500.0 |
| 2000-05-22 16:00:00 | SPY | ETF | 140.25 | 140.4062 | 140.0 | 140.0625 | 632100.0 |
| 2000-05-22 16:30:00 | SPY | ETF | 140.0625 | 140.0625 | 140.0625 | 140.0625 | 100.0 |
| 2000-05-22 09:30:00 | QQQ | ETF | 81.625 | 81.625 | 78.875 | 78.875 | 5317200.0 |
| 2000-05-22 10:00:00 | QQQ | ETF | 78.9375 | 79.25 | 76.375 | 76.375 | 4983700.0 |
| 2000-05-22 10:30:00 | QQQ | ETF | 76.5 | 78.0 | 75.5625 | 77.3125 | 5642500.0 |
| 2000-05-22 11:00:00 | QQQ | ETF | 77.375 | 78.625 | 76.0625 | 78.25 | 4129200.0 |
| 2000-05-22 11:30:00 | QQQ | ETF | 78.0938 | 78.3125 | 77.0 | 77.0625 | 1286900.0 |
| 2000-05-22 12:00:00 | QQQ | ETF | 77.0625 | 77.75 | 76.5 | 76.875 | 1394600.0 |
| 2000-05-22 12:30:00 | QQQ | ETF | 76.875 | 78.0625 | 76.8125 | 77.75 | 1681000.0 |
| 2000-05-22 13:00:00 | QQQ | ETF | 77.625 | 77.9062 | 76.9375 | 77.1875 | 937100.0 |
| 2000-05-22 13:30:00 | QQQ | ETF | 77.1875 | 77.4688 | 76.1875 | 76.5 | 1770300.0 |
| 2000-05-22 14:00:00 | QQQ | ETF | 76.5 | 77.5625 | 76.0 | 77.4375 | 2123400.0 |
| 2000-05-22 14:30:00 | QQQ | ETF | 77.5 | 79.0 | 77.1875 | 78.125 | 3235200.0 |
| 2000-05-22 15:00:00 | QQQ | ETF | 78.125 | 81.5 | 77.875 | 81.125 | 5688600.0 |
| 2000-05-22 15:30:00 | QQQ | ETF | 81.1875 | 81.875 | 79.5 | 81.625 | 4580400.0 |
| 2000-05-22 16:00:00 | QQQ | ETF | 81.5 | 82.125 | 81.5 | 82.125 | 589700.0 |
| 2000-05-22 16:30:00 | QQQ | ETF | 82.0 | 82.25 | 82.0 | 82.25 | 20800.0 |
| 2000-05-22 17:00:00 | QQQ | ETF | 82.0 | 82.0 | 81.75 | 81.75 | 1700.0 |
| 2000-05-22 17:30:00 | QQQ | ETF | 81.75 | 81.75 | 81.625 | 81.625 | 2300.0 |
| 2000-05-22 18:00:00 | QQQ | ETF | 81.875 | 82.0 | 81.625 | 81.625 | 1300.0 |
| 2000-05-22 09:30:00 | DIA | ETF | 106.125 | 106.3438 | 105.3438 | 105.5312 | 143400.0 |
| 2000-05-22 10:00:00 | DIA | ETF | 105.5 | 105.9375 | 104.8438 | 104.8438 | 153500.0 |
| 2000-05-22 10:30:00 | DIA | ETF | 104.875 | 105.0 | 104.0625 | 104.3438 | 67200.0 |
| 2000-05-22 11:00:00 | DIA | ETF | 104.5625 | 104.7188 | 103.8438 | 104.6562 | 80300.0 |
| 2000-05-22 11:30:00 | DIA | ETF | 104.5625 | 104.5938 | 103.875 | 104.0312 | 60500.0 |
| 2000-05-22 12:00:00 | DIA | ETF | 104.0312 | 104.375 | 103.875 | 103.875 | 99500.0 |
| 2000-05-22 12:30:00 | DIA | ETF | 104.0312 | 104.5625 | 104.0312 | 104.4062 | 52300.0 |
| 2000-05-22 13:00:00 | DIA | ETF | 104.4375 | 104.5 | 104.125 | 104.3125 | 78300.0 |
| 2000-05-22 13:30:00 | DIA | ETF | 104.3125 | 104.3125 | 103.7812 | 103.7812 | 105100.0 |
| 2000-05-22 14:00:00 | DIA | ETF | 103.875 | 104.5625 | 103.625 | 104.5625 | 72300.0 |
| 2000-05-22 14:30:00 | DIA | ETF | 104.5625 | 104.8125 | 104.2188 | 104.5625 | 40500.0 |
| 2000-05-22 15:00:00 | DIA | ETF | 104.4375 | 105.5 | 104.3438 | 105.5 | 78400.0 |
| 2000-05-22 15:30:00 | DIA | ETF | 105.375 | 105.5938 | 104.9062 | 105.4375 | 176900.0 |
| 2000-05-22 16:00:00 | DIA | ETF | 105.5 | 105.5312 | 105.2812 | 105.5312 | 24900.0 |
> showing 47 of 222 rows — these rows as CSV