PREVIEW / etf_30min / 2003-06-26
file: by_date/etf_30min/2003/2003-06-26.parquet size: 24 KB rows: 708
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-06-26 08:00:00 | SPY | ETF | 97.85 | 97.85 | 97.75 | 97.83 | 35000.0 |
| 2003-06-26 08:30:00 | SPY | ETF | 97.77 | 97.86 | 97.71 | 97.72 | 48700.0 |
| 2003-06-26 09:00:00 | SPY | ETF | 97.7 | 97.86 | 97.66 | 97.84 | 42700.0 |
| 2003-06-26 09:30:00 | SPY | ETF | 97.78 | 98.06 | 97.6 | 98.03 | 5168800.0 |
| 2003-06-26 10:00:00 | SPY | ETF | 98.01 | 98.24 | 97.83 | 97.92 | 3780900.0 |
| 2003-06-26 10:30:00 | SPY | ETF | 97.92 | 98.244 | 97.61 | 98.1 | 3105600.0 |
| 2003-06-26 11:00:00 | SPY | ETF | 98.078 | 98.2 | 97.954 | 98.09 | 812900.0 |
| 2003-06-26 11:30:00 | SPY | ETF | 98.099 | 98.6 | 98.08 | 98.59 | 2676900.0 |
| 2003-06-26 12:00:00 | SPY | ETF | 98.6 | 98.68 | 98.49 | 98.54 | 2011200.0 |
| 2003-06-26 12:30:00 | SPY | ETF | 98.54 | 98.661 | 98.344 | 98.42 | 1160200.0 |
| 2003-06-26 13:00:00 | SPY | ETF | 98.44 | 98.59 | 98.41 | 98.5 | 634500.0 |
| 2003-06-26 13:30:00 | SPY | ETF | 98.51 | 98.67 | 98.46 | 98.49 | 1097700.0 |
| 2003-06-26 14:00:00 | SPY | ETF | 98.533 | 98.87 | 98.53 | 98.82 | 1639700.0 |
| 2003-06-26 14:30:00 | SPY | ETF | 98.82 | 98.979 | 98.69 | 98.787 | 2048500.0 |
| 2003-06-26 15:00:00 | SPY | ETF | 98.784 | 98.87 | 98.61 | 98.73 | 1070000.0 |
| 2003-06-26 15:30:00 | SPY | ETF | 98.717 | 98.9 | 98.52 | 98.87 | 1861900.0 |
| 2003-06-26 16:00:00 | SPY | ETF | 98.89 | 98.96 | 98.72 | 98.96 | 1271100.0 |
| 2003-06-26 16:30:00 | SPY | ETF | 98.96 | 99.02 | 98.02 | 98.81 | 241500.0 |
| 2003-06-26 17:00:00 | SPY | ETF | 98.877 | 98.877 | 98.78 | 98.8 | 44400.0 |
| 2003-06-26 17:30:00 | SPY | ETF | 98.8 | 98.83 | 98.78 | 98.83 | 24100.0 |
| 2003-06-26 18:00:00 | SPY | ETF | 98.87 | 98.89 | 98.83 | 98.89 | 8400.0 |
| 2003-06-26 19:00:00 | SPY | ETF | 98.91 | 98.91 | 98.9 | 98.9 | 2100.0 |
| 2003-06-26 19:30:00 | SPY | ETF | 98.93 | 98.94 | 98.88 | 98.94 | 6200.0 |
| 2003-06-26 08:00:00 | QQQ | ETF | 29.63 | 29.66 | 29.62 | 29.65 | 36800.0 |
| 2003-06-26 08:30:00 | QQQ | ETF | 29.65 | 29.68 | 29.62 | 29.63 | 86400.0 |
| 2003-06-26 09:00:00 | QQQ | ETF | 29.62 | 29.7 | 29.6 | 29.69 | 76500.0 |
| 2003-06-26 09:30:00 | QQQ | ETF | 29.71 | 29.95 | 29.61 | 29.87 | 12119300.0 |
| 2003-06-26 10:00:00 | QQQ | ETF | 29.9 | 29.97 | 29.7 | 29.85 | 8491900.0 |
| 2003-06-26 10:30:00 | QQQ | ETF | 29.843 | 29.93 | 29.72 | 29.85 | 5810600.0 |
| 2003-06-26 11:00:00 | QQQ | ETF | 29.87 | 29.92 | 29.81 | 29.88 | 2281700.0 |
| 2003-06-26 11:30:00 | QQQ | ETF | 29.888 | 30.118 | 29.88 | 30.118 | 7905600.0 |
| 2003-06-26 12:00:00 | QQQ | ETF | 30.1 | 30.17 | 30.07 | 30.08 | 4834700.0 |
| 2003-06-26 12:30:00 | QQQ | ETF | 30.08 | 30.17 | 30.02 | 30.07 | 3817300.0 |
| 2003-06-26 13:00:00 | QQQ | ETF | 30.07 | 30.11 | 30.04 | 30.06 | 2483400.0 |
| 2003-06-26 13:30:00 | QQQ | ETF | 30.05 | 30.14 | 30.05 | 30.09 | 1765000.0 |
| 2003-06-26 14:00:00 | QQQ | ETF | 30.087 | 30.23 | 30.08 | 30.21 | 4177500.0 |
| 2003-06-26 14:30:00 | QQQ | ETF | 30.21 | 30.28 | 30.11 | 30.18 | 4690300.0 |
| 2003-06-26 15:00:00 | QQQ | ETF | 30.18 | 30.22 | 30.06 | 30.1 | 2847000.0 |
| 2003-06-26 15:30:00 | QQQ | ETF | 30.13 | 30.28 | 30.01 | 30.21 | 7501200.0 |
| 2003-06-26 16:00:00 | QQQ | ETF | 30.21 | 30.23 | 30.17 | 30.23 | 1921200.0 |
| 2003-06-26 16:30:00 | QQQ | ETF | 30.24 | 30.26 | 30.2 | 30.23 | 171300.0 |
| 2003-06-26 17:00:00 | QQQ | ETF | 30.232 | 30.25 | 30.22 | 30.24 | 84600.0 |
| 2003-06-26 17:30:00 | QQQ | ETF | 30.22 | 30.25 | 30.203 | 30.23 | 41700.0 |
| 2003-06-26 18:00:00 | QQQ | ETF | 30.25 | 30.26 | 30.22 | 30.257 | 25600.0 |
| 2003-06-26 18:30:00 | QQQ | ETF | 30.25 | 30.25 | 30.25 | 30.25 | 200.0 |
| 2003-06-26 19:00:00 | QQQ | ETF | 30.26 | 30.27 | 30.26 | 30.27 | 17700.0 |
| 2003-06-26 19:30:00 | QQQ | ETF | 30.26 | 30.28 | 30.25 | 30.26 | 8600.0 |
| 2003-06-26 09:00:00 | IWM | ETF | 44.22 | 44.22 | 44.22 | 44.22 | 1800.0 |
| 2003-06-26 09:30:00 | IWM | ETF | 44.275 | 44.43 | 44.2 | 44.425 | 913200.0 |
| 2003-06-26 10:00:00 | IWM | ETF | 44.425 | 44.5 | 44.35 | 44.445 | 729200.0 |
> showing 50 of 708 rows — these rows as CSV