PREVIEW / etf_30min / 2002-09-10
file: by_date/etf_30min/2002/2002-09-10.parquet size: 19 KB rows: 553
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 |
|---|---|---|---|---|---|---|---|
| 2002-09-10 09:30:00 | SPY | ETF | 91.14 | 91.2 | 90.62 | 90.69 | 4451200.0 |
| 2002-09-10 10:00:00 | SPY | ETF | 90.72 | 91.45 | 90.69 | 91.39 | 3217100.0 |
| 2002-09-10 10:30:00 | SPY | ETF | 91.36 | 91.61 | 91.29 | 91.42 | 4756500.0 |
| 2002-09-10 11:00:00 | SPY | ETF | 91.41 | 91.49 | 91.16 | 91.24 | 1385300.0 |
| 2002-09-10 11:30:00 | SPY | ETF | 91.26 | 91.32 | 90.92 | 91.0 | 2196500.0 |
| 2002-09-10 12:00:00 | SPY | ETF | 90.96 | 91.04 | 90.66 | 90.99 | 2399800.0 |
| 2002-09-10 12:30:00 | SPY | ETF | 91.01 | 91.13 | 90.85 | 91.1 | 1222700.0 |
| 2002-09-10 13:00:00 | SPY | ETF | 91.09 | 91.23 | 91.0 | 91.15 | 1536000.0 |
| 2002-09-10 13:30:00 | SPY | ETF | 91.15 | 91.19 | 90.8 | 90.91 | 1737200.0 |
| 2002-09-10 14:00:00 | SPY | ETF | 90.91 | 90.99 | 90.6 | 90.62 | 3141500.0 |
| 2002-09-10 14:30:00 | SPY | ETF | 90.62 | 91.4 | 90.56 | 91.21 | 4276000.0 |
| 2002-09-10 15:00:00 | SPY | ETF | 91.23 | 91.5 | 91.12 | 91.24 | 1455600.0 |
| 2002-09-10 15:30:00 | SPY | ETF | 91.23 | 91.59 | 91.05 | 91.55 | 3391000.0 |
| 2002-09-10 16:00:00 | SPY | ETF | 91.51 | 91.78 | 91.48 | 91.7 | 1155700.0 |
| 2002-09-10 09:30:00 | QQQ | ETF | 23.23 | 23.38 | 23.1 | 23.23 | 9766100.0 |
| 2002-09-10 10:00:00 | QQQ | ETF | 23.22 | 23.55 | 23.2 | 23.5 | 6060200.0 |
| 2002-09-10 10:30:00 | QQQ | ETF | 23.53 | 23.67 | 23.47 | 23.63 | 6496300.0 |
| 2002-09-10 11:00:00 | QQQ | ETF | 23.63 | 23.63 | 23.39 | 23.44 | 5063800.0 |
| 2002-09-10 11:30:00 | QQQ | ETF | 23.45 | 23.47 | 23.2 | 23.24 | 4423200.0 |
| 2002-09-10 12:00:00 | QQQ | ETF | 23.24 | 23.39 | 23.15 | 23.32 | 4493300.0 |
| 2002-09-10 12:30:00 | QQQ | ETF | 23.32 | 23.4 | 23.25 | 23.4 | 2309100.0 |
| 2002-09-10 13:00:00 | QQQ | ETF | 23.37 | 23.42 | 23.29 | 23.35 | 1926000.0 |
| 2002-09-10 13:30:00 | QQQ | ETF | 23.36 | 23.39 | 23.2 | 23.31 | 3214700.0 |
| 2002-09-10 14:00:00 | QQQ | ETF | 23.31 | 23.33 | 23.12 | 23.14 | 3853800.0 |
| 2002-09-10 14:30:00 | QQQ | ETF | 23.14 | 23.47 | 23.1 | 23.4 | 8173700.0 |
| 2002-09-10 15:00:00 | QQQ | ETF | 23.4 | 23.52 | 23.31 | 23.37 | 4329000.0 |
| 2002-09-10 15:30:00 | QQQ | ETF | 23.38 | 23.57 | 23.3 | 23.54 | 7574600.0 |
| 2002-09-10 16:00:00 | QQQ | ETF | 23.54 | 23.65 | 23.53 | 23.65 | 1493000.0 |
| 2002-09-10 09:30:00 | IWM | ETF | 39.325 | 39.325 | 39.075 | 39.075 | 90400.0 |
| 2002-09-10 10:00:00 | IWM | ETF | 39.1 | 39.325 | 39.1 | 39.325 | 171200.0 |
| 2002-09-10 10:30:00 | IWM | ETF | 39.33 | 39.445 | 39.295 | 39.39 | 53000.0 |
| 2002-09-10 11:00:00 | IWM | ETF | 39.375 | 39.375 | 39.2 | 39.2 | 166400.0 |
| 2002-09-10 11:30:00 | IWM | ETF | 39.255 | 39.255 | 39.075 | 39.09 | 94400.0 |
| 2002-09-10 12:00:00 | IWM | ETF | 39.065 | 39.125 | 39.005 | 39.125 | 32800.0 |
| 2002-09-10 12:30:00 | IWM | ETF | 39.125 | 39.135 | 39.075 | 39.075 | 4000.0 |
| 2002-09-10 13:00:00 | IWM | ETF | 39.135 | 39.135 | 39.095 | 39.095 | 400.0 |
| 2002-09-10 13:30:00 | IWM | ETF | 39.035 | 39.035 | 38.875 | 38.995 | 31800.0 |
| 2002-09-10 14:00:00 | IWM | ETF | 38.915 | 38.93 | 38.875 | 38.875 | 154600.0 |
| 2002-09-10 14:30:00 | IWM | ETF | 38.795 | 39.245 | 38.795 | 39.14 | 228600.0 |
| 2002-09-10 15:00:00 | IWM | ETF | 39.17 | 39.23 | 39.04 | 39.13 | 68200.0 |
| 2002-09-10 15:30:00 | IWM | ETF | 39.09 | 39.395 | 39.09 | 39.395 | 392600.0 |
| 2002-09-10 16:00:00 | IWM | ETF | 39.395 | 39.395 | 39.275 | 39.275 | 45400.0 |
| 2002-09-10 09:30:00 | DIA | ETF | 85.77 | 85.78 | 85.18 | 85.31 | 1182200.0 |
| 2002-09-10 10:00:00 | DIA | ETF | 85.29 | 85.89 | 85.23 | 85.78 | 849700.0 |
| 2002-09-10 10:30:00 | DIA | ETF | 85.87 | 86.15 | 85.75 | 85.95 | 788100.0 |
| 2002-09-10 11:00:00 | DIA | ETF | 85.96 | 86.05 | 85.72 | 85.88 | 522800.0 |
| 2002-09-10 11:30:00 | DIA | ETF | 85.88 | 85.9 | 85.54 | 85.59 | 613200.0 |
| 2002-09-10 12:00:00 | DIA | ETF | 85.59 | 85.63 | 85.21 | 85.63 | 545600.0 |
| 2002-09-10 12:30:00 | DIA | ETF | 85.6 | 85.69 | 85.35 | 85.63 | 393200.0 |
| 2002-09-10 13:00:00 | DIA | ETF | 85.67 | 85.79 | 85.53 | 85.69 | 325800.0 |
> showing 50 of 553 rows — these rows as CSV