PREVIEW / etf_30min / 2003-03-24
file: by_date/etf_30min/2003/2003-03-24.parquet size: 23 KB rows: 677
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-24 08:00:00 | SPY | ETF | 88.39 | 88.39 | 88.04 | 88.22 | 92100.0 |
| 2003-03-24 08:30:00 | SPY | ETF | 88.2 | 88.2 | 87.95 | 87.97 | 50400.0 |
| 2003-03-24 09:00:00 | SPY | ETF | 87.95 | 88.03 | 87.9 | 87.92 | 98400.0 |
| 2003-03-24 09:30:00 | SPY | ETF | 88.02 | 88.14 | 87.67 | 87.76 | 9145000.0 |
| 2003-03-24 10:00:00 | SPY | ETF | 87.76 | 87.87 | 87.3 | 87.35 | 6530600.0 |
| 2003-03-24 10:30:00 | SPY | ETF | 87.35 | 87.4 | 86.95 | 87.2 | 7607800.0 |
| 2003-03-24 11:00:00 | SPY | ETF | 87.19 | 87.3 | 86.86 | 87.08 | 3314200.0 |
| 2003-03-24 11:30:00 | SPY | ETF | 87.08 | 87.3 | 86.81 | 86.93 | 2273800.0 |
| 2003-03-24 12:00:00 | SPY | ETF | 86.95 | 87.1 | 86.72 | 87.0 | 1885300.0 |
| 2003-03-24 12:30:00 | SPY | ETF | 86.99 | 87.05 | 86.78 | 86.99 | 2158100.0 |
| 2003-03-24 13:00:00 | SPY | ETF | 87.01 | 87.01 | 86.87 | 86.95 | 1128200.0 |
| 2003-03-24 13:30:00 | SPY | ETF | 86.93 | 86.98 | 86.6 | 86.8 | 3242600.0 |
| 2003-03-24 14:00:00 | SPY | ETF | 86.81 | 86.86 | 86.35 | 86.69 | 6766800.0 |
| 2003-03-24 14:30:00 | SPY | ETF | 86.69 | 87.04 | 86.64 | 86.89 | 2647000.0 |
| 2003-03-24 15:00:00 | SPY | ETF | 86.88 | 87.17 | 86.74 | 86.82 | 3534700.0 |
| 2003-03-24 15:30:00 | SPY | ETF | 86.81 | 86.9 | 86.54 | 86.58 | 5402500.0 |
| 2003-03-24 16:00:00 | SPY | ETF | 86.57 | 86.73 | 86.51 | 86.6 | 2438000.0 |
| 2003-03-24 16:30:00 | SPY | ETF | 86.6 | 86.69 | 86.6 | 86.65 | 60300.0 |
| 2003-03-24 17:00:00 | SPY | ETF | 86.65 | 86.69 | 86.64 | 86.68 | 146500.0 |
| 2003-03-24 17:30:00 | SPY | ETF | 86.65 | 86.69 | 86.62 | 86.68 | 15800.0 |
| 2003-03-24 18:00:00 | SPY | ETF | 86.65 | 86.65 | 86.56 | 86.56 | 10700.0 |
| 2003-03-24 18:30:00 | SPY | ETF | 86.58 | 86.61 | 86.5 | 86.53 | 10000.0 |
| 2003-03-24 19:00:00 | SPY | ETF | 86.55 | 86.56 | 86.55 | 86.56 | 1200.0 |
| 2003-03-24 19:30:00 | SPY | ETF | 86.55 | 86.56 | 86.55 | 86.56 | 800.0 |
| 2003-03-24 08:00:00 | QQQ | ETF | 26.56 | 26.69 | 26.49 | 26.58 | 92400.0 |
| 2003-03-24 08:30:00 | QQQ | ETF | 26.58 | 26.58 | 26.45 | 26.47 | 122500.0 |
| 2003-03-24 09:00:00 | QQQ | ETF | 26.47 | 26.5 | 26.42 | 26.48 | 114100.0 |
| 2003-03-24 09:30:00 | QQQ | ETF | 26.47 | 26.6 | 26.38 | 26.51 | 15692800.0 |
| 2003-03-24 10:00:00 | QQQ | ETF | 26.5 | 26.57 | 26.3 | 26.32 | 8660300.0 |
| 2003-03-24 10:30:00 | QQQ | ETF | 26.33 | 26.4 | 26.23 | 26.3 | 7178600.0 |
| 2003-03-24 11:00:00 | QQQ | ETF | 26.3 | 26.36 | 26.19 | 26.3 | 4041900.0 |
| 2003-03-24 11:30:00 | QQQ | ETF | 26.3 | 26.38 | 26.23 | 26.25 | 2629100.0 |
| 2003-03-24 12:00:00 | QQQ | ETF | 26.25 | 26.3 | 26.2 | 26.28 | 2676400.0 |
| 2003-03-24 12:30:00 | QQQ | ETF | 26.27 | 26.3 | 26.2 | 26.24 | 2235500.0 |
| 2003-03-24 13:00:00 | QQQ | ETF | 26.25 | 26.29 | 26.22 | 26.23 | 2131200.0 |
| 2003-03-24 13:30:00 | QQQ | ETF | 26.24 | 26.26 | 26.08 | 26.14 | 7128600.0 |
| 2003-03-24 14:00:00 | QQQ | ETF | 26.13 | 26.15 | 25.97 | 26.1 | 7757300.0 |
| 2003-03-24 14:30:00 | QQQ | ETF | 26.08 | 26.23 | 26.07 | 26.15 | 4526500.0 |
| 2003-03-24 15:00:00 | QQQ | ETF | 26.15 | 26.25 | 26.06 | 26.09 | 4682000.0 |
| 2003-03-24 15:30:00 | QQQ | ETF | 26.06 | 26.15 | 26.01 | 26.03 | 7166000.0 |
| 2003-03-24 16:00:00 | QQQ | ETF | 26.05 | 26.07 | 26.0 | 26.01 | 2242400.0 |
| 2003-03-24 16:30:00 | QQQ | ETF | 26.01 | 26.07 | 25.98 | 26.07 | 124700.0 |
| 2003-03-24 17:00:00 | QQQ | ETF | 26.07 | 26.08 | 26.05 | 26.07 | 44300.0 |
| 2003-03-24 17:30:00 | QQQ | ETF | 26.08 | 26.09 | 26.05 | 26.06 | 37300.0 |
| 2003-03-24 18:00:00 | QQQ | ETF | 26.05 | 26.05 | 26.01 | 26.02 | 35700.0 |
| 2003-03-24 18:30:00 | QQQ | ETF | 26.04 | 26.05 | 26.01 | 26.05 | 26300.0 |
| 2003-03-24 19:00:00 | QQQ | ETF | 26.05 | 26.05 | 26.01 | 26.01 | 6200.0 |
| 2003-03-24 19:30:00 | QQQ | ETF | 26.01 | 26.03 | 26.0 | 26.02 | 14900.0 |
| 2003-03-24 08:30:00 | IWM | ETF | 36.755 | 36.755 | 36.755 | 36.755 | 2000.0 |
| 2003-03-24 09:00:00 | IWM | ETF | 36.8 | 36.8 | 36.765 | 36.765 | 2200.0 |
> showing 50 of 677 rows — these rows as CSV