PREVIEW / etf_30min / 2003-11-19
file: by_date/etf_30min/2003/2003-11-19.parquet size: 27 KB rows: 841
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-11-19 08:00:00 | SPY | ETF | 104.05 | 104.18 | 104.05 | 104.12 | 21200.0 |
| 2003-11-19 08:30:00 | SPY | ETF | 104.16 | 104.2 | 104.07 | 104.08 | 102800.0 |
| 2003-11-19 09:00:00 | SPY | ETF | 104.07 | 104.14 | 104.04 | 104.04 | 10500.0 |
| 2003-11-19 09:30:00 | SPY | ETF | 104.03 | 104.27 | 103.92 | 104.0 | 4662900.0 |
| 2003-11-19 10:00:00 | SPY | ETF | 104.01 | 104.42 | 103.95 | 104.37 | 3207500.0 |
| 2003-11-19 10:30:00 | SPY | ETF | 104.37 | 104.49 | 104.27 | 104.38 | 1667800.0 |
| 2003-11-19 11:00:00 | SPY | ETF | 104.38 | 104.58 | 104.31 | 104.47 | 1784200.0 |
| 2003-11-19 11:30:00 | SPY | ETF | 104.45 | 104.49 | 104.27 | 104.31 | 1089500.0 |
| 2003-11-19 12:00:00 | SPY | ETF | 104.31 | 104.42 | 104.23 | 104.38 | 748200.0 |
| 2003-11-19 12:30:00 | SPY | ETF | 104.4 | 104.51 | 104.34 | 104.48 | 607700.0 |
| 2003-11-19 13:00:00 | SPY | ETF | 104.48 | 104.55 | 104.25 | 104.54 | 848600.0 |
| 2003-11-19 13:30:00 | SPY | ETF | 104.55 | 104.62 | 104.43 | 104.47 | 1213200.0 |
| 2003-11-19 14:00:00 | SPY | ETF | 104.48 | 104.97 | 104.48 | 104.95 | 3164500.0 |
| 2003-11-19 14:30:00 | SPY | ETF | 104.95 | 104.97 | 104.71 | 104.89 | 1620300.0 |
| 2003-11-19 15:00:00 | SPY | ETF | 104.89 | 105.01 | 104.72 | 104.91 | 1219400.0 |
| 2003-11-19 15:30:00 | SPY | ETF | 104.91 | 104.95 | 104.69 | 104.85 | 1873700.0 |
| 2003-11-19 16:00:00 | SPY | ETF | 104.86 | 104.96 | 104.72 | 104.72 | 2030000.0 |
| 2003-11-19 16:30:00 | SPY | ETF | 104.72 | 104.84 | 104.72 | 104.8 | 140100.0 |
| 2003-11-19 17:00:00 | SPY | ETF | 104.8 | 104.87 | 104.8 | 104.87 | 16900.0 |
| 2003-11-19 17:30:00 | SPY | ETF | 104.89 | 104.89 | 104.86 | 104.86 | 600.0 |
| 2003-11-19 18:00:00 | SPY | ETF | 104.84 | 104.84 | 104.8 | 104.84 | 1700.0 |
| 2003-11-19 18:30:00 | SPY | ETF | 104.89 | 104.89 | 104.89 | 104.89 | 8100.0 |
| 2003-11-19 19:00:00 | SPY | ETF | 104.87 | 104.88 | 104.83 | 104.86 | 2000.0 |
| 2003-11-19 19:30:00 | SPY | ETF | 104.89 | 104.89 | 104.89 | 104.89 | 1800.0 |
| 2003-11-19 08:00:00 | QQQ | ETF | 33.95 | 33.98 | 33.92 | 33.98 | 52300.0 |
| 2003-11-19 08:30:00 | QQQ | ETF | 33.98 | 34.05 | 33.98 | 34.01 | 155900.0 |
| 2003-11-19 09:00:00 | QQQ | ETF | 34.01 | 34.03 | 33.99 | 34.0 | 141500.0 |
| 2003-11-19 09:30:00 | QQQ | ETF | 34.01 | 34.16 | 33.88 | 33.94 | 12946200.0 |
| 2003-11-19 10:00:00 | QQQ | ETF | 33.92 | 34.168 | 33.886 | 34.13 | 11459800.0 |
| 2003-11-19 10:30:00 | QQQ | ETF | 34.13 | 34.23 | 34.07 | 34.12 | 5601800.0 |
| 2003-11-19 11:00:00 | QQQ | ETF | 34.121 | 34.23 | 34.06 | 34.17 | 3817100.0 |
| 2003-11-19 11:30:00 | QQQ | ETF | 34.17 | 34.19 | 34.06 | 34.08 | 3315800.0 |
| 2003-11-19 12:00:00 | QQQ | ETF | 34.07 | 34.15 | 34.03 | 34.11 | 3819900.0 |
| 2003-11-19 12:30:00 | QQQ | ETF | 34.11 | 34.19 | 34.07 | 34.14 | 2020900.0 |
| 2003-11-19 13:00:00 | QQQ | ETF | 34.147 | 34.181 | 34.04 | 34.18 | 2868300.0 |
| 2003-11-19 13:30:00 | QQQ | ETF | 34.19 | 34.27 | 34.11 | 34.15 | 5437300.0 |
| 2003-11-19 14:00:00 | QQQ | ETF | 34.15 | 34.4 | 34.13 | 34.38 | 5831000.0 |
| 2003-11-19 14:30:00 | QQQ | ETF | 34.38 | 34.4 | 34.26 | 34.33 | 4117200.0 |
| 2003-11-19 15:00:00 | QQQ | ETF | 34.33 | 34.39 | 34.24 | 34.341 | 5887400.0 |
| 2003-11-19 15:30:00 | QQQ | ETF | 34.341 | 34.343 | 34.21 | 34.3 | 6598900.0 |
| 2003-11-19 16:00:00 | QQQ | ETF | 34.3 | 34.37 | 34.17 | 34.23 | 2214300.0 |
| 2003-11-19 16:30:00 | QQQ | ETF | 34.24 | 34.27 | 34.2 | 34.25 | 325300.0 |
| 2003-11-19 17:00:00 | QQQ | ETF | 34.24 | 34.26 | 34.223 | 34.26 | 31900.0 |
| 2003-11-19 17:30:00 | QQQ | ETF | 34.24 | 34.26 | 34.23 | 34.24 | 20600.0 |
| 2003-11-19 18:00:00 | QQQ | ETF | 34.26 | 34.27 | 34.24 | 34.27 | 37000.0 |
| 2003-11-19 18:30:00 | QQQ | ETF | 34.26 | 34.27 | 34.25 | 34.25 | 32600.0 |
| 2003-11-19 19:00:00 | QQQ | ETF | 34.25 | 34.27 | 34.24 | 34.26 | 17300.0 |
| 2003-11-19 19:30:00 | QQQ | ETF | 34.25 | 34.25 | 34.22 | 34.24 | 121400.0 |
| 2003-11-19 08:00:00 | IWM | ETF | 52.0 | 52.0 | 52.0 | 52.0 | 48000.0 |
| 2003-11-19 08:30:00 | IWM | ETF | 52.12 | 52.12 | 52.115 | 52.115 | 2000.0 |
> showing 50 of 841 rows — these rows as CSV