PREVIEW / etf_30min / 2005-03-15
file: by_date/etf_30min/2005/2005-03-15.parquet size: 45 KB rows: 1,488
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-15 08:00:00 | SPY | ETF | 121.2 | 121.37 | 121.2 | 121.31 | 42100.0 |
| 2005-03-15 08:30:00 | SPY | ETF | 121.33 | 121.38 | 121.3 | 121.35 | 51900.0 |
| 2005-03-15 09:00:00 | SPY | ETF | 121.36 | 121.52 | 121.36 | 121.41 | 187400.0 |
| 2005-03-15 09:30:00 | SPY | ETF | 121.42 | 121.46 | 121.27 | 121.36 | 4121600.0 |
| 2005-03-15 10:00:00 | SPY | ETF | 121.35 | 121.37 | 121.1 | 121.19 | 3645200.0 |
| 2005-03-15 10:30:00 | SPY | ETF | 121.19 | 121.37 | 121.12 | 121.34 | 2709800.0 |
| 2005-03-15 11:00:00 | SPY | ETF | 121.34 | 121.36 | 121.14 | 121.17 | 1995400.0 |
| 2005-03-15 11:30:00 | SPY | ETF | 121.15 | 121.2 | 120.68 | 120.72 | 11426600.0 |
| 2005-03-15 12:00:00 | SPY | ETF | 120.72 | 120.81 | 120.56 | 120.74 | 8634000.0 |
| 2005-03-15 12:30:00 | SPY | ETF | 120.74 | 120.86 | 120.65 | 120.79 | 2343600.0 |
| 2005-03-15 13:00:00 | SPY | ETF | 120.79 | 120.83 | 120.52 | 120.57 | 2001500.0 |
| 2005-03-15 13:30:00 | SPY | ETF | 120.57 | 120.58 | 120.36 | 120.56 | 4610300.0 |
| 2005-03-15 14:00:00 | SPY | ETF | 120.57 | 120.72 | 120.41 | 120.51 | 3637400.0 |
| 2005-03-15 14:30:00 | SPY | ETF | 120.52 | 120.7 | 120.31 | 120.51 | 4170700.0 |
| 2005-03-15 15:00:00 | SPY | ETF | 120.54 | 120.61 | 120.35 | 120.36 | 2088200.0 |
| 2005-03-15 15:30:00 | SPY | ETF | 120.35 | 120.45 | 120.13 | 120.17 | 4990000.0 |
| 2005-03-15 16:00:00 | SPY | ETF | 120.17 | 120.27 | 120.09 | 120.19 | 1545900.0 |
| 2005-03-15 16:30:00 | SPY | ETF | 120.16 | 120.18 | 120.12 | 120.16 | 72100.0 |
| 2005-03-15 17:00:00 | SPY | ETF | 120.16 | 120.16 | 120.11 | 120.13 | 3900.0 |
| 2005-03-15 17:30:00 | SPY | ETF | 120.14 | 120.15 | 120.09 | 120.09 | 13600.0 |
| 2005-03-15 18:00:00 | SPY | ETF | 120.09 | 120.14 | 120.09 | 120.13 | 5500.0 |
| 2005-03-15 18:30:00 | SPY | ETF | 120.1 | 120.18 | 120.1 | 120.18 | 19900.0 |
| 2005-03-15 19:00:00 | SPY | ETF | 120.13 | 120.14 | 120.13 | 120.14 | 2000.0 |
| 2005-03-15 19:30:00 | SPY | ETF | 120.14 | 120.14 | 120.14 | 120.14 | 1000.0 |
| 2005-03-15 09:30:00 | QQQ | ETF | 37.44 | 37.48 | 37.33 | 37.37 | 13029200.0 |
| 2005-03-15 10:00:00 | QQQ | ETF | 37.38 | 37.38 | 37.17 | 37.2 | 12947600.0 |
| 2005-03-15 10:30:00 | QQQ | ETF | 37.2 | 37.27 | 37.14 | 37.24 | 6336100.0 |
| 2005-03-15 11:00:00 | QQQ | ETF | 37.25 | 37.28 | 37.18 | 37.18 | 3569700.0 |
| 2005-03-15 11:30:00 | QQQ | ETF | 37.18 | 37.2 | 37.04 | 37.06 | 7901300.0 |
| 2005-03-15 12:00:00 | QQQ | ETF | 37.06 | 37.1 | 37.0 | 37.08 | 5858000.0 |
| 2005-03-15 12:30:00 | QQQ | ETF | 37.08 | 37.14 | 37.05 | 37.12 | 2776600.0 |
| 2005-03-15 13:00:00 | QQQ | ETF | 37.12 | 37.17 | 37.05 | 37.07 | 4835500.0 |
| 2005-03-15 13:30:00 | QQQ | ETF | 37.07 | 37.1 | 36.99 | 37.08 | 4583600.0 |
| 2005-03-15 14:00:00 | QQQ | ETF | 37.08 | 37.14 | 37.02 | 37.08 | 3255300.0 |
| 2005-03-15 14:30:00 | QQQ | ETF | 37.08 | 37.12 | 36.99 | 37.05 | 6004500.0 |
| 2005-03-15 15:00:00 | QQQ | ETF | 37.06 | 37.1 | 37.01 | 37.04 | 6331300.0 |
| 2005-03-15 15:30:00 | QQQ | ETF | 37.04 | 37.07 | 36.99 | 37.03 | 11808100.0 |
| 2005-03-15 08:30:00 | IWM | ETF | 63.155 | 63.155 | 63.155 | 63.155 | 200.0 |
| 2005-03-15 09:00:00 | IWM | ETF | 63.185 | 63.27 | 63.185 | 63.225 | 3800.0 |
| 2005-03-15 09:30:00 | IWM | ETF | 63.265 | 63.41 | 63.225 | 63.34 | 2760800.0 |
| 2005-03-15 10:00:00 | IWM | ETF | 63.335 | 63.335 | 63.085 | 63.135 | 1691600.0 |
| 2005-03-15 10:30:00 | IWM | ETF | 63.14 | 63.325 | 63.08 | 63.295 | 668600.0 |
| 2005-03-15 11:00:00 | IWM | ETF | 63.29 | 63.295 | 63.15 | 63.195 | 562200.0 |
| 2005-03-15 11:30:00 | IWM | ETF | 63.175 | 63.21 | 62.945 | 63.0 | 1462800.0 |
| 2005-03-15 12:00:00 | IWM | ETF | 62.99 | 63.025 | 62.88 | 62.99 | 540800.0 |
| 2005-03-15 12:30:00 | IWM | ETF | 62.985 | 63.07 | 62.95 | 62.985 | 433800.0 |
| 2005-03-15 13:00:00 | IWM | ETF | 62.985 | 63.035 | 62.86 | 62.865 | 1102000.0 |
| 2005-03-15 13:30:00 | IWM | ETF | 62.85 | 62.865 | 62.61 | 62.685 | 719400.0 |
| 2005-03-15 14:00:00 | IWM | ETF | 62.69 | 62.76 | 62.5 | 62.6 | 903800.0 |
| 2005-03-15 14:30:00 | IWM | ETF | 62.59 | 62.68 | 62.465 | 62.57 | 1908800.0 |
> showing 50 of 1,488 rows — these rows as CSV