PREVIEW / etf_30min / 2004-11-08
file: by_date/etf_30min/2004/2004-11-08.parquet size: 36 KB rows: 1,317
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-08 08:00:00 | SPY | ETF | 116.95 | 117.03 | 116.9 | 117.02 | 103900.0 |
| 2004-11-08 08:30:00 | SPY | ETF | 116.96 | 117.04 | 116.95 | 117.03 | 31400.0 |
| 2004-11-08 09:00:00 | SPY | ETF | 117.0 | 117.0 | 116.93 | 117.0 | 48300.0 |
| 2004-11-08 09:30:00 | SPY | ETF | 117.01 | 117.23 | 116.91 | 116.96 | 3988300.0 |
| 2004-11-08 10:00:00 | SPY | ETF | 116.94 | 117.01 | 116.82 | 116.97 | 5631200.0 |
| 2004-11-08 10:30:00 | SPY | ETF | 116.97 | 117.07 | 116.79 | 117.04 | 2433300.0 |
| 2004-11-08 11:00:00 | SPY | ETF | 117.03 | 117.12 | 116.82 | 116.87 | 2316400.0 |
| 2004-11-08 11:30:00 | SPY | ETF | 116.86 | 116.97 | 116.75 | 116.88 | 2233900.0 |
| 2004-11-08 12:00:00 | SPY | ETF | 116.88 | 117.05 | 116.84 | 117.02 | 1315300.0 |
| 2004-11-08 12:30:00 | SPY | ETF | 117.02 | 117.03 | 116.8 | 116.93 | 909100.0 |
| 2004-11-08 13:00:00 | SPY | ETF | 116.93 | 116.95 | 116.72 | 116.87 | 1582300.0 |
| 2004-11-08 13:30:00 | SPY | ETF | 116.88 | 117.05 | 116.85 | 117.05 | 1437800.0 |
| 2004-11-08 14:00:00 | SPY | ETF | 117.04 | 117.13 | 116.91 | 116.93 | 2185700.0 |
| 2004-11-08 14:30:00 | SPY | ETF | 116.94 | 117.12 | 116.9 | 117.06 | 1535600.0 |
| 2004-11-08 15:00:00 | SPY | ETF | 117.06 | 117.13 | 116.91 | 117.06 | 1846600.0 |
| 2004-11-08 15:30:00 | SPY | ETF | 117.07 | 117.15 | 116.93 | 117.0 | 3313300.0 |
| 2004-11-08 16:00:00 | SPY | ETF | 117.01 | 117.17 | 116.99 | 117.08 | 1182500.0 |
| 2004-11-08 16:30:00 | SPY | ETF | 117.08 | 117.08 | 117.04 | 117.08 | 59800.0 |
| 2004-11-08 17:00:00 | SPY | ETF | 117.07 | 117.11 | 116.99 | 116.99 | 322300.0 |
| 2004-11-08 17:30:00 | SPY | ETF | 117.03 | 117.03 | 117.03 | 117.03 | 300.0 |
| 2004-11-08 18:00:00 | SPY | ETF | 117.06 | 117.06 | 117.03 | 117.05 | 3900.0 |
| 2004-11-08 19:00:00 | SPY | ETF | 117.05 | 117.05 | 117.05 | 117.05 | 300.0 |
| 2004-11-08 19:30:00 | SPY | ETF | 117.07 | 117.07 | 117.07 | 117.07 | 4600.0 |
| 2004-11-08 08:00:00 | QQQ | ETF | 37.93 | 37.97 | 37.93 | 37.96 | 66400.0 |
| 2004-11-08 08:30:00 | QQQ | ETF | 37.96 | 37.97 | 37.95 | 37.97 | 79100.0 |
| 2004-11-08 09:00:00 | QQQ | ETF | 37.97 | 37.97 | 37.94 | 37.95 | 40200.0 |
| 2004-11-08 09:30:00 | QQQ | ETF | 37.93 | 38.1 | 37.89 | 37.919 | 9231700.0 |
| 2004-11-08 10:00:00 | QQQ | ETF | 37.92 | 37.98 | 37.85 | 37.96 | 9851400.0 |
| 2004-11-08 10:30:00 | QQQ | ETF | 37.96 | 38.05 | 37.884 | 38.023 | 7620400.0 |
| 2004-11-08 11:00:00 | QQQ | ETF | 38.02 | 38.07 | 37.92 | 37.95 | 5334000.0 |
| 2004-11-08 11:30:00 | QQQ | ETF | 37.941 | 37.97 | 37.87 | 37.931 | 4298300.0 |
| 2004-11-08 12:00:00 | QQQ | ETF | 37.92 | 37.98 | 37.91 | 37.98 | 1769900.0 |
| 2004-11-08 12:30:00 | QQQ | ETF | 37.976 | 37.99 | 37.88 | 37.94 | 2664900.0 |
| 2004-11-08 13:00:00 | QQQ | ETF | 37.94 | 37.94 | 37.85 | 37.9 | 3250400.0 |
| 2004-11-08 13:30:00 | QQQ | ETF | 37.9 | 37.97 | 37.88 | 37.95 | 2287200.0 |
| 2004-11-08 14:00:00 | QQQ | ETF | 37.96 | 38.0 | 37.92 | 37.93 | 2890300.0 |
| 2004-11-08 14:30:00 | QQQ | ETF | 37.938 | 38.03 | 37.92 | 38.01 | 3858400.0 |
| 2004-11-08 15:00:00 | QQQ | ETF | 38.01 | 38.017 | 37.948 | 38.0 | 3419400.0 |
| 2004-11-08 15:30:00 | QQQ | ETF | 38.0 | 38.05 | 37.9109 | 37.97 | 7489500.0 |
| 2004-11-08 16:00:00 | QQQ | ETF | 37.973 | 38.031 | 37.94 | 38.0 | 1171000.0 |
| 2004-11-08 16:30:00 | QQQ | ETF | 38.0 | 38.012 | 37.97 | 37.971 | 59900.0 |
| 2004-11-08 17:00:00 | QQQ | ETF | 37.98 | 37.987 | 37.98 | 37.98 | 5800.0 |
| 2004-11-08 17:30:00 | QQQ | ETF | 37.98 | 37.98 | 37.97 | 37.97 | 6000.0 |
| 2004-11-08 18:00:00 | QQQ | ETF | 37.99 | 38.0 | 37.98 | 38.0 | 8600.0 |
| 2004-11-08 18:30:00 | QQQ | ETF | 37.99 | 38.0 | 37.99 | 38.0 | 4000.0 |
| 2004-11-08 19:00:00 | QQQ | ETF | 38.0 | 38.0 | 38.0 | 38.0 | 8400.0 |
| 2004-11-08 19:30:00 | QQQ | ETF | 38.01 | 38.02 | 37.98 | 37.98 | 13800.0 |
| 2004-11-08 08:30:00 | IWM | ETF | 60.155 | 60.155 | 60.155 | 60.155 | 9800.0 |
| 2004-11-08 09:30:00 | IWM | ETF | 60.215 | 60.435 | 60.175 | 60.185 | 822400.0 |
| 2004-11-08 10:00:00 | IWM | ETF | 60.165 | 60.235 | 60.095 | 60.17 | 534800.0 |
> showing 50 of 1,317 rows — these rows as CSV