PREVIEW / etf_30min / 2004-06-02
file: by_date/etf_30min/2004/2004-06-02.parquet size: 36 KB rows: 1,184
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 |
|---|---|---|---|---|---|---|---|
| 2004-06-02 08:00:00 | SPY | ETF | 113.1 | 113.14 | 113.05 | 113.13 | 22300.0 |
| 2004-06-02 08:30:00 | SPY | ETF | 113.13 | 113.2 | 113.08 | 113.17 | 35700.0 |
| 2004-06-02 09:00:00 | SPY | ETF | 113.15 | 113.15 | 113.03 | 113.05 | 100400.0 |
| 2004-06-02 09:30:00 | SPY | ETF | 113.03 | 113.09 | 112.73 | 112.87 | 3773600.0 |
| 2004-06-02 10:00:00 | SPY | ETF | 112.86 | 112.91 | 112.55 | 112.61 | 4275800.0 |
| 2004-06-02 10:30:00 | SPY | ETF | 112.61 | 112.8 | 112.57 | 112.66 | 2166400.0 |
| 2004-06-02 11:00:00 | SPY | ETF | 112.66 | 112.72 | 112.51 | 112.56 | 2003900.0 |
| 2004-06-02 11:30:00 | SPY | ETF | 112.56 | 112.66 | 112.46 | 112.53 | 2618900.0 |
| 2004-06-02 12:00:00 | SPY | ETF | 112.54 | 112.71 | 112.47 | 112.68 | 988200.0 |
| 2004-06-02 12:30:00 | SPY | ETF | 112.69 | 112.82 | 112.56 | 112.61 | 1305500.0 |
| 2004-06-02 13:00:00 | SPY | ETF | 112.61 | 112.86 | 112.59 | 112.82 | 1335600.0 |
| 2004-06-02 13:30:00 | SPY | ETF | 112.82 | 112.91 | 112.77 | 112.88 | 1542100.0 |
| 2004-06-02 14:00:00 | SPY | ETF | 112.88 | 113.42 | 112.82 | 113.37 | 3812000.0 |
| 2004-06-02 14:30:00 | SPY | ETF | 113.37 | 113.48 | 113.25 | 113.28 | 3627300.0 |
| 2004-06-02 15:00:00 | SPY | ETF | 113.28 | 113.38 | 113.14 | 113.25 | 2219700.0 |
| 2004-06-02 15:30:00 | SPY | ETF | 113.25 | 113.33 | 113.05 | 113.12 | 3931700.0 |
| 2004-06-02 16:00:00 | SPY | ETF | 113.11 | 113.21 | 113.03 | 113.2 | 1406600.0 |
| 2004-06-02 16:30:00 | SPY | ETF | 113.17 | 113.19 | 113.13 | 113.17 | 3047700.0 |
| 2004-06-02 17:00:00 | SPY | ETF | 113.18 | 113.2 | 113.16 | 113.17 | 15500.0 |
| 2004-06-02 17:30:00 | SPY | ETF | 113.17 | 113.17 | 113.17 | 113.17 | 1400.0 |
| 2004-06-02 18:00:00 | SPY | ETF | 113.17 | 113.17 | 113.13 | 113.13 | 4500.0 |
| 2004-06-02 19:30:00 | SPY | ETF | 113.06 | 113.06 | 113.05 | 113.05 | 1600.0 |
| 2004-06-02 08:00:00 | QQQ | ETF | 36.66 | 36.68 | 36.63 | 36.64 | 39700.0 |
| 2004-06-02 08:30:00 | QQQ | ETF | 36.65 | 36.67 | 36.63 | 36.66 | 135100.0 |
| 2004-06-02 09:00:00 | QQQ | ETF | 36.66 | 36.66 | 36.56 | 36.57 | 189400.0 |
| 2004-06-02 09:30:00 | QQQ | ETF | 36.56 | 36.59 | 36.34 | 36.39 | 14489900.0 |
| 2004-06-02 10:00:00 | QQQ | ETF | 36.39 | 36.44 | 36.21 | 36.23 | 11084800.0 |
| 2004-06-02 10:30:00 | QQQ | ETF | 36.23 | 36.35 | 36.21 | 36.28 | 4531400.0 |
| 2004-06-02 11:00:00 | QQQ | ETF | 36.28 | 36.29 | 36.18 | 36.18 | 4467700.0 |
| 2004-06-02 11:30:00 | QQQ | ETF | 36.2 | 36.26 | 36.17 | 36.2 | 3384400.0 |
| 2004-06-02 12:00:00 | QQQ | ETF | 36.21 | 36.323 | 36.18 | 36.323 | 3383800.0 |
| 2004-06-02 12:30:00 | QQQ | ETF | 36.319 | 36.38 | 36.26 | 36.288 | 4009600.0 |
| 2004-06-02 13:00:00 | QQQ | ETF | 36.29 | 36.44 | 36.28 | 36.42 | 3940000.0 |
| 2004-06-02 13:30:00 | QQQ | ETF | 36.42 | 36.45 | 36.35 | 36.41 | 4396400.0 |
| 2004-06-02 14:00:00 | QQQ | ETF | 36.41 | 36.6 | 36.33 | 36.57 | 10302300.0 |
| 2004-06-02 14:30:00 | QQQ | ETF | 36.57 | 36.66 | 36.54 | 36.561 | 11653100.0 |
| 2004-06-02 15:00:00 | QQQ | ETF | 36.56 | 36.6 | 36.48 | 36.501 | 7419600.0 |
| 2004-06-02 15:30:00 | QQQ | ETF | 36.502 | 36.54 | 36.38 | 36.39 | 9868600.0 |
| 2004-06-02 16:00:00 | QQQ | ETF | 36.4 | 36.63 | 36.36 | 36.63 | 2601800.0 |
| 2004-06-02 16:30:00 | QQQ | ETF | 36.44 | 36.46 | 36.41 | 36.43 | 89600.0 |
| 2004-06-02 17:00:00 | QQQ | ETF | 36.44 | 36.44 | 36.43 | 36.44 | 24400.0 |
| 2004-06-02 17:30:00 | QQQ | ETF | 36.44 | 36.44 | 36.42 | 36.42 | 9000.0 |
| 2004-06-02 18:00:00 | QQQ | ETF | 36.42 | 36.44 | 36.41 | 36.42 | 10300.0 |
| 2004-06-02 18:30:00 | QQQ | ETF | 36.43 | 36.43 | 36.42 | 36.42 | 1500.0 |
| 2004-06-02 19:00:00 | QQQ | ETF | 36.43 | 36.44 | 36.42 | 36.44 | 9900.0 |
| 2004-06-02 19:30:00 | QQQ | ETF | 36.42 | 36.42 | 36.42 | 36.42 | 5000.0 |
| 2004-06-02 08:00:00 | IWM | ETF | 57.46 | 57.47 | 57.4 | 57.46 | 9200.0 |
| 2004-06-02 09:00:00 | IWM | ETF | 57.46 | 57.46 | 57.46 | 57.46 | 1000.0 |
| 2004-06-02 09:30:00 | IWM | ETF | 57.405 | 57.46 | 57.115 | 57.23 | 1866200.0 |
| 2004-06-02 10:00:00 | IWM | ETF | 57.235 | 57.27 | 56.89 | 56.98 | 1383000.0 |
> showing 50 of 1,184 rows — these rows as CSV