PREVIEW / etf_30min / 2005-10-11
file: by_date/etf_30min/2005/2005-10-11.parquet size: 50 KB rows: 1,732
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-11 06:00:00 | SPY | ETF | 119.11 | 119.11 | 119.11 | 119.11 | 1700.0 |
| 2005-10-11 07:00:00 | SPY | ETF | 119.04 | 119.06 | 119.03 | 119.06 | 12000.0 |
| 2005-10-11 07:30:00 | SPY | ETF | 119.05 | 119.12 | 119.05 | 119.05 | 27600.0 |
| 2005-10-11 08:00:00 | SPY | ETF | 119.04 | 119.12 | 118.6 | 119.08 | 443600.0 |
| 2005-10-11 08:30:00 | SPY | ETF | 119.07 | 119.12 | 118.7 | 119.07 | 725600.0 |
| 2005-10-11 09:00:00 | SPY | ETF | 119.06 | 119.12 | 118.96 | 119.01 | 1063700.0 |
| 2005-10-11 09:30:00 | SPY | ETF | 118.99 | 119.39 | 118.95 | 119.22 | 7056900.0 |
| 2005-10-11 10:00:00 | SPY | ETF | 119.26 | 119.39 | 118.95 | 119.31 | 6509100.0 |
| 2005-10-11 10:30:00 | SPY | ETF | 119.33 | 119.37 | 118.79 | 118.94 | 4490000.0 |
| 2005-10-11 11:00:00 | SPY | ETF | 118.92 | 119.01 | 118.76 | 118.84 | 3269500.0 |
| 2005-10-11 11:30:00 | SPY | ETF | 118.83 | 118.87 | 118.63 | 118.81 | 4177900.0 |
| 2005-10-11 12:00:00 | SPY | ETF | 118.79 | 118.86 | 118.43 | 118.54 | 4770800.0 |
| 2005-10-11 12:30:00 | SPY | ETF | 118.54 | 118.88 | 118.53 | 118.72 | 4743300.0 |
| 2005-10-11 13:00:00 | SPY | ETF | 118.75 | 118.99 | 118.7 | 118.93 | 3508500.0 |
| 2005-10-11 13:30:00 | SPY | ETF | 118.94 | 118.99 | 118.69 | 118.8 | 2612500.0 |
| 2005-10-11 14:00:00 | SPY | ETF | 118.8 | 119.24 | 118.49 | 119.0 | 10163900.0 |
| 2005-10-11 14:30:00 | SPY | ETF | 119.0 | 119.07 | 118.55 | 118.68 | 3940700.0 |
| 2005-10-11 15:00:00 | SPY | ETF | 118.66 | 118.84 | 118.35 | 118.46 | 6259800.0 |
| 2005-10-11 15:30:00 | SPY | ETF | 118.46 | 118.73 | 118.32 | 118.54 | 5017900.0 |
| 2005-10-11 16:00:00 | SPY | ETF | 118.53 | 118.61 | 118.43 | 118.54 | 911600.0 |
| 2005-10-11 16:30:00 | SPY | ETF | 118.54 | 118.54 | 118.25 | 118.3 | 377900.0 |
| 2005-10-11 17:00:00 | SPY | ETF | 118.29 | 118.29 | 118.16 | 118.16 | 78600.0 |
| 2005-10-11 17:30:00 | SPY | ETF | 118.16 | 118.24 | 118.16 | 118.24 | 57300.0 |
| 2005-10-11 18:00:00 | SPY | ETF | 118.25 | 118.29 | 118.25 | 118.25 | 6300.0 |
| 2005-10-11 18:30:00 | SPY | ETF | 118.29 | 118.33 | 118.29 | 118.33 | 7000.0 |
| 2005-10-11 19:00:00 | SPY | ETF | 118.24 | 118.24 | 118.24 | 118.24 | 500.0 |
| 2005-10-11 19:30:00 | SPY | ETF | 118.26 | 118.26 | 118.26 | 118.26 | 300.0 |
| 2005-10-11 09:30:00 | QQQ | ETF | 38.21 | 38.24 | 38.13 | 38.17 | 10555900.0 |
| 2005-10-11 10:00:00 | QQQ | ETF | 38.16 | 38.23 | 38.08 | 38.18 | 5301700.0 |
| 2005-10-11 10:30:00 | QQQ | ETF | 38.19 | 38.2 | 38.01 | 38.06 | 7095000.0 |
| 2005-10-11 11:00:00 | QQQ | ETF | 38.06 | 38.07 | 37.97 | 38.01 | 6649800.0 |
| 2005-10-11 11:30:00 | QQQ | ETF | 38.01 | 38.04 | 37.92 | 37.99 | 7190400.0 |
| 2005-10-11 12:00:00 | QQQ | ETF | 37.99 | 38.01 | 37.82 | 37.85 | 6886700.0 |
| 2005-10-11 12:30:00 | QQQ | ETF | 37.85 | 37.95 | 37.85 | 37.91 | 4499000.0 |
| 2005-10-11 13:00:00 | QQQ | ETF | 37.92 | 38.03 | 37.89 | 37.99 | 6084700.0 |
| 2005-10-11 13:30:00 | QQQ | ETF | 38.0 | 38.05 | 37.89 | 37.93 | 3977600.0 |
| 2005-10-11 14:00:00 | QQQ | ETF | 37.94 | 38.13 | 37.84 | 38.04 | 15605900.0 |
| 2005-10-11 14:30:00 | QQQ | ETF | 38.04 | 38.08 | 37.9 | 37.93 | 6835900.0 |
| 2005-10-11 15:00:00 | QQQ | ETF | 37.93 | 37.98 | 37.82 | 37.85 | 7288400.0 |
| 2005-10-11 15:30:00 | QQQ | ETF | 37.85 | 37.96 | 37.8 | 37.93 | 10715400.0 |
| 2005-10-11 08:00:00 | IWM | ETF | 63.79 | 63.79 | 63.69 | 63.69 | 1400.0 |
| 2005-10-11 08:30:00 | IWM | ETF | 63.79 | 63.79 | 63.72 | 63.75 | 24200.0 |
| 2005-10-11 09:00:00 | IWM | ETF | 63.77 | 63.77 | 63.64 | 63.7 | 5600.0 |
| 2005-10-11 09:30:00 | IWM | ETF | 63.69 | 63.91 | 63.56 | 63.74 | 2476900.0 |
| 2005-10-11 10:00:00 | IWM | ETF | 63.74 | 63.78 | 63.46 | 63.73 | 984600.0 |
| 2005-10-11 10:30:00 | IWM | ETF | 63.738 | 63.77 | 63.35 | 63.43 | 819300.0 |
| 2005-10-11 11:00:00 | IWM | ETF | 63.43 | 63.46 | 63.26 | 63.31 | 2025200.0 |
| 2005-10-11 11:30:00 | IWM | ETF | 63.32 | 63.34 | 63.03 | 63.12 | 2079600.0 |
| 2005-10-11 12:00:00 | IWM | ETF | 63.12 | 63.19 | 62.84 | 62.97 | 2624800.0 |
| 2005-10-11 12:30:00 | IWM | ETF | 62.96 | 63.06 | 62.94 | 62.94 | 2349600.0 |
> showing 50 of 1,732 rows — these rows as CSV