PREVIEW / etf_30min / 2006-10-06
file: by_date/etf_30min/2006/2006-10-06.parquet size: 81 KB rows: 2,869
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-10-06 06:00:00 | SPY | ETF | 135.17 | 135.17 | 135.17 | 135.17 | 100.0 |
| 2006-10-06 06:30:00 | SPY | ETF | 135.1 | 135.1 | 135.1 | 135.1 | 1400.0 |
| 2006-10-06 07:00:00 | SPY | ETF | 135.07 | 135.07 | 135.03 | 135.07 | 12100.0 |
| 2006-10-06 07:30:00 | SPY | ETF | 135.03 | 135.04 | 134.97 | 135.04 | 63800.0 |
| 2006-10-06 08:00:00 | SPY | ETF | 135.01 | 135.16 | 134.98 | 135.16 | 941900.0 |
| 2006-10-06 08:30:00 | SPY | ETF | 135.1 | 135.19 | 134.8 | 134.88 | 2145000.0 |
| 2006-10-06 09:00:00 | SPY | ETF | 134.88 | 134.96 | 134.78 | 134.96 | 1124600.0 |
| 2006-10-06 09:30:00 | SPY | ETF | 134.95 | 135.0 | 134.5 | 134.61 | 10009200.0 |
| 2006-10-06 10:00:00 | SPY | ETF | 134.58 | 134.77 | 134.46 | 134.59 | 7323700.0 |
| 2006-10-06 10:30:00 | SPY | ETF | 134.59 | 134.93 | 134.57 | 134.87 | 5812300.0 |
| 2006-10-06 11:00:00 | SPY | ETF | 134.87 | 134.91 | 134.7 | 134.89 | 4884800.0 |
| 2006-10-06 11:30:00 | SPY | ETF | 134.88 | 134.92 | 134.57 | 134.66 | 3275000.0 |
| 2006-10-06 12:00:00 | SPY | ETF | 134.66 | 134.71 | 134.51 | 134.5375 | 1756000.0 |
| 2006-10-06 12:30:00 | SPY | ETF | 134.54 | 134.71 | 134.4 | 134.69 | 6490200.0 |
| 2006-10-06 13:00:00 | SPY | ETF | 134.71 | 134.78 | 134.61 | 134.66 | 1900300.0 |
| 2006-10-06 13:30:00 | SPY | ETF | 134.66 | 134.84 | 134.57 | 134.79 | 1896500.0 |
| 2006-10-06 14:00:00 | SPY | ETF | 134.79 | 134.87 | 134.74 | 134.79 | 1559300.0 |
| 2006-10-06 14:30:00 | SPY | ETF | 134.79 | 135.09 | 134.77 | 134.99 | 5264200.0 |
| 2006-10-06 15:00:00 | SPY | ETF | 134.99 | 134.99 | 134.72 | 134.81 | 4106900.0 |
| 2006-10-06 15:30:00 | SPY | ETF | 134.82 | 135.05 | 134.76 | 135.03 | 3974700.0 |
| 2006-10-06 16:00:00 | SPY | ETF | 135.03 | 135.11 | 134.95 | 135.01 | 636100.0 |
| 2006-10-06 16:30:00 | SPY | ETF | 134.97 | 135.02 | 134.95 | 135.0 | 10800.0 |
| 2006-10-06 17:00:00 | SPY | ETF | 134.94 | 135.05 | 134.94 | 135.05 | 15400.0 |
| 2006-10-06 18:00:00 | SPY | ETF | 134.95 | 134.95 | 134.91 | 134.91 | 4600.0 |
| 2006-10-06 18:30:00 | SPY | ETF | 134.91 | 134.91 | 134.88 | 134.88 | 4500.0 |
| 2006-10-06 09:30:00 | QQQ | ETF | 41.38 | 41.5 | 41.24 | 41.35 | 14899900.0 |
| 2006-10-06 10:00:00 | QQQ | ETF | 41.35 | 41.41 | 41.27 | 41.31 | 8538600.0 |
| 2006-10-06 10:30:00 | QQQ | ETF | 41.31 | 41.49 | 41.27 | 41.45 | 9839100.0 |
| 2006-10-06 11:00:00 | QQQ | ETF | 41.45 | 41.48 | 41.39 | 41.46 | 4454100.0 |
| 2006-10-06 11:30:00 | QQQ | ETF | 41.45 | 41.47 | 41.3 | 41.35 | 7055000.0 |
| 2006-10-06 12:00:00 | QQQ | ETF | 41.34 | 41.37 | 41.27 | 41.29 | 4552100.0 |
| 2006-10-06 12:30:00 | QQQ | ETF | 41.29 | 41.4 | 41.24 | 41.4 | 3881400.0 |
| 2006-10-06 13:00:00 | QQQ | ETF | 41.39 | 41.43 | 41.35 | 41.37 | 1922300.0 |
| 2006-10-06 13:30:00 | QQQ | ETF | 41.37 | 41.45 | 41.34 | 41.43 | 1709100.0 |
| 2006-10-06 14:00:00 | QQQ | ETF | 41.43 | 41.46 | 41.38 | 41.41 | 2555700.0 |
| 2006-10-06 14:30:00 | QQQ | ETF | 41.41 | 41.56 | 41.4 | 41.49 | 5649300.0 |
| 2006-10-06 15:00:00 | QQQ | ETF | 41.49 | 41.49 | 41.38 | 41.4 | 3741300.0 |
| 2006-10-06 15:30:00 | QQQ | ETF | 41.4 | 41.44 | 41.32 | 41.42 | 7342900.0 |
| 2006-10-06 07:00:00 | IWM | ETF | 73.55 | 73.7 | 73.55 | 73.7 | 600.0 |
| 2006-10-06 07:30:00 | IWM | ETF | 73.7 | 73.75 | 73.66 | 73.75 | 2400.0 |
| 2006-10-06 08:00:00 | IWM | ETF | 73.79 | 73.81 | 73.78 | 73.8 | 8100.0 |
| 2006-10-06 08:30:00 | IWM | ETF | 73.71 | 73.98 | 73.56 | 73.59 | 319000.0 |
| 2006-10-06 09:00:00 | IWM | ETF | 73.53 | 73.61 | 73.39 | 73.56 | 348600.0 |
| 2006-10-06 09:30:00 | IWM | ETF | 73.61 | 73.67 | 73.15 | 73.28 | 5500400.0 |
| 2006-10-06 10:00:00 | IWM | ETF | 73.29 | 73.34 | 73.0 | 73.14 | 3814200.0 |
| 2006-10-06 10:30:00 | IWM | ETF | 73.13 | 73.58 | 73.13 | 73.46 | 4363800.0 |
| 2006-10-06 11:00:00 | IWM | ETF | 73.46 | 73.48 | 73.31 | 73.43 | 1277100.0 |
| 2006-10-06 11:30:00 | IWM | ETF | 73.45 | 73.5 | 73.21 | 73.3 | 1087400.0 |
| 2006-10-06 12:00:00 | IWM | ETF | 73.3 | 73.31 | 73.05 | 73.0999 | 1348500.0 |
| 2006-10-06 12:30:00 | IWM | ETF | 73.08 | 73.4 | 73.0 | 73.4 | 2254600.0 |
> showing 50 of 2,869 rows — these rows as CSV