PREVIEW / etf_30min / 2000-02-17
file: by_date/etf_30min/2000/2000-02-17.parquet size: 10 KB rows: 214
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-17 09:30:00 | SPY | ETF | 140.4375 | 140.4375 | 139.8438 | 139.9375 | 437000.0 |
| 2000-02-17 10:00:00 | SPY | ETF | 139.875 | 139.9375 | 138.3438 | 139.4375 | 1112000.0 |
| 2000-02-17 10:30:00 | SPY | ETF | 139.3438 | 139.4688 | 138.7188 | 138.9375 | 564100.0 |
| 2000-02-17 11:00:00 | SPY | ETF | 139.0 | 139.3438 | 138.625 | 139.0 | 566600.0 |
| 2000-02-17 11:30:00 | SPY | ETF | 139.0 | 139.0625 | 138.2188 | 138.375 | 721200.0 |
| 2000-02-17 12:00:00 | SPY | ETF | 138.3125 | 138.9688 | 138.3125 | 138.9688 | 245800.0 |
| 2000-02-17 12:30:00 | SPY | ETF | 139.0 | 139.125 | 138.625 | 139.0312 | 229000.0 |
| 2000-02-17 13:00:00 | SPY | ETF | 139.1562 | 139.625 | 139.1562 | 139.5625 | 533500.0 |
| 2000-02-17 13:30:00 | SPY | ETF | 139.6562 | 140.125 | 139.4062 | 139.5312 | 429900.0 |
| 2000-02-17 14:00:00 | SPY | ETF | 139.625 | 139.6562 | 139.0 | 139.25 | 770800.0 |
| 2000-02-17 14:30:00 | SPY | ETF | 139.25 | 139.625 | 138.8125 | 139.0 | 283600.0 |
| 2000-02-17 15:00:00 | SPY | ETF | 138.9375 | 139.125 | 138.2812 | 138.625 | 620700.0 |
| 2000-02-17 15:30:00 | SPY | ETF | 138.5 | 139.3125 | 138.4375 | 139.0625 | 492700.0 |
| 2000-02-17 16:00:00 | SPY | ETF | 139.0312 | 139.0625 | 138.2812 | 138.2812 | 558200.0 |
| 2000-02-17 09:30:00 | QQQ | ETF | 101.1875 | 101.5 | 100.875 | 101.1875 | 2690600.0 |
| 2000-02-17 10:00:00 | QQQ | ETF | 101.125 | 101.3594 | 99.625 | 101.0 | 5248400.0 |
| 2000-02-17 10:30:00 | QQQ | ETF | 101.125 | 101.2188 | 100.4062 | 101.125 | 2449200.0 |
| 2000-02-17 11:00:00 | QQQ | ETF | 101.1406 | 101.4375 | 100.75 | 101.125 | 1297400.0 |
| 2000-02-17 11:30:00 | QQQ | ETF | 101.0938 | 101.25 | 100.1875 | 100.4375 | 2150400.0 |
| 2000-02-17 12:00:00 | QQQ | ETF | 100.4062 | 101.25 | 100.3125 | 101.1875 | 889200.0 |
| 2000-02-17 12:30:00 | QQQ | ETF | 101.1875 | 101.5 | 101.0 | 101.4375 | 930800.0 |
| 2000-02-17 13:00:00 | QQQ | ETF | 101.5 | 102.6562 | 101.4844 | 102.625 | 3493000.0 |
| 2000-02-17 13:30:00 | QQQ | ETF | 102.5625 | 103.25 | 102.25 | 102.3438 | 2453000.0 |
| 2000-02-17 14:00:00 | QQQ | ETF | 102.4375 | 102.75 | 102.0625 | 102.375 | 1364000.0 |
| 2000-02-17 14:30:00 | QQQ | ETF | 102.3438 | 102.8594 | 102.0625 | 102.3125 | 1754800.0 |
| 2000-02-17 15:00:00 | QQQ | ETF | 102.4375 | 102.4844 | 101.75 | 102.125 | 1686200.0 |
| 2000-02-17 15:30:00 | QQQ | ETF | 102.125 | 103.25 | 102.0 | 103.125 | 2457000.0 |
| 2000-02-17 16:00:00 | QQQ | ETF | 103.25 | 103.25 | 102.0 | 102.0 | 900000.0 |
| 2000-02-17 16:30:00 | QQQ | ETF | 102.125 | 102.125 | 102.0 | 102.125 | 25400.0 |
| 2000-02-17 17:00:00 | QQQ | ETF | 102.0625 | 102.1875 | 101.875 | 101.875 | 8400.0 |
| 2000-02-17 17:30:00 | QQQ | ETF | 102.125 | 102.125 | 102.0625 | 102.0625 | 600.0 |
| 2000-02-17 18:00:00 | QQQ | ETF | 102.0625 | 102.125 | 102.0625 | 102.125 | 800.0 |
| 2000-02-17 09:30:00 | DIA | ETF | 106.7812 | 106.8438 | 106.3125 | 106.4688 | 134600.0 |
| 2000-02-17 10:00:00 | DIA | ETF | 106.3125 | 106.3125 | 105.1562 | 106.0625 | 346700.0 |
| 2000-02-17 10:30:00 | DIA | ETF | 106.0312 | 106.125 | 105.3125 | 105.4688 | 157600.0 |
| 2000-02-17 11:00:00 | DIA | ETF | 105.4688 | 105.5938 | 105.0938 | 105.2812 | 38700.0 |
| 2000-02-17 11:30:00 | DIA | ETF | 105.3125 | 105.375 | 104.6562 | 104.6562 | 64400.0 |
| 2000-02-17 12:00:00 | DIA | ETF | 104.8438 | 105.25 | 104.6875 | 105.25 | 17600.0 |
| 2000-02-17 12:30:00 | DIA | ETF | 105.2188 | 105.5 | 105.0312 | 105.5 | 30100.0 |
| 2000-02-17 13:00:00 | DIA | ETF | 105.5312 | 105.7812 | 105.5 | 105.7812 | 29000.0 |
| 2000-02-17 13:30:00 | DIA | ETF | 105.75 | 106.2188 | 105.6875 | 105.75 | 73200.0 |
| 2000-02-17 14:00:00 | DIA | ETF | 105.8125 | 105.875 | 105.2812 | 105.4375 | 54000.0 |
| 2000-02-17 14:30:00 | DIA | ETF | 105.5 | 105.6875 | 105.0625 | 105.2812 | 35900.0 |
| 2000-02-17 15:00:00 | DIA | ETF | 105.125 | 105.2812 | 104.75 | 105.0 | 40000.0 |
| 2000-02-17 15:30:00 | DIA | ETF | 104.8125 | 105.375 | 104.8125 | 105.1875 | 57500.0 |
| 2000-02-17 16:00:00 | DIA | ETF | 105.0625 | 105.0625 | 104.75 | 104.7812 | 32400.0 |
> showing 46 of 214 rows — these rows as CSV