PREVIEW / etf_30min / 2003-02-05
file: by_date/etf_30min/2003/2003-02-05.parquet size: 21 KB rows: 603
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-02-05 08:00:00 | SPY | ETF | 85.2 | 85.42 | 85.2 | 85.42 | 29400.0 |
| 2003-02-05 08:30:00 | SPY | ETF | 85.46 | 85.7 | 85.46 | 85.52 | 19800.0 |
| 2003-02-05 09:00:00 | SPY | ETF | 85.55 | 85.78 | 85.55 | 85.75 | 47000.0 |
| 2003-02-05 09:30:00 | SPY | ETF | 85.75 | 85.9 | 85.33 | 85.58 | 5265400.0 |
| 2003-02-05 10:00:00 | SPY | ETF | 85.58 | 85.68 | 84.89 | 85.23 | 4218900.0 |
| 2003-02-05 10:30:00 | SPY | ETF | 85.23 | 85.9 | 85.02 | 85.77 | 3870000.0 |
| 2003-02-05 11:00:00 | SPY | ETF | 85.77 | 85.97 | 85.35 | 85.55 | 2319700.0 |
| 2003-02-05 11:30:00 | SPY | ETF | 85.54 | 85.87 | 85.47 | 85.76 | 1924300.0 |
| 2003-02-05 12:00:00 | SPY | ETF | 85.72 | 86.07 | 85.64 | 85.99 | 2865600.0 |
| 2003-02-05 12:30:00 | SPY | ETF | 86.0 | 86.54 | 86.0 | 86.33 | 3798700.0 |
| 2003-02-05 13:00:00 | SPY | ETF | 86.29 | 86.4 | 85.82 | 85.89 | 1822300.0 |
| 2003-02-05 13:30:00 | SPY | ETF | 85.88 | 86.1 | 85.86 | 85.95 | 1539100.0 |
| 2003-02-05 14:00:00 | SPY | ETF | 85.94 | 85.99 | 84.95 | 85.31 | 5138600.0 |
| 2003-02-05 14:30:00 | SPY | ETF | 85.3 | 85.42 | 84.7 | 84.8 | 3587000.0 |
| 2003-02-05 15:00:00 | SPY | ETF | 84.75 | 84.9 | 84.48 | 84.71 | 5337700.0 |
| 2003-02-05 15:30:00 | SPY | ETF | 84.71 | 84.98 | 84.61 | 84.64 | 2918100.0 |
| 2003-02-05 16:00:00 | SPY | ETF | 84.64 | 84.92 | 84.62 | 84.8 | 3319500.0 |
| 2003-02-05 16:30:00 | SPY | ETF | 84.82 | 84.9 | 84.76 | 84.76 | 49000.0 |
| 2003-02-05 17:00:00 | SPY | ETF | 84.77 | 84.84 | 84.77 | 84.8 | 38100.0 |
| 2003-02-05 17:30:00 | SPY | ETF | 84.79 | 85.4 | 84.79 | 84.85 | 92700.0 |
| 2003-02-05 18:00:00 | SPY | ETF | 84.8 | 84.83 | 84.72 | 84.72 | 3100.0 |
| 2003-02-05 18:30:00 | SPY | ETF | 84.79 | 84.84 | 84.76 | 84.76 | 3400.0 |
| 2003-02-05 19:00:00 | SPY | ETF | 84.8 | 84.8 | 84.74 | 84.78 | 3400.0 |
| 2003-02-05 19:30:00 | SPY | ETF | 84.78 | 84.82 | 84.74 | 84.78 | 2300.0 |
| 2003-02-05 08:00:00 | QQQ | ETF | 24.2 | 24.34 | 24.2 | 24.32 | 36800.0 |
| 2003-02-05 08:30:00 | QQQ | ETF | 24.33 | 24.36 | 24.3 | 24.31 | 45400.0 |
| 2003-02-05 09:00:00 | QQQ | ETF | 24.31 | 24.41 | 24.31 | 24.35 | 48200.0 |
| 2003-02-05 09:30:00 | QQQ | ETF | 24.33 | 24.43 | 24.21 | 24.32 | 9717200.0 |
| 2003-02-05 10:00:00 | QQQ | ETF | 24.31 | 24.39 | 24.12 | 24.24 | 4560700.0 |
| 2003-02-05 10:30:00 | QQQ | ETF | 24.25 | 24.75 | 24.22 | 24.57 | 9335700.0 |
| 2003-02-05 11:00:00 | QQQ | ETF | 24.6 | 24.67 | 24.42 | 24.49 | 4423700.0 |
| 2003-02-05 11:30:00 | QQQ | ETF | 24.49 | 24.62 | 24.48 | 24.57 | 2243300.0 |
| 2003-02-05 12:00:00 | QQQ | ETF | 24.58 | 24.66 | 24.47 | 24.62 | 2279800.0 |
| 2003-02-05 12:30:00 | QQQ | ETF | 24.61 | 24.86 | 24.6 | 24.74 | 6840200.0 |
| 2003-02-05 13:00:00 | QQQ | ETF | 24.74 | 24.78 | 24.6 | 24.62 | 2407400.0 |
| 2003-02-05 13:30:00 | QQQ | ETF | 24.62 | 24.69 | 24.57 | 24.6 | 1722400.0 |
| 2003-02-05 14:00:00 | QQQ | ETF | 24.62 | 24.64 | 24.04 | 24.29 | 11157300.0 |
| 2003-02-05 14:30:00 | QQQ | ETF | 24.29 | 24.33 | 24.1 | 24.14 | 6192000.0 |
| 2003-02-05 15:00:00 | QQQ | ETF | 24.14 | 24.2 | 24.01 | 24.14 | 5352100.0 |
| 2003-02-05 15:30:00 | QQQ | ETF | 24.14 | 24.23 | 24.05 | 24.09 | 5295900.0 |
| 2003-02-05 16:00:00 | QQQ | ETF | 24.09 | 24.7 | 24.05 | 24.09 | 1425200.0 |
| 2003-02-05 16:30:00 | QQQ | ETF | 24.1 | 24.38 | 24.08 | 24.11 | 123400.0 |
| 2003-02-05 17:00:00 | QQQ | ETF | 24.11 | 24.12 | 24.08 | 24.1 | 274100.0 |
| 2003-02-05 17:30:00 | QQQ | ETF | 24.09 | 24.11 | 24.06 | 24.11 | 33900.0 |
| 2003-02-05 18:00:00 | QQQ | ETF | 24.09 | 24.09 | 24.06 | 24.08 | 34400.0 |
| 2003-02-05 18:30:00 | QQQ | ETF | 24.06 | 24.08 | 24.06 | 24.07 | 2000.0 |
| 2003-02-05 19:00:00 | QQQ | ETF | 24.08 | 24.11 | 24.08 | 24.08 | 7800.0 |
| 2003-02-05 19:30:00 | QQQ | ETF | 24.09 | 24.1 | 24.04 | 24.05 | 16800.0 |
| 2003-02-05 08:00:00 | IWM | ETF | 36.755 | 36.755 | 36.755 | 36.755 | 1000.0 |
| 2003-02-05 09:30:00 | IWM | ETF | 36.96 | 36.96 | 36.725 | 36.745 | 571400.0 |
> showing 50 of 603 rows — these rows as CSV