PREVIEW / etf_30min / 2003-03-11
file: by_date/etf_30min/2003/2003-03-11.parquet size: 21 KB rows: 613
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 |
|---|---|---|---|---|---|---|---|
| 2003-03-11 08:00:00 | SPY | ETF | 81.6 | 81.72 | 81.58 | 81.58 | 26500.0 |
| 2003-03-11 08:30:00 | SPY | ETF | 81.51 | 81.51 | 81.45 | 81.45 | 13300.0 |
| 2003-03-11 09:00:00 | SPY | ETF | 81.41 | 81.51 | 81.36 | 81.47 | 66800.0 |
| 2003-03-11 09:30:00 | SPY | ETF | 81.48 | 81.81 | 81.3 | 81.42 | 6485200.0 |
| 2003-03-11 10:00:00 | SPY | ETF | 81.42 | 82.0 | 81.38 | 81.5 | 4805300.0 |
| 2003-03-11 10:30:00 | SPY | ETF | 81.53 | 81.53 | 80.9 | 81.0 | 5628500.0 |
| 2003-03-11 11:00:00 | SPY | ETF | 81.0 | 81.16 | 80.74 | 80.97 | 3778900.0 |
| 2003-03-11 11:30:00 | SPY | ETF | 80.98 | 81.45 | 80.95 | 81.4 | 2656600.0 |
| 2003-03-11 12:00:00 | SPY | ETF | 81.4 | 81.5 | 81.16 | 81.43 | 2058600.0 |
| 2003-03-11 12:30:00 | SPY | ETF | 81.43 | 81.54 | 81.2 | 81.38 | 2451200.0 |
| 2003-03-11 13:00:00 | SPY | ETF | 81.38 | 81.44 | 81.12 | 81.39 | 1037500.0 |
| 2003-03-11 13:30:00 | SPY | ETF | 81.4 | 81.61 | 81.22 | 81.46 | 2281600.0 |
| 2003-03-11 14:00:00 | SPY | ETF | 81.46 | 81.52 | 81.05 | 81.26 | 1696200.0 |
| 2003-03-11 14:30:00 | SPY | ETF | 81.25 | 81.25 | 80.95 | 81.07 | 1230000.0 |
| 2003-03-11 15:00:00 | SPY | ETF | 81.04 | 81.33 | 80.72 | 80.81 | 3752500.0 |
| 2003-03-11 15:30:00 | SPY | ETF | 80.81 | 80.9 | 80.52 | 80.54 | 5602300.0 |
| 2003-03-11 16:00:00 | SPY | ETF | 80.56 | 80.61 | 80.47 | 80.53 | 1757800.0 |
| 2003-03-11 16:30:00 | SPY | ETF | 80.53 | 80.59 | 80.52 | 80.52 | 78300.0 |
| 2003-03-11 17:00:00 | SPY | ETF | 80.52 | 80.59 | 80.5 | 80.5 | 26800.0 |
| 2003-03-11 17:30:00 | SPY | ETF | 80.53 | 80.54 | 80.53 | 80.53 | 9300.0 |
| 2003-03-11 18:00:00 | SPY | ETF | 80.54 | 80.54 | 80.53 | 80.53 | 2900.0 |
| 2003-03-11 18:30:00 | SPY | ETF | 80.53 | 80.54 | 80.53 | 80.54 | 11000.0 |
| 2003-03-11 19:00:00 | SPY | ETF | 80.52 | 80.55 | 80.5 | 80.55 | 2700.0 |
| 2003-03-11 19:30:00 | SPY | ETF | 80.55 | 80.59 | 80.55 | 80.59 | 700.0 |
| 2003-03-11 08:00:00 | QQQ | ETF | 24.11 | 24.13 | 24.01 | 24.01 | 40800.0 |
| 2003-03-11 08:30:00 | QQQ | ETF | 24.0 | 24.05 | 24.0 | 24.04 | 26100.0 |
| 2003-03-11 09:00:00 | QQQ | ETF | 24.03 | 24.08 | 24.02 | 24.05 | 12200.0 |
| 2003-03-11 09:30:00 | QQQ | ETF | 24.06 | 24.14 | 23.91 | 23.98 | 7415100.0 |
| 2003-03-11 10:00:00 | QQQ | ETF | 23.99 | 24.24 | 23.97 | 24.12 | 6376700.0 |
| 2003-03-11 10:30:00 | QQQ | ETF | 24.12 | 24.15 | 23.98 | 24.01 | 4519100.0 |
| 2003-03-11 11:00:00 | QQQ | ETF | 24.01 | 24.02 | 23.86 | 23.93 | 5236600.0 |
| 2003-03-11 11:30:00 | QQQ | ETF | 23.93 | 24.11 | 23.91 | 24.06 | 5434400.0 |
| 2003-03-11 12:00:00 | QQQ | ETF | 24.07 | 24.12 | 24.0 | 24.06 | 2062800.0 |
| 2003-03-11 12:30:00 | QQQ | ETF | 24.07 | 24.09 | 23.98 | 24.04 | 1272000.0 |
| 2003-03-11 13:00:00 | QQQ | ETF | 24.04 | 24.06 | 23.95 | 24.05 | 1466500.0 |
| 2003-03-11 13:30:00 | QQQ | ETF | 24.05 | 24.09 | 24.01 | 24.07 | 2258900.0 |
| 2003-03-11 14:00:00 | QQQ | ETF | 24.08 | 24.08 | 23.95 | 24.01 | 1490500.0 |
| 2003-03-11 14:30:00 | QQQ | ETF | 24.01 | 24.03 | 23.92 | 23.96 | 3480500.0 |
| 2003-03-11 15:00:00 | QQQ | ETF | 23.96 | 24.03 | 23.86 | 23.89 | 2907700.0 |
| 2003-03-11 15:30:00 | QQQ | ETF | 23.88 | 23.91 | 23.78 | 23.82 | 6065500.0 |
| 2003-03-11 16:00:00 | QQQ | ETF | 23.83 | 23.96 | 23.79 | 23.8 | 1593700.0 |
| 2003-03-11 16:30:00 | QQQ | ETF | 23.81 | 24.08 | 23.8 | 23.84 | 711400.0 |
| 2003-03-11 17:00:00 | QQQ | ETF | 23.85 | 23.87 | 23.82 | 23.84 | 42800.0 |
| 2003-03-11 17:30:00 | QQQ | ETF | 23.84 | 23.85 | 23.82 | 23.85 | 29700.0 |
| 2003-03-11 18:00:00 | QQQ | ETF | 23.82 | 23.84 | 23.82 | 23.83 | 4800.0 |
| 2003-03-11 18:30:00 | QQQ | ETF | 23.84 | 23.84 | 23.81 | 23.83 | 7500.0 |
| 2003-03-11 19:00:00 | QQQ | ETF | 23.83 | 23.86 | 23.83 | 23.85 | 2600.0 |
| 2003-03-11 19:30:00 | QQQ | ETF | 23.84 | 23.85 | 23.82 | 23.85 | 16100.0 |
| 2003-03-11 09:30:00 | IWM | ETF | 34.665 | 34.86 | 34.575 | 34.735 | 351800.0 |
| 2003-03-11 10:00:00 | IWM | ETF | 34.77 | 34.9 | 34.725 | 34.76 | 330000.0 |
> showing 50 of 613 rows — these rows as CSV