PREVIEW / etf_30min / 2005-11-14
file: by_date/etf_30min/2005/2005-11-14.parquet size: 48 KB rows: 1,766
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-11-14 07:00:00 | SPY | ETF | 123.74 | 123.74 | 123.72 | 123.72 | 3700.0 |
| 2005-11-14 07:30:00 | SPY | ETF | 123.71 | 123.71 | 123.69 | 123.69 | 104200.0 |
| 2005-11-14 08:00:00 | SPY | ETF | 123.69 | 123.75 | 123.65 | 123.7 | 421200.0 |
| 2005-11-14 08:30:00 | SPY | ETF | 123.68 | 123.75 | 123.67 | 123.7 | 95500.0 |
| 2005-11-14 09:00:00 | SPY | ETF | 123.72 | 123.8 | 123.71 | 123.78 | 339000.0 |
| 2005-11-14 09:30:00 | SPY | ETF | 123.76 | 123.9 | 123.63 | 123.78 | 6840100.0 |
| 2005-11-14 10:00:00 | SPY | ETF | 123.79 | 124.02 | 123.7 | 123.71 | 6396500.0 |
| 2005-11-14 10:30:00 | SPY | ETF | 123.72 | 123.91 | 123.67 | 123.69 | 2830100.0 |
| 2005-11-14 11:00:00 | SPY | ETF | 123.67 | 123.8 | 123.62 | 123.72 | 3568100.0 |
| 2005-11-14 11:30:00 | SPY | ETF | 123.73 | 123.74 | 123.54 | 123.66 | 2590600.0 |
| 2005-11-14 12:00:00 | SPY | ETF | 123.63 | 123.68 | 123.54 | 123.63 | 1438800.0 |
| 2005-11-14 12:30:00 | SPY | ETF | 123.63 | 123.68 | 123.44 | 123.49 | 1413700.0 |
| 2005-11-14 13:00:00 | SPY | ETF | 123.47 | 123.58 | 123.41 | 123.52 | 5105000.0 |
| 2005-11-14 13:30:00 | SPY | ETF | 123.52 | 123.71 | 123.45 | 123.71 | 2481100.0 |
| 2005-11-14 14:00:00 | SPY | ETF | 123.71 | 123.77 | 123.53 | 123.57 | 1694500.0 |
| 2005-11-14 14:30:00 | SPY | ETF | 123.58 | 123.69 | 123.53 | 123.58 | 1469700.0 |
| 2005-11-14 15:00:00 | SPY | ETF | 123.58 | 123.64 | 123.45 | 123.56 | 1286400.0 |
| 2005-11-14 15:30:00 | SPY | ETF | 123.56 | 123.74 | 123.53 | 123.67 | 2843500.0 |
| 2005-11-14 16:00:00 | SPY | ETF | 123.68 | 123.78 | 123.62 | 123.67 | 866400.0 |
| 2005-11-14 16:30:00 | SPY | ETF | 123.68 | 123.7 | 123.64 | 123.65 | 165400.0 |
| 2005-11-14 17:00:00 | SPY | ETF | 123.67 | 123.69 | 123.63 | 123.63 | 118800.0 |
| 2005-11-14 17:30:00 | SPY | ETF | 123.65 | 123.7 | 123.64 | 123.7 | 2000.0 |
| 2005-11-14 18:00:00 | SPY | ETF | 123.62 | 123.62 | 123.6 | 123.6 | 4600.0 |
| 2005-11-14 18:30:00 | SPY | ETF | 123.61 | 123.63 | 123.6 | 123.6 | 1700.0 |
| 2005-11-14 19:00:00 | SPY | ETF | 123.56 | 123.57 | 123.56 | 123.57 | 1100.0 |
| 2005-11-14 19:30:00 | SPY | ETF | 123.59 | 123.59 | 123.59 | 123.59 | 400.0 |
| 2005-11-14 09:30:00 | QQQ | ETF | 40.77 | 40.83 | 40.71 | 40.78 | 7361900.0 |
| 2005-11-14 10:00:00 | QQQ | ETF | 40.78 | 40.86 | 40.72 | 40.77 | 6149100.0 |
| 2005-11-14 10:30:00 | QQQ | ETF | 40.77 | 40.83 | 40.7 | 40.7 | 3546900.0 |
| 2005-11-14 11:00:00 | QQQ | ETF | 40.71 | 40.79 | 40.69 | 40.75 | 5612700.0 |
| 2005-11-14 11:30:00 | QQQ | ETF | 40.75 | 40.75 | 40.67 | 40.71 | 2862100.0 |
| 2005-11-14 12:00:00 | QQQ | ETF | 40.71 | 40.76 | 40.66 | 40.72 | 2416200.0 |
| 2005-11-14 12:30:00 | QQQ | ETF | 40.72 | 40.73 | 40.62 | 40.63 | 2328700.0 |
| 2005-11-14 13:00:00 | QQQ | ETF | 40.63 | 40.7 | 40.6 | 40.66 | 3222700.0 |
| 2005-11-14 13:30:00 | QQQ | ETF | 40.66 | 40.75 | 40.62 | 40.75 | 2115000.0 |
| 2005-11-14 14:00:00 | QQQ | ETF | 40.75 | 40.75 | 40.69 | 40.71 | 2455600.0 |
| 2005-11-14 14:30:00 | QQQ | ETF | 40.72 | 40.74 | 40.7 | 40.71 | 1479400.0 |
| 2005-11-14 15:00:00 | QQQ | ETF | 40.71 | 40.72 | 40.67 | 40.7 | 2117300.0 |
| 2005-11-14 15:30:00 | QQQ | ETF | 40.7 | 40.75 | 40.69 | 40.72 | 4553800.0 |
| 2005-11-14 08:00:00 | IWM | ETF | 66.33 | 66.33 | 66.29 | 66.29 | 5000.0 |
| 2005-11-14 09:00:00 | IWM | ETF | 66.37 | 66.5 | 66.37 | 66.5 | 7900.0 |
| 2005-11-14 09:30:00 | IWM | ETF | 66.51 | 66.55 | 66.25 | 66.28 | 3132400.0 |
| 2005-11-14 10:00:00 | IWM | ETF | 66.31 | 66.43 | 66.09 | 66.11 | 2391500.0 |
| 2005-11-14 10:30:00 | IWM | ETF | 66.12 | 66.27 | 66.12 | 66.15 | 939200.0 |
| 2005-11-14 11:00:00 | IWM | ETF | 66.15 | 66.21 | 66.05 | 66.12 | 2562600.0 |
| 2005-11-14 11:30:00 | IWM | ETF | 66.15 | 66.15 | 65.91 | 66.0 | 2656600.0 |
| 2005-11-14 12:00:00 | IWM | ETF | 66.0 | 66.13 | 65.94 | 66.13 | 1880400.0 |
| 2005-11-14 12:30:00 | IWM | ETF | 66.11 | 66.15 | 65.94 | 65.94 | 1848800.0 |
| 2005-11-14 13:00:00 | IWM | ETF | 65.94 | 66.04 | 65.85 | 65.9699 | 828700.0 |
| 2005-11-14 13:30:00 | IWM | ETF | 65.96 | 66.3409 | 65.85 | 66.06 | 834400.0 |
> showing 50 of 1,766 rows — these rows as CSV