PREVIEW / etf_30min / 2006-04-28
file: by_date/etf_30min/2006/2006-04-28.parquet size: 61 KB rows: 2,220
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 |
|---|---|---|---|---|---|---|---|
| 2006-04-28 04:00:00 | SPY | ETF | 130.77 | 130.77 | 130.71 | 130.71 | 200.0 |
| 2006-04-28 07:00:00 | SPY | ETF | 130.75 | 130.8 | 130.73 | 130.8 | 2300.0 |
| 2006-04-28 07:30:00 | SPY | ETF | 130.81 | 130.82 | 130.75 | 130.75 | 14400.0 |
| 2006-04-28 08:00:00 | SPY | ETF | 130.75 | 130.82 | 130.64 | 130.69 | 487500.0 |
| 2006-04-28 08:30:00 | SPY | ETF | 130.72 | 131.94 | 130.6 | 130.64 | 1230000.0 |
| 2006-04-28 09:00:00 | SPY | ETF | 130.91 | 130.93 | 130.77 | 130.77 | 396300.0 |
| 2006-04-28 09:30:00 | SPY | ETF | 130.79 | 131.02 | 130.71 | 130.92 | 7320700.0 |
| 2006-04-28 10:00:00 | SPY | ETF | 130.92 | 131.75 | 130.91 | 131.54 | 9842500.0 |
| 2006-04-28 10:30:00 | SPY | ETF | 131.55 | 131.56 | 131.28 | 131.3 | 3895600.0 |
| 2006-04-28 11:00:00 | SPY | ETF | 131.3 | 131.5 | 131.17 | 131.21 | 3301100.0 |
| 2006-04-28 11:30:00 | SPY | ETF | 131.21 | 131.34 | 131.15 | 131.31 | 2947400.0 |
| 2006-04-28 12:00:00 | SPY | ETF | 131.3 | 131.32 | 131.18 | 131.26 | 2125500.0 |
| 2006-04-28 12:30:00 | SPY | ETF | 131.2499 | 131.29 | 131.05 | 131.21 | 2613600.0 |
| 2006-04-28 13:00:00 | SPY | ETF | 131.21 | 131.42 | 131.18 | 131.26 | 1473600.0 |
| 2006-04-28 13:30:00 | SPY | ETF | 131.29 | 131.39 | 131.13 | 131.22 | 2138100.0 |
| 2006-04-28 14:00:00 | SPY | ETF | 131.21 | 131.28 | 131.17 | 131.21 | 1704900.0 |
| 2006-04-28 14:30:00 | SPY | ETF | 131.2 | 131.27 | 131.08 | 131.14 | 1457600.0 |
| 2006-04-28 15:00:00 | SPY | ETF | 131.14 | 131.18 | 130.95 | 131.11 | 4398000.0 |
| 2006-04-28 15:30:00 | SPY | ETF | 131.11 | 131.22 | 131.02 | 131.14 | 5940300.0 |
| 2006-04-28 16:00:00 | SPY | ETF | 131.15 | 131.47 | 130.752 | 131.35 | 1635700.0 |
| 2006-04-28 16:30:00 | SPY | ETF | 131.38 | 131.45 | 131.35 | 131.39 | 25800.0 |
| 2006-04-28 17:30:00 | SPY | ETF | 131.42 | 131.42 | 131.42 | 131.42 | 1900.0 |
| 2006-04-28 18:00:00 | SPY | ETF | 131.43 | 131.43 | 131.4 | 131.4 | 700.0 |
| 2006-04-28 09:30:00 | QQQ | ETF | 41.99 | 42.04 | 41.82 | 41.99 | 20826000.0 |
| 2006-04-28 10:00:00 | QQQ | ETF | 41.96 | 42.22 | 41.96 | 42.13 | 12265100.0 |
| 2006-04-28 10:30:00 | QQQ | ETF | 42.13 | 42.13 | 41.97 | 42.01 | 6851900.0 |
| 2006-04-28 11:00:00 | QQQ | ETF | 42.02 | 42.06 | 41.93 | 41.94 | 6093600.0 |
| 2006-04-28 11:30:00 | QQQ | ETF | 41.93 | 41.95 | 41.87 | 41.93 | 5718900.0 |
| 2006-04-28 12:00:00 | QQQ | ETF | 41.93 | 41.96 | 41.87 | 41.9 | 3685100.0 |
| 2006-04-28 12:30:00 | QQQ | ETF | 41.9 | 41.94 | 41.78 | 41.87 | 4962700.0 |
| 2006-04-28 13:00:00 | QQQ | ETF | 41.87 | 42.01 | 41.86 | 41.92 | 5276100.0 |
| 2006-04-28 13:30:00 | QQQ | ETF | 41.92 | 41.96 | 41.86 | 41.89 | 2418900.0 |
| 2006-04-28 14:00:00 | QQQ | ETF | 41.89 | 41.92 | 41.87 | 41.88 | 1171400.0 |
| 2006-04-28 14:30:00 | QQQ | ETF | 41.88 | 41.91 | 41.85 | 41.87 | 1462900.0 |
| 2006-04-28 15:00:00 | QQQ | ETF | 41.88 | 41.89 | 41.78 | 41.85 | 4409100.0 |
| 2006-04-28 15:30:00 | QQQ | ETF | 41.84 | 41.87 | 41.8 | 41.86 | 7544600.0 |
| 2006-04-28 08:00:00 | IWM | ETF | 75.33 | 75.33 | 75.15 | 75.15 | 13400.0 |
| 2006-04-28 08:30:00 | IWM | ETF | 75.19 | 75.37 | 75.19 | 75.33 | 10100.0 |
| 2006-04-28 09:00:00 | IWM | ETF | 75.33 | 75.33 | 75.21 | 75.23 | 143300.0 |
| 2006-04-28 09:30:00 | IWM | ETF | 75.24 | 75.89 | 75.1 | 75.61 | 4483400.0 |
| 2006-04-28 10:00:00 | IWM | ETF | 75.61 | 76.35 | 75.61 | 76.18 | 6920400.0 |
| 2006-04-28 10:30:00 | IWM | ETF | 76.18 | 76.26 | 75.97 | 76.04 | 2319100.0 |
| 2006-04-28 11:00:00 | IWM | ETF | 76.04 | 76.28 | 75.91 | 76.09 | 2811100.0 |
| 2006-04-28 11:30:00 | IWM | ETF | 76.1 | 76.22 | 75.94 | 76.12 | 3724900.0 |
| 2006-04-28 12:00:00 | IWM | ETF | 76.12 | 76.13 | 76.0 | 76.02 | 999200.0 |
| 2006-04-28 12:30:00 | IWM | ETF | 76.02 | 76.04 | 75.71 | 75.91 | 2316000.0 |
| 2006-04-28 13:00:00 | IWM | ETF | 75.92 | 76.12 | 75.86 | 76.02 | 1024000.0 |
| 2006-04-28 13:30:00 | IWM | ETF | 76.03 | 76.07 | 75.83 | 75.92 | 2121500.0 |
| 2006-04-28 14:00:00 | IWM | ETF | 75.92 | 76.04 | 75.86 | 75.89 | 1292100.0 |
| 2006-04-28 14:30:00 | IWM | ETF | 75.9 | 76.01 | 75.85 | 75.87 | 1447600.0 |
> showing 50 of 2,220 rows — these rows as CSV