PREVIEW / etf_30min / 2005-02-11
file: by_date/etf_30min/2005/2005-02-11.parquet size: 43 KB rows: 1,457
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-02-11 08:00:00 | SPY | ETF | 119.77 | 119.77 | 119.7 | 119.75 | 50400.0 |
| 2005-02-11 08:30:00 | SPY | ETF | 119.74 | 119.76 | 119.72 | 119.76 | 6400.0 |
| 2005-02-11 09:00:00 | SPY | ETF | 119.77 | 119.77 | 119.68 | 119.71 | 28100.0 |
| 2005-02-11 09:30:00 | SPY | ETF | 119.71 | 119.82 | 119.54 | 119.59 | 4481200.0 |
| 2005-02-11 10:00:00 | SPY | ETF | 119.59 | 119.75 | 119.46 | 119.71 | 5954300.0 |
| 2005-02-11 10:30:00 | SPY | ETF | 119.71 | 119.93 | 119.58 | 119.84 | 4399800.0 |
| 2005-02-11 11:00:00 | SPY | ETF | 119.85 | 120.95 | 119.84 | 120.89 | 9388400.0 |
| 2005-02-11 11:30:00 | SPY | ETF | 120.89 | 121.04 | 120.7 | 120.77 | 7058800.0 |
| 2005-02-11 12:00:00 | SPY | ETF | 120.73 | 120.95 | 120.7 | 120.82 | 2371000.0 |
| 2005-02-11 12:30:00 | SPY | ETF | 120.8 | 120.98 | 120.73 | 120.82 | 1897100.0 |
| 2005-02-11 13:00:00 | SPY | ETF | 120.81 | 120.88 | 120.64 | 120.79 | 3333600.0 |
| 2005-02-11 13:30:00 | SPY | ETF | 120.79 | 120.99 | 120.76 | 120.9 | 1963600.0 |
| 2005-02-11 14:00:00 | SPY | ETF | 120.9 | 120.9 | 120.65 | 120.8 | 2274000.0 |
| 2005-02-11 14:30:00 | SPY | ETF | 120.81 | 120.98 | 120.76 | 120.871 | 1652100.0 |
| 2005-02-11 15:00:00 | SPY | ETF | 120.87 | 120.96 | 120.78 | 120.87 | 1789000.0 |
| 2005-02-11 15:30:00 | SPY | ETF | 120.88 | 120.89 | 120.67 | 120.72 | 3710800.0 |
| 2005-02-11 16:00:00 | SPY | ETF | 120.7 | 120.84 | 120.65 | 120.82 | 1004900.0 |
| 2005-02-11 16:30:00 | SPY | ETF | 120.84 | 120.9 | 120.77 | 120.88 | 70800.0 |
| 2005-02-11 17:00:00 | SPY | ETF | 120.88 | 120.9 | 120.65 | 120.65 | 77700.0 |
| 2005-02-11 17:30:00 | SPY | ETF | 120.9 | 120.95 | 120.89 | 120.89 | 2900.0 |
| 2005-02-11 19:00:00 | SPY | ETF | 120.9 | 120.9 | 120.9 | 120.9 | 2500.0 |
| 2005-02-11 19:30:00 | SPY | ETF | 120.9 | 120.9 | 120.9 | 120.9 | 1500.0 |
| 2005-02-11 09:30:00 | QQQ | ETF | 37.07 | 37.12 | 36.93 | 36.98 | 13350200.0 |
| 2005-02-11 10:00:00 | QQQ | ETF | 36.98 | 37.23 | 36.93 | 37.21 | 13058900.0 |
| 2005-02-11 10:30:00 | QQQ | ETF | 37.21 | 37.36 | 37.17 | 37.29 | 9896700.0 |
| 2005-02-11 11:00:00 | QQQ | ETF | 37.28 | 37.73 | 37.28 | 37.72 | 17489200.0 |
| 2005-02-11 11:30:00 | QQQ | ETF | 37.71 | 37.92 | 37.57 | 37.61 | 8483000.0 |
| 2005-02-11 12:00:00 | QQQ | ETF | 37.62 | 37.73 | 37.57 | 37.66 | 5191500.0 |
| 2005-02-11 12:30:00 | QQQ | ETF | 37.65 | 37.75 | 37.64 | 37.69 | 4507100.0 |
| 2005-02-11 13:00:00 | QQQ | ETF | 37.69 | 37.72 | 37.62 | 37.65 | 5604800.0 |
| 2005-02-11 13:30:00 | QQQ | ETF | 37.65 | 37.85 | 37.65 | 37.8 | 6969700.0 |
| 2005-02-11 14:00:00 | QQQ | ETF | 37.8 | 37.81 | 37.69 | 37.72 | 3333300.0 |
| 2005-02-11 14:30:00 | QQQ | ETF | 37.72 | 37.81 | 37.69 | 37.77 | 3590200.0 |
| 2005-02-11 15:00:00 | QQQ | ETF | 37.77 | 37.8 | 37.69 | 37.78 | 4580300.0 |
| 2005-02-11 15:30:00 | QQQ | ETF | 37.78 | 37.79 | 37.68 | 37.71 | 7314100.0 |
| 2005-02-11 08:00:00 | IWM | ETF | 62.2 | 62.2 | 62.17 | 62.2 | 11400.0 |
| 2005-02-11 09:00:00 | IWM | ETF | 62.31 | 62.31 | 62.275 | 62.275 | 6000.0 |
| 2005-02-11 09:30:00 | IWM | ETF | 62.325 | 62.345 | 61.955 | 62.045 | 1626600.0 |
| 2005-02-11 10:00:00 | IWM | ETF | 62.04 | 62.24 | 61.88 | 62.22 | 2560000.0 |
| 2005-02-11 10:30:00 | IWM | ETF | 62.22 | 62.41 | 62.185 | 62.315 | 1111000.0 |
| 2005-02-11 11:00:00 | IWM | ETF | 62.335 | 63.05 | 62.33 | 63.045 | 2066400.0 |
| 2005-02-11 11:30:00 | IWM | ETF | 63.07 | 63.135 | 62.84 | 62.94 | 2457400.0 |
| 2005-02-11 12:00:00 | IWM | ETF | 62.935 | 62.955 | 62.81 | 62.91 | 567400.0 |
| 2005-02-11 12:30:00 | IWM | ETF | 62.905 | 63.045 | 62.895 | 63.01 | 483400.0 |
| 2005-02-11 13:00:00 | IWM | ETF | 63.02 | 63.035 | 62.905 | 62.99 | 630600.0 |
| 2005-02-11 13:30:00 | IWM | ETF | 62.99 | 63.35 | 62.975 | 63.26 | 1754000.0 |
| 2005-02-11 14:00:00 | IWM | ETF | 63.27 | 63.28 | 63.17 | 63.23 | 675600.0 |
| 2005-02-11 14:30:00 | IWM | ETF | 63.23 | 63.33 | 63.195 | 63.205 | 786000.0 |
| 2005-02-11 15:00:00 | IWM | ETF | 63.21 | 63.29 | 63.075 | 63.27 | 1206800.0 |
| 2005-02-11 15:30:00 | IWM | ETF | 63.27 | 63.37 | 63.0 | 63.215 | 1606400.0 |
> showing 50 of 1,457 rows — these rows as CSV