PREVIEW / etf_30min / 2006-02-22
file: by_date/etf_30min/2006/2006-02-22.parquet size: 60 KB rows: 2,175
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-02-22 06:00:00 | SPY | ETF | 128.41 | 128.41 | 128.41 | 128.41 | 2000.0 |
| 2006-02-22 07:00:00 | SPY | ETF | 128.63 | 128.63 | 128.63 | 128.63 | 100.0 |
| 2006-02-22 07:30:00 | SPY | ETF | 128.66 | 128.71 | 128.66 | 128.71 | 18200.0 |
| 2006-02-22 08:00:00 | SPY | ETF | 128.44 | 128.71 | 128.44 | 128.57 | 639600.0 |
| 2006-02-22 08:30:00 | SPY | ETF | 128.57 | 128.835 | 128.5 | 128.8 | 1267700.0 |
| 2006-02-22 09:00:00 | SPY | ETF | 128.8 | 128.81 | 128.73 | 128.78 | 137900.0 |
| 2006-02-22 09:30:00 | SPY | ETF | 128.77 | 128.96 | 128.67 | 128.7612 | 4862800.0 |
| 2006-02-22 10:00:00 | SPY | ETF | 128.78 | 129.1 | 128.65 | 128.93 | 5067500.0 |
| 2006-02-22 10:30:00 | SPY | ETF | 128.94 | 129.1 | 128.89 | 129.08 | 2040100.0 |
| 2006-02-22 11:00:00 | SPY | ETF | 129.08 | 129.41 | 129.04 | 129.33 | 3722100.0 |
| 2006-02-22 11:30:00 | SPY | ETF | 129.34 | 129.48 | 129.3 | 129.35 | 3065100.0 |
| 2006-02-22 12:00:00 | SPY | ETF | 129.35 | 129.58 | 129.29 | 129.48 | 2982900.0 |
| 2006-02-22 12:30:00 | SPY | ETF | 129.48 | 129.54 | 129.43 | 129.49 | 1081600.0 |
| 2006-02-22 13:00:00 | SPY | ETF | 129.5 | 129.62 | 129.43 | 129.57 | 1601400.0 |
| 2006-02-22 13:30:00 | SPY | ETF | 129.57 | 129.58 | 129.26 | 129.37 | 2856300.0 |
| 2006-02-22 14:00:00 | SPY | ETF | 129.38 | 129.48 | 129.3 | 129.37 | 1146500.0 |
| 2006-02-22 14:30:00 | SPY | ETF | 129.37 | 129.48 | 129.25 | 129.45 | 1406800.0 |
| 2006-02-22 15:00:00 | SPY | ETF | 129.45 | 129.49 | 129.28 | 129.41 | 1707400.0 |
| 2006-02-22 15:30:00 | SPY | ETF | 129.41 | 129.65 | 129.41 | 129.43 | 3142300.0 |
| 2006-02-22 16:00:00 | SPY | ETF | 129.42 | 129.44 | 129.22 | 129.25 | 619700.0 |
| 2006-02-22 16:30:00 | SPY | ETF | 129.27 | 129.28 | 129.2 | 129.24 | 1136500.0 |
| 2006-02-22 17:00:00 | SPY | ETF | 128.503 | 129.24 | 128.503 | 129.24 | 2026800.0 |
| 2006-02-22 17:30:00 | SPY | ETF | 129.29 | 129.3 | 129.25 | 129.25 | 11400.0 |
| 2006-02-22 18:00:00 | SPY | ETF | 129.26 | 129.27 | 129.25 | 129.25 | 4700.0 |
| 2006-02-22 18:30:00 | SPY | ETF | 129.26 | 129.26 | 129.24 | 129.24 | 400.0 |
| 2006-02-22 19:30:00 | SPY | ETF | 129.23 | 129.23 | 129.22 | 129.23 | 1400.0 |
| 2006-02-22 09:30:00 | QQQ | ETF | 40.8 | 40.83 | 40.68 | 40.7 | 10560200.0 |
| 2006-02-22 10:00:00 | QQQ | ETF | 40.7 | 40.92 | 40.68 | 40.84 | 9877900.0 |
| 2006-02-22 10:30:00 | QQQ | ETF | 40.84 | 40.94 | 40.82 | 40.93 | 7109300.0 |
| 2006-02-22 11:00:00 | QQQ | ETF | 40.93 | 41.21 | 40.9 | 41.21 | 8048900.0 |
| 2006-02-22 11:30:00 | QQQ | ETF | 41.21 | 41.3 | 41.16 | 41.21 | 10292900.0 |
| 2006-02-22 12:00:00 | QQQ | ETF | 41.2 | 41.34 | 41.19 | 41.3 | 9085200.0 |
| 2006-02-22 12:30:00 | QQQ | ETF | 41.3 | 41.4 | 41.27 | 41.37 | 4882300.0 |
| 2006-02-22 13:00:00 | QQQ | ETF | 41.37 | 41.46 | 41.36 | 41.39 | 3834900.0 |
| 2006-02-22 13:30:00 | QQQ | ETF | 41.39 | 41.54 | 41.21 | 41.3 | 7194400.0 |
| 2006-02-22 14:00:00 | QQQ | ETF | 41.29 | 41.37 | 41.26 | 41.32 | 2812100.0 |
| 2006-02-22 14:30:00 | QQQ | ETF | 41.32 | 41.36 | 41.26 | 41.31 | 2817500.0 |
| 2006-02-22 15:00:00 | QQQ | ETF | 41.3 | 41.35 | 41.26 | 41.31 | 2556800.0 |
| 2006-02-22 15:30:00 | QQQ | ETF | 41.31 | 41.38 | 41.28 | 41.28 | 6562400.0 |
| 2006-02-22 08:00:00 | IWM | ETF | 72.39 | 72.39 | 72.39 | 72.39 | 100.0 |
| 2006-02-22 08:30:00 | IWM | ETF | 72.27 | 72.5 | 72.27 | 72.49 | 77500.0 |
| 2006-02-22 09:00:00 | IWM | ETF | 72.49 | 72.49 | 72.43 | 72.46 | 101200.0 |
| 2006-02-22 09:30:00 | IWM | ETF | 72.47 | 72.5 | 72.06 | 72.09 | 3053200.0 |
| 2006-02-22 10:00:00 | IWM | ETF | 72.09 | 72.48 | 71.98 | 72.34 | 2736200.0 |
| 2006-02-22 10:30:00 | IWM | ETF | 72.35 | 72.38 | 72.15 | 72.37 | 3146800.0 |
| 2006-02-22 11:00:00 | IWM | ETF | 72.37 | 72.77 | 72.32 | 72.76 | 3667800.0 |
| 2006-02-22 11:30:00 | IWM | ETF | 72.77 | 72.88 | 72.76 | 72.78 | 2204900.0 |
| 2006-02-22 12:00:00 | IWM | ETF | 72.79 | 72.91 | 72.78 | 72.87 | 1231400.0 |
| 2006-02-22 12:30:00 | IWM | ETF | 72.86 | 72.96 | 72.86 | 72.89 | 995900.0 |
| 2006-02-22 13:00:00 | IWM | ETF | 72.9 | 72.94 | 72.82 | 72.9 | 1095600.0 |
> showing 50 of 2,175 rows — these rows as CSV