PREVIEW / etf_30min / 2005-12-23
file: by_date/etf_30min/2005/2005-12-23.parquet size: 52 KB rows: 1,981
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 |
|---|---|---|---|---|---|---|---|
| 2005-12-23 06:30:00 | SPY | ETF | 126.63 | 126.63 | 126.63 | 126.63 | 400.0 |
| 2005-12-23 07:00:00 | SPY | ETF | 126.65 | 126.66 | 126.65 | 126.66 | 20100.0 |
| 2005-12-23 07:30:00 | SPY | ETF | 126.68 | 126.68 | 126.68 | 126.68 | 1400.0 |
| 2005-12-23 08:00:00 | SPY | ETF | 126.7 | 126.71 | 126.62 | 126.68 | 177100.0 |
| 2005-12-23 08:30:00 | SPY | ETF | 126.68 | 126.72 | 126.65 | 126.71 | 471800.0 |
| 2005-12-23 09:00:00 | SPY | ETF | 126.7 | 126.79 | 126.7 | 126.79 | 405600.0 |
| 2005-12-23 09:30:00 | SPY | ETF | 126.79 | 126.86 | 126.6 | 126.74 | 3694200.0 |
| 2005-12-23 10:00:00 | SPY | ETF | 126.75 | 126.79 | 126.62 | 126.67 | 2353700.0 |
| 2005-12-23 10:30:00 | SPY | ETF | 126.66 | 126.66 | 126.42 | 126.47 | 2850300.0 |
| 2005-12-23 11:00:00 | SPY | ETF | 126.46 | 126.61 | 126.45 | 126.57 | 1964100.0 |
| 2005-12-23 11:30:00 | SPY | ETF | 126.57 | 126.72 | 126.54 | 126.68 | 6197100.0 |
| 2005-12-23 12:00:00 | SPY | ETF | 126.7 | 126.72 | 126.58 | 126.62 | 1347900.0 |
| 2005-12-23 12:30:00 | SPY | ETF | 126.63 | 126.75 | 126.61 | 126.74 | 978600.0 |
| 2005-12-23 13:00:00 | SPY | ETF | 126.75 | 126.77 | 126.67 | 126.6899 | 1077600.0 |
| 2005-12-23 13:30:00 | SPY | ETF | 126.6899 | 126.76 | 126.67 | 126.71 | 938900.0 |
| 2005-12-23 14:00:00 | SPY | ETF | 126.74 | 126.74 | 126.57 | 126.66 | 1054600.0 |
| 2005-12-23 14:30:00 | SPY | ETF | 126.65 | 126.75 | 126.61 | 126.74 | 667800.0 |
| 2005-12-23 15:00:00 | SPY | ETF | 126.73 | 126.82 | 126.65 | 126.67 | 1135300.0 |
| 2005-12-23 15:30:00 | SPY | ETF | 126.67 | 126.78 | 126.64 | 126.75 | 1624100.0 |
| 2005-12-23 16:00:00 | SPY | ETF | 126.77 | 126.8 | 126.66 | 126.66 | 184300.0 |
| 2005-12-23 16:30:00 | SPY | ETF | 126.68 | 126.68 | 126.66 | 126.66 | 2100.0 |
| 2005-12-23 17:00:00 | SPY | ETF | 126.71 | 126.75 | 126.67 | 126.67 | 1300.0 |
| 2005-12-23 17:30:00 | SPY | ETF | 126.67 | 126.67 | 126.67 | 126.67 | 500.0 |
| 2005-12-23 09:30:00 | QQQ | ETF | 41.51 | 41.59 | 41.46 | 41.55 | 8199800.0 |
| 2005-12-23 10:00:00 | QQQ | ETF | 41.55 | 41.56 | 41.49 | 41.5 | 3184000.0 |
| 2005-12-23 10:30:00 | QQQ | ETF | 41.49 | 41.5 | 41.32 | 41.34 | 5520300.0 |
| 2005-12-23 11:00:00 | QQQ | ETF | 41.33 | 41.4 | 41.33 | 41.38 | 1654600.0 |
| 2005-12-23 11:30:00 | QQQ | ETF | 41.38 | 41.44 | 41.36 | 41.43 | 1787100.0 |
| 2005-12-23 12:00:00 | QQQ | ETF | 41.43 | 41.43 | 41.33 | 41.35 | 2469800.0 |
| 2005-12-23 12:30:00 | QQQ | ETF | 41.35 | 41.4 | 41.35 | 41.39 | 1233700.0 |
| 2005-12-23 13:00:00 | QQQ | ETF | 41.39 | 41.4 | 41.36 | 41.37 | 1445400.0 |
| 2005-12-23 13:30:00 | QQQ | ETF | 41.37 | 41.41 | 41.36 | 41.38 | 1107000.0 |
| 2005-12-23 14:00:00 | QQQ | ETF | 41.38 | 41.38 | 41.3 | 41.33 | 1506700.0 |
| 2005-12-23 14:30:00 | QQQ | ETF | 41.33 | 41.38 | 41.32 | 41.37 | 957200.0 |
| 2005-12-23 15:00:00 | QQQ | ETF | 41.37 | 41.39 | 41.34 | 41.35 | 1085500.0 |
| 2005-12-23 15:30:00 | QQQ | ETF | 41.35 | 41.41 | 41.34 | 41.41 | 3224900.0 |
| 2005-12-23 08:00:00 | IWM | ETF | 67.98 | 68.07 | 67.98 | 68.07 | 300.0 |
| 2005-12-23 08:30:00 | IWM | ETF | 68.03 | 68.03 | 68.01 | 68.01 | 7200.0 |
| 2005-12-23 09:00:00 | IWM | ETF | 68.06 | 68.07 | 68.03 | 68.07 | 51900.0 |
| 2005-12-23 09:30:00 | IWM | ETF | 68.1 | 68.27 | 68.07 | 68.2 | 3625900.0 |
| 2005-12-23 10:00:00 | IWM | ETF | 68.19 | 68.2 | 67.99 | 68.03 | 1977200.0 |
| 2005-12-23 10:30:00 | IWM | ETF | 68.02 | 68.11 | 67.96 | 68.0 | 952800.0 |
| 2005-12-23 11:00:00 | IWM | ETF | 68.01 | 68.14 | 68.01 | 68.0815 | 560400.0 |
| 2005-12-23 11:30:00 | IWM | ETF | 68.09 | 68.15 | 68.03 | 68.14 | 1079800.0 |
| 2005-12-23 12:00:00 | IWM | ETF | 68.13 | 68.14 | 68.03 | 68.06 | 1022700.0 |
| 2005-12-23 12:30:00 | IWM | ETF | 68.07 | 68.17 | 68.06 | 68.16 | 893300.0 |
| 2005-12-23 13:00:00 | IWM | ETF | 68.17 | 68.2 | 68.09 | 68.1 | 333300.0 |
| 2005-12-23 13:30:00 | IWM | ETF | 68.1 | 68.2 | 68.1 | 68.14 | 843600.0 |
| 2005-12-23 14:00:00 | IWM | ETF | 68.14 | 68.16 | 68.03 | 68.09 | 547400.0 |
| 2005-12-23 14:30:00 | IWM | ETF | 68.09 | 68.1 | 68.03 | 68.08 | 639000.0 |
> showing 50 of 1,981 rows — these rows as CSV