PREVIEW / etf_30min / 2006-10-13
file: by_date/etf_30min/2006/2006-10-13.parquet size: 83 KB rows: 2,979
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-10-13 06:00:00 | SPY | ETF | 136.35 | 136.35 | 136.35 | 136.35 | 1000.0 |
| 2006-10-13 06:30:00 | SPY | ETF | 136.23 | 136.23 | 136.23 | 136.23 | 10000.0 |
| 2006-10-13 07:00:00 | SPY | ETF | 136.24 | 136.24 | 136.2 | 136.2 | 13900.0 |
| 2006-10-13 07:30:00 | SPY | ETF | 136.23 | 136.25 | 136.18 | 136.23 | 432900.0 |
| 2006-10-13 08:00:00 | SPY | ETF | 136.22 | 136.31 | 136.18 | 136.22 | 300500.0 |
| 2006-10-13 08:30:00 | SPY | ETF | 136.2 | 136.23 | 136.08 | 136.12 | 1372200.0 |
| 2006-10-13 09:00:00 | SPY | ETF | 136.13 | 136.27 | 136.13 | 136.15 | 225100.0 |
| 2006-10-13 09:30:00 | SPY | ETF | 136.16 | 136.33 | 136.11 | 136.16 | 5645400.0 |
| 2006-10-13 10:00:00 | SPY | ETF | 136.16 | 136.27 | 136.04 | 136.16 | 5664700.0 |
| 2006-10-13 10:30:00 | SPY | ETF | 136.16 | 136.29 | 136.14 | 136.22 | 3926400.0 |
| 2006-10-13 11:00:00 | SPY | ETF | 136.21 | 136.25 | 136.08 | 136.17 | 2573800.0 |
| 2006-10-13 11:30:00 | SPY | ETF | 136.17 | 136.27 | 136.11 | 136.22 | 2863600.0 |
| 2006-10-13 12:00:00 | SPY | ETF | 136.22 | 136.4 | 136.2 | 136.35 | 2616200.0 |
| 2006-10-13 12:30:00 | SPY | ETF | 136.35 | 136.51 | 136.35 | 136.46 | 3114000.0 |
| 2006-10-13 13:00:00 | SPY | ETF | 136.45 | 136.52 | 136.25 | 136.49 | 1979800.0 |
| 2006-10-13 13:30:00 | SPY | ETF | 136.5 | 136.68 | 136.49 | 136.65 | 3440200.0 |
| 2006-10-13 14:00:00 | SPY | ETF | 136.63 | 136.71 | 136.45 | 136.45 | 3040600.0 |
| 2006-10-13 14:30:00 | SPY | ETF | 136.45 | 136.47 | 136.23 | 136.3 | 4225700.0 |
| 2006-10-13 15:00:00 | SPY | ETF | 136.3 | 136.5 | 136.29 | 136.46 | 1801800.0 |
| 2006-10-13 15:30:00 | SPY | ETF | 136.46 | 136.58 | 136.39 | 136.56 | 4549900.0 |
| 2006-10-13 16:00:00 | SPY | ETF | 136.58 | 136.61 | 136.52 | 136.59 | 2155800.0 |
| 2006-10-13 16:30:00 | SPY | ETF | 136.59 | 136.59 | 136.56 | 136.57 | 3046700.0 |
| 2006-10-13 17:00:00 | SPY | ETF | 136.56 | 136.6 | 136.52 | 136.52 | 18100.0 |
| 2006-10-13 17:30:00 | SPY | ETF | 136.6 | 136.6 | 136.52 | 136.52 | 300.0 |
| 2006-10-13 18:00:00 | SPY | ETF | 136.58 | 136.58 | 136.58 | 136.58 | 500.0 |
| 2006-10-13 18:30:00 | SPY | ETF | 136.58 | 136.58 | 136.58 | 136.58 | 800.0 |
| 2006-10-13 19:30:00 | SPY | ETF | 136.58 | 136.58 | 136.58 | 136.58 | 200.0 |
| 2006-10-13 09:30:00 | QQQ | ETF | 42.22 | 42.36 | 42.14 | 42.26 | 10865400.0 |
| 2006-10-13 10:00:00 | QQQ | ETF | 42.27 | 42.33 | 42.21 | 42.26 | 7232300.0 |
| 2006-10-13 10:30:00 | QQQ | ETF | 42.27 | 42.38 | 42.25 | 42.33 | 6365100.0 |
| 2006-10-13 11:00:00 | QQQ | ETF | 42.33 | 42.35 | 42.24 | 42.28 | 6675300.0 |
| 2006-10-13 11:30:00 | QQQ | ETF | 42.28 | 42.33 | 42.25 | 42.3 | 2605100.0 |
| 2006-10-13 12:00:00 | QQQ | ETF | 42.3 | 42.36 | 42.28 | 42.35 | 1751400.0 |
| 2006-10-13 12:30:00 | QQQ | ETF | 42.35 | 42.43 | 42.34 | 42.4 | 3476200.0 |
| 2006-10-13 13:00:00 | QQQ | ETF | 42.4 | 42.47 | 42.38 | 42.46 | 3290300.0 |
| 2006-10-13 13:30:00 | QQQ | ETF | 42.47 | 42.52 | 42.44 | 42.46 | 5525400.0 |
| 2006-10-13 14:00:00 | QQQ | ETF | 42.46 | 42.5 | 42.4 | 42.41 | 3482900.0 |
| 2006-10-13 14:30:00 | QQQ | ETF | 42.41 | 42.42 | 42.32 | 42.37 | 6337600.0 |
| 2006-10-13 15:00:00 | QQQ | ETF | 42.36 | 42.44 | 42.35 | 42.41 | 3870200.0 |
| 2006-10-13 15:30:00 | QQQ | ETF | 42.41 | 42.46 | 42.35 | 42.42 | 7568500.0 |
| 2006-10-13 07:00:00 | IWM | ETF | 75.0 | 75.0 | 75.0 | 75.0 | 700.0 |
| 2006-10-13 08:00:00 | IWM | ETF | 75.25 | 75.3 | 75.24 | 75.24 | 4500.0 |
| 2006-10-13 08:30:00 | IWM | ETF | 75.3 | 75.3 | 75.18 | 75.22 | 75400.0 |
| 2006-10-13 09:00:00 | IWM | ETF | 75.24 | 75.36 | 75.24 | 75.3 | 100400.0 |
| 2006-10-13 09:30:00 | IWM | ETF | 75.3 | 75.51 | 75.13 | 75.37 | 5633100.0 |
| 2006-10-13 10:00:00 | IWM | ETF | 75.37 | 75.64 | 75.31 | 75.51 | 4973700.0 |
| 2006-10-13 10:30:00 | IWM | ETF | 75.51 | 75.79 | 75.5 | 75.68 | 5727900.0 |
| 2006-10-13 11:00:00 | IWM | ETF | 75.68 | 75.71 | 75.46 | 75.51 | 4263800.0 |
| 2006-10-13 11:30:00 | IWM | ETF | 75.51 | 75.69 | 75.46 | 75.57 | 3588100.0 |
| 2006-10-13 12:00:00 | IWM | ETF | 75.57 | 75.71 | 75.52 | 75.66 | 1507700.0 |
> showing 50 of 2,979 rows — these rows as CSV