PREVIEW / etf_30min / 2006-10-11
file: by_date/etf_30min/2006/2006-10-11.parquet size: 82 KB rows: 2,909
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-11 07:00:00 | SPY | ETF | 134.95 | 134.97 | 134.85 | 134.85 | 83100.0 |
| 2006-10-11 07:30:00 | SPY | ETF | 134.85 | 134.92 | 134.85 | 134.88 | 43600.0 |
| 2006-10-11 08:00:00 | SPY | ETF | 134.89 | 134.98 | 134.82 | 134.84 | 1491100.0 |
| 2006-10-11 08:30:00 | SPY | ETF | 134.84 | 135.3446 | 134.84 | 134.92 | 1791700.0 |
| 2006-10-11 09:00:00 | SPY | ETF | 134.92 | 134.95 | 134.83 | 134.85 | 415900.0 |
| 2006-10-11 09:30:00 | SPY | ETF | 134.84 | 134.92 | 134.76 | 134.86 | 5841000.0 |
| 2006-10-11 10:00:00 | SPY | ETF | 134.87 | 135.02 | 134.8 | 134.93 | 4536900.0 |
| 2006-10-11 10:30:00 | SPY | ETF | 134.93 | 135.12 | 134.88 | 135.02 | 6863700.0 |
| 2006-10-11 11:00:00 | SPY | ETF | 135.03 | 135.12 | 134.97 | 135.05 | 3376700.0 |
| 2006-10-11 11:30:00 | SPY | ETF | 135.05 | 135.24 | 135.0 | 135.16 | 3976100.0 |
| 2006-10-11 12:00:00 | SPY | ETF | 135.16 | 135.23 | 135.03 | 135.11 | 3258200.0 |
| 2006-10-11 12:30:00 | SPY | ETF | 135.1 | 135.35 | 135.05 | 135.25 | 3681900.0 |
| 2006-10-11 13:00:00 | SPY | ETF | 135.25 | 135.43 | 135.24 | 135.28 | 2448300.0 |
| 2006-10-11 13:30:00 | SPY | ETF | 135.27 | 135.31 | 135.12 | 135.2 | 4905400.0 |
| 2006-10-11 14:00:00 | SPY | ETF | 135.2 | 135.23 | 134.84 | 134.94 | 9374700.0 |
| 2006-10-11 14:30:00 | SPY | ETF | 134.94 | 134.97 | 134.3 | 134.76 | 19580700.0 |
| 2006-10-11 15:00:00 | SPY | ETF | 134.76 | 135.05 | 134.61 | 134.91 | 13592300.0 |
| 2006-10-11 15:30:00 | SPY | ETF | 134.91 | 135.07 | 134.9 | 134.99 | 5530600.0 |
| 2006-10-11 16:00:00 | SPY | ETF | 134.99 | 135.361 | 134.97 | 135.12 | 2450800.0 |
| 2006-10-11 16:30:00 | SPY | ETF | 135.1 | 135.15 | 135.07 | 135.14 | 3812600.0 |
| 2006-10-11 17:00:00 | SPY | ETF | 135.15 | 135.16 | 135.11 | 135.11 | 1186300.0 |
| 2006-10-11 17:30:00 | SPY | ETF | 135.11 | 135.17 | 135.1 | 135.1 | 61000.0 |
| 2006-10-11 18:00:00 | SPY | ETF | 135.12 | 135.15 | 135.1 | 135.15 | 7700.0 |
| 2006-10-11 18:30:00 | SPY | ETF | 135.14 | 135.15 | 135.14 | 135.15 | 1500.0 |
| 2006-10-11 19:00:00 | SPY | ETF | 135.14 | 135.14 | 135.14 | 135.14 | 500.0 |
| 2006-10-11 19:30:00 | SPY | ETF | 135.1 | 135.12 | 135.1 | 135.1 | 800.0 |
| 2006-10-11 09:30:00 | QQQ | ETF | 41.43 | 41.48 | 41.37 | 41.45 | 9743700.0 |
| 2006-10-11 10:00:00 | QQQ | ETF | 41.45 | 41.56 | 41.4 | 41.52 | 7825100.0 |
| 2006-10-11 10:30:00 | QQQ | ETF | 41.51 | 41.63 | 41.46 | 41.58 | 6812600.0 |
| 2006-10-11 11:00:00 | QQQ | ETF | 41.58 | 41.65 | 41.57 | 41.63 | 4150200.0 |
| 2006-10-11 11:30:00 | QQQ | ETF | 41.63 | 41.78 | 41.6 | 41.7 | 8838500.0 |
| 2006-10-11 12:00:00 | QQQ | ETF | 41.7 | 41.75 | 41.65 | 41.67 | 4099900.0 |
| 2006-10-11 12:30:00 | QQQ | ETF | 41.66 | 41.79 | 41.65 | 41.75 | 6254900.0 |
| 2006-10-11 13:00:00 | QQQ | ETF | 41.75 | 41.83 | 41.74 | 41.75 | 2765100.0 |
| 2006-10-11 13:30:00 | QQQ | ETF | 41.75 | 41.76 | 41.68 | 41.73 | 2706900.0 |
| 2006-10-11 14:00:00 | QQQ | ETF | 41.74 | 41.75 | 41.5 | 41.55 | 17066900.0 |
| 2006-10-11 14:30:00 | QQQ | ETF | 41.55 | 41.58 | 41.17 | 41.41 | 34517800.0 |
| 2006-10-11 15:00:00 | QQQ | ETF | 41.41 | 41.6 | 41.33 | 41.5 | 15057300.0 |
| 2006-10-11 15:30:00 | QQQ | ETF | 41.51 | 41.59 | 41.5 | 41.53 | 6281800.0 |
| 2006-10-11 08:00:00 | IWM | ETF | 73.8 | 73.8 | 73.66 | 73.78 | 239200.0 |
| 2006-10-11 08:30:00 | IWM | ETF | 73.78 | 73.8 | 73.76 | 73.79 | 172400.0 |
| 2006-10-11 09:00:00 | IWM | ETF | 73.78 | 73.89 | 73.77 | 73.78 | 262700.0 |
| 2006-10-11 09:30:00 | IWM | ETF | 73.78 | 73.89 | 73.55 | 73.83 | 2936400.0 |
| 2006-10-11 10:00:00 | IWM | ETF | 73.84 | 73.95 | 73.71 | 73.79 | 2102800.0 |
| 2006-10-11 10:30:00 | IWM | ETF | 73.7925 | 73.98 | 73.69 | 73.82 | 1941200.0 |
| 2006-10-11 11:00:00 | IWM | ETF | 73.82 | 73.95 | 73.78 | 73.92 | 1180700.0 |
| 2006-10-11 11:30:00 | IWM | ETF | 73.92 | 74.17 | 73.87 | 74.08 | 2174900.0 |
| 2006-10-11 12:00:00 | IWM | ETF | 74.08 | 74.09 | 73.9 | 73.96 | 822900.0 |
| 2006-10-11 12:30:00 | IWM | ETF | 73.96 | 74.24 | 73.93 | 74.15 | 1549800.0 |
| 2006-10-11 13:00:00 | IWM | ETF | 74.15 | 74.29 | 74.09 | 74.1 | 2528000.0 |
> showing 50 of 2,909 rows — these rows as CSV