PREVIEW / etf_30min / 2005-09-16
file: by_date/etf_30min/2005/2005-09-16.parquet size: 46 KB rows: 1,668
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-16 07:00:00 | SPY | ETF | 123.1 | 123.11 | 123.05 | 123.08 | 281900.0 |
| 2005-09-16 07:30:00 | SPY | ETF | 123.13 | 123.28 | 123.13 | 123.18 | 222600.0 |
| 2005-09-16 08:00:00 | SPY | ETF | 123.08 | 123.26 | 123.06 | 123.14 | 1149500.0 |
| 2005-09-16 08:30:00 | SPY | ETF | 123.13 | 123.15 | 123.05 | 123.12 | 172200.0 |
| 2005-09-16 09:00:00 | SPY | ETF | 123.13 | 123.33 | 123.13 | 123.28 | 1262600.0 |
| 2005-09-16 09:30:00 | SPY | ETF | 123.28 | 123.31 | 122.9 | 123.06 | 15148800.0 |
| 2005-09-16 10:00:00 | SPY | ETF | 123.06 | 123.37 | 123.01 | 123.17 | 7936200.0 |
| 2005-09-16 10:30:00 | SPY | ETF | 123.17 | 123.26 | 123.08 | 123.14 | 4901800.0 |
| 2005-09-16 11:00:00 | SPY | ETF | 123.14 | 123.2 | 122.99 | 123.162 | 4516000.0 |
| 2005-09-16 11:30:00 | SPY | ETF | 123.16 | 123.2 | 123.04 | 123.07 | 1706100.0 |
| 2005-09-16 12:00:00 | SPY | ETF | 123.07 | 123.195 | 122.87 | 122.98 | 2302200.0 |
| 2005-09-16 12:30:00 | SPY | ETF | 122.98 | 123.21 | 122.95 | 123.14 | 2658500.0 |
| 2005-09-16 13:00:00 | SPY | ETF | 123.14 | 123.2 | 123.08 | 123.15 | 1843800.0 |
| 2005-09-16 13:30:00 | SPY | ETF | 123.14 | 123.3 | 123.11 | 123.25 | 2466600.0 |
| 2005-09-16 14:00:00 | SPY | ETF | 123.26 | 123.42 | 123.21 | 123.27 | 2757900.0 |
| 2005-09-16 14:30:00 | SPY | ETF | 123.27 | 123.51 | 123.23 | 123.4688 | 3902200.0 |
| 2005-09-16 15:00:00 | SPY | ETF | 123.47 | 123.67 | 123.43 | 123.61 | 6586100.0 |
| 2005-09-16 15:30:00 | SPY | ETF | 123.61 | 123.74 | 123.56 | 123.7 | 5486900.0 |
| 2005-09-16 16:00:00 | SPY | ETF | 123.66 | 123.7 | 123.5 | 123.56 | 2028000.0 |
| 2005-09-16 16:30:00 | SPY | ETF | 123.56 | 123.6 | 123.5 | 123.55 | 2614900.0 |
| 2005-09-16 17:00:00 | SPY | ETF | 123.55 | 123.6 | 123.53 | 123.55 | 18500.0 |
| 2005-09-16 17:30:00 | SPY | ETF | 123.55 | 123.59 | 123.51 | 123.51 | 1565500.0 |
| 2005-09-16 18:00:00 | SPY | ETF | 123.57 | 123.57 | 123.56 | 123.56 | 1700.0 |
| 2005-09-16 19:00:00 | SPY | ETF | 123.54 | 123.6 | 123.54 | 123.6 | 5300.0 |
| 2005-09-16 19:30:00 | SPY | ETF | 123.6 | 123.62 | 123.54 | 123.54 | 4900.0 |
| 2005-09-16 09:30:00 | QQQ | ETF | 39.25 | 39.29 | 39.15 | 39.2 | 9289900.0 |
| 2005-09-16 10:00:00 | QQQ | ETF | 39.21 | 39.29 | 39.17 | 39.22 | 6953900.0 |
| 2005-09-16 10:30:00 | QQQ | ETF | 39.22 | 39.24 | 39.17 | 39.18 | 2562100.0 |
| 2005-09-16 11:00:00 | QQQ | ETF | 39.19 | 39.2 | 39.11 | 39.17 | 4451000.0 |
| 2005-09-16 11:30:00 | QQQ | ETF | 39.17 | 39.21 | 39.12 | 39.18 | 3900400.0 |
| 2005-09-16 12:00:00 | QQQ | ETF | 39.18 | 39.2 | 39.11 | 39.14 | 4117200.0 |
| 2005-09-16 12:30:00 | QQQ | ETF | 39.15 | 39.21 | 39.13 | 39.2 | 3582300.0 |
| 2005-09-16 13:00:00 | QQQ | ETF | 39.19 | 39.2 | 39.16 | 39.16 | 1104700.0 |
| 2005-09-16 13:30:00 | QQQ | ETF | 39.16 | 39.22 | 39.13 | 39.2 | 2768300.0 |
| 2005-09-16 14:00:00 | QQQ | ETF | 39.21 | 39.25 | 39.19 | 39.21 | 4179500.0 |
| 2005-09-16 14:30:00 | QQQ | ETF | 39.21 | 39.3 | 39.19 | 39.29 | 3876300.0 |
| 2005-09-16 15:00:00 | QQQ | ETF | 39.29 | 39.41 | 39.28 | 39.4 | 8656100.0 |
| 2005-09-16 15:30:00 | QQQ | ETF | 39.39 | 39.46 | 39.36 | 39.4 | 8423100.0 |
| 2005-09-16 07:00:00 | IWM | ETF | 66.47 | 66.47 | 66.47 | 66.47 | 20000.0 |
| 2005-09-16 07:30:00 | IWM | ETF | 66.51 | 66.53 | 66.51 | 66.53 | 35100.0 |
| 2005-09-16 08:00:00 | IWM | ETF | 66.45 | 66.57 | 66.45 | 66.5 | 556500.0 |
| 2005-09-16 08:30:00 | IWM | ETF | 66.55 | 66.57 | 66.45 | 66.55 | 968200.0 |
| 2005-09-16 09:00:00 | IWM | ETF | 66.58 | 66.63 | 66.55 | 66.59 | 177500.0 |
| 2005-09-16 09:30:00 | IWM | ETF | 66.57 | 66.7 | 66.52 | 66.57 | 3224500.0 |
| 2005-09-16 10:00:00 | IWM | ETF | 66.58 | 66.68 | 66.45 | 66.49 | 1701900.0 |
| 2005-09-16 10:30:00 | IWM | ETF | 66.48 | 66.5 | 66.38 | 66.4 | 1278400.0 |
| 2005-09-16 11:00:00 | IWM | ETF | 66.4 | 66.48 | 66.36 | 66.44 | 1418900.0 |
| 2005-09-16 11:30:00 | IWM | ETF | 66.45 | 66.46 | 66.34 | 66.37 | 1718100.0 |
| 2005-09-16 12:00:00 | IWM | ETF | 66.36 | 66.43 | 66.35 | 66.4 | 995400.0 |
| 2005-09-16 12:30:00 | IWM | ETF | 66.4 | 66.55 | 66.38 | 66.54 | 1592600.0 |
> showing 50 of 1,668 rows — these rows as CSV