PREVIEW / etf_30min / 2005-02-15
file: by_date/etf_30min/2005/2005-02-15.parquet size: 42 KB rows: 1,464
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-02-15 08:00:00 | SPY | ETF | 120.9 | 120.91 | 120.9 | 120.91 | 52600.0 |
| 2005-02-15 08:30:00 | SPY | ETF | 120.92 | 120.94 | 120.86 | 120.88 | 128600.0 |
| 2005-02-15 09:00:00 | SPY | ETF | 120.89 | 120.89 | 120.81 | 120.81 | 28800.0 |
| 2005-02-15 09:30:00 | SPY | ETF | 120.8 | 120.87 | 120.68 | 120.82 | 3711100.0 |
| 2005-02-15 10:00:00 | SPY | ETF | 120.83 | 121.09 | 120.72 | 121.04 | 4212600.0 |
| 2005-02-15 10:30:00 | SPY | ETF | 121.04 | 121.36 | 121.04 | 121.32 | 6383700.0 |
| 2005-02-15 11:00:00 | SPY | ETF | 121.32 | 121.43 | 121.27 | 121.33 | 3114900.0 |
| 2005-02-15 11:30:00 | SPY | ETF | 121.33 | 121.35 | 121.24 | 121.27 | 1368100.0 |
| 2005-02-15 12:00:00 | SPY | ETF | 121.28 | 121.35 | 121.21 | 121.25 | 1537900.0 |
| 2005-02-15 12:30:00 | SPY | ETF | 121.27 | 121.35 | 121.23 | 121.25 | 1368100.0 |
| 2005-02-15 13:00:00 | SPY | ETF | 121.25 | 121.29 | 120.85 | 120.85 | 3726900.0 |
| 2005-02-15 13:30:00 | SPY | ETF | 120.86 | 120.97 | 120.76 | 120.91 | 4375400.0 |
| 2005-02-15 14:00:00 | SPY | ETF | 120.9 | 121.02 | 120.8 | 120.97 | 3862300.0 |
| 2005-02-15 14:30:00 | SPY | ETF | 120.99 | 121.08 | 120.9 | 121.03 | 2002700.0 |
| 2005-02-15 15:00:00 | SPY | ETF | 121.05 | 121.17 | 120.83 | 121.11 | 2397300.0 |
| 2005-02-15 15:30:00 | SPY | ETF | 121.11 | 121.24 | 121.09 | 121.19 | 3320500.0 |
| 2005-02-15 16:00:00 | SPY | ETF | 121.19 | 121.19 | 120.7913 | 121.17 | 1029000.0 |
| 2005-02-15 16:30:00 | SPY | ETF | 121.17 | 121.28 | 121.11 | 121.28 | 296800.0 |
| 2005-02-15 17:00:00 | SPY | ETF | 121.28 | 121.29 | 121.13 | 121.13 | 411700.0 |
| 2005-02-15 17:30:00 | SPY | ETF | 121.24 | 121.28 | 121.24 | 121.28 | 600.0 |
| 2005-02-15 18:00:00 | SPY | ETF | 121.24 | 121.24 | 121.23 | 121.24 | 15700.0 |
| 2005-02-15 18:30:00 | SPY | ETF | 121.22 | 121.22 | 121.19 | 121.19 | 300.0 |
| 2005-02-15 19:00:00 | SPY | ETF | 121.21 | 121.21 | 121.19 | 121.19 | 200.0 |
| 2005-02-15 09:30:00 | QQQ | ETF | 37.91 | 37.97 | 37.82 | 37.93 | 9676800.0 |
| 2005-02-15 10:00:00 | QQQ | ETF | 37.94 | 38.5 | 37.86 | 38.15 | 11845800.0 |
| 2005-02-15 10:30:00 | QQQ | ETF | 38.15 | 38.42 | 38.14 | 38.41 | 20784100.0 |
| 2005-02-15 11:00:00 | QQQ | ETF | 38.4 | 38.48 | 38.37 | 38.44 | 11536400.0 |
| 2005-02-15 11:30:00 | QQQ | ETF | 38.44 | 38.45 | 38.35 | 38.37 | 4521500.0 |
| 2005-02-15 12:00:00 | QQQ | ETF | 38.36 | 38.38 | 38.3 | 38.31 | 3440000.0 |
| 2005-02-15 12:30:00 | QQQ | ETF | 38.31 | 38.35 | 38.27 | 38.29 | 3696100.0 |
| 2005-02-15 13:00:00 | QQQ | ETF | 38.28 | 38.3 | 38.03 | 38.03 | 11288300.0 |
| 2005-02-15 13:30:00 | QQQ | ETF | 38.03 | 38.08 | 37.88 | 38.0 | 11740600.0 |
| 2005-02-15 14:00:00 | QQQ | ETF | 38.01 | 38.11 | 37.93 | 38.08 | 6154200.0 |
| 2005-02-15 14:30:00 | QQQ | ETF | 38.08 | 38.13 | 38.05 | 38.12 | 4243400.0 |
| 2005-02-15 15:00:00 | QQQ | ETF | 38.12 | 38.15 | 38.07 | 38.08 | 4832200.0 |
| 2005-02-15 15:30:00 | QQQ | ETF | 38.08 | 38.18 | 38.07 | 38.14 | 7448600.0 |
| 2005-02-15 08:00:00 | IWM | ETF | 63.365 | 63.365 | 63.365 | 63.365 | 800.0 |
| 2005-02-15 09:00:00 | IWM | ETF | 63.375 | 63.375 | 63.375 | 63.375 | 400.0 |
| 2005-02-15 09:30:00 | IWM | ETF | 63.325 | 63.395 | 63.245 | 63.365 | 1669800.0 |
| 2005-02-15 10:00:00 | IWM | ETF | 63.365 | 63.54 | 63.26 | 63.455 | 1439800.0 |
| 2005-02-15 10:30:00 | IWM | ETF | 63.47 | 63.68 | 63.47 | 63.63 | 947400.0 |
| 2005-02-15 11:00:00 | IWM | ETF | 63.635 | 63.675 | 63.58 | 63.615 | 501400.0 |
| 2005-02-15 11:30:00 | IWM | ETF | 63.62 | 63.645 | 63.555 | 63.605 | 647400.0 |
| 2005-02-15 12:00:00 | IWM | ETF | 63.615 | 63.635 | 63.56 | 63.595 | 129800.0 |
| 2005-02-15 12:30:00 | IWM | ETF | 63.605 | 63.615 | 63.515 | 63.52 | 218800.0 |
| 2005-02-15 13:00:00 | IWM | ETF | 63.52 | 63.525 | 63.24 | 63.25 | 1225200.0 |
| 2005-02-15 13:30:00 | IWM | ETF | 63.245 | 63.345 | 62.975 | 63.055 | 2319800.0 |
| 2005-02-15 14:00:00 | IWM | ETF | 63.05 | 63.15 | 62.915 | 63.03 | 2155000.0 |
| 2005-02-15 14:30:00 | IWM | ETF | 63.035 | 63.195 | 62.99 | 63.165 | 623600.0 |
| 2005-02-15 15:00:00 | IWM | ETF | 63.175 | 63.2 | 63.11 | 63.155 | 423600.0 |
> showing 50 of 1,464 rows — these rows as CSV