PREVIEW / etf_30min / 2003-06-16
file: by_date/etf_30min/2003/2003-06-16.parquet size: 24 KB rows: 735
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-16 08:00:00 | SPY | ETF | 99.44 | 99.97 | 99.44 | 99.97 | 10300.0 |
| 2003-06-16 08:30:00 | SPY | ETF | 99.96 | 100.0 | 99.94 | 99.96 | 28200.0 |
| 2003-06-16 09:00:00 | SPY | ETF | 99.96 | 100.02 | 99.87 | 99.96 | 26000.0 |
| 2003-06-16 09:30:00 | SPY | ETF | 99.96 | 100.17 | 99.8 | 100.03 | 3582700.0 |
| 2003-06-16 10:00:00 | SPY | ETF | 100.03 | 100.39 | 100.0 | 100.33 | 2524000.0 |
| 2003-06-16 10:30:00 | SPY | ETF | 100.33 | 100.97 | 100.27 | 100.91 | 3723200.0 |
| 2003-06-16 11:00:00 | SPY | ETF | 100.9 | 101.18 | 100.9 | 101.0 | 2707800.0 |
| 2003-06-16 11:30:00 | SPY | ETF | 100.99 | 101.23 | 100.92 | 101.05 | 2639100.0 |
| 2003-06-16 12:00:00 | SPY | ETF | 101.07 | 101.25 | 101.0 | 101.022 | 1342100.0 |
| 2003-06-16 12:30:00 | SPY | ETF | 101.04 | 101.11 | 100.91 | 100.96 | 1381900.0 |
| 2003-06-16 13:00:00 | SPY | ETF | 100.94 | 101.04 | 100.85 | 100.96 | 858800.0 |
| 2003-06-16 13:30:00 | SPY | ETF | 100.97 | 101.15 | 100.95 | 101.11 | 1205200.0 |
| 2003-06-16 14:00:00 | SPY | ETF | 101.129 | 101.28 | 101.08 | 101.24 | 1860400.0 |
| 2003-06-16 14:30:00 | SPY | ETF | 101.21 | 101.34 | 101.21 | 101.28 | 2224800.0 |
| 2003-06-16 15:00:00 | SPY | ETF | 101.3 | 101.31 | 101.05 | 101.12 | 1659900.0 |
| 2003-06-16 15:30:00 | SPY | ETF | 101.1 | 101.66 | 101.1 | 101.64 | 5226400.0 |
| 2003-06-16 16:00:00 | SPY | ETF | 101.626 | 101.7 | 101.37 | 101.6 | 1772100.0 |
| 2003-06-16 16:30:00 | SPY | ETF | 101.62 | 101.67 | 101.6 | 101.63 | 104100.0 |
| 2003-06-16 17:00:00 | SPY | ETF | 101.627 | 101.627 | 101.6 | 101.627 | 19100.0 |
| 2003-06-16 17:30:00 | SPY | ETF | 101.62 | 101.66 | 101.62 | 101.66 | 7200.0 |
| 2003-06-16 18:00:00 | SPY | ETF | 101.65 | 101.67 | 101.65 | 101.66 | 3600.0 |
| 2003-06-16 18:30:00 | SPY | ETF | 101.69 | 101.69 | 101.66 | 101.69 | 1900.0 |
| 2003-06-16 19:00:00 | SPY | ETF | 101.64 | 101.68 | 101.59 | 101.68 | 55000.0 |
| 2003-06-16 19:30:00 | SPY | ETF | 101.68 | 101.73 | 101.68 | 101.73 | 20600.0 |
| 2003-06-16 08:00:00 | QQQ | ETF | 29.97 | 30.09 | 29.95 | 30.09 | 49900.0 |
| 2003-06-16 08:30:00 | QQQ | ETF | 30.08 | 30.2 | 30.06 | 30.15 | 74300.0 |
| 2003-06-16 09:00:00 | QQQ | ETF | 30.16 | 30.19 | 30.11 | 30.15 | 73200.0 |
| 2003-06-16 09:30:00 | QQQ | ETF | 30.17 | 30.24 | 30.0 | 30.08 | 7392200.0 |
| 2003-06-16 10:00:00 | QQQ | ETF | 30.08 | 30.27 | 30.06 | 30.22 | 6455700.0 |
| 2003-06-16 10:30:00 | QQQ | ETF | 30.23 | 30.57 | 30.16 | 30.53 | 9971200.0 |
| 2003-06-16 11:00:00 | QQQ | ETF | 30.54 | 30.68 | 30.52 | 30.594 | 6589900.0 |
| 2003-06-16 11:30:00 | QQQ | ETF | 30.594 | 30.69 | 30.54 | 30.6 | 4916900.0 |
| 2003-06-16 12:00:00 | QQQ | ETF | 30.62 | 30.694 | 30.6 | 30.62 | 2534800.0 |
| 2003-06-16 12:30:00 | QQQ | ETF | 30.62 | 30.65 | 30.56 | 30.57 | 1990300.0 |
| 2003-06-16 13:00:00 | QQQ | ETF | 30.573 | 30.62 | 30.52 | 30.58 | 1228000.0 |
| 2003-06-16 13:30:00 | QQQ | ETF | 30.6 | 30.67 | 30.58 | 30.66 | 1432400.0 |
| 2003-06-16 14:00:00 | QQQ | ETF | 30.66 | 30.78 | 30.66 | 30.74 | 5387900.0 |
| 2003-06-16 14:30:00 | QQQ | ETF | 30.745 | 30.798 | 30.7 | 30.73 | 3489100.0 |
| 2003-06-16 15:00:00 | QQQ | ETF | 30.74 | 30.76 | 30.6 | 30.64 | 3629900.0 |
| 2003-06-16 15:30:00 | QQQ | ETF | 30.65 | 30.84 | 30.63 | 30.81 | 6411800.0 |
| 2003-06-16 16:00:00 | QQQ | ETF | 30.81 | 30.92 | 30.78 | 30.92 | 2700000.0 |
| 2003-06-16 16:30:00 | QQQ | ETF | 30.92 | 30.949 | 30.891 | 30.93 | 252500.0 |
| 2003-06-16 17:00:00 | QQQ | ETF | 30.921 | 30.94 | 30.91 | 30.91 | 301600.0 |
| 2003-06-16 17:30:00 | QQQ | ETF | 30.92 | 30.93 | 30.91 | 30.93 | 34300.0 |
| 2003-06-16 18:00:00 | QQQ | ETF | 30.93 | 30.94 | 30.9 | 30.9 | 318100.0 |
| 2003-06-16 18:30:00 | QQQ | ETF | 30.9 | 30.92 | 30.89 | 30.89 | 21700.0 |
| 2003-06-16 19:00:00 | QQQ | ETF | 30.88 | 30.89 | 30.87 | 30.88 | 5800.0 |
| 2003-06-16 19:30:00 | QQQ | ETF | 30.88 | 30.9 | 30.88 | 30.89 | 11000.0 |
| 2003-06-16 09:30:00 | IWM | ETF | 45.1 | 45.15 | 44.97 | 45.035 | 446600.0 |
| 2003-06-16 10:00:00 | IWM | ETF | 45.055 | 45.155 | 45.025 | 45.125 | 171800.0 |
> showing 50 of 735 rows — these rows as CSV