PREVIEW / etf_30min / 2001-05-14
file: by_date/etf_30min/2001/2001-05-14.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-14 09:30:00 | SPY | ETF | 124.9 | 125.15 | 124.63 | 124.7 | 1271000.0 |
| 2001-05-14 10:00:00 | SPY | ETF | 124.74 | 125.19 | 124.52 | 125.0 | 1111300.0 |
| 2001-05-14 10:30:00 | SPY | ETF | 125.05 | 125.05 | 124.63 | 124.71 | 365800.0 |
| 2001-05-14 11:00:00 | SPY | ETF | 124.7 | 124.74 | 124.47 | 124.58 | 444900.0 |
| 2001-05-14 11:30:00 | SPY | ETF | 124.51 | 124.74 | 124.46 | 124.59 | 540100.0 |
| 2001-05-14 12:00:00 | SPY | ETF | 124.64 | 124.83 | 124.55 | 124.66 | 133400.0 |
| 2001-05-14 12:30:00 | SPY | ETF | 124.72 | 124.97 | 124.65 | 124.83 | 346100.0 |
| 2001-05-14 13:00:00 | SPY | ETF | 124.8 | 124.82 | 124.61 | 124.72 | 117500.0 |
| 2001-05-14 13:30:00 | SPY | ETF | 124.72 | 124.89 | 124.52 | 124.57 | 150100.0 |
| 2001-05-14 14:00:00 | SPY | ETF | 124.64 | 124.78 | 124.46 | 124.56 | 306300.0 |
| 2001-05-14 14:30:00 | SPY | ETF | 124.62 | 124.88 | 124.47 | 124.82 | 315900.0 |
| 2001-05-14 15:00:00 | SPY | ETF | 124.77 | 125.07 | 124.62 | 124.95 | 364500.0 |
| 2001-05-14 15:30:00 | SPY | ETF | 124.99 | 125.44 | 124.99 | 125.23 | 1723500.0 |
| 2001-05-14 16:00:00 | SPY | ETF | 125.22 | 125.4 | 124.67 | 125.4 | 488900.0 |
| 2001-05-14 16:30:00 | SPY | ETF | 125.35 | 125.45 | 125.32 | 125.32 | 9700.0 |
| 2001-05-14 17:00:00 | SPY | ETF | 125.26 | 125.26 | 125.25 | 125.25 | 700.0 |
| 2001-05-14 09:30:00 | QQQ | ETF | 45.3 | 45.36 | 44.6 | 44.72 | 6770600.0 |
| 2001-05-14 10:00:00 | QQQ | ETF | 44.73 | 44.92 | 44.47 | 44.8 | 4778300.0 |
| 2001-05-14 10:30:00 | QQQ | ETF | 44.8 | 44.85 | 44.54 | 44.58 | 1815800.0 |
| 2001-05-14 11:00:00 | QQQ | ETF | 44.58 | 44.59 | 44.26 | 44.35 | 2721300.0 |
| 2001-05-14 11:30:00 | QQQ | ETF | 44.35 | 44.56 | 44.34 | 44.54 | 2050400.0 |
| 2001-05-14 12:00:00 | QQQ | ETF | 44.46 | 44.65 | 44.38 | 44.55 | 1380600.0 |
| 2001-05-14 12:30:00 | QQQ | ETF | 44.58 | 44.83 | 44.55 | 44.68 | 1981800.0 |
| 2001-05-14 13:00:00 | QQQ | ETF | 44.66 | 44.69 | 44.33 | 44.47 | 1552500.0 |
| 2001-05-14 13:30:00 | QQQ | ETF | 44.49 | 44.6 | 44.35 | 44.42 | 2747000.0 |
| 2001-05-14 14:00:00 | QQQ | ETF | 44.43 | 44.59 | 44.28 | 44.38 | 1777100.0 |
| 2001-05-14 14:30:00 | QQQ | ETF | 44.35 | 44.4 | 44.11 | 44.39 | 3066400.0 |
| 2001-05-14 15:00:00 | QQQ | ETF | 44.38 | 44.57 | 44.26 | 44.5 | 2425300.0 |
| 2001-05-14 15:30:00 | QQQ | ETF | 44.53 | 44.9 | 44.46 | 44.69 | 6709900.0 |
| 2001-05-14 16:00:00 | QQQ | ETF | 44.7 | 44.9 | 44.69 | 44.9 | 670300.0 |
| 2001-05-14 16:30:00 | QQQ | ETF | 44.9 | 44.95 | 44.86 | 44.88 | 22200.0 |
| 2001-05-14 17:00:00 | QQQ | ETF | 44.9 | 44.98 | 44.88 | 44.95 | 26800.0 |
| 2001-05-14 17:30:00 | QQQ | ETF | 44.95 | 44.98 | 44.89 | 44.95 | 23600.0 |
| 2001-05-14 18:00:00 | QQQ | ETF | 44.94 | 45.0 | 44.85 | 44.86 | 9400.0 |
| 2001-05-14 09:30:00 | IWM | ETF | 48.46 | 48.66 | 48.375 | 48.545 | 50400.0 |
| 2001-05-14 10:00:00 | IWM | ETF | 48.45 | 48.65 | 48.425 | 48.5 | 20200.0 |
| 2001-05-14 10:30:00 | IWM | ETF | 48.5 | 48.6 | 48.425 | 48.58 | 10800.0 |
| 2001-05-14 11:00:00 | IWM | ETF | 48.375 | 48.495 | 48.305 | 48.305 | 26000.0 |
| 2001-05-14 11:30:00 | IWM | ETF | 48.3 | 48.495 | 48.28 | 48.375 | 7800.0 |
| 2001-05-14 12:00:00 | IWM | ETF | 48.375 | 48.495 | 48.375 | 48.475 | 14000.0 |
| 2001-05-14 12:30:00 | IWM | ETF | 48.305 | 48.45 | 48.275 | 48.305 | 6200.0 |
| 2001-05-14 13:00:00 | IWM | ETF | 48.31 | 48.47 | 48.275 | 48.445 | 5200.0 |
| 2001-05-14 13:30:00 | IWM | ETF | 48.275 | 48.495 | 48.275 | 48.375 | 6800.0 |
| 2001-05-14 14:00:00 | IWM | ETF | 48.4 | 48.495 | 48.375 | 48.375 | 21200.0 |
| 2001-05-14 14:30:00 | IWM | ETF | 48.38 | 48.38 | 48.15 | 48.365 | 11800.0 |
| 2001-05-14 15:00:00 | IWM | ETF | 48.15 | 48.45 | 48.15 | 48.275 | 11400.0 |
| 2001-05-14 15:30:00 | IWM | ETF | 48.225 | 48.595 | 48.225 | 48.45 | 40600.0 |
| 2001-05-14 16:00:00 | IWM | ETF | 48.52 | 48.52 | 48.45 | 48.45 | 4400.0 |
| 2001-05-14 09:30:00 | DIA | ETF | 108.35 | 108.51 | 108.11 | 108.36 | 325500.0 |
| 2001-05-14 10:00:00 | DIA | ETF | 108.28 | 108.8 | 108.11 | 108.59 | 331000.0 |
> showing 50 of 351 rows — these rows as CSV