PREVIEW / etf_30min / 2006-01-24
file: by_date/etf_30min/2006/2006-01-24.parquet size: 59 KB rows: 2,134
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-01-24 05:30:00 | SPY | ETF | 126.49 | 126.49 | 126.49 | 126.49 | 100.0 |
| 2006-01-24 06:30:00 | SPY | ETF | 126.59 | 126.59 | 126.59 | 126.59 | 200.0 |
| 2006-01-24 07:00:00 | SPY | ETF | 126.74 | 126.8 | 126.7 | 126.8 | 3400.0 |
| 2006-01-24 07:30:00 | SPY | ETF | 126.81 | 126.81 | 126.72 | 126.73 | 18400.0 |
| 2006-01-24 08:00:00 | SPY | ETF | 126.8 | 126.8 | 126.64 | 126.64 | 549200.0 |
| 2006-01-24 08:30:00 | SPY | ETF | 126.62 | 126.72 | 126.62 | 126.72 | 33900.0 |
| 2006-01-24 09:00:00 | SPY | ETF | 126.64 | 126.74 | 126.42 | 126.62 | 1083100.0 |
| 2006-01-24 09:30:00 | SPY | ETF | 126.63 | 127.05 | 126.61 | 127.01 | 6413100.0 |
| 2006-01-24 10:00:00 | SPY | ETF | 127.01 | 127.09 | 126.73 | 126.8 | 6109100.0 |
| 2006-01-24 10:30:00 | SPY | ETF | 126.8 | 126.88 | 126.65 | 126.67 | 3028300.0 |
| 2006-01-24 11:00:00 | SPY | ETF | 126.67 | 126.67 | 126.42 | 126.67 | 7006200.0 |
| 2006-01-24 11:30:00 | SPY | ETF | 126.6501 | 126.79 | 126.59 | 126.7 | 1910200.0 |
| 2006-01-24 12:00:00 | SPY | ETF | 126.69 | 126.82 | 126.45 | 126.58 | 3355200.0 |
| 2006-01-24 12:30:00 | SPY | ETF | 126.58 | 126.8 | 126.44 | 126.66 | 2411800.0 |
| 2006-01-24 13:00:00 | SPY | ETF | 126.64 | 126.73 | 126.49 | 126.67 | 1611800.0 |
| 2006-01-24 13:30:00 | SPY | ETF | 126.67 | 126.92 | 126.57 | 126.88 | 2250800.0 |
| 2006-01-24 14:00:00 | SPY | ETF | 126.87 | 127.15 | 126.87 | 126.9401 | 5156400.0 |
| 2006-01-24 14:30:00 | SPY | ETF | 126.94 | 127.0 | 126.68 | 126.69 | 2429000.0 |
| 2006-01-24 15:00:00 | SPY | ETF | 126.69 | 126.83 | 126.59 | 126.75 | 2632200.0 |
| 2006-01-24 15:30:00 | SPY | ETF | 126.73 | 126.81 | 126.58 | 126.6 | 4732900.0 |
| 2006-01-24 16:00:00 | SPY | ETF | 126.59 | 126.765 | 126.53 | 126.53 | 1120200.0 |
| 2006-01-24 16:30:00 | SPY | ETF | 126.59 | 126.68 | 126.58 | 126.65 | 78800.0 |
| 2006-01-24 17:00:00 | SPY | ETF | 126.67 | 126.67 | 126.57 | 126.58 | 140500.0 |
| 2006-01-24 17:30:00 | SPY | ETF | 126.64 | 126.64 | 126.64 | 126.64 | 300.0 |
| 2006-01-24 18:00:00 | SPY | ETF | 126.61 | 126.67 | 126.61 | 126.67 | 5100.0 |
| 2006-01-24 19:00:00 | SPY | ETF | 126.67 | 126.67 | 126.67 | 126.67 | 100.0 |
| 2006-01-24 19:30:00 | SPY | ETF | 126.69 | 126.69 | 126.69 | 126.69 | 2400.0 |
| 2006-01-24 09:30:00 | QQQ | ETF | 41.37 | 41.7 | 41.35 | 41.66 | 15588400.0 |
| 2006-01-24 10:00:00 | QQQ | ETF | 41.66 | 41.68 | 41.48 | 41.51 | 6589900.0 |
| 2006-01-24 10:30:00 | QQQ | ETF | 41.52 | 41.55 | 41.42 | 41.45 | 5250100.0 |
| 2006-01-24 11:00:00 | QQQ | ETF | 41.45 | 41.5 | 41.31 | 41.43 | 6916500.0 |
| 2006-01-24 11:30:00 | QQQ | ETF | 41.43 | 41.49 | 41.39 | 41.45 | 5561800.0 |
| 2006-01-24 12:00:00 | QQQ | ETF | 41.45 | 41.51 | 41.36 | 41.42 | 4788800.0 |
| 2006-01-24 12:30:00 | QQQ | ETF | 41.42 | 41.47 | 41.34 | 41.41 | 3666100.0 |
| 2006-01-24 13:00:00 | QQQ | ETF | 41.4 | 41.43 | 41.34 | 41.43 | 2437600.0 |
| 2006-01-24 13:30:00 | QQQ | ETF | 41.42 | 41.5 | 41.35 | 41.48 | 2493800.0 |
| 2006-01-24 14:00:00 | QQQ | ETF | 41.48 | 41.63 | 41.47 | 41.56 | 5861500.0 |
| 2006-01-24 14:30:00 | QQQ | ETF | 41.56 | 41.59 | 41.41 | 41.41 | 3246500.0 |
| 2006-01-24 15:00:00 | QQQ | ETF | 41.42 | 41.48 | 41.39 | 41.45 | 3564200.0 |
| 2006-01-24 15:30:00 | QQQ | ETF | 41.45 | 41.5 | 41.43 | 41.44 | 4843500.0 |
| 2006-01-24 07:30:00 | IWM | ETF | 70.51 | 70.51 | 70.51 | 70.51 | 26000.0 |
| 2006-01-24 08:00:00 | IWM | ETF | 70.41 | 70.55 | 70.41 | 70.51 | 19600.0 |
| 2006-01-24 08:30:00 | IWM | ETF | 70.48 | 70.48 | 70.46 | 70.47 | 500.0 |
| 2006-01-24 09:00:00 | IWM | ETF | 70.44 | 70.52 | 70.44 | 70.47 | 84700.0 |
| 2006-01-24 09:30:00 | IWM | ETF | 70.45 | 70.94 | 70.44 | 70.89 | 4137600.0 |
| 2006-01-24 10:00:00 | IWM | ETF | 70.9 | 70.98 | 70.78 | 70.81 | 1814900.0 |
| 2006-01-24 10:30:00 | IWM | ETF | 70.8 | 70.98 | 70.77 | 70.82 | 2240400.0 |
| 2006-01-24 11:00:00 | IWM | ETF | 70.82 | 70.86 | 70.65 | 70.84 | 2328900.0 |
| 2006-01-24 11:30:00 | IWM | ETF | 70.84 | 70.93 | 70.75 | 70.88 | 1127900.0 |
| 2006-01-24 12:00:00 | IWM | ETF | 70.89 | 71.08 | 70.79 | 70.84 | 6717000.0 |
> showing 50 of 2,134 rows — these rows as CSV