PREVIEW / etf_30min / 2005-12-30
file: by_date/etf_30min/2005/2005-12-30.parquet size: 56 KB rows: 2,057
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-30 04:00:00 | SPY | ETF | 125.16 | 125.16 | 125.16 | 125.16 | 100.0 |
| 2005-12-30 04:30:00 | SPY | ETF | 125.09 | 125.09 | 125.09 | 125.09 | 500.0 |
| 2005-12-30 05:00:00 | SPY | ETF | 124.69 | 124.69 | 124.66 | 124.66 | 20200.0 |
| 2005-12-30 05:30:00 | SPY | ETF | 124.84 | 124.84 | 124.84 | 124.84 | 1000.0 |
| 2005-12-30 07:00:00 | SPY | ETF | 124.83 | 124.93 | 124.83 | 124.93 | 20400.0 |
| 2005-12-30 07:30:00 | SPY | ETF | 124.98 | 124.98 | 124.93 | 124.97 | 33000.0 |
| 2005-12-30 08:00:00 | SPY | ETF | 124.98 | 124.99 | 124.83 | 124.95 | 350200.0 |
| 2005-12-30 08:30:00 | SPY | ETF | 124.96 | 124.99 | 124.82 | 124.86 | 266900.0 |
| 2005-12-30 09:00:00 | SPY | ETF | 124.87 | 124.95 | 124.8 | 124.8 | 132600.0 |
| 2005-12-30 09:30:00 | SPY | ETF | 124.8 | 125.0 | 124.67 | 124.87 | 5777100.0 |
| 2005-12-30 10:00:00 | SPY | ETF | 124.86 | 124.88 | 124.61 | 124.71 | 3640700.0 |
| 2005-12-30 10:30:00 | SPY | ETF | 124.71 | 124.79 | 124.54 | 124.67 | 2596600.0 |
| 2005-12-30 11:00:00 | SPY | ETF | 124.65 | 124.72 | 124.56 | 124.67 | 1657200.0 |
| 2005-12-30 11:30:00 | SPY | ETF | 124.67 | 124.74 | 124.61 | 124.68 | 1065700.0 |
| 2005-12-30 12:00:00 | SPY | ETF | 124.68 | 124.68 | 124.58 | 124.66 | 1290900.0 |
| 2005-12-30 12:30:00 | SPY | ETF | 124.66 | 124.69 | 124.54 | 124.59 | 1374200.0 |
| 2005-12-30 13:00:00 | SPY | ETF | 124.59 | 124.62 | 124.5 | 124.58 | 1323700.0 |
| 2005-12-30 13:30:00 | SPY | ETF | 124.56 | 124.73 | 124.56 | 124.68 | 2601000.0 |
| 2005-12-30 14:00:00 | SPY | ETF | 124.68 | 124.91 | 124.67 | 124.72 | 2643800.0 |
| 2005-12-30 14:30:00 | SPY | ETF | 124.715 | 124.88 | 124.64 | 124.81 | 3218700.0 |
| 2005-12-30 15:00:00 | SPY | ETF | 124.815 | 124.91 | 124.66 | 124.84 | 4103000.0 |
| 2005-12-30 15:30:00 | SPY | ETF | 124.845 | 125.06 | 124.55 | 124.56 | 6876100.0 |
| 2005-12-30 16:00:00 | SPY | ETF | 124.55 | 124.98 | 124.37 | 124.5 | 3913300.0 |
| 2005-12-30 16:30:00 | SPY | ETF | 124.5 | 124.52 | 124.42 | 124.42 | 30000.0 |
| 2005-12-30 17:00:00 | SPY | ETF | 124.46 | 124.5 | 124.45 | 124.48 | 7600.0 |
| 2005-12-30 17:30:00 | SPY | ETF | 124.52 | 124.52 | 124.48 | 124.52 | 1700.0 |
| 2005-12-30 18:00:00 | SPY | ETF | 124.52 | 124.52 | 124.52 | 124.52 | 500.0 |
| 2005-12-30 19:00:00 | SPY | ETF | 124.52 | 124.52 | 124.52 | 124.52 | 400.0 |
| 2005-12-30 09:30:00 | QQQ | ETF | 40.54 | 40.57 | 40.5 | 40.54 | 9072800.0 |
| 2005-12-30 10:00:00 | QQQ | ETF | 40.55 | 40.55 | 40.39 | 40.43 | 6210900.0 |
| 2005-12-30 10:30:00 | QQQ | ETF | 40.43 | 40.51 | 40.36 | 40.41 | 4785700.0 |
| 2005-12-30 11:00:00 | QQQ | ETF | 40.42 | 40.49 | 40.39 | 40.48 | 3423700.0 |
| 2005-12-30 11:30:00 | QQQ | ETF | 40.48 | 40.5 | 40.46 | 40.47 | 1938300.0 |
| 2005-12-30 12:00:00 | QQQ | ETF | 40.48 | 40.5 | 40.45 | 40.46 | 1947100.0 |
| 2005-12-30 12:30:00 | QQQ | ETF | 40.47 | 40.49 | 40.41 | 40.43 | 2517500.0 |
| 2005-12-30 13:00:00 | QQQ | ETF | 40.43 | 40.46 | 40.41 | 40.44 | 2164000.0 |
| 2005-12-30 13:30:00 | QQQ | ETF | 40.45 | 40.57 | 40.44 | 40.53 | 5113200.0 |
| 2005-12-30 14:00:00 | QQQ | ETF | 40.53 | 40.58 | 40.5 | 40.5 | 2659400.0 |
| 2005-12-30 14:30:00 | QQQ | ETF | 40.5 | 40.55 | 40.46 | 40.53 | 2970400.0 |
| 2005-12-30 15:00:00 | QQQ | ETF | 40.54 | 40.54 | 40.44 | 40.51 | 4005800.0 |
| 2005-12-30 15:30:00 | QQQ | ETF | 40.51 | 40.57 | 40.41 | 40.42 | 9631400.0 |
| 2005-12-30 07:00:00 | IWM | ETF | 66.99 | 66.99 | 66.99 | 66.99 | 500.0 |
| 2005-12-30 08:00:00 | IWM | ETF | 67.02 | 67.02 | 66.97 | 66.97 | 20700.0 |
| 2005-12-30 08:30:00 | IWM | ETF | 66.95 | 66.95 | 66.79 | 66.82 | 23300.0 |
| 2005-12-30 09:00:00 | IWM | ETF | 66.79 | 66.85 | 66.77 | 66.78 | 74600.0 |
| 2005-12-30 09:30:00 | IWM | ETF | 66.76 | 66.78 | 66.46 | 66.76 | 3981600.0 |
| 2005-12-30 10:00:00 | IWM | ETF | 66.75 | 66.76 | 66.6 | 66.66 | 2121700.0 |
| 2005-12-30 10:30:00 | IWM | ETF | 66.67 | 66.72 | 66.54 | 66.61 | 1790900.0 |
| 2005-12-30 11:00:00 | IWM | ETF | 66.6 | 66.78 | 66.59 | 66.67 | 1353600.0 |
| 2005-12-30 11:30:00 | IWM | ETF | 66.68 | 66.75 | 66.67 | 66.71 | 735300.0 |
> showing 50 of 2,057 rows — these rows as CSV