PREVIEW / etf_30min / 2004-02-25
file: by_date/etf_30min/2004/2004-02-25.parquet size: 34 KB rows: 1,144
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-25 08:00:00 | SPY | ETF | 114.53 | 114.64 | 114.53 | 114.63 | 14100.0 |
| 2004-02-25 08:30:00 | SPY | ETF | 114.63 | 114.64 | 114.55 | 114.55 | 5500.0 |
| 2004-02-25 09:00:00 | SPY | ETF | 114.54 | 114.54 | 114.48 | 114.48 | 19600.0 |
| 2004-02-25 09:30:00 | SPY | ETF | 114.46 | 114.84 | 114.38 | 114.8 | 6534000.0 |
| 2004-02-25 10:00:00 | SPY | ETF | 114.78 | 114.91 | 114.66 | 114.74 | 2593200.0 |
| 2004-02-25 10:30:00 | SPY | ETF | 114.73 | 114.83 | 114.63 | 114.77 | 1372200.0 |
| 2004-02-25 11:00:00 | SPY | ETF | 114.75 | 115.03 | 114.58 | 114.6 | 3492200.0 |
| 2004-02-25 11:30:00 | SPY | ETF | 114.61 | 114.71 | 114.32 | 114.54 | 1705800.0 |
| 2004-02-25 12:00:00 | SPY | ETF | 114.55 | 114.72 | 114.48 | 114.6901 | 529700.0 |
| 2004-02-25 12:30:00 | SPY | ETF | 114.69 | 114.87 | 114.67 | 114.87 | 2606000.0 |
| 2004-02-25 13:00:00 | SPY | ETF | 114.88 | 114.89 | 114.72 | 114.75 | 639300.0 |
| 2004-02-25 13:30:00 | SPY | ETF | 114.75 | 114.95 | 114.66 | 114.84 | 661700.0 |
| 2004-02-25 14:00:00 | SPY | ETF | 114.84 | 114.91 | 114.76 | 114.84 | 953600.0 |
| 2004-02-25 14:30:00 | SPY | ETF | 114.82 | 114.94 | 114.71 | 114.82 | 1152800.0 |
| 2004-02-25 15:00:00 | SPY | ETF | 114.81 | 115.06 | 114.79 | 115.02 | 2577700.0 |
| 2004-02-25 15:30:00 | SPY | ETF | 115.02 | 115.04 | 114.87 | 114.91 | 2425600.0 |
| 2004-02-25 16:00:00 | SPY | ETF | 114.91 | 114.94 | 114.81 | 114.88 | 1976300.0 |
| 2004-02-25 16:30:00 | SPY | ETF | 114.87 | 114.96 | 114.83 | 114.93 | 559500.0 |
| 2004-02-25 17:00:00 | SPY | ETF | 114.96 | 114.99 | 114.87 | 114.98 | 90200.0 |
| 2004-02-25 17:30:00 | SPY | ETF | 114.92 | 114.98 | 114.92 | 114.98 | 1400.0 |
| 2004-02-25 18:00:00 | SPY | ETF | 114.99 | 114.99 | 114.99 | 114.99 | 200.0 |
| 2004-02-25 18:30:00 | SPY | ETF | 114.99 | 114.99 | 114.97 | 114.99 | 17100.0 |
| 2004-02-25 19:00:00 | SPY | ETF | 114.97 | 114.97 | 114.97 | 114.97 | 100.0 |
| 2004-02-25 19:30:00 | SPY | ETF | 114.95 | 114.95 | 114.95 | 114.95 | 500.0 |
| 2004-02-25 08:00:00 | QQQ | ETF | 36.39 | 36.44 | 36.39 | 36.44 | 40900.0 |
| 2004-02-25 08:30:00 | QQQ | ETF | 36.44 | 36.45 | 36.41 | 36.42 | 92300.0 |
| 2004-02-25 09:00:00 | QQQ | ETF | 36.41 | 36.44 | 36.4 | 36.43 | 112000.0 |
| 2004-02-25 09:30:00 | QQQ | ETF | 36.43 | 36.67 | 36.4 | 36.64 | 13824900.0 |
| 2004-02-25 10:00:00 | QQQ | ETF | 36.63 | 36.654 | 36.51 | 36.52 | 7674600.0 |
| 2004-02-25 10:30:00 | QQQ | ETF | 36.52 | 36.563 | 36.45 | 36.51 | 6063000.0 |
| 2004-02-25 11:00:00 | QQQ | ETF | 36.512 | 36.63 | 36.44 | 36.44 | 6824000.0 |
| 2004-02-25 11:30:00 | QQQ | ETF | 36.45 | 36.49 | 36.33 | 36.42 | 5580000.0 |
| 2004-02-25 12:00:00 | QQQ | ETF | 36.42 | 36.49 | 36.38 | 36.48 | 2296700.0 |
| 2004-02-25 12:30:00 | QQQ | ETF | 36.48 | 36.58 | 36.478 | 36.57 | 2823300.0 |
| 2004-02-25 13:00:00 | QQQ | ETF | 36.57 | 36.58 | 36.51 | 36.52 | 2288800.0 |
| 2004-02-25 13:30:00 | QQQ | ETF | 36.52 | 36.601 | 36.5 | 36.56 | 2526600.0 |
| 2004-02-25 14:00:00 | QQQ | ETF | 36.56 | 36.581 | 36.53 | 36.56 | 1574600.0 |
| 2004-02-25 14:30:00 | QQQ | ETF | 36.57 | 36.606 | 36.46 | 36.52 | 3291500.0 |
| 2004-02-25 15:00:00 | QQQ | ETF | 36.51 | 36.64 | 36.49 | 36.602 | 5041800.0 |
| 2004-02-25 15:30:00 | QQQ | ETF | 36.604 | 36.64 | 36.54 | 36.58 | 5950800.0 |
| 2004-02-25 16:00:00 | QQQ | ETF | 36.58 | 36.61 | 36.5 | 36.53 | 2858200.0 |
| 2004-02-25 16:30:00 | QQQ | ETF | 36.53 | 36.622 | 36.53 | 36.62 | 1336300.0 |
| 2004-02-25 17:00:00 | QQQ | ETF | 36.62 | 36.62 | 36.59 | 36.62 | 131600.0 |
| 2004-02-25 17:30:00 | QQQ | ETF | 36.621 | 36.64 | 36.6 | 36.63 | 46600.0 |
| 2004-02-25 18:00:00 | QQQ | ETF | 36.63 | 36.631 | 36.61 | 36.62 | 15800.0 |
| 2004-02-25 18:30:00 | QQQ | ETF | 36.63 | 36.63 | 36.58 | 36.62 | 30500.0 |
| 2004-02-25 19:00:00 | QQQ | ETF | 36.61 | 36.62 | 36.6 | 36.62 | 700.0 |
| 2004-02-25 19:30:00 | QQQ | ETF | 36.61 | 36.63 | 36.6 | 36.6 | 8600.0 |
| 2004-02-25 09:00:00 | IWM | ETF | 57.075 | 57.075 | 57.075 | 57.075 | 2000.0 |
| 2004-02-25 09:30:00 | IWM | ETF | 57.07 | 57.345 | 56.84 | 57.325 | 2953000.0 |
> showing 50 of 1,144 rows — these rows as CSV