PREVIEW / etf_30min / 2006-11-08
file: by_date/etf_30min/2006/2006-11-08.parquet size: 88 KB rows: 3,040
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-11-08 06:00:00 | SPY | ETF | 138.06 | 138.13 | 138.06 | 138.13 | 23000.0 |
| 2006-11-08 06:30:00 | SPY | ETF | 138.12 | 138.12 | 138.0 | 138.05 | 33200.0 |
| 2006-11-08 07:00:00 | SPY | ETF | 138.01 | 138.01 | 137.87 | 137.9 | 210600.0 |
| 2006-11-08 07:30:00 | SPY | ETF | 137.89 | 138.13 | 137.88 | 138.12 | 115900.0 |
| 2006-11-08 08:00:00 | SPY | ETF | 138.08 | 138.17 | 137.88 | 138.13 | 2110400.0 |
| 2006-11-08 08:30:00 | SPY | ETF | 138.14 | 138.16 | 137.92 | 138.0 | 1097400.0 |
| 2006-11-08 09:00:00 | SPY | ETF | 137.99 | 138.37 | 137.75 | 138.0 | 838400.0 |
| 2006-11-08 09:30:00 | SPY | ETF | 138.0 | 138.22 | 137.79 | 138.12 | 14062800.0 |
| 2006-11-08 10:00:00 | SPY | ETF | 138.14 | 138.33 | 138.06 | 138.08 | 7990300.0 |
| 2006-11-08 10:30:00 | SPY | ETF | 138.08 | 138.49 | 138.01 | 138.35 | 8547000.0 |
| 2006-11-08 11:00:00 | SPY | ETF | 138.35 | 138.38 | 138.18 | 138.34 | 4203100.0 |
| 2006-11-08 11:30:00 | SPY | ETF | 138.33 | 138.34 | 138.21 | 138.3 | 2604500.0 |
| 2006-11-08 12:00:00 | SPY | ETF | 138.3 | 138.39 | 138.1 | 138.11 | 2023800.0 |
| 2006-11-08 12:30:00 | SPY | ETF | 138.11 | 138.46 | 137.98 | 138.31 | 7060500.0 |
| 2006-11-08 13:00:00 | SPY | ETF | 138.3 | 138.43 | 138.06 | 138.23 | 2985200.0 |
| 2006-11-08 13:30:00 | SPY | ETF | 138.22 | 138.59 | 138.2 | 138.53 | 4404400.0 |
| 2006-11-08 14:00:00 | SPY | ETF | 138.5201 | 138.95 | 138.39 | 138.81 | 6934500.0 |
| 2006-11-08 14:30:00 | SPY | ETF | 138.82 | 139.05 | 138.8 | 138.91 | 5505500.0 |
| 2006-11-08 15:00:00 | SPY | ETF | 138.92 | 139.0 | 138.79 | 138.84 | 4354800.0 |
| 2006-11-08 15:30:00 | SPY | ETF | 138.84 | 138.96 | 138.63 | 138.74 | 6196300.0 |
| 2006-11-08 16:00:00 | SPY | ETF | 138.74 | 138.96 | 138.3795 | 138.88 | 2669700.0 |
| 2006-11-08 16:30:00 | SPY | ETF | 138.87 | 138.93 | 138.79 | 138.92 | 291400.0 |
| 2006-11-08 17:00:00 | SPY | ETF | 138.92 | 139.03 | 138.92 | 138.96 | 359000.0 |
| 2006-11-08 17:30:00 | SPY | ETF | 138.99 | 139.0 | 138.95 | 138.95 | 50700.0 |
| 2006-11-08 18:00:00 | SPY | ETF | 138.95 | 138.95 | 138.95 | 138.95 | 1600.0 |
| 2006-11-08 18:30:00 | SPY | ETF | 138.98 | 138.98 | 138.97 | 138.97 | 1700.0 |
| 2006-11-08 19:00:00 | SPY | ETF | 138.97 | 138.97 | 138.95 | 138.95 | 500.0 |
| 2006-11-08 19:30:00 | SPY | ETF | 138.97 | 138.97 | 138.94 | 138.96 | 300.0 |
| 2006-11-08 09:30:00 | QQQ | ETF | 42.58 | 42.77 | 42.47 | 42.74 | 25274000.0 |
| 2006-11-08 10:00:00 | QQQ | ETF | 42.74 | 42.86 | 42.62 | 42.71 | 17502900.0 |
| 2006-11-08 10:30:00 | QQQ | ETF | 42.71 | 42.84 | 42.63 | 42.77 | 12565500.0 |
| 2006-11-08 11:00:00 | QQQ | ETF | 42.77 | 42.8 | 42.7 | 42.77 | 4141300.0 |
| 2006-11-08 11:30:00 | QQQ | ETF | 42.77 | 42.78 | 42.73 | 42.75 | 2532400.0 |
| 2006-11-08 12:00:00 | QQQ | ETF | 42.75 | 42.85 | 42.72 | 42.72 | 8726600.0 |
| 2006-11-08 12:30:00 | QQQ | ETF | 42.72 | 42.91 | 42.66 | 42.8 | 11634700.0 |
| 2006-11-08 13:00:00 | QQQ | ETF | 42.81 | 42.85 | 42.7 | 42.75 | 8772600.0 |
| 2006-11-08 13:30:00 | QQQ | ETF | 42.76 | 43.07 | 42.76 | 43.04 | 15834700.0 |
| 2006-11-08 14:00:00 | QQQ | ETF | 43.04 | 43.2 | 42.95 | 43.08 | 16071200.0 |
| 2006-11-08 14:30:00 | QQQ | ETF | 43.08 | 43.19 | 43.06 | 43.13 | 7210200.0 |
| 2006-11-08 15:00:00 | QQQ | ETF | 43.12 | 43.15 | 43.06 | 43.13 | 8563300.0 |
| 2006-11-08 15:30:00 | QQQ | ETF | 43.14 | 43.18 | 42.94 | 43.02 | 12396100.0 |
| 2006-11-08 08:00:00 | IWM | ETF | 75.73 | 75.81 | 75.72 | 75.8 | 14600.0 |
| 2006-11-08 08:30:00 | IWM | ETF | 75.8 | 75.8 | 75.59 | 75.63 | 157800.0 |
| 2006-11-08 09:00:00 | IWM | ETF | 75.62 | 75.64 | 75.57 | 75.6 | 786100.0 |
| 2006-11-08 09:30:00 | IWM | ETF | 75.61 | 75.99 | 75.41 | 75.88 | 8428400.0 |
| 2006-11-08 10:00:00 | IWM | ETF | 75.89 | 76.19 | 75.84 | 75.97 | 3675600.0 |
| 2006-11-08 10:30:00 | IWM | ETF | 75.97 | 76.32 | 75.87 | 76.12 | 5052200.0 |
| 2006-11-08 11:00:00 | IWM | ETF | 76.12 | 76.32 | 76.08 | 76.28 | 2016500.0 |
| 2006-11-08 11:30:00 | IWM | ETF | 76.3 | 76.3 | 76.16 | 76.22 | 989600.0 |
| 2006-11-08 12:00:00 | IWM | ETF | 76.23 | 76.43 | 75.98 | 75.99 | 3133100.0 |
> showing 50 of 3,040 rows — these rows as CSV