PREVIEW / etf_30min / 2004-12-17
file: by_date/etf_30min/2004/2004-12-17.parquet size: 40 KB rows: 1,339
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-12-17 08:00:00 | SPY | ETF | 120.18 | 120.18 | 120.09 | 120.14 | 187900.0 |
| 2004-12-17 08:30:00 | SPY | ETF | 120.15 | 120.24 | 119.97 | 120.03 | 193200.0 |
| 2004-12-17 09:00:00 | SPY | ETF | 120.01 | 120.03 | 119.28 | 119.46 | 583400.0 |
| 2004-12-17 09:30:00 | SPY | ETF | 119.46 | 119.86 | 119.3 | 119.72 | 7703400.0 |
| 2004-12-17 10:00:00 | SPY | ETF | 119.71 | 119.8 | 119.47 | 119.75 | 4828100.0 |
| 2004-12-17 10:30:00 | SPY | ETF | 119.75 | 119.97 | 119.65 | 119.73 | 3399600.0 |
| 2004-12-17 11:00:00 | SPY | ETF | 119.73 | 119.77 | 119.3 | 119.46 | 3916200.0 |
| 2004-12-17 11:30:00 | SPY | ETF | 119.45 | 119.48 | 119.24 | 119.32 | 4382600.0 |
| 2004-12-17 12:00:00 | SPY | ETF | 119.32 | 119.52 | 119.18 | 119.45 | 4352100.0 |
| 2004-12-17 12:30:00 | SPY | ETF | 119.46 | 119.47 | 119.33 | 119.37 | 1473800.0 |
| 2004-12-17 13:00:00 | SPY | ETF | 119.34 | 119.51 | 119.2 | 119.49 | 2000800.0 |
| 2004-12-17 13:30:00 | SPY | ETF | 119.47 | 119.52 | 119.16 | 119.35 | 2518200.0 |
| 2004-12-17 14:00:00 | SPY | ETF | 119.36 | 119.43 | 119.25 | 119.43 | 2032300.0 |
| 2004-12-17 14:30:00 | SPY | ETF | 119.4 | 119.71 | 119.34 | 119.63 | 3168500.0 |
| 2004-12-17 15:00:00 | SPY | ETF | 119.65 | 119.68 | 119.39 | 119.49 | 2853300.0 |
| 2004-12-17 15:30:00 | SPY | ETF | 119.48 | 119.68 | 119.39 | 119.42 | 6116200.0 |
| 2004-12-17 16:00:00 | SPY | ETF | 119.42 | 119.56 | 119.35 | 119.55 | 3405600.0 |
| 2004-12-17 16:30:00 | SPY | ETF | 119.5 | 119.75 | 119.35 | 119.7 | 1598000.0 |
| 2004-12-17 17:00:00 | SPY | ETF | 119.7 | 119.75 | 119.55 | 119.64 | 118400.0 |
| 2004-12-17 17:30:00 | SPY | ETF | 119.65 | 119.66 | 119.5 | 119.54 | 31200.0 |
| 2004-12-17 18:00:00 | SPY | ETF | 119.53 | 119.57 | 119.38 | 119.38 | 69900.0 |
| 2004-12-17 19:30:00 | SPY | ETF | 119.43 | 119.43 | 119.4 | 119.4 | 600.0 |
| 2004-12-17 08:00:00 | QQQ | ETF | 39.72 | 39.73 | 39.68 | 39.72 | 917619.0 |
| 2004-12-17 08:30:00 | QQQ | ETF | 39.72 | 39.77 | 39.645 | 39.66 | 732412.0 |
| 2004-12-17 09:00:00 | QQQ | ETF | 39.66 | 39.71 | 39.541 | 39.64 | 984448.0 |
| 2004-12-17 09:30:00 | QQQ | ETF | 39.65 | 39.81 | 39.58 | 39.72 | 14732310.0 |
| 2004-12-17 10:00:00 | QQQ | ETF | 39.72 | 39.74 | 39.57 | 39.643 | 6918898.0 |
| 2004-12-17 10:30:00 | QQQ | ETF | 39.643 | 39.743 | 39.643 | 39.711 | 6664329.0 |
| 2004-12-17 11:00:00 | QQQ | ETF | 39.71 | 39.72 | 39.544 | 39.595 | 5689405.0 |
| 2004-12-17 11:30:00 | QQQ | ETF | 39.592 | 39.61 | 39.48 | 39.521 | 8306695.0 |
| 2004-12-17 12:00:00 | QQQ | ETF | 39.52 | 39.58 | 39.47 | 39.561 | 5907726.0 |
| 2004-12-17 12:30:00 | QQQ | ETF | 39.57 | 39.592 | 39.52 | 39.53 | 2826548.0 |
| 2004-12-17 13:00:00 | QQQ | ETF | 39.54 | 39.561 | 39.45 | 39.56 | 2987059.0 |
| 2004-12-17 13:30:00 | QQQ | ETF | 39.559 | 39.56 | 39.458 | 39.492 | 5543281.0 |
| 2004-12-17 14:00:00 | QQQ | ETF | 39.49 | 39.54 | 39.45 | 39.523 | 3366916.0 |
| 2004-12-17 14:30:00 | QQQ | ETF | 39.53 | 39.62 | 39.47 | 39.582 | 4785103.0 |
| 2004-12-17 15:00:00 | QQQ | ETF | 39.582 | 39.6 | 39.51 | 39.534 | 3913084.0 |
| 2004-12-17 15:30:00 | QQQ | ETF | 39.533 | 39.6 | 39.46 | 39.473 | 9621578.0 |
| 2004-12-17 16:00:00 | QQQ | ETF | 39.48 | 39.57 | 39.45 | 39.45 | 3780378.0 |
| 2004-12-17 16:30:00 | QQQ | ETF | 39.46 | 39.55 | 39.431 | 39.513 | 481363.0 |
| 2004-12-17 17:00:00 | QQQ | ETF | 39.54 | 39.6 | 39.52 | 39.57 | 537658.0 |
| 2004-12-17 17:30:00 | QQQ | ETF | 39.57 | 39.57 | 39.42 | 39.42 | 178405.0 |
| 2004-12-17 18:00:00 | QQQ | ETF | 39.42 | 39.43 | 39.31 | 39.33 | 173280.0 |
| 2004-12-17 08:00:00 | IWM | ETF | 64.225 | 64.495 | 64.21 | 64.27 | 73400.0 |
| 2004-12-17 09:00:00 | IWM | ETF | 64.22 | 64.22 | 63.89 | 63.91 | 11200.0 |
| 2004-12-17 09:30:00 | IWM | ETF | 63.975 | 64.25 | 63.97 | 64.105 | 3742400.0 |
| 2004-12-17 10:00:00 | IWM | ETF | 64.1 | 64.105 | 63.92 | 64.0 | 1993400.0 |
| 2004-12-17 10:30:00 | IWM | ETF | 64.01 | 64.15 | 64.01 | 64.09 | 1052000.0 |
| 2004-12-17 11:00:00 | IWM | ETF | 64.085 | 64.09 | 63.905 | 63.96 | 783600.0 |
| 2004-12-17 11:30:00 | IWM | ETF | 63.96 | 63.965 | 63.83 | 63.93 | 1066000.0 |
> showing 50 of 1,339 rows — these rows as CSV