PREVIEW / etf_30min / 2003-12-19
file: by_date/etf_30min/2003/2003-12-19.parquet size: 27 KB rows: 880
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-12-19 08:00:00 | SPY | ETF | 109.18 | 109.18 | 109.13 | 109.17 | 22600.0 |
| 2003-12-19 08:30:00 | SPY | ETF | 109.13 | 109.34 | 109.05 | 109.34 | 10000.0 |
| 2003-12-19 09:00:00 | SPY | ETF | 109.34 | 109.37 | 109.27 | 109.37 | 106000.0 |
| 2003-12-19 09:30:00 | SPY | ETF | 109.3 | 109.33 | 108.86 | 108.93 | 6541200.0 |
| 2003-12-19 10:00:00 | SPY | ETF | 108.95 | 109.17 | 108.9 | 109.14 | 2649200.0 |
| 2003-12-19 10:30:00 | SPY | ETF | 109.14 | 109.28 | 109.1 | 109.22 | 1262800.0 |
| 2003-12-19 11:00:00 | SPY | ETF | 109.21 | 109.37 | 109.1 | 109.35 | 1735500.0 |
| 2003-12-19 11:30:00 | SPY | ETF | 109.35 | 109.36 | 108.71 | 109.1 | 7188300.0 |
| 2003-12-19 12:00:00 | SPY | ETF | 109.11 | 109.16 | 108.65 | 108.89 | 2750700.0 |
| 2003-12-19 12:30:00 | SPY | ETF | 108.9 | 108.92 | 108.59 | 108.77 | 3393500.0 |
| 2003-12-19 13:00:00 | SPY | ETF | 108.77 | 108.89 | 108.7 | 108.77 | 2530000.0 |
| 2003-12-19 13:30:00 | SPY | ETF | 108.77 | 108.84 | 108.63 | 108.83 | 1089800.0 |
| 2003-12-19 14:00:00 | SPY | ETF | 108.82 | 108.84 | 108.58 | 108.8 | 1349700.0 |
| 2003-12-19 14:30:00 | SPY | ETF | 108.8 | 108.9 | 108.74 | 108.83 | 1016500.0 |
| 2003-12-19 15:00:00 | SPY | ETF | 108.84 | 109.09 | 108.8 | 109.05 | 2094400.0 |
| 2003-12-19 15:30:00 | SPY | ETF | 109.05 | 109.11 | 108.95 | 109.03 | 2022400.0 |
| 2003-12-19 16:00:00 | SPY | ETF | 109.04 | 109.12 | 108.85 | 108.92 | 2013600.0 |
| 2003-12-19 16:30:00 | SPY | ETF | 108.93 | 109.0 | 108.9 | 108.97 | 58800.0 |
| 2003-12-19 17:00:00 | SPY | ETF | 108.98 | 109.03 | 108.94 | 108.97 | 16300.0 |
| 2003-12-19 17:30:00 | SPY | ETF | 109.0 | 109.0 | 109.0 | 109.0 | 1000.0 |
| 2003-12-19 18:00:00 | SPY | ETF | 108.97 | 108.97 | 108.97 | 108.97 | 500.0 |
| 2003-12-19 19:00:00 | SPY | ETF | 108.94 | 108.94 | 108.94 | 108.94 | 100.0 |
| 2003-12-19 08:00:00 | QQQ | ETF | 35.52 | 35.54 | 35.5 | 35.52 | 34900.0 |
| 2003-12-19 08:30:00 | QQQ | ETF | 35.52 | 35.62 | 35.47 | 35.62 | 92300.0 |
| 2003-12-19 09:00:00 | QQQ | ETF | 35.63 | 35.64 | 35.57 | 35.6 | 135200.0 |
| 2003-12-19 09:30:00 | QQQ | ETF | 35.61 | 35.61 | 35.35 | 35.38 | 13140000.0 |
| 2003-12-19 10:00:00 | QQQ | ETF | 35.38 | 35.56 | 35.37 | 35.539 | 6343000.0 |
| 2003-12-19 10:30:00 | QQQ | ETF | 35.539 | 35.61 | 35.49 | 35.59 | 3761800.0 |
| 2003-12-19 11:00:00 | QQQ | ETF | 35.58 | 35.65 | 35.51 | 35.639 | 4559300.0 |
| 2003-12-19 11:30:00 | QQQ | ETF | 35.61 | 35.65 | 35.25 | 35.45 | 12187300.0 |
| 2003-12-19 12:00:00 | QQQ | ETF | 35.45 | 35.47 | 35.297 | 35.34 | 8985700.0 |
| 2003-12-19 12:30:00 | QQQ | ETF | 35.337 | 35.35 | 35.2 | 35.278 | 8756900.0 |
| 2003-12-19 13:00:00 | QQQ | ETF | 35.274 | 35.35 | 35.22 | 35.31 | 4021300.0 |
| 2003-12-19 13:30:00 | QQQ | ETF | 35.31 | 35.35 | 35.25 | 35.35 | 2528000.0 |
| 2003-12-19 14:00:00 | QQQ | ETF | 35.35 | 35.36 | 35.26 | 35.342 | 2372300.0 |
| 2003-12-19 14:30:00 | QQQ | ETF | 35.344 | 35.38 | 35.3 | 35.35 | 2841300.0 |
| 2003-12-19 15:00:00 | QQQ | ETF | 35.341 | 35.48 | 35.338 | 35.46 | 4621900.0 |
| 2003-12-19 15:30:00 | QQQ | ETF | 35.463 | 35.49 | 35.41 | 35.45 | 5538100.0 |
| 2003-12-19 16:00:00 | QQQ | ETF | 35.45 | 35.48 | 35.412 | 35.44 | 4111700.0 |
| 2003-12-19 16:30:00 | QQQ | ETF | 35.46 | 35.46 | 35.4 | 35.42 | 105500.0 |
| 2003-12-19 17:00:00 | QQQ | ETF | 35.43 | 35.46 | 35.42 | 35.46 | 45700.0 |
| 2003-12-19 17:30:00 | QQQ | ETF | 35.46 | 35.47 | 35.46 | 35.46 | 9100.0 |
| 2003-12-19 18:00:00 | QQQ | ETF | 35.45 | 35.45 | 35.41 | 35.41 | 5600.0 |
| 2003-12-19 18:30:00 | QQQ | ETF | 35.45 | 35.45 | 35.45 | 35.45 | 1900.0 |
| 2003-12-19 08:30:00 | IWM | ETF | 54.375 | 54.375 | 54.375 | 54.375 | 2000.0 |
| 2003-12-19 09:00:00 | IWM | ETF | 54.44 | 54.44 | 54.44 | 54.44 | 400.0 |
| 2003-12-19 09:30:00 | IWM | ETF | 54.4 | 54.4 | 53.835 | 53.87 | 718400.0 |
| 2003-12-19 10:00:00 | IWM | ETF | 53.86 | 54.2875 | 53.835 | 54.225 | 332800.0 |
| 2003-12-19 10:30:00 | IWM | ETF | 54.29 | 54.35 | 54.215 | 54.3 | 405600.0 |
| 2003-12-19 11:00:00 | IWM | ETF | 54.3 | 54.4 | 54.229 | 54.4 | 165400.0 |
> showing 50 of 880 rows — these rows as CSV