PREVIEW / etf_30min / 2003-11-07
file: by_date/etf_30min/2003/2003-11-07.parquet size: 26 KB rows: 844
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-11-07 08:00:00 | SPY | ETF | 106.8 | 106.8 | 106.58 | 106.66 | 49600.0 |
| 2003-11-07 08:30:00 | SPY | ETF | 106.72 | 107.0 | 106.5 | 106.76 | 300900.0 |
| 2003-11-07 09:00:00 | SPY | ETF | 106.74 | 106.82 | 106.64 | 106.65 | 51200.0 |
| 2003-11-07 09:30:00 | SPY | ETF | 106.64 | 106.72 | 106.16 | 106.27 | 5909500.0 |
| 2003-11-07 10:00:00 | SPY | ETF | 106.27 | 106.52 | 106.15 | 106.47 | 2753800.0 |
| 2003-11-07 10:30:00 | SPY | ETF | 106.47 | 106.6 | 106.3 | 106.38 | 1155400.0 |
| 2003-11-07 11:00:00 | SPY | ETF | 106.4 | 106.41 | 106.21 | 106.3 | 1117300.0 |
| 2003-11-07 11:30:00 | SPY | ETF | 106.3 | 106.53 | 106.22 | 106.36 | 1104900.0 |
| 2003-11-07 12:00:00 | SPY | ETF | 106.35 | 106.4 | 106.05 | 106.09 | 1095000.0 |
| 2003-11-07 12:30:00 | SPY | ETF | 106.09 | 106.2 | 106.0 | 106.18 | 1138000.0 |
| 2003-11-07 13:00:00 | SPY | ETF | 106.17 | 106.41 | 106.14 | 106.36 | 1100100.0 |
| 2003-11-07 13:30:00 | SPY | ETF | 106.37 | 106.37 | 106.11 | 106.26 | 818500.0 |
| 2003-11-07 14:00:00 | SPY | ETF | 106.26 | 106.54 | 106.18 | 106.2 | 1325900.0 |
| 2003-11-07 14:30:00 | SPY | ETF | 106.18 | 106.37 | 106.09 | 106.2 | 1478900.0 |
| 2003-11-07 15:00:00 | SPY | ETF | 106.22 | 106.32 | 106.08 | 106.15 | 1669600.0 |
| 2003-11-07 15:30:00 | SPY | ETF | 106.14 | 106.19 | 105.65 | 105.81 | 4294800.0 |
| 2003-11-07 16:00:00 | SPY | ETF | 105.81 | 105.9 | 105.57 | 105.59 | 2246300.0 |
| 2003-11-07 16:30:00 | SPY | ETF | 105.6 | 105.62 | 105.58 | 105.61 | 70100.0 |
| 2003-11-07 17:00:00 | SPY | ETF | 105.61 | 105.61 | 105.59 | 105.59 | 7500.0 |
| 2003-11-07 17:30:00 | SPY | ETF | 105.6 | 105.6 | 105.55 | 105.55 | 3500.0 |
| 2003-11-07 18:00:00 | SPY | ETF | 105.58 | 105.58 | 105.58 | 105.58 | 300.0 |
| 2003-11-07 19:00:00 | SPY | ETF | 105.55 | 105.55 | 105.55 | 105.55 | 400.0 |
| 2003-11-07 19:30:00 | SPY | ETF | 105.6 | 105.6 | 105.6 | 105.6 | 200.0 |
| 2003-11-07 08:00:00 | QQQ | ETF | 36.07 | 36.12 | 36.05 | 36.11 | 201000.0 |
| 2003-11-07 08:30:00 | QQQ | ETF | 36.11 | 36.26 | 36.04 | 36.13 | 429700.0 |
| 2003-11-07 09:00:00 | QQQ | ETF | 36.12 | 36.15 | 36.04 | 36.08 | 162100.0 |
| 2003-11-07 09:30:00 | QQQ | ETF | 36.08 | 36.16 | 35.9 | 35.94 | 11032400.0 |
| 2003-11-07 10:00:00 | QQQ | ETF | 35.95 | 36.08 | 35.89 | 36.06 | 4991300.0 |
| 2003-11-07 10:30:00 | QQQ | ETF | 36.06 | 36.14 | 35.99 | 36.032 | 3811500.0 |
| 2003-11-07 11:00:00 | QQQ | ETF | 36.04 | 36.05 | 35.91 | 35.96 | 3186000.0 |
| 2003-11-07 11:30:00 | QQQ | ETF | 35.953 | 36.04 | 35.91 | 35.969 | 2064900.0 |
| 2003-11-07 12:00:00 | QQQ | ETF | 35.964 | 36.0 | 35.88 | 35.9 | 2502500.0 |
| 2003-11-07 12:30:00 | QQQ | ETF | 35.91 | 35.96 | 35.84 | 35.94 | 2871100.0 |
| 2003-11-07 13:00:00 | QQQ | ETF | 35.94 | 36.1 | 35.93 | 36.08 | 2667900.0 |
| 2003-11-07 13:30:00 | QQQ | ETF | 36.08 | 36.09 | 35.96 | 36.039 | 2824000.0 |
| 2003-11-07 14:00:00 | QQQ | ETF | 36.04 | 36.15 | 36.0 | 36.007 | 3774400.0 |
| 2003-11-07 14:30:00 | QQQ | ETF | 36.01 | 36.11 | 35.96 | 36.016 | 2426300.0 |
| 2003-11-07 15:00:00 | QQQ | ETF | 36.019 | 36.07 | 35.94 | 35.946 | 3904700.0 |
| 2003-11-07 15:30:00 | QQQ | ETF | 35.95 | 35.96 | 35.67 | 35.76 | 7184900.0 |
| 2003-11-07 16:00:00 | QQQ | ETF | 35.79 | 35.83 | 35.57 | 35.6 | 5036500.0 |
| 2003-11-07 16:30:00 | QQQ | ETF | 35.61 | 35.62 | 35.596 | 35.619 | 114400.0 |
| 2003-11-07 17:00:00 | QQQ | ETF | 35.62 | 35.63 | 35.59 | 35.61 | 38700.0 |
| 2003-11-07 17:30:00 | QQQ | ETF | 35.621 | 35.65 | 35.61 | 35.62 | 50700.0 |
| 2003-11-07 18:00:00 | QQQ | ETF | 35.639 | 35.639 | 35.61 | 35.61 | 24700.0 |
| 2003-11-07 18:30:00 | QQQ | ETF | 35.62 | 35.63 | 35.62 | 35.63 | 7300.0 |
| 2003-11-07 19:00:00 | QQQ | ETF | 35.62 | 35.62 | 35.61 | 35.62 | 4300.0 |
| 2003-11-07 19:30:00 | QQQ | ETF | 35.62 | 35.63 | 35.62 | 35.63 | 3900.0 |
| 2003-11-07 08:30:00 | IWM | ETF | 54.67 | 54.67 | 54.64 | 54.64 | 1800.0 |
| 2003-11-07 09:00:00 | IWM | ETF | 54.65 | 54.65 | 54.63 | 54.63 | 1400.0 |
| 2003-11-07 09:30:00 | IWM | ETF | 54.5 | 54.66 | 54.17 | 54.19 | 1992000.0 |
> showing 50 of 844 rows — these rows as CSV