PREVIEW / etf_30min / 2006-03-16
file: by_date/etf_30min/2006/2006-03-16.parquet size: 61 KB rows: 2,201
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-16 05:30:00 | SPY | ETF | 130.52 | 130.52 | 130.52 | 130.52 | 5500.0 |
| 2006-03-16 06:30:00 | SPY | ETF | 130.6 | 130.6 | 130.6 | 130.6 | 3000.0 |
| 2006-03-16 07:00:00 | SPY | ETF | 130.56 | 130.57 | 130.56 | 130.57 | 5100.0 |
| 2006-03-16 07:30:00 | SPY | ETF | 130.56 | 130.61 | 130.56 | 130.61 | 7000.0 |
| 2006-03-16 08:00:00 | SPY | ETF | 130.62 | 130.69 | 130.55 | 130.56 | 218800.0 |
| 2006-03-16 08:30:00 | SPY | ETF | 130.64 | 131.1 | 130.54 | 131.07 | 2504000.0 |
| 2006-03-16 09:00:00 | SPY | ETF | 131.06 | 131.11 | 130.46 | 130.98 | 537300.0 |
| 2006-03-16 09:30:00 | SPY | ETF | 130.98 | 131.05 | 130.89 | 130.97 | 6171000.0 |
| 2006-03-16 10:00:00 | SPY | ETF | 130.98 | 131.3 | 130.96 | 131.08 | 6512400.0 |
| 2006-03-16 10:30:00 | SPY | ETF | 131.08 | 131.22 | 130.84 | 130.96 | 5207100.0 |
| 2006-03-16 11:00:00 | SPY | ETF | 130.97 | 131.18 | 130.95 | 131.16 | 3106700.0 |
| 2006-03-16 11:30:00 | SPY | ETF | 131.16 | 131.21 | 131.07 | 131.15 | 1888500.0 |
| 2006-03-16 12:00:00 | SPY | ETF | 131.16 | 131.43 | 131.05 | 131.41 | 4880700.0 |
| 2006-03-16 12:30:00 | SPY | ETF | 131.42 | 131.47 | 131.33 | 131.33 | 3268900.0 |
| 2006-03-16 13:00:00 | SPY | ETF | 131.34 | 131.34 | 131.01 | 131.18 | 4607000.0 |
| 2006-03-16 13:30:00 | SPY | ETF | 131.1899 | 131.25 | 130.95 | 130.99 | 3966400.0 |
| 2006-03-16 14:00:00 | SPY | ETF | 130.99 | 131.25 | 130.98 | 131.2 | 2868900.0 |
| 2006-03-16 14:30:00 | SPY | ETF | 131.21 | 131.22 | 130.87 | 130.95 | 4346700.0 |
| 2006-03-16 15:00:00 | SPY | ETF | 130.95 | 131.19 | 130.93 | 131.05 | 3842900.0 |
| 2006-03-16 15:30:00 | SPY | ETF | 131.05 | 131.18 | 130.96 | 131.01 | 5524100.0 |
| 2006-03-16 16:00:00 | SPY | ETF | 131.0 | 131.05 | 130.92 | 130.96 | 2433900.0 |
| 2006-03-16 16:30:00 | SPY | ETF | 130.97 | 131.03 | 130.92 | 131.03 | 1806600.0 |
| 2006-03-16 17:00:00 | SPY | ETF | 130.97 | 130.97 | 130.9 | 130.9 | 78700.0 |
| 2006-03-16 17:30:00 | SPY | ETF | 130.92 | 130.92 | 130.92 | 130.92 | 800.0 |
| 2006-03-16 18:00:00 | SPY | ETF | 130.91 | 130.95 | 130.89 | 130.94 | 1555700.0 |
| 2006-03-16 18:30:00 | SPY | ETF | 130.95 | 130.97 | 130.95 | 130.97 | 1500.0 |
| 2006-03-16 19:00:00 | SPY | ETF | 130.94 | 130.97 | 130.9 | 130.9 | 700.0 |
| 2006-03-16 19:30:00 | SPY | ETF | 130.92 | 130.93 | 130.92 | 130.93 | 2200.0 |
| 2006-03-16 09:30:00 | QQQ | ETF | 41.85 | 41.88 | 41.77 | 41.78 | 9371100.0 |
| 2006-03-16 10:00:00 | QQQ | ETF | 41.78 | 41.92 | 41.71 | 41.76 | 10365600.0 |
| 2006-03-16 10:30:00 | QQQ | ETF | 41.76 | 41.84 | 41.62 | 41.69 | 10105200.0 |
| 2006-03-16 11:00:00 | QQQ | ETF | 41.68 | 41.78 | 41.67 | 41.78 | 6593300.0 |
| 2006-03-16 11:30:00 | QQQ | ETF | 41.78 | 41.8 | 41.74 | 41.76 | 2249000.0 |
| 2006-03-16 12:00:00 | QQQ | ETF | 41.75 | 41.88 | 41.73 | 41.88 | 4485000.0 |
| 2006-03-16 12:30:00 | QQQ | ETF | 41.87 | 41.88 | 41.78 | 41.78 | 3996600.0 |
| 2006-03-16 13:00:00 | QQQ | ETF | 41.79 | 41.79 | 41.63 | 41.72 | 6427900.0 |
| 2006-03-16 13:30:00 | QQQ | ETF | 41.72 | 41.77 | 41.55 | 41.56 | 7707600.0 |
| 2006-03-16 14:00:00 | QQQ | ETF | 41.57 | 41.69 | 41.56 | 41.64 | 4757100.0 |
| 2006-03-16 14:30:00 | QQQ | ETF | 41.64 | 41.64 | 41.39 | 41.41 | 8998100.0 |
| 2006-03-16 15:00:00 | QQQ | ETF | 41.41 | 41.53 | 41.39 | 41.44 | 7441100.0 |
| 2006-03-16 15:30:00 | QQQ | ETF | 41.45 | 41.53 | 41.33 | 41.36 | 7005600.0 |
| 2006-03-16 08:00:00 | IWM | ETF | 73.88 | 73.91 | 73.88 | 73.91 | 220000.0 |
| 2006-03-16 08:30:00 | IWM | ETF | 74.05 | 74.22 | 74.04 | 74.18 | 146700.0 |
| 2006-03-16 09:00:00 | IWM | ETF | 74.2 | 74.22 | 74.17 | 74.21 | 71600.0 |
| 2006-03-16 09:30:00 | IWM | ETF | 74.2 | 74.31 | 74.03 | 74.17 | 4368400.0 |
| 2006-03-16 10:00:00 | IWM | ETF | 74.17 | 74.39 | 74.09 | 74.13 | 2242700.0 |
| 2006-03-16 10:30:00 | IWM | ETF | 74.14 | 74.23 | 73.88 | 73.97 | 2909800.0 |
| 2006-03-16 11:00:00 | IWM | ETF | 73.97 | 74.22 | 73.93 | 74.17 | 1724000.0 |
| 2006-03-16 11:30:00 | IWM | ETF | 74.18 | 74.27 | 74.16 | 74.21 | 853500.0 |
| 2006-03-16 12:00:00 | IWM | ETF | 74.21 | 74.48 | 74.19 | 74.46 | 1453300.0 |
> showing 50 of 2,201 rows — these rows as CSV