PREVIEW / etf_30min / 2005-06-02
file: by_date/etf_30min/2005/2005-06-02.parquet size: 43 KB rows: 1,501
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-02 06:30:00 | SPY | ETF | 120.46 | 120.46 | 120.46 | 120.46 | 1500.0 |
| 2005-06-02 07:30:00 | SPY | ETF | 120.47 | 120.49 | 120.47 | 120.47 | 20600.0 |
| 2005-06-02 08:00:00 | SPY | ETF | 120.44 | 120.44 | 120.37 | 120.37 | 17700.0 |
| 2005-06-02 08:30:00 | SPY | ETF | 120.31 | 120.35 | 120.23 | 120.29 | 140000.0 |
| 2005-06-02 09:00:00 | SPY | ETF | 120.3 | 120.32 | 120.23 | 120.25 | 25500.0 |
| 2005-06-02 09:30:00 | SPY | ETF | 120.23 | 120.4 | 120.1 | 120.36 | 5756300.0 |
| 2005-06-02 10:00:00 | SPY | ETF | 120.36 | 120.44 | 120.21 | 120.29 | 3819700.0 |
| 2005-06-02 10:30:00 | SPY | ETF | 120.29 | 120.56 | 120.18 | 120.43 | 5016300.0 |
| 2005-06-02 11:00:00 | SPY | ETF | 120.42 | 120.49 | 120.33 | 120.45 | 2253200.0 |
| 2005-06-02 11:30:00 | SPY | ETF | 120.45 | 120.56 | 120.4 | 120.48 | 1218700.0 |
| 2005-06-02 12:00:00 | SPY | ETF | 120.48 | 120.59 | 120.47 | 120.56 | 1521400.0 |
| 2005-06-02 12:30:00 | SPY | ETF | 120.56 | 120.65 | 120.5 | 120.52 | 1540200.0 |
| 2005-06-02 13:00:00 | SPY | ETF | 120.53 | 120.59 | 120.48 | 120.49 | 1220700.0 |
| 2005-06-02 13:30:00 | SPY | ETF | 120.5 | 120.52 | 120.37 | 120.5 | 2450800.0 |
| 2005-06-02 14:00:00 | SPY | ETF | 120.5 | 120.74 | 120.47 | 120.71 | 2688800.0 |
| 2005-06-02 14:30:00 | SPY | ETF | 120.71 | 120.8 | 120.62 | 120.73 | 2430600.0 |
| 2005-06-02 15:00:00 | SPY | ETF | 120.73 | 120.75 | 120.59 | 120.72 | 1719100.0 |
| 2005-06-02 15:30:00 | SPY | ETF | 120.72 | 120.84 | 120.63 | 120.72 | 4263400.0 |
| 2005-06-02 16:00:00 | SPY | ETF | 120.73 | 120.82 | 120.64 | 120.74 | 1727400.0 |
| 2005-06-02 16:30:00 | SPY | ETF | 120.78 | 120.78 | 120.75 | 120.76 | 111200.0 |
| 2005-06-02 17:00:00 | SPY | ETF | 120.77 | 120.77 | 120.73 | 120.77 | 53800.0 |
| 2005-06-02 17:30:00 | SPY | ETF | 120.77 | 120.78 | 120.73 | 120.75 | 1000.0 |
| 2005-06-02 18:00:00 | SPY | ETF | 120.78 | 120.78 | 120.76 | 120.76 | 1500.0 |
| 2005-06-02 19:00:00 | SPY | ETF | 120.77 | 120.77 | 120.77 | 120.77 | 100.0 |
| 2005-06-02 19:30:00 | SPY | ETF | 120.75 | 120.77 | 120.74 | 120.77 | 4100.0 |
| 2005-06-02 09:30:00 | QQQ | ETF | 38.34 | 38.49 | 38.3 | 38.46 | 11682900.0 |
| 2005-06-02 10:00:00 | QQQ | ETF | 38.46 | 38.49 | 38.37 | 38.42 | 5839800.0 |
| 2005-06-02 10:30:00 | QQQ | ETF | 38.42 | 38.53 | 38.38 | 38.44 | 6826900.0 |
| 2005-06-02 11:00:00 | QQQ | ETF | 38.44 | 38.5 | 38.39 | 38.47 | 4106400.0 |
| 2005-06-02 11:30:00 | QQQ | ETF | 38.47 | 38.53 | 38.45 | 38.47 | 2642900.0 |
| 2005-06-02 12:00:00 | QQQ | ETF | 38.47 | 38.63 | 38.47 | 38.52 | 3875100.0 |
| 2005-06-02 12:30:00 | QQQ | ETF | 38.52 | 38.56 | 38.51 | 38.51 | 3269500.0 |
| 2005-06-02 13:00:00 | QQQ | ETF | 38.51 | 39.49 | 38.47 | 38.49 | 2262600.0 |
| 2005-06-02 13:30:00 | QQQ | ETF | 38.49 | 38.5 | 38.44 | 38.49 | 2836700.0 |
| 2005-06-02 14:00:00 | QQQ | ETF | 38.5 | 38.59 | 38.49 | 38.58 | 8584100.0 |
| 2005-06-02 14:30:00 | QQQ | ETF | 38.58 | 38.61 | 38.51 | 38.58 | 6266000.0 |
| 2005-06-02 15:00:00 | QQQ | ETF | 38.59 | 38.61 | 38.55 | 38.6 | 3672300.0 |
| 2005-06-02 15:30:00 | QQQ | ETF | 38.6 | 38.66 | 38.56 | 38.65 | 7698200.0 |
| 2005-06-02 08:00:00 | IWM | ETF | 62.125 | 62.125 | 62.125 | 62.125 | 400.0 |
| 2005-06-02 08:30:00 | IWM | ETF | 62.035 | 62.035 | 62.035 | 62.035 | 3000.0 |
| 2005-06-02 09:00:00 | IWM | ETF | 62.035 | 62.035 | 61.995 | 62.0 | 10200.0 |
| 2005-06-02 09:30:00 | IWM | ETF | 62.04 | 62.145 | 61.845 | 62.045 | 1018200.0 |
| 2005-06-02 10:00:00 | IWM | ETF | 62.045 | 62.16 | 61.95 | 61.99 | 977600.0 |
| 2005-06-02 10:30:00 | IWM | ETF | 61.99 | 62.25 | 61.935 | 62.135 | 2847400.0 |
| 2005-06-02 11:00:00 | IWM | ETF | 62.135 | 62.25 | 62.05 | 62.205 | 451600.0 |
| 2005-06-02 11:30:00 | IWM | ETF | 62.205 | 62.31 | 62.145 | 62.2 | 688000.0 |
| 2005-06-02 12:00:00 | IWM | ETF | 62.2 | 62.34 | 62.2 | 62.24 | 997400.0 |
| 2005-06-02 12:30:00 | IWM | ETF | 62.245 | 62.335 | 62.18 | 62.185 | 726800.0 |
| 2005-06-02 13:00:00 | IWM | ETF | 62.19 | 62.215 | 62.055 | 62.06 | 1306400.0 |
| 2005-06-02 13:30:00 | IWM | ETF | 62.065 | 62.09 | 61.91 | 62.035 | 1713800.0 |
> showing 50 of 1,501 rows — these rows as CSV