PREVIEW / etf_30min / 2005-10-26
file: by_date/etf_30min/2005/2005-10-26.parquet size: 52 KB rows: 1,782
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-26 07:00:00 | SPY | ETF | 120.03 | 120.03 | 120.03 | 120.03 | 2400.0 |
| 2005-10-26 07:30:00 | SPY | ETF | 120.03 | 120.05 | 119.85 | 119.85 | 232700.0 |
| 2005-10-26 08:00:00 | SPY | ETF | 119.84 | 120.11 | 119.4 | 119.41 | 1819800.0 |
| 2005-10-26 08:30:00 | SPY | ETF | 119.42 | 120.11 | 119.4 | 119.58 | 1915400.0 |
| 2005-10-26 09:00:00 | SPY | ETF | 119.58 | 120.0 | 119.5 | 119.51 | 480700.0 |
| 2005-10-26 09:30:00 | SPY | ETF | 119.51 | 119.99 | 119.35 | 119.96 | 9526400.0 |
| 2005-10-26 10:00:00 | SPY | ETF | 119.94 | 120.26 | 119.69 | 120.16 | 8688500.0 |
| 2005-10-26 10:30:00 | SPY | ETF | 120.16 | 120.33 | 119.41 | 120.25 | 8803600.0 |
| 2005-10-26 11:00:00 | SPY | ETF | 120.25 | 120.54 | 120.11 | 120.44 | 5319100.0 |
| 2005-10-26 11:30:00 | SPY | ETF | 120.44 | 120.49 | 120.02 | 120.08 | 4904700.0 |
| 2005-10-26 12:00:00 | SPY | ETF | 120.07 | 120.15 | 119.9 | 120.03 | 3273100.0 |
| 2005-10-26 12:30:00 | SPY | ETF | 120.03 | 120.14 | 119.8 | 119.97 | 3795200.0 |
| 2005-10-26 13:00:00 | SPY | ETF | 119.98 | 120.01 | 119.56 | 119.75 | 5433300.0 |
| 2005-10-26 13:30:00 | SPY | ETF | 119.7401 | 119.98 | 119.41 | 119.67 | 6189900.0 |
| 2005-10-26 14:00:00 | SPY | ETF | 119.68 | 120.01 | 119.65 | 119.78 | 4293200.0 |
| 2005-10-26 14:30:00 | SPY | ETF | 119.78 | 119.81 | 119.45 | 119.69 | 4094600.0 |
| 2005-10-26 15:00:00 | SPY | ETF | 119.68 | 119.93 | 119.57 | 119.72 | 3696900.0 |
| 2005-10-26 15:30:00 | SPY | ETF | 119.71 | 119.72 | 119.19 | 119.26 | 6575600.0 |
| 2005-10-26 16:00:00 | SPY | ETF | 119.27 | 119.85 | 119.23 | 119.33 | 616000.0 |
| 2005-10-26 16:30:00 | SPY | ETF | 119.34 | 119.41 | 119.32 | 119.35 | 212700.0 |
| 2005-10-26 17:00:00 | SPY | ETF | 119.34 | 119.5324 | 119.33 | 119.39 | 43600.0 |
| 2005-10-26 17:30:00 | SPY | ETF | 119.35 | 119.42 | 119.35 | 119.42 | 1579500.0 |
| 2005-10-26 18:00:00 | SPY | ETF | 119.4 | 119.4 | 119.31 | 119.31 | 800.0 |
| 2005-10-26 18:30:00 | SPY | ETF | 119.31 | 119.31 | 119.29 | 119.29 | 500.0 |
| 2005-10-26 19:00:00 | SPY | ETF | 119.29 | 119.29 | 119.27 | 119.27 | 4800.0 |
| 2005-10-26 19:30:00 | SPY | ETF | 119.36 | 119.36 | 119.36 | 119.36 | 200.0 |
| 2005-10-26 09:30:00 | QQQ | ETF | 38.96 | 39.1 | 38.9 | 39.08 | 9688600.0 |
| 2005-10-26 10:00:00 | QQQ | ETF | 39.06 | 39.23 | 39.01 | 39.22 | 9518900.0 |
| 2005-10-26 10:30:00 | QQQ | ETF | 39.23 | 39.25 | 39.07 | 39.22 | 9012600.0 |
| 2005-10-26 11:00:00 | QQQ | ETF | 39.22 | 39.27 | 39.14 | 39.23 | 5923600.0 |
| 2005-10-26 11:30:00 | QQQ | ETF | 39.23 | 39.25 | 39.08 | 39.09 | 4310700.0 |
| 2005-10-26 12:00:00 | QQQ | ETF | 39.09 | 39.11 | 39.01 | 39.06 | 7261800.0 |
| 2005-10-26 12:30:00 | QQQ | ETF | 39.06 | 39.1 | 38.96 | 39.04 | 3462700.0 |
| 2005-10-26 13:00:00 | QQQ | ETF | 39.05 | 39.07 | 38.87 | 38.97 | 5878200.0 |
| 2005-10-26 13:30:00 | QQQ | ETF | 38.96 | 38.99 | 38.83 | 38.9 | 4382900.0 |
| 2005-10-26 14:00:00 | QQQ | ETF | 38.9 | 39.02 | 38.9 | 38.97 | 5784600.0 |
| 2005-10-26 14:30:00 | QQQ | ETF | 38.96 | 38.99 | 38.88 | 38.96 | 4340100.0 |
| 2005-10-26 15:00:00 | QQQ | ETF | 38.96 | 39.01 | 38.9 | 38.92 | 3852800.0 |
| 2005-10-26 15:30:00 | QQQ | ETF | 38.93 | 38.93 | 38.76 | 38.8 | 8262800.0 |
| 2005-10-26 07:30:00 | IWM | ETF | 64.04 | 64.04 | 63.94 | 63.94 | 38700.0 |
| 2005-10-26 08:00:00 | IWM | ETF | 63.91 | 64.04 | 63.58 | 63.59 | 227100.0 |
| 2005-10-26 08:30:00 | IWM | ETF | 63.58 | 63.84 | 63.58 | 63.72 | 165000.0 |
| 2005-10-26 09:00:00 | IWM | ETF | 63.73 | 63.76 | 63.67 | 63.7 | 169100.0 |
| 2005-10-26 09:30:00 | IWM | ETF | 63.69 | 64.09 | 63.61 | 64.08 | 4879900.0 |
| 2005-10-26 10:00:00 | IWM | ETF | 64.05 | 64.4 | 63.91 | 64.32 | 3672200.0 |
| 2005-10-26 10:30:00 | IWM | ETF | 64.31 | 64.37 | 64.08 | 64.19 | 2557200.0 |
| 2005-10-26 11:00:00 | IWM | ETF | 64.18 | 64.59 | 64.06 | 64.53 | 2591300.0 |
| 2005-10-26 11:30:00 | IWM | ETF | 64.54 | 64.55 | 64.24 | 64.27 | 1347800.0 |
| 2005-10-26 12:00:00 | IWM | ETF | 64.27 | 64.34 | 64.2 | 64.28 | 528300.0 |
| 2005-10-26 12:30:00 | IWM | ETF | 64.28 | 64.34 | 64.11 | 64.24 | 758900.0 |
> showing 50 of 1,782 rows — these rows as CSV