PREVIEW / etf_30min / 2005-12-12
file: by_date/etf_30min/2005/2005-12-12.parquet size: 56 KB rows: 2,027
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-12 04:00:00 | SPY | ETF | 126.86 | 126.86 | 126.86 | 126.86 | 200.0 |
| 2005-12-12 05:00:00 | SPY | ETF | 126.84 | 126.84 | 126.84 | 126.84 | 200.0 |
| 2005-12-12 06:00:00 | SPY | ETF | 126.84 | 126.86 | 126.84 | 126.86 | 25000.0 |
| 2005-12-12 06:30:00 | SPY | ETF | 126.85 | 126.85 | 126.84 | 126.84 | 25000.0 |
| 2005-12-12 07:00:00 | SPY | ETF | 126.79 | 126.84 | 126.78 | 126.84 | 6900.0 |
| 2005-12-12 07:30:00 | SPY | ETF | 126.82 | 126.82 | 126.74 | 126.74 | 65000.0 |
| 2005-12-12 08:00:00 | SPY | ETF | 126.74 | 126.85 | 126.59 | 126.71 | 321500.0 |
| 2005-12-12 08:30:00 | SPY | ETF | 126.72 | 126.75 | 126.66 | 126.74 | 222800.0 |
| 2005-12-12 09:00:00 | SPY | ETF | 126.74 | 126.79 | 126.69 | 126.77 | 153500.0 |
| 2005-12-12 09:30:00 | SPY | ETF | 126.71 | 126.86 | 126.64 | 126.68 | 4929100.0 |
| 2005-12-12 10:00:00 | SPY | ETF | 126.69 | 126.83 | 126.56 | 126.78 | 4587000.0 |
| 2005-12-12 10:30:00 | SPY | ETF | 126.78 | 126.81 | 126.5 | 126.71 | 4535800.0 |
| 2005-12-12 11:00:00 | SPY | ETF | 126.72 | 126.78 | 126.55 | 126.57 | 3412800.0 |
| 2005-12-12 11:30:00 | SPY | ETF | 126.56 | 126.65 | 126.48 | 126.51 | 2482600.0 |
| 2005-12-12 12:00:00 | SPY | ETF | 126.51 | 126.58 | 126.32 | 126.33 | 4350400.0 |
| 2005-12-12 12:30:00 | SPY | ETF | 126.32 | 126.34 | 126.09 | 126.22 | 4355300.0 |
| 2005-12-12 13:00:00 | SPY | ETF | 126.22 | 126.22 | 125.98 | 126.11 | 3722800.0 |
| 2005-12-12 13:30:00 | SPY | ETF | 126.1 | 126.17 | 125.96 | 126.12 | 2683600.0 |
| 2005-12-12 14:00:00 | SPY | ETF | 126.13 | 126.25 | 126.07 | 126.22 | 2713800.0 |
| 2005-12-12 14:30:00 | SPY | ETF | 126.21 | 126.43 | 126.15 | 126.34 | 2304600.0 |
| 2005-12-12 15:00:00 | SPY | ETF | 126.34 | 126.59 | 126.3 | 126.48 | 2595500.0 |
| 2005-12-12 15:30:00 | SPY | ETF | 126.47 | 126.57 | 126.4 | 126.48 | 3052000.0 |
| 2005-12-12 16:00:00 | SPY | ETF | 126.47 | 126.56 | 126.39 | 126.56 | 648600.0 |
| 2005-12-12 16:30:00 | SPY | ETF | 126.56 | 126.58 | 126.47 | 126.54 | 74000.0 |
| 2005-12-12 17:00:00 | SPY | ETF | 126.51 | 126.54 | 126.5 | 126.53 | 132400.0 |
| 2005-12-12 17:30:00 | SPY | ETF | 126.51 | 126.52 | 126.51 | 126.52 | 900.0 |
| 2005-12-12 18:00:00 | SPY | ETF | 126.47 | 126.48 | 126.43 | 126.48 | 3500.0 |
| 2005-12-12 19:00:00 | SPY | ETF | 126.47 | 126.47 | 126.47 | 126.47 | 200.0 |
| 2005-12-12 19:30:00 | SPY | ETF | 126.47 | 126.49 | 126.47 | 126.49 | 200.0 |
| 2005-12-12 09:30:00 | QQQ | ETF | 41.87 | 41.92 | 41.83 | 41.85 | 6694200.0 |
| 2005-12-12 10:00:00 | QQQ | ETF | 41.85 | 41.91 | 41.79 | 41.9 | 5407700.0 |
| 2005-12-12 10:30:00 | QQQ | ETF | 41.89 | 41.93 | 41.83 | 41.91 | 2948300.0 |
| 2005-12-12 11:00:00 | QQQ | ETF | 41.92 | 41.94 | 41.87 | 41.87 | 2908900.0 |
| 2005-12-12 11:30:00 | QQQ | ETF | 41.88 | 41.92 | 41.87 | 41.89 | 1105900.0 |
| 2005-12-12 12:00:00 | QQQ | ETF | 41.89 | 41.9 | 41.81 | 41.82 | 2849100.0 |
| 2005-12-12 12:30:00 | QQQ | ETF | 41.82 | 41.83 | 41.73 | 41.78 | 4755500.0 |
| 2005-12-12 13:00:00 | QQQ | ETF | 41.77 | 41.78 | 41.68 | 41.75 | 2572800.0 |
| 2005-12-12 13:30:00 | QQQ | ETF | 41.75 | 41.78 | 41.69 | 41.78 | 1950200.0 |
| 2005-12-12 14:00:00 | QQQ | ETF | 41.78 | 41.82 | 41.76 | 41.81 | 2596000.0 |
| 2005-12-12 14:30:00 | QQQ | ETF | 41.81 | 41.87 | 41.78 | 41.84 | 2401200.0 |
| 2005-12-12 15:00:00 | QQQ | ETF | 41.84 | 41.89 | 41.83 | 41.86 | 2577500.0 |
| 2005-12-12 15:30:00 | QQQ | ETF | 41.86 | 41.89 | 41.84 | 41.87 | 3967400.0 |
| 2005-12-12 08:00:00 | IWM | ETF | 68.82 | 68.84 | 68.82 | 68.84 | 500.0 |
| 2005-12-12 08:30:00 | IWM | ETF | 68.84 | 68.84 | 68.83 | 68.84 | 4500.0 |
| 2005-12-12 09:00:00 | IWM | ETF | 68.84 | 68.86 | 68.79 | 68.84 | 106600.0 |
| 2005-12-12 09:30:00 | IWM | ETF | 68.82 | 68.97 | 68.7 | 68.75 | 2818800.0 |
| 2005-12-12 10:00:00 | IWM | ETF | 68.75 | 68.89 | 68.6 | 68.87 | 1991400.0 |
| 2005-12-12 10:30:00 | IWM | ETF | 68.88 | 68.92 | 68.62 | 68.77 | 2307000.0 |
| 2005-12-12 11:00:00 | IWM | ETF | 68.78 | 68.93 | 68.74 | 68.79 | 1438800.0 |
| 2005-12-12 11:30:00 | IWM | ETF | 68.78 | 68.82 | 68.73 | 68.75 | 542300.0 |
> showing 50 of 2,027 rows — these rows as CSV