PREVIEW / etf_30min / 2005-02-10
file: by_date/etf_30min/2005/2005-02-10.parquet size: 43 KB rows: 1,452
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-10 08:00:00 | SPY | ETF | 119.53 | 119.54 | 119.45 | 119.54 | 147400.0 |
| 2005-02-10 08:30:00 | SPY | ETF | 119.54 | 119.66 | 119.54 | 119.6 | 106900.0 |
| 2005-02-10 09:00:00 | SPY | ETF | 119.63 | 119.7 | 119.62 | 119.65 | 60600.0 |
| 2005-02-10 09:30:00 | SPY | ETF | 119.66 | 119.75 | 119.51 | 119.6 | 5058000.0 |
| 2005-02-10 10:00:00 | SPY | ETF | 119.61 | 119.81 | 119.56 | 119.61 | 4324600.0 |
| 2005-02-10 10:30:00 | SPY | ETF | 119.61 | 119.65 | 119.38 | 119.46 | 4454600.0 |
| 2005-02-10 11:00:00 | SPY | ETF | 119.48 | 119.49 | 119.26 | 119.44 | 3646100.0 |
| 2005-02-10 11:30:00 | SPY | ETF | 119.45 | 119.57 | 119.38 | 119.5 | 2035000.0 |
| 2005-02-10 12:00:00 | SPY | ETF | 119.5 | 119.61 | 119.43 | 119.56 | 2462700.0 |
| 2005-02-10 12:30:00 | SPY | ETF | 119.57 | 119.63 | 119.51 | 119.57 | 1773500.0 |
| 2005-02-10 13:00:00 | SPY | ETF | 119.58 | 119.8 | 119.42 | 119.79 | 1710200.0 |
| 2005-02-10 13:30:00 | SPY | ETF | 119.77 | 119.91 | 119.72 | 119.87 | 4190700.0 |
| 2005-02-10 14:00:00 | SPY | ETF | 119.86 | 119.94 | 119.76 | 119.82 | 2667700.0 |
| 2005-02-10 14:30:00 | SPY | ETF | 119.82 | 119.89 | 119.59 | 119.79 | 3759600.0 |
| 2005-02-10 15:00:00 | SPY | ETF | 119.78 | 120.0 | 119.75 | 119.98 | 3053700.0 |
| 2005-02-10 15:30:00 | SPY | ETF | 119.98 | 120.02 | 119.77 | 119.83 | 4327200.0 |
| 2005-02-10 16:00:00 | SPY | ETF | 119.85 | 119.93 | 119.65 | 119.72 | 744300.0 |
| 2005-02-10 16:30:00 | SPY | ETF | 119.73 | 119.74 | 119.65 | 119.68 | 178200.0 |
| 2005-02-10 17:00:00 | SPY | ETF | 119.68 | 119.7 | 119.68 | 119.7 | 5400.0 |
| 2005-02-10 17:30:00 | SPY | ETF | 119.7 | 119.71 | 119.66 | 119.71 | 2800.0 |
| 2005-02-10 18:00:00 | SPY | ETF | 119.71 | 119.71 | 119.68 | 119.68 | 800.0 |
| 2005-02-10 18:30:00 | SPY | ETF | 119.71 | 119.73 | 119.71 | 119.73 | 500.0 |
| 2005-02-10 19:00:00 | SPY | ETF | 119.78 | 119.82 | 119.78 | 119.82 | 300.0 |
| 2005-02-10 19:30:00 | SPY | ETF | 119.88 | 119.88 | 119.84 | 119.84 | 2300.0 |
| 2005-02-10 09:30:00 | QQQ | ETF | 37.24 | 37.28 | 37.12 | 37.16 | 11915000.0 |
| 2005-02-10 10:00:00 | QQQ | ETF | 37.15 | 37.25 | 37.1 | 37.12 | 8062800.0 |
| 2005-02-10 10:30:00 | QQQ | ETF | 37.12 | 37.15 | 36.93 | 36.97 | 10845600.0 |
| 2005-02-10 11:00:00 | QQQ | ETF | 36.98 | 37.0 | 36.88 | 36.96 | 8287000.0 |
| 2005-02-10 11:30:00 | QQQ | ETF | 36.97 | 37.08 | 36.92 | 37.04 | 7877500.0 |
| 2005-02-10 12:00:00 | QQQ | ETF | 37.04 | 37.19 | 37.03 | 37.15 | 5915000.0 |
| 2005-02-10 12:30:00 | QQQ | ETF | 37.15 | 37.18 | 37.1 | 37.13 | 4609000.0 |
| 2005-02-10 13:00:00 | QQQ | ETF | 37.13 | 37.25 | 37.04 | 37.24 | 3822000.0 |
| 2005-02-10 13:30:00 | QQQ | ETF | 37.24 | 37.31 | 37.18 | 37.29 | 7725600.0 |
| 2005-02-10 14:00:00 | QQQ | ETF | 37.29 | 37.32 | 37.21 | 37.24 | 3602700.0 |
| 2005-02-10 14:30:00 | QQQ | ETF | 37.24 | 37.25 | 37.01 | 37.11 | 6512900.0 |
| 2005-02-10 15:00:00 | QQQ | ETF | 37.11 | 37.24 | 37.09 | 37.22 | 7001900.0 |
| 2005-02-10 15:30:00 | QQQ | ETF | 37.21 | 37.23 | 37.12 | 37.15 | 7608000.0 |
| 2005-02-10 08:00:00 | IWM | ETF | 62.24 | 62.24 | 62.24 | 62.24 | 200.0 |
| 2005-02-10 08:30:00 | IWM | ETF | 62.3 | 62.365 | 62.3 | 62.365 | 8000.0 |
| 2005-02-10 09:00:00 | IWM | ETF | 62.375 | 62.425 | 62.32 | 62.345 | 147600.0 |
| 2005-02-10 09:30:00 | IWM | ETF | 62.37 | 62.5 | 62.315 | 62.326 | 2020800.0 |
| 2005-02-10 10:00:00 | IWM | ETF | 62.325 | 62.48 | 62.32 | 62.345 | 1927600.0 |
| 2005-02-10 10:30:00 | IWM | ETF | 62.36 | 62.38 | 62.015 | 62.08 | 2519600.0 |
| 2005-02-10 11:00:00 | IWM | ETF | 62.085 | 62.095 | 61.905 | 62.0 | 1832400.0 |
| 2005-02-10 11:30:00 | IWM | ETF | 61.995 | 62.31 | 61.98 | 62.285 | 2227200.0 |
| 2005-02-10 12:00:00 | IWM | ETF | 62.285 | 62.41 | 62.175 | 62.335 | 1271400.0 |
| 2005-02-10 12:30:00 | IWM | ETF | 62.365 | 62.45 | 62.3 | 62.3 | 1085000.0 |
| 2005-02-10 13:00:00 | IWM | ETF | 62.305 | 62.455 | 62.21 | 62.45 | 734200.0 |
| 2005-02-10 13:30:00 | IWM | ETF | 62.45 | 62.6 | 62.4 | 62.575 | 901400.0 |
| 2005-02-10 14:00:00 | IWM | ETF | 62.575 | 62.615 | 62.49 | 62.535 | 1214000.0 |
> showing 50 of 1,452 rows — these rows as CSV