PREVIEW / etf_30min / 2003-12-26
file: by_date/etf_30min/2003/2003-12-26.parquet size: 17 KB rows: 463
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-26 08:00:00 | SPY | ETF | 109.76 | 109.85 | 109.75 | 109.85 | 14200.0 |
| 2003-12-26 08:30:00 | SPY | ETF | 109.85 | 109.9 | 109.85 | 109.86 | 11500.0 |
| 2003-12-26 09:00:00 | SPY | ETF | 109.83 | 109.83 | 109.75 | 109.75 | 700.0 |
| 2003-12-26 09:30:00 | SPY | ETF | 109.71 | 110.0 | 109.71 | 110.0 | 1637600.0 |
| 2003-12-26 10:00:00 | SPY | ETF | 109.98 | 110.08 | 109.86 | 109.94 | 745500.0 |
| 2003-12-26 10:30:00 | SPY | ETF | 109.94 | 110.02 | 109.91 | 109.95 | 468400.0 |
| 2003-12-26 11:00:00 | SPY | ETF | 109.93 | 110.0 | 109.9 | 109.98 | 526100.0 |
| 2003-12-26 11:30:00 | SPY | ETF | 109.98 | 110.04 | 109.88 | 109.91 | 1085400.0 |
| 2003-12-26 12:00:00 | SPY | ETF | 109.9 | 109.95 | 109.72 | 109.77 | 1461500.0 |
| 2003-12-26 12:30:00 | SPY | ETF | 109.78 | 109.86 | 109.71 | 109.81 | 899700.0 |
| 2003-12-26 13:00:00 | SPY | ETF | 109.8 | 109.87 | 109.63 | 109.7 | 427600.0 |
| 2003-12-26 08:00:00 | QQQ | ETF | 36.0 | 36.01 | 35.96 | 36.01 | 69700.0 |
| 2003-12-26 08:30:00 | QQQ | ETF | 36.01 | 36.04 | 36.0 | 36.03 | 181100.0 |
| 2003-12-26 09:00:00 | QQQ | ETF | 36.03 | 36.03 | 35.97 | 35.97 | 31900.0 |
| 2003-12-26 09:30:00 | QQQ | ETF | 35.96 | 36.08 | 35.93 | 36.06 | 3551900.0 |
| 2003-12-26 10:00:00 | QQQ | ETF | 36.06 | 36.09 | 35.95 | 36.03 | 3661900.0 |
| 2003-12-26 10:30:00 | QQQ | ETF | 36.023 | 36.04 | 35.96 | 35.98 | 2155000.0 |
| 2003-12-26 11:00:00 | QQQ | ETF | 35.96 | 36.02 | 35.94 | 36.0 | 3187000.0 |
| 2003-12-26 11:30:00 | QQQ | ETF | 36.005 | 36.02 | 35.96 | 35.97 | 3060800.0 |
| 2003-12-26 12:00:00 | QQQ | ETF | 35.98 | 35.99 | 35.85 | 35.861 | 3231000.0 |
| 2003-12-26 12:30:00 | QQQ | ETF | 35.85 | 35.91 | 35.84 | 35.88 | 3961500.0 |
| 2003-12-26 13:00:00 | QQQ | ETF | 35.88 | 35.89 | 35.82 | 35.85 | 344200.0 |
| 2003-12-26 09:30:00 | IWM | ETF | 55.175 | 55.345 | 55.1 | 55.345 | 90400.0 |
| 2003-12-26 10:00:00 | IWM | ETF | 55.32 | 55.375 | 55.205 | 55.255 | 352200.0 |
| 2003-12-26 10:30:00 | IWM | ETF | 55.275 | 55.29 | 55.24 | 55.285 | 148200.0 |
| 2003-12-26 11:00:00 | IWM | ETF | 55.285 | 55.285 | 55.22 | 55.25 | 194800.0 |
| 2003-12-26 11:30:00 | IWM | ETF | 55.255 | 55.3 | 55.225 | 55.225 | 108200.0 |
| 2003-12-26 12:00:00 | IWM | ETF | 55.25 | 55.265 | 55.14 | 55.195 | 102400.0 |
| 2003-12-26 12:30:00 | IWM | ETF | 55.185 | 55.3345 | 55.175 | 55.3345 | 316800.0 |
| 2003-12-26 13:00:00 | IWM | ETF | 55.295 | 55.295 | 55.195 | 55.235 | 17200.0 |
| 2003-12-26 08:00:00 | DIA | ETF | 103.27 | 103.28 | 103.25 | 103.28 | 7000.0 |
| 2003-12-26 08:30:00 | DIA | ETF | 103.36 | 103.39 | 103.36 | 103.39 | 2300.0 |
| 2003-12-26 09:00:00 | DIA | ETF | 103.4 | 103.4 | 103.26 | 103.26 | 6300.0 |
| 2003-12-26 09:30:00 | DIA | ETF | 103.25 | 103.44 | 103.2 | 103.42 | 439100.0 |
| 2003-12-26 10:00:00 | DIA | ETF | 103.42 | 103.52 | 103.33 | 103.4 | 194700.0 |
| 2003-12-26 10:30:00 | DIA | ETF | 103.38 | 103.47 | 103.38 | 103.41 | 88700.0 |
| 2003-12-26 11:00:00 | DIA | ETF | 103.44 | 103.45 | 103.38 | 103.42 | 100200.0 |
| 2003-12-26 11:30:00 | DIA | ETF | 103.43 | 103.48 | 103.37 | 103.407 | 527100.0 |
| 2003-12-26 12:00:00 | DIA | ETF | 103.39 | 103.43 | 103.27 | 103.31 | 151500.0 |
| 2003-12-26 12:30:00 | DIA | ETF | 103.32 | 103.4 | 103.27 | 103.35 | 518100.0 |
| 2003-12-26 13:00:00 | DIA | ETF | 103.4 | 103.4 | 103.21 | 103.27 | 31300.0 |
| 2003-12-26 09:30:00 | TLT | ETF | 86.9 | 87.0 | 86.9 | 86.98 | 27100.0 |
| 2003-12-26 10:00:00 | TLT | ETF | 87.0 | 87.0 | 86.96 | 86.97 | 7800.0 |
| 2003-12-26 10:30:00 | TLT | ETF | 86.95 | 86.96 | 86.93 | 86.95 | 1300.0 |
| 2003-12-26 11:00:00 | TLT | ETF | 86.96 | 87.03 | 86.96 | 87.01 | 16000.0 |
| 2003-12-26 11:30:00 | TLT | ETF | 87.01 | 87.02 | 86.99 | 87.0 | 13200.0 |
| 2003-12-26 12:00:00 | TLT | ETF | 87.04 | 87.04 | 87.0 | 87.0 | 1500.0 |
| 2003-12-26 12:30:00 | TLT | ETF | 87.0 | 87.04 | 86.99 | 87.0 | 10500.0 |
| 2003-12-26 13:00:00 | TLT | ETF | 86.99 | 86.99 | 86.98 | 86.98 | 3000.0 |
> showing 49 of 463 rows — these rows as CSV