PREVIEW / etf_30min / 2004-02-17
file: by_date/etf_30min/2004/2004-02-17.parquet size: 35 KB rows: 1,223
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 |
|---|---|---|---|---|---|---|---|
| 2004-02-17 08:00:00 | SPY | ETF | 115.67 | 115.7 | 115.66 | 115.7 | 4600.0 |
| 2004-02-17 08:30:00 | SPY | ETF | 115.7 | 115.9 | 115.7 | 115.84 | 81400.0 |
| 2004-02-17 09:00:00 | SPY | ETF | 115.81 | 115.85 | 115.79 | 115.81 | 48900.0 |
| 2004-02-17 09:30:00 | SPY | ETF | 115.85 | 116.04 | 115.77 | 115.88 | 3109300.0 |
| 2004-02-17 10:00:00 | SPY | ETF | 115.89 | 116.03 | 115.78 | 115.86 | 1831400.0 |
| 2004-02-17 10:30:00 | SPY | ETF | 115.85 | 116.07 | 115.81 | 115.99 | 1336800.0 |
| 2004-02-17 11:00:00 | SPY | ETF | 115.99 | 116.16 | 115.95 | 116.02 | 1298700.0 |
| 2004-02-17 11:30:00 | SPY | ETF | 116.02 | 116.11 | 116.0 | 116.02 | 996000.0 |
| 2004-02-17 12:00:00 | SPY | ETF | 116.01 | 116.31 | 116.0 | 116.26 | 1616100.0 |
| 2004-02-17 12:30:00 | SPY | ETF | 116.25 | 116.31 | 116.13 | 116.19 | 1359700.0 |
| 2004-02-17 13:00:00 | SPY | ETF | 116.18 | 116.27 | 116.04 | 116.11 | 1443300.0 |
| 2004-02-17 13:30:00 | SPY | ETF | 116.11 | 116.23 | 116.05 | 116.15 | 1386800.0 |
| 2004-02-17 14:00:00 | SPY | ETF | 116.19 | 116.43 | 116.12 | 116.35 | 1299000.0 |
| 2004-02-17 14:30:00 | SPY | ETF | 116.35 | 116.4 | 116.25 | 116.38 | 1379700.0 |
| 2004-02-17 15:00:00 | SPY | ETF | 116.38 | 116.41 | 116.17 | 116.2 | 2040700.0 |
| 2004-02-17 15:30:00 | SPY | ETF | 116.21 | 116.27 | 116.07 | 116.14 | 2749100.0 |
| 2004-02-17 16:00:00 | SPY | ETF | 116.14 | 116.21 | 116.1 | 116.2 | 1283100.0 |
| 2004-02-17 16:30:00 | SPY | ETF | 116.2 | 116.33 | 116.2 | 116.33 | 88400.0 |
| 2004-02-17 17:00:00 | SPY | ETF | 116.29 | 116.34 | 116.28 | 116.28 | 6200.0 |
| 2004-02-17 17:30:00 | SPY | ETF | 116.25 | 116.33 | 116.25 | 116.33 | 200.0 |
| 2004-02-17 18:00:00 | SPY | ETF | 116.26 | 116.27 | 116.26 | 116.27 | 1500.0 |
| 2004-02-17 18:30:00 | SPY | ETF | 116.27 | 116.27 | 116.21 | 116.26 | 3100.0 |
| 2004-02-17 19:00:00 | SPY | ETF | 116.26 | 116.26 | 116.23 | 116.23 | 1200.0 |
| 2004-02-17 19:30:00 | SPY | ETF | 116.18 | 116.18 | 116.18 | 116.18 | 100.0 |
| 2004-02-17 08:00:00 | QQQ | ETF | 37.19 | 37.2 | 37.17 | 37.19 | 30300.0 |
| 2004-02-17 08:30:00 | QQQ | ETF | 37.2 | 37.28 | 37.2 | 37.26 | 79900.0 |
| 2004-02-17 09:00:00 | QQQ | ETF | 37.25 | 37.27 | 37.24 | 37.24 | 107900.0 |
| 2004-02-17 09:30:00 | QQQ | ETF | 37.28 | 37.41 | 37.22 | 37.29 | 12314800.0 |
| 2004-02-17 10:00:00 | QQQ | ETF | 37.29 | 37.36 | 37.23 | 37.29 | 4356400.0 |
| 2004-02-17 10:30:00 | QQQ | ETF | 37.29 | 37.37 | 37.24 | 37.29 | 3952900.0 |
| 2004-02-17 11:00:00 | QQQ | ETF | 37.3 | 37.4 | 37.29 | 37.36 | 5417600.0 |
| 2004-02-17 11:30:00 | QQQ | ETF | 37.363 | 37.4 | 37.3 | 37.33 | 2784500.0 |
| 2004-02-17 12:00:00 | QQQ | ETF | 37.33 | 37.48 | 37.33 | 37.46 | 5461000.0 |
| 2004-02-17 12:30:00 | QQQ | ETF | 37.46 | 37.48 | 37.42 | 37.44 | 3512800.0 |
| 2004-02-17 13:00:00 | QQQ | ETF | 37.44 | 37.51 | 37.429 | 37.44 | 3629300.0 |
| 2004-02-17 13:30:00 | QQQ | ETF | 37.44 | 37.48 | 37.42 | 37.47 | 2495600.0 |
| 2004-02-17 14:00:00 | QQQ | ETF | 37.474 | 37.62 | 37.44 | 37.57 | 5939900.0 |
| 2004-02-17 14:30:00 | QQQ | ETF | 37.57 | 37.604 | 37.537 | 37.6 | 3457300.0 |
| 2004-02-17 15:00:00 | QQQ | ETF | 37.6 | 37.61 | 37.47 | 37.482 | 4917700.0 |
| 2004-02-17 15:30:00 | QQQ | ETF | 37.485 | 37.54 | 37.45 | 37.463 | 6744900.0 |
| 2004-02-17 16:00:00 | QQQ | ETF | 37.46 | 37.489 | 37.4 | 37.489 | 1937100.0 |
| 2004-02-17 16:30:00 | QQQ | ETF | 37.48 | 37.54 | 37.46 | 37.54 | 635200.0 |
| 2004-02-17 17:00:00 | QQQ | ETF | 37.54 | 37.56 | 37.522 | 37.55 | 110100.0 |
| 2004-02-17 17:30:00 | QQQ | ETF | 37.54 | 37.56 | 37.53 | 37.55 | 23200.0 |
| 2004-02-17 18:00:00 | QQQ | ETF | 37.55 | 37.56 | 37.53 | 37.54 | 56300.0 |
| 2004-02-17 18:30:00 | QQQ | ETF | 37.53 | 37.53 | 37.51 | 37.51 | 25000.0 |
| 2004-02-17 19:00:00 | QQQ | ETF | 37.51 | 37.53 | 37.51 | 37.51 | 11500.0 |
| 2004-02-17 19:30:00 | QQQ | ETF | 37.51 | 37.53 | 37.5 | 37.53 | 30900.0 |
| 2004-02-17 08:30:00 | IWM | ETF | 58.7 | 58.7 | 58.7 | 58.7 | 1000.0 |
| 2004-02-17 09:30:00 | IWM | ETF | 58.71 | 58.92 | 58.68 | 58.79 | 1384800.0 |
> showing 50 of 1,223 rows — these rows as CSV