PREVIEW / etf_30min / 2002-01-28
file: by_date/etf_30min/2002/2002-01-28.parquet size: 17 KB rows: 455
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-28 09:30:00 | SPY | ETF | 113.9 | 114.19 | 113.85 | 113.97 | 1081300.0 |
| 2002-01-28 10:00:00 | SPY | ETF | 113.96 | 114.08 | 113.7 | 113.8 | 953000.0 |
| 2002-01-28 10:30:00 | SPY | ETF | 113.78 | 113.83 | 113.61 | 113.73 | 667900.0 |
| 2002-01-28 11:00:00 | SPY | ETF | 113.69 | 113.88 | 113.68 | 113.69 | 281000.0 |
| 2002-01-28 11:30:00 | SPY | ETF | 113.68 | 113.76 | 113.42 | 113.42 | 854300.0 |
| 2002-01-28 12:00:00 | SPY | ETF | 113.44 | 113.46 | 113.07 | 113.11 | 594500.0 |
| 2002-01-28 12:30:00 | SPY | ETF | 113.15 | 113.26 | 113.06 | 113.08 | 523200.0 |
| 2002-01-28 13:00:00 | SPY | ETF | 113.11 | 113.18 | 112.92 | 113.12 | 643800.0 |
| 2002-01-28 13:30:00 | SPY | ETF | 113.14 | 113.28 | 112.95 | 112.98 | 509300.0 |
| 2002-01-28 14:00:00 | SPY | ETF | 112.98 | 113.19 | 112.97 | 113.16 | 379600.0 |
| 2002-01-28 14:30:00 | SPY | ETF | 113.15 | 113.31 | 113.02 | 113.1 | 797900.0 |
| 2002-01-28 15:00:00 | SPY | ETF | 113.04 | 113.55 | 113.04 | 113.5 | 648800.0 |
| 2002-01-28 15:30:00 | SPY | ETF | 113.52 | 113.63 | 113.39 | 113.63 | 1227000.0 |
| 2002-01-28 16:00:00 | SPY | ETF | 113.65 | 113.86 | 113.55 | 113.61 | 1204400.0 |
| 2002-01-28 16:30:00 | SPY | ETF | 113.89 | 113.9 | 113.89 | 113.9 | 3300.0 |
| 2002-01-28 17:00:00 | SPY | ETF | 113.85 | 113.85 | 113.85 | 113.85 | 1900.0 |
| 2002-01-28 17:30:00 | SPY | ETF | 113.87 | 113.9 | 113.87 | 113.9 | 1100.0 |
| 2002-01-28 18:00:00 | SPY | ETF | 113.95 | 113.95 | 113.95 | 113.95 | 200.0 |
| 2002-01-28 09:30:00 | QQQ | ETF | 39.15 | 39.39 | 39.1 | 39.25 | 7967600.0 |
| 2002-01-28 10:00:00 | QQQ | ETF | 39.23 | 39.34 | 38.98 | 39.08 | 5797500.0 |
| 2002-01-28 10:30:00 | QQQ | ETF | 39.08 | 39.2 | 38.99 | 39.1 | 3295800.0 |
| 2002-01-28 11:00:00 | QQQ | ETF | 39.11 | 39.24 | 39.07 | 39.1 | 1674200.0 |
| 2002-01-28 11:30:00 | QQQ | ETF | 39.09 | 39.12 | 38.78 | 38.79 | 3276100.0 |
| 2002-01-28 12:00:00 | QQQ | ETF | 38.79 | 38.81 | 38.5 | 38.56 | 4506900.0 |
| 2002-01-28 12:30:00 | QQQ | ETF | 38.56 | 38.7 | 38.5 | 38.5 | 1862600.0 |
| 2002-01-28 13:00:00 | QQQ | ETF | 38.51 | 38.61 | 38.42 | 38.55 | 2083400.0 |
| 2002-01-28 13:30:00 | QQQ | ETF | 38.57 | 38.68 | 38.42 | 38.45 | 2153800.0 |
| 2002-01-28 14:00:00 | QQQ | ETF | 38.46 | 38.66 | 38.45 | 38.59 | 1786600.0 |
| 2002-01-28 14:30:00 | QQQ | ETF | 38.63 | 38.78 | 38.56 | 38.59 | 2749100.0 |
| 2002-01-28 15:00:00 | QQQ | ETF | 38.6 | 38.89 | 38.56 | 38.85 | 2921800.0 |
| 2002-01-28 15:30:00 | QQQ | ETF | 38.85 | 38.97 | 38.81 | 38.95 | 5394500.0 |
| 2002-01-28 16:00:00 | QQQ | ETF | 38.95 | 39.07 | 38.91 | 38.95 | 1158400.0 |
| 2002-01-28 16:30:00 | QQQ | ETF | 38.97 | 39.16 | 38.86 | 39.09 | 237500.0 |
| 2002-01-28 17:00:00 | QQQ | ETF | 39.11 | 39.14 | 39.08 | 39.11 | 337400.0 |
| 2002-01-28 17:30:00 | QQQ | ETF | 39.11 | 39.21 | 39.11 | 39.21 | 126300.0 |
| 2002-01-28 18:00:00 | QQQ | ETF | 39.17 | 39.21 | 39.15 | 39.2 | 36900.0 |
| 2002-01-28 09:30:00 | IWM | ETF | 47.8 | 47.975 | 47.79 | 47.9 | 42400.0 |
| 2002-01-28 10:00:00 | IWM | ETF | 47.9 | 47.9 | 47.66 | 47.675 | 15000.0 |
| 2002-01-28 10:30:00 | IWM | ETF | 47.65 | 47.85 | 47.65 | 47.845 | 10000.0 |
| 2002-01-28 11:00:00 | IWM | ETF | 47.845 | 47.85 | 47.71 | 47.835 | 20200.0 |
| 2002-01-28 11:30:00 | IWM | ETF | 47.835 | 47.835 | 47.585 | 47.635 | 22200.0 |
| 2002-01-28 12:00:00 | IWM | ETF | 47.61 | 47.71 | 47.5 | 47.51 | 87600.0 |
| 2002-01-28 12:30:00 | IWM | ETF | 47.525 | 47.625 | 47.52 | 47.62 | 11000.0 |
| 2002-01-28 13:00:00 | IWM | ETF | 47.545 | 47.62 | 47.515 | 47.56 | 2600.0 |
| 2002-01-28 13:30:00 | IWM | ETF | 47.6 | 47.64 | 47.6 | 47.62 | 16800.0 |
| 2002-01-28 14:00:00 | IWM | ETF | 47.61 | 47.66 | 47.6 | 47.66 | 31000.0 |
| 2002-01-28 14:30:00 | IWM | ETF | 47.66 | 47.69 | 47.615 | 47.625 | 7600.0 |
| 2002-01-28 15:00:00 | IWM | ETF | 47.625 | 47.71 | 47.6 | 47.71 | 13800.0 |
| 2002-01-28 15:30:00 | IWM | ETF | 47.73 | 48.0 | 47.65 | 47.975 | 124400.0 |
| 2002-01-28 16:00:00 | IWM | ETF | 47.805 | 47.95 | 47.805 | 47.83 | 213000.0 |
> showing 50 of 455 rows — these rows as CSV