PREVIEW / etf_30min / 2005-09-12
file: by_date/etf_30min/2005/2005-09-12.parquet size: 44 KB rows: 1,654
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-09-12 07:00:00 | SPY | ETF | 124.34 | 124.5 | 124.34 | 124.5 | 2700.0 |
| 2005-09-12 07:30:00 | SPY | ETF | 124.48 | 124.5 | 124.45 | 124.5 | 8000.0 |
| 2005-09-12 08:00:00 | SPY | ETF | 124.45 | 124.85 | 124.37 | 124.5 | 143600.0 |
| 2005-09-12 08:30:00 | SPY | ETF | 124.5 | 124.51 | 124.47 | 124.49 | 72300.0 |
| 2005-09-12 09:00:00 | SPY | ETF | 124.49 | 124.51 | 124.43 | 124.44 | 257900.0 |
| 2005-09-12 09:30:00 | SPY | ETF | 124.45 | 124.67 | 124.37 | 124.6 | 4438000.0 |
| 2005-09-12 10:00:00 | SPY | ETF | 124.6 | 124.65 | 124.39 | 124.47 | 3863100.0 |
| 2005-09-12 10:30:00 | SPY | ETF | 124.47 | 124.55 | 124.32 | 124.5 | 3222000.0 |
| 2005-09-12 11:00:00 | SPY | ETF | 124.5 | 124.56 | 124.37 | 124.48 | 1684800.0 |
| 2005-09-12 11:30:00 | SPY | ETF | 124.48 | 124.53 | 124.38 | 124.38 | 1833100.0 |
| 2005-09-12 12:00:00 | SPY | ETF | 124.4 | 124.65 | 124.38 | 124.63 | 3038500.0 |
| 2005-09-12 12:30:00 | SPY | ETF | 124.63 | 124.63 | 124.45 | 124.47 | 1589100.0 |
| 2005-09-12 13:00:00 | SPY | ETF | 124.47 | 124.56 | 124.45 | 124.45 | 764300.0 |
| 2005-09-12 13:30:00 | SPY | ETF | 124.46 | 124.54 | 124.31 | 124.31 | 1228000.0 |
| 2005-09-12 14:00:00 | SPY | ETF | 124.35 | 124.5 | 124.27 | 124.44 | 2283700.0 |
| 2005-09-12 14:30:00 | SPY | ETF | 124.44 | 124.57 | 124.43 | 124.56 | 1071500.0 |
| 2005-09-12 15:00:00 | SPY | ETF | 124.55 | 124.66 | 124.48 | 124.63 | 1572600.0 |
| 2005-09-12 15:30:00 | SPY | ETF | 124.63 | 124.63 | 124.41 | 124.43 | 3403500.0 |
| 2005-09-12 16:00:00 | SPY | ETF | 124.4 | 124.66 | 124.3 | 124.31 | 1058700.0 |
| 2005-09-12 16:30:00 | SPY | ETF | 124.3 | 124.44 | 124.2 | 124.3 | 357100.0 |
| 2005-09-12 17:00:00 | SPY | ETF | 124.28 | 124.29 | 124.26 | 124.29 | 11100.0 |
| 2005-09-12 17:30:00 | SPY | ETF | 124.32 | 124.34 | 124.3 | 124.31 | 2700.0 |
| 2005-09-12 18:00:00 | SPY | ETF | 124.33 | 124.34 | 124.27 | 124.27 | 2900.0 |
| 2005-09-12 18:30:00 | SPY | ETF | 124.28 | 124.28 | 124.25 | 124.25 | 6000.0 |
| 2005-09-12 19:30:00 | SPY | ETF | 124.27 | 124.27 | 124.25 | 124.27 | 1600.0 |
| 2005-09-12 09:30:00 | QQQ | ETF | 39.63 | 39.77 | 39.58 | 39.76 | 7720100.0 |
| 2005-09-12 10:00:00 | QQQ | ETF | 39.76 | 39.77 | 39.68 | 39.73 | 3814500.0 |
| 2005-09-12 10:30:00 | QQQ | ETF | 39.73 | 39.77 | 39.63 | 39.74 | 5380100.0 |
| 2005-09-12 11:00:00 | QQQ | ETF | 39.75 | 39.79 | 39.72 | 39.77 | 3487800.0 |
| 2005-09-12 11:30:00 | QQQ | ETF | 39.77 | 39.78 | 39.7 | 39.7 | 1771900.0 |
| 2005-09-12 12:00:00 | QQQ | ETF | 39.71 | 39.86 | 39.7 | 39.84 | 5250900.0 |
| 2005-09-12 12:30:00 | QQQ | ETF | 39.84 | 39.85 | 39.78 | 39.78 | 1348300.0 |
| 2005-09-12 13:00:00 | QQQ | ETF | 39.78 | 39.81 | 39.77 | 39.79 | 1536000.0 |
| 2005-09-12 13:30:00 | QQQ | ETF | 39.79 | 39.83 | 39.72 | 39.72 | 2464100.0 |
| 2005-09-12 14:00:00 | QQQ | ETF | 39.72 | 39.75 | 39.67 | 39.71 | 4060100.0 |
| 2005-09-12 14:30:00 | QQQ | ETF | 39.72 | 39.81 | 39.71 | 39.8 | 2436100.0 |
| 2005-09-12 15:00:00 | QQQ | ETF | 39.8 | 39.84 | 39.75 | 39.82 | 3462900.0 |
| 2005-09-12 15:30:00 | QQQ | ETF | 39.83 | 39.83 | 39.73 | 39.73 | 4761600.0 |
| 2005-09-12 08:00:00 | IWM | ETF | 67.36 | 67.44 | 67.35 | 67.44 | 13500.0 |
| 2005-09-12 09:30:00 | IWM | ETF | 67.425 | 67.61 | 67.28 | 67.53 | 1755400.0 |
| 2005-09-12 10:00:00 | IWM | ETF | 67.53 | 67.6 | 67.42 | 67.54 | 1210200.0 |
| 2005-09-12 10:30:00 | IWM | ETF | 67.54 | 67.63 | 67.45 | 67.62 | 892200.0 |
| 2005-09-12 11:00:00 | IWM | ETF | 67.62 | 67.72 | 67.61 | 67.69 | 1176300.0 |
| 2005-09-12 11:30:00 | IWM | ETF | 67.69 | 67.75 | 67.67 | 67.68 | 1114000.0 |
| 2005-09-12 12:00:00 | IWM | ETF | 67.68 | 67.92 | 67.67 | 67.9 | 1313700.0 |
| 2005-09-12 12:30:00 | IWM | ETF | 67.91 | 67.91 | 67.84 | 67.86 | 1994300.0 |
| 2005-09-12 13:00:00 | IWM | ETF | 67.86 | 67.9 | 67.82 | 67.82 | 375300.0 |
| 2005-09-12 13:30:00 | IWM | ETF | 67.82 | 67.88 | 67.72 | 67.72 | 672500.0 |
| 2005-09-12 14:00:00 | IWM | ETF | 67.72 | 67.84 | 67.7 | 67.83 | 1114000.0 |
| 2005-09-12 14:30:00 | IWM | ETF | 67.83 | 67.99 | 67.82 | 67.97 | 991200.0 |
> showing 50 of 1,654 rows — these rows as CSV