PREVIEW / etf_30min / 2001-06-12
file: by_date/etf_30min/2001/2001-06-12.parquet size: 15 KB rows: 358
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-06-12 09:30:00 | SPY | ETF | 124.86 | 125.07 | 124.75 | 124.92 | 1305000.0 |
| 2001-06-12 10:00:00 | SPY | ETF | 124.92 | 124.92 | 124.2 | 124.22 | 1040100.0 |
| 2001-06-12 10:30:00 | SPY | ETF | 124.27 | 124.32 | 124.04 | 124.25 | 543100.0 |
| 2001-06-12 11:00:00 | SPY | ETF | 124.3 | 124.43 | 124.11 | 124.18 | 619000.0 |
| 2001-06-12 11:30:00 | SPY | ETF | 124.19 | 124.54 | 124.14 | 124.52 | 449500.0 |
| 2001-06-12 12:00:00 | SPY | ETF | 124.53 | 124.54 | 124.3 | 124.32 | 223300.0 |
| 2001-06-12 12:30:00 | SPY | ETF | 124.33 | 124.44 | 124.24 | 124.27 | 215900.0 |
| 2001-06-12 13:00:00 | SPY | ETF | 124.34 | 124.74 | 124.25 | 124.72 | 210400.0 |
| 2001-06-12 13:30:00 | SPY | ETF | 124.7 | 125.2 | 124.7 | 125.03 | 615800.0 |
| 2001-06-12 14:00:00 | SPY | ETF | 125.01 | 125.54 | 125.01 | 125.2 | 617500.0 |
| 2001-06-12 14:30:00 | SPY | ETF | 125.16 | 125.78 | 124.95 | 125.78 | 459400.0 |
| 2001-06-12 15:00:00 | SPY | ETF | 125.79 | 126.59 | 125.7 | 126.59 | 1313400.0 |
| 2001-06-12 15:30:00 | SPY | ETF | 126.57 | 126.74 | 125.86 | 126.13 | 1125300.0 |
| 2001-06-12 16:00:00 | SPY | ETF | 126.13 | 126.16 | 124.56 | 125.88 | 280700.0 |
| 2001-06-12 16:30:00 | SPY | ETF | 125.8 | 125.8 | 125.8 | 125.8 | 25000.0 |
| 2001-06-12 17:30:00 | SPY | ETF | 125.78 | 125.8 | 125.74 | 125.8 | 4200.0 |
| 2001-06-12 18:00:00 | SPY | ETF | 125.98 | 125.98 | 125.98 | 125.98 | 700.0 |
| 2001-06-12 09:30:00 | QQQ | ETF | 44.87 | 45.0 | 44.55 | 44.95 | 11516600.0 |
| 2001-06-12 10:00:00 | QQQ | ETF | 44.96 | 45.02 | 44.3 | 44.43 | 7079100.0 |
| 2001-06-12 10:30:00 | QQQ | ETF | 44.43 | 44.58 | 44.23 | 44.54 | 4309100.0 |
| 2001-06-12 11:00:00 | QQQ | ETF | 44.56 | 44.73 | 44.38 | 44.42 | 3584500.0 |
| 2001-06-12 11:30:00 | QQQ | ETF | 44.42 | 44.89 | 44.42 | 44.85 | 3263100.0 |
| 2001-06-12 12:00:00 | QQQ | ETF | 44.84 | 44.86 | 44.65 | 44.7 | 2466400.0 |
| 2001-06-12 12:30:00 | QQQ | ETF | 44.73 | 44.79 | 44.5 | 44.61 | 1519100.0 |
| 2001-06-12 13:00:00 | QQQ | ETF | 44.61 | 45.01 | 44.58 | 45.0 | 3066300.0 |
| 2001-06-12 13:30:00 | QQQ | ETF | 45.0 | 45.49 | 44.96 | 45.32 | 5940500.0 |
| 2001-06-12 14:00:00 | QQQ | ETF | 45.29 | 45.81 | 45.28 | 45.56 | 6988400.0 |
| 2001-06-12 14:30:00 | QQQ | ETF | 45.56 | 46.1 | 45.28 | 46.1 | 5896800.0 |
| 2001-06-12 15:00:00 | QQQ | ETF | 46.09 | 46.62 | 45.92 | 46.61 | 9373700.0 |
| 2001-06-12 15:30:00 | QQQ | ETF | 46.62 | 46.7 | 45.9 | 46.17 | 9720000.0 |
| 2001-06-12 16:00:00 | QQQ | ETF | 46.16 | 46.19 | 45.8 | 45.96 | 1153200.0 |
| 2001-06-12 16:30:00 | QQQ | ETF | 45.9 | 45.99 | 45.25 | 45.85 | 58400.0 |
| 2001-06-12 17:00:00 | QQQ | ETF | 46.0 | 46.0 | 45.0 | 45.9 | 12900.0 |
| 2001-06-12 17:30:00 | QQQ | ETF | 45.9 | 45.96 | 45.81 | 45.9 | 10100.0 |
| 2001-06-12 18:00:00 | QQQ | ETF | 45.91 | 46.0 | 45.91 | 45.99 | 6100.0 |
| 2001-06-12 09:30:00 | IWM | ETF | 50.0 | 50.1 | 50.0 | 50.015 | 38000.0 |
| 2001-06-12 10:00:00 | IWM | ETF | 50.175 | 50.175 | 49.73 | 49.735 | 73200.0 |
| 2001-06-12 10:30:00 | IWM | ETF | 49.8 | 49.94 | 49.8 | 49.85 | 17600.0 |
| 2001-06-12 11:00:00 | IWM | ETF | 49.94 | 50.0 | 49.825 | 49.84 | 118200.0 |
| 2001-06-12 11:30:00 | IWM | ETF | 49.83 | 50.075 | 49.83 | 50.0 | 43200.0 |
| 2001-06-12 12:00:00 | IWM | ETF | 50.04 | 50.075 | 50.005 | 50.025 | 3600.0 |
| 2001-06-12 12:30:00 | IWM | ETF | 49.95 | 49.975 | 49.85 | 49.875 | 87000.0 |
| 2001-06-12 13:00:00 | IWM | ETF | 49.805 | 50.005 | 49.805 | 50.005 | 2200.0 |
| 2001-06-12 13:30:00 | IWM | ETF | 49.975 | 50.055 | 49.975 | 50.005 | 19000.0 |
| 2001-06-12 14:00:00 | IWM | ETF | 50.085 | 50.13 | 50.085 | 50.13 | 39400.0 |
| 2001-06-12 14:30:00 | IWM | ETF | 50.15 | 50.285 | 50.14 | 50.285 | 5600.0 |
| 2001-06-12 15:00:00 | IWM | ETF | 50.35 | 50.645 | 50.35 | 50.645 | 68600.0 |
| 2001-06-12 15:30:00 | IWM | ETF | 50.645 | 50.75 | 50.4 | 50.435 | 160600.0 |
| 2001-06-12 16:00:00 | IWM | ETF | 50.575 | 50.575 | 50.4 | 50.4 | 8800.0 |
| 2001-06-12 09:30:00 | DIA | ETF | 108.69 | 108.9 | 108.56 | 108.6 | 350400.0 |
> showing 50 of 358 rows — these rows as CSV