PREVIEW / etf_30min / 2006-09-19
file: by_date/etf_30min/2006/2006-09-19.parquet size: 83 KB rows: 2,859
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-19 06:30:00 | SPY | ETF | 131.75 | 131.75 | 131.75 | 131.75 | 1000.0 |
| 2006-09-19 07:00:00 | SPY | ETF | 131.7 | 131.75 | 131.7 | 131.75 | 25600.0 |
| 2006-09-19 07:30:00 | SPY | ETF | 131.71 | 131.83 | 131.71 | 131.82 | 265400.0 |
| 2006-09-19 08:00:00 | SPY | ETF | 131.73 | 131.84 | 131.53 | 131.83 | 574700.0 |
| 2006-09-19 08:30:00 | SPY | ETF | 131.84 | 132.2 | 131.84 | 132.2 | 3344200.0 |
| 2006-09-19 09:00:00 | SPY | ETF | 132.2 | 132.23 | 132.08 | 132.12 | 430700.0 |
| 2006-09-19 09:30:00 | SPY | ETF | 132.12 | 132.13 | 131.77 | 131.83 | 9242200.0 |
| 2006-09-19 10:00:00 | SPY | ETF | 131.83 | 131.97 | 131.67 | 131.7701 | 5848700.0 |
| 2006-09-19 10:30:00 | SPY | ETF | 131.78 | 131.81 | 131.65 | 131.75 | 4104300.0 |
| 2006-09-19 11:00:00 | SPY | ETF | 131.75 | 131.96 | 131.66 | 131.66 | 5900500.0 |
| 2006-09-19 11:30:00 | SPY | ETF | 131.67 | 131.72 | 131.33 | 131.42 | 12038300.0 |
| 2006-09-19 12:00:00 | SPY | ETF | 131.42 | 131.8 | 131.11 | 131.12 | 9080100.0 |
| 2006-09-19 12:30:00 | SPY | ETF | 131.12 | 131.37 | 131.11 | 131.27 | 3702500.0 |
| 2006-09-19 13:00:00 | SPY | ETF | 131.27 | 131.33 | 131.1 | 131.21 | 4884600.0 |
| 2006-09-19 13:30:00 | SPY | ETF | 131.22 | 131.29 | 131.07 | 131.23 | 3451000.0 |
| 2006-09-19 14:00:00 | SPY | ETF | 131.23 | 131.42 | 131.17 | 131.38 | 4499600.0 |
| 2006-09-19 14:30:00 | SPY | ETF | 131.38 | 131.46 | 131.22 | 131.3 | 4060700.0 |
| 2006-09-19 15:00:00 | SPY | ETF | 131.31 | 131.58 | 131.26 | 131.57 | 5310800.0 |
| 2006-09-19 15:30:00 | SPY | ETF | 131.57 | 131.995 | 131.56 | 131.74 | 10123400.0 |
| 2006-09-19 16:00:00 | SPY | ETF | 131.75 | 131.95 | 131.716 | 131.93 | 1093800.0 |
| 2006-09-19 16:30:00 | SPY | ETF | 131.88 | 131.98 | 131.88 | 131.94 | 421200.0 |
| 2006-09-19 17:00:00 | SPY | ETF | 131.93 | 131.95 | 131.9 | 131.92 | 25400.0 |
| 2006-09-19 17:30:00 | SPY | ETF | 131.94 | 132.01 | 131.94 | 131.95 | 9800.0 |
| 2006-09-19 18:00:00 | SPY | ETF | 131.95 | 131.95 | 131.87 | 131.87 | 7700.0 |
| 2006-09-19 19:00:00 | SPY | ETF | 131.91 | 131.93 | 131.89 | 131.9 | 9900.0 |
| 2006-09-19 19:30:00 | SPY | ETF | 131.88 | 131.88 | 131.88 | 131.88 | 700.0 |
| 2006-09-19 09:30:00 | QQQ | ETF | 40.25 | 40.25 | 40.03 | 40.09 | 11852400.0 |
| 2006-09-19 10:00:00 | QQQ | ETF | 40.09 | 40.18 | 39.95 | 40.04 | 10155000.0 |
| 2006-09-19 10:30:00 | QQQ | ETF | 40.04 | 40.1 | 39.99 | 40.07 | 8147000.0 |
| 2006-09-19 11:00:00 | QQQ | ETF | 40.07 | 40.19 | 40.05 | 40.07 | 7086300.0 |
| 2006-09-19 11:30:00 | QQQ | ETF | 40.08 | 40.08 | 39.65 | 39.71 | 27272200.0 |
| 2006-09-19 12:00:00 | QQQ | ETF | 39.71 | 39.8 | 39.53 | 39.53 | 20811100.0 |
| 2006-09-19 12:30:00 | QQQ | ETF | 39.53 | 39.71 | 39.52 | 39.63 | 9607900.0 |
| 2006-09-19 13:00:00 | QQQ | ETF | 39.63 | 39.67 | 39.54 | 39.59 | 6294200.0 |
| 2006-09-19 13:30:00 | QQQ | ETF | 39.58 | 39.66 | 39.55 | 39.6 | 4734000.0 |
| 2006-09-19 14:00:00 | QQQ | ETF | 39.6 | 39.72 | 39.6 | 39.7 | 5906500.0 |
| 2006-09-19 14:30:00 | QQQ | ETF | 39.7 | 39.72 | 39.57 | 39.64 | 11279100.0 |
| 2006-09-19 15:00:00 | QQQ | ETF | 39.65 | 39.81 | 39.63 | 39.78 | 8190800.0 |
| 2006-09-19 15:30:00 | QQQ | ETF | 39.79 | 39.87 | 39.78 | 39.85 | 9082100.0 |
| 2006-09-19 07:30:00 | IWM | ETF | 72.43 | 72.45 | 72.43 | 72.45 | 5000.0 |
| 2006-09-19 08:00:00 | IWM | ETF | 72.45 | 72.45 | 72.39 | 72.45 | 9200.0 |
| 2006-09-19 08:30:00 | IWM | ETF | 72.45 | 72.88 | 72.45 | 72.64 | 561500.0 |
| 2006-09-19 09:00:00 | IWM | ETF | 72.82 | 72.84 | 72.64 | 72.71 | 511300.0 |
| 2006-09-19 09:30:00 | IWM | ETF | 72.71 | 72.74 | 72.22 | 72.35 | 3379600.0 |
| 2006-09-19 10:00:00 | IWM | ETF | 72.35 | 72.53 | 72.13 | 72.3 | 4198500.0 |
| 2006-09-19 10:30:00 | IWM | ETF | 72.29 | 72.36 | 72.19 | 72.3 | 1891100.0 |
| 2006-09-19 11:00:00 | IWM | ETF | 72.3 | 72.55 | 72.23 | 72.27 | 1539600.0 |
| 2006-09-19 11:30:00 | IWM | ETF | 72.27 | 72.27 | 71.42 | 71.5 | 12179500.0 |
| 2006-09-19 12:00:00 | IWM | ETF | 71.49 | 71.66 | 71.15 | 71.17 | 7737500.0 |
| 2006-09-19 12:30:00 | IWM | ETF | 71.16 | 71.45 | 71.15 | 71.32 | 2876300.0 |
> showing 50 of 2,859 rows — these rows as CSV