PREVIEW / etf_30min / 2003-07-22
file: by_date/etf_30min/2003/2003-07-22.parquet size: 23 KB rows: 697
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-22 08:00:00 | SPY | ETF | 98.74 | 98.78 | 98.63 | 98.69 | 10400.0 |
| 2003-07-22 08:30:00 | SPY | ETF | 98.66 | 98.67 | 98.55 | 98.62 | 13600.0 |
| 2003-07-22 09:00:00 | SPY | ETF | 98.65 | 98.7 | 98.65 | 98.69 | 18000.0 |
| 2003-07-22 09:30:00 | SPY | ETF | 98.69 | 98.775 | 98.2 | 98.44 | 5070800.0 |
| 2003-07-22 10:00:00 | SPY | ETF | 98.43 | 98.66 | 97.93 | 98.0 | 3389100.0 |
| 2003-07-22 10:30:00 | SPY | ETF | 97.998 | 98.24 | 97.91 | 98.1 | 1714900.0 |
| 2003-07-22 11:00:00 | SPY | ETF | 98.09 | 98.55 | 98.09 | 98.52 | 4986000.0 |
| 2003-07-22 11:30:00 | SPY | ETF | 98.52 | 99.34 | 98.5 | 99.25 | 4606800.0 |
| 2003-07-22 12:00:00 | SPY | ETF | 99.24 | 99.41 | 99.03 | 99.08 | 3450600.0 |
| 2003-07-22 12:30:00 | SPY | ETF | 99.06 | 99.25 | 99.0 | 99.151 | 1124500.0 |
| 2003-07-22 13:00:00 | SPY | ETF | 99.15 | 99.24 | 98.87 | 99.0 | 2405300.0 |
| 2003-07-22 13:30:00 | SPY | ETF | 98.99 | 99.08 | 98.56 | 98.949 | 4345600.0 |
| 2003-07-22 14:00:00 | SPY | ETF | 98.93 | 99.28 | 98.88 | 99.26 | 3394900.0 |
| 2003-07-22 14:30:00 | SPY | ETF | 99.25 | 99.35 | 99.11 | 99.33 | 1936900.0 |
| 2003-07-22 15:00:00 | SPY | ETF | 99.32 | 99.4 | 99.028 | 99.11 | 1615900.0 |
| 2003-07-22 15:30:00 | SPY | ETF | 99.1 | 99.3 | 98.92 | 99.12 | 3801500.0 |
| 2003-07-22 16:00:00 | SPY | ETF | 99.103 | 99.25 | 99.08 | 99.15 | 1780200.0 |
| 2003-07-22 16:30:00 | SPY | ETF | 99.18 | 99.3 | 98.8178 | 99.29 | 144200.0 |
| 2003-07-22 17:00:00 | SPY | ETF | 99.28 | 99.356 | 99.28 | 99.32 | 540900.0 |
| 2003-07-22 17:30:00 | SPY | ETF | 99.3 | 99.36 | 99.28 | 99.36 | 108700.0 |
| 2003-07-22 18:00:00 | SPY | ETF | 99.36 | 99.42 | 99.36 | 99.4 | 15800.0 |
| 2003-07-22 18:30:00 | SPY | ETF | 99.4 | 99.42 | 99.4 | 99.42 | 2400.0 |
| 2003-07-22 19:00:00 | SPY | ETF | 99.36 | 99.42 | 99.36 | 99.4 | 1800.0 |
| 2003-07-22 08:00:00 | QQQ | ETF | 31.14 | 31.14 | 31.08 | 31.11 | 61000.0 |
| 2003-07-22 08:30:00 | QQQ | ETF | 31.11 | 31.12 | 31.05 | 31.08 | 92600.0 |
| 2003-07-22 09:00:00 | QQQ | ETF | 31.07 | 31.12 | 31.06 | 31.11 | 80200.0 |
| 2003-07-22 09:30:00 | QQQ | ETF | 31.11 | 31.15 | 30.91 | 31.1 | 10157400.0 |
| 2003-07-22 10:00:00 | QQQ | ETF | 31.09 | 31.18 | 30.9 | 30.95 | 7273900.0 |
| 2003-07-22 10:30:00 | QQQ | ETF | 30.95 | 31.064 | 30.86 | 30.96 | 3629300.0 |
| 2003-07-22 11:00:00 | QQQ | ETF | 30.96 | 31.12 | 30.92 | 31.07 | 5156900.0 |
| 2003-07-22 11:30:00 | QQQ | ETF | 31.09 | 31.5 | 31.04 | 31.42 | 12757000.0 |
| 2003-07-22 12:00:00 | QQQ | ETF | 31.42 | 31.46 | 31.3 | 31.31 | 6720600.0 |
| 2003-07-22 12:30:00 | QQQ | ETF | 31.31 | 31.42 | 31.29 | 31.33 | 2294600.0 |
| 2003-07-22 13:00:00 | QQQ | ETF | 31.33 | 31.38 | 31.2 | 31.31 | 4000900.0 |
| 2003-07-22 13:30:00 | QQQ | ETF | 31.303 | 31.38 | 31.1 | 31.286 | 6012600.0 |
| 2003-07-22 14:00:00 | QQQ | ETF | 31.29 | 31.4 | 31.22 | 31.4 | 2655700.0 |
| 2003-07-22 14:30:00 | QQQ | ETF | 31.39 | 31.43 | 31.3 | 31.37 | 4139200.0 |
| 2003-07-22 15:00:00 | QQQ | ETF | 31.37 | 31.41 | 31.26 | 31.29 | 3890300.0 |
| 2003-07-22 15:30:00 | QQQ | ETF | 31.3 | 31.44 | 31.22 | 31.307 | 8509800.0 |
| 2003-07-22 16:00:00 | QQQ | ETF | 31.3 | 31.41 | 31.28 | 31.37 | 3501200.0 |
| 2003-07-22 16:30:00 | QQQ | ETF | 31.37 | 31.45 | 31.36 | 31.37 | 464700.0 |
| 2003-07-22 17:00:00 | QQQ | ETF | 31.4 | 31.45 | 31.27 | 31.41 | 428800.0 |
| 2003-07-22 17:30:00 | QQQ | ETF | 31.4 | 31.42 | 31.383 | 31.42 | 124600.0 |
| 2003-07-22 18:00:00 | QQQ | ETF | 31.41 | 31.44 | 31.391 | 31.436 | 31300.0 |
| 2003-07-22 18:30:00 | QQQ | ETF | 31.43 | 31.44 | 31.42 | 31.44 | 26100.0 |
| 2003-07-22 19:00:00 | QQQ | ETF | 31.42 | 31.43 | 31.39 | 31.4 | 14500.0 |
| 2003-07-22 19:30:00 | QQQ | ETF | 31.4 | 31.41 | 31.39 | 31.4 | 13400.0 |
| 2003-07-22 09:30:00 | IWM | ETF | 45.86 | 45.88 | 45.71 | 45.81 | 751400.0 |
| 2003-07-22 10:00:00 | IWM | ETF | 45.82 | 45.94 | 45.64 | 45.655 | 690800.0 |
| 2003-07-22 10:30:00 | IWM | ETF | 45.73 | 45.74 | 45.66 | 45.695 | 94600.0 |
> showing 50 of 697 rows — these rows as CSV