PREVIEW / etf_30min / 2004-10-05
file: by_date/etf_30min/2004/2004-10-05.parquet size: 35 KB rows: 1,196
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-05 08:00:00 | SPY | ETF | 113.96 | 113.97 | 113.93 | 113.93 | 24900.0 |
| 2004-10-05 08:30:00 | SPY | ETF | 113.92 | 113.94 | 113.87 | 113.87 | 36600.0 |
| 2004-10-05 09:00:00 | SPY | ETF | 113.85 | 113.86 | 113.76 | 113.84 | 232100.0 |
| 2004-10-05 09:30:00 | SPY | ETF | 113.85 | 113.9 | 113.74 | 113.82 | 4183900.0 |
| 2004-10-05 10:00:00 | SPY | ETF | 113.81 | 113.97 | 113.61 | 113.94 | 4912200.0 |
| 2004-10-05 10:30:00 | SPY | ETF | 113.92 | 114.0 | 113.82 | 113.88 | 2803800.0 |
| 2004-10-05 11:00:00 | SPY | ETF | 113.88 | 113.95 | 113.79 | 113.85 | 1968100.0 |
| 2004-10-05 11:30:00 | SPY | ETF | 113.81 | 113.94 | 113.81 | 113.9 | 1316200.0 |
| 2004-10-05 12:00:00 | SPY | ETF | 113.87 | 113.97 | 113.81 | 113.94 | 1208200.0 |
| 2004-10-05 12:30:00 | SPY | ETF | 113.94 | 114.16 | 113.93 | 114.05 | 2242000.0 |
| 2004-10-05 13:00:00 | SPY | ETF | 114.05 | 114.09 | 113.96 | 113.99 | 851600.0 |
| 2004-10-05 13:30:00 | SPY | ETF | 113.99 | 114.04 | 113.79 | 113.79 | 1846300.0 |
| 2004-10-05 14:00:00 | SPY | ETF | 113.78 | 113.83 | 113.56 | 113.64 | 4255700.0 |
| 2004-10-05 14:30:00 | SPY | ETF | 113.64 | 113.79 | 113.59 | 113.65 | 3066800.0 |
| 2004-10-05 15:00:00 | SPY | ETF | 113.66 | 113.83 | 113.54 | 113.81 | 1770200.0 |
| 2004-10-05 15:30:00 | SPY | ETF | 113.83 | 113.88 | 113.66 | 113.83 | 4029500.0 |
| 2004-10-05 16:00:00 | SPY | ETF | 113.83 | 113.98 | 113.78 | 113.91 | 1009000.0 |
| 2004-10-05 16:30:00 | SPY | ETF | 113.91 | 113.95 | 113.89 | 113.95 | 27200.0 |
| 2004-10-05 17:00:00 | SPY | ETF | 113.93 | 113.93 | 113.86 | 113.92 | 117000.0 |
| 2004-10-05 17:30:00 | SPY | ETF | 113.93 | 113.93 | 113.85 | 113.86 | 65900.0 |
| 2004-10-05 18:00:00 | SPY | ETF | 113.86 | 113.96 | 113.86 | 113.91 | 60900.0 |
| 2004-10-05 19:30:00 | SPY | ETF | 113.98 | 113.98 | 113.98 | 113.98 | 200.0 |
| 2004-10-05 08:00:00 | QQQ | ETF | 36.32 | 36.33 | 36.28 | 36.29 | 71100.0 |
| 2004-10-05 08:30:00 | QQQ | ETF | 36.27 | 36.28 | 36.23 | 36.23 | 78900.0 |
| 2004-10-05 09:00:00 | QQQ | ETF | 36.23 | 36.24 | 36.2 | 36.23 | 234400.0 |
| 2004-10-05 09:30:00 | QQQ | ETF | 36.23 | 36.38 | 36.22 | 36.27 | 13752600.0 |
| 2004-10-05 10:00:00 | QQQ | ETF | 36.263 | 36.44 | 36.16 | 36.4 | 10303500.0 |
| 2004-10-05 10:30:00 | QQQ | ETF | 36.4 | 36.44 | 36.3 | 36.34 | 7105000.0 |
| 2004-10-05 11:00:00 | QQQ | ETF | 36.349 | 36.4 | 36.28 | 36.31 | 6712800.0 |
| 2004-10-05 11:30:00 | QQQ | ETF | 36.31 | 36.362 | 36.27 | 36.32 | 4943800.0 |
| 2004-10-05 12:00:00 | QQQ | ETF | 36.32 | 36.382 | 36.3 | 36.375 | 3219600.0 |
| 2004-10-05 12:30:00 | QQQ | ETF | 36.38 | 36.49 | 36.37 | 36.45 | 6565200.0 |
| 2004-10-05 13:00:00 | QQQ | ETF | 36.451 | 36.47 | 36.39 | 36.4 | 1666500.0 |
| 2004-10-05 13:30:00 | QQQ | ETF | 36.41 | 36.45 | 36.3 | 36.3 | 4178400.0 |
| 2004-10-05 14:00:00 | QQQ | ETF | 36.3 | 36.34 | 36.19 | 36.23 | 7834500.0 |
| 2004-10-05 14:30:00 | QQQ | ETF | 36.24 | 36.32 | 36.21 | 36.27 | 5511300.0 |
| 2004-10-05 15:00:00 | QQQ | ETF | 36.27 | 36.36 | 36.2 | 36.342 | 5310200.0 |
| 2004-10-05 15:30:00 | QQQ | ETF | 36.341 | 36.39 | 36.27 | 36.34 | 7222400.0 |
| 2004-10-05 16:00:00 | QQQ | ETF | 36.336 | 36.44 | 36.33 | 36.44 | 2227100.0 |
| 2004-10-05 16:30:00 | QQQ | ETF | 36.44 | 36.44 | 36.375 | 36.39 | 738300.0 |
| 2004-10-05 17:00:00 | QQQ | ETF | 36.39 | 36.403 | 36.39 | 36.4 | 43900.0 |
| 2004-10-05 17:30:00 | QQQ | ETF | 36.41 | 36.41 | 36.38 | 36.41 | 9900.0 |
| 2004-10-05 18:00:00 | QQQ | ETF | 36.41 | 36.41 | 36.39 | 36.39 | 25800.0 |
| 2004-10-05 19:00:00 | QQQ | ETF | 36.41 | 36.42 | 36.41 | 36.42 | 3800.0 |
| 2004-10-05 19:30:00 | QQQ | ETF | 36.42 | 36.42 | 36.4 | 36.42 | 3200.0 |
| 2004-10-05 08:00:00 | IWM | ETF | 58.695 | 58.695 | 58.645 | 58.645 | 1000.0 |
| 2004-10-05 08:30:00 | IWM | ETF | 58.605 | 58.605 | 58.605 | 58.605 | 1000.0 |
| 2004-10-05 09:00:00 | IWM | ETF | 58.58 | 58.655 | 58.58 | 58.655 | 37600.0 |
| 2004-10-05 09:30:00 | IWM | ETF | 58.615 | 58.89 | 58.61 | 58.63 | 1629600.0 |
| 2004-10-05 10:00:00 | IWM | ETF | 58.64 | 58.71 | 58.375 | 58.705 | 1814400.0 |
> showing 50 of 1,196 rows — these rows as CSV