PREVIEW / etf_30min / 2005-02-28
file: by_date/etf_30min/2005/2005-02-28.parquet size: 44 KB rows: 1,428
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-28 08:00:00 | SPY | ETF | 121.45 | 121.45 | 121.35 | 121.36 | 49100.0 |
| 2005-02-28 08:30:00 | SPY | ETF | 121.3 | 121.31 | 121.14 | 121.18 | 130700.0 |
| 2005-02-28 09:00:00 | SPY | ETF | 121.16 | 121.21 | 121.15 | 121.17 | 147400.0 |
| 2005-02-28 09:30:00 | SPY | ETF | 121.15 | 121.24 | 121.04 | 121.14 | 6044100.0 |
| 2005-02-28 10:00:00 | SPY | ETF | 121.13 | 121.22 | 120.97 | 121.12 | 4731500.0 |
| 2005-02-28 10:30:00 | SPY | ETF | 121.13 | 121.3 | 121.08 | 121.22 | 5885200.0 |
| 2005-02-28 11:00:00 | SPY | ETF | 121.22 | 121.26 | 121.0 | 121.04 | 1686900.0 |
| 2005-02-28 11:30:00 | SPY | ETF | 121.04 | 121.1 | 120.84 | 120.86 | 5735500.0 |
| 2005-02-28 12:00:00 | SPY | ETF | 120.85 | 120.87 | 120.31 | 120.32 | 8201800.0 |
| 2005-02-28 12:30:00 | SPY | ETF | 120.33 | 120.65 | 120.28 | 120.45 | 3683200.0 |
| 2005-02-28 13:00:00 | SPY | ETF | 120.44 | 120.51 | 120.33 | 120.44 | 2735400.0 |
| 2005-02-28 13:30:00 | SPY | ETF | 120.45 | 120.49 | 120.2 | 120.23 | 3753500.0 |
| 2005-02-28 14:00:00 | SPY | ETF | 120.23 | 120.44 | 120.05 | 120.37 | 4901100.0 |
| 2005-02-28 14:30:00 | SPY | ETF | 120.35 | 120.61 | 120.32 | 120.59 | 3658500.0 |
| 2005-02-28 15:00:00 | SPY | ETF | 120.58 | 120.93 | 120.53 | 120.76 | 4685200.0 |
| 2005-02-28 15:30:00 | SPY | ETF | 120.77 | 121.04 | 120.53 | 120.53 | 8606800.0 |
| 2005-02-28 16:00:00 | SPY | ETF | 120.48 | 120.8 | 120.48 | 120.68 | 2929700.0 |
| 2005-02-28 16:30:00 | SPY | ETF | 120.68 | 120.71 | 120.66 | 120.67 | 28300.0 |
| 2005-02-28 17:00:00 | SPY | ETF | 120.68 | 120.68 | 120.65 | 120.65 | 18300.0 |
| 2005-02-28 17:30:00 | SPY | ETF | 120.64 | 120.64 | 120.64 | 120.64 | 1300.0 |
| 2005-02-28 18:00:00 | SPY | ETF | 120.65 | 120.65 | 120.63 | 120.63 | 5400.0 |
| 2005-02-28 19:30:00 | SPY | ETF | 120.64 | 120.64 | 120.64 | 120.64 | 1000.0 |
| 2005-02-28 09:30:00 | QQQ | ETF | 37.47 | 37.6 | 37.42 | 37.49 | 10547700.0 |
| 2005-02-28 10:00:00 | QQQ | ETF | 37.49 | 37.52 | 37.33 | 37.45 | 7332300.0 |
| 2005-02-28 10:30:00 | QQQ | ETF | 37.45 | 37.59 | 37.43 | 37.52 | 5601500.0 |
| 2005-02-28 11:00:00 | QQQ | ETF | 37.52 | 37.52 | 37.33 | 37.39 | 3867600.0 |
| 2005-02-28 11:30:00 | QQQ | ETF | 37.39 | 39.39 | 37.28 | 37.33 | 6021800.0 |
| 2005-02-28 12:00:00 | QQQ | ETF | 37.33 | 37.33 | 37.05 | 37.07 | 10780700.0 |
| 2005-02-28 12:30:00 | QQQ | ETF | 37.07 | 37.14 | 37.03 | 37.11 | 5587100.0 |
| 2005-02-28 13:00:00 | QQQ | ETF | 37.12 | 37.14 | 37.04 | 37.09 | 4827800.0 |
| 2005-02-28 13:30:00 | QQQ | ETF | 37.09 | 37.12 | 36.97 | 37.01 | 6547600.0 |
| 2005-02-28 14:00:00 | QQQ | ETF | 37.01 | 37.43 | 36.92 | 37.07 | 5724300.0 |
| 2005-02-28 14:30:00 | QQQ | ETF | 37.08 | 37.21 | 37.05 | 37.18 | 7234700.0 |
| 2005-02-28 15:00:00 | QQQ | ETF | 37.18 | 37.29 | 37.15 | 37.21 | 6032900.0 |
| 2005-02-28 15:30:00 | QQQ | ETF | 37.21 | 37.32 | 37.2 | 37.23 | 8558200.0 |
| 2005-02-28 09:00:00 | IWM | ETF | 63.45 | 63.5 | 63.425 | 63.46 | 49200.0 |
| 2005-02-28 09:30:00 | IWM | ETF | 63.45 | 63.58 | 63.34 | 63.49 | 2368200.0 |
| 2005-02-28 10:00:00 | IWM | ETF | 63.475 | 63.525 | 63.265 | 63.435 | 1326000.0 |
| 2005-02-28 10:30:00 | IWM | ETF | 63.435 | 63.635 | 63.415 | 63.58 | 1030200.0 |
| 2005-02-28 11:00:00 | IWM | ETF | 63.57 | 63.59 | 63.34 | 63.385 | 510200.0 |
| 2005-02-28 11:30:00 | IWM | ETF | 63.375 | 63.465 | 63.17 | 63.192 | 1037400.0 |
| 2005-02-28 12:00:00 | IWM | ETF | 63.185 | 63.37 | 62.825 | 62.86 | 2447600.0 |
| 2005-02-28 12:30:00 | IWM | ETF | 62.865 | 63.01 | 62.845 | 63.01 | 911600.0 |
| 2005-02-28 13:00:00 | IWM | ETF | 63.01 | 63.015 | 62.895 | 62.95 | 745000.0 |
| 2005-02-28 13:30:00 | IWM | ETF | 62.94 | 62.98 | 62.675 | 62.725 | 1936000.0 |
| 2005-02-28 14:00:00 | IWM | ETF | 62.72 | 62.845 | 62.675 | 62.765 | 550800.0 |
| 2005-02-28 14:30:00 | IWM | ETF | 62.76 | 63.0 | 62.73 | 62.985 | 1038400.0 |
| 2005-02-28 15:00:00 | IWM | ETF | 62.985 | 63.25 | 62.95 | 63.125 | 1510200.0 |
| 2005-02-28 15:30:00 | IWM | ETF | 63.12 | 63.355 | 63.038 | 63.07 | 1880600.0 |
| 2005-02-28 16:00:00 | IWM | ETF | 63.075 | 63.175 | 63.045 | 63.14 | 648400.0 |
> showing 50 of 1,428 rows — these rows as CSV