PREVIEW / etf_30min / 2003-05-27
file: by_date/etf_30min/2003/2003-05-27.parquet size: 25 KB rows: 736
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-05-27 08:00:00 | SPY | ETF | 93.35 | 93.35 | 93.26 | 93.31 | 45800.0 |
| 2003-05-27 08:30:00 | SPY | ETF | 93.29 | 93.29 | 93.21 | 93.26 | 7100.0 |
| 2003-05-27 09:00:00 | SPY | ETF | 93.27 | 93.35 | 93.25 | 93.31 | 15300.0 |
| 2003-05-27 09:30:00 | SPY | ETF | 93.3 | 93.57 | 93.18 | 93.55 | 4913500.0 |
| 2003-05-27 10:00:00 | SPY | ETF | 93.55 | 94.55 | 93.38 | 94.54 | 7119800.0 |
| 2003-05-27 10:30:00 | SPY | ETF | 94.5 | 94.9 | 94.47 | 94.89 | 3453300.0 |
| 2003-05-27 11:00:00 | SPY | ETF | 94.89 | 95.04 | 94.72 | 94.91 | 2210100.0 |
| 2003-05-27 11:30:00 | SPY | ETF | 94.88 | 95.03 | 94.76 | 94.9 | 1969600.0 |
| 2003-05-27 12:00:00 | SPY | ETF | 94.87 | 95.26 | 94.87 | 95.18 | 1930000.0 |
| 2003-05-27 12:30:00 | SPY | ETF | 95.15 | 95.19 | 95.0 | 95.03 | 1195100.0 |
| 2003-05-27 13:00:00 | SPY | ETF | 95.03 | 95.33 | 94.96 | 95.26 | 1052200.0 |
| 2003-05-27 13:30:00 | SPY | ETF | 95.27 | 95.42 | 95.24 | 95.26 | 2119600.0 |
| 2003-05-27 14:00:00 | SPY | ETF | 95.25 | 95.31 | 95.11 | 95.16 | 1355700.0 |
| 2003-05-27 14:30:00 | SPY | ETF | 95.15 | 95.44 | 95.1 | 95.43 | 1643100.0 |
| 2003-05-27 15:00:00 | SPY | ETF | 95.38 | 95.65 | 95.36 | 95.6 | 2946300.0 |
| 2003-05-27 15:30:00 | SPY | ETF | 95.61 | 95.84 | 95.59 | 95.62 | 4651900.0 |
| 2003-05-27 16:00:00 | SPY | ETF | 95.61 | 95.69 | 95.4 | 95.52 | 2640800.0 |
| 2003-05-27 16:30:00 | SPY | ETF | 95.5 | 95.51 | 95.42 | 95.46 | 124700.0 |
| 2003-05-27 17:00:00 | SPY | ETF | 95.49 | 95.5 | 95.45 | 95.5 | 95000.0 |
| 2003-05-27 17:30:00 | SPY | ETF | 95.48 | 95.52 | 95.45 | 95.51 | 9200.0 |
| 2003-05-27 18:00:00 | SPY | ETF | 95.5 | 95.53 | 95.45 | 95.47 | 3200.0 |
| 2003-05-27 18:30:00 | SPY | ETF | 95.45 | 95.48 | 95.45 | 95.45 | 6100.0 |
| 2003-05-27 19:00:00 | SPY | ETF | 95.46 | 95.46 | 95.46 | 95.46 | 200.0 |
| 2003-05-27 19:30:00 | SPY | ETF | 95.44 | 95.44 | 95.4 | 95.4 | 1400.0 |
| 2003-05-27 08:00:00 | QQQ | ETF | 27.97 | 27.97 | 27.91 | 27.92 | 47500.0 |
| 2003-05-27 08:30:00 | QQQ | ETF | 27.91 | 27.93 | 27.9 | 27.93 | 47600.0 |
| 2003-05-27 09:00:00 | QQQ | ETF | 27.93 | 27.97 | 27.91 | 27.94 | 70900.0 |
| 2003-05-27 09:30:00 | QQQ | ETF | 27.93 | 28.22 | 27.9 | 28.21 | 7956100.0 |
| 2003-05-27 10:00:00 | QQQ | ETF | 28.2 | 28.7 | 28.14 | 28.67 | 9117500.0 |
| 2003-05-27 10:30:00 | QQQ | ETF | 28.7 | 28.83 | 28.61 | 28.83 | 11064400.0 |
| 2003-05-27 11:00:00 | QQQ | ETF | 28.82 | 28.94 | 28.77 | 28.85 | 10128900.0 |
| 2003-05-27 11:30:00 | QQQ | ETF | 28.83 | 28.95 | 28.82 | 28.89 | 4400200.0 |
| 2003-05-27 12:00:00 | QQQ | ETF | 28.88 | 29.04 | 28.87 | 28.98 | 9393400.0 |
| 2003-05-27 12:30:00 | QQQ | ETF | 28.98 | 29.0 | 28.9 | 28.92 | 3638100.0 |
| 2003-05-27 13:00:00 | QQQ | ETF | 28.92 | 29.08 | 28.87 | 29.07 | 3941000.0 |
| 2003-05-27 13:30:00 | QQQ | ETF | 29.05 | 29.1 | 28.97 | 29.0 | 11479500.0 |
| 2003-05-27 14:00:00 | QQQ | ETF | 29.0 | 29.04 | 28.92 | 29.0 | 2514400.0 |
| 2003-05-27 14:30:00 | QQQ | ETF | 28.99 | 29.1 | 28.95 | 29.1 | 3546600.0 |
| 2003-05-27 15:00:00 | QQQ | ETF | 29.09 | 29.15 | 29.03 | 29.14 | 4944900.0 |
| 2003-05-27 15:30:00 | QQQ | ETF | 29.14 | 29.22 | 29.11 | 29.13 | 9240300.0 |
| 2003-05-27 16:00:00 | QQQ | ETF | 29.13 | 29.16 | 29.09 | 29.13 | 1985900.0 |
| 2003-05-27 16:30:00 | QQQ | ETF | 29.15 | 29.18 | 29.13 | 29.15 | 39500.0 |
| 2003-05-27 17:00:00 | QQQ | ETF | 29.16 | 29.19 | 29.15 | 29.18 | 21600.0 |
| 2003-05-27 17:30:00 | QQQ | ETF | 29.18 | 29.18 | 29.15 | 29.17 | 34200.0 |
| 2003-05-27 18:00:00 | QQQ | ETF | 29.17 | 29.2 | 29.16 | 29.16 | 111800.0 |
| 2003-05-27 18:30:00 | QQQ | ETF | 29.16 | 29.16 | 29.14 | 29.16 | 9400.0 |
| 2003-05-27 19:00:00 | QQQ | ETF | 29.16 | 29.17 | 29.15 | 29.15 | 2600.0 |
| 2003-05-27 19:30:00 | QQQ | ETF | 29.17 | 29.22 | 29.16 | 29.22 | 21000.0 |
| 2003-05-27 20:00:00 | QQQ | ETF | 29.22 | 29.22 | 29.22 | 29.22 | 100.0 |
| 2003-05-27 09:00:00 | IWM | ETF | 41.62 | 41.62 | 41.62 | 41.62 | 2000.0 |
> showing 50 of 736 rows — these rows as CSV