PREVIEW / etf_30min / 2003-09-04
file: by_date/etf_30min/2003/2003-09-04.parquet size: 24 KB rows: 752
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-09-04 08:00:00 | SPY | ETF | 103.06 | 103.25 | 103.06 | 103.22 | 3000.0 |
| 2003-09-04 08:30:00 | SPY | ETF | 103.12 | 103.17 | 103.01 | 103.02 | 252600.0 |
| 2003-09-04 09:00:00 | SPY | ETF | 103.06 | 103.15 | 103.06 | 103.09 | 132300.0 |
| 2003-09-04 09:30:00 | SPY | ETF | 103.1 | 103.28 | 102.93 | 103.2 | 4070200.0 |
| 2003-09-04 10:00:00 | SPY | ETF | 103.2 | 103.55 | 102.89 | 102.92 | 4334200.0 |
| 2003-09-04 10:30:00 | SPY | ETF | 102.92 | 103.12 | 102.76 | 102.92 | 2334300.0 |
| 2003-09-04 11:00:00 | SPY | ETF | 102.92 | 103.23 | 102.84 | 103.22 | 1675000.0 |
| 2003-09-04 11:30:00 | SPY | ETF | 103.22 | 103.27 | 102.97 | 103.07 | 1172600.0 |
| 2003-09-04 12:00:00 | SPY | ETF | 103.07 | 103.24 | 103.02 | 103.18 | 885400.0 |
| 2003-09-04 12:30:00 | SPY | ETF | 103.173 | 103.38 | 103.12 | 103.26 | 1119500.0 |
| 2003-09-04 13:00:00 | SPY | ETF | 103.27 | 103.33 | 103.22 | 103.26 | 474900.0 |
| 2003-09-04 13:30:00 | SPY | ETF | 103.29 | 103.53 | 103.25 | 103.45 | 1200800.0 |
| 2003-09-04 14:00:00 | SPY | ETF | 103.46 | 103.52 | 103.25 | 103.36 | 1009700.0 |
| 2003-09-04 14:30:00 | SPY | ETF | 103.36 | 103.52 | 103.22 | 103.23 | 970200.0 |
| 2003-09-04 15:00:00 | SPY | ETF | 103.23 | 103.433 | 103.21 | 103.29 | 1105300.0 |
| 2003-09-04 15:30:00 | SPY | ETF | 103.29 | 103.43 | 103.25 | 103.43 | 2312500.0 |
| 2003-09-04 16:00:00 | SPY | ETF | 103.4 | 103.63 | 103.38 | 103.62 | 1391000.0 |
| 2003-09-04 16:30:00 | SPY | ETF | 103.62 | 103.72 | 103.53 | 103.545 | 170300.0 |
| 2003-09-04 17:00:00 | SPY | ETF | 103.53 | 103.6 | 103.53 | 103.6 | 28300.0 |
| 2003-09-04 17:30:00 | SPY | ETF | 103.58 | 103.59 | 103.55 | 103.55 | 800.0 |
| 2003-09-04 18:00:00 | SPY | ETF | 103.58 | 103.65 | 103.55 | 103.6 | 6800.0 |
| 2003-09-04 18:30:00 | SPY | ETF | 103.57 | 103.57 | 103.57 | 103.57 | 100.0 |
| 2003-09-04 19:00:00 | SPY | ETF | 103.57 | 103.57 | 103.57 | 103.57 | 300.0 |
| 2003-09-04 19:30:00 | SPY | ETF | 103.56 | 103.58 | 103.56 | 103.58 | 200.0 |
| 2003-09-04 08:00:00 | QQQ | ETF | 33.86 | 33.95 | 33.83 | 33.94 | 17700.0 |
| 2003-09-04 08:30:00 | QQQ | ETF | 33.91 | 33.94 | 33.5 | 33.83 | 129500.0 |
| 2003-09-04 09:00:00 | QQQ | ETF | 33.84 | 33.87 | 33.82 | 33.83 | 165600.0 |
| 2003-09-04 09:30:00 | QQQ | ETF | 33.83 | 33.98 | 33.7 | 33.91 | 9737200.0 |
| 2003-09-04 10:00:00 | QQQ | ETF | 33.91 | 34.07 | 33.83 | 33.86 | 8193400.0 |
| 2003-09-04 10:30:00 | QQQ | ETF | 33.87 | 33.97 | 33.76 | 33.79 | 5165600.0 |
| 2003-09-04 11:00:00 | QQQ | ETF | 33.799 | 33.987 | 33.74 | 33.969 | 3782200.0 |
| 2003-09-04 11:30:00 | QQQ | ETF | 33.97 | 34.0 | 33.88 | 33.91 | 2271300.0 |
| 2003-09-04 12:00:00 | QQQ | ETF | 33.92 | 34.04 | 33.89 | 34.0 | 1889600.0 |
| 2003-09-04 12:30:00 | QQQ | ETF | 33.99 | 34.14 | 33.98 | 34.072 | 5279200.0 |
| 2003-09-04 13:00:00 | QQQ | ETF | 34.08 | 34.11 | 34.02 | 34.05 | 2312900.0 |
| 2003-09-04 13:30:00 | QQQ | ETF | 34.06 | 34.2 | 34.03 | 34.18 | 4236200.0 |
| 2003-09-04 14:00:00 | QQQ | ETF | 34.17 | 34.22 | 34.07 | 34.08 | 2662400.0 |
| 2003-09-04 14:30:00 | QQQ | ETF | 34.07 | 34.17 | 34.05 | 34.065 | 2203200.0 |
| 2003-09-04 15:00:00 | QQQ | ETF | 34.06 | 34.17 | 34.02 | 34.1 | 3183600.0 |
| 2003-09-04 15:30:00 | QQQ | ETF | 34.088 | 34.18 | 34.06 | 34.15 | 4994000.0 |
| 2003-09-04 16:00:00 | QQQ | ETF | 34.16 | 34.35 | 34.12 | 34.3 | 2497000.0 |
| 2003-09-04 16:30:00 | QQQ | ETF | 34.3 | 34.37 | 34.25 | 34.25 | 467600.0 |
| 2003-09-04 17:00:00 | QQQ | ETF | 34.25 | 34.3 | 34.25 | 34.28 | 59900.0 |
| 2003-09-04 17:30:00 | QQQ | ETF | 34.29 | 34.3 | 34.26 | 34.288 | 60700.0 |
| 2003-09-04 18:00:00 | QQQ | ETF | 34.28 | 34.33 | 34.28 | 34.32 | 83600.0 |
| 2003-09-04 18:30:00 | QQQ | ETF | 34.31 | 34.33 | 34.3 | 34.31 | 36000.0 |
| 2003-09-04 19:00:00 | QQQ | ETF | 34.31 | 34.32 | 34.29 | 34.3 | 11000.0 |
| 2003-09-04 19:30:00 | QQQ | ETF | 34.3 | 34.31 | 34.29 | 34.3 | 8500.0 |
| 2003-09-04 09:00:00 | IWM | ETF | 51.0 | 51.0 | 51.0 | 51.0 | 200.0 |
| 2003-09-04 09:30:00 | IWM | ETF | 51.075 | 51.075 | 50.805 | 51.045 | 428200.0 |
> showing 50 of 752 rows — these rows as CSV