PREVIEW / etf_30min / 2005-02-25
file: by_date/etf_30min/2005/2005-02-25.parquet size: 44 KB rows: 1,467
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-25 08:00:00 | SPY | ETF | 120.41 | 120.41 | 120.35 | 120.4 | 5700.0 |
| 2005-02-25 08:30:00 | SPY | ETF | 120.38 | 120.46 | 120.26 | 120.27 | 62600.0 |
| 2005-02-25 09:00:00 | SPY | ETF | 120.29 | 120.31 | 120.25 | 120.29 | 66800.0 |
| 2005-02-25 09:30:00 | SPY | ETF | 120.27 | 120.43 | 120.18 | 120.27 | 6656100.0 |
| 2005-02-25 10:00:00 | SPY | ETF | 120.28 | 120.49 | 120.18 | 120.47 | 6414400.0 |
| 2005-02-25 10:30:00 | SPY | ETF | 120.49 | 120.7 | 120.35 | 120.7 | 4225600.0 |
| 2005-02-25 11:00:00 | SPY | ETF | 120.64 | 120.98 | 120.61 | 120.87 | 7608300.0 |
| 2005-02-25 11:30:00 | SPY | ETF | 120.87 | 121.27 | 120.83 | 121.17 | 4003800.0 |
| 2005-02-25 12:00:00 | SPY | ETF | 121.171 | 121.26 | 121.06 | 121.15 | 2642300.0 |
| 2005-02-25 12:30:00 | SPY | ETF | 121.15 | 121.23 | 121.03 | 121.05 | 2885900.0 |
| 2005-02-25 13:00:00 | SPY | ETF | 121.05 | 121.12 | 120.93 | 120.95 | 1753600.0 |
| 2005-02-25 13:30:00 | SPY | ETF | 120.95 | 121.17 | 120.93 | 121.15 | 2321600.0 |
| 2005-02-25 14:00:00 | SPY | ETF | 121.15 | 121.44 | 121.09 | 121.3 | 6486200.0 |
| 2005-02-25 14:30:00 | SPY | ETF | 121.3 | 121.43 | 121.12 | 121.23 | 3083000.0 |
| 2005-02-25 15:00:00 | SPY | ETF | 121.23 | 121.46 | 121.2 | 121.38 | 2838900.0 |
| 2005-02-25 15:30:00 | SPY | ETF | 121.38 | 121.67 | 121.25 | 121.38 | 4928200.0 |
| 2005-02-25 16:00:00 | SPY | ETF | 121.39 | 121.49 | 121.33 | 121.38 | 3198000.0 |
| 2005-02-25 16:30:00 | SPY | ETF | 121.38 | 121.41 | 121.29 | 121.37 | 264500.0 |
| 2005-02-25 17:00:00 | SPY | ETF | 121.35 | 121.36 | 121.34 | 121.34 | 3500.0 |
| 2005-02-25 17:30:00 | SPY | ETF | 121.38 | 121.38 | 121.38 | 121.38 | 900.0 |
| 2005-02-25 18:00:00 | SPY | ETF | 121.38 | 121.38 | 121.36 | 121.38 | 3400.0 |
| 2005-02-25 18:30:00 | SPY | ETF | 121.38 | 121.4 | 121.38 | 121.4 | 1300.0 |
| 2005-02-25 09:30:00 | QQQ | ETF | 37.36 | 37.49 | 37.32 | 37.35 | 11262100.0 |
| 2005-02-25 10:00:00 | QQQ | ETF | 37.35 | 37.44 | 37.3 | 37.39 | 6486800.0 |
| 2005-02-25 10:30:00 | QQQ | ETF | 37.39 | 37.49 | 37.29 | 37.49 | 4959900.0 |
| 2005-02-25 11:00:00 | QQQ | ETF | 37.5 | 37.55 | 37.43 | 37.46 | 8156800.0 |
| 2005-02-25 11:30:00 | QQQ | ETF | 37.46 | 37.68 | 37.45 | 37.63 | 5905200.0 |
| 2005-02-25 12:00:00 | QQQ | ETF | 37.63 | 37.66 | 37.57 | 37.6 | 3662500.0 |
| 2005-02-25 12:30:00 | QQQ | ETF | 37.6 | 37.66 | 37.51 | 37.52 | 3454400.0 |
| 2005-02-25 13:00:00 | QQQ | ETF | 37.53 | 37.58 | 37.44 | 37.45 | 4114100.0 |
| 2005-02-25 13:30:00 | QQQ | ETF | 37.45 | 37.56 | 37.43 | 37.52 | 4902100.0 |
| 2005-02-25 14:00:00 | QQQ | ETF | 37.52 | 37.65 | 37.51 | 37.56 | 3628900.0 |
| 2005-02-25 14:30:00 | QQQ | ETF | 37.56 | 37.63 | 37.49 | 37.53 | 3619500.0 |
| 2005-02-25 15:00:00 | QQQ | ETF | 37.52 | 37.65 | 37.5 | 37.63 | 3922100.0 |
| 2005-02-25 15:30:00 | QQQ | ETF | 37.62 | 37.67 | 37.58 | 37.63 | 8402500.0 |
| 2005-02-25 08:00:00 | IWM | ETF | 62.625 | 62.66 | 62.625 | 62.66 | 22000.0 |
| 2005-02-25 08:30:00 | IWM | ETF | 62.65 | 62.65 | 62.635 | 62.635 | 3600.0 |
| 2005-02-25 09:00:00 | IWM | ETF | 62.52 | 62.525 | 62.46 | 62.46 | 26400.0 |
| 2005-02-25 09:30:00 | IWM | ETF | 62.4 | 62.72 | 62.4 | 62.525 | 2704000.0 |
| 2005-02-25 10:00:00 | IWM | ETF | 62.505 | 62.69 | 62.405 | 62.685 | 3389200.0 |
| 2005-02-25 10:30:00 | IWM | ETF | 62.695 | 62.875 | 62.62 | 62.865 | 1758600.0 |
| 2005-02-25 11:00:00 | IWM | ETF | 62.9 | 63.0 | 62.85 | 62.99 | 2943400.0 |
| 2005-02-25 11:30:00 | IWM | ETF | 62.99 | 63.22 | 62.965 | 63.16 | 1934200.0 |
| 2005-02-25 12:00:00 | IWM | ETF | 63.165 | 63.2 | 63.11 | 63.17 | 922800.0 |
| 2005-02-25 12:30:00 | IWM | ETF | 63.17 | 63.25 | 63.115 | 63.12 | 780000.0 |
| 2005-02-25 13:00:00 | IWM | ETF | 63.125 | 63.15 | 62.98 | 62.98 | 583400.0 |
| 2005-02-25 13:30:00 | IWM | ETF | 62.985 | 63.2 | 62.98 | 63.12 | 874200.0 |
| 2005-02-25 14:00:00 | IWM | ETF | 63.12 | 63.325 | 63.105 | 63.305 | 1430800.0 |
| 2005-02-25 14:30:00 | IWM | ETF | 63.305 | 63.385 | 63.225 | 63.275 | 1651200.0 |
| 2005-02-25 15:00:00 | IWM | ETF | 63.265 | 63.435 | 63.225 | 63.4 | 1703600.0 |
> showing 50 of 1,467 rows — these rows as CSV