PREVIEW / etf_30min / 2005-06-08
file: by_date/etf_30min/2005/2005-06-08.parquet size: 43 KB rows: 1,472
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-06-08 07:00:00 | SPY | ETF | 120.52 | 120.64 | 120.52 | 120.59 | 53800.0 |
| 2005-06-08 07:30:00 | SPY | ETF | 120.58 | 120.6 | 120.55 | 120.55 | 90900.0 |
| 2005-06-08 08:00:00 | SPY | ETF | 120.53 | 120.55 | 120.5 | 120.5 | 29700.0 |
| 2005-06-08 08:30:00 | SPY | ETF | 120.5 | 120.53 | 120.47 | 120.49 | 52900.0 |
| 2005-06-08 09:00:00 | SPY | ETF | 120.49 | 120.5 | 120.45 | 120.47 | 43000.0 |
| 2005-06-08 09:30:00 | SPY | ETF | 120.43 | 120.47 | 120.25 | 120.44 | 4116800.0 |
| 2005-06-08 10:00:00 | SPY | ETF | 120.44 | 120.49 | 120.23 | 120.27 | 3440500.0 |
| 2005-06-08 10:30:00 | SPY | ETF | 120.27 | 120.56 | 120.13 | 120.52 | 5832100.0 |
| 2005-06-08 11:00:00 | SPY | ETF | 120.51 | 120.52 | 120.31 | 120.45 | 2145500.0 |
| 2005-06-08 11:30:00 | SPY | ETF | 120.45 | 120.54 | 120.37 | 120.52 | 1011600.0 |
| 2005-06-08 12:00:00 | SPY | ETF | 120.51 | 120.55 | 120.41 | 120.47 | 1026200.0 |
| 2005-06-08 12:30:00 | SPY | ETF | 120.47 | 120.59 | 120.44 | 120.58 | 1741000.0 |
| 2005-06-08 13:00:00 | SPY | ETF | 120.47 | 120.53 | 120.34 | 120.4 | 1616800.0 |
| 2005-06-08 13:30:00 | SPY | ETF | 120.39 | 120.58 | 119.99 | 120.12 | 3290500.0 |
| 2005-06-08 14:00:00 | SPY | ETF | 120.11 | 120.15 | 119.77 | 119.92 | 6628600.0 |
| 2005-06-08 14:30:00 | SPY | ETF | 119.91 | 119.98 | 119.71 | 119.74 | 2381500.0 |
| 2005-06-08 15:00:00 | SPY | ETF | 119.73 | 120.0809 | 119.67 | 119.78 | 3541300.0 |
| 2005-06-08 15:30:00 | SPY | ETF | 119.77 | 119.98 | 119.73 | 119.85 | 6739000.0 |
| 2005-06-08 16:00:00 | SPY | ETF | 119.9 | 120.0 | 119.88 | 119.93 | 447000.0 |
| 2005-06-08 16:30:00 | SPY | ETF | 119.93 | 119.94 | 119.87 | 119.9 | 144900.0 |
| 2005-06-08 17:00:00 | SPY | ETF | 119.91 | 119.95 | 119.91 | 119.95 | 3001500.0 |
| 2005-06-08 17:30:00 | SPY | ETF | 119.91 | 119.91 | 119.91 | 119.91 | 3000.0 |
| 2005-06-08 18:00:00 | SPY | ETF | 119.92 | 119.92 | 119.86 | 119.91 | 2200.0 |
| 2005-06-08 19:30:00 | SPY | ETF | 119.88 | 119.88 | 119.86 | 119.86 | 1200.0 |
| 2005-06-08 09:30:00 | QQQ | ETF | 37.88 | 37.95 | 37.8 | 37.88 | 11029000.0 |
| 2005-06-08 10:00:00 | QQQ | ETF | 37.88 | 37.92 | 37.8 | 37.81 | 5426300.0 |
| 2005-06-08 10:30:00 | QQQ | ETF | 37.82 | 37.88 | 37.71 | 37.86 | 9305300.0 |
| 2005-06-08 11:00:00 | QQQ | ETF | 37.86 | 37.87 | 37.77 | 37.86 | 3568200.0 |
| 2005-06-08 11:30:00 | QQQ | ETF | 37.85 | 37.93 | 37.83 | 37.91 | 2671000.0 |
| 2005-06-08 12:00:00 | QQQ | ETF | 37.9 | 37.95 | 37.89 | 37.9 | 3506300.0 |
| 2005-06-08 12:30:00 | QQQ | ETF | 37.9 | 37.94 | 37.87 | 37.92 | 3015500.0 |
| 2005-06-08 13:00:00 | QQQ | ETF | 37.92 | 37.93 | 37.81 | 37.83 | 2040600.0 |
| 2005-06-08 13:30:00 | QQQ | ETF | 37.83 | 37.84 | 37.71 | 37.75 | 4529900.0 |
| 2005-06-08 14:00:00 | QQQ | ETF | 37.76 | 37.76 | 37.55 | 37.66 | 14043700.0 |
| 2005-06-08 14:30:00 | QQQ | ETF | 37.66 | 37.7 | 37.61 | 37.64 | 6258800.0 |
| 2005-06-08 15:00:00 | QQQ | ETF | 37.64 | 37.7 | 37.61 | 37.67 | 3846600.0 |
| 2005-06-08 15:30:00 | QQQ | ETF | 37.66 | 37.75 | 37.65 | 37.71 | 6200300.0 |
| 2005-06-08 08:00:00 | IWM | ETF | 62.295 | 62.295 | 62.295 | 62.295 | 1000.0 |
| 2005-06-08 08:30:00 | IWM | ETF | 62.29 | 62.29 | 62.29 | 62.29 | 3200.0 |
| 2005-06-08 09:30:00 | IWM | ETF | 62.24 | 62.37 | 62.1 | 62.315 | 2795600.0 |
| 2005-06-08 10:00:00 | IWM | ETF | 62.315 | 62.335 | 62.135 | 62.135 | 995200.0 |
| 2005-06-08 10:30:00 | IWM | ETF | 62.165 | 62.3 | 62.055 | 62.275 | 1431600.0 |
| 2005-06-08 11:00:00 | IWM | ETF | 62.265 | 62.295 | 62.185 | 62.275 | 1008800.0 |
| 2005-06-08 11:30:00 | IWM | ETF | 62.28 | 62.315 | 62.22 | 62.315 | 312000.0 |
| 2005-06-08 12:00:00 | IWM | ETF | 62.305 | 62.335 | 62.225 | 62.26 | 967600.0 |
| 2005-06-08 12:30:00 | IWM | ETF | 62.26 | 62.335 | 62.24 | 62.25 | 857400.0 |
| 2005-06-08 13:00:00 | IWM | ETF | 62.245 | 62.265 | 62.155 | 62.21 | 293400.0 |
| 2005-06-08 13:30:00 | IWM | ETF | 62.205 | 62.205 | 61.875 | 61.955 | 1243600.0 |
| 2005-06-08 14:00:00 | IWM | ETF | 61.965 | 61.965 | 61.675 | 61.8 | 2079200.0 |
| 2005-06-08 14:30:00 | IWM | ETF | 61.795 | 61.83 | 61.646 | 61.66 | 2173400.0 |
> showing 50 of 1,472 rows — these rows as CSV