PREVIEW / etf_30min / 2006-08-28
file: by_date/etf_30min/2006/2006-08-28.parquet size: 76 KB rows: 2,742
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-08-28 04:30:00 | SPY | ETF | 129.66 | 129.66 | 129.58 | 129.58 | 400.0 |
| 2006-08-28 05:00:00 | SPY | ETF | 129.54 | 129.54 | 129.54 | 129.54 | 100.0 |
| 2006-08-28 06:30:00 | SPY | ETF | 129.65 | 129.65 | 129.65 | 129.65 | 100.0 |
| 2006-08-28 07:00:00 | SPY | ETF | 129.62 | 129.65 | 129.62 | 129.65 | 5100.0 |
| 2006-08-28 07:30:00 | SPY | ETF | 129.7 | 129.7 | 129.64 | 129.64 | 3900.0 |
| 2006-08-28 08:00:00 | SPY | ETF | 129.72 | 129.81 | 129.65 | 129.79 | 441700.0 |
| 2006-08-28 08:30:00 | SPY | ETF | 129.79 | 129.81 | 129.78 | 129.78 | 66700.0 |
| 2006-08-28 09:00:00 | SPY | ETF | 129.78 | 129.81 | 129.66 | 129.66 | 153500.0 |
| 2006-08-28 09:30:00 | SPY | ETF | 129.65 | 130.06 | 129.64 | 129.96 | 6622400.0 |
| 2006-08-28 10:00:00 | SPY | ETF | 129.97 | 130.33 | 129.97 | 130.31 | 5824000.0 |
| 2006-08-28 10:30:00 | SPY | ETF | 130.31 | 130.46 | 130.27 | 130.38 | 5367100.0 |
| 2006-08-28 11:00:00 | SPY | ETF | 130.38 | 130.51 | 130.28 | 130.36 | 2095800.0 |
| 2006-08-28 11:30:00 | SPY | ETF | 130.37 | 130.64 | 130.27 | 130.54 | 5052300.0 |
| 2006-08-28 12:00:00 | SPY | ETF | 130.55 | 130.7 | 130.5 | 130.53 | 3290200.0 |
| 2006-08-28 12:30:00 | SPY | ETF | 130.53 | 130.64 | 130.52 | 130.58 | 2012400.0 |
| 2006-08-28 13:00:00 | SPY | ETF | 130.58 | 130.62 | 130.49 | 130.57 | 2909000.0 |
| 2006-08-28 13:30:00 | SPY | ETF | 130.57 | 130.74 | 130.49 | 130.72 | 2374500.0 |
| 2006-08-28 14:00:00 | SPY | ETF | 130.72 | 130.82 | 130.6315 | 130.66 | 4404000.0 |
| 2006-08-28 14:30:00 | SPY | ETF | 130.64 | 130.7 | 130.53 | 130.69 | 3429800.0 |
| 2006-08-28 15:00:00 | SPY | ETF | 130.68 | 130.72 | 130.56 | 130.6 | 2260300.0 |
| 2006-08-28 15:30:00 | SPY | ETF | 130.6 | 130.66 | 130.4 | 130.48 | 4752300.0 |
| 2006-08-28 16:00:00 | SPY | ETF | 130.49 | 130.56 | 130.43 | 130.48 | 929400.0 |
| 2006-08-28 16:30:00 | SPY | ETF | 130.45 | 130.48 | 130.44 | 130.48 | 5100.0 |
| 2006-08-28 17:00:00 | SPY | ETF | 130.47 | 130.47 | 130.47 | 130.47 | 500.0 |
| 2006-08-28 17:30:00 | SPY | ETF | 130.47 | 130.48 | 130.47 | 130.47 | 12500.0 |
| 2006-08-28 18:00:00 | SPY | ETF | 130.46 | 130.46 | 130.46 | 130.46 | 700.0 |
| 2006-08-28 19:30:00 | SPY | ETF | 130.48 | 130.49 | 130.47 | 130.49 | 2000.0 |
| 2006-08-28 09:30:00 | QQQ | ETF | 38.28 | 38.45 | 38.24 | 38.39 | 10958800.0 |
| 2006-08-28 10:00:00 | QQQ | ETF | 38.38 | 38.58 | 38.38 | 38.57 | 10468000.0 |
| 2006-08-28 10:30:00 | QQQ | ETF | 38.58 | 38.62 | 38.52 | 38.55 | 7347500.0 |
| 2006-08-28 11:00:00 | QQQ | ETF | 38.56 | 38.62 | 38.5 | 38.52 | 5966100.0 |
| 2006-08-28 11:30:00 | QQQ | ETF | 38.52 | 38.69 | 38.46 | 38.66 | 7136000.0 |
| 2006-08-28 12:00:00 | QQQ | ETF | 38.66 | 38.79 | 38.62 | 38.63 | 6132400.0 |
| 2006-08-28 12:30:00 | QQQ | ETF | 38.63 | 38.66 | 38.62 | 38.62 | 2029800.0 |
| 2006-08-28 13:00:00 | QQQ | ETF | 38.62 | 38.64 | 38.58 | 38.62 | 2240700.0 |
| 2006-08-28 13:30:00 | QQQ | ETF | 38.63 | 38.7 | 38.57 | 38.7 | 4401600.0 |
| 2006-08-28 14:00:00 | QQQ | ETF | 38.69 | 38.73 | 38.63 | 38.65 | 3795800.0 |
| 2006-08-28 14:30:00 | QQQ | ETF | 38.66 | 38.67 | 38.58 | 38.65 | 3698600.0 |
| 2006-08-28 15:00:00 | QQQ | ETF | 38.65 | 38.68 | 38.6 | 38.62 | 3544100.0 |
| 2006-08-28 15:30:00 | QQQ | ETF | 38.62 | 38.64 | 38.52 | 38.61 | 7366700.0 |
| 2006-08-28 07:30:00 | IWM | ETF | 69.5 | 69.5 | 69.5 | 69.5 | 100.0 |
| 2006-08-28 08:00:00 | IWM | ETF | 69.42 | 69.52 | 69.4 | 69.52 | 2100.0 |
| 2006-08-28 08:30:00 | IWM | ETF | 69.62 | 69.62 | 69.62 | 69.62 | 200.0 |
| 2006-08-28 09:00:00 | IWM | ETF | 69.6 | 69.64 | 69.52 | 69.55 | 32800.0 |
| 2006-08-28 09:30:00 | IWM | ETF | 69.54 | 69.94 | 69.52 | 69.82 | 3910000.0 |
| 2006-08-28 10:00:00 | IWM | ETF | 69.84 | 70.16 | 69.84 | 70.14 | 2941500.0 |
| 2006-08-28 10:30:00 | IWM | ETF | 70.15 | 70.28 | 70.14 | 70.22 | 2956400.0 |
| 2006-08-28 11:00:00 | IWM | ETF | 70.22 | 70.3 | 70.11 | 70.15 | 2202400.0 |
| 2006-08-28 11:30:00 | IWM | ETF | 70.16 | 70.35 | 70.09 | 70.26 | 1486900.0 |
| 2006-08-28 12:00:00 | IWM | ETF | 70.26 | 70.37 | 70.21 | 70.2599 | 1636100.0 |
> showing 50 of 2,742 rows — these rows as CSV