PREVIEW / etf_30min / 2003-06-10
file: by_date/etf_30min/2003/2003-06-10.parquet size: 23 KB rows: 708
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-06-10 08:00:00 | SPY | ETF | 98.65 | 98.65 | 98.61 | 98.61 | 2200.0 |
| 2003-06-10 08:30:00 | SPY | ETF | 98.56 | 98.61 | 98.54 | 98.61 | 22300.0 |
| 2003-06-10 09:00:00 | SPY | ETF | 98.62 | 98.74 | 98.41 | 98.41 | 37200.0 |
| 2003-06-10 09:30:00 | SPY | ETF | 98.46 | 98.84 | 98.39 | 98.55 | 5069800.0 |
| 2003-06-10 10:00:00 | SPY | ETF | 98.56 | 98.87 | 98.32 | 98.55 | 3083400.0 |
| 2003-06-10 10:30:00 | SPY | ETF | 98.54 | 98.64 | 98.19 | 98.42 | 6150400.0 |
| 2003-06-10 11:00:00 | SPY | ETF | 98.45 | 98.72 | 98.25 | 98.6 | 1355900.0 |
| 2003-06-10 11:30:00 | SPY | ETF | 98.58 | 98.75 | 98.46 | 98.53 | 919500.0 |
| 2003-06-10 12:00:00 | SPY | ETF | 98.55 | 98.79 | 98.52 | 98.73 | 1372800.0 |
| 2003-06-10 12:30:00 | SPY | ETF | 98.71 | 98.82 | 98.61 | 98.72 | 659700.0 |
| 2003-06-10 13:00:00 | SPY | ETF | 98.75 | 98.89 | 98.73 | 98.82 | 944100.0 |
| 2003-06-10 13:30:00 | SPY | ETF | 98.81 | 98.89 | 98.48 | 98.64 | 1065200.0 |
| 2003-06-10 14:00:00 | SPY | ETF | 98.61 | 98.66 | 98.45 | 98.5 | 884600.0 |
| 2003-06-10 14:30:00 | SPY | ETF | 98.5 | 98.5 | 98.29 | 98.39 | 973900.0 |
| 2003-06-10 15:00:00 | SPY | ETF | 98.4 | 98.62 | 98.25 | 98.61 | 1214500.0 |
| 2003-06-10 15:30:00 | SPY | ETF | 98.55 | 99.06 | 98.55 | 99.05 | 1930400.0 |
| 2003-06-10 16:00:00 | SPY | ETF | 99.03 | 99.26 | 99.01 | 99.2 | 1496100.0 |
| 2003-06-10 16:30:00 | SPY | ETF | 99.2 | 99.23 | 99.01 | 99.13 | 287300.0 |
| 2003-06-10 17:00:00 | SPY | ETF | 99.14 | 99.26 | 99.05 | 99.09 | 433000.0 |
| 2003-06-10 17:30:00 | SPY | ETF | 99.12 | 99.14 | 99.1 | 99.1 | 11100.0 |
| 2003-06-10 18:00:00 | SPY | ETF | 99.1 | 99.12 | 99.06 | 99.12 | 2600.0 |
| 2003-06-10 18:30:00 | SPY | ETF | 99.12 | 99.12 | 99.1 | 99.1 | 5200.0 |
| 2003-06-10 19:00:00 | SPY | ETF | 99.09 | 99.17 | 99.09 | 99.17 | 7200.0 |
| 2003-06-10 19:30:00 | SPY | ETF | 99.18 | 99.18 | 99.07 | 99.17 | 2500.0 |
| 2003-06-10 08:00:00 | QQQ | ETF | 29.91 | 29.92 | 29.86 | 29.87 | 27200.0 |
| 2003-06-10 08:30:00 | QQQ | ETF | 29.87 | 29.87 | 29.82 | 29.87 | 20500.0 |
| 2003-06-10 09:00:00 | QQQ | ETF | 29.86 | 29.92 | 29.85 | 29.85 | 88800.0 |
| 2003-06-10 09:30:00 | QQQ | ETF | 29.86 | 30.03 | 29.7 | 29.83 | 14757600.0 |
| 2003-06-10 10:00:00 | QQQ | ETF | 29.83 | 30.0 | 29.74 | 29.84 | 7435700.0 |
| 2003-06-10 10:30:00 | QQQ | ETF | 29.83 | 29.89 | 29.68 | 29.76 | 4670700.0 |
| 2003-06-10 11:00:00 | QQQ | ETF | 29.76 | 29.89 | 29.68 | 29.87 | 4401700.0 |
| 2003-06-10 11:30:00 | QQQ | ETF | 29.86 | 29.95 | 29.78 | 29.84 | 3201500.0 |
| 2003-06-10 12:00:00 | QQQ | ETF | 29.84 | 29.97 | 29.84 | 29.91 | 1918400.0 |
| 2003-06-10 12:30:00 | QQQ | ETF | 29.91 | 29.94 | 29.86 | 29.92 | 1394900.0 |
| 2003-06-10 13:00:00 | QQQ | ETF | 29.92 | 29.98 | 29.9 | 29.94 | 1552900.0 |
| 2003-06-10 13:30:00 | QQQ | ETF | 29.95 | 29.97 | 29.82 | 29.88 | 3619000.0 |
| 2003-06-10 14:00:00 | QQQ | ETF | 29.88 | 29.9 | 29.81 | 29.84 | 2002200.0 |
| 2003-06-10 14:30:00 | QQQ | ETF | 29.85 | 29.89 | 29.77 | 29.83 | 2683300.0 |
| 2003-06-10 15:00:00 | QQQ | ETF | 29.85 | 29.94 | 29.77 | 29.91 | 3594100.0 |
| 2003-06-10 15:30:00 | QQQ | ETF | 29.92 | 30.18 | 29.9 | 30.15 | 6640100.0 |
| 2003-06-10 16:00:00 | QQQ | ETF | 30.15 | 30.2 | 30.1 | 30.19 | 3710600.0 |
| 2003-06-10 16:30:00 | QQQ | ETF | 30.19 | 30.2 | 30.05 | 30.09 | 1268600.0 |
| 2003-06-10 17:00:00 | QQQ | ETF | 30.08 | 30.11 | 29.98 | 30.0 | 1622300.0 |
| 2003-06-10 17:30:00 | QQQ | ETF | 30.01 | 30.03 | 30.0 | 30.02 | 236100.0 |
| 2003-06-10 18:00:00 | QQQ | ETF | 30.02 | 30.04 | 30.02 | 30.04 | 22200.0 |
| 2003-06-10 18:30:00 | QQQ | ETF | 30.05 | 30.05 | 30.03 | 30.03 | 21700.0 |
| 2003-06-10 19:00:00 | QQQ | ETF | 30.04 | 30.05 | 30.04 | 30.05 | 4900.0 |
| 2003-06-10 19:30:00 | QQQ | ETF | 30.05 | 30.08 | 30.04 | 30.05 | 13700.0 |
| 2003-06-10 09:30:00 | IWM | ETF | 44.49 | 44.81 | 44.49 | 44.675 | 218400.0 |
| 2003-06-10 10:00:00 | IWM | ETF | 44.685 | 44.765 | 44.62 | 44.62 | 442000.0 |
> showing 50 of 708 rows — these rows as CSV