PREVIEW / etf_30min / 2003-07-03
file: by_date/etf_30min/2003/2003-07-03.parquet size: 16 KB rows: 401
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-07-03 08:00:00 | SPY | ETF | 99.3 | 99.43 | 99.3 | 99.35 | 15200.0 |
| 2003-07-03 08:30:00 | SPY | ETF | 99.29 | 99.29 | 98.83 | 98.88 | 112800.0 |
| 2003-07-03 09:00:00 | SPY | ETF | 98.95 | 99.12 | 98.95 | 99.05 | 165900.0 |
| 2003-07-03 09:30:00 | SPY | ETF | 99.07 | 99.39 | 98.95 | 99.2 | 4733200.0 |
| 2003-07-03 10:00:00 | SPY | ETF | 99.22 | 99.8 | 99.13 | 99.31 | 7347800.0 |
| 2003-07-03 10:30:00 | SPY | ETF | 99.3 | 99.499 | 97.904 | 99.08 | 7371400.0 |
| 2003-07-03 11:00:00 | SPY | ETF | 99.08 | 99.42 | 99.0 | 99.261 | 1113500.0 |
| 2003-07-03 11:30:00 | SPY | ETF | 99.26 | 99.43 | 99.145 | 99.35 | 1068900.0 |
| 2003-07-03 12:00:00 | SPY | ETF | 99.35 | 99.38 | 98.95 | 98.96 | 1516800.0 |
| 2003-07-03 12:30:00 | SPY | ETF | 98.96 | 99.08 | 98.87 | 98.9 | 2697700.0 |
| 2003-07-03 13:00:00 | SPY | ETF | 98.92 | 98.96 | 98.61 | 98.62 | 700900.0 |
| 2003-07-03 08:00:00 | QQQ | ETF | 30.8 | 30.84 | 30.76 | 30.8 | 76900.0 |
| 2003-07-03 08:30:00 | QQQ | ETF | 30.79 | 30.79 | 30.61 | 30.63 | 290600.0 |
| 2003-07-03 09:00:00 | QQQ | ETF | 30.64 | 30.72 | 30.64 | 30.71 | 178600.0 |
| 2003-07-03 09:30:00 | QQQ | ETF | 30.7 | 30.96 | 30.64 | 30.86 | 12695500.0 |
| 2003-07-03 10:00:00 | QQQ | ETF | 30.866 | 31.1 | 30.85 | 30.861 | 8890100.0 |
| 2003-07-03 10:30:00 | QQQ | ETF | 30.867 | 30.9 | 30.47 | 30.7 | 8358200.0 |
| 2003-07-03 11:00:00 | QQQ | ETF | 30.7 | 30.86 | 30.68 | 30.8 | 2364600.0 |
| 2003-07-03 11:30:00 | QQQ | ETF | 30.8 | 30.9 | 30.75 | 30.85 | 2534600.0 |
| 2003-07-03 12:00:00 | QQQ | ETF | 30.86 | 30.87 | 30.69 | 30.713 | 2694100.0 |
| 2003-07-03 12:30:00 | QQQ | ETF | 30.71 | 30.8 | 30.642 | 30.65 | 4308100.0 |
| 2003-07-03 13:00:00 | QQQ | ETF | 30.65 | 30.69 | 30.47 | 30.55 | 1481400.0 |
| 2003-07-03 13:30:00 | QQQ | ETF | 30.55 | 30.6 | 30.53 | 30.56 | 12600.0 |
| 2003-07-03 14:00:00 | QQQ | ETF | 30.59 | 30.59 | 30.58 | 30.58 | 1400.0 |
| 2003-07-03 09:00:00 | IWM | ETF | 45.5 | 45.5 | 45.5 | 45.5 | 9800.0 |
| 2003-07-03 09:30:00 | IWM | ETF | 45.51 | 45.6 | 45.405 | 45.55 | 242600.0 |
| 2003-07-03 10:00:00 | IWM | ETF | 45.585 | 45.825 | 45.55 | 45.725 | 165000.0 |
| 2003-07-03 10:30:00 | IWM | ETF | 45.73 | 45.76 | 45.515 | 45.705 | 319400.0 |
| 2003-07-03 11:00:00 | IWM | ETF | 45.7 | 45.745 | 45.605 | 45.74 | 68400.0 |
| 2003-07-03 11:30:00 | IWM | ETF | 45.7 | 45.74 | 45.665 | 45.74 | 232800.0 |
| 2003-07-03 12:00:00 | IWM | ETF | 45.65 | 45.725 | 45.545 | 45.545 | 336200.0 |
| 2003-07-03 12:30:00 | IWM | ETF | 45.55 | 45.59 | 45.515 | 45.59 | 272000.0 |
| 2003-07-03 13:00:00 | IWM | ETF | 45.525 | 45.525 | 45.48 | 45.48 | 7400.0 |
| 2003-07-03 08:00:00 | DIA | ETF | 91.31 | 91.38 | 91.29 | 91.34 | 15400.0 |
| 2003-07-03 08:30:00 | DIA | ETF | 91.24 | 91.65 | 90.85 | 90.88 | 19800.0 |
| 2003-07-03 09:00:00 | DIA | ETF | 90.95 | 91.11 | 90.95 | 91.0 | 5900.0 |
| 2003-07-03 09:30:00 | DIA | ETF | 91.0 | 91.26 | 90.9 | 91.14 | 509400.0 |
| 2003-07-03 10:00:00 | DIA | ETF | 91.14 | 91.67 | 91.03 | 91.2 | 509400.0 |
| 2003-07-03 10:30:00 | DIA | ETF | 91.2 | 91.3 | 90.01 | 90.9 | 519200.0 |
| 2003-07-03 11:00:00 | DIA | ETF | 90.95 | 91.26 | 90.9 | 91.2 | 130800.0 |
| 2003-07-03 11:30:00 | DIA | ETF | 91.11 | 91.25 | 91.03 | 91.24 | 96800.0 |
| 2003-07-03 12:00:00 | DIA | ETF | 91.22 | 91.22 | 90.97 | 90.97 | 174400.0 |
| 2003-07-03 12:30:00 | DIA | ETF | 90.99 | 91.08 | 90.86 | 90.87 | 914900.0 |
| 2003-07-03 13:00:00 | DIA | ETF | 90.92 | 90.92 | 90.65 | 90.7 | 62900.0 |
| 2003-07-03 09:30:00 | TLT | ETF | 91.7 | 91.71 | 91.5 | 91.5 | 72700.0 |
| 2003-07-03 10:00:00 | TLT | ETF | 91.19 | 91.2 | 90.68 | 91.05 | 189500.0 |
| 2003-07-03 10:30:00 | TLT | ETF | 91.0 | 91.2 | 90.8 | 90.9 | 146400.0 |
| 2003-07-03 11:00:00 | TLT | ETF | 90.93 | 90.97 | 90.73 | 90.89 | 27500.0 |
| 2003-07-03 11:30:00 | TLT | ETF | 90.96 | 90.96 | 90.74 | 90.74 | 55700.0 |
| 2003-07-03 12:00:00 | TLT | ETF | 90.7 | 90.83 | 90.65 | 90.83 | 19600.0 |
> showing 50 of 401 rows — these rows as CSV