PREVIEW / etf_30min / 2006-06-06
file: by_date/etf_30min/2006/2006-06-06.parquet size: 68 KB rows: 2,378
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-06-06 05:00:00 | SPY | ETF | 127.41 | 127.41 | 127.41 | 127.41 | 100.0 |
| 2006-06-06 07:00:00 | SPY | ETF | 127.4 | 127.4 | 127.33 | 127.39 | 22700.0 |
| 2006-06-06 07:30:00 | SPY | ETF | 127.4 | 127.4 | 127.21 | 127.26 | 73600.0 |
| 2006-06-06 08:00:00 | SPY | ETF | 127.27 | 127.4 | 127.18 | 127.27 | 1561800.0 |
| 2006-06-06 08:30:00 | SPY | ETF | 127.27 | 127.37 | 127.24 | 127.24 | 244400.0 |
| 2006-06-06 09:00:00 | SPY | ETF | 127.24 | 127.25 | 127.15 | 127.21 | 907400.0 |
| 2006-06-06 09:30:00 | SPY | ETF | 127.21 | 127.38 | 126.51 | 126.59 | 12718900.0 |
| 2006-06-06 10:00:00 | SPY | ETF | 126.6 | 127.05 | 126.41 | 126.95 | 14021100.0 |
| 2006-06-06 10:30:00 | SPY | ETF | 126.95 | 127.07 | 126.35 | 126.45 | 9949900.0 |
| 2006-06-06 11:00:00 | SPY | ETF | 126.45 | 126.56 | 125.9 | 126.19 | 11843000.0 |
| 2006-06-06 11:30:00 | SPY | ETF | 126.19 | 126.32 | 125.76 | 125.98 | 8755900.0 |
| 2006-06-06 12:00:00 | SPY | ETF | 125.96 | 126.5 | 125.91 | 126.12 | 10841600.0 |
| 2006-06-06 12:30:00 | SPY | ETF | 126.12 | 126.95 | 126.11 | 126.88 | 9711000.0 |
| 2006-06-06 13:00:00 | SPY | ETF | 126.87 | 126.89 | 126.49 | 126.62 | 5442300.0 |
| 2006-06-06 13:30:00 | SPY | ETF | 126.63 | 126.88 | 126.26 | 126.52 | 5912000.0 |
| 2006-06-06 14:00:00 | SPY | ETF | 126.51 | 126.52 | 126.13 | 126.38 | 4050700.0 |
| 2006-06-06 14:30:00 | SPY | ETF | 126.39 | 126.65 | 126.09 | 126.12 | 6388700.0 |
| 2006-06-06 15:00:00 | SPY | ETF | 126.12 | 126.39 | 126.0 | 126.12 | 6100900.0 |
| 2006-06-06 15:30:00 | SPY | ETF | 126.12 | 126.96 | 126.02 | 126.71 | 13327100.0 |
| 2006-06-06 16:00:00 | SPY | ETF | 126.72 | 126.83 | 126.65 | 126.81 | 4010800.0 |
| 2006-06-06 16:30:00 | SPY | ETF | 126.84 | 126.94 | 126.45 | 126.88 | 574900.0 |
| 2006-06-06 17:00:00 | SPY | ETF | 126.91 | 126.97 | 126.91 | 126.94 | 63600.0 |
| 2006-06-06 17:30:00 | SPY | ETF | 126.94 | 126.94 | 126.91 | 126.91 | 13000.0 |
| 2006-06-06 18:00:00 | SPY | ETF | 126.96 | 126.97 | 126.92 | 126.95 | 363700.0 |
| 2006-06-06 18:30:00 | SPY | ETF | 126.96 | 126.97 | 126.91 | 126.91 | 5600.0 |
| 2006-06-06 19:00:00 | SPY | ETF | 126.95 | 126.95 | 126.95 | 126.95 | 4000.0 |
| 2006-06-06 09:30:00 | QQQ | ETF | 38.85 | 38.95 | 38.57 | 38.63 | 18661500.0 |
| 2006-06-06 10:00:00 | QQQ | ETF | 38.62 | 38.85 | 38.57 | 38.78 | 12714900.0 |
| 2006-06-06 10:30:00 | QQQ | ETF | 38.78 | 38.87 | 38.57 | 38.62 | 10490900.0 |
| 2006-06-06 11:00:00 | QQQ | ETF | 38.61 | 38.66 | 38.45 | 38.51 | 12817500.0 |
| 2006-06-06 11:30:00 | QQQ | ETF | 38.51 | 38.59 | 38.35 | 38.46 | 10788400.0 |
| 2006-06-06 12:00:00 | QQQ | ETF | 38.46 | 38.65 | 38.43 | 38.51 | 8049300.0 |
| 2006-06-06 12:30:00 | QQQ | ETF | 38.5 | 38.79 | 38.48 | 38.76 | 8179500.0 |
| 2006-06-06 13:00:00 | QQQ | ETF | 38.77 | 38.77 | 38.62 | 38.69 | 5049500.0 |
| 2006-06-06 13:30:00 | QQQ | ETF | 38.68 | 38.76 | 38.54 | 38.65 | 4490500.0 |
| 2006-06-06 14:00:00 | QQQ | ETF | 38.65 | 38.65 | 38.51 | 38.59 | 4956100.0 |
| 2006-06-06 14:30:00 | QQQ | ETF | 38.59 | 38.68 | 38.47 | 38.49 | 5077900.0 |
| 2006-06-06 15:00:00 | QQQ | ETF | 38.5 | 38.59 | 38.45 | 38.51 | 6673500.0 |
| 2006-06-06 15:30:00 | QQQ | ETF | 38.51 | 38.8 | 38.48 | 38.73 | 13559800.0 |
| 2006-06-06 08:00:00 | IWM | ETF | 71.21 | 71.22 | 71.09 | 71.15 | 41900.0 |
| 2006-06-06 08:30:00 | IWM | ETF | 71.14 | 71.16 | 71.09 | 71.09 | 3900.0 |
| 2006-06-06 09:00:00 | IWM | ETF | 71.12 | 71.12 | 71.01 | 71.05 | 192700.0 |
| 2006-06-06 09:30:00 | IWM | ETF | 71.04 | 71.16 | 70.24 | 70.35 | 14587700.0 |
| 2006-06-06 10:00:00 | IWM | ETF | 70.36 | 70.87 | 70.28 | 70.77 | 8635600.0 |
| 2006-06-06 10:30:00 | IWM | ETF | 70.76 | 70.95 | 70.24 | 70.33 | 5425500.0 |
| 2006-06-06 11:00:00 | IWM | ETF | 70.33 | 70.45 | 69.97 | 70.24 | 9105100.0 |
| 2006-06-06 11:30:00 | IWM | ETF | 70.25 | 70.38 | 69.81 | 69.87 | 7133600.0 |
| 2006-06-06 12:00:00 | IWM | ETF | 69.87 | 70.43 | 69.83 | 70.19 | 9030900.0 |
| 2006-06-06 12:30:00 | IWM | ETF | 70.18 | 70.87 | 70.18 | 70.81 | 5603500.0 |
| 2006-06-06 13:00:00 | IWM | ETF | 70.8 | 70.86 | 70.36 | 70.63 | 8758100.0 |
> showing 50 of 2,378 rows — these rows as CSV