PREVIEW / etf_30min / 2005-10-14
file: by_date/etf_30min/2005/2005-10-14.parquet size: 50 KB rows: 1,723
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-10-14 07:00:00 | SPY | ETF | 117.7 | 117.83 | 117.7 | 117.78 | 193600.0 |
| 2005-10-14 07:30:00 | SPY | ETF | 117.77 | 117.8 | 117.71 | 117.72 | 309300.0 |
| 2005-10-14 08:00:00 | SPY | ETF | 117.75 | 117.89 | 117.67 | 117.73 | 2483100.0 |
| 2005-10-14 08:30:00 | SPY | ETF | 117.79 | 118.38 | 117.79 | 118.29 | 4509000.0 |
| 2005-10-14 09:00:00 | SPY | ETF | 118.29 | 118.34 | 118.11 | 118.12 | 805900.0 |
| 2005-10-14 09:30:00 | SPY | ETF | 118.12 | 118.33 | 117.81 | 117.86 | 13619800.0 |
| 2005-10-14 10:00:00 | SPY | ETF | 117.88 | 118.09 | 117.56 | 117.69 | 9963600.0 |
| 2005-10-14 10:30:00 | SPY | ETF | 117.72 | 118.03 | 117.6 | 117.86 | 7440200.0 |
| 2005-10-14 11:00:00 | SPY | ETF | 117.86 | 118.39 | 117.81 | 118.14 | 5352500.0 |
| 2005-10-14 11:30:00 | SPY | ETF | 118.14 | 118.33 | 118.06 | 118.27 | 2726200.0 |
| 2005-10-14 12:00:00 | SPY | ETF | 118.29 | 118.61 | 118.25 | 118.48 | 6403100.0 |
| 2005-10-14 12:30:00 | SPY | ETF | 118.48 | 118.5 | 118.07 | 118.11 | 6935400.0 |
| 2005-10-14 13:00:00 | SPY | ETF | 118.1 | 118.38 | 117.95 | 118.33 | 5097700.0 |
| 2005-10-14 13:30:00 | SPY | ETF | 118.32 | 118.42 | 118.18 | 118.38 | 2233300.0 |
| 2005-10-14 14:00:00 | SPY | ETF | 118.39 | 118.39 | 118.11 | 118.28 | 2894800.0 |
| 2005-10-14 14:30:00 | SPY | ETF | 118.28 | 118.64 | 118.21 | 118.53 | 3741300.0 |
| 2005-10-14 15:00:00 | SPY | ETF | 118.53 | 118.67 | 118.43 | 118.57 | 4168800.0 |
| 2005-10-14 15:30:00 | SPY | ETF | 118.56 | 118.81 | 118.56 | 118.75 | 6882900.0 |
| 2005-10-14 16:00:00 | SPY | ETF | 118.77 | 118.77 | 118.64 | 118.68 | 703600.0 |
| 2005-10-14 16:30:00 | SPY | ETF | 118.65 | 118.71 | 118.59 | 118.59 | 146700.0 |
| 2005-10-14 17:00:00 | SPY | ETF | 118.65 | 118.69 | 118.58 | 118.58 | 21400.0 |
| 2005-10-14 17:30:00 | SPY | ETF | 118.6 | 118.6 | 118.6 | 118.6 | 200.0 |
| 2005-10-14 18:00:00 | SPY | ETF | 118.65 | 118.67 | 118.65 | 118.67 | 2900.0 |
| 2005-10-14 18:30:00 | SPY | ETF | 118.67 | 118.67 | 118.67 | 118.67 | 2400.0 |
| 2005-10-14 19:00:00 | SPY | ETF | 118.67 | 118.67 | 118.6 | 118.6 | 1700.0 |
| 2005-10-14 19:30:00 | SPY | ETF | 118.61 | 118.61 | 118.61 | 118.61 | 1000.0 |
| 2005-10-14 09:30:00 | QQQ | ETF | 37.86 | 37.96 | 37.72 | 37.73 | 18266200.0 |
| 2005-10-14 10:00:00 | QQQ | ETF | 37.73 | 37.84 | 37.64 | 37.71 | 13225200.0 |
| 2005-10-14 10:30:00 | QQQ | ETF | 37.71 | 37.94 | 37.68 | 37.85 | 12998800.0 |
| 2005-10-14 11:00:00 | QQQ | ETF | 37.85 | 37.95 | 37.8 | 37.89 | 6819900.0 |
| 2005-10-14 11:30:00 | QQQ | ETF | 37.89 | 37.95 | 37.83 | 37.9 | 6303000.0 |
| 2005-10-14 12:00:00 | QQQ | ETF | 37.91 | 38.02 | 37.9 | 37.93 | 8101700.0 |
| 2005-10-14 12:30:00 | QQQ | ETF | 37.93 | 37.94 | 37.76 | 37.78 | 8850400.0 |
| 2005-10-14 13:00:00 | QQQ | ETF | 37.78 | 37.86 | 37.7 | 37.84 | 5922900.0 |
| 2005-10-14 13:30:00 | QQQ | ETF | 37.84 | 37.89 | 37.81 | 37.88 | 3347800.0 |
| 2005-10-14 14:00:00 | QQQ | ETF | 37.88 | 37.88 | 37.77 | 37.86 | 3031600.0 |
| 2005-10-14 14:30:00 | QQQ | ETF | 37.86 | 38.04 | 37.82 | 37.97 | 9715700.0 |
| 2005-10-14 15:00:00 | QQQ | ETF | 37.98 | 38.06 | 37.96 | 38.02 | 5830900.0 |
| 2005-10-14 15:30:00 | QQQ | ETF | 38.01 | 38.07 | 37.99 | 38.06 | 8478700.0 |
| 2005-10-14 07:30:00 | IWM | ETF | 62.0 | 62.0 | 62.0 | 62.0 | 8500.0 |
| 2005-10-14 08:00:00 | IWM | ETF | 61.96 | 62.08 | 61.96 | 62.0 | 892900.0 |
| 2005-10-14 08:30:00 | IWM | ETF | 62.13 | 62.59 | 62.07 | 62.48 | 597900.0 |
| 2005-10-14 09:00:00 | IWM | ETF | 62.46 | 62.55 | 61.87 | 62.47 | 5214000.0 |
| 2005-10-14 09:30:00 | IWM | ETF | 62.46 | 62.53 | 61.32 | 62.06 | 6096800.0 |
| 2005-10-14 10:00:00 | IWM | ETF | 62.05 | 62.22 | 61.76 | 61.8 | 4502100.0 |
| 2005-10-14 10:30:00 | IWM | ETF | 61.8 | 62.45 | 61.68 | 62.32 | 6648700.0 |
| 2005-10-14 11:00:00 | IWM | ETF | 62.32 | 62.49 | 62.2 | 62.44 | 1554300.0 |
| 2005-10-14 11:30:00 | IWM | ETF | 62.43 | 62.65 | 62.38 | 62.62 | 4338700.0 |
| 2005-10-14 12:00:00 | IWM | ETF | 62.63 | 62.89 | 62.63 | 62.79 | 4413100.0 |
| 2005-10-14 12:30:00 | IWM | ETF | 62.78 | 62.79 | 62.48 | 62.53 | 3177200.0 |
> showing 50 of 1,723 rows — these rows as CSV