PREVIEW / etf_30min / 2003-02-19
file: by_date/etf_30min/2003/2003-02-19.parquet size: 21 KB rows: 604
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-02-19 08:00:00 | SPY | ETF | 85.56 | 85.56 | 85.43 | 85.45 | 16600.0 |
| 2003-02-19 08:30:00 | SPY | ETF | 85.45 | 85.47 | 85.26 | 85.3 | 92400.0 |
| 2003-02-19 09:00:00 | SPY | ETF | 85.33 | 85.47 | 85.32 | 85.38 | 22600.0 |
| 2003-02-19 09:30:00 | SPY | ETF | 85.32 | 85.47 | 85.07 | 85.2 | 4378400.0 |
| 2003-02-19 10:00:00 | SPY | ETF | 85.2 | 85.37 | 84.94 | 85.09 | 1818300.0 |
| 2003-02-19 10:30:00 | SPY | ETF | 85.1 | 85.22 | 84.8 | 84.92 | 2431100.0 |
| 2003-02-19 11:00:00 | SPY | ETF | 84.9 | 85.09 | 84.82 | 84.97 | 1595000.0 |
| 2003-02-19 11:30:00 | SPY | ETF | 84.95 | 84.99 | 84.7 | 84.91 | 1280700.0 |
| 2003-02-19 12:00:00 | SPY | ETF | 84.88 | 85.0 | 84.81 | 84.88 | 842200.0 |
| 2003-02-19 12:30:00 | SPY | ETF | 84.88 | 85.07 | 84.85 | 84.97 | 929300.0 |
| 2003-02-19 13:00:00 | SPY | ETF | 85.0 | 85.0 | 84.69 | 84.73 | 1304200.0 |
| 2003-02-19 13:30:00 | SPY | ETF | 84.73 | 84.76 | 84.46 | 84.62 | 2236700.0 |
| 2003-02-19 14:00:00 | SPY | ETF | 84.63 | 84.74 | 84.4 | 84.54 | 1264100.0 |
| 2003-02-19 14:30:00 | SPY | ETF | 84.53 | 84.63 | 84.32 | 84.38 | 2191800.0 |
| 2003-02-19 15:00:00 | SPY | ETF | 84.37 | 84.83 | 84.28 | 84.8 | 2777700.0 |
| 2003-02-19 15:30:00 | SPY | ETF | 84.79 | 84.94 | 84.66 | 84.93 | 3436900.0 |
| 2003-02-19 16:00:00 | SPY | ETF | 84.93 | 85.18 | 84.86 | 85.15 | 1510100.0 |
| 2003-02-19 16:30:00 | SPY | ETF | 85.1 | 85.19 | 85.06 | 85.14 | 30400.0 |
| 2003-02-19 17:00:00 | SPY | ETF | 85.12 | 85.14 | 85.07 | 85.12 | 28400.0 |
| 2003-02-19 17:30:00 | SPY | ETF | 85.09 | 85.1 | 85.09 | 85.1 | 1000.0 |
| 2003-02-19 18:00:00 | SPY | ETF | 85.07 | 85.15 | 85.07 | 85.15 | 4900.0 |
| 2003-02-19 19:30:00 | SPY | ETF | 85.14 | 85.18 | 85.14 | 85.18 | 1200.0 |
| 2003-02-19 08:00:00 | QQQ | ETF | 25.3 | 25.38 | 25.28 | 25.3 | 54400.0 |
| 2003-02-19 08:30:00 | QQQ | ETF | 25.3 | 25.35 | 25.2 | 25.21 | 73800.0 |
| 2003-02-19 09:00:00 | QQQ | ETF | 25.22 | 25.24 | 25.16 | 25.18 | 34100.0 |
| 2003-02-19 09:30:00 | QQQ | ETF | 25.2 | 25.22 | 25.05 | 25.15 | 6083300.0 |
| 2003-02-19 10:00:00 | QQQ | ETF | 25.14 | 25.24 | 25.01 | 25.09 | 3267600.0 |
| 2003-02-19 10:30:00 | QQQ | ETF | 25.08 | 25.12 | 24.96 | 25.05 | 4142100.0 |
| 2003-02-19 11:00:00 | QQQ | ETF | 25.05 | 25.1 | 24.98 | 25.03 | 2040800.0 |
| 2003-02-19 11:30:00 | QQQ | ETF | 25.03 | 25.05 | 24.91 | 25.0 | 2222300.0 |
| 2003-02-19 12:00:00 | QQQ | ETF | 24.97 | 25.04 | 24.95 | 24.99 | 949900.0 |
| 2003-02-19 12:30:00 | QQQ | ETF | 25.0 | 25.07 | 24.98 | 25.02 | 1125600.0 |
| 2003-02-19 13:00:00 | QQQ | ETF | 25.02 | 25.05 | 24.92 | 24.93 | 1114900.0 |
| 2003-02-19 13:30:00 | QQQ | ETF | 24.93 | 24.95 | 24.78 | 24.86 | 3838600.0 |
| 2003-02-19 14:00:00 | QQQ | ETF | 24.87 | 24.93 | 24.8 | 24.83 | 1920500.0 |
| 2003-02-19 14:30:00 | QQQ | ETF | 24.83 | 24.88 | 24.71 | 24.75 | 3324400.0 |
| 2003-02-19 15:00:00 | QQQ | ETF | 24.74 | 24.95 | 24.71 | 24.93 | 3146100.0 |
| 2003-02-19 15:30:00 | QQQ | ETF | 24.93 | 25.02 | 24.85 | 25.02 | 4370500.0 |
| 2003-02-19 16:00:00 | QQQ | ETF | 25.02 | 25.09 | 24.97 | 25.06 | 2611500.0 |
| 2003-02-19 16:30:00 | QQQ | ETF | 25.05 | 25.08 | 24.95 | 25.08 | 84900.0 |
| 2003-02-19 17:00:00 | QQQ | ETF | 25.07 | 25.07 | 25.04 | 25.07 | 66800.0 |
| 2003-02-19 17:30:00 | QQQ | ETF | 25.07 | 25.1 | 25.01 | 25.08 | 82700.0 |
| 2003-02-19 18:00:00 | QQQ | ETF | 25.08 | 25.11 | 25.08 | 25.08 | 16600.0 |
| 2003-02-19 18:30:00 | QQQ | ETF | 25.1 | 25.1 | 25.09 | 25.09 | 2300.0 |
| 2003-02-19 19:00:00 | QQQ | ETF | 25.09 | 25.11 | 25.08 | 25.08 | 8700.0 |
| 2003-02-19 19:30:00 | QQQ | ETF | 25.08 | 25.12 | 25.08 | 25.11 | 8100.0 |
| 2003-02-19 09:30:00 | IWM | ETF | 36.275 | 36.275 | 36.09 | 36.135 | 626600.0 |
| 2003-02-19 10:00:00 | IWM | ETF | 36.125 | 36.2 | 36.085 | 36.11 | 137800.0 |
| 2003-02-19 10:30:00 | IWM | ETF | 36.09 | 36.11 | 35.94 | 35.94 | 195800.0 |
| 2003-02-19 11:00:00 | IWM | ETF | 35.96 | 36.015 | 35.94 | 35.94 | 46600.0 |
> showing 50 of 604 rows — these rows as CSV