PREVIEW / etf_30min / 2005-01-10
file: by_date/etf_30min/2005/2005-01-10.parquet size: 42 KB rows: 1,428
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-01-10 08:00:00 | SPY | ETF | 118.52 | 118.56 | 118.49 | 118.5 | 37600.0 |
| 2005-01-10 08:30:00 | SPY | ETF | 118.5 | 118.54 | 118.47 | 118.49 | 22900.0 |
| 2005-01-10 09:00:00 | SPY | ETF | 118.46 | 118.46 | 118.35 | 118.35 | 148800.0 |
| 2005-01-10 09:30:00 | SPY | ETF | 118.34 | 118.73 | 118.34 | 118.7 | 6862700.0 |
| 2005-01-10 10:00:00 | SPY | ETF | 118.71 | 119.14 | 118.56 | 119.11 | 7652600.0 |
| 2005-01-10 10:30:00 | SPY | ETF | 119.11 | 119.22 | 118.79 | 119.09 | 4828000.0 |
| 2005-01-10 11:00:00 | SPY | ETF | 119.09 | 119.26 | 119.04 | 119.19 | 3413800.0 |
| 2005-01-10 11:30:00 | SPY | ETF | 119.19 | 119.22 | 119.01 | 119.13 | 2630900.0 |
| 2005-01-10 12:00:00 | SPY | ETF | 119.13 | 119.31 | 119.1 | 119.21 | 2621600.0 |
| 2005-01-10 12:30:00 | SPY | ETF | 119.2 | 119.3 | 119.06 | 119.22 | 1764900.0 |
| 2005-01-10 13:00:00 | SPY | ETF | 119.23 | 119.46 | 119.16 | 119.4 | 3953000.0 |
| 2005-01-10 13:30:00 | SPY | ETF | 119.4 | 119.46 | 119.36 | 119.38 | 1900300.0 |
| 2005-01-10 14:00:00 | SPY | ETF | 119.39 | 119.39 | 119.16 | 119.23 | 2701800.0 |
| 2005-01-10 14:30:00 | SPY | ETF | 119.22 | 119.27 | 119.05 | 119.11 | 2777500.0 |
| 2005-01-10 15:00:00 | SPY | ETF | 119.11 | 119.22 | 118.74 | 118.81 | 5684700.0 |
| 2005-01-10 15:30:00 | SPY | ETF | 118.82 | 118.98 | 118.59 | 118.94 | 6577300.0 |
| 2005-01-10 16:00:00 | SPY | ETF | 118.96 | 119.03 | 118.88 | 118.97 | 1042000.0 |
| 2005-01-10 16:30:00 | SPY | ETF | 118.96 | 119.05 | 118.89 | 119.01 | 249100.0 |
| 2005-01-10 17:00:00 | SPY | ETF | 118.98 | 118.98 | 118.94 | 118.96 | 231600.0 |
| 2005-01-10 17:30:00 | SPY | ETF | 118.97 | 118.99 | 118.9 | 118.99 | 11900.0 |
| 2005-01-10 18:00:00 | SPY | ETF | 118.99 | 119.09 | 118.89 | 118.99 | 25200.0 |
| 2005-01-10 18:30:00 | SPY | ETF | 119.02 | 119.02 | 118.96 | 118.96 | 2100.0 |
| 2005-01-10 19:30:00 | SPY | ETF | 118.94 | 118.94 | 118.94 | 118.94 | 500.0 |
| 2005-01-10 09:30:00 | QQQ | ETF | 38.45 | 38.61 | 38.4 | 38.58 | 13549000.0 |
| 2005-01-10 10:00:00 | QQQ | ETF | 38.59 | 38.76 | 38.47 | 38.75 | 13270600.0 |
| 2005-01-10 10:30:00 | QQQ | ETF | 38.75 | 38.8 | 38.7 | 38.74 | 7360900.0 |
| 2005-01-10 11:00:00 | QQQ | ETF | 38.74 | 38.82 | 38.7 | 38.77 | 5585500.0 |
| 2005-01-10 11:30:00 | QQQ | ETF | 38.77 | 38.78 | 38.65 | 38.71 | 2758300.0 |
| 2005-01-10 12:00:00 | QQQ | ETF | 38.71 | 38.8 | 38.69 | 38.75 | 2522600.0 |
| 2005-01-10 12:30:00 | QQQ | ETF | 38.75 | 38.79 | 38.67 | 38.76 | 1793800.0 |
| 2005-01-10 13:00:00 | QQQ | ETF | 38.76 | 38.87 | 38.71 | 38.82 | 4174000.0 |
| 2005-01-10 13:30:00 | QQQ | ETF | 38.81 | 38.87 | 38.8 | 38.81 | 4214800.0 |
| 2005-01-10 14:00:00 | QQQ | ETF | 38.81 | 38.87 | 38.7 | 38.78 | 4800200.0 |
| 2005-01-10 14:30:00 | QQQ | ETF | 38.78 | 38.8 | 38.67 | 38.72 | 4515300.0 |
| 2005-01-10 15:00:00 | QQQ | ETF | 38.72 | 38.76 | 38.46 | 38.5 | 8946500.0 |
| 2005-01-10 15:30:00 | QQQ | ETF | 38.49 | 38.58 | 38.39 | 38.51 | 8714900.0 |
| 2005-01-10 08:00:00 | IWM | ETF | 61.0 | 61.0 | 61.0 | 61.0 | 1000.0 |
| 2005-01-10 08:30:00 | IWM | ETF | 60.975 | 60.975 | 60.965 | 60.965 | 3000.0 |
| 2005-01-10 09:00:00 | IWM | ETF | 60.955 | 61.03 | 60.9 | 61.01 | 27800.0 |
| 2005-01-10 09:30:00 | IWM | ETF | 61.0 | 61.425 | 60.95 | 61.36 | 3084200.0 |
| 2005-01-10 10:00:00 | IWM | ETF | 61.355 | 61.74 | 61.2 | 61.7 | 3194400.0 |
| 2005-01-10 10:30:00 | IWM | ETF | 61.72 | 61.765 | 61.525 | 61.595 | 1895600.0 |
| 2005-01-10 11:00:00 | IWM | ETF | 61.585 | 61.925 | 61.58 | 61.85 | 1586800.0 |
| 2005-01-10 11:30:00 | IWM | ETF | 61.85 | 61.85 | 61.71 | 61.82 | 665200.0 |
| 2005-01-10 12:00:00 | IWM | ETF | 61.82 | 61.895 | 61.77 | 61.825 | 685400.0 |
| 2005-01-10 12:30:00 | IWM | ETF | 61.815 | 61.86 | 61.675 | 61.785 | 966400.0 |
| 2005-01-10 13:00:00 | IWM | ETF | 61.795 | 62.1 | 61.78 | 62.06 | 1325200.0 |
| 2005-01-10 13:30:00 | IWM | ETF | 62.07 | 62.095 | 61.96 | 62.0 | 1547600.0 |
| 2005-01-10 14:00:00 | IWM | ETF | 62.005 | 62.01 | 61.84 | 61.89 | 1181400.0 |
| 2005-01-10 14:30:00 | IWM | ETF | 61.885 | 61.93 | 61.76 | 61.865 | 1047200.0 |
> showing 50 of 1,428 rows — these rows as CSV