PREVIEW / etf_30min / 2000-05-24
file: by_date/etf_30min/2000/2000-05-24.parquet size: 10 KB rows: 220
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-24 09:30:00 | SPY | ETF | 138.0 | 138.9375 | 137.6875 | 137.6875 | 1488300.0 |
| 2000-05-24 10:00:00 | SPY | ETF | 137.6875 | 139.7188 | 137.4062 | 139.6875 | 1516400.0 |
| 2000-05-24 10:30:00 | SPY | ETF | 139.75 | 139.75 | 138.5312 | 138.5312 | 522900.0 |
| 2000-05-24 11:00:00 | SPY | ETF | 138.6562 | 138.875 | 137.9375 | 138.1875 | 407700.0 |
| 2000-05-24 11:30:00 | SPY | ETF | 138.1875 | 138.5 | 137.625 | 137.7188 | 492800.0 |
| 2000-05-24 12:00:00 | SPY | ETF | 137.8125 | 138.375 | 137.25 | 137.5 | 367900.0 |
| 2000-05-24 12:30:00 | SPY | ETF | 137.5312 | 137.7188 | 136.5 | 136.7188 | 778400.0 |
| 2000-05-24 13:00:00 | SPY | ETF | 136.625 | 137.5938 | 136.625 | 137.25 | 341700.0 |
| 2000-05-24 13:30:00 | SPY | ETF | 137.2188 | 138.5625 | 136.9688 | 138.25 | 437400.0 |
| 2000-05-24 14:00:00 | SPY | ETF | 138.0625 | 139.3438 | 137.6562 | 139.0938 | 1686500.0 |
| 2000-05-24 14:30:00 | SPY | ETF | 139.1875 | 140.0312 | 139.0312 | 139.875 | 329100.0 |
| 2000-05-24 15:00:00 | SPY | ETF | 139.75 | 140.4375 | 139.1562 | 139.8438 | 758600.0 |
| 2000-05-24 15:30:00 | SPY | ETF | 139.9375 | 140.6875 | 139.75 | 140.4062 | 1392400.0 |
| 2000-05-24 16:00:00 | SPY | ETF | 140.4062 | 140.4375 | 140.0312 | 140.0312 | 393700.0 |
| 2000-05-24 16:30:00 | SPY | ETF | 140.25 | 140.25 | 140.25 | 140.25 | 100.0 |
| 2000-05-24 09:30:00 | QQQ | ETF | 75.0 | 76.25 | 74.0312 | 74.5 | 6771600.0 |
| 2000-05-24 10:00:00 | QQQ | ETF | 74.0312 | 77.375 | 73.5 | 77.0 | 6783600.0 |
| 2000-05-24 10:30:00 | QQQ | ETF | 77.0625 | 77.625 | 75.375 | 75.5 | 3207200.0 |
| 2000-05-24 11:00:00 | QQQ | ETF | 75.5 | 76.5 | 75.0312 | 75.375 | 1729300.0 |
| 2000-05-24 11:30:00 | QQQ | ETF | 75.25 | 75.875 | 74.25 | 74.75 | 1651000.0 |
| 2000-05-24 12:00:00 | QQQ | ETF | 74.75 | 74.9688 | 74.0 | 74.125 | 1496100.0 |
| 2000-05-24 12:30:00 | QQQ | ETF | 74.0 | 74.5 | 72.25 | 72.75 | 2415100.0 |
| 2000-05-24 13:00:00 | QQQ | ETF | 72.5312 | 74.25 | 72.5 | 73.625 | 3035500.0 |
| 2000-05-24 13:30:00 | QQQ | ETF | 73.25 | 75.625 | 73.0 | 74.6875 | 3966500.0 |
| 2000-05-24 14:00:00 | QQQ | ETF | 74.6875 | 77.375 | 74.125 | 77.375 | 3818800.0 |
| 2000-05-24 14:30:00 | QQQ | ETF | 77.375 | 78.3438 | 76.375 | 78.0 | 4299500.0 |
| 2000-05-24 15:00:00 | QQQ | ETF | 77.9375 | 78.9375 | 76.6875 | 78.3125 | 3702300.0 |
| 2000-05-24 15:30:00 | QQQ | ETF | 78.3125 | 79.875 | 78.0 | 79.4375 | 5412700.0 |
| 2000-05-24 16:00:00 | QQQ | ETF | 79.4375 | 79.75 | 78.75 | 79.0 | 840000.0 |
| 2000-05-24 16:30:00 | QQQ | ETF | 78.875 | 79.0 | 78.5 | 78.875 | 2000.0 |
| 2000-05-24 17:00:00 | QQQ | ETF | 79.0 | 79.75 | 79.0 | 79.5 | 1600.0 |
| 2000-05-24 17:30:00 | QQQ | ETF | 79.5 | 79.75 | 79.5 | 79.5 | 2900.0 |
| 2000-05-24 18:00:00 | QQQ | ETF | 79.75 | 79.75 | 79.5 | 79.5 | 2900.0 |
| 2000-05-24 09:30:00 | DIA | ETF | 104.7188 | 104.9688 | 104.375 | 104.375 | 74200.0 |
| 2000-05-24 10:00:00 | DIA | ETF | 104.2812 | 105.5312 | 104.2812 | 105.5 | 102700.0 |
| 2000-05-24 10:30:00 | DIA | ETF | 105.375 | 105.4688 | 104.8438 | 104.8438 | 22500.0 |
| 2000-05-24 11:00:00 | DIA | ETF | 104.7812 | 105.0625 | 104.4688 | 104.7812 | 83000.0 |
| 2000-05-24 11:30:00 | DIA | ETF | 104.5312 | 104.875 | 104.25 | 104.625 | 38400.0 |
| 2000-05-24 12:00:00 | DIA | ETF | 104.5 | 104.6562 | 104.1875 | 104.1875 | 51000.0 |
| 2000-05-24 12:30:00 | DIA | ETF | 104.25 | 104.4062 | 103.4688 | 103.5625 | 154500.0 |
| 2000-05-24 13:00:00 | DIA | ETF | 103.5938 | 104.3125 | 103.5938 | 103.9062 | 57500.0 |
| 2000-05-24 13:30:00 | DIA | ETF | 104.0625 | 104.9375 | 104.0 | 104.7812 | 288300.0 |
| 2000-05-24 14:00:00 | DIA | ETF | 104.5625 | 105.1875 | 104.5312 | 105.0938 | 52800.0 |
| 2000-05-24 14:30:00 | DIA | ETF | 105.125 | 105.375 | 104.7812 | 105.25 | 160900.0 |
| 2000-05-24 15:00:00 | DIA | ETF | 105.375 | 105.625 | 104.9688 | 105.375 | 125200.0 |
| 2000-05-24 15:30:00 | DIA | ETF | 105.375 | 105.6875 | 105.25 | 105.5 | 39000.0 |
| 2000-05-24 16:00:00 | DIA | ETF | 105.5 | 105.5 | 105.2812 | 105.4375 | 4200.0 |
> showing 47 of 220 rows — these rows as CSV