PREVIEW / etf_30min / 2006-06-02
file: by_date/etf_30min/2006/2006-06-02.parquet size: 67 KB rows: 2,357
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-06-02 05:30:00 | SPY | ETF | 128.81 | 128.84 | 128.81 | 128.84 | 1700.0 |
| 2006-06-02 06:00:00 | SPY | ETF | 128.89 | 128.89 | 128.89 | 128.89 | 100.0 |
| 2006-06-02 07:00:00 | SPY | ETF | 128.82 | 128.93 | 128.82 | 128.93 | 15200.0 |
| 2006-06-02 07:30:00 | SPY | ETF | 128.95 | 129.08 | 128.93 | 128.93 | 68200.0 |
| 2006-06-02 08:00:00 | SPY | ETF | 128.94 | 129.11 | 128.84 | 129.08 | 2213600.0 |
| 2006-06-02 08:30:00 | SPY | ETF | 129.08 | 129.56 | 129.06 | 129.43 | 5606300.0 |
| 2006-06-02 09:00:00 | SPY | ETF | 129.45 | 129.47 | 129.23 | 129.25 | 880100.0 |
| 2006-06-02 09:30:00 | SPY | ETF | 129.25 | 129.43 | 128.46 | 128.65 | 23610000.0 |
| 2006-06-02 10:00:00 | SPY | ETF | 128.65 | 129.11 | 128.64 | 129.04 | 11052400.0 |
| 2006-06-02 10:30:00 | SPY | ETF | 129.04 | 129.3 | 128.92 | 129.06 | 4628400.0 |
| 2006-06-02 11:00:00 | SPY | ETF | 129.06 | 129.2 | 128.7 | 128.79 | 3319600.0 |
| 2006-06-02 11:30:00 | SPY | ETF | 128.79 | 129.16 | 128.33 | 128.43 | 7650800.0 |
| 2006-06-02 12:00:00 | SPY | ETF | 128.41 | 128.74 | 128.32 | 128.63 | 3550500.0 |
| 2006-06-02 12:30:00 | SPY | ETF | 128.63 | 128.84 | 128.59 | 128.67 | 2880500.0 |
| 2006-06-02 13:00:00 | SPY | ETF | 128.66 | 128.97 | 128.65 | 128.95 | 2926100.0 |
| 2006-06-02 13:30:00 | SPY | ETF | 128.95 | 128.97 | 128.67 | 128.76 | 3129800.0 |
| 2006-06-02 14:00:00 | SPY | ETF | 128.76 | 128.88 | 128.68 | 128.77 | 1631200.0 |
| 2006-06-02 14:30:00 | SPY | ETF | 128.77 | 129.16 | 128.75 | 129.08 | 5176900.0 |
| 2006-06-02 15:00:00 | SPY | ETF | 129.08 | 129.1 | 128.83 | 129.07 | 3216900.0 |
| 2006-06-02 15:30:00 | SPY | ETF | 129.08 | 129.29 | 128.98 | 129.13 | 6429700.0 |
| 2006-06-02 16:00:00 | SPY | ETF | 129.13 | 129.18 | 128.96 | 129.09 | 1667000.0 |
| 2006-06-02 16:30:00 | SPY | ETF | 129.03 | 129.09 | 128.98 | 129.06 | 148200.0 |
| 2006-06-02 17:00:00 | SPY | ETF | 128.98 | 129.01 | 128.97 | 128.98 | 2100.0 |
| 2006-06-02 17:30:00 | SPY | ETF | 129.02 | 129.02 | 129.02 | 129.02 | 100.0 |
| 2006-06-02 18:00:00 | SPY | ETF | 128.99 | 128.99 | 128.99 | 128.99 | 100.0 |
| 2006-06-02 18:30:00 | SPY | ETF | 128.99 | 128.99 | 128.99 | 128.99 | 100.0 |
| 2006-06-02 19:00:00 | SPY | ETF | 129.0 | 129.0 | 128.96 | 128.96 | 1800.0 |
| 2006-06-02 09:30:00 | QQQ | ETF | 39.97 | 40.0 | 39.56 | 39.68 | 26261400.0 |
| 2006-06-02 10:00:00 | QQQ | ETF | 39.68 | 39.89 | 39.66 | 39.8 | 11583800.0 |
| 2006-06-02 10:30:00 | QQQ | ETF | 39.81 | 39.86 | 39.73 | 39.77 | 4982900.0 |
| 2006-06-02 11:00:00 | QQQ | ETF | 39.77 | 39.79 | 39.58 | 39.62 | 6663500.0 |
| 2006-06-02 11:30:00 | QQQ | ETF | 39.62 | 39.64 | 39.32 | 39.35 | 19817300.0 |
| 2006-06-02 12:00:00 | QQQ | ETF | 39.35 | 39.51 | 39.31 | 39.47 | 6675600.0 |
| 2006-06-02 12:30:00 | QQQ | ETF | 39.47 | 39.54 | 39.44 | 39.45 | 5618700.0 |
| 2006-06-02 13:00:00 | QQQ | ETF | 39.46 | 39.6 | 39.42 | 39.58 | 4627800.0 |
| 2006-06-02 13:30:00 | QQQ | ETF | 39.58 | 39.59 | 39.45 | 39.47 | 3823400.0 |
| 2006-06-02 14:00:00 | QQQ | ETF | 39.47 | 39.56 | 39.4 | 39.5 | 3562100.0 |
| 2006-06-02 14:30:00 | QQQ | ETF | 39.5 | 39.64 | 39.4 | 39.6 | 5688400.0 |
| 2006-06-02 15:00:00 | QQQ | ETF | 39.59 | 39.62 | 39.4 | 39.6 | 4808000.0 |
| 2006-06-02 15:30:00 | QQQ | ETF | 39.6 | 39.7 | 39.6 | 39.64 | 8130400.0 |
| 2006-06-02 08:00:00 | IWM | ETF | 73.33 | 73.43 | 73.13 | 73.39 | 1156400.0 |
| 2006-06-02 08:30:00 | IWM | ETF | 73.3 | 73.84 | 73.3 | 73.74 | 2444800.0 |
| 2006-06-02 09:00:00 | IWM | ETF | 73.74 | 73.87 | 73.66 | 73.73 | 1065800.0 |
| 2006-06-02 09:30:00 | IWM | ETF | 73.74 | 73.84 | 73.15 | 73.22 | 9345000.0 |
| 2006-06-02 10:00:00 | IWM | ETF | 73.22 | 73.62 | 73.21 | 73.46 | 5639200.0 |
| 2006-06-02 10:30:00 | IWM | ETF | 73.45 | 73.57 | 73.24 | 73.36 | 3152000.0 |
| 2006-06-02 11:00:00 | IWM | ETF | 73.35 | 73.42 | 73.02 | 73.07 | 4378700.0 |
| 2006-06-02 11:30:00 | IWM | ETF | 73.06 | 73.15 | 72.68 | 72.75 | 3567800.0 |
| 2006-06-02 12:00:00 | IWM | ETF | 72.76 | 73.04 | 72.7 | 73.0 | 2350700.0 |
| 2006-06-02 12:30:00 | IWM | ETF | 73.01 | 73.2 | 72.95 | 73.05 | 1635500.0 |
> showing 50 of 2,357 rows — these rows as CSV