PREVIEW / etf_30min / 2001-09-10
file: by_date/etf_30min/2001/2001-09-10.parquet size: 16 KB rows: 400
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-09-10 09:30:00 | SPY | ETF | 107.7 | 109.09 | 107.7 | 108.82 | 4786600.0 |
| 2001-09-10 10:00:00 | SPY | ETF | 108.86 | 109.41 | 108.48 | 108.97 | 2494300.0 |
| 2001-09-10 10:30:00 | SPY | ETF | 108.95 | 109.78 | 108.77 | 109.75 | 2144400.0 |
| 2001-09-10 11:00:00 | SPY | ETF | 109.7 | 109.95 | 109.42 | 109.71 | 1533000.0 |
| 2001-09-10 11:30:00 | SPY | ETF | 109.68 | 110.25 | 109.56 | 110.0 | 2363700.0 |
| 2001-09-10 12:00:00 | SPY | ETF | 109.98 | 110.35 | 109.92 | 110.03 | 694200.0 |
| 2001-09-10 12:30:00 | SPY | ETF | 110.05 | 110.15 | 109.7 | 109.7 | 674600.0 |
| 2001-09-10 13:00:00 | SPY | ETF | 109.74 | 109.8 | 109.2 | 109.4 | 781900.0 |
| 2001-09-10 13:30:00 | SPY | ETF | 109.4 | 109.61 | 109.26 | 109.5 | 526600.0 |
| 2001-09-10 14:00:00 | SPY | ETF | 109.55 | 109.8 | 109.18 | 109.42 | 751200.0 |
| 2001-09-10 14:30:00 | SPY | ETF | 109.4 | 109.88 | 109.32 | 109.4 | 1116500.0 |
| 2001-09-10 15:00:00 | SPY | ETF | 109.41 | 109.71 | 109.1 | 109.63 | 1334100.0 |
| 2001-09-10 15:30:00 | SPY | ETF | 109.6 | 110.0 | 109.47 | 109.83 | 1873100.0 |
| 2001-09-10 16:00:00 | SPY | ETF | 109.8 | 110.1 | 109.53 | 109.9 | 974200.0 |
| 2001-09-10 16:30:00 | SPY | ETF | 110.0 | 110.05 | 109.95 | 110.05 | 3200.0 |
| 2001-09-10 09:30:00 | QQQ | ETF | 33.49 | 34.1 | 33.34 | 33.95 | 15528000.0 |
| 2001-09-10 10:00:00 | QQQ | ETF | 33.87 | 34.08 | 33.51 | 33.57 | 9120400.0 |
| 2001-09-10 10:30:00 | QQQ | ETF | 33.58 | 34.12 | 33.46 | 34.07 | 7972200.0 |
| 2001-09-10 11:00:00 | QQQ | ETF | 34.1 | 34.12 | 33.76 | 33.9 | 4157700.0 |
| 2001-09-10 11:30:00 | QQQ | ETF | 33.9 | 34.32 | 33.82 | 34.11 | 5769400.0 |
| 2001-09-10 12:00:00 | QQQ | ETF | 34.08 | 34.28 | 34.06 | 34.06 | 3080700.0 |
| 2001-09-10 12:30:00 | QQQ | ETF | 34.09 | 34.13 | 33.8 | 33.82 | 2792200.0 |
| 2001-09-10 13:00:00 | QQQ | ETF | 33.81 | 33.86 | 33.61 | 33.75 | 5738800.0 |
| 2001-09-10 13:30:00 | QQQ | ETF | 33.74 | 33.89 | 33.61 | 33.89 | 1692500.0 |
| 2001-09-10 14:00:00 | QQQ | ETF | 33.89 | 33.96 | 33.6 | 33.82 | 3210200.0 |
| 2001-09-10 14:30:00 | QQQ | ETF | 33.82 | 34.12 | 33.76 | 33.82 | 3821100.0 |
| 2001-09-10 15:00:00 | QQQ | ETF | 33.83 | 34.05 | 33.59 | 33.91 | 5331400.0 |
| 2001-09-10 15:30:00 | QQQ | ETF | 33.89 | 34.14 | 33.82 | 34.0 | 6343800.0 |
| 2001-09-10 16:00:00 | QQQ | ETF | 34.0 | 34.13 | 33.9 | 34.07 | 1724400.0 |
| 2001-09-10 16:30:00 | QQQ | ETF | 34.06 | 34.11 | 33.98 | 34.05 | 280900.0 |
| 2001-09-10 17:00:00 | QQQ | ETF | 34.11 | 34.12 | 34.05 | 34.11 | 88600.0 |
| 2001-09-10 17:30:00 | QQQ | ETF | 34.12 | 34.15 | 34.08 | 34.1 | 32300.0 |
| 2001-09-10 18:00:00 | QQQ | ETF | 34.1 | 34.1 | 34.07 | 34.07 | 4600.0 |
| 2001-09-10 09:30:00 | IWM | ETF | 43.925 | 44.2 | 43.925 | 44.155 | 257400.0 |
| 2001-09-10 10:00:00 | IWM | ETF | 44.13 | 44.175 | 44.02 | 44.175 | 107200.0 |
| 2001-09-10 10:30:00 | IWM | ETF | 44.145 | 44.225 | 44.025 | 44.2 | 5000.0 |
| 2001-09-10 11:00:00 | IWM | ETF | 44.2 | 44.2 | 44.025 | 44.025 | 203200.0 |
| 2001-09-10 11:30:00 | IWM | ETF | 44.195 | 44.25 | 44.075 | 44.19 | 1705400.0 |
| 2001-09-10 12:00:00 | IWM | ETF | 44.055 | 44.22 | 44.055 | 44.22 | 206200.0 |
| 2001-09-10 12:30:00 | IWM | ETF | 44.055 | 44.215 | 44.055 | 44.075 | 43200.0 |
| 2001-09-10 13:00:00 | IWM | ETF | 44.045 | 44.045 | 43.945 | 43.945 | 1400.0 |
| 2001-09-10 13:30:00 | IWM | ETF | 44.065 | 44.065 | 43.76 | 43.76 | 1701800.0 |
| 2001-09-10 14:00:00 | IWM | ETF | 43.94 | 43.94 | 43.6 | 43.6 | 216200.0 |
| 2001-09-10 14:30:00 | IWM | ETF | 43.6 | 43.9 | 43.6 | 43.75 | 74600.0 |
| 2001-09-10 15:00:00 | IWM | ETF | 43.67 | 43.7 | 43.55 | 43.7 | 56200.0 |
| 2001-09-10 15:30:00 | IWM | ETF | 43.745 | 43.82 | 43.625 | 43.75 | 106400.0 |
| 2001-09-10 16:00:00 | IWM | ETF | 43.75 | 43.925 | 43.75 | 43.925 | 65000.0 |
| 2001-09-10 09:30:00 | DIA | ETF | 95.1 | 96.05 | 95.05 | 95.88 | 1302200.0 |
| 2001-09-10 10:00:00 | DIA | ETF | 95.85 | 96.25 | 95.51 | 95.9 | 626700.0 |
| 2001-09-10 10:30:00 | DIA | ETF | 95.92 | 96.45 | 95.82 | 96.4 | 740400.0 |
> showing 50 of 400 rows — these rows as CSV