PREVIEW / etf_30min / 2004-02-18
file: by_date/etf_30min/2004/2004-02-18.parquet size: 35 KB rows: 1,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 |
|---|---|---|---|---|---|---|---|
| 2004-02-18 08:00:00 | SPY | ETF | 116.3 | 116.3 | 116.3 | 116.3 | 100.0 |
| 2004-02-18 08:30:00 | SPY | ETF | 116.25 | 116.32 | 116.25 | 116.32 | 25600.0 |
| 2004-02-18 09:00:00 | SPY | ETF | 116.28 | 116.3 | 116.2 | 116.2 | 53600.0 |
| 2004-02-18 09:30:00 | SPY | ETF | 116.2 | 116.25 | 115.9 | 116.03 | 3554300.0 |
| 2004-02-18 10:00:00 | SPY | ETF | 116.04 | 116.2 | 115.98 | 116.02 | 1810800.0 |
| 2004-02-18 10:30:00 | SPY | ETF | 116.02 | 116.07 | 115.85 | 115.95 | 2019500.0 |
| 2004-02-18 11:00:00 | SPY | ETF | 115.95 | 116.05 | 115.93 | 115.99 | 1256000.0 |
| 2004-02-18 11:30:00 | SPY | ETF | 115.99 | 116.11 | 115.95 | 115.98 | 1229400.0 |
| 2004-02-18 12:00:00 | SPY | ETF | 115.98 | 116.13 | 115.89 | 116.1 | 534800.0 |
| 2004-02-18 12:30:00 | SPY | ETF | 116.09 | 116.25 | 116.08 | 116.11 | 1272500.0 |
| 2004-02-18 13:00:00 | SPY | ETF | 116.11 | 116.2 | 115.94 | 116.03 | 537600.0 |
| 2004-02-18 13:30:00 | SPY | ETF | 116.03 | 116.1 | 115.97 | 116.08 | 394600.0 |
| 2004-02-18 14:00:00 | SPY | ETF | 116.07 | 116.09 | 115.35 | 115.52 | 4429300.0 |
| 2004-02-18 14:30:00 | SPY | ETF | 115.5 | 115.65 | 115.48 | 115.62 | 3010500.0 |
| 2004-02-18 15:00:00 | SPY | ETF | 115.62 | 115.79 | 115.56 | 115.68 | 1661500.0 |
| 2004-02-18 15:30:00 | SPY | ETF | 115.67 | 115.8 | 115.63 | 115.66 | 1634900.0 |
| 2004-02-18 16:00:00 | SPY | ETF | 115.65 | 115.76 | 115.57 | 115.68 | 1067800.0 |
| 2004-02-18 16:30:00 | SPY | ETF | 115.68 | 115.83 | 115.68 | 115.82 | 159000.0 |
| 2004-02-18 17:00:00 | SPY | ETF | 115.81 | 115.89 | 115.8 | 115.89 | 333900.0 |
| 2004-02-18 17:30:00 | SPY | ETF | 115.94 | 115.94 | 115.85 | 115.85 | 3700.0 |
| 2004-02-18 18:00:00 | SPY | ETF | 115.85 | 115.95 | 115.85 | 115.94 | 38800.0 |
| 2004-02-18 18:30:00 | SPY | ETF | 115.9 | 115.9 | 115.9 | 115.9 | 500.0 |
| 2004-02-18 19:30:00 | SPY | ETF | 115.9 | 115.9 | 115.9 | 115.9 | 100.0 |
| 2004-02-18 08:00:00 | QQQ | ETF | 37.53 | 37.55 | 37.53 | 37.54 | 18600.0 |
| 2004-02-18 08:30:00 | QQQ | ETF | 37.5 | 37.54 | 37.5 | 37.53 | 18100.0 |
| 2004-02-18 09:00:00 | QQQ | ETF | 37.53 | 37.53 | 37.5 | 37.51 | 99300.0 |
| 2004-02-18 09:30:00 | QQQ | ETF | 37.51 | 37.57 | 37.41 | 37.48 | 10242500.0 |
| 2004-02-18 10:00:00 | QQQ | ETF | 37.479 | 37.55 | 37.41 | 37.44 | 5226800.0 |
| 2004-02-18 10:30:00 | QQQ | ETF | 37.435 | 37.44 | 37.32 | 37.39 | 7747300.0 |
| 2004-02-18 11:00:00 | QQQ | ETF | 37.37 | 37.46 | 37.36 | 37.42 | 2959400.0 |
| 2004-02-18 11:30:00 | QQQ | ETF | 37.424 | 37.53 | 37.4 | 37.47 | 3289800.0 |
| 2004-02-18 12:00:00 | QQQ | ETF | 37.46 | 37.59 | 37.44 | 37.56 | 4238100.0 |
| 2004-02-18 12:30:00 | QQQ | ETF | 37.56 | 37.67 | 37.56 | 37.6 | 4956100.0 |
| 2004-02-18 13:00:00 | QQQ | ETF | 37.592 | 37.66 | 37.55 | 37.56 | 3963300.0 |
| 2004-02-18 13:30:00 | QQQ | ETF | 37.57 | 37.6 | 37.55 | 37.59 | 1500100.0 |
| 2004-02-18 14:00:00 | QQQ | ETF | 37.59 | 37.59 | 37.34 | 37.393 | 6836400.0 |
| 2004-02-18 14:30:00 | QQQ | ETF | 37.392 | 37.44 | 37.36 | 37.43 | 4609700.0 |
| 2004-02-18 15:00:00 | QQQ | ETF | 37.43 | 37.52 | 37.4 | 37.471 | 3836700.0 |
| 2004-02-18 15:30:00 | QQQ | ETF | 37.471 | 37.546 | 37.45 | 37.49 | 4460200.0 |
| 2004-02-18 16:00:00 | QQQ | ETF | 37.49 | 37.57 | 37.46 | 37.52 | 2321700.0 |
| 2004-02-18 16:30:00 | QQQ | ETF | 37.57 | 37.7 | 37.566 | 37.67 | 863800.0 |
| 2004-02-18 17:00:00 | QQQ | ETF | 37.68 | 37.75 | 37.66 | 37.75 | 1043700.0 |
| 2004-02-18 17:30:00 | QQQ | ETF | 37.74 | 37.75 | 37.72 | 37.73 | 71900.0 |
| 2004-02-18 18:00:00 | QQQ | ETF | 37.73 | 37.77 | 37.72 | 37.74 | 49500.0 |
| 2004-02-18 18:30:00 | QQQ | ETF | 37.74 | 37.75 | 37.72 | 37.73 | 65100.0 |
| 2004-02-18 19:00:00 | QQQ | ETF | 37.73 | 37.74 | 37.72 | 37.72 | 39900.0 |
| 2004-02-18 19:30:00 | QQQ | ETF | 37.74 | 37.74 | 37.72 | 37.72 | 34200.0 |
| 2004-02-18 08:30:00 | IWM | ETF | 59.465 | 59.525 | 59.45 | 59.525 | 3200.0 |
| 2004-02-18 09:00:00 | IWM | ETF | 59.475 | 59.475 | 59.42 | 59.42 | 6200.0 |
| 2004-02-18 09:30:00 | IWM | ETF | 59.4 | 59.435 | 59.125 | 59.205 | 772200.0 |
> showing 50 of 1,214 rows — these rows as CSV