PREVIEW / etf_30min / 2006-03-29
file: by_date/etf_30min/2006/2006-03-29.parquet size: 61 KB rows: 2,202
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-03-29 04:00:00 | SPY | ETF | 129.49 | 129.49 | 129.49 | 129.49 | 1500.0 |
| 2006-03-29 04:30:00 | SPY | ETF | 129.57 | 129.57 | 129.57 | 129.57 | 100.0 |
| 2006-03-29 06:30:00 | SPY | ETF | 129.45 | 129.45 | 129.45 | 129.45 | 100.0 |
| 2006-03-29 07:00:00 | SPY | ETF | 129.44 | 129.56 | 129.44 | 129.49 | 12700.0 |
| 2006-03-29 07:30:00 | SPY | ETF | 129.49 | 129.53 | 129.44 | 129.49 | 70800.0 |
| 2006-03-29 08:00:00 | SPY | ETF | 129.51 | 129.54 | 129.42 | 129.5 | 634200.0 |
| 2006-03-29 08:30:00 | SPY | ETF | 129.51 | 129.55 | 129.48 | 129.5 | 824500.0 |
| 2006-03-29 09:00:00 | SPY | ETF | 129.53 | 129.54 | 129.39 | 129.41 | 466000.0 |
| 2006-03-29 09:30:00 | SPY | ETF | 129.41 | 129.6 | 129.31 | 129.39 | 5352800.0 |
| 2006-03-29 10:00:00 | SPY | ETF | 129.39 | 129.68 | 129.29 | 129.62 | 4714000.0 |
| 2006-03-29 10:30:00 | SPY | ETF | 129.65 | 129.71 | 129.42 | 129.5 | 4105900.0 |
| 2006-03-29 11:00:00 | SPY | ETF | 129.5 | 130.01 | 129.43 | 130.0 | 6007600.0 |
| 2006-03-29 11:30:00 | SPY | ETF | 130.0 | 130.27 | 129.98 | 130.11 | 7261600.0 |
| 2006-03-29 12:00:00 | SPY | ETF | 130.11 | 130.25 | 130.1 | 130.16 | 3582500.0 |
| 2006-03-29 12:30:00 | SPY | ETF | 130.15 | 130.21 | 130.06 | 130.09 | 2092400.0 |
| 2006-03-29 13:00:00 | SPY | ETF | 130.1 | 130.5 | 130.03 | 130.31 | 4345100.0 |
| 2006-03-29 13:30:00 | SPY | ETF | 130.32 | 130.35 | 130.15 | 130.28 | 1950000.0 |
| 2006-03-29 14:00:00 | SPY | ETF | 130.27 | 130.43 | 130.12 | 130.19 | 3171000.0 |
| 2006-03-29 14:30:00 | SPY | ETF | 130.19 | 130.35 | 130.06 | 130.28 | 3467700.0 |
| 2006-03-29 15:00:00 | SPY | ETF | 130.27 | 130.48 | 130.21 | 130.42 | 3247900.0 |
| 2006-03-29 15:30:00 | SPY | ETF | 130.42 | 130.46 | 130.16 | 130.21 | 4673700.0 |
| 2006-03-29 16:00:00 | SPY | ETF | 130.21 | 130.22 | 130.0 | 130.06 | 1573500.0 |
| 2006-03-29 16:30:00 | SPY | ETF | 130.05 | 130.05 | 130.01 | 130.04 | 40300.0 |
| 2006-03-29 17:00:00 | SPY | ETF | 130.05 | 130.08 | 130.01 | 130.03 | 65200.0 |
| 2006-03-29 17:30:00 | SPY | ETF | 130.06 | 130.08 | 130.0 | 130.0 | 4800.0 |
| 2006-03-29 18:00:00 | SPY | ETF | 130.0 | 130.05 | 129.98 | 130.05 | 24300.0 |
| 2006-03-29 18:30:00 | SPY | ETF | 130.05 | 130.05 | 130.0 | 130.0 | 1900.0 |
| 2006-03-29 19:00:00 | SPY | ETF | 130.0 | 130.0 | 130.0 | 130.0 | 500.0 |
| 2006-03-29 19:30:00 | SPY | ETF | 130.05 | 130.06 | 130.05 | 130.06 | 2900.0 |
| 2006-03-29 09:30:00 | QQQ | ETF | 41.2 | 41.28 | 41.17 | 41.22 | 8246400.0 |
| 2006-03-29 10:00:00 | QQQ | ETF | 41.22 | 41.46 | 41.18 | 41.42 | 11374500.0 |
| 2006-03-29 10:30:00 | QQQ | ETF | 41.43 | 41.46 | 41.32 | 41.36 | 5581000.0 |
| 2006-03-29 11:00:00 | QQQ | ETF | 41.36 | 41.66 | 41.35 | 41.65 | 14755800.0 |
| 2006-03-29 11:30:00 | QQQ | ETF | 41.65 | 41.78 | 41.57 | 41.73 | 10194400.0 |
| 2006-03-29 12:00:00 | QQQ | ETF | 41.73 | 41.78 | 41.55 | 41.73 | 5147800.0 |
| 2006-03-29 12:30:00 | QQQ | ETF | 41.73 | 41.79 | 41.71 | 41.73 | 4303400.0 |
| 2006-03-29 13:00:00 | QQQ | ETF | 41.73 | 41.94 | 41.72 | 41.88 | 14301700.0 |
| 2006-03-29 13:30:00 | QQQ | ETF | 41.87 | 41.9 | 41.8 | 41.88 | 6747000.0 |
| 2006-03-29 14:00:00 | QQQ | ETF | 41.87 | 42.1 | 41.86 | 41.91 | 19462400.0 |
| 2006-03-29 14:30:00 | QQQ | ETF | 41.91 | 41.95 | 41.83 | 41.91 | 6178800.0 |
| 2006-03-29 15:00:00 | QQQ | ETF | 41.91 | 42.06 | 41.91 | 42.05 | 8220600.0 |
| 2006-03-29 15:30:00 | QQQ | ETF | 42.04 | 42.06 | 41.82 | 41.9 | 13138300.0 |
| 2006-03-29 08:00:00 | IWM | ETF | 75.3 | 75.3 | 74.63 | 74.76 | 201800.0 |
| 2006-03-29 08:30:00 | IWM | ETF | 74.73 | 74.73 | 74.68 | 74.72 | 10500.0 |
| 2006-03-29 09:00:00 | IWM | ETF | 74.73 | 74.74 | 74.65 | 74.66 | 34500.0 |
| 2006-03-29 09:30:00 | IWM | ETF | 74.66 | 74.9 | 74.66 | 74.81 | 2517800.0 |
| 2006-03-29 10:00:00 | IWM | ETF | 74.81 | 75.05 | 74.69 | 75.02 | 1838900.0 |
| 2006-03-29 10:30:00 | IWM | ETF | 75.01 | 75.15 | 74.92 | 75.02 | 1863600.0 |
| 2006-03-29 11:00:00 | IWM | ETF | 75.0494 | 75.56 | 74.98 | 75.55 | 4046600.0 |
| 2006-03-29 11:30:00 | IWM | ETF | 75.56 | 75.59 | 75.5 | 75.57 | 2307300.0 |
> showing 50 of 2,202 rows — these rows as CSV