PREVIEW / etf_30min / 2005-02-09
file: by_date/etf_30min/2005/2005-02-09.parquet size: 42 KB rows: 1,446
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-09 08:00:00 | SPY | ETF | 120.33 | 120.5 | 120.33 | 120.42 | 100900.0 |
| 2005-02-09 08:30:00 | SPY | ETF | 120.44 | 120.47 | 120.36 | 120.42 | 72700.0 |
| 2005-02-09 09:00:00 | SPY | ETF | 120.43 | 120.43 | 120.39 | 120.42 | 26300.0 |
| 2005-02-09 09:30:00 | SPY | ETF | 120.42 | 120.49 | 120.2 | 120.3 | 5082000.0 |
| 2005-02-09 10:00:00 | SPY | ETF | 120.29 | 120.43 | 119.72 | 119.82 | 8494600.0 |
| 2005-02-09 10:30:00 | SPY | ETF | 119.82 | 119.85 | 119.59 | 119.77 | 6102500.0 |
| 2005-02-09 11:00:00 | SPY | ETF | 119.78 | 119.83 | 119.66 | 119.72 | 2535000.0 |
| 2005-02-09 11:30:00 | SPY | ETF | 119.72 | 119.76 | 119.61 | 119.69 | 1583700.0 |
| 2005-02-09 12:00:00 | SPY | ETF | 119.69 | 119.77 | 119.68 | 119.71 | 1825000.0 |
| 2005-02-09 12:30:00 | SPY | ETF | 119.7 | 119.77 | 119.69 | 119.73 | 729300.0 |
| 2005-02-09 13:00:00 | SPY | ETF | 119.73 | 119.89 | 119.72 | 119.88 | 3236500.0 |
| 2005-02-09 13:30:00 | SPY | ETF | 119.88 | 119.95 | 119.79 | 119.81 | 2725200.0 |
| 2005-02-09 14:00:00 | SPY | ETF | 119.8 | 119.88 | 119.37 | 119.49 | 6265100.0 |
| 2005-02-09 14:30:00 | SPY | ETF | 119.5 | 119.61 | 119.48 | 119.5 | 3267400.0 |
| 2005-02-09 15:00:00 | SPY | ETF | 119.5 | 119.59 | 119.33 | 119.58 | 4566700.0 |
| 2005-02-09 15:30:00 | SPY | ETF | 119.57 | 119.65 | 119.25 | 119.3 | 4957400.0 |
| 2005-02-09 16:00:00 | SPY | ETF | 119.33 | 119.39 | 119.28 | 119.34 | 923600.0 |
| 2005-02-09 16:30:00 | SPY | ETF | 119.33 | 119.37 | 119.33 | 119.35 | 63900.0 |
| 2005-02-09 17:00:00 | SPY | ETF | 119.31 | 120.38 | 119.31 | 119.35 | 18500.0 |
| 2005-02-09 17:30:00 | SPY | ETF | 119.35 | 119.35 | 119.35 | 119.35 | 1100.0 |
| 2005-02-09 18:00:00 | SPY | ETF | 119.38 | 119.4 | 119.37 | 119.38 | 4000.0 |
| 2005-02-09 18:30:00 | SPY | ETF | 119.35 | 119.35 | 119.35 | 119.35 | 4500.0 |
| 2005-02-09 19:30:00 | SPY | ETF | 119.35 | 119.35 | 119.35 | 119.35 | 100.0 |
| 2005-02-09 09:30:00 | QQQ | ETF | 37.77 | 37.8 | 37.62 | 37.67 | 8541200.0 |
| 2005-02-09 10:00:00 | QQQ | ETF | 37.67 | 37.72 | 37.4 | 37.45 | 12013000.0 |
| 2005-02-09 10:30:00 | QQQ | ETF | 37.44 | 37.46 | 37.25 | 37.32 | 13256700.0 |
| 2005-02-09 11:00:00 | QQQ | ETF | 37.32 | 37.36 | 37.29 | 37.33 | 4216900.0 |
| 2005-02-09 11:30:00 | QQQ | ETF | 37.33 | 37.37 | 37.28 | 37.33 | 3113000.0 |
| 2005-02-09 12:00:00 | QQQ | ETF | 37.34 | 37.38 | 37.32 | 37.34 | 1850900.0 |
| 2005-02-09 12:30:00 | QQQ | ETF | 37.34 | 37.38 | 37.34 | 37.35 | 1475900.0 |
| 2005-02-09 13:00:00 | QQQ | ETF | 37.35 | 37.41 | 37.35 | 37.39 | 3253200.0 |
| 2005-02-09 13:30:00 | QQQ | ETF | 37.39 | 37.42 | 37.34 | 37.34 | 2873600.0 |
| 2005-02-09 14:00:00 | QQQ | ETF | 37.34 | 37.35 | 37.15 | 37.22 | 8742700.0 |
| 2005-02-09 14:30:00 | QQQ | ETF | 37.23 | 37.26 | 37.16 | 37.16 | 5022800.0 |
| 2005-02-09 15:00:00 | QQQ | ETF | 37.16 | 37.21 | 37.07 | 37.21 | 10325300.0 |
| 2005-02-09 15:30:00 | QQQ | ETF | 37.2 | 37.23 | 37.06 | 37.11 | 10719900.0 |
| 2005-02-09 08:30:00 | IWM | ETF | 63.67 | 63.67 | 63.67 | 63.67 | 4000.0 |
| 2005-02-09 09:00:00 | IWM | ETF | 63.635 | 63.7 | 63.635 | 63.7 | 34800.0 |
| 2005-02-09 09:30:00 | IWM | ETF | 63.74 | 63.75 | 63.41 | 63.435 | 1111800.0 |
| 2005-02-09 10:00:00 | IWM | ETF | 63.435 | 63.49 | 62.945 | 62.99 | 3434000.0 |
| 2005-02-09 10:30:00 | IWM | ETF | 62.985 | 63.05 | 62.83 | 62.94 | 3092800.0 |
| 2005-02-09 11:00:00 | IWM | ETF | 62.95 | 63.025 | 62.91 | 62.975 | 1470600.0 |
| 2005-02-09 11:30:00 | IWM | ETF | 62.975 | 63.01 | 62.885 | 62.925 | 642400.0 |
| 2005-02-09 12:00:00 | IWM | ETF | 62.925 | 63.0 | 62.905 | 62.925 | 1552000.0 |
| 2005-02-09 12:30:00 | IWM | ETF | 62.925 | 63.025 | 62.91 | 62.935 | 530200.0 |
| 2005-02-09 13:00:00 | IWM | ETF | 62.94 | 63.015 | 62.875 | 62.945 | 1141200.0 |
| 2005-02-09 13:30:00 | IWM | ETF | 62.94 | 62.995 | 62.895 | 62.915 | 696000.0 |
| 2005-02-09 14:00:00 | IWM | ETF | 62.915 | 62.92 | 62.66 | 62.715 | 3134200.0 |
| 2005-02-09 14:30:00 | IWM | ETF | 62.705 | 62.845 | 62.69 | 62.74 | 1288800.0 |
| 2005-02-09 15:00:00 | IWM | ETF | 62.735 | 62.75 | 62.565 | 62.6 | 3246400.0 |
> showing 50 of 1,446 rows — these rows as CSV