PREVIEW / etf_30min / 2001-12-05
file: by_date/etf_30min/2001/2001-12-05.parquet size: 18 KB rows: 493
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 |
|---|---|---|---|---|---|---|---|
| 2001-12-05 09:30:00 | SPY | ETF | 115.61 | 116.3 | 115.58 | 116.17 | 3703500.0 |
| 2001-12-05 10:00:00 | SPY | ETF | 116.24 | 117.0 | 116.16 | 116.69 | 4199300.0 |
| 2001-12-05 10:30:00 | SPY | ETF | 116.72 | 116.79 | 116.47 | 116.74 | 1289900.0 |
| 2001-12-05 11:00:00 | SPY | ETF | 116.74 | 117.16 | 116.64 | 116.9 | 1615400.0 |
| 2001-12-05 11:30:00 | SPY | ETF | 116.92 | 117.08 | 116.82 | 116.95 | 1070700.0 |
| 2001-12-05 12:00:00 | SPY | ETF | 116.97 | 117.45 | 116.91 | 117.44 | 1446500.0 |
| 2001-12-05 12:30:00 | SPY | ETF | 117.41 | 117.48 | 117.06 | 117.09 | 1260000.0 |
| 2001-12-05 13:00:00 | SPY | ETF | 117.1 | 117.34 | 117.07 | 117.1 | 599600.0 |
| 2001-12-05 13:30:00 | SPY | ETF | 117.09 | 117.16 | 116.91 | 117.06 | 1110900.0 |
| 2001-12-05 14:00:00 | SPY | ETF | 117.02 | 117.29 | 116.8 | 117.22 | 1306400.0 |
| 2001-12-05 14:30:00 | SPY | ETF | 117.22 | 117.6 | 117.16 | 117.51 | 1531400.0 |
| 2001-12-05 15:00:00 | SPY | ETF | 117.55 | 118.0 | 117.47 | 117.98 | 1788800.0 |
| 2001-12-05 15:30:00 | SPY | ETF | 117.93 | 117.98 | 117.53 | 117.64 | 2416000.0 |
| 2001-12-05 16:00:00 | SPY | ETF | 117.74 | 117.78 | 116.96 | 117.4 | 1601000.0 |
| 2001-12-05 16:30:00 | SPY | ETF | 117.45 | 117.55 | 117.25 | 117.38 | 199200.0 |
| 2001-12-05 17:00:00 | SPY | ETF | 117.35 | 117.35 | 117.35 | 117.35 | 300.0 |
| 2001-12-05 17:30:00 | SPY | ETF | 117.4 | 117.43 | 117.4 | 117.43 | 2100.0 |
| 2001-12-05 09:30:00 | QQQ | ETF | 41.2 | 41.75 | 41.12 | 41.69 | 15910600.0 |
| 2001-12-05 10:00:00 | QQQ | ETF | 41.7 | 42.3 | 41.67 | 42.04 | 16830800.0 |
| 2001-12-05 10:30:00 | QQQ | ETF | 42.05 | 42.2 | 41.91 | 42.04 | 7851200.0 |
| 2001-12-05 11:00:00 | QQQ | ETF | 42.05 | 42.47 | 42.04 | 42.27 | 8579300.0 |
| 2001-12-05 11:30:00 | QQQ | ETF | 42.29 | 42.34 | 42.15 | 42.23 | 4322700.0 |
| 2001-12-05 12:00:00 | QQQ | ETF | 42.24 | 42.61 | 42.23 | 42.59 | 6796200.0 |
| 2001-12-05 12:30:00 | QQQ | ETF | 42.59 | 42.63 | 42.43 | 42.46 | 3809500.0 |
| 2001-12-05 13:00:00 | QQQ | ETF | 42.45 | 42.67 | 42.43 | 42.54 | 3762600.0 |
| 2001-12-05 13:30:00 | QQQ | ETF | 42.51 | 42.58 | 42.34 | 42.44 | 4848600.0 |
| 2001-12-05 14:00:00 | QQQ | ETF | 42.41 | 42.6 | 42.18 | 42.58 | 5978800.0 |
| 2001-12-05 14:30:00 | QQQ | ETF | 42.56 | 42.87 | 42.52 | 42.8 | 8532800.0 |
| 2001-12-05 15:00:00 | QQQ | ETF | 42.76 | 43.15 | 42.75 | 43.09 | 11445000.0 |
| 2001-12-05 15:30:00 | QQQ | ETF | 43.08 | 43.12 | 42.59 | 42.8 | 11626500.0 |
| 2001-12-05 16:00:00 | QQQ | ETF | 42.8 | 43.0 | 42.55 | 42.86 | 3267100.0 |
| 2001-12-05 16:30:00 | QQQ | ETF | 42.87 | 43.05 | 42.69 | 42.73 | 636500.0 |
| 2001-12-05 17:00:00 | QQQ | ETF | 42.73 | 42.82 | 42.71 | 42.78 | 53400.0 |
| 2001-12-05 17:30:00 | QQQ | ETF | 42.74 | 42.8 | 42.72 | 42.73 | 25900.0 |
| 2001-12-05 18:00:00 | QQQ | ETF | 42.75 | 42.79 | 42.71 | 42.72 | 43800.0 |
| 2001-12-05 09:30:00 | IWM | ETF | 47.05 | 47.35 | 46.9 | 47.35 | 75800.0 |
| 2001-12-05 10:00:00 | IWM | ETF | 47.325 | 47.645 | 47.275 | 47.61 | 29600.0 |
| 2001-12-05 10:30:00 | IWM | ETF | 47.59 | 47.59 | 47.405 | 47.565 | 37200.0 |
| 2001-12-05 11:00:00 | IWM | ETF | 47.54 | 47.62 | 47.38 | 47.38 | 35200.0 |
| 2001-12-05 11:30:00 | IWM | ETF | 47.425 | 47.615 | 47.425 | 47.595 | 7000.0 |
| 2001-12-05 12:00:00 | IWM | ETF | 47.62 | 47.75 | 47.6 | 47.745 | 120200.0 |
| 2001-12-05 12:30:00 | IWM | ETF | 47.8 | 47.82 | 47.675 | 47.745 | 7600.0 |
| 2001-12-05 13:00:00 | IWM | ETF | 47.79 | 47.82 | 47.625 | 47.82 | 1600.0 |
| 2001-12-05 13:30:00 | IWM | ETF | 47.775 | 47.775 | 47.665 | 47.7 | 3800.0 |
| 2001-12-05 14:00:00 | IWM | ETF | 47.55 | 47.675 | 47.55 | 47.675 | 6800.0 |
| 2001-12-05 14:30:00 | IWM | ETF | 47.7 | 47.875 | 47.7 | 47.85 | 11800.0 |
| 2001-12-05 15:00:00 | IWM | ETF | 47.85 | 47.99 | 47.76 | 47.95 | 15600.0 |
| 2001-12-05 15:30:00 | IWM | ETF | 47.95 | 47.95 | 47.645 | 47.775 | 197800.0 |
| 2001-12-05 16:00:00 | IWM | ETF | 47.775 | 47.795 | 47.575 | 47.575 | 43200.0 |
| 2001-12-05 09:30:00 | DIA | ETF | 99.73 | 100.14 | 99.6 | 100.05 | 516900.0 |
> showing 50 of 493 rows — these rows as CSV