PREVIEW / etf_30min / 2005-12-07
file: by_date/etf_30min/2005/2005-12-07.parquet size: 56 KB rows: 2,013
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-07 04:30:00 | SPY | ETF | 126.85 | 126.85 | 126.85 | 126.85 | 5000.0 |
| 2005-12-07 07:00:00 | SPY | ETF | 126.87 | 126.87 | 126.87 | 126.87 | 2000.0 |
| 2005-12-07 07:30:00 | SPY | ETF | 126.82 | 126.82 | 126.75 | 126.75 | 60600.0 |
| 2005-12-07 08:00:00 | SPY | ETF | 126.75 | 126.88 | 126.7 | 126.74 | 69500.0 |
| 2005-12-07 08:30:00 | SPY | ETF | 126.72 | 126.82 | 126.71 | 126.82 | 388600.0 |
| 2005-12-07 09:00:00 | SPY | ETF | 126.82 | 126.83 | 126.76 | 126.77 | 648000.0 |
| 2005-12-07 09:30:00 | SPY | ETF | 126.79 | 126.87 | 126.48 | 126.65 | 9287700.0 |
| 2005-12-07 10:00:00 | SPY | ETF | 126.65 | 126.84 | 126.62 | 126.72 | 5474500.0 |
| 2005-12-07 10:30:00 | SPY | ETF | 126.72 | 126.85 | 126.39 | 126.4 | 5050800.0 |
| 2005-12-07 11:00:00 | SPY | ETF | 126.4 | 126.71 | 126.29 | 126.39 | 4996000.0 |
| 2005-12-07 11:30:00 | SPY | ETF | 126.3999 | 126.63 | 126.37 | 126.45 | 1551400.0 |
| 2005-12-07 12:00:00 | SPY | ETF | 126.44 | 126.52 | 126.29 | 126.5 | 2347700.0 |
| 2005-12-07 12:30:00 | SPY | ETF | 126.49 | 126.57 | 126.43 | 126.48 | 2057800.0 |
| 2005-12-07 13:00:00 | SPY | ETF | 126.49 | 126.52 | 126.06 | 126.06 | 3036300.0 |
| 2005-12-07 13:30:00 | SPY | ETF | 126.06 | 126.38 | 125.95 | 125.99 | 6667000.0 |
| 2005-12-07 14:00:00 | SPY | ETF | 125.99 | 126.03 | 125.78 | 125.86 | 9056400.0 |
| 2005-12-07 14:30:00 | SPY | ETF | 125.86 | 126.08 | 125.71 | 125.8 | 4986600.0 |
| 2005-12-07 15:00:00 | SPY | ETF | 125.8 | 125.95 | 125.68 | 125.88 | 4812600.0 |
| 2005-12-07 15:30:00 | SPY | ETF | 125.89 | 126.21 | 125.84 | 126.15 | 4182400.0 |
| 2005-12-07 16:00:00 | SPY | ETF | 126.14 | 126.19 | 126.06 | 126.07 | 476500.0 |
| 2005-12-07 16:30:00 | SPY | ETF | 126.09 | 126.19 | 126.08 | 126.17 | 33900.0 |
| 2005-12-07 17:00:00 | SPY | ETF | 126.17 | 126.17 | 126.13 | 126.13 | 84600.0 |
| 2005-12-07 17:30:00 | SPY | ETF | 126.17 | 126.17 | 126.08 | 126.15 | 6000.0 |
| 2005-12-07 18:00:00 | SPY | ETF | 126.14 | 126.15 | 126.12 | 126.15 | 7000.0 |
| 2005-12-07 18:30:00 | SPY | ETF | 126.17 | 126.18 | 126.17 | 126.17 | 3700.0 |
| 2005-12-07 19:30:00 | SPY | ETF | 126.12 | 126.12 | 126.07 | 126.08 | 3000.0 |
| 2005-12-07 09:30:00 | QQQ | ETF | 42.0 | 42.03 | 41.86 | 41.95 | 9079300.0 |
| 2005-12-07 10:00:00 | QQQ | ETF | 41.96 | 42.0 | 41.91 | 41.94 | 4771200.0 |
| 2005-12-07 10:30:00 | QQQ | ETF | 41.94 | 42.01 | 41.81 | 41.82 | 7558800.0 |
| 2005-12-07 11:00:00 | QQQ | ETF | 41.81 | 41.86 | 41.77 | 41.8 | 7012400.0 |
| 2005-12-07 11:30:00 | QQQ | ETF | 41.8 | 41.9 | 41.79 | 41.83 | 5220900.0 |
| 2005-12-07 12:00:00 | QQQ | ETF | 41.83 | 41.88 | 41.8 | 41.86 | 2197200.0 |
| 2005-12-07 12:30:00 | QQQ | ETF | 41.86 | 41.91 | 41.84 | 41.88 | 3462900.0 |
| 2005-12-07 13:00:00 | QQQ | ETF | 41.88 | 41.88 | 41.76 | 41.77 | 3449400.0 |
| 2005-12-07 13:30:00 | QQQ | ETF | 41.78 | 41.82 | 41.69 | 41.7 | 5922500.0 |
| 2005-12-07 14:00:00 | QQQ | ETF | 41.7 | 41.75 | 41.63 | 41.68 | 6208600.0 |
| 2005-12-07 14:30:00 | QQQ | ETF | 41.68 | 41.77 | 41.63 | 41.71 | 4826100.0 |
| 2005-12-07 15:00:00 | QQQ | ETF | 41.7 | 41.79 | 41.66 | 41.75 | 5962700.0 |
| 2005-12-07 15:30:00 | QQQ | ETF | 41.75 | 41.86 | 41.72 | 41.85 | 6767000.0 |
| 2005-12-07 07:30:00 | IWM | ETF | 68.48 | 68.48 | 68.45 | 68.45 | 1500.0 |
| 2005-12-07 08:00:00 | IWM | ETF | 68.45 | 68.51 | 68.35 | 68.38 | 146900.0 |
| 2005-12-07 08:30:00 | IWM | ETF | 68.4 | 68.42 | 68.39 | 68.42 | 231000.0 |
| 2005-12-07 09:30:00 | IWM | ETF | 68.42 | 68.57 | 68.13 | 68.36 | 2647200.0 |
| 2005-12-07 10:00:00 | IWM | ETF | 68.35 | 68.49 | 68.28 | 68.44 | 1342400.0 |
| 2005-12-07 10:30:00 | IWM | ETF | 68.44 | 68.51 | 68.06 | 68.07 | 2958500.0 |
| 2005-12-07 11:00:00 | IWM | ETF | 68.07 | 68.15 | 67.96 | 68.09 | 2366700.0 |
| 2005-12-07 11:30:00 | IWM | ETF | 68.09 | 68.25 | 68.08 | 68.15 | 1784500.0 |
| 2005-12-07 12:00:00 | IWM | ETF | 68.15 | 68.24 | 68.04 | 68.23 | 993900.0 |
| 2005-12-07 12:30:00 | IWM | ETF | 68.23 | 68.35 | 68.15 | 68.25 | 647500.0 |
| 2005-12-07 13:00:00 | IWM | ETF | 68.25 | 68.32 | 67.95 | 67.95 | 739700.0 |
> showing 50 of 2,013 rows — these rows as CSV