PREVIEW / etf_30min / 2001-05-15
file: by_date/etf_30min/2001/2001-05-15.parquet size: 14 KB rows: 350
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-15 09:30:00 | SPY | ETF | 125.55 | 125.55 | 125.03 | 125.37 | 947200.0 |
| 2001-05-15 10:00:00 | SPY | ETF | 125.35 | 125.65 | 125.33 | 125.55 | 992400.0 |
| 2001-05-15 10:30:00 | SPY | ETF | 125.55 | 125.58 | 125.25 | 125.34 | 224000.0 |
| 2001-05-15 11:00:00 | SPY | ETF | 125.29 | 125.47 | 125.21 | 125.47 | 154900.0 |
| 2001-05-15 11:30:00 | SPY | ETF | 125.43 | 125.52 | 125.18 | 125.2 | 349800.0 |
| 2001-05-15 12:00:00 | SPY | ETF | 125.27 | 125.34 | 125.19 | 125.33 | 194500.0 |
| 2001-05-15 12:30:00 | SPY | ETF | 125.28 | 125.48 | 125.28 | 125.33 | 102000.0 |
| 2001-05-15 13:00:00 | SPY | ETF | 125.34 | 125.43 | 125.22 | 125.34 | 249400.0 |
| 2001-05-15 13:30:00 | SPY | ETF | 125.31 | 125.38 | 125.15 | 125.2 | 366200.0 |
| 2001-05-15 14:00:00 | SPY | ETF | 125.22 | 126.0 | 124.85 | 125.3 | 1740800.0 |
| 2001-05-15 14:30:00 | SPY | ETF | 125.34 | 126.08 | 125.16 | 125.98 | 1323100.0 |
| 2001-05-15 15:00:00 | SPY | ETF | 125.98 | 126.22 | 125.5 | 125.65 | 634600.0 |
| 2001-05-15 15:30:00 | SPY | ETF | 125.75 | 125.9 | 124.95 | 125.3 | 1014300.0 |
| 2001-05-15 16:00:00 | SPY | ETF | 125.3 | 125.98 | 125.2 | 125.9 | 792700.0 |
| 2001-05-15 16:30:00 | SPY | ETF | 125.9 | 125.9 | 125.66 | 125.66 | 600.0 |
| 2001-05-15 17:00:00 | SPY | ETF | 125.62 | 125.64 | 125.62 | 125.64 | 1600.0 |
| 2001-05-15 18:00:00 | SPY | ETF | 125.62 | 125.62 | 125.62 | 125.62 | 300.0 |
| 2001-05-15 09:30:00 | QQQ | ETF | 44.9 | 45.14 | 44.65 | 45.05 | 4931400.0 |
| 2001-05-15 10:00:00 | QQQ | ETF | 45.06 | 45.6 | 45.03 | 45.48 | 5127100.0 |
| 2001-05-15 10:30:00 | QQQ | ETF | 45.48 | 45.57 | 45.14 | 45.2 | 3814200.0 |
| 2001-05-15 11:00:00 | QQQ | ETF | 45.18 | 45.35 | 45.09 | 45.34 | 1438600.0 |
| 2001-05-15 11:30:00 | QQQ | ETF | 45.35 | 45.37 | 45.01 | 45.04 | 1301800.0 |
| 2001-05-15 12:00:00 | QQQ | ETF | 45.05 | 45.18 | 45.01 | 45.17 | 1833500.0 |
| 2001-05-15 12:30:00 | QQQ | ETF | 45.15 | 45.34 | 45.1 | 45.25 | 1255700.0 |
| 2001-05-15 13:00:00 | QQQ | ETF | 45.27 | 45.32 | 45.17 | 45.22 | 1387800.0 |
| 2001-05-15 13:30:00 | QQQ | ETF | 45.2 | 45.28 | 45.09 | 45.15 | 1784100.0 |
| 2001-05-15 14:00:00 | QQQ | ETF | 45.18 | 46.15 | 44.92 | 45.25 | 13569500.0 |
| 2001-05-15 14:30:00 | QQQ | ETF | 45.15 | 46.0 | 45.1 | 45.98 | 9050500.0 |
| 2001-05-15 15:00:00 | QQQ | ETF | 45.95 | 46.3 | 45.65 | 45.75 | 9139200.0 |
| 2001-05-15 15:30:00 | QQQ | ETF | 45.78 | 45.9 | 44.58 | 44.75 | 8312300.0 |
| 2001-05-15 16:00:00 | QQQ | ETF | 44.75 | 46.1 | 44.65 | 45.14 | 3132000.0 |
| 2001-05-15 16:30:00 | QQQ | ETF | 45.15 | 45.15 | 44.75 | 45.0 | 281600.0 |
| 2001-05-15 17:00:00 | QQQ | ETF | 44.95 | 45.0 | 44.9 | 45.0 | 58900.0 |
| 2001-05-15 17:30:00 | QQQ | ETF | 45.03 | 45.2 | 45.03 | 45.06 | 59100.0 |
| 2001-05-15 18:00:00 | QQQ | ETF | 45.1 | 45.15 | 45.0 | 45.15 | 4100.0 |
| 2001-05-15 09:30:00 | IWM | ETF | 48.5 | 48.61 | 48.425 | 48.61 | 11200.0 |
| 2001-05-15 10:00:00 | IWM | ETF | 48.45 | 48.72 | 48.45 | 48.6 | 26200.0 |
| 2001-05-15 10:30:00 | IWM | ETF | 48.6 | 48.75 | 48.525 | 48.525 | 16800.0 |
| 2001-05-15 11:00:00 | IWM | ETF | 48.5 | 48.675 | 48.5 | 48.525 | 4600.0 |
| 2001-05-15 11:30:00 | IWM | ETF | 48.65 | 48.7 | 48.575 | 48.58 | 14600.0 |
| 2001-05-15 12:00:00 | IWM | ETF | 48.575 | 48.58 | 48.505 | 48.505 | 1200.0 |
| 2001-05-15 12:30:00 | IWM | ETF | 48.505 | 48.65 | 48.505 | 48.515 | 1600.0 |
| 2001-05-15 13:00:00 | IWM | ETF | 48.535 | 48.65 | 48.535 | 48.54 | 9200.0 |
| 2001-05-15 13:30:00 | IWM | ETF | 48.625 | 48.695 | 48.545 | 48.64 | 4000.0 |
| 2001-05-15 14:00:00 | IWM | ETF | 48.565 | 48.95 | 48.53 | 48.55 | 6600.0 |
| 2001-05-15 14:30:00 | IWM | ETF | 48.75 | 48.945 | 48.7 | 48.945 | 33800.0 |
| 2001-05-15 15:00:00 | IWM | ETF | 48.975 | 49.1 | 48.775 | 48.9 | 182200.0 |
| 2001-05-15 15:30:00 | IWM | ETF | 48.905 | 48.98 | 48.65 | 48.805 | 74000.0 |
| 2001-05-15 16:00:00 | IWM | ETF | 49.075 | 49.1 | 48.655 | 48.925 | 18000.0 |
| 2001-05-15 09:30:00 | DIA | ETF | 109.1 | 109.1 | 108.7 | 108.88 | 154400.0 |
> showing 50 of 350 rows — these rows as CSV