PREVIEW / etf_30min / 2003-08-28
file: by_date/etf_30min/2003/2003-08-28.parquet size: 23 KB rows: 700
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-08-28 08:00:00 | SPY | ETF | 100.25 | 100.33 | 100.18 | 100.33 | 18600.0 |
| 2003-08-28 08:30:00 | SPY | ETF | 100.39 | 100.4 | 100.25 | 100.37 | 24500.0 |
| 2003-08-28 09:00:00 | SPY | ETF | 100.36 | 100.44 | 100.36 | 100.39 | 20400.0 |
| 2003-08-28 09:30:00 | SPY | ETF | 100.4 | 100.57 | 100.35 | 100.39 | 2229600.0 |
| 2003-08-28 10:00:00 | SPY | ETF | 100.38 | 100.43 | 99.66 | 99.9 | 6199100.0 |
| 2003-08-28 10:30:00 | SPY | ETF | 99.89 | 99.93 | 99.78 | 99.84 | 1918600.0 |
| 2003-08-28 11:00:00 | SPY | ETF | 99.85 | 100.13 | 99.76 | 100.06 | 2040900.0 |
| 2003-08-28 11:30:00 | SPY | ETF | 100.05 | 100.25 | 100.0 | 100.23 | 1108600.0 |
| 2003-08-28 12:00:00 | SPY | ETF | 100.22 | 100.34 | 100.18 | 100.19 | 1311400.0 |
| 2003-08-28 12:30:00 | SPY | ETF | 100.17 | 100.47 | 100.15 | 100.37 | 1104800.0 |
| 2003-08-28 13:00:00 | SPY | ETF | 100.364 | 100.39 | 100.198 | 100.28 | 1043400.0 |
| 2003-08-28 13:30:00 | SPY | ETF | 100.28 | 100.37 | 100.08 | 100.25 | 835100.0 |
| 2003-08-28 14:00:00 | SPY | ETF | 100.27 | 100.39 | 100.21 | 100.33 | 644400.0 |
| 2003-08-28 14:30:00 | SPY | ETF | 100.32 | 100.38 | 100.17 | 100.36 | 760700.0 |
| 2003-08-28 15:00:00 | SPY | ETF | 100.37 | 100.8 | 100.32 | 100.77 | 2069500.0 |
| 2003-08-28 15:30:00 | SPY | ETF | 100.76 | 101.0 | 100.72 | 100.84 | 3114500.0 |
| 2003-08-28 16:00:00 | SPY | ETF | 100.85 | 100.85 | 100.71 | 100.81 | 1101900.0 |
| 2003-08-28 16:30:00 | SPY | ETF | 100.81 | 100.81 | 100.649 | 100.67 | 224200.0 |
| 2003-08-28 17:00:00 | SPY | ETF | 100.4714 | 100.71 | 100.4714 | 100.71 | 154200.0 |
| 2003-08-28 17:30:00 | SPY | ETF | 100.72 | 100.757 | 100.72 | 100.75 | 10700.0 |
| 2003-08-28 18:00:00 | SPY | ETF | 100.75 | 100.76 | 100.75 | 100.75 | 5400.0 |
| 2003-08-28 18:30:00 | SPY | ETF | 100.73 | 100.73 | 100.7 | 100.7 | 300.0 |
| 2003-08-28 19:00:00 | SPY | ETF | 100.75 | 100.77 | 100.75 | 100.77 | 900.0 |
| 2003-08-28 08:00:00 | QQQ | ETF | 32.84 | 32.92 | 32.84 | 32.92 | 36700.0 |
| 2003-08-28 08:30:00 | QQQ | ETF | 32.92 | 33.0 | 32.88 | 32.92 | 116100.0 |
| 2003-08-28 09:00:00 | QQQ | ETF | 32.92 | 32.98 | 32.92 | 32.94 | 110500.0 |
| 2003-08-28 09:30:00 | QQQ | ETF | 32.94 | 32.984 | 32.81 | 32.87 | 6423500.0 |
| 2003-08-28 10:00:00 | QQQ | ETF | 32.88 | 32.89 | 32.522 | 32.7 | 8543300.0 |
| 2003-08-28 10:30:00 | QQQ | ETF | 32.71 | 32.71 | 32.58 | 32.59 | 2338600.0 |
| 2003-08-28 11:00:00 | QQQ | ETF | 32.59 | 32.8 | 32.55 | 32.73 | 2933300.0 |
| 2003-08-28 11:30:00 | QQQ | ETF | 32.74 | 32.88 | 32.73 | 32.85 | 2842200.0 |
| 2003-08-28 12:00:00 | QQQ | ETF | 32.86 | 32.92 | 32.81 | 32.81 | 3080400.0 |
| 2003-08-28 12:30:00 | QQQ | ETF | 32.813 | 32.95 | 32.8 | 32.864 | 2673700.0 |
| 2003-08-28 13:00:00 | QQQ | ETF | 32.87 | 32.89 | 32.81 | 32.86 | 1397600.0 |
| 2003-08-28 13:30:00 | QQQ | ETF | 32.86 | 32.94 | 32.78 | 32.87 | 1970100.0 |
| 2003-08-28 14:00:00 | QQQ | ETF | 32.86 | 32.93 | 32.84 | 32.87 | 1735000.0 |
| 2003-08-28 14:30:00 | QQQ | ETF | 32.87 | 32.94 | 32.79 | 32.93 | 1902000.0 |
| 2003-08-28 15:00:00 | QQQ | ETF | 32.94 | 33.04 | 32.89 | 33.032 | 5484200.0 |
| 2003-08-28 15:30:00 | QQQ | ETF | 33.032 | 33.11 | 33.0 | 33.09 | 8410300.0 |
| 2003-08-28 16:00:00 | QQQ | ETF | 33.09 | 33.12 | 33.05 | 33.12 | 1442800.0 |
| 2003-08-28 16:30:00 | QQQ | ETF | 33.09 | 33.1 | 33.01 | 33.03 | 244800.0 |
| 2003-08-28 17:00:00 | QQQ | ETF | 33.039 | 33.05 | 33.01 | 33.03 | 49500.0 |
| 2003-08-28 17:30:00 | QQQ | ETF | 33.03 | 33.075 | 33.03 | 33.05 | 32900.0 |
| 2003-08-28 18:00:00 | QQQ | ETF | 33.06 | 33.07 | 33.05 | 33.06 | 11700.0 |
| 2003-08-28 18:30:00 | QQQ | ETF | 33.06 | 33.07 | 33.06 | 33.07 | 500.0 |
| 2003-08-28 19:00:00 | QQQ | ETF | 33.06 | 33.07 | 33.03 | 33.03 | 4400.0 |
| 2003-08-28 19:30:00 | QQQ | ETF | 33.04 | 33.05 | 33.03 | 33.03 | 7900.0 |
| 2003-08-28 20:00:00 | QQQ | ETF | 33.05 | 33.05 | 33.05 | 33.05 | 400.0 |
| 2003-08-28 09:30:00 | IWM | ETF | 49.15 | 49.295 | 49.046 | 49.05 | 427200.0 |
| 2003-08-28 10:00:00 | IWM | ETF | 49.045 | 49.075 | 48.645 | 48.87 | 857200.0 |
> showing 50 of 700 rows — these rows as CSV