PREVIEW / etf_30min / 2003-02-04
file: by_date/etf_30min/2003/2003-02-04.parquet size: 21 KB rows: 634
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-04 08:00:00 | SPY | ETF | 85.67 | 85.7 | 85.59 | 85.6 | 8200.0 |
| 2003-02-04 08:30:00 | SPY | ETF | 85.6 | 85.62 | 85.52 | 85.62 | 7200.0 |
| 2003-02-04 09:00:00 | SPY | ETF | 85.6 | 85.6 | 85.34 | 85.34 | 38800.0 |
| 2003-02-04 09:30:00 | SPY | ETF | 85.31 | 85.43 | 84.68 | 84.93 | 6816400.0 |
| 2003-02-04 10:00:00 | SPY | ETF | 84.92 | 85.1 | 84.47 | 84.79 | 4481100.0 |
| 2003-02-04 10:30:00 | SPY | ETF | 84.8 | 84.88 | 84.57 | 84.68 | 1825600.0 |
| 2003-02-04 11:00:00 | SPY | ETF | 84.68 | 84.77 | 84.3 | 84.43 | 2935300.0 |
| 2003-02-04 11:30:00 | SPY | ETF | 84.43 | 84.66 | 84.38 | 84.61 | 1887100.0 |
| 2003-02-04 12:00:00 | SPY | ETF | 84.61 | 84.77 | 84.48 | 84.72 | 1085900.0 |
| 2003-02-04 12:30:00 | SPY | ETF | 84.72 | 84.86 | 84.64 | 84.65 | 2102400.0 |
| 2003-02-04 13:00:00 | SPY | ETF | 84.66 | 84.98 | 84.6 | 84.84 | 1523400.0 |
| 2003-02-04 13:30:00 | SPY | ETF | 84.87 | 85.22 | 84.74 | 85.04 | 2603400.0 |
| 2003-02-04 14:00:00 | SPY | ETF | 85.0 | 85.15 | 84.86 | 84.98 | 1416900.0 |
| 2003-02-04 14:30:00 | SPY | ETF | 84.98 | 85.19 | 84.66 | 84.75 | 2879700.0 |
| 2003-02-04 15:00:00 | SPY | ETF | 84.71 | 84.9 | 84.59 | 84.72 | 3614500.0 |
| 2003-02-04 15:30:00 | SPY | ETF | 84.69 | 85.23 | 84.66 | 85.14 | 4284400.0 |
| 2003-02-04 16:00:00 | SPY | ETF | 85.11 | 86.84 | 85.1 | 85.31 | 2094100.0 |
| 2003-02-04 16:30:00 | SPY | ETF | 85.31 | 85.63 | 85.1 | 85.25 | 322000.0 |
| 2003-02-04 17:00:00 | SPY | ETF | 85.27 | 85.99 | 85.14 | 85.35 | 407500.0 |
| 2003-02-04 17:30:00 | SPY | ETF | 85.36 | 85.42 | 85.32 | 85.33 | 88400.0 |
| 2003-02-04 18:00:00 | SPY | ETF | 85.33 | 85.39 | 85.24 | 85.38 | 10500.0 |
| 2003-02-04 18:30:00 | SPY | ETF | 85.33 | 85.4 | 85.24 | 85.25 | 1700.0 |
| 2003-02-04 19:00:00 | SPY | ETF | 85.25 | 85.27 | 85.25 | 85.27 | 2200.0 |
| 2003-02-04 19:30:00 | SPY | ETF | 85.3 | 85.35 | 85.3 | 85.35 | 1500.0 |
| 2003-02-04 08:00:00 | QQQ | ETF | 24.25 | 24.27 | 24.21 | 24.24 | 17000.0 |
| 2003-02-04 08:30:00 | QQQ | ETF | 24.23 | 24.24 | 24.16 | 24.18 | 25300.0 |
| 2003-02-04 09:00:00 | QQQ | ETF | 24.2 | 24.22 | 24.17 | 24.17 | 50500.0 |
| 2003-02-04 09:30:00 | QQQ | ETF | 24.18 | 24.22 | 24.06 | 24.19 | 11209600.0 |
| 2003-02-04 10:00:00 | QQQ | ETF | 24.18 | 24.29 | 24.03 | 24.19 | 7672300.0 |
| 2003-02-04 10:30:00 | QQQ | ETF | 24.2 | 24.2 | 24.03 | 24.05 | 3723200.0 |
| 2003-02-04 11:00:00 | QQQ | ETF | 24.05 | 24.06 | 23.82 | 23.87 | 6850900.0 |
| 2003-02-04 11:30:00 | QQQ | ETF | 23.88 | 23.97 | 23.86 | 23.94 | 2140600.0 |
| 2003-02-04 12:00:00 | QQQ | ETF | 23.94 | 24.02 | 23.9 | 24.0 | 3703000.0 |
| 2003-02-04 12:30:00 | QQQ | ETF | 24.0 | 24.04 | 23.95 | 23.97 | 1988700.0 |
| 2003-02-04 13:00:00 | QQQ | ETF | 24.0 | 24.09 | 23.95 | 24.05 | 1750200.0 |
| 2003-02-04 13:30:00 | QQQ | ETF | 24.05 | 24.18 | 24.0 | 24.09 | 2642200.0 |
| 2003-02-04 14:00:00 | QQQ | ETF | 24.09 | 24.18 | 24.02 | 24.07 | 3278500.0 |
| 2003-02-04 14:30:00 | QQQ | ETF | 24.07 | 24.13 | 23.95 | 23.98 | 4640500.0 |
| 2003-02-04 15:00:00 | QQQ | ETF | 23.98 | 24.04 | 23.91 | 23.97 | 2440400.0 |
| 2003-02-04 15:30:00 | QQQ | ETF | 23.97 | 24.15 | 23.95 | 24.14 | 3936900.0 |
| 2003-02-04 16:00:00 | QQQ | ETF | 24.17 | 24.3 | 24.11 | 24.15 | 3535500.0 |
| 2003-02-04 16:30:00 | QQQ | ETF | 24.17 | 24.17 | 24.0 | 24.07 | 1470000.0 |
| 2003-02-04 17:00:00 | QQQ | ETF | 24.06 | 24.25 | 23.94 | 24.24 | 4343300.0 |
| 2003-02-04 17:30:00 | QQQ | ETF | 24.25 | 24.27 | 24.19 | 24.2 | 307200.0 |
| 2003-02-04 18:00:00 | QQQ | ETF | 24.2 | 24.24 | 24.13 | 24.13 | 66200.0 |
| 2003-02-04 18:30:00 | QQQ | ETF | 24.15 | 24.15 | 24.08 | 24.1 | 48700.0 |
| 2003-02-04 19:00:00 | QQQ | ETF | 24.13 | 24.13 | 24.08 | 24.1 | 53000.0 |
| 2003-02-04 19:30:00 | QQQ | ETF | 24.12 | 24.21 | 24.12 | 24.21 | 26300.0 |
| 2003-02-04 09:00:00 | IWM | ETF | 36.67 | 36.67 | 36.67 | 36.67 | 1200.0 |
| 2003-02-04 09:30:00 | IWM | ETF | 36.525 | 36.59 | 36.45 | 36.47 | 1272400.0 |
> showing 50 of 634 rows — these rows as CSV