PREVIEW / etf_30min / 2005-05-17
file: by_date/etf_30min/2005/2005-05-17.parquet size: 44 KB rows: 1,484
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-05-17 04:00:00 | SPY | ETF | 116.47 | 116.47 | 116.47 | 116.47 | 7100.0 |
| 2005-05-17 07:00:00 | SPY | ETF | 116.41 | 116.45 | 116.31 | 116.39 | 278600.0 |
| 2005-05-17 07:30:00 | SPY | ETF | 116.42 | 116.47 | 116.39 | 116.42 | 58300.0 |
| 2005-05-17 08:00:00 | SPY | ETF | 116.4 | 116.56 | 116.4 | 116.52 | 375200.0 |
| 2005-05-17 08:30:00 | SPY | ETF | 116.41 | 116.55 | 116.34 | 116.43 | 578000.0 |
| 2005-05-17 09:00:00 | SPY | ETF | 116.43 | 116.47 | 116.36 | 116.42 | 173200.0 |
| 2005-05-17 09:30:00 | SPY | ETF | 116.43 | 116.68 | 116.36 | 116.66 | 7729200.0 |
| 2005-05-17 10:00:00 | SPY | ETF | 116.66 | 116.73 | 116.24 | 116.25 | 5816100.0 |
| 2005-05-17 10:30:00 | SPY | ETF | 116.25 | 116.41 | 116.16 | 116.32 | 4768300.0 |
| 2005-05-17 11:00:00 | SPY | ETF | 116.33 | 116.54 | 116.26 | 116.35 | 2535000.0 |
| 2005-05-17 11:30:00 | SPY | ETF | 116.36 | 116.74 | 116.34 | 116.6 | 2956800.0 |
| 2005-05-17 12:00:00 | SPY | ETF | 116.6 | 116.64 | 116.47 | 116.53 | 1710500.0 |
| 2005-05-17 12:30:00 | SPY | ETF | 116.54 | 116.54 | 116.33 | 116.35 | 1709000.0 |
| 2005-05-17 13:00:00 | SPY | ETF | 116.36 | 116.64 | 116.3 | 116.56 | 2826400.0 |
| 2005-05-17 13:30:00 | SPY | ETF | 116.56 | 116.63 | 116.41 | 116.52 | 1226500.0 |
| 2005-05-17 14:00:00 | SPY | ETF | 116.53 | 116.79 | 116.43 | 116.67 | 2672400.0 |
| 2005-05-17 14:30:00 | SPY | ETF | 116.67 | 117.44 | 116.67 | 117.3 | 11440800.0 |
| 2005-05-17 15:00:00 | SPY | ETF | 117.29 | 117.38 | 117.2 | 117.37 | 3265500.0 |
| 2005-05-17 15:30:00 | SPY | ETF | 117.37 | 117.7 | 117.36 | 117.57 | 7613800.0 |
| 2005-05-17 16:00:00 | SPY | ETF | 117.55 | 117.66 | 117.55 | 117.59 | 1427000.0 |
| 2005-05-17 16:30:00 | SPY | ETF | 117.59 | 117.62 | 117.53 | 117.57 | 207700.0 |
| 2005-05-17 17:00:00 | SPY | ETF | 117.57 | 117.63 | 117.57 | 117.62 | 148100.0 |
| 2005-05-17 17:30:00 | SPY | ETF | 117.62 | 117.64 | 117.57 | 117.58 | 2100.0 |
| 2005-05-17 18:00:00 | SPY | ETF | 117.58 | 117.58 | 117.58 | 117.58 | 100.0 |
| 2005-05-17 18:30:00 | SPY | ETF | 117.56 | 117.56 | 117.56 | 117.56 | 500.0 |
| 2005-05-17 19:30:00 | SPY | ETF | 117.6 | 117.6 | 117.55 | 117.55 | 4800.0 |
| 2005-05-17 09:30:00 | QQQ | ETF | 36.35 | 36.46 | 36.32 | 36.46 | 10841500.0 |
| 2005-05-17 10:00:00 | QQQ | ETF | 36.45 | 36.47 | 36.25 | 36.26 | 11874800.0 |
| 2005-05-17 10:30:00 | QQQ | ETF | 36.26 | 36.33 | 36.21 | 36.31 | 9708500.0 |
| 2005-05-17 11:00:00 | QQQ | ETF | 36.31 | 36.37 | 36.29 | 36.3 | 3362500.0 |
| 2005-05-17 11:30:00 | QQQ | ETF | 36.3 | 36.45 | 36.29 | 36.4 | 6636200.0 |
| 2005-05-17 12:00:00 | QQQ | ETF | 36.4 | 36.4 | 36.35 | 36.36 | 1678200.0 |
| 2005-05-17 12:30:00 | QQQ | ETF | 36.37 | 36.37 | 36.3 | 36.32 | 2351200.0 |
| 2005-05-17 13:00:00 | QQQ | ETF | 36.32 | 36.4 | 36.3 | 36.38 | 3500400.0 |
| 2005-05-17 13:30:00 | QQQ | ETF | 36.39 | 36.41 | 36.35 | 36.4 | 2184500.0 |
| 2005-05-17 14:00:00 | QQQ | ETF | 36.4 | 36.47 | 36.36 | 36.43 | 4290700.0 |
| 2005-05-17 14:30:00 | QQQ | ETF | 36.42 | 36.64 | 36.42 | 36.61 | 12373400.0 |
| 2005-05-17 15:00:00 | QQQ | ETF | 36.61 | 36.64 | 36.58 | 36.63 | 3991500.0 |
| 2005-05-17 15:30:00 | QQQ | ETF | 36.63 | 36.74 | 36.63 | 36.7 | 14510200.0 |
| 2005-05-17 07:30:00 | IWM | ETF | 58.74 | 58.74 | 58.725 | 58.725 | 28200.0 |
| 2005-05-17 08:00:00 | IWM | ETF | 58.73 | 58.805 | 58.725 | 58.805 | 97400.0 |
| 2005-05-17 08:30:00 | IWM | ETF | 58.7 | 58.825 | 58.7 | 58.78 | 33000.0 |
| 2005-05-17 09:00:00 | IWM | ETF | 58.77 | 58.78 | 58.76 | 58.76 | 7000.0 |
| 2005-05-17 09:30:00 | IWM | ETF | 58.755 | 58.895 | 58.615 | 58.86 | 1273800.0 |
| 2005-05-17 10:00:00 | IWM | ETF | 58.865 | 58.9 | 58.52 | 58.52 | 2642600.0 |
| 2005-05-17 10:30:00 | IWM | ETF | 58.525 | 58.595 | 58.435 | 58.52 | 1397400.0 |
| 2005-05-17 11:00:00 | IWM | ETF | 58.51 | 58.635 | 58.42 | 58.52 | 1920000.0 |
| 2005-05-17 11:30:00 | IWM | ETF | 58.52 | 58.8 | 58.515 | 58.74 | 899000.0 |
| 2005-05-17 12:00:00 | IWM | ETF | 58.73 | 58.75 | 58.615 | 58.655 | 292800.0 |
| 2005-05-17 12:30:00 | IWM | ETF | 58.65 | 58.655 | 58.505 | 58.545 | 712400.0 |
> showing 50 of 1,484 rows — these rows as CSV