PREVIEW / etf_30min / 2006-12-22
file: by_date/etf_30min/2006/2006-12-22.parquet size: 87 KB rows: 3,059
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-12-22 04:00:00 | SPY | ETF | 141.7 | 141.7 | 141.7 | 141.7 | 2700.0 |
| 2006-12-22 05:00:00 | SPY | ETF | 141.69 | 141.69 | 141.69 | 141.69 | 1600.0 |
| 2006-12-22 07:30:00 | SPY | ETF | 141.76 | 141.76 | 141.76 | 141.76 | 2900.0 |
| 2006-12-22 08:00:00 | SPY | ETF | 141.67 | 141.78 | 141.66 | 141.72 | 391200.0 |
| 2006-12-22 08:30:00 | SPY | ETF | 141.68 | 141.82 | 141.55 | 141.74 | 917900.0 |
| 2006-12-22 09:00:00 | SPY | ETF | 141.76 | 141.78 | 141.62 | 141.62 | 943200.0 |
| 2006-12-22 09:30:00 | SPY | ETF | 141.64 | 141.65 | 140.92 | 141.17 | 12994700.0 |
| 2006-12-22 10:00:00 | SPY | ETF | 141.17 | 141.5 | 141.01 | 141.44 | 6418900.0 |
| 2006-12-22 10:30:00 | SPY | ETF | 141.45 | 141.49 | 141.23 | 141.25 | 4695300.0 |
| 2006-12-22 11:00:00 | SPY | ETF | 141.27 | 141.31 | 140.99 | 141.05 | 3685300.0 |
| 2006-12-22 11:30:00 | SPY | ETF | 141.06 | 141.16 | 140.92 | 140.93 | 2974800.0 |
| 2006-12-22 12:00:00 | SPY | ETF | 140.93 | 141.29 | 140.78 | 140.87 | 5252700.0 |
| 2006-12-22 12:30:00 | SPY | ETF | 140.86 | 141.08 | 140.81 | 140.98 | 5373600.0 |
| 2006-12-22 13:00:00 | SPY | ETF | 140.97 | 140.98 | 140.8 | 140.82 | 1723800.0 |
| 2006-12-22 13:30:00 | SPY | ETF | 140.82 | 141.06 | 140.8 | 141.04 | 1342700.0 |
| 2006-12-22 14:00:00 | SPY | ETF | 141.04 | 141.11 | 140.95 | 141.0 | 1409800.0 |
| 2006-12-22 14:30:00 | SPY | ETF | 141.0 | 141.1 | 140.94 | 141.06 | 1569000.0 |
| 2006-12-22 15:00:00 | SPY | ETF | 141.05 | 141.2 | 141.03 | 141.11 | 2156500.0 |
| 2006-12-22 15:30:00 | SPY | ETF | 141.11 | 141.16 | 140.85 | 140.85 | 4769100.0 |
| 2006-12-22 16:00:00 | SPY | ETF | 140.83 | 140.9 | 140.65 | 140.67 | 1633700.0 |
| 2006-12-22 16:30:00 | SPY | ETF | 140.67 | 140.9303 | 140.65 | 140.73 | 2513200.0 |
| 2006-12-22 17:00:00 | SPY | ETF | 140.71 | 140.71 | 140.68 | 140.7 | 14900.0 |
| 2006-12-22 17:30:00 | SPY | ETF | 140.7 | 140.7 | 140.7 | 140.7 | 600.0 |
| 2006-12-22 18:00:00 | SPY | ETF | 140.67 | 140.67 | 140.67 | 140.67 | 3900.0 |
| 2006-12-22 18:30:00 | SPY | ETF | 140.7 | 140.7 | 140.68 | 140.7 | 300.0 |
| 2006-12-22 19:30:00 | SPY | ETF | 140.68 | 140.74 | 140.68 | 140.74 | 900.0 |
| 2006-12-22 09:30:00 | QQQ | ETF | 43.38 | 43.41 | 43.04 | 43.21 | 20961100.0 |
| 2006-12-22 10:00:00 | QQQ | ETF | 43.19 | 43.39 | 43.14 | 43.35 | 12413100.0 |
| 2006-12-22 10:30:00 | QQQ | ETF | 43.35 | 43.37 | 43.14 | 43.16 | 6675500.0 |
| 2006-12-22 11:00:00 | QQQ | ETF | 43.16 | 43.22 | 43.06 | 43.09 | 7999000.0 |
| 2006-12-22 11:30:00 | QQQ | ETF | 43.1 | 43.18 | 43.05 | 43.05 | 4868600.0 |
| 2006-12-22 12:00:00 | QQQ | ETF | 43.05 | 43.05 | 42.95 | 43.01 | 9775100.0 |
| 2006-12-22 12:30:00 | QQQ | ETF | 43.0 | 43.1 | 42.98 | 43.06 | 2780400.0 |
| 2006-12-22 13:00:00 | QQQ | ETF | 43.06 | 43.07 | 42.99 | 43.01 | 2053700.0 |
| 2006-12-22 13:30:00 | QQQ | ETF | 43.02 | 43.11 | 43.0 | 43.07 | 3469400.0 |
| 2006-12-22 14:00:00 | QQQ | ETF | 43.07 | 43.13 | 43.0 | 43.07 | 2969700.0 |
| 2006-12-22 14:30:00 | QQQ | ETF | 43.07 | 43.1 | 43.04 | 43.08 | 2061000.0 |
| 2006-12-22 15:00:00 | QQQ | ETF | 43.08 | 43.17 | 43.04 | 43.07 | 4760000.0 |
| 2006-12-22 15:30:00 | QQQ | ETF | 43.07 | 43.98 | 42.95 | 42.95 | 6092400.0 |
| 2006-12-22 08:00:00 | IWM | ETF | 77.69 | 77.69 | 77.62 | 77.62 | 4200.0 |
| 2006-12-22 08:30:00 | IWM | ETF | 77.58 | 77.67 | 77.58 | 77.67 | 24100.0 |
| 2006-12-22 09:00:00 | IWM | ETF | 77.67 | 77.7 | 77.6 | 77.6 | 82100.0 |
| 2006-12-22 09:30:00 | IWM | ETF | 77.59 | 77.61 | 77.05 | 77.4 | 6952100.0 |
| 2006-12-22 10:00:00 | IWM | ETF | 77.4 | 77.71 | 77.28 | 77.7 | 5312200.0 |
| 2006-12-22 10:30:00 | IWM | ETF | 77.71 | 77.75 | 77.48 | 77.49 | 2309100.0 |
| 2006-12-22 11:00:00 | IWM | ETF | 77.49 | 77.56 | 77.31 | 77.38 | 2275800.0 |
| 2006-12-22 11:30:00 | IWM | ETF | 77.38 | 77.45 | 77.29 | 77.29 | 1524800.0 |
| 2006-12-22 12:00:00 | IWM | ETF | 77.28 | 77.38 | 77.24 | 77.34 | 1502200.0 |
| 2006-12-22 12:30:00 | IWM | ETF | 77.33 | 77.49 | 77.28 | 77.35 | 2259700.0 |
| 2006-12-22 13:00:00 | IWM | ETF | 77.36 | 77.4 | 77.28 | 77.3 | 619500.0 |
> showing 50 of 3,059 rows — these rows as CSV