PREVIEW / etf_30min / 2006-06-09
file: by_date/etf_30min/2006/2006-06-09.parquet size: 67 KB rows: 2,346
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 |
|---|---|---|---|---|---|---|---|
| 2006-06-09 04:30:00 | SPY | ETF | 126.15 | 126.15 | 126.15 | 126.15 | 3000.0 |
| 2006-06-09 05:30:00 | SPY | ETF | 126.01 | 126.13 | 126.01 | 126.11 | 50000.0 |
| 2006-06-09 06:00:00 | SPY | ETF | 126.06 | 126.16 | 126.06 | 126.16 | 75000.0 |
| 2006-06-09 06:30:00 | SPY | ETF | 126.15 | 126.16 | 126.15 | 126.16 | 30000.0 |
| 2006-06-09 07:00:00 | SPY | ETF | 126.26 | 126.43 | 126.26 | 126.35 | 12400.0 |
| 2006-06-09 07:30:00 | SPY | ETF | 126.3 | 126.34 | 126.3 | 126.33 | 15200.0 |
| 2006-06-09 08:00:00 | SPY | ETF | 126.3 | 126.49 | 126.25 | 126.33 | 826200.0 |
| 2006-06-09 08:30:00 | SPY | ETF | 126.33 | 126.33 | 126.05 | 126.24 | 1566400.0 |
| 2006-06-09 09:00:00 | SPY | ETF | 126.23 | 126.38 | 125.76 | 126.35 | 513700.0 |
| 2006-06-09 09:30:00 | SPY | ETF | 126.36 | 126.61 | 125.91 | 126.48 | 11939000.0 |
| 2006-06-09 10:00:00 | SPY | ETF | 126.47 | 126.58 | 126.22 | 126.54 | 5939000.0 |
| 2006-06-09 10:30:00 | SPY | ETF | 126.5 | 126.67 | 126.13 | 126.18 | 9999300.0 |
| 2006-06-09 11:00:00 | SPY | ETF | 126.18 | 126.59 | 126.1 | 126.41 | 4487700.0 |
| 2006-06-09 11:30:00 | SPY | ETF | 126.41 | 126.52 | 125.75 | 125.92 | 9211700.0 |
| 2006-06-09 12:00:00 | SPY | ETF | 125.92 | 126.16 | 125.81 | 125.85 | 4154200.0 |
| 2006-06-09 12:30:00 | SPY | ETF | 125.84 | 126.09 | 125.6 | 125.68 | 5990300.0 |
| 2006-06-09 13:00:00 | SPY | ETF | 125.69 | 125.73 | 125.34 | 125.51 | 7826900.0 |
| 2006-06-09 13:30:00 | SPY | ETF | 125.53 | 125.88 | 125.46 | 125.68 | 4351300.0 |
| 2006-06-09 14:00:00 | SPY | ETF | 125.68 | 126.14 | 125.65 | 126.09 | 4779900.0 |
| 2006-06-09 14:30:00 | SPY | ETF | 126.09 | 126.34 | 126.02 | 126.11 | 4758500.0 |
| 2006-06-09 15:00:00 | SPY | ETF | 126.1 | 126.28 | 125.8 | 126.01 | 3385500.0 |
| 2006-06-09 15:30:00 | SPY | ETF | 126.0 | 126.96 | 125.51 | 125.52 | 6995300.0 |
| 2006-06-09 16:00:00 | SPY | ETF | 125.51 | 125.62 | 125.3 | 125.32 | 5675800.0 |
| 2006-06-09 16:30:00 | SPY | ETF | 125.32 | 125.62 | 125.25 | 125.28 | 505900.0 |
| 2006-06-09 17:00:00 | SPY | ETF | 125.28 | 125.3 | 125.28 | 125.3 | 4700.0 |
| 2006-06-09 17:30:00 | SPY | ETF | 125.35 | 125.35 | 125.35 | 125.35 | 100.0 |
| 2006-06-09 18:00:00 | SPY | ETF | 125.3 | 125.37 | 125.3 | 125.35 | 2600.0 |
| 2006-06-09 18:30:00 | SPY | ETF | 125.35 | 125.37 | 125.33 | 125.33 | 1900.0 |
| 2006-06-09 19:30:00 | SPY | ETF | 125.37 | 125.37 | 125.37 | 125.37 | 900.0 |
| 2006-06-09 09:30:00 | QQQ | ETF | 38.54 | 38.72 | 38.49 | 38.62 | 25693800.0 |
| 2006-06-09 10:00:00 | QQQ | ETF | 38.61 | 38.68 | 38.47 | 38.68 | 12292600.0 |
| 2006-06-09 10:30:00 | QQQ | ETF | 38.68 | 39.7 | 38.51 | 38.52 | 9885600.0 |
| 2006-06-09 11:00:00 | QQQ | ETF | 38.53 | 38.7 | 38.48 | 38.58 | 6988600.0 |
| 2006-06-09 11:30:00 | QQQ | ETF | 38.58 | 38.66 | 38.37 | 38.42 | 12840100.0 |
| 2006-06-09 12:00:00 | QQQ | ETF | 38.42 | 38.5 | 38.33 | 38.38 | 6030800.0 |
| 2006-06-09 12:30:00 | QQQ | ETF | 38.38 | 38.46 | 38.26 | 38.29 | 6013500.0 |
| 2006-06-09 13:00:00 | QQQ | ETF | 38.29 | 38.32 | 38.11 | 38.16 | 12447900.0 |
| 2006-06-09 13:30:00 | QQQ | ETF | 38.17 | 38.32 | 38.12 | 38.27 | 7571800.0 |
| 2006-06-09 14:00:00 | QQQ | ETF | 38.27 | 38.42 | 38.26 | 38.38 | 5704000.0 |
| 2006-06-09 14:30:00 | QQQ | ETF | 38.38 | 38.46 | 38.33 | 38.35 | 5001800.0 |
| 2006-06-09 15:00:00 | QQQ | ETF | 38.36 | 38.38 | 38.21 | 38.31 | 6236000.0 |
| 2006-06-09 15:30:00 | QQQ | ETF | 38.31 | 38.33 | 38.12 | 38.15 | 10591900.0 |
| 2006-06-09 08:00:00 | IWM | ETF | 70.53 | 70.64 | 70.46 | 70.53 | 95200.0 |
| 2006-06-09 08:30:00 | IWM | ETF | 70.5 | 70.51 | 70.32 | 70.49 | 449100.0 |
| 2006-06-09 09:00:00 | IWM | ETF | 70.5 | 70.55 | 70.17 | 70.55 | 226400.0 |
| 2006-06-09 09:30:00 | IWM | ETF | 70.55 | 70.88 | 70.23 | 70.83 | 10567500.0 |
| 2006-06-09 10:00:00 | IWM | ETF | 70.82 | 70.97 | 70.58 | 70.87 | 6583900.0 |
| 2006-06-09 10:30:00 | IWM | ETF | 70.87 | 71.1 | 70.56 | 70.57 | 3695300.0 |
| 2006-06-09 11:00:00 | IWM | ETF | 70.56 | 70.84 | 70.51 | 70.74 | 1582500.0 |
| 2006-06-09 11:30:00 | IWM | ETF | 70.74 | 70.88 | 70.04 | 70.26 | 5292900.0 |
> showing 50 of 2,346 rows — these rows as CSV