PREVIEW / etf_30min / 2005-07-28
file: by_date/etf_30min/2005/2005-07-28.parquet size: 46 KB rows: 1,632
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-07-28 06:00:00 | SPY | ETF | 123.8 | 123.8 | 123.8 | 123.8 | 5700.0 |
| 2005-07-28 07:00:00 | SPY | ETF | 123.9 | 123.92 | 123.9 | 123.92 | 49900.0 |
| 2005-07-28 07:30:00 | SPY | ETF | 123.93 | 123.93 | 123.89 | 123.89 | 25600.0 |
| 2005-07-28 08:00:00 | SPY | ETF | 123.92 | 124.08 | 123.92 | 124.04 | 476500.0 |
| 2005-07-28 08:30:00 | SPY | ETF | 124.05 | 124.11 | 123.93 | 123.93 | 662600.0 |
| 2005-07-28 09:00:00 | SPY | ETF | 124.07 | 124.09 | 124.0 | 124.0 | 176200.0 |
| 2005-07-28 09:30:00 | SPY | ETF | 123.99 | 124.21 | 123.93 | 124.04 | 6075100.0 |
| 2005-07-28 10:00:00 | SPY | ETF | 124.02 | 124.08 | 123.64 | 123.78 | 4800600.0 |
| 2005-07-28 10:30:00 | SPY | ETF | 123.77 | 124.08 | 123.74 | 123.98 | 3184700.0 |
| 2005-07-28 11:00:00 | SPY | ETF | 123.99 | 124.07 | 123.9 | 124.02 | 2096700.0 |
| 2005-07-28 11:30:00 | SPY | ETF | 124.01 | 124.35 | 123.93 | 124.29 | 5725200.0 |
| 2005-07-28 12:00:00 | SPY | ETF | 124.27 | 124.34 | 124.18 | 124.23 | 1803500.0 |
| 2005-07-28 12:30:00 | SPY | ETF | 124.23 | 124.3 | 124.2 | 124.24 | 743700.0 |
| 2005-07-28 13:00:00 | SPY | ETF | 124.23 | 124.42 | 124.19 | 124.38 | 1748700.0 |
| 2005-07-28 13:30:00 | SPY | ETF | 124.38 | 124.53 | 124.31 | 124.38 | 2760200.0 |
| 2005-07-28 14:00:00 | SPY | ETF | 124.39 | 124.49 | 124.33 | 124.41 | 1865900.0 |
| 2005-07-28 14:30:00 | SPY | ETF | 124.41 | 124.64 | 124.37 | 124.52 | 3698700.0 |
| 2005-07-28 15:00:00 | SPY | ETF | 124.52 | 124.55 | 124.41 | 124.52 | 2392200.0 |
| 2005-07-28 15:30:00 | SPY | ETF | 124.52 | 124.54 | 124.34 | 124.5 | 7267700.0 |
| 2005-07-28 16:00:00 | SPY | ETF | 124.5 | 124.6 | 124.47 | 124.56 | 712800.0 |
| 2005-07-28 16:30:00 | SPY | ETF | 124.55 | 124.6 | 124.52 | 124.58 | 345900.0 |
| 2005-07-28 17:00:00 | SPY | ETF | 124.58 | 124.6 | 124.57 | 124.6 | 123200.0 |
| 2005-07-28 17:30:00 | SPY | ETF | 124.6 | 124.62 | 124.45 | 124.62 | 203700.0 |
| 2005-07-28 18:00:00 | SPY | ETF | 124.62 | 124.62 | 124.58 | 124.6 | 16900.0 |
| 2005-07-28 18:30:00 | SPY | ETF | 124.58 | 124.58 | 124.58 | 124.58 | 300.0 |
| 2005-07-28 19:30:00 | SPY | ETF | 124.6 | 124.6 | 124.6 | 124.6 | 100.0 |
| 2005-07-28 09:30:00 | QQQ | ETF | 39.74 | 39.8 | 39.67 | 39.77 | 8604000.0 |
| 2005-07-28 10:00:00 | QQQ | ETF | 39.77 | 39.79 | 39.64 | 39.69 | 8336600.0 |
| 2005-07-28 10:30:00 | QQQ | ETF | 39.7 | 39.81 | 39.67 | 39.76 | 4764500.0 |
| 2005-07-28 11:00:00 | QQQ | ETF | 39.76 | 39.79 | 39.72 | 39.74 | 3806200.0 |
| 2005-07-28 11:30:00 | QQQ | ETF | 39.74 | 39.88 | 39.72 | 39.85 | 5137100.0 |
| 2005-07-28 12:00:00 | QQQ | ETF | 39.84 | 39.87 | 39.79 | 39.8 | 3355900.0 |
| 2005-07-28 12:30:00 | QQQ | ETF | 39.81 | 39.83 | 39.79 | 39.82 | 1597700.0 |
| 2005-07-28 13:00:00 | QQQ | ETF | 39.81 | 39.88 | 39.8 | 39.88 | 1686700.0 |
| 2005-07-28 13:30:00 | QQQ | ETF | 39.88 | 39.92 | 39.84 | 39.85 | 4510900.0 |
| 2005-07-28 14:00:00 | QQQ | ETF | 39.85 | 39.91 | 39.83 | 39.87 | 2698300.0 |
| 2005-07-28 14:30:00 | QQQ | ETF | 39.87 | 39.91 | 39.85 | 39.9 | 3625900.0 |
| 2005-07-28 15:00:00 | QQQ | ETF | 39.9 | 39.91 | 39.81 | 39.88 | 3910100.0 |
| 2005-07-28 15:30:00 | QQQ | ETF | 39.88 | 39.91 | 39.84 | 39.9 | 8242200.0 |
| 2005-07-28 07:30:00 | IWM | ETF | 67.28 | 67.28 | 67.28 | 67.28 | 1000.0 |
| 2005-07-28 08:00:00 | IWM | ETF | 67.46 | 67.46 | 67.46 | 67.46 | 7000.0 |
| 2005-07-28 08:30:00 | IWM | ETF | 67.42 | 67.45 | 67.4 | 67.42 | 19500.0 |
| 2005-07-28 09:00:00 | IWM | ETF | 67.43 | 67.43 | 67.38 | 67.38 | 600.0 |
| 2005-07-28 09:30:00 | IWM | ETF | 67.37 | 67.56 | 67.27 | 67.35 | 2571900.0 |
| 2005-07-28 10:00:00 | IWM | ETF | 67.35 | 67.43 | 67.02 | 67.13 | 2045500.0 |
| 2005-07-28 10:30:00 | IWM | ETF | 67.13 | 67.3 | 67.06 | 67.23 | 528700.0 |
| 2005-07-28 11:00:00 | IWM | ETF | 67.23 | 67.32 | 67.15 | 67.29 | 394500.0 |
| 2005-07-28 11:30:00 | IWM | ETF | 67.29 | 67.5 | 67.21 | 67.44 | 1456200.0 |
| 2005-07-28 12:00:00 | IWM | ETF | 67.46 | 67.57 | 67.43 | 67.51 | 866300.0 |
| 2005-07-28 12:30:00 | IWM | ETF | 67.51 | 67.53 | 67.43 | 67.49 | 287400.0 |
> showing 50 of 1,632 rows — these rows as CSV