PREVIEW / etf_30min / 2003-02-18
file: by_date/etf_30min/2003/2003-02-18.parquet size: 21 KB rows: 650
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-18 08:00:00 | SPY | ETF | 84.5 | 84.5 | 84.2 | 84.49 | 26500.0 |
| 2003-02-18 08:30:00 | SPY | ETF | 84.58 | 84.64 | 84.53 | 84.62 | 20000.0 |
| 2003-02-18 09:00:00 | SPY | ETF | 84.62 | 84.68 | 84.5 | 84.5 | 39900.0 |
| 2003-02-18 09:30:00 | SPY | ETF | 84.53 | 85.19 | 84.49 | 85.03 | 7130500.0 |
| 2003-02-18 10:00:00 | SPY | ETF | 85.07 | 85.39 | 85.06 | 85.2 | 3338100.0 |
| 2003-02-18 10:30:00 | SPY | ETF | 85.21 | 85.56 | 85.06 | 85.45 | 3348000.0 |
| 2003-02-18 11:00:00 | SPY | ETF | 85.47 | 85.57 | 85.29 | 85.35 | 2290900.0 |
| 2003-02-18 11:30:00 | SPY | ETF | 85.35 | 85.42 | 85.22 | 85.35 | 1296700.0 |
| 2003-02-18 12:00:00 | SPY | ETF | 85.36 | 85.6 | 85.3 | 85.49 | 1081700.0 |
| 2003-02-18 12:30:00 | SPY | ETF | 85.5 | 85.66 | 85.45 | 85.61 | 1133100.0 |
| 2003-02-18 13:00:00 | SPY | ETF | 85.61 | 85.75 | 85.36 | 85.38 | 1335200.0 |
| 2003-02-18 13:30:00 | SPY | ETF | 85.38 | 85.55 | 85.32 | 85.52 | 1170700.0 |
| 2003-02-18 14:00:00 | SPY | ETF | 85.53 | 85.66 | 85.38 | 85.54 | 1891800.0 |
| 2003-02-18 14:30:00 | SPY | ETF | 85.54 | 85.69 | 85.29 | 85.38 | 1834800.0 |
| 2003-02-18 15:00:00 | SPY | ETF | 85.39 | 85.39 | 84.99 | 85.14 | 3616900.0 |
| 2003-02-18 15:30:00 | SPY | ETF | 85.14 | 85.54 | 85.0 | 85.5 | 3273700.0 |
| 2003-02-18 16:00:00 | SPY | ETF | 85.55 | 85.8 | 85.42 | 85.69 | 2948100.0 |
| 2003-02-18 16:30:00 | SPY | ETF | 85.66 | 85.68 | 85.14 | 85.6 | 77800.0 |
| 2003-02-18 17:00:00 | SPY | ETF | 85.6 | 85.65 | 85.6 | 85.65 | 18600.0 |
| 2003-02-18 17:30:00 | SPY | ETF | 85.62 | 85.62 | 85.54 | 85.59 | 9200.0 |
| 2003-02-18 18:00:00 | SPY | ETF | 85.62 | 85.62 | 85.54 | 85.62 | 10200.0 |
| 2003-02-18 18:30:00 | SPY | ETF | 85.61 | 85.65 | 85.61 | 85.65 | 5200.0 |
| 2003-02-18 19:00:00 | SPY | ETF | 85.56 | 85.56 | 85.54 | 85.54 | 3100.0 |
| 2003-02-18 19:30:00 | SPY | ETF | 85.63 | 85.63 | 85.58 | 85.58 | 5600.0 |
| 2003-02-18 08:00:00 | QQQ | ETF | 24.6 | 24.7 | 24.57 | 24.7 | 79800.0 |
| 2003-02-18 08:30:00 | QQQ | ETF | 24.7 | 24.76 | 24.67 | 24.73 | 71800.0 |
| 2003-02-18 09:00:00 | QQQ | ETF | 24.71 | 24.76 | 24.68 | 24.71 | 63800.0 |
| 2003-02-18 09:30:00 | QQQ | ETF | 24.7 | 25.01 | 24.68 | 24.91 | 14717300.0 |
| 2003-02-18 10:00:00 | QQQ | ETF | 24.93 | 25.04 | 24.84 | 24.88 | 8089300.0 |
| 2003-02-18 10:30:00 | QQQ | ETF | 24.88 | 25.1 | 24.84 | 25.04 | 7332200.0 |
| 2003-02-18 11:00:00 | QQQ | ETF | 25.04 | 25.1 | 24.97 | 25.0 | 3217200.0 |
| 2003-02-18 11:30:00 | QQQ | ETF | 25.0 | 25.03 | 24.9 | 24.99 | 2774800.0 |
| 2003-02-18 12:00:00 | QQQ | ETF | 24.99 | 25.08 | 24.94 | 25.05 | 1736200.0 |
| 2003-02-18 12:30:00 | QQQ | ETF | 25.04 | 25.1 | 25.01 | 25.1 | 2305300.0 |
| 2003-02-18 13:00:00 | QQQ | ETF | 25.1 | 25.16 | 25.02 | 25.02 | 4266400.0 |
| 2003-02-18 13:30:00 | QQQ | ETF | 25.02 | 25.12 | 25.01 | 25.08 | 3040500.0 |
| 2003-02-18 14:00:00 | QQQ | ETF | 25.08 | 25.19 | 25.06 | 25.15 | 3945600.0 |
| 2003-02-18 14:30:00 | QQQ | ETF | 25.15 | 25.23 | 25.08 | 25.11 | 2451800.0 |
| 2003-02-18 15:00:00 | QQQ | ETF | 25.11 | 25.13 | 24.93 | 24.97 | 4656800.0 |
| 2003-02-18 15:30:00 | QQQ | ETF | 24.97 | 25.22 | 24.94 | 25.2 | 6271900.0 |
| 2003-02-18 16:00:00 | QQQ | ETF | 25.21 | 25.34 | 25.17 | 25.22 | 3221300.0 |
| 2003-02-18 16:30:00 | QQQ | ETF | 25.24 | 25.31 | 25.21 | 25.31 | 147700.0 |
| 2003-02-18 17:00:00 | QQQ | ETF | 25.31 | 25.35 | 25.28 | 25.32 | 74900.0 |
| 2003-02-18 17:30:00 | QQQ | ETF | 25.32 | 25.32 | 25.29 | 25.29 | 16600.0 |
| 2003-02-18 18:00:00 | QQQ | ETF | 25.3 | 25.32 | 25.3 | 25.31 | 23200.0 |
| 2003-02-18 18:30:00 | QQQ | ETF | 25.3 | 25.33 | 25.28 | 25.28 | 10000.0 |
| 2003-02-18 19:00:00 | QQQ | ETF | 25.29 | 25.31 | 25.29 | 25.29 | 2500.0 |
| 2003-02-18 19:30:00 | QQQ | ETF | 25.3 | 25.32 | 25.28 | 25.3 | 10000.0 |
| 2003-02-18 09:30:00 | IWM | ETF | 35.925 | 36.07 | 35.925 | 36.015 | 292600.0 |
| 2003-02-18 10:00:00 | IWM | ETF | 36.025 | 36.11 | 35.99 | 35.99 | 141200.0 |
> showing 50 of 650 rows — these rows as CSV