PREVIEW / etf_30min / 2003-12-24
file: by_date/etf_30min/2003/2003-12-24.parquet size: 18 KB rows: 477
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-12-24 08:00:00 | SPY | ETF | 109.55 | 109.55 | 109.52 | 109.55 | 1400.0 |
| 2003-12-24 08:30:00 | SPY | ETF | 109.48 | 109.48 | 109.38 | 109.42 | 40700.0 |
| 2003-12-24 09:00:00 | SPY | ETF | 109.48 | 109.55 | 109.48 | 109.55 | 3400.0 |
| 2003-12-24 09:30:00 | SPY | ETF | 109.52 | 109.61 | 109.43 | 109.58 | 1294000.0 |
| 2003-12-24 10:00:00 | SPY | ETF | 109.59 | 109.72 | 109.53 | 109.67 | 850300.0 |
| 2003-12-24 10:30:00 | SPY | ETF | 109.67 | 109.88 | 109.56 | 109.84 | 1136900.0 |
| 2003-12-24 11:00:00 | SPY | ETF | 109.84 | 109.86 | 109.74 | 109.83 | 552000.0 |
| 2003-12-24 11:30:00 | SPY | ETF | 109.83 | 109.86 | 109.65 | 109.69 | 1075900.0 |
| 2003-12-24 12:00:00 | SPY | ETF | 109.68 | 109.76 | 109.68 | 109.75 | 830700.0 |
| 2003-12-24 12:30:00 | SPY | ETF | 109.75 | 109.78 | 109.55 | 109.64 | 1624300.0 |
| 2003-12-24 13:00:00 | SPY | ETF | 109.64 | 109.65 | 109.51 | 109.62 | 166700.0 |
| 2003-12-24 08:00:00 | QQQ | ETF | 35.83 | 35.89 | 35.83 | 35.87 | 16800.0 |
| 2003-12-24 08:30:00 | QQQ | ETF | 35.86 | 35.86 | 35.77 | 35.81 | 83800.0 |
| 2003-12-24 09:00:00 | QQQ | ETF | 35.81 | 35.87 | 35.81 | 35.84 | 45100.0 |
| 2003-12-24 09:30:00 | QQQ | ETF | 35.84 | 35.93 | 35.8 | 35.91 | 4717400.0 |
| 2003-12-24 10:00:00 | QQQ | ETF | 35.91 | 35.97 | 35.87 | 35.96 | 3686100.0 |
| 2003-12-24 10:30:00 | QQQ | ETF | 35.96 | 36.006 | 35.86 | 35.985 | 2878900.0 |
| 2003-12-24 11:00:00 | QQQ | ETF | 35.98 | 36.02 | 35.94 | 35.985 | 3433000.0 |
| 2003-12-24 11:30:00 | QQQ | ETF | 35.98 | 36.0 | 35.92 | 35.94 | 3941400.0 |
| 2003-12-24 12:00:00 | QQQ | ETF | 35.94 | 35.98 | 35.93 | 35.97 | 1801200.0 |
| 2003-12-24 12:30:00 | QQQ | ETF | 35.97 | 35.991 | 35.85 | 35.875 | 22561000.0 |
| 2003-12-24 13:00:00 | QQQ | ETF | 35.877 | 35.9 | 35.85 | 35.9 | 151600.0 |
| 2003-12-24 09:00:00 | IWM | ETF | 55.035 | 55.035 | 55.035 | 55.035 | 200.0 |
| 2003-12-24 09:30:00 | IWM | ETF | 55.05 | 55.085 | 54.935 | 55.055 | 256400.0 |
| 2003-12-24 10:00:00 | IWM | ETF | 55.03 | 55.135 | 54.98 | 55.045 | 172600.0 |
| 2003-12-24 10:30:00 | IWM | ETF | 55.085 | 55.085 | 54.995 | 55.075 | 76400.0 |
| 2003-12-24 11:00:00 | IWM | ETF | 55.075 | 55.085 | 55.025 | 55.075 | 63600.0 |
| 2003-12-24 11:30:00 | IWM | ETF | 55.075 | 55.18 | 55.065 | 55.125 | 89000.0 |
| 2003-12-24 12:00:00 | IWM | ETF | 55.14 | 55.18 | 55.12 | 55.175 | 76200.0 |
| 2003-12-24 12:30:00 | IWM | ETF | 55.16 | 55.175 | 54.982 | 55.01 | 386800.0 |
| 2003-12-24 13:00:00 | IWM | ETF | 55.03 | 55.04 | 54.945 | 55.04 | 80600.0 |
| 2003-12-24 08:00:00 | DIA | ETF | 103.22 | 103.4 | 103.19 | 103.19 | 8800.0 |
| 2003-12-24 08:30:00 | DIA | ETF | 103.11 | 103.15 | 103.1 | 103.12 | 6800.0 |
| 2003-12-24 09:00:00 | DIA | ETF | 103.2 | 103.2 | 103.16 | 103.16 | 1600.0 |
| 2003-12-24 09:30:00 | DIA | ETF | 103.16 | 103.33 | 103.1 | 103.27 | 354800.0 |
| 2003-12-24 10:00:00 | DIA | ETF | 103.26 | 103.44 | 103.2 | 103.33 | 243000.0 |
| 2003-12-24 10:30:00 | DIA | ETF | 103.32 | 103.43 | 103.2 | 103.41 | 551900.0 |
| 2003-12-24 11:00:00 | DIA | ETF | 103.41 | 103.43 | 103.25 | 103.33 | 190500.0 |
| 2003-12-24 11:30:00 | DIA | ETF | 103.33 | 103.38 | 103.2 | 103.25 | 230900.0 |
| 2003-12-24 12:00:00 | DIA | ETF | 103.26 | 103.31 | 103.2 | 103.28 | 134500.0 |
| 2003-12-24 12:30:00 | DIA | ETF | 103.245 | 103.3 | 103.15 | 103.16 | 1365400.0 |
| 2003-12-24 13:00:00 | DIA | ETF | 103.16 | 103.2 | 103.11 | 103.2 | 24400.0 |
| 2003-12-24 09:30:00 | TLT | ETF | 86.37 | 86.52 | 86.33 | 86.34 | 29900.0 |
| 2003-12-24 10:00:00 | TLT | ETF | 86.41 | 86.41 | 86.17 | 86.25 | 27300.0 |
| 2003-12-24 10:30:00 | TLT | ETF | 86.28 | 86.31 | 86.25 | 86.31 | 3800.0 |
| 2003-12-24 11:00:00 | TLT | ETF | 86.3 | 86.48 | 86.3 | 86.48 | 18500.0 |
| 2003-12-24 11:30:00 | TLT | ETF | 86.45 | 86.53 | 86.41 | 86.53 | 31000.0 |
| 2003-12-24 12:00:00 | TLT | ETF | 86.59 | 86.6 | 86.5 | 86.59 | 1700.0 |
| 2003-12-24 12:30:00 | TLT | ETF | 86.56 | 86.64 | 86.54 | 86.6 | 21700.0 |
| 2003-12-24 13:00:00 | TLT | ETF | 86.59 | 86.66 | 86.59 | 86.66 | 5000.0 |
> showing 50 of 477 rows — these rows as CSV