PREVIEW / etf_30min / 2001-04-26
file: by_date/etf_30min/2001/2001-04-26.parquet size: 15 KB rows: 372
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-04-26 09:30:00 | SPY | ETF | 123.73 | 124.1 | 123.51 | 124.06 | 1108600.0 |
| 2001-04-26 10:00:00 | SPY | ETF | 124.0 | 124.58 | 123.92 | 124.33 | 1296200.0 |
| 2001-04-26 10:30:00 | SPY | ETF | 124.35 | 124.65 | 124.15 | 124.5 | 715200.0 |
| 2001-04-26 11:00:00 | SPY | ETF | 124.54 | 124.54 | 123.82 | 124.03 | 662900.0 |
| 2001-04-26 11:30:00 | SPY | ETF | 124.0 | 124.28 | 123.98 | 124.07 | 213400.0 |
| 2001-04-26 12:00:00 | SPY | ETF | 124.09 | 124.32 | 123.82 | 124.25 | 276200.0 |
| 2001-04-26 12:30:00 | SPY | ETF | 124.35 | 124.94 | 124.35 | 124.78 | 391600.0 |
| 2001-04-26 13:00:00 | SPY | ETF | 124.87 | 125.18 | 124.6 | 125.18 | 334500.0 |
| 2001-04-26 13:30:00 | SPY | ETF | 125.15 | 125.22 | 124.58 | 124.75 | 409600.0 |
| 2001-04-26 14:00:00 | SPY | ETF | 124.87 | 124.87 | 124.3 | 124.55 | 623900.0 |
| 2001-04-26 14:30:00 | SPY | ETF | 124.56 | 124.65 | 123.68 | 123.81 | 1142100.0 |
| 2001-04-26 15:00:00 | SPY | ETF | 123.88 | 124.23 | 123.5 | 124.0 | 1123400.0 |
| 2001-04-26 15:30:00 | SPY | ETF | 124.01 | 124.09 | 123.55 | 123.74 | 865100.0 |
| 2001-04-26 16:00:00 | SPY | ETF | 123.83 | 124.16 | 123.66 | 123.82 | 840100.0 |
| 2001-04-26 16:30:00 | SPY | ETF | 124.83 | 126.0 | 123.85 | 124.0 | 1100.0 |
| 2001-04-26 17:30:00 | SPY | ETF | 124.98 | 124.98 | 123.01 | 123.01 | 300.0 |
| 2001-04-26 18:00:00 | SPY | ETF | 124.98 | 124.98 | 123.01 | 123.01 | 300.0 |
| 2001-04-26 09:30:00 | QQQ | ETF | 45.9 | 45.95 | 45.25 | 45.62 | 8936400.0 |
| 2001-04-26 10:00:00 | QQQ | ETF | 45.6 | 46.0 | 45.52 | 45.64 | 5637200.0 |
| 2001-04-26 10:30:00 | QQQ | ETF | 45.68 | 45.92 | 45.42 | 45.82 | 3303100.0 |
| 2001-04-26 11:00:00 | QQQ | ETF | 45.81 | 45.83 | 44.95 | 45.1 | 6254300.0 |
| 2001-04-26 11:30:00 | QQQ | ETF | 45.08 | 45.42 | 45.01 | 45.25 | 3510100.0 |
| 2001-04-26 12:00:00 | QQQ | ETF | 45.24 | 45.54 | 45.03 | 45.53 | 2620100.0 |
| 2001-04-26 12:30:00 | QQQ | ETF | 45.52 | 45.83 | 45.49 | 45.7 | 3928600.0 |
| 2001-04-26 13:00:00 | QQQ | ETF | 45.79 | 45.85 | 45.51 | 45.77 | 2304700.0 |
| 2001-04-26 13:30:00 | QQQ | ETF | 45.77 | 45.77 | 45.25 | 45.39 | 2865500.0 |
| 2001-04-26 14:00:00 | QQQ | ETF | 45.38 | 45.4 | 44.75 | 44.93 | 7186900.0 |
| 2001-04-26 14:30:00 | QQQ | ETF | 44.95 | 45.02 | 44.04 | 44.22 | 7223600.0 |
| 2001-04-26 15:00:00 | QQQ | ETF | 44.23 | 44.55 | 43.89 | 44.08 | 6103100.0 |
| 2001-04-26 15:30:00 | QQQ | ETF | 44.1 | 44.4 | 43.87 | 43.94 | 5092300.0 |
| 2001-04-26 16:00:00 | QQQ | ETF | 43.94 | 44.54 | 43.9 | 43.95 | 1682100.0 |
| 2001-04-26 16:30:00 | QQQ | ETF | 43.91 | 44.25 | 43.9 | 44.18 | 66600.0 |
| 2001-04-26 17:00:00 | QQQ | ETF | 44.16 | 44.18 | 44.04 | 44.04 | 70400.0 |
| 2001-04-26 17:30:00 | QQQ | ETF | 44.05 | 44.14 | 43.99 | 44.05 | 8400.0 |
| 2001-04-26 18:00:00 | QQQ | ETF | 44.02 | 44.09 | 44.02 | 44.04 | 3700.0 |
| 2001-04-26 09:30:00 | IWM | ETF | 47.25 | 47.425 | 47.175 | 47.425 | 83400.0 |
| 2001-04-26 10:00:00 | IWM | ETF | 47.525 | 47.825 | 47.525 | 47.825 | 59800.0 |
| 2001-04-26 10:30:00 | IWM | ETF | 47.755 | 47.85 | 47.75 | 47.85 | 2200.0 |
| 2001-04-26 11:00:00 | IWM | ETF | 47.825 | 47.825 | 47.6 | 47.675 | 18400.0 |
| 2001-04-26 11:30:00 | IWM | ETF | 47.675 | 47.775 | 47.675 | 47.675 | 18800.0 |
| 2001-04-26 12:00:00 | IWM | ETF | 47.845 | 47.845 | 47.655 | 47.75 | 2600.0 |
| 2001-04-26 12:30:00 | IWM | ETF | 47.65 | 47.875 | 47.65 | 47.875 | 2800.0 |
| 2001-04-26 13:00:00 | IWM | ETF | 47.95 | 47.95 | 47.755 | 47.765 | 12600.0 |
| 2001-04-26 13:30:00 | IWM | ETF | 47.8 | 47.95 | 47.8 | 47.95 | 2200.0 |
| 2001-04-26 14:00:00 | IWM | ETF | 47.8 | 47.9 | 47.75 | 47.9 | 1800.0 |
| 2001-04-26 14:30:00 | IWM | ETF | 47.845 | 47.87 | 47.45 | 47.45 | 18800.0 |
| 2001-04-26 15:00:00 | IWM | ETF | 47.5 | 47.575 | 47.4 | 47.575 | 5600.0 |
| 2001-04-26 15:30:00 | IWM | ETF | 47.725 | 47.725 | 47.475 | 47.625 | 26000.0 |
| 2001-04-26 16:00:00 | IWM | ETF | 47.675 | 47.85 | 47.675 | 47.85 | 17200.0 |
| 2001-04-26 09:30:00 | DIA | ETF | 106.7 | 106.7 | 106.29 | 106.69 | 272200.0 |
> showing 50 of 372 rows — these rows as CSV