PREVIEW / etf_30min / 2000-04-17
file: by_date/etf_30min/2000/2000-04-17.parquet size: 10 KB rows: 228
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-04-17 09:30:00 | SPY | ETF | 135.1875 | 137.75 | 135.1875 | 137.0 | 2313100.0 |
| 2000-04-17 10:00:00 | SPY | ETF | 137.0 | 137.625 | 135.75 | 136.0 | 1693200.0 |
| 2000-04-17 10:30:00 | SPY | ETF | 136.1875 | 138.1875 | 135.9375 | 138.0 | 786300.0 |
| 2000-04-17 11:00:00 | SPY | ETF | 137.75 | 138.25 | 137.25 | 137.5312 | 938300.0 |
| 2000-04-17 11:30:00 | SPY | ETF | 137.2812 | 137.875 | 136.75 | 137.125 | 6199900.0 |
| 2000-04-17 12:00:00 | SPY | ETF | 136.875 | 136.875 | 135.75 | 135.875 | 1439700.0 |
| 2000-04-17 12:30:00 | SPY | ETF | 135.8125 | 136.1562 | 134.6875 | 136.0 | 1614000.0 |
| 2000-04-17 13:00:00 | SPY | ETF | 136.0625 | 137.1875 | 135.9375 | 136.5625 | 1496300.0 |
| 2000-04-17 13:30:00 | SPY | ETF | 136.625 | 136.8125 | 135.0938 | 135.0938 | 832000.0 |
| 2000-04-17 14:00:00 | SPY | ETF | 135.25 | 136.875 | 135.125 | 136.875 | 1320000.0 |
| 2000-04-17 14:30:00 | SPY | ETF | 136.9375 | 138.25 | 136.9375 | 138.2188 | 1603500.0 |
| 2000-04-17 15:00:00 | SPY | ETF | 138.1875 | 138.375 | 136.7188 | 138.0312 | 568500.0 |
| 2000-04-17 15:30:00 | SPY | ETF | 138.25 | 140.125 | 138.25 | 140.0625 | 2252000.0 |
| 2000-04-17 16:00:00 | SPY | ETF | 140.25 | 140.4375 | 140.0 | 140.25 | 602900.0 |
| 2000-04-17 17:00:00 | SPY | ETF | 140.75 | 140.75 | 140.75 | 140.75 | 300.0 |
| 2000-04-17 09:30:00 | QQQ | ETF | 78.0312 | 83.375 | 78.0 | 82.75 | 8461300.0 |
| 2000-04-17 10:00:00 | QQQ | ETF | 82.625 | 83.5 | 80.625 | 81.1875 | 5186100.0 |
| 2000-04-17 10:30:00 | QQQ | ETF | 81.1875 | 84.75 | 80.625 | 84.5 | 4175200.0 |
| 2000-04-17 11:00:00 | QQQ | ETF | 84.5 | 84.9688 | 83.5 | 83.75 | 3739800.0 |
| 2000-04-17 11:30:00 | QQQ | ETF | 83.625 | 84.25 | 82.3125 | 82.625 | 2380900.0 |
| 2000-04-17 12:00:00 | QQQ | ETF | 82.6562 | 83.0 | 81.5 | 81.625 | 2246000.0 |
| 2000-04-17 12:30:00 | QQQ | ETF | 81.625 | 82.0 | 79.625 | 81.75 | 5497700.0 |
| 2000-04-17 13:00:00 | QQQ | ETF | 81.75 | 82.375 | 80.8125 | 81.875 | 3058200.0 |
| 2000-04-17 13:30:00 | QQQ | ETF | 81.875 | 82.0 | 80.0 | 80.125 | 2213500.0 |
| 2000-04-17 14:00:00 | QQQ | ETF | 80.0 | 82.1875 | 79.5 | 82.0 | 2763300.0 |
| 2000-04-17 14:30:00 | QQQ | ETF | 82.0 | 84.0625 | 82.0 | 84.0 | 4267600.0 |
| 2000-04-17 15:00:00 | QQQ | ETF | 83.875 | 84.5625 | 82.0312 | 84.5 | 3945600.0 |
| 2000-04-17 15:30:00 | QQQ | ETF | 84.5625 | 88.0 | 84.125 | 87.625 | 5956800.0 |
| 2000-04-17 16:00:00 | QQQ | ETF | 87.625 | 89.5 | 87.5 | 89.0 | 829000.0 |
| 2000-04-17 16:30:00 | QQQ | ETF | 89.0 | 90.0 | 88.0 | 89.5 | 17100.0 |
| 2000-04-17 17:00:00 | QQQ | ETF | 89.5 | 89.5 | 89.0 | 89.125 | 9300.0 |
| 2000-04-17 17:30:00 | QQQ | ETF | 89.5 | 90.0 | 89.25 | 89.75 | 4600.0 |
| 2000-04-17 18:00:00 | QQQ | ETF | 90.0 | 90.0 | 89.625 | 89.625 | 4200.0 |
| 2000-04-17 09:30:00 | DIA | ETF | 102.875 | 104.7812 | 102.875 | 104.125 | 1259700.0 |
| 2000-04-17 10:00:00 | DIA | ETF | 104.0 | 104.125 | 103.0312 | 103.8125 | 600100.0 |
| 2000-04-17 10:30:00 | DIA | ETF | 103.5625 | 104.6875 | 103.5625 | 104.3125 | 725500.0 |
| 2000-04-17 11:00:00 | DIA | ETF | 104.0625 | 104.5 | 103.75 | 103.75 | 499400.0 |
| 2000-04-17 11:30:00 | DIA | ETF | 103.75 | 104.25 | 103.5312 | 103.75 | 88900.0 |
| 2000-04-17 12:00:00 | DIA | ETF | 103.5 | 103.8125 | 103.0 | 103.0 | 101800.0 |
| 2000-04-17 12:30:00 | DIA | ETF | 103.1875 | 103.5 | 102.25 | 103.5 | 285000.0 |
| 2000-04-17 13:00:00 | DIA | ETF | 103.5 | 104.3125 | 103.3438 | 103.9688 | 463600.0 |
| 2000-04-17 13:30:00 | DIA | ETF | 104.0 | 104.0 | 103.0 | 103.0 | 173000.0 |
| 2000-04-17 14:00:00 | DIA | ETF | 102.9688 | 104.1875 | 102.7188 | 104.0625 | 281600.0 |
| 2000-04-17 14:30:00 | DIA | ETF | 104.1562 | 105.0 | 104.1562 | 104.9375 | 514600.0 |
| 2000-04-17 15:00:00 | DIA | ETF | 104.9688 | 104.9688 | 103.75 | 104.9375 | 365700.0 |
| 2000-04-17 15:30:00 | DIA | ETF | 104.9375 | 105.9688 | 104.9375 | 105.9688 | 457300.0 |
| 2000-04-17 16:00:00 | DIA | ETF | 105.75 | 106.0312 | 105.5625 | 106.0312 | 136000.0 |
| 2000-04-17 16:30:00 | DIA | ETF | 106.0 | 106.0 | 106.0 | 106.0 | 200.0 |
> showing 48 of 228 rows — these rows as CSV