PREVIEW / etf_30min / 2001-10-25
file: by_date/etf_30min/2001/2001-10-25.parquet size: 17 KB rows: 418
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-25 09:30:00 | SPY | ETF | 107.45 | 107.82 | 107.32 | 107.5 | 1970000.0 |
| 2001-10-25 10:00:00 | SPY | ETF | 107.5 | 107.54 | 106.74 | 107.1 | 1875000.0 |
| 2001-10-25 10:30:00 | SPY | ETF | 107.15 | 107.33 | 106.91 | 107.07 | 1023600.0 |
| 2001-10-25 11:00:00 | SPY | ETF | 107.1 | 107.62 | 107.04 | 107.42 | 913100.0 |
| 2001-10-25 11:30:00 | SPY | ETF | 107.38 | 107.74 | 107.3 | 107.5 | 782000.0 |
| 2001-10-25 12:00:00 | SPY | ETF | 107.44 | 107.8 | 107.36 | 107.38 | 1467000.0 |
| 2001-10-25 12:30:00 | SPY | ETF | 107.38 | 107.72 | 107.34 | 107.51 | 866700.0 |
| 2001-10-25 13:00:00 | SPY | ETF | 107.51 | 108.07 | 107.5 | 107.89 | 2039900.0 |
| 2001-10-25 13:30:00 | SPY | ETF | 107.83 | 108.23 | 107.75 | 108.11 | 1760600.0 |
| 2001-10-25 14:00:00 | SPY | ETF | 108.18 | 109.32 | 108.1 | 109.18 | 1873600.0 |
| 2001-10-25 14:30:00 | SPY | ETF | 109.18 | 109.95 | 109.02 | 109.66 | 3551300.0 |
| 2001-10-25 15:00:00 | SPY | ETF | 109.65 | 110.32 | 109.5 | 110.25 | 3131100.0 |
| 2001-10-25 15:30:00 | SPY | ETF | 110.32 | 110.32 | 109.86 | 110.31 | 3855400.0 |
| 2001-10-25 16:00:00 | SPY | ETF | 110.3 | 110.64 | 109.99 | 110.5 | 2047300.0 |
| 2001-10-25 16:30:00 | SPY | ETF | 110.5 | 110.5 | 110.3 | 110.5 | 11800.0 |
| 2001-10-25 17:00:00 | SPY | ETF | 110.57 | 110.6 | 110.5 | 110.5 | 25900.0 |
| 2001-10-25 17:30:00 | SPY | ETF | 110.55 | 110.57 | 110.35 | 110.57 | 2400.0 |
| 2001-10-25 09:30:00 | QQQ | ETF | 34.7 | 34.97 | 34.5 | 34.65 | 16794000.0 |
| 2001-10-25 10:00:00 | QQQ | ETF | 34.65 | 34.7 | 34.23 | 34.36 | 11714100.0 |
| 2001-10-25 10:30:00 | QQQ | ETF | 34.36 | 34.62 | 34.25 | 34.53 | 4994200.0 |
| 2001-10-25 11:00:00 | QQQ | ETF | 34.52 | 34.69 | 34.38 | 34.52 | 3949200.0 |
| 2001-10-25 11:30:00 | QQQ | ETF | 34.52 | 34.7 | 34.5 | 34.59 | 2867300.0 |
| 2001-10-25 12:00:00 | QQQ | ETF | 34.6 | 34.9 | 34.57 | 34.68 | 5903200.0 |
| 2001-10-25 12:30:00 | QQQ | ETF | 34.69 | 34.97 | 34.66 | 34.92 | 3434300.0 |
| 2001-10-25 13:00:00 | QQQ | ETF | 34.91 | 35.38 | 34.9 | 35.21 | 8640600.0 |
| 2001-10-25 13:30:00 | QQQ | ETF | 35.19 | 35.35 | 35.12 | 35.34 | 5879200.0 |
| 2001-10-25 14:00:00 | QQQ | ETF | 35.3 | 36.26 | 35.27 | 36.19 | 13607600.0 |
| 2001-10-25 14:30:00 | QQQ | ETF | 36.18 | 36.44 | 36.0 | 36.16 | 13265700.0 |
| 2001-10-25 15:00:00 | QQQ | ETF | 36.2 | 36.78 | 36.13 | 36.75 | 9766200.0 |
| 2001-10-25 15:30:00 | QQQ | ETF | 36.72 | 36.82 | 36.43 | 36.76 | 12489300.0 |
| 2001-10-25 16:00:00 | QQQ | ETF | 36.77 | 36.81 | 34.7 | 36.65 | 3118300.0 |
| 2001-10-25 16:30:00 | QQQ | ETF | 36.65 | 36.7 | 36.5 | 36.61 | 415400.0 |
| 2001-10-25 17:00:00 | QQQ | ETF | 36.66 | 36.8 | 36.2 | 36.61 | 198300.0 |
| 2001-10-25 17:30:00 | QQQ | ETF | 36.69 | 36.8 | 36.6 | 36.72 | 354700.0 |
| 2001-10-25 18:00:00 | QQQ | ETF | 36.72 | 36.74 | 36.61 | 36.68 | 39900.0 |
| 2001-10-25 09:30:00 | IWM | ETF | 42.2 | 42.325 | 42.075 | 42.295 | 63400.0 |
| 2001-10-25 10:00:00 | IWM | ETF | 42.15 | 42.19 | 42.0 | 42.0 | 27400.0 |
| 2001-10-25 10:30:00 | IWM | ETF | 42.05 | 42.15 | 42.05 | 42.15 | 4000.0 |
| 2001-10-25 11:00:00 | IWM | ETF | 42.185 | 42.36 | 42.13 | 42.35 | 132600.0 |
| 2001-10-25 11:30:00 | IWM | ETF | 42.385 | 42.385 | 42.345 | 42.345 | 5800.0 |
| 2001-10-25 12:00:00 | IWM | ETF | 42.38 | 42.5 | 42.38 | 42.48 | 20800.0 |
| 2001-10-25 12:30:00 | IWM | ETF | 42.515 | 42.59 | 42.44 | 42.59 | 7600.0 |
| 2001-10-25 13:00:00 | IWM | ETF | 42.585 | 42.765 | 42.585 | 42.725 | 272400.0 |
| 2001-10-25 13:30:00 | IWM | ETF | 42.685 | 42.815 | 42.685 | 42.81 | 44600.0 |
| 2001-10-25 14:00:00 | IWM | ETF | 42.82 | 43.17 | 42.815 | 43.17 | 76400.0 |
| 2001-10-25 14:30:00 | IWM | ETF | 43.1 | 43.275 | 43.05 | 43.17 | 260000.0 |
| 2001-10-25 15:00:00 | IWM | ETF | 43.125 | 43.3 | 43.09 | 43.25 | 159400.0 |
| 2001-10-25 15:30:00 | IWM | ETF | 43.295 | 43.45 | 43.155 | 43.45 | 61400.0 |
| 2001-10-25 16:00:00 | IWM | ETF | 43.495 | 43.625 | 43.495 | 43.625 | 46600.0 |
| 2001-10-25 09:30:00 | DIA | ETF | 92.5 | 92.75 | 92.2 | 92.35 | 419700.0 |
> showing 50 of 418 rows — these rows as CSV