PREVIEW / etf_30min / 2005-03-09
file: by_date/etf_30min/2005/2005-03-09.parquet size: 45 KB rows: 1,501
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-03-09 08:00:00 | SPY | ETF | 122.13 | 122.14 | 121.7 | 121.83 | 265000.0 |
| 2005-03-09 08:30:00 | SPY | ETF | 121.8 | 121.92 | 121.76 | 121.91 | 265800.0 |
| 2005-03-09 09:00:00 | SPY | ETF | 121.92 | 121.96 | 121.88 | 121.96 | 151600.0 |
| 2005-03-09 09:30:00 | SPY | ETF | 121.97 | 122.16 | 121.79 | 121.82 | 7056600.0 |
| 2005-03-09 10:00:00 | SPY | ETF | 121.79 | 121.93 | 121.65 | 121.9 | 5963400.0 |
| 2005-03-09 10:30:00 | SPY | ETF | 121.9 | 122.29 | 121.69 | 122.09 | 8140500.0 |
| 2005-03-09 11:00:00 | SPY | ETF | 122.11 | 122.2 | 121.91 | 121.98 | 2367400.0 |
| 2005-03-09 11:30:00 | SPY | ETF | 121.98 | 122.1 | 121.93 | 121.94 | 1464800.0 |
| 2005-03-09 12:00:00 | SPY | ETF | 121.96 | 121.97 | 121.68 | 121.78 | 2497700.0 |
| 2005-03-09 12:30:00 | SPY | ETF | 121.78 | 121.96 | 121.35 | 121.35 | 8227500.0 |
| 2005-03-09 13:00:00 | SPY | ETF | 121.37 | 121.72 | 121.34 | 121.57 | 5305600.0 |
| 2005-03-09 13:30:00 | SPY | ETF | 121.59 | 121.63 | 121.44 | 121.59 | 2015800.0 |
| 2005-03-09 14:00:00 | SPY | ETF | 121.6 | 121.84 | 121.34 | 121.48 | 4749200.0 |
| 2005-03-09 14:30:00 | SPY | ETF | 121.47 | 121.66 | 121.44 | 121.54 | 3809600.0 |
| 2005-03-09 15:00:00 | SPY | ETF | 121.56 | 121.59 | 121.22 | 121.41 | 4713400.0 |
| 2005-03-09 15:30:00 | SPY | ETF | 121.42 | 121.59 | 120.98 | 121.03 | 10896600.0 |
| 2005-03-09 16:00:00 | SPY | ETF | 121.0 | 121.07 | 120.96 | 120.97 | 1069100.0 |
| 2005-03-09 16:30:00 | SPY | ETF | 120.99 | 121.08 | 120.99 | 121.03 | 89500.0 |
| 2005-03-09 17:00:00 | SPY | ETF | 122.15 | 122.15 | 121.0 | 121.03 | 41600.0 |
| 2005-03-09 18:00:00 | SPY | ETF | 121.03 | 121.07 | 121.03 | 121.07 | 3300.0 |
| 2005-03-09 18:30:00 | SPY | ETF | 121.06 | 121.06 | 121.06 | 121.06 | 100.0 |
| 2005-03-09 19:00:00 | SPY | ETF | 121.02 | 121.06 | 121.02 | 121.06 | 1700.0 |
| 2005-03-09 19:30:00 | SPY | ETF | 121.06 | 121.08 | 121.06 | 121.08 | 2400.0 |
| 2005-03-09 09:30:00 | QQQ | ETF | 37.67 | 37.76 | 37.58 | 37.59 | 10931000.0 |
| 2005-03-09 10:00:00 | QQQ | ETF | 37.59 | 37.72 | 37.56 | 37.72 | 7837400.0 |
| 2005-03-09 10:30:00 | QQQ | ETF | 37.71 | 37.93 | 37.69 | 37.83 | 13826600.0 |
| 2005-03-09 11:00:00 | QQQ | ETF | 37.84 | 37.89 | 37.76 | 37.81 | 4770500.0 |
| 2005-03-09 11:30:00 | QQQ | ETF | 37.8 | 37.86 | 37.78 | 37.81 | 3377300.0 |
| 2005-03-09 12:00:00 | QQQ | ETF | 37.81 | 37.81 | 37.62 | 37.64 | 4974900.0 |
| 2005-03-09 12:30:00 | QQQ | ETF | 37.65 | 37.71 | 37.5 | 37.53 | 11164000.0 |
| 2005-03-09 13:00:00 | QQQ | ETF | 37.52 | 37.6 | 37.51 | 37.55 | 5427300.0 |
| 2005-03-09 13:30:00 | QQQ | ETF | 37.55 | 37.66 | 37.52 | 37.65 | 4924900.0 |
| 2005-03-09 14:00:00 | QQQ | ETF | 37.65 | 37.72 | 37.53 | 37.61 | 4255800.0 |
| 2005-03-09 14:30:00 | QQQ | ETF | 37.61 | 37.72 | 37.6 | 37.67 | 4206500.0 |
| 2005-03-09 15:00:00 | QQQ | ETF | 37.67 | 37.71 | 37.57 | 37.69 | 5335100.0 |
| 2005-03-09 15:30:00 | QQQ | ETF | 37.7 | 37.7 | 37.47 | 37.57 | 9749100.0 |
| 2005-03-09 08:00:00 | IWM | ETF | 63.5 | 63.5 | 63.3 | 63.3 | 3800.0 |
| 2005-03-09 08:30:00 | IWM | ETF | 63.335 | 63.335 | 63.335 | 63.335 | 1200.0 |
| 2005-03-09 09:00:00 | IWM | ETF | 63.38 | 63.39 | 63.375 | 63.375 | 38600.0 |
| 2005-03-09 09:30:00 | IWM | ETF | 63.435 | 63.505 | 63.055 | 63.06 | 2679400.0 |
| 2005-03-09 10:00:00 | IWM | ETF | 63.05 | 63.15 | 62.92 | 63.15 | 1976600.0 |
| 2005-03-09 10:30:00 | IWM | ETF | 63.105 | 63.495 | 63.09 | 63.4 | 3137600.0 |
| 2005-03-09 11:00:00 | IWM | ETF | 63.4 | 63.57 | 63.31 | 63.445 | 2030000.0 |
| 2005-03-09 11:30:00 | IWM | ETF | 63.45 | 63.505 | 63.37 | 63.405 | 815600.0 |
| 2005-03-09 12:00:00 | IWM | ETF | 63.405 | 63.435 | 63.25 | 63.31 | 2520000.0 |
| 2005-03-09 12:30:00 | IWM | ETF | 63.325 | 63.395 | 63.075 | 63.105 | 1645000.0 |
| 2005-03-09 13:00:00 | IWM | ETF | 63.08 | 63.25 | 63.08 | 63.22 | 379200.0 |
| 2005-03-09 13:30:00 | IWM | ETF | 63.205 | 63.3 | 63.155 | 63.28 | 749800.0 |
| 2005-03-09 14:00:00 | IWM | ETF | 63.28 | 63.43 | 63.16 | 63.255 | 1181200.0 |
| 2005-03-09 14:30:00 | IWM | ETF | 63.26 | 63.395 | 63.24 | 63.33 | 1003800.0 |
> showing 50 of 1,501 rows — these rows as CSV