PREVIEW / etf_30min / 2006-05-05
file: by_date/etf_30min/2006/2006-05-05.parquet size: 64 KB rows: 2,286
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-05 04:30:00 | SPY | ETF | 131.54 | 131.54 | 131.54 | 131.54 | 200.0 |
| 2006-05-05 06:30:00 | SPY | ETF | 131.6 | 131.6 | 131.6 | 131.6 | 2000.0 |
| 2006-05-05 07:00:00 | SPY | ETF | 131.62 | 131.63 | 131.6 | 131.6 | 32400.0 |
| 2006-05-05 07:30:00 | SPY | ETF | 131.63 | 131.63 | 131.62 | 131.62 | 4700.0 |
| 2006-05-05 08:00:00 | SPY | ETF | 131.64 | 131.67 | 131.57 | 131.64 | 396100.0 |
| 2006-05-05 08:30:00 | SPY | ETF | 131.64 | 132.05 | 131.64 | 131.9 | 2130900.0 |
| 2006-05-05 09:00:00 | SPY | ETF | 131.89 | 132.1 | 131.88 | 132.06 | 1340300.0 |
| 2006-05-05 09:30:00 | SPY | ETF | 132.05 | 132.31 | 131.9 | 132.13 | 12011100.0 |
| 2006-05-05 10:00:00 | SPY | ETF | 132.14 | 132.17 | 131.85 | 131.92 | 6454100.0 |
| 2006-05-05 10:30:00 | SPY | ETF | 131.9 | 132.15 | 131.9 | 132.13 | 3809800.0 |
| 2006-05-05 11:00:00 | SPY | ETF | 132.14 | 132.23 | 132.02 | 132.2 | 1955900.0 |
| 2006-05-05 11:30:00 | SPY | ETF | 132.21 | 132.45 | 132.2 | 132.33 | 8398700.0 |
| 2006-05-05 12:00:00 | SPY | ETF | 132.33 | 132.48 | 132.3 | 132.38 | 2638100.0 |
| 2006-05-05 12:30:00 | SPY | ETF | 132.36 | 132.45 | 132.24 | 132.25 | 3507000.0 |
| 2006-05-05 13:00:00 | SPY | ETF | 132.25 | 132.39 | 132.2 | 132.27 | 1905500.0 |
| 2006-05-05 13:30:00 | SPY | ETF | 132.27 | 132.48 | 132.27 | 132.42 | 2172700.0 |
| 2006-05-05 14:00:00 | SPY | ETF | 132.43 | 132.57 | 132.34 | 132.5 | 2869700.0 |
| 2006-05-05 14:30:00 | SPY | ETF | 132.51 | 132.8 | 132.49 | 132.67 | 3681000.0 |
| 2006-05-05 15:00:00 | SPY | ETF | 132.67 | 132.68 | 132.53 | 132.58 | 1920600.0 |
| 2006-05-05 15:30:00 | SPY | ETF | 132.57 | 132.74 | 132.56 | 132.7 | 4729500.0 |
| 2006-05-05 16:00:00 | SPY | ETF | 132.69 | 132.7 | 132.5 | 132.6 | 875800.0 |
| 2006-05-05 16:30:00 | SPY | ETF | 132.6 | 132.62 | 132.6 | 132.62 | 2600.0 |
| 2006-05-05 17:00:00 | SPY | ETF | 132.64 | 132.64 | 132.58 | 132.58 | 2000.0 |
| 2006-05-05 17:30:00 | SPY | ETF | 132.55 | 132.65 | 132.55 | 132.65 | 300.0 |
| 2006-05-05 18:00:00 | SPY | ETF | 132.58 | 132.58 | 132.55 | 132.55 | 1100.0 |
| 2006-05-05 18:30:00 | SPY | ETF | 132.51 | 132.51 | 132.51 | 132.51 | 100.0 |
| 2006-05-05 19:00:00 | SPY | ETF | 132.52 | 132.52 | 132.51 | 132.51 | 2200.0 |
| 2006-05-05 19:30:00 | SPY | ETF | 132.5 | 132.5 | 132.5 | 132.5 | 1500.0 |
| 2006-05-05 09:30:00 | QQQ | ETF | 42.11 | 42.21 | 42.03 | 42.11 | 14085600.0 |
| 2006-05-05 10:00:00 | QQQ | ETF | 42.1 | 42.11 | 41.94 | 41.97 | 11244100.0 |
| 2006-05-05 10:30:00 | QQQ | ETF | 41.96 | 42.06 | 41.95 | 42.06 | 5815000.0 |
| 2006-05-05 11:00:00 | QQQ | ETF | 42.06 | 42.08 | 42.02 | 42.06 | 2699100.0 |
| 2006-05-05 11:30:00 | QQQ | ETF | 42.06 | 42.13 | 42.05 | 42.06 | 4018100.0 |
| 2006-05-05 12:00:00 | QQQ | ETF | 42.07 | 42.11 | 42.06 | 42.1 | 3654900.0 |
| 2006-05-05 12:30:00 | QQQ | ETF | 42.1 | 42.11 | 42.01 | 42.02 | 2430900.0 |
| 2006-05-05 13:00:00 | QQQ | ETF | 42.02 | 42.09 | 41.97 | 42.0 | 2857900.0 |
| 2006-05-05 13:30:00 | QQQ | ETF | 42.0 | 42.1 | 42.0 | 42.08 | 3594300.0 |
| 2006-05-05 14:00:00 | QQQ | ETF | 42.08 | 42.11 | 42.03 | 42.11 | 4944000.0 |
| 2006-05-05 14:30:00 | QQQ | ETF | 42.1 | 42.14 | 42.09 | 42.09 | 5128700.0 |
| 2006-05-05 15:00:00 | QQQ | ETF | 42.1 | 42.12 | 42.08 | 42.11 | 2099500.0 |
| 2006-05-05 15:30:00 | QQQ | ETF | 42.11 | 42.16 | 42.1 | 42.14 | 8333600.0 |
| 2006-05-05 07:30:00 | IWM | ETF | 77.2 | 77.2 | 77.2 | 77.2 | 5000.0 |
| 2006-05-05 08:00:00 | IWM | ETF | 77.26 | 77.26 | 77.16 | 77.16 | 11800.0 |
| 2006-05-05 08:30:00 | IWM | ETF | 77.28 | 77.55 | 77.28 | 77.45 | 342200.0 |
| 2006-05-05 09:00:00 | IWM | ETF | 77.46 | 77.57 | 77.45 | 77.52 | 275100.0 |
| 2006-05-05 09:30:00 | IWM | ETF | 77.52 | 77.8 | 77.45 | 77.7 | 9473300.0 |
| 2006-05-05 10:00:00 | IWM | ETF | 77.71 | 77.72 | 77.4 | 77.41 | 3471100.0 |
| 2006-05-05 10:30:00 | IWM | ETF | 77.39 | 77.51 | 77.32 | 77.49 | 1748200.0 |
| 2006-05-05 11:00:00 | IWM | ETF | 77.49 | 77.62 | 77.38 | 77.62 | 1660800.0 |
| 2006-05-05 11:30:00 | IWM | ETF | 77.62 | 77.78 | 77.62 | 77.71 | 3095200.0 |
> showing 50 of 2,286 rows — these rows as CSV