PREVIEW / etf_30min / 2003-01-07
file: by_date/etf_30min/2003/2003-01-07.parquet size: 22 KB rows: 653
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-01-07 08:00:00 | SPY | ETF | 92.84 | 92.84 | 92.6 | 92.6 | 6000.0 |
| 2003-01-07 08:30:00 | SPY | ETF | 92.66 | 92.85 | 92.65 | 92.85 | 15700.0 |
| 2003-01-07 09:00:00 | SPY | ETF | 92.85 | 92.96 | 92.85 | 92.9 | 10200.0 |
| 2003-01-07 09:30:00 | SPY | ETF | 92.9 | 92.98 | 92.57 | 92.86 | 3086900.0 |
| 2003-01-07 10:00:00 | SPY | ETF | 92.85 | 93.13 | 92.62 | 92.7 | 3984800.0 |
| 2003-01-07 10:30:00 | SPY | ETF | 92.7 | 92.71 | 92.2 | 92.3 | 5072600.0 |
| 2003-01-07 11:00:00 | SPY | ETF | 92.33 | 92.82 | 92.27 | 92.74 | 2564700.0 |
| 2003-01-07 11:30:00 | SPY | ETF | 92.83 | 93.03 | 92.69 | 92.9 | 2180600.0 |
| 2003-01-07 12:00:00 | SPY | ETF | 92.9 | 93.0 | 92.64 | 92.79 | 1090800.0 |
| 2003-01-07 12:30:00 | SPY | ETF | 92.79 | 92.92 | 92.61 | 92.66 | 1048800.0 |
| 2003-01-07 13:00:00 | SPY | ETF | 92.67 | 92.89 | 92.45 | 92.86 | 2345500.0 |
| 2003-01-07 13:30:00 | SPY | ETF | 92.85 | 93.14 | 92.6 | 93.12 | 2378400.0 |
| 2003-01-07 14:00:00 | SPY | ETF | 93.12 | 93.37 | 92.9 | 92.93 | 2865700.0 |
| 2003-01-07 14:30:00 | SPY | ETF | 92.95 | 93.16 | 92.67 | 92.75 | 1908200.0 |
| 2003-01-07 15:00:00 | SPY | ETF | 92.79 | 93.07 | 92.53 | 92.63 | 2106100.0 |
| 2003-01-07 15:30:00 | SPY | ETF | 92.63 | 92.67 | 92.29 | 92.56 | 3127700.0 |
| 2003-01-07 16:00:00 | SPY | ETF | 92.57 | 92.8 | 92.46 | 92.78 | 1383900.0 |
| 2003-01-07 16:30:00 | SPY | ETF | 92.73 | 92.76 | 92.64 | 92.67 | 41800.0 |
| 2003-01-07 17:00:00 | SPY | ETF | 92.67 | 92.72 | 92.67 | 92.69 | 6500.0 |
| 2003-01-07 17:30:00 | SPY | ETF | 92.7 | 92.7 | 92.65 | 92.66 | 2100.0 |
| 2003-01-07 18:00:00 | SPY | ETF | 92.69 | 92.69 | 92.62 | 92.64 | 6400.0 |
| 2003-01-07 18:30:00 | SPY | ETF | 92.62 | 92.62 | 92.59 | 92.59 | 600.0 |
| 2003-01-07 19:00:00 | SPY | ETF | 92.65 | 92.65 | 92.65 | 92.65 | 500.0 |
| 2003-01-07 19:30:00 | SPY | ETF | 92.61 | 92.66 | 92.6 | 92.6 | 600.0 |
| 2003-01-07 08:00:00 | QQQ | ETF | 26.38 | 26.4 | 26.26 | 26.27 | 27500.0 |
| 2003-01-07 08:30:00 | QQQ | ETF | 26.3 | 26.37 | 26.29 | 26.34 | 23700.0 |
| 2003-01-07 09:00:00 | QQQ | ETF | 26.38 | 26.42 | 26.36 | 26.39 | 30900.0 |
| 2003-01-07 09:30:00 | QQQ | ETF | 26.4 | 26.53 | 26.3 | 26.49 | 9491000.0 |
| 2003-01-07 10:00:00 | QQQ | ETF | 26.52 | 26.8 | 26.46 | 26.52 | 13470900.0 |
| 2003-01-07 10:30:00 | QQQ | ETF | 26.53 | 26.57 | 26.25 | 26.32 | 9996900.0 |
| 2003-01-07 11:00:00 | QQQ | ETF | 26.32 | 26.58 | 26.3 | 26.56 | 5461800.0 |
| 2003-01-07 11:30:00 | QQQ | ETF | 26.57 | 26.69 | 26.52 | 26.64 | 2863100.0 |
| 2003-01-07 12:00:00 | QQQ | ETF | 26.63 | 26.65 | 26.51 | 26.6 | 2785500.0 |
| 2003-01-07 12:30:00 | QQQ | ETF | 26.6 | 26.66 | 26.51 | 26.55 | 2774400.0 |
| 2003-01-07 13:00:00 | QQQ | ETF | 26.56 | 26.69 | 26.45 | 26.67 | 4649200.0 |
| 2003-01-07 13:30:00 | QQQ | ETF | 26.66 | 26.83 | 26.56 | 26.83 | 5562500.0 |
| 2003-01-07 14:00:00 | QQQ | ETF | 26.8 | 26.93 | 26.65 | 26.69 | 6917600.0 |
| 2003-01-07 14:30:00 | QQQ | ETF | 26.69 | 26.84 | 26.57 | 26.65 | 3572900.0 |
| 2003-01-07 15:00:00 | QQQ | ETF | 26.65 | 26.81 | 26.6 | 26.68 | 3315100.0 |
| 2003-01-07 15:30:00 | QQQ | ETF | 26.7 | 26.7 | 26.45 | 26.64 | 8249300.0 |
| 2003-01-07 16:00:00 | QQQ | ETF | 26.61 | 26.69 | 26.51 | 26.66 | 1637600.0 |
| 2003-01-07 16:30:00 | QQQ | ETF | 26.65 | 26.67 | 26.58 | 26.62 | 231100.0 |
| 2003-01-07 17:00:00 | QQQ | ETF | 26.65 | 26.67 | 26.62 | 26.64 | 36600.0 |
| 2003-01-07 17:30:00 | QQQ | ETF | 26.63 | 26.65 | 26.6 | 26.62 | 25800.0 |
| 2003-01-07 18:00:00 | QQQ | ETF | 26.63 | 26.65 | 26.6 | 26.63 | 25800.0 |
| 2003-01-07 18:30:00 | QQQ | ETF | 26.63 | 26.63 | 26.62 | 26.62 | 5700.0 |
| 2003-01-07 19:00:00 | QQQ | ETF | 26.62 | 26.65 | 26.62 | 26.64 | 2000.0 |
| 2003-01-07 19:30:00 | QQQ | ETF | 26.63 | 26.63 | 26.6 | 26.6 | 3500.0 |
| 2003-01-07 09:30:00 | IWM | ETF | 39.35 | 39.44 | 39.25 | 39.35 | 314200.0 |
| 2003-01-07 10:00:00 | IWM | ETF | 39.405 | 39.45 | 39.1 | 39.1 | 350600.0 |
> showing 50 of 653 rows — these rows as CSV