PREVIEW / etf_30min / 2004-11-23
file: by_date/etf_30min/2004/2004-11-23.parquet size: 40 KB rows: 1,329
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 |
|---|---|---|---|---|---|---|---|
| 2004-11-23 08:00:00 | SPY | ETF | 117.92 | 117.94 | 117.89 | 117.94 | 9000.0 |
| 2004-11-23 08:30:00 | SPY | ETF | 117.94 | 117.95 | 117.93 | 117.94 | 18000.0 |
| 2004-11-23 09:00:00 | SPY | ETF | 117.95 | 118.0 | 117.92 | 117.95 | 64600.0 |
| 2004-11-23 09:30:00 | SPY | ETF | 117.93 | 117.97 | 117.75 | 117.89 | 4071100.0 |
| 2004-11-23 10:00:00 | SPY | ETF | 117.86 | 118.24 | 117.79 | 118.07 | 4169500.0 |
| 2004-11-23 10:30:00 | SPY | ETF | 118.07 | 118.09 | 117.51 | 117.55 | 5257300.0 |
| 2004-11-23 11:00:00 | SPY | ETF | 117.55 | 117.61 | 117.37 | 117.5 | 3637200.0 |
| 2004-11-23 11:30:00 | SPY | ETF | 117.49 | 117.58 | 117.45 | 117.51 | 2710000.0 |
| 2004-11-23 12:00:00 | SPY | ETF | 117.51 | 117.59 | 117.43 | 117.52 | 1779900.0 |
| 2004-11-23 12:30:00 | SPY | ETF | 117.53 | 117.65 | 117.51 | 117.54 | 2163400.0 |
| 2004-11-23 13:00:00 | SPY | ETF | 117.53 | 117.72 | 117.46 | 117.68 | 1291300.0 |
| 2004-11-23 13:30:00 | SPY | ETF | 117.69 | 117.72 | 117.57 | 117.69 | 987400.0 |
| 2004-11-23 14:00:00 | SPY | ETF | 117.68 | 118.26 | 117.67 | 118.16 | 4715000.0 |
| 2004-11-23 14:30:00 | SPY | ETF | 118.16 | 118.17 | 117.86 | 117.93 | 1803400.0 |
| 2004-11-23 15:00:00 | SPY | ETF | 117.93 | 118.06 | 117.72 | 117.97 | 2761000.0 |
| 2004-11-23 15:30:00 | SPY | ETF | 117.96 | 118.0 | 117.74 | 118.0 | 3238300.0 |
| 2004-11-23 16:00:00 | SPY | ETF | 117.97 | 118.2 | 117.8778 | 118.15 | 1470300.0 |
| 2004-11-23 16:30:00 | SPY | ETF | 118.14 | 118.24 | 117.8978 | 118.19 | 667600.0 |
| 2004-11-23 17:00:00 | SPY | ETF | 118.19 | 118.19 | 118.18 | 118.18 | 6500.0 |
| 2004-11-23 17:30:00 | SPY | ETF | 118.16 | 118.18 | 118.13 | 118.18 | 8300.0 |
| 2004-11-23 18:00:00 | SPY | ETF | 118.2 | 118.2 | 118.15 | 118.15 | 2500.0 |
| 2004-11-23 18:30:00 | SPY | ETF | 118.19 | 118.2 | 118.19 | 118.2 | 2200.0 |
| 2004-11-23 08:00:00 | QQQ | ETF | 38.98 | 39.0 | 38.97 | 38.98 | 24400.0 |
| 2004-11-23 08:30:00 | QQQ | ETF | 38.99 | 39.01 | 38.99 | 38.99 | 49700.0 |
| 2004-11-23 09:00:00 | QQQ | ETF | 38.99 | 39.02 | 38.99 | 39.01 | 82300.0 |
| 2004-11-23 09:30:00 | QQQ | ETF | 39.01 | 39.03 | 38.87 | 38.96 | 8931000.0 |
| 2004-11-23 10:00:00 | QQQ | ETF | 38.95 | 39.15 | 38.93 | 39.05 | 9598600.0 |
| 2004-11-23 10:30:00 | QQQ | ETF | 39.05 | 39.08 | 38.75 | 38.79 | 9231200.0 |
| 2004-11-23 11:00:00 | QQQ | ETF | 38.79 | 38.8 | 38.61 | 38.68 | 9552400.0 |
| 2004-11-23 11:30:00 | QQQ | ETF | 38.68 | 38.73 | 38.66 | 38.68 | 2586000.0 |
| 2004-11-23 12:00:00 | QQQ | ETF | 38.68 | 38.71 | 38.63 | 38.67 | 3778200.0 |
| 2004-11-23 12:30:00 | QQQ | ETF | 38.67 | 38.73 | 38.647 | 38.69 | 2362500.0 |
| 2004-11-23 13:00:00 | QQQ | ETF | 38.69 | 38.75 | 38.659 | 38.72 | 2598300.0 |
| 2004-11-23 13:30:00 | QQQ | ETF | 38.72 | 38.75 | 38.7 | 38.735 | 2709800.0 |
| 2004-11-23 14:00:00 | QQQ | ETF | 38.734 | 39.0 | 38.734 | 38.94 | 13258800.0 |
| 2004-11-23 14:30:00 | QQQ | ETF | 38.94 | 38.98 | 38.84 | 38.87 | 6993200.0 |
| 2004-11-23 15:00:00 | QQQ | ETF | 38.87 | 38.95 | 38.8 | 38.9 | 6577700.0 |
| 2004-11-23 15:30:00 | QQQ | ETF | 38.9 | 38.92 | 38.82 | 38.89 | 5419900.0 |
| 2004-11-23 16:00:00 | QQQ | ETF | 38.9 | 39.03 | 38.895 | 39.01 | 2420200.0 |
| 2004-11-23 16:30:00 | QQQ | ETF | 39.0 | 39.06 | 39.0 | 39.05 | 692800.0 |
| 2004-11-23 17:00:00 | QQQ | ETF | 39.04 | 39.06 | 39.04 | 39.05 | 261800.0 |
| 2004-11-23 17:30:00 | QQQ | ETF | 39.05 | 39.06 | 39.03 | 39.05 | 48800.0 |
| 2004-11-23 18:00:00 | QQQ | ETF | 39.06 | 39.069 | 39.05 | 39.05 | 6100.0 |
| 2004-11-23 18:30:00 | QQQ | ETF | 39.07 | 39.07 | 39.03 | 39.05 | 900.0 |
| 2004-11-23 19:00:00 | QQQ | ETF | 39.06 | 39.06 | 39.06 | 39.06 | 600.0 |
| 2004-11-23 19:30:00 | QQQ | ETF | 39.06 | 39.1 | 39.04 | 39.1 | 10100.0 |
| 2004-11-23 08:00:00 | IWM | ETF | 61.975 | 61.975 | 61.975 | 61.975 | 3800.0 |
| 2004-11-23 08:30:00 | IWM | ETF | 61.975 | 61.975 | 61.975 | 61.975 | 20000.0 |
| 2004-11-23 09:00:00 | IWM | ETF | 62.0 | 62.0 | 62.0 | 62.0 | 3800.0 |
| 2004-11-23 09:30:00 | IWM | ETF | 61.965 | 62.1 | 61.83 | 62.04 | 1008800.0 |
> showing 50 of 1,329 rows — these rows as CSV