PREVIEW / etf_30min / 2001-05-10
file: by_date/etf_30min/2001/2001-05-10.parquet size: 14 KB rows: 351
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-05-10 09:30:00 | SPY | ETF | 127.26 | 127.5 | 126.71 | 126.99 | 1676600.0 |
| 2001-05-10 10:00:00 | SPY | ETF | 126.99 | 127.24 | 126.7 | 126.85 | 617400.0 |
| 2001-05-10 10:30:00 | SPY | ETF | 126.93 | 127.2 | 126.83 | 127.0 | 251100.0 |
| 2001-05-10 11:00:00 | SPY | ETF | 126.97 | 127.0 | 126.55 | 126.72 | 450400.0 |
| 2001-05-10 11:30:00 | SPY | ETF | 126.76 | 126.77 | 126.34 | 126.46 | 272700.0 |
| 2001-05-10 12:00:00 | SPY | ETF | 126.47 | 126.47 | 126.02 | 126.07 | 496900.0 |
| 2001-05-10 12:30:00 | SPY | ETF | 126.03 | 126.42 | 125.98 | 126.25 | 396400.0 |
| 2001-05-10 13:00:00 | SPY | ETF | 126.21 | 126.58 | 126.06 | 126.55 | 241800.0 |
| 2001-05-10 13:30:00 | SPY | ETF | 126.55 | 126.65 | 126.27 | 126.58 | 163500.0 |
| 2001-05-10 14:00:00 | SPY | ETF | 126.56 | 126.62 | 126.06 | 126.1 | 308500.0 |
| 2001-05-10 14:30:00 | SPY | ETF | 126.13 | 126.38 | 125.85 | 125.98 | 449800.0 |
| 2001-05-10 15:00:00 | SPY | ETF | 126.02 | 126.32 | 125.9 | 126.09 | 307100.0 |
| 2001-05-10 15:30:00 | SPY | ETF | 126.07 | 126.07 | 125.77 | 125.99 | 472800.0 |
| 2001-05-10 16:00:00 | SPY | ETF | 125.98 | 126.17 | 125.8 | 125.84 | 536200.0 |
| 2001-05-10 16:30:00 | SPY | ETF | 126.15 | 126.15 | 126.15 | 126.15 | 700.0 |
| 2001-05-10 17:00:00 | SPY | ETF | 126.15 | 126.28 | 126.15 | 126.28 | 1100.0 |
| 2001-05-10 17:30:00 | SPY | ETF | 126.17 | 126.17 | 126.17 | 126.17 | 300.0 |
| 2001-05-10 09:30:00 | QQQ | ETF | 47.92 | 48.05 | 47.31 | 47.5 | 9503600.0 |
| 2001-05-10 10:00:00 | QQQ | ETF | 47.5 | 47.75 | 47.15 | 47.32 | 4818400.0 |
| 2001-05-10 10:30:00 | QQQ | ETF | 47.3 | 47.7 | 47.25 | 47.53 | 2966400.0 |
| 2001-05-10 11:00:00 | QQQ | ETF | 47.53 | 47.6 | 47.05 | 47.25 | 3616900.0 |
| 2001-05-10 11:30:00 | QQQ | ETF | 47.22 | 47.26 | 46.75 | 46.85 | 4058900.0 |
| 2001-05-10 12:00:00 | QQQ | ETF | 46.82 | 46.82 | 46.41 | 46.58 | 5236500.0 |
| 2001-05-10 12:30:00 | QQQ | ETF | 46.57 | 46.87 | 46.44 | 46.55 | 3397700.0 |
| 2001-05-10 13:00:00 | QQQ | ETF | 46.6 | 47.05 | 46.45 | 47.0 | 4210900.0 |
| 2001-05-10 13:30:00 | QQQ | ETF | 47.01 | 47.07 | 46.6 | 46.85 | 1959500.0 |
| 2001-05-10 14:00:00 | QQQ | ETF | 46.88 | 46.98 | 46.28 | 46.33 | 3676400.0 |
| 2001-05-10 14:30:00 | QQQ | ETF | 46.35 | 46.55 | 46.09 | 46.15 | 4448100.0 |
| 2001-05-10 15:00:00 | QQQ | ETF | 46.19 | 46.47 | 46.02 | 46.12 | 3151500.0 |
| 2001-05-10 15:30:00 | QQQ | ETF | 46.13 | 46.17 | 45.75 | 45.82 | 5847300.0 |
| 2001-05-10 16:00:00 | QQQ | ETF | 45.8 | 45.89 | 45.72 | 45.75 | 955900.0 |
| 2001-05-10 16:30:00 | QQQ | ETF | 45.75 | 47.49 | 45.6 | 45.78 | 312800.0 |
| 2001-05-10 17:00:00 | QQQ | ETF | 45.78 | 46.0 | 45.75 | 45.85 | 312100.0 |
| 2001-05-10 17:30:00 | QQQ | ETF | 45.85 | 45.87 | 45.7 | 45.7 | 22300.0 |
| 2001-05-10 18:00:00 | QQQ | ETF | 45.7 | 45.8 | 45.6 | 45.7 | 28700.0 |
| 2001-05-10 09:30:00 | IWM | ETF | 49.425 | 49.425 | 49.125 | 49.125 | 43800.0 |
| 2001-05-10 10:00:00 | IWM | ETF | 49.13 | 49.325 | 49.13 | 49.13 | 13400.0 |
| 2001-05-10 10:30:00 | IWM | ETF | 49.13 | 49.275 | 49.13 | 49.25 | 26600.0 |
| 2001-05-10 11:00:00 | IWM | ETF | 49.2 | 49.29 | 49.125 | 49.13 | 14800.0 |
| 2001-05-10 11:30:00 | IWM | ETF | 49.13 | 49.265 | 49.0 | 49.025 | 45200.0 |
| 2001-05-10 12:00:00 | IWM | ETF | 49.025 | 49.22 | 48.925 | 49.195 | 63600.0 |
| 2001-05-10 12:30:00 | IWM | ETF | 49.01 | 49.025 | 48.925 | 48.925 | 19000.0 |
| 2001-05-10 13:00:00 | IWM | ETF | 48.925 | 49.17 | 48.925 | 49.0 | 29800.0 |
| 2001-05-10 13:30:00 | IWM | ETF | 49.05 | 49.2 | 48.975 | 48.975 | 15200.0 |
| 2001-05-10 14:00:00 | IWM | ETF | 48.975 | 49.15 | 48.95 | 48.95 | 25600.0 |
| 2001-05-10 14:30:00 | IWM | ETF | 48.9 | 49.125 | 48.9 | 49.05 | 99200.0 |
| 2001-05-10 15:00:00 | IWM | ETF | 48.85 | 49.09 | 48.85 | 48.955 | 34400.0 |
| 2001-05-10 15:30:00 | IWM | ETF | 48.975 | 49.0 | 48.75 | 48.88 | 83600.0 |
| 2001-05-10 16:00:00 | IWM | ETF | 48.9 | 48.9 | 48.75 | 48.75 | 37400.0 |
| 2001-05-10 09:30:00 | DIA | ETF | 109.74 | 109.83 | 109.35 | 109.55 | 452500.0 |
> showing 50 of 351 rows — these rows as CSV