PREVIEW / etf_30min / 2004-02-09
file: by_date/etf_30min/2004/2004-02-09.parquet size: 32 KB rows: 1,029
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 |
|---|---|---|---|---|---|---|---|
| 2004-02-09 08:00:00 | SPY | ETF | 114.72 | 114.72 | 114.6 | 114.68 | 6800.0 |
| 2004-02-09 08:30:00 | SPY | ETF | 114.62 | 114.62 | 114.62 | 114.62 | 2000.0 |
| 2004-02-09 09:00:00 | SPY | ETF | 114.61 | 114.7 | 114.61 | 114.67 | 21900.0 |
| 2004-02-09 09:30:00 | SPY | ETF | 114.67 | 114.69 | 114.43 | 114.58 | 3133800.0 |
| 2004-02-09 10:00:00 | SPY | ETF | 114.57 | 114.71 | 114.42 | 114.6 | 1391800.0 |
| 2004-02-09 10:30:00 | SPY | ETF | 114.58 | 114.68 | 114.49 | 114.55 | 825700.0 |
| 2004-02-09 11:00:00 | SPY | ETF | 114.56 | 114.6 | 114.45 | 114.55 | 970900.0 |
| 2004-02-09 11:30:00 | SPY | ETF | 114.55 | 114.69 | 114.55 | 114.65 | 1397000.0 |
| 2004-02-09 12:00:00 | SPY | ETF | 114.65 | 114.76 | 114.5 | 114.52 | 1797800.0 |
| 2004-02-09 12:30:00 | SPY | ETF | 114.52 | 114.67 | 114.52 | 114.6 | 812300.0 |
| 2004-02-09 13:00:00 | SPY | ETF | 114.6 | 114.84 | 114.59 | 114.77 | 1118000.0 |
| 2004-02-09 13:30:00 | SPY | ETF | 114.77 | 114.87 | 114.73 | 114.75 | 857100.0 |
| 2004-02-09 14:00:00 | SPY | ETF | 114.75 | 114.78 | 114.57 | 114.64 | 876500.0 |
| 2004-02-09 14:30:00 | SPY | ETF | 114.62 | 114.68 | 114.37 | 114.41 | 1411800.0 |
| 2004-02-09 15:00:00 | SPY | ETF | 114.41 | 114.46 | 114.29 | 114.33 | 3708500.0 |
| 2004-02-09 15:30:00 | SPY | ETF | 114.33 | 114.49 | 114.29 | 114.34 | 3543200.0 |
| 2004-02-09 16:00:00 | SPY | ETF | 114.34 | 114.53 | 114.32 | 114.49 | 1837300.0 |
| 2004-02-09 16:30:00 | SPY | ETF | 114.49 | 114.51 | 114.46 | 114.49 | 14900.0 |
| 2004-02-09 17:00:00 | SPY | ETF | 114.49 | 114.49 | 114.49 | 114.49 | 2000.0 |
| 2004-02-09 17:30:00 | SPY | ETF | 114.47 | 114.49 | 114.47 | 114.49 | 4400.0 |
| 2004-02-09 18:00:00 | SPY | ETF | 114.49 | 114.49 | 114.44 | 114.44 | 4300.0 |
| 2004-02-09 18:30:00 | SPY | ETF | 114.45 | 114.45 | 114.45 | 114.45 | 100.0 |
| 2004-02-09 19:00:00 | SPY | ETF | 114.5 | 114.5 | 114.45 | 114.45 | 300.0 |
| 2004-02-09 20:00:00 | SPY | ETF | 114.48 | 114.48 | 114.48 | 114.48 | 100.0 |
| 2004-02-09 08:00:00 | QQQ | ETF | 37.35 | 37.38 | 37.32 | 37.37 | 79900.0 |
| 2004-02-09 08:30:00 | QQQ | ETF | 37.36 | 37.39 | 37.35 | 37.36 | 86300.0 |
| 2004-02-09 09:00:00 | QQQ | ETF | 37.36 | 37.38 | 37.34 | 37.34 | 92200.0 |
| 2004-02-09 09:30:00 | QQQ | ETF | 37.34 | 37.34 | 37.14 | 37.24 | 8123200.0 |
| 2004-02-09 10:00:00 | QQQ | ETF | 37.23 | 37.29 | 37.124 | 37.26 | 6277500.0 |
| 2004-02-09 10:30:00 | QQQ | ETF | 37.27 | 37.32 | 37.22 | 37.25 | 3043800.0 |
| 2004-02-09 11:00:00 | QQQ | ETF | 37.25 | 37.28 | 37.2 | 37.25 | 2053400.0 |
| 2004-02-09 11:30:00 | QQQ | ETF | 37.24 | 37.35 | 37.24 | 37.29 | 2530200.0 |
| 2004-02-09 12:00:00 | QQQ | ETF | 37.29 | 37.34 | 37.25 | 37.26 | 2296200.0 |
| 2004-02-09 12:30:00 | QQQ | ETF | 37.26 | 37.29 | 37.23 | 37.25 | 2658900.0 |
| 2004-02-09 13:00:00 | QQQ | ETF | 37.26 | 37.35 | 37.25 | 37.325 | 1792400.0 |
| 2004-02-09 13:30:00 | QQQ | ETF | 37.33 | 37.38 | 37.28 | 37.31 | 3181100.0 |
| 2004-02-09 14:00:00 | QQQ | ETF | 37.3 | 37.34 | 37.2 | 37.23 | 3707900.0 |
| 2004-02-09 14:30:00 | QQQ | ETF | 37.23 | 37.27 | 37.13 | 37.16 | 3932900.0 |
| 2004-02-09 15:00:00 | QQQ | ETF | 37.16 | 37.18 | 37.07 | 37.097 | 5924800.0 |
| 2004-02-09 15:30:00 | QQQ | ETF | 37.097 | 37.19 | 37.05 | 37.1 | 8089700.0 |
| 2004-02-09 16:00:00 | QQQ | ETF | 37.09 | 37.15 | 37.05 | 37.1 | 2425400.0 |
| 2004-02-09 16:30:00 | QQQ | ETF | 37.1 | 37.14 | 37.09 | 37.13 | 53000.0 |
| 2004-02-09 17:00:00 | QQQ | ETF | 37.13 | 37.18 | 37.13 | 37.169 | 449400.0 |
| 2004-02-09 17:30:00 | QQQ | ETF | 37.18 | 37.2 | 37.151 | 37.2 | 34300.0 |
| 2004-02-09 18:00:00 | QQQ | ETF | 37.18 | 37.2 | 37.17 | 37.18 | 35000.0 |
| 2004-02-09 18:30:00 | QQQ | ETF | 37.18 | 37.18 | 37.18 | 37.18 | 5000.0 |
| 2004-02-09 19:00:00 | QQQ | ETF | 37.15 | 37.2 | 37.15 | 37.2 | 23300.0 |
| 2004-02-09 19:30:00 | QQQ | ETF | 37.17 | 37.2 | 37.17 | 37.19 | 9700.0 |
| 2004-02-09 09:30:00 | IWM | ETF | 58.3955 | 58.415 | 58.095 | 58.31 | 1286200.0 |
| 2004-02-09 10:00:00 | IWM | ETF | 58.2905 | 58.4 | 58.17 | 58.355 | 476400.0 |
> showing 50 of 1,029 rows — these rows as CSV