PREVIEW / etf_30min / 2005-01-24
file: by_date/etf_30min/2005/2005-01-24.parquet size: 42 KB rows: 1,455
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-01-24 08:00:00 | SPY | ETF | 116.91 | 117.02 | 116.91 | 116.94 | 196400.0 |
| 2005-01-24 08:30:00 | SPY | ETF | 116.96 | 117.06 | 116.96 | 117.04 | 191700.0 |
| 2005-01-24 09:00:00 | SPY | ETF | 117.04 | 117.14 | 117.04 | 117.08 | 345300.0 |
| 2005-01-24 09:30:00 | SPY | ETF | 117.09 | 117.28 | 116.8 | 116.84 | 8210600.0 |
| 2005-01-24 10:00:00 | SPY | ETF | 116.84 | 117.15 | 116.75 | 116.86 | 7954500.0 |
| 2005-01-24 10:30:00 | SPY | ETF | 116.87 | 117.23 | 116.74 | 116.87 | 6975100.0 |
| 2005-01-24 11:00:00 | SPY | ETF | 116.87 | 117.2 | 116.71 | 117.06 | 4860200.0 |
| 2005-01-24 11:30:00 | SPY | ETF | 117.09 | 117.25 | 116.95 | 117.03 | 3013900.0 |
| 2005-01-24 12:00:00 | SPY | ETF | 117.03 | 117.23 | 116.86 | 116.91 | 2225200.0 |
| 2005-01-24 12:30:00 | SPY | ETF | 116.91 | 117.13 | 116.79 | 117.03 | 2095900.0 |
| 2005-01-24 13:00:00 | SPY | ETF | 117.03 | 117.34 | 117.03 | 117.28 | 2347500.0 |
| 2005-01-24 13:30:00 | SPY | ETF | 117.28 | 117.3 | 116.95 | 116.98 | 1578300.0 |
| 2005-01-24 14:00:00 | SPY | ETF | 116.96 | 117.16 | 116.83 | 116.87 | 2504500.0 |
| 2005-01-24 14:30:00 | SPY | ETF | 116.88 | 116.96 | 116.62 | 116.69 | 4023500.0 |
| 2005-01-24 15:00:00 | SPY | ETF | 116.69 | 116.89 | 116.63 | 116.78 | 3858800.0 |
| 2005-01-24 15:30:00 | SPY | ETF | 116.78 | 116.85 | 116.37 | 116.42 | 6234400.0 |
| 2005-01-24 16:00:00 | SPY | ETF | 116.44 | 116.61 | 116.37 | 116.58 | 526700.0 |
| 2005-01-24 16:30:00 | SPY | ETF | 116.54 | 116.62 | 116.37 | 116.61 | 259600.0 |
| 2005-01-24 17:00:00 | SPY | ETF | 116.61 | 116.61 | 116.55 | 116.55 | 107500.0 |
| 2005-01-24 17:30:00 | SPY | ETF | 116.6 | 116.6 | 116.55 | 116.55 | 1900.0 |
| 2005-01-24 18:00:00 | SPY | ETF | 116.55 | 116.64 | 116.55 | 116.62 | 4500.0 |
| 2005-01-24 18:30:00 | SPY | ETF | 116.65 | 116.69 | 116.65 | 116.68 | 5000.0 |
| 2005-01-24 19:00:00 | SPY | ETF | 116.68 | 116.68 | 116.67 | 116.67 | 2200.0 |
| 2005-01-24 19:30:00 | SPY | ETF | 116.69 | 116.7 | 116.66 | 116.66 | 600.0 |
| 2005-01-24 09:30:00 | QQQ | ETF | 37.15 | 37.2 | 36.93 | 36.97 | 18273700.0 |
| 2005-01-24 10:00:00 | QQQ | ETF | 36.97 | 37.11 | 36.87 | 36.97 | 14134000.0 |
| 2005-01-24 10:30:00 | QQQ | ETF | 36.98 | 37.09 | 36.86 | 36.93 | 11116400.0 |
| 2005-01-24 11:00:00 | QQQ | ETF | 36.93 | 37.01 | 36.79 | 36.94 | 9654700.0 |
| 2005-01-24 11:30:00 | QQQ | ETF | 36.93 | 37.0 | 36.84 | 36.92 | 5262800.0 |
| 2005-01-24 12:00:00 | QQQ | ETF | 36.92 | 37.0 | 36.84 | 36.85 | 5632000.0 |
| 2005-01-24 12:30:00 | QQQ | ETF | 36.85 | 36.88 | 36.73 | 36.82 | 7041700.0 |
| 2005-01-24 13:00:00 | QQQ | ETF | 36.82 | 36.99 | 36.82 | 36.96 | 5945000.0 |
| 2005-01-24 13:30:00 | QQQ | ETF | 36.96 | 36.96 | 36.8 | 36.82 | 4454600.0 |
| 2005-01-24 14:00:00 | QQQ | ETF | 36.82 | 36.93 | 36.76 | 36.78 | 5649800.0 |
| 2005-01-24 14:30:00 | QQQ | ETF | 36.77 | 36.79 | 36.54 | 36.6 | 10969300.0 |
| 2005-01-24 15:00:00 | QQQ | ETF | 36.6 | 36.71 | 36.57 | 36.68 | 10807200.0 |
| 2005-01-24 15:30:00 | QQQ | ETF | 36.67 | 36.71 | 36.46 | 36.53 | 16956800.0 |
| 2005-01-24 08:00:00 | IWM | ETF | 60.91 | 60.91 | 60.91 | 60.91 | 400.0 |
| 2005-01-24 08:30:00 | IWM | ETF | 60.95 | 60.97 | 60.95 | 60.97 | 3000.0 |
| 2005-01-24 09:00:00 | IWM | ETF | 60.985 | 61.085 | 60.98 | 60.98 | 24000.0 |
| 2005-01-24 09:30:00 | IWM | ETF | 60.96 | 61.25 | 60.6715 | 60.71 | 4336000.0 |
| 2005-01-24 10:00:00 | IWM | ETF | 60.72 | 61.025 | 60.53 | 60.685 | 2408200.0 |
| 2005-01-24 10:30:00 | IWM | ETF | 60.7 | 60.845 | 60.55 | 60.625 | 1258200.0 |
| 2005-01-24 11:00:00 | IWM | ETF | 60.64 | 60.785 | 60.505 | 60.675 | 790400.0 |
| 2005-01-24 11:30:00 | IWM | ETF | 60.67 | 60.785 | 60.635 | 60.695 | 378800.0 |
| 2005-01-24 12:00:00 | IWM | ETF | 60.715 | 60.75 | 60.575 | 60.61 | 522400.0 |
| 2005-01-24 12:30:00 | IWM | ETF | 60.605 | 60.7 | 60.55 | 60.62 | 986800.0 |
| 2005-01-24 13:00:00 | IWM | ETF | 60.62 | 60.835 | 60.62 | 60.775 | 902200.0 |
| 2005-01-24 13:30:00 | IWM | ETF | 60.765 | 60.79 | 60.59 | 60.605 | 477800.0 |
| 2005-01-24 14:00:00 | IWM | ETF | 60.605 | 60.71 | 60.42 | 60.42 | 653800.0 |
> showing 50 of 1,455 rows — these rows as CSV