PREVIEW / etf_30min / 2001-10-26
file: by_date/etf_30min/2001/2001-10-26.parquet size: 16 KB rows: 398
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-10-26 09:30:00 | SPY | ETF | 109.95 | 110.55 | 109.67 | 109.82 | 2864000.0 |
| 2001-10-26 10:00:00 | SPY | ETF | 109.84 | 110.73 | 109.7 | 110.48 | 1630600.0 |
| 2001-10-26 10:30:00 | SPY | ETF | 110.45 | 110.6 | 110.22 | 110.48 | 1211200.0 |
| 2001-10-26 11:00:00 | SPY | ETF | 110.41 | 110.88 | 110.35 | 110.6 | 1456800.0 |
| 2001-10-26 11:30:00 | SPY | ETF | 110.6 | 110.6 | 110.27 | 110.5 | 579800.0 |
| 2001-10-26 12:00:00 | SPY | ETF | 110.48 | 110.7 | 110.4 | 110.5 | 499300.0 |
| 2001-10-26 12:30:00 | SPY | ETF | 110.53 | 110.9 | 110.41 | 110.87 | 323300.0 |
| 2001-10-26 13:00:00 | SPY | ETF | 110.88 | 111.23 | 110.85 | 110.99 | 1743400.0 |
| 2001-10-26 13:30:00 | SPY | ETF | 110.95 | 111.09 | 110.7 | 110.8 | 650800.0 |
| 2001-10-26 14:00:00 | SPY | ETF | 110.85 | 111.05 | 110.77 | 110.82 | 1133200.0 |
| 2001-10-26 14:30:00 | SPY | ETF | 110.76 | 110.8 | 110.42 | 110.77 | 1030100.0 |
| 2001-10-26 15:00:00 | SPY | ETF | 110.78 | 111.48 | 110.69 | 111.14 | 1693600.0 |
| 2001-10-26 15:30:00 | SPY | ETF | 111.15 | 111.36 | 110.69 | 110.77 | 2024000.0 |
| 2001-10-26 16:00:00 | SPY | ETF | 110.74 | 110.75 | 110.21 | 110.24 | 1721100.0 |
| 2001-10-26 16:30:00 | SPY | ETF | 110.27 | 110.35 | 110.27 | 110.32 | 22400.0 |
| 2001-10-26 18:00:00 | SPY | ETF | 110.32 | 110.38 | 110.32 | 110.38 | 400.0 |
| 2001-10-26 09:30:00 | QQQ | ETF | 36.5 | 37.06 | 36.35 | 36.5 | 21587500.0 |
| 2001-10-26 10:00:00 | QQQ | ETF | 36.49 | 36.95 | 36.42 | 36.8 | 10836700.0 |
| 2001-10-26 10:30:00 | QQQ | ETF | 36.78 | 36.82 | 36.36 | 36.58 | 5193100.0 |
| 2001-10-26 11:00:00 | QQQ | ETF | 36.58 | 36.79 | 36.45 | 36.54 | 5145800.0 |
| 2001-10-26 11:30:00 | QQQ | ETF | 36.53 | 36.57 | 36.25 | 36.4 | 5076800.0 |
| 2001-10-26 12:00:00 | QQQ | ETF | 36.38 | 36.53 | 36.33 | 36.43 | 2130400.0 |
| 2001-10-26 12:30:00 | QQQ | ETF | 36.4 | 36.79 | 36.37 | 36.75 | 4358700.0 |
| 2001-10-26 13:00:00 | QQQ | ETF | 36.75 | 37.0 | 36.71 | 36.73 | 7084400.0 |
| 2001-10-26 13:30:00 | QQQ | ETF | 36.75 | 36.83 | 36.42 | 36.54 | 3463000.0 |
| 2001-10-26 14:00:00 | QQQ | ETF | 36.52 | 36.7 | 36.43 | 36.54 | 3333100.0 |
| 2001-10-26 14:30:00 | QQQ | ETF | 36.5 | 36.5 | 36.2 | 36.4 | 6986600.0 |
| 2001-10-26 15:00:00 | QQQ | ETF | 36.41 | 36.76 | 36.29 | 36.4 | 6854400.0 |
| 2001-10-26 15:30:00 | QQQ | ETF | 36.42 | 36.63 | 36.18 | 36.26 | 8254900.0 |
| 2001-10-26 16:00:00 | QQQ | ETF | 36.26 | 36.7 | 36.0 | 36.1 | 2925800.0 |
| 2001-10-26 16:30:00 | QQQ | ETF | 36.15 | 36.15 | 36.0 | 36.05 | 30000.0 |
| 2001-10-26 17:00:00 | QQQ | ETF | 36.06 | 36.1 | 36.01 | 36.09 | 6200.0 |
| 2001-10-26 17:30:00 | QQQ | ETF | 36.1 | 36.2 | 36.03 | 36.2 | 12000.0 |
| 2001-10-26 18:00:00 | QQQ | ETF | 36.05 | 36.05 | 36.01 | 36.02 | 11000.0 |
| 2001-10-26 09:30:00 | IWM | ETF | 43.2 | 43.65 | 43.2 | 43.495 | 21600.0 |
| 2001-10-26 10:00:00 | IWM | ETF | 43.305 | 43.59 | 43.305 | 43.59 | 3400.0 |
| 2001-10-26 10:30:00 | IWM | ETF | 43.645 | 43.645 | 43.55 | 43.56 | 3400.0 |
| 2001-10-26 11:00:00 | IWM | ETF | 43.57 | 43.7 | 43.57 | 43.62 | 337400.0 |
| 2001-10-26 11:30:00 | IWM | ETF | 43.595 | 43.595 | 43.51 | 43.55 | 61200.0 |
| 2001-10-26 12:00:00 | IWM | ETF | 43.575 | 43.575 | 43.46 | 43.46 | 39800.0 |
| 2001-10-26 12:30:00 | IWM | ETF | 43.46 | 43.705 | 43.46 | 43.6 | 8600.0 |
| 2001-10-26 13:00:00 | IWM | ETF | 43.7 | 43.755 | 43.675 | 43.755 | 9800.0 |
| 2001-10-26 13:30:00 | IWM | ETF | 43.725 | 43.735 | 43.65 | 43.725 | 121200.0 |
| 2001-10-26 14:00:00 | IWM | ETF | 43.695 | 43.725 | 43.655 | 43.725 | 194400.0 |
| 2001-10-26 14:30:00 | IWM | ETF | 43.65 | 43.72 | 43.625 | 43.65 | 30600.0 |
| 2001-10-26 15:00:00 | IWM | ETF | 43.675 | 43.81 | 43.675 | 43.75 | 16000.0 |
| 2001-10-26 15:30:00 | IWM | ETF | 43.75 | 43.825 | 43.65 | 43.675 | 76600.0 |
| 2001-10-26 16:00:00 | IWM | ETF | 43.675 | 43.675 | 43.625 | 43.625 | 7600.0 |
| 2001-10-26 09:30:00 | DIA | ETF | 94.43 | 94.99 | 94.25 | 94.52 | 469300.0 |
| 2001-10-26 10:00:00 | DIA | ETF | 94.5 | 95.35 | 94.35 | 95.11 | 589200.0 |
> showing 50 of 398 rows — these rows as CSV