PREVIEW / etf_30min / 2006-05-02
file: by_date/etf_30min/2006/2006-05-02.parquet size: 62 KB rows: 2,290
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-02 04:00:00 | SPY | ETF | 130.84 | 130.84 | 130.84 | 130.84 | 300.0 |
| 2006-05-02 05:30:00 | SPY | ETF | 130.93 | 130.93 | 130.93 | 130.93 | 9100.0 |
| 2006-05-02 07:00:00 | SPY | ETF | 130.88 | 130.88 | 130.82 | 130.83 | 164800.0 |
| 2006-05-02 07:30:00 | SPY | ETF | 130.85 | 130.89 | 130.81 | 130.84 | 83700.0 |
| 2006-05-02 08:00:00 | SPY | ETF | 130.84 | 130.9 | 130.82 | 130.88 | 554600.0 |
| 2006-05-02 08:30:00 | SPY | ETF | 130.88 | 131.42 | 130.855 | 130.95 | 1397400.0 |
| 2006-05-02 09:00:00 | SPY | ETF | 130.95 | 131.08 | 130.07 | 131.02 | 1365900.0 |
| 2006-05-02 09:30:00 | SPY | ETF | 131.01 | 131.1 | 130.81 | 130.93 | 6158900.0 |
| 2006-05-02 10:00:00 | SPY | ETF | 130.95 | 131.19 | 130.74 | 131.07 | 6114900.0 |
| 2006-05-02 10:30:00 | SPY | ETF | 131.08 | 131.22 | 130.9 | 130.95 | 4024900.0 |
| 2006-05-02 11:00:00 | SPY | ETF | 130.95 | 131.06 | 130.8 | 131.04 | 3045400.0 |
| 2006-05-02 11:30:00 | SPY | ETF | 131.04 | 131.15 | 131.0 | 131.05 | 1810900.0 |
| 2006-05-02 12:00:00 | SPY | ETF | 131.04 | 131.13 | 131.01 | 131.04 | 1489400.0 |
| 2006-05-02 12:30:00 | SPY | ETF | 131.02 | 131.38 | 131.02 | 131.3 | 5031800.0 |
| 2006-05-02 13:00:00 | SPY | ETF | 131.28 | 131.37 | 131.21 | 131.31 | 2097400.0 |
| 2006-05-02 13:30:00 | SPY | ETF | 131.32 | 131.46 | 131.24 | 131.28 | 2458700.0 |
| 2006-05-02 14:00:00 | SPY | ETF | 131.28 | 131.37 | 131.23 | 131.23 | 1430600.0 |
| 2006-05-02 14:30:00 | SPY | ETF | 131.2274 | 131.27 | 131.06 | 131.16 | 2459500.0 |
| 2006-05-02 15:00:00 | SPY | ETF | 131.17 | 131.3 | 131.13 | 131.29 | 1919200.0 |
| 2006-05-02 15:30:00 | SPY | ETF | 131.3 | 131.42 | 131.25 | 131.38 | 3330600.0 |
| 2006-05-02 16:00:00 | SPY | ETF | 131.37 | 131.43 | 131.35 | 131.39 | 741400.0 |
| 2006-05-02 16:30:00 | SPY | ETF | 131.39 | 131.42 | 131.37 | 131.39 | 196700.0 |
| 2006-05-02 17:00:00 | SPY | ETF | 131.41 | 131.42 | 131.37 | 131.39 | 7100.0 |
| 2006-05-02 17:30:00 | SPY | ETF | 131.39 | 131.39 | 131.39 | 131.39 | 1000.0 |
| 2006-05-02 18:00:00 | SPY | ETF | 131.42 | 131.42 | 131.36 | 131.36 | 12800.0 |
| 2006-05-02 18:30:00 | SPY | ETF | 131.34 | 131.34 | 131.32 | 131.32 | 11400.0 |
| 2006-05-02 19:30:00 | SPY | ETF | 131.35 | 131.37 | 131.35 | 131.37 | 4000.0 |
| 2006-05-02 09:30:00 | QQQ | ETF | 41.61 | 41.67 | 41.4 | 41.55 | 12815000.0 |
| 2006-05-02 10:00:00 | QQQ | ETF | 41.55 | 41.72 | 41.46 | 41.67 | 15059900.0 |
| 2006-05-02 10:30:00 | QQQ | ETF | 41.67 | 41.73 | 41.5 | 41.56 | 6204200.0 |
| 2006-05-02 11:00:00 | QQQ | ETF | 41.56 | 41.56 | 41.48 | 41.54 | 4429500.0 |
| 2006-05-02 11:30:00 | QQQ | ETF | 41.54 | 41.58 | 41.49 | 41.53 | 2573600.0 |
| 2006-05-02 12:00:00 | QQQ | ETF | 41.52 | 41.57 | 41.5 | 41.51 | 2965000.0 |
| 2006-05-02 12:30:00 | QQQ | ETF | 41.5 | 41.66 | 41.5 | 41.6 | 2849500.0 |
| 2006-05-02 13:00:00 | QQQ | ETF | 41.59 | 41.66 | 41.56 | 41.63 | 2966900.0 |
| 2006-05-02 13:30:00 | QQQ | ETF | 41.63 | 41.68 | 41.57 | 41.59 | 2618800.0 |
| 2006-05-02 14:00:00 | QQQ | ETF | 41.59 | 41.63 | 41.52 | 41.54 | 3446400.0 |
| 2006-05-02 14:30:00 | QQQ | ETF | 41.53 | 41.57 | 41.49 | 41.55 | 6123600.0 |
| 2006-05-02 15:00:00 | QQQ | ETF | 41.55 | 41.59 | 41.52 | 41.58 | 3366600.0 |
| 2006-05-02 15:30:00 | QQQ | ETF | 41.57 | 41.59 | 41.52 | 41.54 | 8582800.0 |
| 2006-05-02 07:00:00 | IWM | ETF | 73.13 | 75.5 | 73.13 | 75.5 | 2100.0 |
| 2006-05-02 08:00:00 | IWM | ETF | 75.58 | 75.58 | 75.52 | 75.52 | 1800.0 |
| 2006-05-02 08:30:00 | IWM | ETF | 75.56 | 75.66 | 75.56 | 75.59 | 67200.0 |
| 2006-05-02 09:00:00 | IWM | ETF | 75.61 | 75.74 | 75.61 | 75.67 | 207800.0 |
| 2006-05-02 09:30:00 | IWM | ETF | 75.71 | 75.89 | 75.51 | 75.71 | 4425400.0 |
| 2006-05-02 10:00:00 | IWM | ETF | 75.71 | 75.84 | 75.41 | 75.77 | 3131800.0 |
| 2006-05-02 10:30:00 | IWM | ETF | 75.79 | 75.89 | 75.54 | 75.61 | 1506500.0 |
| 2006-05-02 11:00:00 | IWM | ETF | 75.61 | 75.75 | 75.5025 | 75.71 | 1267000.0 |
| 2006-05-02 11:30:00 | IWM | ETF | 75.72 | 75.79 | 75.63 | 75.69 | 866200.0 |
| 2006-05-02 12:00:00 | IWM | ETF | 75.68 | 75.79 | 75.66 | 75.73 | 328500.0 |
> showing 50 of 2,290 rows — these rows as CSV