PREVIEW / etf_30min / 2003-10-30
file: by_date/etf_30min/2003/2003-10-30.parquet size: 26 KB rows: 824
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-10-30 08:00:00 | SPY | ETF | 105.28 | 105.4 | 105.26 | 105.39 | 14900.0 |
| 2003-10-30 08:30:00 | SPY | ETF | 105.43 | 105.97 | 105.39 | 105.83 | 786800.0 |
| 2003-10-30 09:00:00 | SPY | ETF | 105.83 | 105.96 | 105.78 | 105.83 | 218700.0 |
| 2003-10-30 09:30:00 | SPY | ETF | 105.79 | 105.83 | 105.2 | 105.29 | 6243900.0 |
| 2003-10-30 10:00:00 | SPY | ETF | 105.27 | 105.35 | 104.8 | 104.92 | 6919500.0 |
| 2003-10-30 10:30:00 | SPY | ETF | 104.92 | 105.14 | 104.9 | 105.12 | 3097200.0 |
| 2003-10-30 11:00:00 | SPY | ETF | 105.12 | 105.28 | 105.0 | 105.21 | 1897500.0 |
| 2003-10-30 11:30:00 | SPY | ETF | 105.25 | 105.27 | 105.07 | 105.09 | 797000.0 |
| 2003-10-30 12:00:00 | SPY | ETF | 105.09 | 105.24 | 105.04 | 105.18 | 491500.0 |
| 2003-10-30 12:30:00 | SPY | ETF | 105.18 | 105.64 | 105.16 | 105.56 | 1446700.0 |
| 2003-10-30 13:00:00 | SPY | ETF | 105.56 | 105.62 | 105.31 | 105.38 | 1702700.0 |
| 2003-10-30 13:30:00 | SPY | ETF | 105.41 | 105.42 | 105.18 | 105.3 | 1085400.0 |
| 2003-10-30 14:00:00 | SPY | ETF | 105.3 | 105.68 | 105.14 | 105.64 | 1619800.0 |
| 2003-10-30 14:30:00 | SPY | ETF | 105.63 | 105.63 | 105.35 | 105.45 | 1408700.0 |
| 2003-10-30 15:00:00 | SPY | ETF | 105.45 | 105.47 | 104.87 | 105.1 | 3117400.0 |
| 2003-10-30 15:30:00 | SPY | ETF | 105.08 | 105.23 | 104.89 | 105.09 | 2682700.0 |
| 2003-10-30 16:00:00 | SPY | ETF | 105.11 | 105.43 | 105.05 | 105.37 | 1287600.0 |
| 2003-10-30 16:30:00 | SPY | ETF | 105.37 | 105.4538 | 105.36 | 105.41 | 107800.0 |
| 2003-10-30 17:00:00 | SPY | ETF | 105.42 | 105.48 | 105.4 | 105.4 | 187800.0 |
| 2003-10-30 17:30:00 | SPY | ETF | 105.37 | 105.48 | 105.36 | 105.43 | 3300.0 |
| 2003-10-30 18:00:00 | SPY | ETF | 105.41 | 105.48 | 105.41 | 105.44 | 16600.0 |
| 2003-10-30 18:30:00 | SPY | ETF | 105.4 | 105.42 | 105.4 | 105.42 | 900.0 |
| 2003-10-30 19:00:00 | SPY | ETF | 105.4 | 105.4 | 105.4 | 105.4 | 6700.0 |
| 2003-10-30 19:30:00 | SPY | ETF | 105.36 | 105.39 | 105.36 | 105.39 | 1100.0 |
| 2003-10-30 08:00:00 | QQQ | ETF | 35.39 | 35.45 | 35.38 | 35.42 | 138300.0 |
| 2003-10-30 08:30:00 | QQQ | ETF | 35.44 | 35.9 | 35.44 | 35.79 | 2068800.0 |
| 2003-10-30 09:00:00 | QQQ | ETF | 35.79 | 35.86 | 35.77 | 35.8 | 469400.0 |
| 2003-10-30 09:30:00 | QQQ | ETF | 35.81 | 35.86 | 35.38 | 35.45 | 15956600.0 |
| 2003-10-30 10:00:00 | QQQ | ETF | 35.444 | 35.48 | 35.15 | 35.25 | 11147100.0 |
| 2003-10-30 10:30:00 | QQQ | ETF | 35.24 | 35.39 | 35.2125 | 35.36 | 7117600.0 |
| 2003-10-30 11:00:00 | QQQ | ETF | 35.35 | 35.46 | 35.29 | 35.43 | 4540100.0 |
| 2003-10-30 11:30:00 | QQQ | ETF | 35.43 | 35.47 | 35.34 | 35.37 | 3329300.0 |
| 2003-10-30 12:00:00 | QQQ | ETF | 35.37 | 35.43 | 35.338 | 35.42 | 2477200.0 |
| 2003-10-30 12:30:00 | QQQ | ETF | 35.42 | 35.63 | 35.4 | 35.59 | 6406000.0 |
| 2003-10-30 13:00:00 | QQQ | ETF | 35.61 | 35.63 | 35.46 | 35.49 | 3720600.0 |
| 2003-10-30 13:30:00 | QQQ | ETF | 35.49 | 35.5 | 35.41 | 35.47 | 2583700.0 |
| 2003-10-30 14:00:00 | QQQ | ETF | 35.478 | 35.638 | 35.39 | 35.62 | 4077200.0 |
| 2003-10-30 14:30:00 | QQQ | ETF | 35.616 | 35.63 | 35.487 | 35.52 | 2826000.0 |
| 2003-10-30 15:00:00 | QQQ | ETF | 35.515 | 35.53 | 35.25 | 35.36 | 7333800.0 |
| 2003-10-30 15:30:00 | QQQ | ETF | 35.35 | 35.38 | 35.14 | 35.251 | 6110200.0 |
| 2003-10-30 16:00:00 | QQQ | ETF | 35.26 | 35.4 | 35.21 | 35.36 | 2268600.0 |
| 2003-10-30 16:30:00 | QQQ | ETF | 35.37 | 35.41 | 35.36 | 35.39 | 607900.0 |
| 2003-10-30 17:00:00 | QQQ | ETF | 35.39 | 35.418 | 34.3904 | 35.39 | 114700.0 |
| 2003-10-30 17:30:00 | QQQ | ETF | 35.39 | 35.39 | 35.36 | 35.36 | 42400.0 |
| 2003-10-30 18:00:00 | QQQ | ETF | 35.36 | 35.387 | 35.36 | 35.37 | 49400.0 |
| 2003-10-30 18:30:00 | QQQ | ETF | 35.38 | 35.38 | 35.36 | 35.37 | 2500.0 |
| 2003-10-30 19:00:00 | QQQ | ETF | 35.36 | 35.36 | 35.35 | 35.35 | 3800.0 |
| 2003-10-30 19:30:00 | QQQ | ETF | 35.32 | 35.37 | 35.32 | 35.36 | 7600.0 |
| 2003-10-30 08:30:00 | IWM | ETF | 53.21 | 53.475 | 53.21 | 53.425 | 7400.0 |
| 2003-10-30 09:00:00 | IWM | ETF | 53.425 | 53.435 | 53.425 | 53.435 | 2400.0 |
> showing 50 of 824 rows — these rows as CSV