PREVIEW / etf_30min / 2005-02-17
file: by_date/etf_30min/2005/2005-02-17.parquet size: 42 KB rows: 1,435
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-17 08:00:00 | SPY | ETF | 121.26 | 121.32 | 121.24 | 121.32 | 19100.0 |
| 2005-02-17 08:30:00 | SPY | ETF | 121.26 | 121.27 | 121.25 | 121.25 | 14100.0 |
| 2005-02-17 09:00:00 | SPY | ETF | 121.25 | 121.29 | 121.23 | 121.23 | 18900.0 |
| 2005-02-17 09:30:00 | SPY | ETF | 121.23 | 121.33 | 121.16 | 121.19 | 4642600.0 |
| 2005-02-17 10:00:00 | SPY | ETF | 121.2 | 121.32 | 120.67 | 120.72 | 10140400.0 |
| 2005-02-17 10:30:00 | SPY | ETF | 120.71 | 120.83 | 120.44 | 120.63 | 7053500.0 |
| 2005-02-17 11:00:00 | SPY | ETF | 120.64 | 120.73 | 120.51 | 120.72 | 4551400.0 |
| 2005-02-17 11:30:00 | SPY | ETF | 120.72 | 120.75 | 120.58 | 120.65 | 1476900.0 |
| 2005-02-17 12:00:00 | SPY | ETF | 120.64 | 120.88 | 120.64 | 120.79 | 2274800.0 |
| 2005-02-17 12:30:00 | SPY | ETF | 120.79 | 120.85 | 120.71 | 120.85 | 1644100.0 |
| 2005-02-17 13:00:00 | SPY | ETF | 120.82 | 120.93 | 120.67 | 120.68 | 1996000.0 |
| 2005-02-17 13:30:00 | SPY | ETF | 120.69 | 120.77 | 120.6 | 120.63 | 1235700.0 |
| 2005-02-17 14:00:00 | SPY | ETF | 120.64 | 120.73 | 120.49 | 120.71 | 3323100.0 |
| 2005-02-17 14:30:00 | SPY | ETF | 120.7 | 120.72 | 120.31 | 120.37 | 5354700.0 |
| 2005-02-17 15:00:00 | SPY | ETF | 120.36 | 120.5 | 120.29 | 120.42 | 4646700.0 |
| 2005-02-17 15:30:00 | SPY | ETF | 120.41 | 120.6 | 120.24 | 120.28 | 6192800.0 |
| 2005-02-17 16:00:00 | SPY | ETF | 120.25 | 120.31 | 120.2 | 120.25 | 1877500.0 |
| 2005-02-17 16:30:00 | SPY | ETF | 120.25 | 120.25 | 120.2 | 120.23 | 314000.0 |
| 2005-02-17 17:00:00 | SPY | ETF | 120.23 | 120.24 | 120.19 | 120.19 | 5500.0 |
| 2005-02-17 17:30:00 | SPY | ETF | 120.18 | 120.24 | 120.18 | 120.18 | 10900.0 |
| 2005-02-17 18:00:00 | SPY | ETF | 120.23 | 120.24 | 120.23 | 120.23 | 13000.0 |
| 2005-02-17 18:30:00 | SPY | ETF | 120.26 | 120.26 | 120.26 | 120.26 | 300.0 |
| 2005-02-17 19:30:00 | SPY | ETF | 120.27 | 120.27 | 120.27 | 120.27 | 300.0 |
| 2005-02-17 09:30:00 | QQQ | ETF | 38.06 | 38.14 | 37.98 | 38.03 | 6492100.0 |
| 2005-02-17 10:00:00 | QQQ | ETF | 38.04 | 38.06 | 37.7 | 37.71 | 15106600.0 |
| 2005-02-17 10:30:00 | QQQ | ETF | 37.71 | 37.72 | 37.56 | 37.69 | 13187400.0 |
| 2005-02-17 11:00:00 | QQQ | ETF | 37.69 | 37.75 | 37.62 | 37.74 | 6655800.0 |
| 2005-02-17 11:30:00 | QQQ | ETF | 37.74 | 37.78 | 37.7 | 37.75 | 2817200.0 |
| 2005-02-17 12:00:00 | QQQ | ETF | 37.75 | 37.81 | 37.73 | 37.76 | 2692000.0 |
| 2005-02-17 12:30:00 | QQQ | ETF | 37.75 | 37.78 | 37.7 | 37.75 | 3552700.0 |
| 2005-02-17 13:00:00 | QQQ | ETF | 37.75 | 37.81 | 37.68 | 37.69 | 4559600.0 |
| 2005-02-17 13:30:00 | QQQ | ETF | 37.69 | 37.75 | 37.63 | 37.65 | 5267700.0 |
| 2005-02-17 14:00:00 | QQQ | ETF | 37.64 | 37.71 | 37.56 | 37.64 | 6184700.0 |
| 2005-02-17 14:30:00 | QQQ | ETF | 37.65 | 37.66 | 37.43 | 37.47 | 8028100.0 |
| 2005-02-17 15:00:00 | QQQ | ETF | 37.47 | 37.54 | 37.44 | 37.49 | 7229100.0 |
| 2005-02-17 15:30:00 | QQQ | ETF | 37.49 | 37.61 | 37.44 | 37.45 | 11040800.0 |
| 2005-02-17 08:30:00 | IWM | ETF | 63.55 | 63.565 | 63.545 | 63.565 | 4000.0 |
| 2005-02-17 09:30:00 | IWM | ETF | 63.7 | 63.835 | 63.6 | 63.775 | 2201800.0 |
| 2005-02-17 10:00:00 | IWM | ETF | 63.755 | 63.785 | 63.305 | 63.35 | 2464800.0 |
| 2005-02-17 10:30:00 | IWM | ETF | 63.335 | 63.34 | 62.99 | 63.205 | 2155400.0 |
| 2005-02-17 11:00:00 | IWM | ETF | 63.215 | 63.275 | 63.055 | 63.255 | 2231800.0 |
| 2005-02-17 11:30:00 | IWM | ETF | 63.265 | 63.315 | 63.125 | 63.22 | 368600.0 |
| 2005-02-17 12:00:00 | IWM | ETF | 63.215 | 63.425 | 63.215 | 63.37 | 1523400.0 |
| 2005-02-17 12:30:00 | IWM | ETF | 63.37 | 63.48 | 63.325 | 63.48 | 231600.0 |
| 2005-02-17 13:00:00 | IWM | ETF | 63.475 | 63.52 | 63.285 | 63.33 | 551400.0 |
| 2005-02-17 13:30:00 | IWM | ETF | 63.355 | 63.405 | 63.22 | 63.275 | 542400.0 |
| 2005-02-17 14:00:00 | IWM | ETF | 63.265 | 63.41 | 63.145 | 63.345 | 525200.0 |
| 2005-02-17 14:30:00 | IWM | ETF | 63.345 | 63.35 | 63.025 | 63.03 | 949200.0 |
| 2005-02-17 15:00:00 | IWM | ETF | 63.025 | 63.08 | 62.925 | 62.99 | 1648000.0 |
| 2005-02-17 15:30:00 | IWM | ETF | 62.985 | 63.075 | 62.875 | 62.93 | 1253200.0 |
> showing 50 of 1,435 rows — these rows as CSV