PREVIEW / etf_30min / 2005-11-18
file: by_date/etf_30min/2005/2005-11-18.parquet size: 51 KB rows: 1,814
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-11-18 07:00:00 | SPY | ETF | 124.66 | 124.69 | 124.66 | 124.69 | 9100.0 |
| 2005-11-18 07:30:00 | SPY | ETF | 124.73 | 124.8 | 124.73 | 124.77 | 87000.0 |
| 2005-11-18 08:00:00 | SPY | ETF | 124.69 | 124.97 | 124.68 | 124.87 | 1916100.0 |
| 2005-11-18 08:30:00 | SPY | ETF | 124.89 | 124.9 | 124.77 | 124.9 | 323500.0 |
| 2005-11-18 09:00:00 | SPY | ETF | 124.9 | 125.12 | 124.76 | 125.03 | 831400.0 |
| 2005-11-18 09:30:00 | SPY | ETF | 125.04 | 125.12 | 124.91 | 125.04 | 12153400.0 |
| 2005-11-18 10:00:00 | SPY | ETF | 125.02 | 125.28 | 124.96 | 124.99 | 8981800.0 |
| 2005-11-18 10:30:00 | SPY | ETF | 125.0 | 125.06 | 124.62 | 124.67 | 6416100.0 |
| 2005-11-18 11:00:00 | SPY | ETF | 124.67 | 124.85 | 124.56 | 124.64 | 6871200.0 |
| 2005-11-18 11:30:00 | SPY | ETF | 124.65 | 124.68 | 124.46 | 124.54 | 4005400.0 |
| 2005-11-18 12:00:00 | SPY | ETF | 124.56 | 125.756 | 124.54 | 124.57 | 3830900.0 |
| 2005-11-18 12:30:00 | SPY | ETF | 124.57 | 124.75 | 124.33 | 124.45 | 2883300.0 |
| 2005-11-18 13:00:00 | SPY | ETF | 124.45 | 124.6 | 124.43 | 124.49 | 1312000.0 |
| 2005-11-18 13:30:00 | SPY | ETF | 124.49 | 124.9 | 124.46 | 124.79 | 3027900.0 |
| 2005-11-18 14:00:00 | SPY | ETF | 124.78 | 124.87 | 124.63 | 124.66 | 2486200.0 |
| 2005-11-18 14:30:00 | SPY | ETF | 124.6615 | 124.82 | 124.63 | 124.73 | 1381300.0 |
| 2005-11-18 15:00:00 | SPY | ETF | 124.73 | 124.97 | 124.69 | 124.78 | 3091800.0 |
| 2005-11-18 15:30:00 | SPY | ETF | 124.78 | 125.23 | 124.75 | 125.1 | 6681400.0 |
| 2005-11-18 16:00:00 | SPY | ETF | 125.09 | 125.134 | 124.7625 | 125.09 | 2292800.0 |
| 2005-11-18 16:30:00 | SPY | ETF | 125.08 | 125.1 | 125.0 | 125.0 | 504400.0 |
| 2005-11-18 17:00:00 | SPY | ETF | 125.04 | 125.05 | 125.02 | 125.03 | 91500.0 |
| 2005-11-18 17:30:00 | SPY | ETF | 125.04 | 125.04 | 125.01 | 125.02 | 11400.0 |
| 2005-11-18 19:00:00 | SPY | ETF | 125.06 | 125.07 | 125.06 | 125.07 | 1000.0 |
| 2005-11-18 19:30:00 | SPY | ETF | 125.07 | 125.07 | 125.07 | 125.07 | 600.0 |
| 2005-11-18 09:30:00 | QQQ | ETF | 41.51 | 41.53 | 40.5 | 41.48 | 19232000.0 |
| 2005-11-18 10:00:00 | QQQ | ETF | 41.49 | 41.65 | 41.45 | 41.45 | 16120900.0 |
| 2005-11-18 10:30:00 | QQQ | ETF | 41.45 | 41.46 | 39.39 | 41.33 | 9743100.0 |
| 2005-11-18 11:00:00 | QQQ | ETF | 41.34 | 41.47 | 41.27 | 41.36 | 11122600.0 |
| 2005-11-18 11:30:00 | QQQ | ETF | 41.35 | 41.4 | 41.28 | 41.37 | 3896000.0 |
| 2005-11-18 12:00:00 | QQQ | ETF | 41.37 | 41.44 | 41.36 | 41.38 | 2489600.0 |
| 2005-11-18 12:30:00 | QQQ | ETF | 41.38 | 41.39 | 41.31 | 41.35 | 2066700.0 |
| 2005-11-18 13:00:00 | QQQ | ETF | 41.35 | 41.38 | 41.32 | 41.35 | 1976400.0 |
| 2005-11-18 13:30:00 | QQQ | ETF | 41.34 | 41.45 | 41.34 | 41.42 | 4498600.0 |
| 2005-11-18 14:00:00 | QQQ | ETF | 41.43 | 41.47 | 41.03 | 41.37 | 3957500.0 |
| 2005-11-18 14:30:00 | QQQ | ETF | 41.37 | 41.4 | 41.3 | 41.33 | 5111600.0 |
| 2005-11-18 15:00:00 | QQQ | ETF | 41.33 | 41.4 | 41.32 | 41.35 | 5463700.0 |
| 2005-11-18 15:30:00 | QQQ | ETF | 41.35 | 41.46 | 41.34 | 41.42 | 8366500.0 |
| 2005-11-18 07:30:00 | IWM | ETF | 66.42 | 66.5 | 66.42 | 66.5 | 27300.0 |
| 2005-11-18 08:00:00 | IWM | ETF | 66.5 | 66.6 | 66.39 | 66.55 | 378700.0 |
| 2005-11-18 08:30:00 | IWM | ETF | 66.56 | 66.64 | 66.52 | 66.52 | 281700.0 |
| 2005-11-18 09:00:00 | IWM | ETF | 66.57 | 66.64 | 66.49 | 66.62 | 57400.0 |
| 2005-11-18 09:30:00 | IWM | ETF | 66.63 | 66.83 | 66.61 | 66.81 | 4245000.0 |
| 2005-11-18 10:00:00 | IWM | ETF | 66.81 | 67.08 | 66.77 | 66.82 | 4894800.0 |
| 2005-11-18 10:30:00 | IWM | ETF | 66.82 | 66.88 | 66.5 | 66.6 | 4541200.0 |
| 2005-11-18 11:00:00 | IWM | ETF | 66.6 | 66.71 | 66.44 | 66.51 | 1789100.0 |
| 2005-11-18 11:30:00 | IWM | ETF | 66.51 | 66.65 | 66.37 | 66.51 | 1045900.0 |
| 2005-11-18 12:00:00 | IWM | ETF | 66.52 | 66.68 | 66.45 | 66.57 | 908300.0 |
| 2005-11-18 12:30:00 | IWM | ETF | 66.58 | 66.59 | 66.43 | 66.53 | 612900.0 |
| 2005-11-18 13:00:00 | IWM | ETF | 66.53 | 66.69 | 66.53 | 66.65 | 1338400.0 |
| 2005-11-18 13:30:00 | IWM | ETF | 66.66 | 66.89 | 66.6 | 66.85 | 1177600.0 |
> showing 50 of 1,814 rows — these rows as CSV