PREVIEW / etf_30min / 2006-02-13
file: by_date/etf_30min/2006/2006-02-13.parquet size: 58 KB rows: 2,103
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-13 05:00:00 | SPY | ETF | 126.35 | 126.36 | 126.35 | 126.36 | 300.0 |
| 2006-02-13 05:30:00 | SPY | ETF | 126.32 | 126.32 | 126.32 | 126.32 | 100.0 |
| 2006-02-13 07:00:00 | SPY | ETF | 126.45 | 126.52 | 126.45 | 126.52 | 46300.0 |
| 2006-02-13 07:30:00 | SPY | ETF | 126.55 | 126.57 | 126.46 | 126.48 | 36600.0 |
| 2006-02-13 08:00:00 | SPY | ETF | 126.46 | 126.56 | 126.33 | 126.38 | 660900.0 |
| 2006-02-13 08:30:00 | SPY | ETF | 126.47 | 126.53 | 126.41 | 126.5 | 156900.0 |
| 2006-02-13 09:00:00 | SPY | ETF | 126.52 | 126.59 | 126.5 | 126.55 | 138400.0 |
| 2006-02-13 09:30:00 | SPY | ETF | 126.57 | 126.71 | 126.42 | 126.62 | 5985400.0 |
| 2006-02-13 10:00:00 | SPY | ETF | 126.61 | 126.79 | 126.46 | 126.53 | 3225600.0 |
| 2006-02-13 10:30:00 | SPY | ETF | 126.53 | 126.75 | 126.47 | 126.67 | 2679100.0 |
| 2006-02-13 11:00:00 | SPY | ETF | 126.65 | 126.77 | 126.59 | 126.63 | 2148800.0 |
| 2006-02-13 11:30:00 | SPY | ETF | 126.64 | 126.74 | 126.61 | 126.66 | 1136600.0 |
| 2006-02-13 12:00:00 | SPY | ETF | 126.66 | 126.74 | 126.65 | 126.68 | 1712700.0 |
| 2006-02-13 12:30:00 | SPY | ETF | 126.67 | 126.7 | 126.39 | 126.52 | 2540700.0 |
| 2006-02-13 13:00:00 | SPY | ETF | 126.52 | 126.6 | 126.3 | 126.38 | 3425400.0 |
| 2006-02-13 13:30:00 | SPY | ETF | 126.38 | 126.4 | 126.1 | 126.12 | 5289800.0 |
| 2006-02-13 14:00:00 | SPY | ETF | 126.12 | 126.27 | 126.05 | 126.17 | 4210300.0 |
| 2006-02-13 14:30:00 | SPY | ETF | 126.16 | 126.27 | 125.95 | 126.02 | 3248100.0 |
| 2006-02-13 15:00:00 | SPY | ETF | 126.02 | 126.22 | 125.96 | 126.2 | 3016400.0 |
| 2006-02-13 15:30:00 | SPY | ETF | 126.21 | 126.53 | 126.2 | 126.46 | 4075100.0 |
| 2006-02-13 16:00:00 | SPY | ETF | 126.46 | 128.49 | 126.41 | 126.46 | 2837100.0 |
| 2006-02-13 16:30:00 | SPY | ETF | 126.47 | 126.5 | 126.45 | 126.47 | 117800.0 |
| 2006-02-13 17:00:00 | SPY | ETF | 126.48 | 126.48 | 125.98 | 126.42 | 1304300.0 |
| 2006-02-13 17:30:00 | SPY | ETF | 126.42 | 126.43 | 126.41 | 126.41 | 12100.0 |
| 2006-02-13 18:00:00 | SPY | ETF | 126.4 | 126.47 | 126.4 | 126.47 | 1200.0 |
| 2006-02-13 18:30:00 | SPY | ETF | 126.45 | 126.48 | 126.45 | 126.48 | 8300.0 |
| 2006-02-13 19:00:00 | SPY | ETF | 126.51 | 126.51 | 126.51 | 126.51 | 200.0 |
| 2006-02-13 19:30:00 | SPY | ETF | 126.46 | 126.46 | 126.46 | 126.46 | 600.0 |
| 2006-02-13 09:30:00 | QQQ | ETF | 40.72 | 40.74 | 40.61 | 40.64 | 10049400.0 |
| 2006-02-13 10:00:00 | QQQ | ETF | 40.64 | 40.71 | 40.54 | 40.57 | 6484300.0 |
| 2006-02-13 10:30:00 | QQQ | ETF | 40.57 | 40.69 | 40.52 | 40.62 | 4112800.0 |
| 2006-02-13 11:00:00 | QQQ | ETF | 40.63 | 40.66 | 40.57 | 40.6 | 2904100.0 |
| 2006-02-13 11:30:00 | QQQ | ETF | 40.6 | 40.62 | 40.55 | 40.57 | 2020200.0 |
| 2006-02-13 12:00:00 | QQQ | ETF | 40.58 | 40.62 | 40.57 | 40.59 | 1426100.0 |
| 2006-02-13 12:30:00 | QQQ | ETF | 40.59 | 40.59 | 40.46 | 40.53 | 4245800.0 |
| 2006-02-13 13:00:00 | QQQ | ETF | 40.53 | 40.55 | 40.4 | 40.44 | 6796300.0 |
| 2006-02-13 13:30:00 | QQQ | ETF | 40.44 | 40.45 | 40.33 | 40.34 | 4820100.0 |
| 2006-02-13 14:00:00 | QQQ | ETF | 40.33 | 40.45 | 40.33 | 40.41 | 3656900.0 |
| 2006-02-13 14:30:00 | QQQ | ETF | 40.41 | 40.45 | 40.31 | 40.34 | 5656800.0 |
| 2006-02-13 15:00:00 | QQQ | ETF | 40.34 | 40.4 | 40.3 | 40.38 | 4729400.0 |
| 2006-02-13 15:30:00 | QQQ | ETF | 40.38 | 40.51 | 40.38 | 40.5 | 9084700.0 |
| 2006-02-13 07:00:00 | IWM | ETF | 71.02 | 71.02 | 71.02 | 71.02 | 200.0 |
| 2006-02-13 08:00:00 | IWM | ETF | 71.07 | 71.07 | 70.99 | 70.99 | 18700.0 |
| 2006-02-13 08:30:00 | IWM | ETF | 71.01 | 71.02 | 70.96 | 70.96 | 13600.0 |
| 2006-02-13 09:00:00 | IWM | ETF | 70.93 | 71.05 | 70.93 | 71.04 | 6500.0 |
| 2006-02-13 09:30:00 | IWM | ETF | 71.04 | 71.15 | 70.84 | 70.98 | 4755800.0 |
| 2006-02-13 10:00:00 | IWM | ETF | 70.97 | 71.12 | 70.72 | 70.77 | 2359400.0 |
| 2006-02-13 10:30:00 | IWM | ETF | 70.73 | 71.07 | 70.69 | 71.0 | 1818100.0 |
| 2006-02-13 11:00:00 | IWM | ETF | 70.99 | 71.1 | 70.9 | 70.95 | 1158500.0 |
| 2006-02-13 11:30:00 | IWM | ETF | 70.95 | 70.99 | 70.86 | 70.94 | 612500.0 |
> showing 50 of 2,103 rows — these rows as CSV