PREVIEW / etf_30min / 2005-10-25
file: by_date/etf_30min/2005/2005-10-25.parquet size: 51 KB rows: 1,722
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-10-25 07:00:00 | SPY | ETF | 119.57 | 119.59 | 119.56 | 119.56 | 49200.0 |
| 2005-10-25 07:30:00 | SPY | ETF | 119.64 | 119.67 | 119.64 | 119.67 | 10400.0 |
| 2005-10-25 08:00:00 | SPY | ETF | 119.73 | 119.75 | 119.55 | 119.65 | 197600.0 |
| 2005-10-25 08:30:00 | SPY | ETF | 119.65 | 119.67 | 119.57 | 119.64 | 528900.0 |
| 2005-10-25 09:00:00 | SPY | ETF | 119.64 | 119.77 | 119.6 | 119.74 | 679200.0 |
| 2005-10-25 09:30:00 | SPY | ETF | 119.72 | 120.03 | 119.63 | 119.95 | 6676200.0 |
| 2005-10-25 10:00:00 | SPY | ETF | 119.95 | 120.24 | 119.66 | 120.24 | 8265200.0 |
| 2005-10-25 10:30:00 | SPY | ETF | 120.23 | 120.24 | 119.97 | 120.0 | 5286900.0 |
| 2005-10-25 11:00:00 | SPY | ETF | 119.99 | 120.08 | 119.58 | 119.65 | 6213100.0 |
| 2005-10-25 11:30:00 | SPY | ETF | 119.64 | 119.65 | 119.44 | 119.48 | 6654100.0 |
| 2005-10-25 12:00:00 | SPY | ETF | 119.48 | 119.82 | 119.48 | 119.62 | 2898000.0 |
| 2005-10-25 12:30:00 | SPY | ETF | 119.61 | 119.64 | 119.38 | 119.5 | 3520200.0 |
| 2005-10-25 13:00:00 | SPY | ETF | 119.52 | 119.52 | 119.31 | 119.4 | 4124900.0 |
| 2005-10-25 13:30:00 | SPY | ETF | 119.4 | 119.41 | 118.97 | 119.1 | 5754800.0 |
| 2005-10-25 14:00:00 | SPY | ETF | 119.09 | 119.22 | 118.94 | 119.11 | 4098000.0 |
| 2005-10-25 14:30:00 | SPY | ETF | 119.11 | 119.47 | 119.04 | 119.36 | 6271500.0 |
| 2005-10-25 15:00:00 | SPY | ETF | 119.36 | 119.39 | 119.06 | 119.32 | 3301100.0 |
| 2005-10-25 15:30:00 | SPY | ETF | 119.32 | 119.87 | 119.23 | 119.74 | 9734100.0 |
| 2005-10-25 16:00:00 | SPY | ETF | 119.77 | 119.78 | 119.65 | 119.71 | 792100.0 |
| 2005-10-25 16:30:00 | SPY | ETF | 119.64 | 119.7 | 119.61 | 119.67 | 16500.0 |
| 2005-10-25 17:00:00 | SPY | ETF | 119.68 | 119.97 | 119.68 | 119.72 | 6200.0 |
| 2005-10-25 17:30:00 | SPY | ETF | 119.65 | 119.67 | 119.65 | 119.67 | 500.0 |
| 2005-10-25 18:00:00 | SPY | ETF | 119.67 | 119.7 | 119.67 | 119.7 | 1600.0 |
| 2005-10-25 19:00:00 | SPY | ETF | 119.71 | 119.71 | 119.71 | 119.71 | 2700.0 |
| 2005-10-25 09:30:00 | QQQ | ETF | 39.07 | 39.16 | 39.03 | 39.13 | 9348700.0 |
| 2005-10-25 10:00:00 | QQQ | ETF | 39.12 | 39.19 | 39.01 | 39.19 | 9425200.0 |
| 2005-10-25 10:30:00 | QQQ | ETF | 39.19 | 39.19 | 39.05 | 39.07 | 6357300.0 |
| 2005-10-25 11:00:00 | QQQ | ETF | 39.07 | 39.09 | 38.95 | 38.99 | 6792900.0 |
| 2005-10-25 11:30:00 | QQQ | ETF | 38.99 | 39.01 | 38.94 | 38.94 | 5008100.0 |
| 2005-10-25 12:00:00 | QQQ | ETF | 38.95 | 39.03 | 38.95 | 38.97 | 4977200.0 |
| 2005-10-25 12:30:00 | QQQ | ETF | 38.97 | 38.99 | 38.92 | 38.95 | 3164600.0 |
| 2005-10-25 13:00:00 | QQQ | ETF | 38.94 | 38.97 | 38.87 | 38.89 | 4777800.0 |
| 2005-10-25 13:30:00 | QQQ | ETF | 38.9 | 38.9 | 38.82 | 38.85 | 6741000.0 |
| 2005-10-25 14:00:00 | QQQ | ETF | 38.85 | 38.88 | 38.77 | 38.83 | 5920000.0 |
| 2005-10-25 14:30:00 | QQQ | ETF | 38.83 | 38.92 | 38.8 | 38.87 | 5409900.0 |
| 2005-10-25 15:00:00 | QQQ | ETF | 38.87 | 38.89 | 38.79 | 38.86 | 3982200.0 |
| 2005-10-25 15:30:00 | QQQ | ETF | 38.87 | 39.09 | 38.83 | 39.08 | 11421100.0 |
| 2005-10-25 07:00:00 | IWM | ETF | 64.08 | 64.08 | 64.08 | 64.08 | 5000.0 |
| 2005-10-25 07:30:00 | IWM | ETF | 64.18 | 64.18 | 64.18 | 64.18 | 2900.0 |
| 2005-10-25 08:00:00 | IWM | ETF | 64.17 | 64.17 | 64.12 | 64.15 | 7600.0 |
| 2005-10-25 08:30:00 | IWM | ETF | 64.17 | 64.21 | 64.12 | 64.12 | 22200.0 |
| 2005-10-25 09:00:00 | IWM | ETF | 64.12 | 64.2 | 64.11 | 64.2 | 45100.0 |
| 2005-10-25 09:30:00 | IWM | ETF | 64.21 | 64.28 | 63.92 | 64.16 | 2847000.0 |
| 2005-10-25 10:00:00 | IWM | ETF | 64.16 | 64.4 | 63.91 | 64.4 | 3588100.0 |
| 2005-10-25 10:30:00 | IWM | ETF | 64.4 | 64.4 | 64.08 | 64.08 | 1976000.0 |
| 2005-10-25 11:00:00 | IWM | ETF | 64.1 | 64.13 | 63.69 | 63.73 | 2914900.0 |
| 2005-10-25 11:30:00 | IWM | ETF | 63.71 | 63.85 | 63.6 | 63.64 | 2966100.0 |
| 2005-10-25 12:00:00 | IWM | ETF | 63.64 | 63.85 | 63.64 | 63.68 | 1458700.0 |
| 2005-10-25 12:30:00 | IWM | ETF | 63.67 | 63.7 | 63.44 | 63.5 | 1730300.0 |
| 2005-10-25 13:00:00 | IWM | ETF | 63.49 | 63.6 | 63.37 | 63.54 | 1418100.0 |
> showing 50 of 1,722 rows — these rows as CSV