PREVIEW / etf_30min / 2002-12-24
file: by_date/etf_30min/2002/2002-12-24.parquet size: 14 KB rows: 344
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 |
|---|---|---|---|---|---|---|---|
| 2002-12-24 08:00:00 | SPY | ETF | 90.2 | 90.25 | 90.2 | 90.25 | 500.0 |
| 2002-12-24 08:30:00 | SPY | ETF | 90.2 | 90.2 | 89.6 | 89.67 | 61900.0 |
| 2002-12-24 09:00:00 | SPY | ETF | 89.7 | 89.77 | 89.59 | 89.59 | 9600.0 |
| 2002-12-24 09:30:00 | SPY | ETF | 89.59 | 89.86 | 89.54 | 89.69 | 2381100.0 |
| 2002-12-24 10:00:00 | SPY | ETF | 89.71 | 89.86 | 89.59 | 89.63 | 1441300.0 |
| 2002-12-24 10:30:00 | SPY | ETF | 89.61 | 89.65 | 89.41 | 89.5 | 1268600.0 |
| 2002-12-24 11:00:00 | SPY | ETF | 89.42 | 89.64 | 89.4 | 89.61 | 645700.0 |
| 2002-12-24 11:30:00 | SPY | ETF | 89.63 | 89.65 | 89.52 | 89.6 | 478400.0 |
| 2002-12-24 12:00:00 | SPY | ETF | 89.61 | 89.8 | 89.58 | 89.71 | 682800.0 |
| 2002-12-24 12:30:00 | SPY | ETF | 89.69 | 89.69 | 89.36 | 89.45 | 1271900.0 |
| 2002-12-24 13:00:00 | SPY | ETF | 89.44 | 89.53 | 89.25 | 89.36 | 1734300.0 |
| 2002-12-24 13:30:00 | SPY | ETF | 89.35 | 89.35 | 89.35 | 89.35 | 100.0 |
| 2002-12-24 08:00:00 | QQQ | ETF | 25.64 | 25.72 | 25.64 | 25.72 | 5900.0 |
| 2002-12-24 08:30:00 | QQQ | ETF | 25.71 | 25.71 | 25.46 | 25.5 | 33600.0 |
| 2002-12-24 09:00:00 | QQQ | ETF | 25.52 | 25.54 | 25.5 | 25.52 | 39400.0 |
| 2002-12-24 09:30:00 | QQQ | ETF | 25.5 | 25.72 | 25.48 | 25.66 | 2771300.0 |
| 2002-12-24 10:00:00 | QQQ | ETF | 25.66 | 25.73 | 25.55 | 25.56 | 2169700.0 |
| 2002-12-24 10:30:00 | QQQ | ETF | 25.56 | 25.63 | 25.51 | 25.57 | 1930500.0 |
| 2002-12-24 11:00:00 | QQQ | ETF | 25.57 | 25.63 | 25.55 | 25.59 | 1097300.0 |
| 2002-12-24 11:30:00 | QQQ | ETF | 25.6 | 25.63 | 25.54 | 25.56 | 1274100.0 |
| 2002-12-24 12:00:00 | QQQ | ETF | 25.57 | 25.6 | 25.54 | 25.57 | 1449000.0 |
| 2002-12-24 12:30:00 | QQQ | ETF | 25.57 | 25.57 | 25.42 | 25.44 | 3504500.0 |
| 2002-12-24 13:00:00 | QQQ | ETF | 25.43 | 25.45 | 25.32 | 25.41 | 732700.0 |
| 2002-12-24 13:30:00 | QQQ | ETF | 25.4 | 25.4 | 25.35 | 25.38 | 2200.0 |
| 2002-12-24 14:00:00 | QQQ | ETF | 25.38 | 25.38 | 25.35 | 25.35 | 3000.0 |
| 2002-12-24 09:30:00 | IWM | ETF | 38.665 | 38.825 | 38.65 | 38.725 | 74600.0 |
| 2002-12-24 10:00:00 | IWM | ETF | 38.75 | 38.85 | 38.705 | 38.75 | 70200.0 |
| 2002-12-24 10:30:00 | IWM | ETF | 38.78 | 38.78 | 38.7 | 38.7 | 22800.0 |
| 2002-12-24 11:00:00 | IWM | ETF | 38.7 | 38.74 | 38.68 | 38.725 | 36800.0 |
| 2002-12-24 11:30:00 | IWM | ETF | 38.72 | 38.725 | 38.7 | 38.725 | 20400.0 |
| 2002-12-24 12:00:00 | IWM | ETF | 38.625 | 38.745 | 38.625 | 38.73 | 18800.0 |
| 2002-12-24 12:30:00 | IWM | ETF | 38.7 | 38.705 | 38.54 | 38.575 | 181800.0 |
| 2002-12-24 13:00:00 | IWM | ETF | 38.565 | 38.7 | 38.54 | 38.7 | 81000.0 |
| 2002-12-24 08:30:00 | DIA | ETF | 84.7 | 84.75 | 84.7 | 84.72 | 7300.0 |
| 2002-12-24 09:00:00 | DIA | ETF | 84.84 | 84.84 | 84.82 | 84.82 | 700.0 |
| 2002-12-24 09:30:00 | DIA | ETF | 84.68 | 84.97 | 84.67 | 84.8 | 291000.0 |
| 2002-12-24 10:00:00 | DIA | ETF | 84.78 | 84.99 | 84.72 | 84.77 | 159500.0 |
| 2002-12-24 10:30:00 | DIA | ETF | 84.77 | 84.77 | 84.54 | 84.57 | 214400.0 |
| 2002-12-24 11:00:00 | DIA | ETF | 84.57 | 84.72 | 84.51 | 84.64 | 125800.0 |
| 2002-12-24 11:30:00 | DIA | ETF | 84.67 | 84.72 | 84.6 | 84.7 | 128100.0 |
| 2002-12-24 12:00:00 | DIA | ETF | 84.7 | 84.86 | 84.64 | 84.81 | 128500.0 |
| 2002-12-24 12:30:00 | DIA | ETF | 84.81 | 84.81 | 84.5 | 84.58 | 193500.0 |
| 2002-12-24 13:00:00 | DIA | ETF | 84.55 | 84.63 | 84.49 | 84.63 | 50700.0 |
| 2002-12-24 09:30:00 | TLT | ETF | 88.0 | 88.08 | 87.9 | 87.9 | 19500.0 |
| 2002-12-24 10:00:00 | TLT | ETF | 87.91 | 87.96 | 87.91 | 87.96 | 15100.0 |
| 2002-12-24 10:30:00 | TLT | ETF | 87.96 | 87.99 | 87.92 | 87.99 | 8000.0 |
| 2002-12-24 11:30:00 | TLT | ETF | 87.98 | 87.98 | 87.98 | 87.98 | 100.0 |
| 2002-12-24 12:00:00 | TLT | ETF | 87.94 | 87.94 | 87.94 | 87.94 | 100.0 |
| 2002-12-24 12:30:00 | TLT | ETF | 87.85 | 87.91 | 87.84 | 87.91 | 2300.0 |
| 2002-12-24 13:00:00 | TLT | ETF | 87.89 | 87.89 | 87.89 | 87.89 | 1500.0 |
> showing 50 of 344 rows — these rows as CSV