PREVIEW / etf_30min / 2001-06-06
file: by_date/etf_30min/2001/2001-06-06.parquet size: 15 KB rows: 372
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 |
|---|---|---|---|---|---|---|---|
| 2001-06-06 09:30:00 | SPY | ETF | 128.83 | 128.83 | 128.24 | 128.41 | 1841700.0 |
| 2001-06-06 10:00:00 | SPY | ETF | 128.44 | 128.8 | 127.95 | 128.0 | 1229100.0 |
| 2001-06-06 10:30:00 | SPY | ETF | 128.07 | 128.21 | 127.81 | 128.18 | 840200.0 |
| 2001-06-06 11:00:00 | SPY | ETF | 128.18 | 128.23 | 127.45 | 127.7 | 1487300.0 |
| 2001-06-06 11:30:00 | SPY | ETF | 127.74 | 127.87 | 127.52 | 127.63 | 848200.0 |
| 2001-06-06 12:00:00 | SPY | ETF | 127.62 | 127.91 | 127.57 | 127.82 | 882900.0 |
| 2001-06-06 12:30:00 | SPY | ETF | 127.82 | 128.04 | 127.8 | 127.9 | 468500.0 |
| 2001-06-06 13:00:00 | SPY | ETF | 127.87 | 128.19 | 127.76 | 127.8 | 603500.0 |
| 2001-06-06 13:30:00 | SPY | ETF | 127.76 | 128.17 | 127.6 | 128.17 | 388000.0 |
| 2001-06-06 14:00:00 | SPY | ETF | 128.11 | 128.25 | 127.84 | 127.85 | 405600.0 |
| 2001-06-06 14:30:00 | SPY | ETF | 127.86 | 127.98 | 127.62 | 127.72 | 583000.0 |
| 2001-06-06 15:00:00 | SPY | ETF | 127.76 | 127.76 | 127.36 | 127.53 | 580600.0 |
| 2001-06-06 15:30:00 | SPY | ETF | 127.51 | 127.64 | 127.41 | 127.48 | 713400.0 |
| 2001-06-06 16:00:00 | SPY | ETF | 127.53 | 127.84 | 127.43 | 127.54 | 762300.0 |
| 2001-06-06 16:30:00 | SPY | ETF | 127.72 | 127.72 | 127.72 | 127.72 | 200.0 |
| 2001-06-06 18:00:00 | SPY | ETF | 127.5 | 127.5 | 127.3 | 127.3 | 2700.0 |
| 2001-06-06 09:30:00 | QQQ | ETF | 48.08 | 48.19 | 47.7 | 48.0 | 10187700.0 |
| 2001-06-06 10:00:00 | QQQ | ETF | 48.0 | 48.49 | 47.64 | 47.7 | 7712700.0 |
| 2001-06-06 10:30:00 | QQQ | ETF | 47.74 | 48.09 | 47.6 | 47.97 | 4001900.0 |
| 2001-06-06 11:00:00 | QQQ | ETF | 47.99 | 48.05 | 47.07 | 47.22 | 9965600.0 |
| 2001-06-06 11:30:00 | QQQ | ETF | 47.26 | 47.55 | 47.08 | 47.2 | 4133200.0 |
| 2001-06-06 12:00:00 | QQQ | ETF | 47.19 | 47.52 | 47.15 | 47.45 | 1520600.0 |
| 2001-06-06 12:30:00 | QQQ | ETF | 47.49 | 47.85 | 47.41 | 47.7 | 3325500.0 |
| 2001-06-06 13:00:00 | QQQ | ETF | 47.69 | 47.94 | 47.59 | 47.65 | 2048100.0 |
| 2001-06-06 13:30:00 | QQQ | ETF | 47.65 | 47.98 | 47.51 | 47.97 | 1786100.0 |
| 2001-06-06 14:00:00 | QQQ | ETF | 47.97 | 48.14 | 47.8 | 47.96 | 2928700.0 |
| 2001-06-06 14:30:00 | QQQ | ETF | 47.9 | 47.96 | 47.58 | 47.68 | 2292600.0 |
| 2001-06-06 15:00:00 | QQQ | ETF | 47.67 | 47.75 | 47.4 | 47.55 | 2598700.0 |
| 2001-06-06 15:30:00 | QQQ | ETF | 47.53 | 47.65 | 47.34 | 47.43 | 4738300.0 |
| 2001-06-06 16:00:00 | QQQ | ETF | 47.4 | 47.6 | 47.4 | 47.52 | 1263800.0 |
| 2001-06-06 16:30:00 | QQQ | ETF | 47.52 | 47.56 | 47.49 | 47.54 | 7100.0 |
| 2001-06-06 17:00:00 | QQQ | ETF | 47.5 | 47.56 | 47.49 | 47.53 | 4600.0 |
| 2001-06-06 17:30:00 | QQQ | ETF | 47.51 | 47.58 | 47.4 | 47.45 | 21900.0 |
| 2001-06-06 18:00:00 | QQQ | ETF | 47.45 | 47.46 | 47.37 | 47.4 | 9500.0 |
| 2001-06-06 09:30:00 | IWM | ETF | 51.5 | 51.625 | 51.325 | 51.375 | 28000.0 |
| 2001-06-06 10:00:00 | IWM | ETF | 51.4 | 51.595 | 51.33 | 51.5 | 26800.0 |
| 2001-06-06 10:30:00 | IWM | ETF | 51.32 | 51.35 | 51.255 | 51.255 | 72800.0 |
| 2001-06-06 11:00:00 | IWM | ETF | 51.3 | 51.3 | 51.075 | 51.175 | 223800.0 |
| 2001-06-06 11:30:00 | IWM | ETF | 51.175 | 51.185 | 51.11 | 51.11 | 93400.0 |
| 2001-06-06 12:00:00 | IWM | ETF | 51.25 | 51.25 | 51.15 | 51.15 | 600.0 |
| 2001-06-06 12:30:00 | IWM | ETF | 51.2 | 51.295 | 51.2 | 51.275 | 9000.0 |
| 2001-06-06 13:00:00 | IWM | ETF | 51.275 | 51.275 | 51.15 | 51.15 | 182600.0 |
| 2001-06-06 13:30:00 | IWM | ETF | 51.25 | 51.25 | 51.115 | 51.175 | 49400.0 |
| 2001-06-06 14:00:00 | IWM | ETF | 51.225 | 51.395 | 51.225 | 51.345 | 122000.0 |
| 2001-06-06 14:30:00 | IWM | ETF | 51.25 | 51.295 | 51.205 | 51.275 | 13200.0 |
| 2001-06-06 15:00:00 | IWM | ETF | 51.29 | 51.29 | 51.26 | 51.26 | 400.0 |
| 2001-06-06 15:30:00 | IWM | ETF | 51.29 | 51.29 | 51.11 | 51.125 | 216000.0 |
| 2001-06-06 16:00:00 | IWM | ETF | 51.125 | 51.175 | 51.105 | 51.175 | 15200.0 |
| 2001-06-06 09:30:00 | DIA | ETF | 111.85 | 111.92 | 111.5 | 111.7 | 406100.0 |
| 2001-06-06 10:00:00 | DIA | ETF | 111.74 | 111.94 | 111.44 | 111.46 | 265600.0 |
> showing 50 of 372 rows — these rows as CSV