PREVIEW / etf_30min / 2006-09-14
file: by_date/etf_30min/2006/2006-09-14.parquet size: 75 KB rows: 2,742
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-09-14 06:30:00 | SPY | ETF | 132.24 | 132.24 | 132.24 | 132.24 | 100.0 |
| 2006-09-14 07:00:00 | SPY | ETF | 132.2 | 132.2 | 132.16 | 132.16 | 2000.0 |
| 2006-09-14 07:30:00 | SPY | ETF | 132.12 | 132.12 | 132.12 | 132.12 | 3200.0 |
| 2006-09-14 08:00:00 | SPY | ETF | 132.14 | 132.27 | 132.11 | 132.27 | 334800.0 |
| 2006-09-14 08:30:00 | SPY | ETF | 132.26 | 132.27 | 131.96 | 131.99 | 368100.0 |
| 2006-09-14 09:00:00 | SPY | ETF | 131.99 | 132.01 | 131.86 | 131.95 | 660500.0 |
| 2006-09-14 09:30:00 | SPY | ETF | 131.96 | 132.17 | 131.85 | 131.93 | 9851900.0 |
| 2006-09-14 10:00:00 | SPY | ETF | 131.94 | 132.04 | 131.79 | 131.91 | 6118900.0 |
| 2006-09-14 10:30:00 | SPY | ETF | 131.91 | 132.01 | 131.75 | 131.93 | 4316700.0 |
| 2006-09-14 11:00:00 | SPY | ETF | 131.93 | 132.15 | 131.85 | 132.04 | 4411600.0 |
| 2006-09-14 11:30:00 | SPY | ETF | 132.04 | 132.05 | 131.9 | 131.98 | 2480100.0 |
| 2006-09-14 12:00:00 | SPY | ETF | 132.0 | 132.01 | 131.82 | 131.97 | 3601100.0 |
| 2006-09-14 12:30:00 | SPY | ETF | 131.98 | 132.1 | 131.94 | 132.06 | 1657000.0 |
| 2006-09-14 13:00:00 | SPY | ETF | 132.06 | 132.06 | 131.91 | 132.01 | 1908500.0 |
| 2006-09-14 13:30:00 | SPY | ETF | 132.01 | 132.15 | 132.0 | 132.07 | 3485600.0 |
| 2006-09-14 14:00:00 | SPY | ETF | 132.07 | 132.13 | 131.99 | 132.11 | 1722100.0 |
| 2006-09-14 14:30:00 | SPY | ETF | 132.11 | 132.22 | 131.92 | 131.94 | 3730600.0 |
| 2006-09-14 15:00:00 | SPY | ETF | 131.93 | 132.01 | 131.84 | 131.99 | 3571200.0 |
| 2006-09-14 15:30:00 | SPY | ETF | 131.98 | 132.12 | 131.96 | 132.06 | 4258700.0 |
| 2006-09-14 16:00:00 | SPY | ETF | 132.07 | 132.24 | 131.92 | 132.23 | 3283400.0 |
| 2006-09-14 16:30:00 | SPY | ETF | 132.21 | 132.22 | 132.17 | 132.18 | 150300.0 |
| 2006-09-14 17:00:00 | SPY | ETF | 132.2 | 132.25 | 132.2 | 132.22 | 75400.0 |
| 2006-09-14 17:30:00 | SPY | ETF | 132.25 | 132.25 | 132.21 | 132.21 | 19300.0 |
| 2006-09-14 18:00:00 | SPY | ETF | 132.21 | 132.26 | 132.2 | 132.2 | 6300.0 |
| 2006-09-14 19:00:00 | SPY | ETF | 132.24 | 132.24 | 132.24 | 132.24 | 200.0 |
| 2006-09-14 19:30:00 | SPY | ETF | 132.25 | 132.26 | 132.25 | 132.26 | 8900.0 |
| 2006-09-14 09:30:00 | QQQ | ETF | 39.85 | 39.94 | 39.77 | 39.9 | 14285900.0 |
| 2006-09-14 10:00:00 | QQQ | ETF | 39.9 | 39.97 | 39.82 | 39.9 | 10013900.0 |
| 2006-09-14 10:30:00 | QQQ | ETF | 39.9 | 39.96 | 39.81 | 39.91 | 9310800.0 |
| 2006-09-14 11:00:00 | QQQ | ETF | 39.91 | 40.22 | 39.89 | 40.02 | 11259600.0 |
| 2006-09-14 11:30:00 | QQQ | ETF | 40.02 | 40.03 | 39.94 | 39.98 | 5309400.0 |
| 2006-09-14 12:00:00 | QQQ | ETF | 39.99 | 40.0 | 39.91 | 39.97 | 2990700.0 |
| 2006-09-14 12:30:00 | QQQ | ETF | 39.97 | 40.04 | 39.94 | 39.99 | 4837300.0 |
| 2006-09-14 13:00:00 | QQQ | ETF | 39.99 | 39.99 | 39.92 | 39.96 | 3624000.0 |
| 2006-09-14 13:30:00 | QQQ | ETF | 39.96 | 40.03 | 39.92 | 40.01 | 4594700.0 |
| 2006-09-14 14:00:00 | QQQ | ETF | 39.97 | 40.04 | 39.97 | 40.04 | 3299100.0 |
| 2006-09-14 14:30:00 | QQQ | ETF | 40.03 | 40.08 | 39.76 | 39.97 | 6273000.0 |
| 2006-09-14 15:00:00 | QQQ | ETF | 39.97 | 39.98 | 39.81 | 39.98 | 7660800.0 |
| 2006-09-14 15:30:00 | QQQ | ETF | 39.98 | 40.02 | 39.95 | 39.97 | 8624800.0 |
| 2006-09-14 07:30:00 | IWM | ETF | 72.5 | 72.5 | 72.5 | 72.5 | 3000.0 |
| 2006-09-14 08:00:00 | IWM | ETF | 72.69 | 72.76 | 72.65 | 72.69 | 602300.0 |
| 2006-09-14 08:30:00 | IWM | ETF | 72.66 | 72.68 | 72.51 | 72.61 | 164700.0 |
| 2006-09-14 09:00:00 | IWM | ETF | 72.6 | 72.62 | 72.45 | 72.45 | 638200.0 |
| 2006-09-14 09:30:00 | IWM | ETF | 72.47 | 72.59 | 72.15 | 72.33 | 4292100.0 |
| 2006-09-14 10:00:00 | IWM | ETF | 72.31 | 72.3899 | 72.14 | 72.18 | 3729400.0 |
| 2006-09-14 10:30:00 | IWM | ETF | 72.18 | 72.33 | 72.01 | 72.21 | 3132800.0 |
| 2006-09-14 11:00:00 | IWM | ETF | 72.22 | 72.55 | 72.18 | 72.48 | 3208500.0 |
| 2006-09-14 11:30:00 | IWM | ETF | 72.49 | 72.5 | 72.31 | 72.4291 | 1569700.0 |
| 2006-09-14 12:00:00 | IWM | ETF | 72.43 | 72.47 | 72.25 | 72.4 | 1640700.0 |
| 2006-09-14 12:30:00 | IWM | ETF | 72.39 | 72.55 | 72.33 | 72.46 | 1036500.0 |
> showing 50 of 2,742 rows — these rows as CSV