PREVIEW / etf_30min / 2003-11-17
file: by_date/etf_30min/2003/2003-11-17.parquet size: 28 KB rows: 872
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 |
|---|---|---|---|---|---|---|---|
| 2003-11-17 08:00:00 | SPY | ETF | 104.9 | 104.94 | 104.8 | 104.8 | 105800.0 |
| 2003-11-17 08:30:00 | SPY | ETF | 104.8 | 104.96 | 104.77 | 104.8 | 159400.0 |
| 2003-11-17 09:00:00 | SPY | ETF | 104.82 | 104.96 | 104.82 | 104.95 | 196000.0 |
| 2003-11-17 09:30:00 | SPY | ETF | 104.91 | 105.14 | 104.8 | 104.82 | 4272800.0 |
| 2003-11-17 10:00:00 | SPY | ETF | 104.85 | 104.87 | 104.48 | 104.6 | 6408100.0 |
| 2003-11-17 10:30:00 | SPY | ETF | 104.6 | 104.73 | 104.54 | 104.66 | 2410000.0 |
| 2003-11-17 11:00:00 | SPY | ETF | 104.65 | 104.69 | 104.25 | 104.37 | 3075700.0 |
| 2003-11-17 11:30:00 | SPY | ETF | 104.35 | 104.56 | 104.211 | 104.55 | 2648900.0 |
| 2003-11-17 12:00:00 | SPY | ETF | 104.55 | 104.59 | 104.42 | 104.48 | 1191700.0 |
| 2003-11-17 12:30:00 | SPY | ETF | 104.48 | 104.56 | 104.34 | 104.48 | 1278300.0 |
| 2003-11-17 13:00:00 | SPY | ETF | 104.47 | 104.48 | 104.04 | 104.14 | 3646600.0 |
| 2003-11-17 13:30:00 | SPY | ETF | 104.13 | 104.31 | 104.09 | 104.27 | 1242500.0 |
| 2003-11-17 14:00:00 | SPY | ETF | 104.3 | 104.44 | 104.18 | 104.39 | 2408800.0 |
| 2003-11-17 14:30:00 | SPY | ETF | 104.39 | 104.5 | 104.19 | 104.48 | 2059800.0 |
| 2003-11-17 15:00:00 | SPY | ETF | 104.48 | 104.79 | 104.23 | 104.68 | 3013500.0 |
| 2003-11-17 15:30:00 | SPY | ETF | 104.67 | 105.04 | 104.61 | 104.86 | 3211200.0 |
| 2003-11-17 16:00:00 | SPY | ETF | 104.86 | 105.0 | 104.81 | 104.93 | 1318600.0 |
| 2003-11-17 16:30:00 | SPY | ETF | 104.94 | 105.0 | 104.91 | 105.0 | 174800.0 |
| 2003-11-17 17:00:00 | SPY | ETF | 104.99 | 105.03 | 104.94 | 104.94 | 58200.0 |
| 2003-11-17 17:30:00 | SPY | ETF | 104.93 | 104.95 | 104.93 | 104.95 | 5300.0 |
| 2003-11-17 18:00:00 | SPY | ETF | 104.99 | 105.05 | 104.99 | 105.0 | 18000.0 |
| 2003-11-17 18:30:00 | SPY | ETF | 105.01 | 105.01 | 104.96 | 104.96 | 7000.0 |
| 2003-11-17 19:00:00 | SPY | ETF | 104.94 | 104.94 | 104.92 | 104.92 | 500.0 |
| 2003-11-17 19:30:00 | SPY | ETF | 104.92 | 104.95 | 104.92 | 104.95 | 1500.0 |
| 2003-11-17 08:00:00 | QQQ | ETF | 34.81 | 34.82 | 34.75 | 34.76 | 100200.0 |
| 2003-11-17 08:30:00 | QQQ | ETF | 34.78 | 34.82 | 34.71 | 34.75 | 245800.0 |
| 2003-11-17 09:00:00 | QQQ | ETF | 34.76 | 34.83 | 34.74 | 34.83 | 268000.0 |
| 2003-11-17 09:30:00 | QQQ | ETF | 34.84 | 34.91 | 34.73 | 34.744 | 12290300.0 |
| 2003-11-17 10:00:00 | QQQ | ETF | 34.75 | 34.79 | 34.53 | 34.66 | 12945500.0 |
| 2003-11-17 10:30:00 | QQQ | ETF | 34.66 | 34.73 | 34.59 | 34.68 | 5105200.0 |
| 2003-11-17 11:00:00 | QQQ | ETF | 34.68 | 34.69 | 34.44 | 34.51 | 8689900.0 |
| 2003-11-17 11:30:00 | QQQ | ETF | 34.508 | 34.575 | 34.41 | 34.57 | 5332100.0 |
| 2003-11-17 12:00:00 | QQQ | ETF | 34.572 | 34.6 | 34.5 | 34.566 | 3261200.0 |
| 2003-11-17 12:30:00 | QQQ | ETF | 34.565 | 34.59 | 34.46 | 34.5 | 3528800.0 |
| 2003-11-17 13:00:00 | QQQ | ETF | 34.51 | 34.52 | 34.26 | 34.275 | 7535400.0 |
| 2003-11-17 13:30:00 | QQQ | ETF | 34.28 | 34.344 | 34.27 | 34.344 | 3461300.0 |
| 2003-11-17 14:00:00 | QQQ | ETF | 34.35 | 34.44 | 34.297 | 34.4 | 7137300.0 |
| 2003-11-17 14:30:00 | QQQ | ETF | 34.4 | 34.47 | 34.31 | 34.46 | 5950600.0 |
| 2003-11-17 15:00:00 | QQQ | ETF | 34.45 | 34.58 | 34.31 | 34.496 | 9195600.0 |
| 2003-11-17 15:30:00 | QQQ | ETF | 34.49 | 34.67 | 34.47 | 34.62 | 9647800.0 |
| 2003-11-17 16:00:00 | QQQ | ETF | 34.62 | 34.71 | 34.46 | 34.69 | 3133400.0 |
| 2003-11-17 16:30:00 | QQQ | ETF | 34.68 | 34.731 | 34.66 | 34.68 | 412400.0 |
| 2003-11-17 17:00:00 | QQQ | ETF | 34.68 | 34.69 | 34.66 | 34.66 | 31100.0 |
| 2003-11-17 17:30:00 | QQQ | ETF | 34.66 | 34.72 | 34.66 | 34.68 | 18500.0 |
| 2003-11-17 18:00:00 | QQQ | ETF | 34.66 | 34.72 | 34.5046 | 34.71 | 375500.0 |
| 2003-11-17 18:30:00 | QQQ | ETF | 34.68 | 34.68 | 34.67 | 34.67 | 15300.0 |
| 2003-11-17 19:00:00 | QQQ | ETF | 34.67 | 34.67 | 34.61 | 34.66 | 6700.0 |
| 2003-11-17 19:30:00 | QQQ | ETF | 34.63 | 34.66 | 34.63 | 34.66 | 2600.0 |
| 2003-11-17 09:00:00 | IWM | ETF | 52.73 | 52.73 | 52.73 | 52.73 | 200.0 |
| 2003-11-17 09:30:00 | IWM | ETF | 52.725 | 52.737 | 52.34 | 52.35 | 958000.0 |
> showing 50 of 872 rows — these rows as CSV