PREVIEW / etf_30min / 2003-03-19
file: by_date/etf_30min/2003/2003-03-19.parquet size: 22 KB rows: 648
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-03-19 08:00:00 | SPY | ETF | 87.8 | 87.98 | 87.7 | 87.92 | 67800.0 |
| 2003-03-19 08:30:00 | SPY | ETF | 87.78 | 87.87 | 87.62 | 87.62 | 139500.0 |
| 2003-03-19 09:00:00 | SPY | ETF | 87.5 | 87.57 | 87.26 | 87.28 | 76900.0 |
| 2003-03-19 09:30:00 | SPY | ETF | 87.28 | 87.7 | 87.14 | 87.29 | 5366200.0 |
| 2003-03-19 10:00:00 | SPY | ETF | 87.34 | 87.63 | 87.15 | 87.35 | 3350500.0 |
| 2003-03-19 10:30:00 | SPY | ETF | 87.38 | 87.65 | 87.28 | 87.31 | 2052700.0 |
| 2003-03-19 11:00:00 | SPY | ETF | 87.3 | 87.33 | 86.81 | 86.97 | 4504700.0 |
| 2003-03-19 11:30:00 | SPY | ETF | 86.94 | 87.03 | 86.68 | 86.73 | 2368700.0 |
| 2003-03-19 12:00:00 | SPY | ETF | 86.72 | 87.06 | 86.7 | 87.05 | 2644800.0 |
| 2003-03-19 12:30:00 | SPY | ETF | 87.04 | 87.47 | 86.98 | 87.32 | 3640700.0 |
| 2003-03-19 13:00:00 | SPY | ETF | 87.34 | 87.51 | 87.2 | 87.33 | 2182800.0 |
| 2003-03-19 13:30:00 | SPY | ETF | 87.39 | 87.39 | 87.07 | 87.32 | 1793400.0 |
| 2003-03-19 14:00:00 | SPY | ETF | 87.34 | 87.38 | 86.92 | 87.31 | 1680500.0 |
| 2003-03-19 14:30:00 | SPY | ETF | 87.28 | 87.89 | 87.15 | 87.73 | 5760700.0 |
| 2003-03-19 15:00:00 | SPY | ETF | 87.75 | 87.88 | 87.39 | 87.84 | 3264600.0 |
| 2003-03-19 15:30:00 | SPY | ETF | 87.82 | 88.16 | 87.8 | 87.95 | 4896000.0 |
| 2003-03-19 16:00:00 | SPY | ETF | 88.01 | 88.01 | 87.81 | 87.93 | 2603700.0 |
| 2003-03-19 16:30:00 | SPY | ETF | 87.94 | 88.0 | 87.92 | 88.0 | 151400.0 |
| 2003-03-19 17:00:00 | SPY | ETF | 87.98 | 88.04 | 87.94 | 88.04 | 20200.0 |
| 2003-03-19 17:30:00 | SPY | ETF | 88.0 | 88.18 | 88.0 | 88.17 | 55700.0 |
| 2003-03-19 18:00:00 | SPY | ETF | 88.15 | 88.2 | 88.08 | 88.13 | 21300.0 |
| 2003-03-19 18:30:00 | SPY | ETF | 88.12 | 88.22 | 88.12 | 88.22 | 1200.0 |
| 2003-03-19 19:00:00 | SPY | ETF | 88.19 | 88.3 | 88.17 | 88.25 | 7100.0 |
| 2003-03-19 19:30:00 | SPY | ETF | 88.25 | 88.28 | 88.25 | 88.25 | 1300.0 |
| 2003-03-19 20:00:00 | SPY | ETF | 88.25 | 88.25 | 88.25 | 88.25 | 100.0 |
| 2003-03-19 08:00:00 | QQQ | ETF | 27.1 | 27.15 | 27.07 | 27.12 | 80300.0 |
| 2003-03-19 08:30:00 | QQQ | ETF | 27.09 | 27.09 | 26.97 | 26.97 | 97200.0 |
| 2003-03-19 09:00:00 | QQQ | ETF | 26.95 | 26.96 | 26.81 | 26.82 | 149200.0 |
| 2003-03-19 09:30:00 | QQQ | ETF | 26.85 | 26.98 | 26.61 | 26.69 | 12112300.0 |
| 2003-03-19 10:00:00 | QQQ | ETF | 26.66 | 26.77 | 26.58 | 26.67 | 7781100.0 |
| 2003-03-19 10:30:00 | QQQ | ETF | 26.67 | 26.74 | 26.56 | 26.57 | 5131100.0 |
| 2003-03-19 11:00:00 | QQQ | ETF | 26.57 | 26.62 | 26.42 | 26.48 | 7291700.0 |
| 2003-03-19 11:30:00 | QQQ | ETF | 26.49 | 26.51 | 26.33 | 26.37 | 4944300.0 |
| 2003-03-19 12:00:00 | QQQ | ETF | 26.36 | 26.53 | 26.34 | 26.5 | 4688500.0 |
| 2003-03-19 12:30:00 | QQQ | ETF | 26.51 | 26.65 | 26.45 | 26.59 | 7006300.0 |
| 2003-03-19 13:00:00 | QQQ | ETF | 26.6 | 26.65 | 26.51 | 26.58 | 3192900.0 |
| 2003-03-19 13:30:00 | QQQ | ETF | 26.59 | 26.6 | 26.46 | 26.55 | 3374600.0 |
| 2003-03-19 14:00:00 | QQQ | ETF | 26.56 | 26.58 | 26.43 | 26.54 | 2568900.0 |
| 2003-03-19 14:30:00 | QQQ | ETF | 26.54 | 26.78 | 26.51 | 26.71 | 6909700.0 |
| 2003-03-19 15:00:00 | QQQ | ETF | 26.71 | 26.76 | 26.53 | 26.72 | 3843600.0 |
| 2003-03-19 15:30:00 | QQQ | ETF | 26.72 | 26.88 | 26.65 | 26.7 | 11358800.0 |
| 2003-03-19 16:00:00 | QQQ | ETF | 26.71 | 26.74 | 26.65 | 26.68 | 5705800.0 |
| 2003-03-19 16:30:00 | QQQ | ETF | 26.69 | 26.72 | 26.63 | 26.64 | 169500.0 |
| 2003-03-19 17:00:00 | QQQ | ETF | 26.65 | 26.7 | 26.65 | 26.7 | 24300.0 |
| 2003-03-19 17:30:00 | QQQ | ETF | 26.67 | 26.73 | 26.67 | 26.73 | 81900.0 |
| 2003-03-19 18:00:00 | QQQ | ETF | 26.74 | 26.76 | 26.68 | 26.73 | 42000.0 |
| 2003-03-19 18:30:00 | QQQ | ETF | 26.74 | 26.81 | 26.74 | 26.79 | 38100.0 |
| 2003-03-19 19:00:00 | QQQ | ETF | 26.8 | 26.85 | 26.77 | 26.82 | 13400.0 |
| 2003-03-19 19:30:00 | QQQ | ETF | 26.8 | 26.82 | 26.78 | 26.78 | 48900.0 |
| 2003-03-19 09:30:00 | IWM | ETF | 36.725 | 36.725 | 36.44 | 36.48 | 182200.0 |
> showing 50 of 648 rows — these rows as CSV