PREVIEW / etf_30min / 2006-04-24
file: by_date/etf_30min/2006/2006-04-24.parquet size: 60 KB rows: 2,179
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 |
|---|---|---|---|---|---|---|---|
| 2006-04-24 06:30:00 | SPY | ETF | 130.92 | 130.94 | 130.89 | 130.89 | 189500.0 |
| 2006-04-24 07:00:00 | SPY | ETF | 130.86 | 130.92 | 130.85 | 130.88 | 19200.0 |
| 2006-04-24 07:30:00 | SPY | ETF | 130.91 | 130.95 | 130.91 | 130.95 | 27300.0 |
| 2006-04-24 08:00:00 | SPY | ETF | 130.94 | 131.01 | 130.85 | 130.97 | 480300.0 |
| 2006-04-24 08:30:00 | SPY | ETF | 130.99 | 130.99 | 130.8 | 130.95 | 315400.0 |
| 2006-04-24 09:00:00 | SPY | ETF | 130.97 | 130.99 | 130.91 | 130.95 | 204800.0 |
| 2006-04-24 09:30:00 | SPY | ETF | 130.93 | 130.95 | 130.44 | 130.47 | 9667400.0 |
| 2006-04-24 10:00:00 | SPY | ETF | 130.48 | 130.74 | 130.42 | 130.62 | 7367200.0 |
| 2006-04-24 10:30:00 | SPY | ETF | 130.62 | 130.9 | 130.61 | 130.69 | 5075400.0 |
| 2006-04-24 11:00:00 | SPY | ETF | 130.69 | 130.74 | 130.38 | 130.5 | 5397600.0 |
| 2006-04-24 11:30:00 | SPY | ETF | 130.5 | 130.68 | 130.48 | 130.66 | 1855400.0 |
| 2006-04-24 12:00:00 | SPY | ETF | 130.66 | 130.72 | 130.51 | 130.59 | 2497100.0 |
| 2006-04-24 12:30:00 | SPY | ETF | 130.59 | 130.95 | 130.56 | 130.87 | 2323500.0 |
| 2006-04-24 13:00:00 | SPY | ETF | 130.87 | 130.9 | 130.68 | 130.72 | 2633100.0 |
| 2006-04-24 13:30:00 | SPY | ETF | 130.73 | 130.88 | 130.61 | 130.8 | 1742800.0 |
| 2006-04-24 14:00:00 | SPY | ETF | 130.8 | 130.95 | 130.74 | 130.8 | 1967200.0 |
| 2006-04-24 14:30:00 | SPY | ETF | 130.8 | 130.86 | 130.66 | 130.72 | 2242500.0 |
| 2006-04-24 15:00:00 | SPY | ETF | 130.72 | 130.93 | 130.71 | 130.89 | 1893400.0 |
| 2006-04-24 15:30:00 | SPY | ETF | 130.89 | 131.07 | 130.82 | 130.83 | 4594600.0 |
| 2006-04-24 16:00:00 | SPY | ETF | 130.82 | 130.95 | 130.82 | 130.91 | 1104700.0 |
| 2006-04-24 16:30:00 | SPY | ETF | 130.94 | 131.0 | 130.94 | 131.0 | 18300.0 |
| 2006-04-24 17:00:00 | SPY | ETF | 130.94 | 130.97 | 130.94 | 130.95 | 3400.0 |
| 2006-04-24 17:30:00 | SPY | ETF | 130.94 | 130.94 | 130.94 | 130.94 | 600.0 |
| 2006-04-24 18:00:00 | SPY | ETF | 130.95 | 130.95 | 130.95 | 130.95 | 700.0 |
| 2006-04-24 18:30:00 | SPY | ETF | 130.95 | 130.95 | 130.92 | 130.92 | 600.0 |
| 2006-04-24 19:00:00 | SPY | ETF | 130.93 | 130.93 | 130.93 | 130.93 | 300.0 |
| 2006-04-24 19:30:00 | SPY | ETF | 130.92 | 130.92 | 130.92 | 130.92 | 400.0 |
| 2006-04-24 09:30:00 | QQQ | ETF | 41.96 | 41.96 | 41.72 | 41.75 | 13112900.0 |
| 2006-04-24 10:00:00 | QQQ | ETF | 41.75 | 41.95 | 41.72 | 41.81 | 8445500.0 |
| 2006-04-24 10:30:00 | QQQ | ETF | 41.81 | 41.91 | 41.77 | 41.8 | 7028400.0 |
| 2006-04-24 11:00:00 | QQQ | ETF | 41.8 | 41.83 | 41.72 | 41.77 | 7374000.0 |
| 2006-04-24 11:30:00 | QQQ | ETF | 41.76 | 41.87 | 41.76 | 41.86 | 2753000.0 |
| 2006-04-24 12:00:00 | QQQ | ETF | 41.87 | 41.89 | 41.83 | 41.86 | 2692400.0 |
| 2006-04-24 12:30:00 | QQQ | ETF | 41.87 | 42.05 | 41.84 | 42.01 | 5495900.0 |
| 2006-04-24 13:00:00 | QQQ | ETF | 42.01 | 42.02 | 41.92 | 41.95 | 2990800.0 |
| 2006-04-24 13:30:00 | QQQ | ETF | 41.95 | 42.01 | 41.92 | 41.96 | 2525600.0 |
| 2006-04-24 14:00:00 | QQQ | ETF | 41.96 | 42.02 | 41.94 | 41.95 | 3807400.0 |
| 2006-04-24 14:30:00 | QQQ | ETF | 41.96 | 41.98 | 41.87 | 41.9 | 3907200.0 |
| 2006-04-24 15:00:00 | QQQ | ETF | 41.9 | 42.01 | 41.9 | 42.0 | 2743800.0 |
| 2006-04-24 15:30:00 | QQQ | ETF | 42.0 | 42.07 | 41.95 | 41.96 | 7186700.0 |
| 2006-04-24 08:00:00 | IWM | ETF | 76.69 | 76.69 | 76.64 | 76.64 | 1000.0 |
| 2006-04-24 08:30:00 | IWM | ETF | 76.61 | 76.61 | 76.57 | 76.59 | 3300.0 |
| 2006-04-24 09:00:00 | IWM | ETF | 76.59 | 76.6 | 76.55 | 76.56 | 43800.0 |
| 2006-04-24 09:30:00 | IWM | ETF | 76.54 | 76.7 | 75.93 | 75.98 | 7326400.0 |
| 2006-04-24 10:00:00 | IWM | ETF | 75.98 | 76.2 | 75.91 | 76.04 | 4186400.0 |
| 2006-04-24 10:30:00 | IWM | ETF | 76.03 | 76.18 | 75.79 | 75.85 | 3722400.0 |
| 2006-04-24 11:00:00 | IWM | ETF | 75.85 | 75.9 | 75.73 | 75.79 | 4200000.0 |
| 2006-04-24 11:30:00 | IWM | ETF | 75.79 | 76.08 | 75.77 | 76.07 | 1415700.0 |
| 2006-04-24 12:00:00 | IWM | ETF | 76.06 | 76.12 | 76.02 | 76.06 | 1280500.0 |
| 2006-04-24 12:30:00 | IWM | ETF | 76.06 | 76.13 | 76.04 | 76.08 | 1995200.0 |
> showing 50 of 2,179 rows — these rows as CSV