PREVIEW / etf_30min / 2003-08-21
file: by_date/etf_30min/2003/2003-08-21.parquet size: 24 KB rows: 739
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-21 08:00:00 | SPY | ETF | 101.01 | 101.03 | 100.98 | 101.03 | 9700.0 |
| 2003-08-21 08:30:00 | SPY | ETF | 101.09 | 101.12 | 100.97 | 101.03 | 66800.0 |
| 2003-08-21 09:00:00 | SPY | ETF | 101.03 | 101.08 | 101.01 | 101.01 | 21000.0 |
| 2003-08-21 09:30:00 | SPY | ETF | 101.05 | 101.48 | 100.79 | 101.42 | 3537100.0 |
| 2003-08-21 10:00:00 | SPY | ETF | 101.45 | 101.52 | 101.23 | 101.28 | 2864900.0 |
| 2003-08-21 10:30:00 | SPY | ETF | 101.29 | 101.39 | 101.13 | 101.39 | 1260000.0 |
| 2003-08-21 11:00:00 | SPY | ETF | 101.37 | 101.39 | 100.453 | 100.79 | 7149200.0 |
| 2003-08-21 11:30:00 | SPY | ETF | 100.78 | 100.88 | 100.4 | 100.65 | 4271300.0 |
| 2003-08-21 12:00:00 | SPY | ETF | 100.65 | 101.24 | 100.62 | 101.05 | 7032400.0 |
| 2003-08-21 12:30:00 | SPY | ETF | 101.05 | 101.08 | 100.7 | 100.74 | 1902600.0 |
| 2003-08-21 13:00:00 | SPY | ETF | 100.74 | 100.85 | 100.62 | 100.83 | 1179300.0 |
| 2003-08-21 13:30:00 | SPY | ETF | 100.82 | 100.99 | 100.71 | 100.94 | 900300.0 |
| 2003-08-21 14:00:00 | SPY | ETF | 100.94 | 100.98 | 100.61 | 100.74 | 1861600.0 |
| 2003-08-21 14:30:00 | SPY | ETF | 100.72 | 100.8 | 100.54 | 100.72 | 1357000.0 |
| 2003-08-21 15:00:00 | SPY | ETF | 100.72 | 100.88 | 100.65 | 100.83 | 1220800.0 |
| 2003-08-21 15:30:00 | SPY | ETF | 100.82 | 101.06 | 100.81 | 100.87 | 2415500.0 |
| 2003-08-21 16:00:00 | SPY | ETF | 100.89 | 100.94 | 100.73 | 100.74 | 1179900.0 |
| 2003-08-21 16:30:00 | SPY | ETF | 100.75 | 100.845 | 100.71 | 100.84 | 132200.0 |
| 2003-08-21 17:00:00 | SPY | ETF | 100.783 | 100.84 | 100.783 | 100.84 | 12700.0 |
| 2003-08-21 17:30:00 | SPY | ETF | 100.81 | 100.82 | 100.76 | 100.77 | 28800.0 |
| 2003-08-21 18:00:00 | SPY | ETF | 100.75 | 100.77 | 100.74 | 100.77 | 8300.0 |
| 2003-08-21 18:30:00 | SPY | ETF | 100.77 | 100.77 | 100.74 | 100.77 | 2000.0 |
| 2003-08-21 19:00:00 | SPY | ETF | 100.75 | 100.76 | 100.75 | 100.76 | 1000.0 |
| 2003-08-21 19:30:00 | SPY | ETF | 100.75 | 100.75 | 100.72 | 100.72 | 1800.0 |
| 2003-08-21 08:00:00 | QQQ | ETF | 32.55 | 32.57 | 32.53 | 32.56 | 53800.0 |
| 2003-08-21 08:30:00 | QQQ | ETF | 32.55 | 32.64 | 32.55 | 32.58 | 146400.0 |
| 2003-08-21 09:00:00 | QQQ | ETF | 32.59 | 32.6 | 32.56 | 32.58 | 66500.0 |
| 2003-08-21 09:30:00 | QQQ | ETF | 32.59 | 32.73 | 32.48 | 32.715 | 9315500.0 |
| 2003-08-21 10:00:00 | QQQ | ETF | 32.71 | 32.82 | 32.63 | 32.671 | 6887100.0 |
| 2003-08-21 10:30:00 | QQQ | ETF | 32.671 | 32.73 | 32.559 | 32.73 | 4514900.0 |
| 2003-08-21 11:00:00 | QQQ | ETF | 32.71 | 32.75 | 32.3 | 32.475 | 8074500.0 |
| 2003-08-21 11:30:00 | QQQ | ETF | 32.47 | 32.48 | 32.27 | 32.43 | 6935900.0 |
| 2003-08-21 12:00:00 | QQQ | ETF | 32.45 | 32.65 | 32.42 | 32.57 | 9002200.0 |
| 2003-08-21 12:30:00 | QQQ | ETF | 32.55 | 32.58 | 32.44 | 32.451 | 3036600.0 |
| 2003-08-21 13:00:00 | QQQ | ETF | 32.47 | 32.55 | 32.41 | 32.52 | 2559900.0 |
| 2003-08-21 13:30:00 | QQQ | ETF | 32.52 | 32.62 | 32.49 | 32.56 | 2788600.0 |
| 2003-08-21 14:00:00 | QQQ | ETF | 32.578 | 32.6 | 32.48 | 32.57 | 2639500.0 |
| 2003-08-21 14:30:00 | QQQ | ETF | 32.57 | 32.6 | 32.48 | 32.57 | 2660100.0 |
| 2003-08-21 15:00:00 | QQQ | ETF | 32.56 | 32.66 | 32.53 | 32.621 | 3338900.0 |
| 2003-08-21 15:30:00 | QQQ | ETF | 32.64 | 32.73 | 32.62 | 32.68 | 6332600.0 |
| 2003-08-21 16:00:00 | QQQ | ETF | 32.674 | 32.7 | 32.573 | 32.63 | 1677400.0 |
| 2003-08-21 16:30:00 | QQQ | ETF | 32.63 | 32.66 | 32.61 | 32.66 | 96100.0 |
| 2003-08-21 17:00:00 | QQQ | ETF | 32.65 | 32.66 | 32.62 | 32.63 | 65200.0 |
| 2003-08-21 17:30:00 | QQQ | ETF | 32.63 | 32.67 | 32.63 | 32.646 | 18700.0 |
| 2003-08-21 18:00:00 | QQQ | ETF | 32.64 | 32.65 | 32.63 | 32.65 | 6200.0 |
| 2003-08-21 18:30:00 | QQQ | ETF | 32.65 | 32.66 | 32.63 | 32.66 | 10800.0 |
| 2003-08-21 19:00:00 | QQQ | ETF | 32.66 | 32.67 | 32.66 | 32.67 | 3000.0 |
| 2003-08-21 19:30:00 | QQQ | ETF | 32.67 | 32.68 | 32.64 | 32.64 | 10700.0 |
| 2003-08-21 09:30:00 | IWM | ETF | 49.2 | 49.35 | 49.05 | 49.34 | 266800.0 |
| 2003-08-21 10:00:00 | IWM | ETF | 49.37 | 49.4 | 49.29 | 49.38 | 731400.0 |
> showing 50 of 739 rows — these rows as CSV