PREVIEW / etf_30min / 2006-10-18
file: by_date/etf_30min/2006/2006-10-18.parquet size: 85 KB rows: 2,975
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-18 07:00:00 | SPY | ETF | 136.59 | 136.59 | 136.56 | 136.56 | 50200.0 |
| 2006-10-18 07:30:00 | SPY | ETF | 136.54 | 136.64 | 136.52 | 136.64 | 88600.0 |
| 2006-10-18 08:00:00 | SPY | ETF | 136.6 | 136.63 | 136.52 | 136.59 | 1029100.0 |
| 2006-10-18 08:30:00 | SPY | ETF | 136.58 | 137.07 | 136.58 | 137.05 | 6603900.0 |
| 2006-10-18 09:00:00 | SPY | ETF | 137.05 | 137.11 | 137.02 | 137.06 | 1463900.0 |
| 2006-10-18 09:30:00 | SPY | ETF | 137.04 | 137.37 | 137.02 | 137.06 | 10845500.0 |
| 2006-10-18 10:00:00 | SPY | ETF | 137.04 | 137.09 | 136.58 | 136.74 | 10319100.0 |
| 2006-10-18 10:30:00 | SPY | ETF | 136.74 | 136.82 | 136.33 | 136.61 | 13262500.0 |
| 2006-10-18 11:00:00 | SPY | ETF | 136.61 | 136.83 | 136.47 | 136.73 | 6026200.0 |
| 2006-10-18 11:30:00 | SPY | ETF | 136.72 | 136.91 | 136.65 | 136.73 | 3427600.0 |
| 2006-10-18 12:00:00 | SPY | ETF | 136.72 | 136.78 | 136.64 | 136.74 | 1895000.0 |
| 2006-10-18 12:30:00 | SPY | ETF | 136.73 | 136.78 | 136.56 | 136.61 | 2270100.0 |
| 2006-10-18 13:00:00 | SPY | ETF | 136.59 | 136.66 | 136.17 | 136.19 | 6500600.0 |
| 2006-10-18 13:30:00 | SPY | ETF | 136.19 | 136.36 | 136.1 | 136.33 | 4675600.0 |
| 2006-10-18 14:00:00 | SPY | ETF | 136.33 | 136.69 | 136.2 | 136.56 | 5276400.0 |
| 2006-10-18 14:30:00 | SPY | ETF | 136.58 | 136.7 | 136.5 | 136.63 | 2791100.0 |
| 2006-10-18 15:00:00 | SPY | ETF | 136.62 | 136.66 | 136.4 | 136.46 | 3422700.0 |
| 2006-10-18 15:30:00 | SPY | ETF | 136.46 | 136.66 | 136.44 | 136.59 | 4470300.0 |
| 2006-10-18 16:00:00 | SPY | ETF | 136.59 | 136.63 | 136.47 | 136.59 | 826000.0 |
| 2006-10-18 16:30:00 | SPY | ETF | 136.61 | 136.72 | 136.56 | 136.56 | 322100.0 |
| 2006-10-18 17:00:00 | SPY | ETF | 136.57 | 136.58 | 136.5 | 136.54 | 45700.0 |
| 2006-10-18 17:30:00 | SPY | ETF | 136.5 | 136.5 | 136.43 | 136.43 | 121100.0 |
| 2006-10-18 18:00:00 | SPY | ETF | 136.45 | 136.46 | 136.4 | 136.4 | 512200.0 |
| 2006-10-18 18:30:00 | SPY | ETF | 136.39 | 136.39 | 136.34 | 136.37 | 3300.0 |
| 2006-10-18 19:00:00 | SPY | ETF | 136.39 | 136.39 | 136.39 | 136.39 | 1500.0 |
| 2006-10-18 19:30:00 | SPY | ETF | 136.43 | 136.43 | 136.43 | 136.43 | 7900.0 |
| 2006-10-18 09:30:00 | QQQ | ETF | 42.22 | 42.31 | 42.08 | 42.09 | 15712600.0 |
| 2006-10-18 10:00:00 | QQQ | ETF | 42.1 | 42.12 | 41.88 | 41.94 | 17185800.0 |
| 2006-10-18 10:30:00 | QQQ | ETF | 41.94 | 41.99 | 41.71 | 41.83 | 14227200.0 |
| 2006-10-18 11:00:00 | QQQ | ETF | 41.84 | 41.94 | 41.75 | 41.87 | 9254500.0 |
| 2006-10-18 11:30:00 | QQQ | ETF | 41.87 | 41.96 | 41.84 | 41.88 | 5141300.0 |
| 2006-10-18 12:00:00 | QQQ | ETF | 41.89 | 41.91 | 41.83 | 41.88 | 3334300.0 |
| 2006-10-18 12:30:00 | QQQ | ETF | 41.89 | 41.91 | 41.83 | 41.85 | 2134000.0 |
| 2006-10-18 13:00:00 | QQQ | ETF | 41.86 | 41.9 | 41.68 | 41.68 | 5576800.0 |
| 2006-10-18 13:30:00 | QQQ | ETF | 41.69 | 41.78 | 41.65 | 41.77 | 7555800.0 |
| 2006-10-18 14:00:00 | QQQ | ETF | 41.77 | 41.93 | 41.69 | 41.87 | 10229800.0 |
| 2006-10-18 14:30:00 | QQQ | ETF | 41.87 | 41.91 | 41.78 | 41.83 | 4436400.0 |
| 2006-10-18 15:00:00 | QQQ | ETF | 41.84 | 41.86 | 41.73 | 41.75 | 3860200.0 |
| 2006-10-18 15:30:00 | QQQ | ETF | 41.76 | 41.83 | 41.74 | 41.8 | 5543200.0 |
| 2006-10-18 07:30:00 | IWM | ETF | 76.1 | 76.1 | 76.1 | 76.1 | 100.0 |
| 2006-10-18 08:00:00 | IWM | ETF | 76.17 | 76.19 | 75.97 | 76.13 | 907900.0 |
| 2006-10-18 08:30:00 | IWM | ETF | 76.2 | 76.56 | 76.2 | 76.48 | 1649800.0 |
| 2006-10-18 09:00:00 | IWM | ETF | 76.47 | 76.52 | 76.43 | 76.52 | 1308600.0 |
| 2006-10-18 09:30:00 | IWM | ETF | 76.52 | 76.8 | 76.4 | 76.41 | 5299700.0 |
| 2006-10-18 10:00:00 | IWM | ETF | 76.41 | 76.41 | 76.05 | 76.15 | 5947500.0 |
| 2006-10-18 10:30:00 | IWM | ETF | 76.15 | 76.22 | 75.86 | 76.07 | 2958000.0 |
| 2006-10-18 11:00:00 | IWM | ETF | 76.07 | 76.37 | 75.92 | 76.27 | 5582800.0 |
| 2006-10-18 11:30:00 | IWM | ETF | 76.28 | 76.4 | 76.15 | 76.25 | 2258300.0 |
| 2006-10-18 12:00:00 | IWM | ETF | 76.25 | 76.36 | 76.15 | 76.23 | 1886100.0 |
| 2006-10-18 12:30:00 | IWM | ETF | 76.24 | 76.58 | 75.99 | 76.0 | 1674800.0 |
> showing 50 of 2,975 rows — these rows as CSV