PREVIEW / etf_30min / 2006-05-10
file: by_date/etf_30min/2006/2006-05-10.parquet size: 64 KB rows: 2,337
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-05-10 06:00:00 | SPY | ETF | 132.61 | 132.61 | 132.61 | 132.61 | 2000.0 |
| 2006-05-10 06:30:00 | SPY | ETF | 132.58 | 132.58 | 132.58 | 132.58 | 200.0 |
| 2006-05-10 07:00:00 | SPY | ETF | 132.55 | 132.55 | 132.52 | 132.52 | 55000.0 |
| 2006-05-10 07:30:00 | SPY | ETF | 132.56 | 132.61 | 132.56 | 132.58 | 19600.0 |
| 2006-05-10 08:00:00 | SPY | ETF | 132.59 | 132.63 | 132.57 | 132.6 | 94500.0 |
| 2006-05-10 08:30:00 | SPY | ETF | 132.6 | 132.6 | 132.54 | 132.55 | 55900.0 |
| 2006-05-10 09:00:00 | SPY | ETF | 132.54 | 132.54 | 132.39 | 132.4 | 118600.0 |
| 2006-05-10 09:30:00 | SPY | ETF | 132.41 | 132.58 | 132.33 | 132.52 | 4133300.0 |
| 2006-05-10 10:00:00 | SPY | ETF | 132.53 | 132.59 | 132.47 | 132.56 | 2319000.0 |
| 2006-05-10 10:30:00 | SPY | ETF | 132.55 | 132.6 | 132.41 | 132.46 | 2511700.0 |
| 2006-05-10 11:00:00 | SPY | ETF | 132.46 | 132.52 | 132.43 | 132.45 | 1812000.0 |
| 2006-05-10 11:30:00 | SPY | ETF | 132.44 | 132.51 | 132.4 | 132.43 | 1646000.0 |
| 2006-05-10 12:00:00 | SPY | ETF | 132.41 | 132.49 | 132.41 | 132.47 | 554800.0 |
| 2006-05-10 12:30:00 | SPY | ETF | 132.46 | 132.56 | 132.44 | 132.49 | 1275800.0 |
| 2006-05-10 13:00:00 | SPY | ETF | 132.52 | 132.58 | 132.4 | 132.49 | 900100.0 |
| 2006-05-10 13:30:00 | SPY | ETF | 132.4901 | 132.52 | 132.4 | 132.43 | 1506600.0 |
| 2006-05-10 14:00:00 | SPY | ETF | 132.43 | 132.6 | 131.89 | 132.04 | 14459000.0 |
| 2006-05-10 14:30:00 | SPY | ETF | 132.08 | 132.72 | 131.9 | 132.59 | 11605200.0 |
| 2006-05-10 15:00:00 | SPY | ETF | 132.59 | 132.75 | 132.32 | 132.38 | 11205100.0 |
| 2006-05-10 15:30:00 | SPY | ETF | 132.38 | 132.48 | 132.18 | 132.43 | 4955400.0 |
| 2006-05-10 16:00:00 | SPY | ETF | 132.43 | 132.55 | 132.34 | 132.5 | 392400.0 |
| 2006-05-10 16:30:00 | SPY | ETF | 132.5 | 132.54 | 132.47 | 132.48 | 27500.0 |
| 2006-05-10 17:00:00 | SPY | ETF | 132.5 | 132.53 | 132.47 | 132.53 | 175200.0 |
| 2006-05-10 17:30:00 | SPY | ETF | 132.5 | 132.51 | 132.5 | 132.51 | 5000.0 |
| 2006-05-10 18:00:00 | SPY | ETF | 132.52 | 132.52 | 132.47 | 132.47 | 25400.0 |
| 2006-05-10 18:30:00 | SPY | ETF | 132.47 | 132.47 | 132.47 | 132.47 | 500.0 |
| 2006-05-10 19:00:00 | SPY | ETF | 132.48 | 132.48 | 132.46 | 132.46 | 6500.0 |
| 2006-05-10 09:30:00 | QQQ | ETF | 41.93 | 41.98 | 41.87 | 41.93 | 8305900.0 |
| 2006-05-10 10:00:00 | QQQ | ETF | 41.93 | 41.97 | 41.9 | 41.92 | 3998500.0 |
| 2006-05-10 10:30:00 | QQQ | ETF | 41.91 | 41.97 | 41.82 | 41.83 | 4230400.0 |
| 2006-05-10 11:00:00 | QQQ | ETF | 41.84 | 41.91 | 41.83 | 41.87 | 6201400.0 |
| 2006-05-10 11:30:00 | QQQ | ETF | 41.87 | 41.92 | 41.86 | 41.87 | 2804100.0 |
| 2006-05-10 12:00:00 | QQQ | ETF | 41.87 | 41.89 | 41.84 | 41.87 | 2084200.0 |
| 2006-05-10 12:30:00 | QQQ | ETF | 41.88 | 41.91 | 41.82 | 41.89 | 1916000.0 |
| 2006-05-10 13:00:00 | QQQ | ETF | 41.9 | 41.92 | 41.84 | 41.86 | 1478200.0 |
| 2006-05-10 13:30:00 | QQQ | ETF | 41.85 | 41.86 | 41.76 | 41.8 | 3737100.0 |
| 2006-05-10 14:00:00 | QQQ | ETF | 41.8 | 41.86 | 41.62 | 41.7 | 15141100.0 |
| 2006-05-10 14:30:00 | QQQ | ETF | 41.7 | 41.82 | 41.55 | 41.76 | 16545800.0 |
| 2006-05-10 15:00:00 | QQQ | ETF | 41.76 | 41.85 | 41.64 | 41.65 | 5676600.0 |
| 2006-05-10 15:30:00 | QQQ | ETF | 41.66 | 41.69 | 41.55 | 41.65 | 10983400.0 |
| 2006-05-10 08:00:00 | IWM | ETF | 77.5 | 77.5 | 77.46 | 77.46 | 900.0 |
| 2006-05-10 08:30:00 | IWM | ETF | 77.44 | 77.45 | 77.41 | 77.45 | 31000.0 |
| 2006-05-10 09:00:00 | IWM | ETF | 77.45 | 77.46 | 77.38 | 77.38 | 20300.0 |
| 2006-05-10 09:30:00 | IWM | ETF | 77.38 | 77.38 | 77.2 | 77.29 | 1429100.0 |
| 2006-05-10 10:00:00 | IWM | ETF | 77.29 | 77.43 | 77.26 | 77.37 | 752600.0 |
| 2006-05-10 10:30:00 | IWM | ETF | 77.38 | 77.46 | 77.17 | 77.22 | 1201800.0 |
| 2006-05-10 11:00:00 | IWM | ETF | 77.22 | 77.3 | 77.21 | 77.27 | 681200.0 |
| 2006-05-10 11:30:00 | IWM | ETF | 77.25 | 77.32 | 77.2 | 77.23 | 2744000.0 |
| 2006-05-10 12:00:00 | IWM | ETF | 77.23 | 77.26 | 77.19 | 77.25 | 1775300.0 |
| 2006-05-10 12:30:00 | IWM | ETF | 77.25 | 77.34 | 77.25 | 77.31 | 458500.0 |
> showing 50 of 2,337 rows — these rows as CSV