PREVIEW / etf_30min / 2005-06-07
file: by_date/etf_30min/2005/2005-06-07.parquet size: 45 KB rows: 1,527
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-06-07 06:00:00 | SPY | ETF | 120.32 | 120.33 | 120.32 | 120.33 | 1000.0 |
| 2005-06-07 07:00:00 | SPY | ETF | 120.25 | 120.4 | 120.25 | 120.37 | 86400.0 |
| 2005-06-07 07:30:00 | SPY | ETF | 120.37 | 120.42 | 120.37 | 120.41 | 92200.0 |
| 2005-06-07 08:00:00 | SPY | ETF | 120.39 | 120.45 | 120.36 | 120.41 | 220800.0 |
| 2005-06-07 08:30:00 | SPY | ETF | 120.41 | 120.44 | 120.4 | 120.41 | 63700.0 |
| 2005-06-07 09:00:00 | SPY | ETF | 120.41 | 120.45 | 120.36 | 120.37 | 64400.0 |
| 2005-06-07 09:30:00 | SPY | ETF | 120.39 | 120.84 | 120.32 | 120.78 | 7301700.0 |
| 2005-06-07 10:00:00 | SPY | ETF | 120.77 | 121.25 | 120.73 | 121.14 | 7661500.0 |
| 2005-06-07 10:30:00 | SPY | ETF | 121.16 | 121.23 | 121.0 | 121.12 | 4660400.0 |
| 2005-06-07 11:00:00 | SPY | ETF | 121.09 | 121.18 | 121.0 | 121.06 | 2474100.0 |
| 2005-06-07 11:30:00 | SPY | ETF | 121.07 | 121.25 | 121.05 | 121.21 | 2477400.0 |
| 2005-06-07 12:00:00 | SPY | ETF | 121.21 | 121.24 | 121.03 | 121.09 | 1994100.0 |
| 2005-06-07 12:30:00 | SPY | ETF | 121.1 | 121.24 | 121.06 | 121.19 | 1903400.0 |
| 2005-06-07 13:00:00 | SPY | ETF | 121.19 | 121.21 | 121.01 | 121.04 | 2060700.0 |
| 2005-06-07 13:30:00 | SPY | ETF | 121.05 | 121.09 | 120.88 | 120.92 | 4711400.0 |
| 2005-06-07 14:00:00 | SPY | ETF | 120.91 | 120.92 | 120.33 | 120.5 | 8772300.0 |
| 2005-06-07 14:30:00 | SPY | ETF | 120.5 | 120.78 | 120.46 | 120.63 | 4004300.0 |
| 2005-06-07 15:00:00 | SPY | ETF | 120.63 | 120.67 | 120.32 | 120.34 | 4721600.0 |
| 2005-06-07 15:30:00 | SPY | ETF | 120.34 | 120.4 | 120.05 | 120.07 | 9446400.0 |
| 2005-06-07 16:00:00 | SPY | ETF | 120.07 | 120.3 | 120.0 | 120.25 | 1192600.0 |
| 2005-06-07 16:30:00 | SPY | ETF | 120.2 | 120.2 | 120.07 | 120.19 | 78500.0 |
| 2005-06-07 17:00:00 | SPY | ETF | 120.19 | 120.2 | 120.16 | 120.18 | 55300.0 |
| 2005-06-07 17:30:00 | SPY | ETF | 120.19 | 120.19 | 120.12 | 120.12 | 38700.0 |
| 2005-06-07 18:00:00 | SPY | ETF | 120.12 | 120.17 | 120.12 | 120.15 | 24500.0 |
| 2005-06-07 18:30:00 | SPY | ETF | 120.11 | 120.16 | 120.08 | 120.16 | 6300.0 |
| 2005-06-07 19:00:00 | SPY | ETF | 120.16 | 120.16 | 120.16 | 120.16 | 1300.0 |
| 2005-06-07 19:30:00 | SPY | ETF | 120.19 | 120.19 | 120.19 | 120.19 | 500.0 |
| 2005-06-07 09:30:00 | QQQ | ETF | 38.15 | 38.25 | 38.1 | 38.24 | 10226200.0 |
| 2005-06-07 10:00:00 | QQQ | ETF | 38.24 | 38.47 | 38.22 | 38.44 | 13500300.0 |
| 2005-06-07 10:30:00 | QQQ | ETF | 38.44 | 38.45 | 38.35 | 38.39 | 6603600.0 |
| 2005-06-07 11:00:00 | QQQ | ETF | 38.39 | 38.41 | 36.38 | 38.35 | 4344600.0 |
| 2005-06-07 11:30:00 | QQQ | ETF | 38.35 | 38.41 | 38.31 | 38.39 | 5062300.0 |
| 2005-06-07 12:00:00 | QQQ | ETF | 38.39 | 38.4 | 38.3 | 38.32 | 2662000.0 |
| 2005-06-07 12:30:00 | QQQ | ETF | 38.32 | 38.37 | 38.32 | 38.36 | 1904400.0 |
| 2005-06-07 13:00:00 | QQQ | ETF | 38.36 | 38.37 | 38.29 | 38.29 | 1617800.0 |
| 2005-06-07 13:30:00 | QQQ | ETF | 38.3 | 38.3 | 38.11 | 38.14 | 9635300.0 |
| 2005-06-07 14:00:00 | QQQ | ETF | 38.14 | 38.15 | 37.82 | 37.88 | 18112500.0 |
| 2005-06-07 14:30:00 | QQQ | ETF | 37.88 | 38.02 | 37.85 | 37.97 | 8651300.0 |
| 2005-06-07 15:00:00 | QQQ | ETF | 37.97 | 37.98 | 37.84 | 37.85 | 7359500.0 |
| 2005-06-07 15:30:00 | QQQ | ETF | 37.85 | 37.85 | 37.74 | 37.8 | 13019700.0 |
| 2005-06-07 08:00:00 | IWM | ETF | 62.175 | 62.175 | 62.175 | 62.175 | 12000.0 |
| 2005-06-07 08:30:00 | IWM | ETF | 62.22 | 62.24 | 62.21 | 62.21 | 16400.0 |
| 2005-06-07 09:00:00 | IWM | ETF | 62.21 | 62.21 | 62.19 | 62.19 | 3800.0 |
| 2005-06-07 09:30:00 | IWM | ETF | 62.2 | 62.565 | 62.2 | 62.555 | 5042200.0 |
| 2005-06-07 10:00:00 | IWM | ETF | 62.55 | 62.875 | 62.535 | 62.85 | 3360200.0 |
| 2005-06-07 10:30:00 | IWM | ETF | 62.835 | 62.865 | 62.65 | 62.715 | 2570600.0 |
| 2005-06-07 11:00:00 | IWM | ETF | 62.715 | 62.755 | 62.615 | 62.685 | 1847000.0 |
| 2005-06-07 11:30:00 | IWM | ETF | 62.685 | 62.75 | 62.61 | 62.74 | 858000.0 |
| 2005-06-07 12:00:00 | IWM | ETF | 62.74 | 62.75 | 62.625 | 62.695 | 422600.0 |
| 2005-06-07 12:30:00 | IWM | ETF | 62.69 | 62.77 | 62.68 | 62.76 | 427800.0 |
> showing 50 of 1,527 rows — these rows as CSV