PREVIEW / etf_30min / 2006-05-26
file: by_date/etf_30min/2006/2006-05-26.parquet size: 64 KB rows: 2,325
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-26 06:00:00 | SPY | ETF | 127.64 | 127.64 | 127.64 | 127.64 | 1000.0 |
| 2006-05-26 06:30:00 | SPY | ETF | 127.59 | 127.6 | 127.59 | 127.6 | 4300.0 |
| 2006-05-26 07:00:00 | SPY | ETF | 127.62 | 127.62 | 127.53 | 127.53 | 4900.0 |
| 2006-05-26 07:30:00 | SPY | ETF | 127.53 | 127.62 | 127.53 | 127.57 | 299200.0 |
| 2006-05-26 08:00:00 | SPY | ETF | 127.58 | 127.7 | 127.45 | 127.67 | 1507800.0 |
| 2006-05-26 08:30:00 | SPY | ETF | 127.66 | 128.25 | 127.66 | 128.04 | 5389000.0 |
| 2006-05-26 09:00:00 | SPY | ETF | 128.06 | 128.19 | 128.0 | 128.0 | 1323900.0 |
| 2006-05-26 09:30:00 | SPY | ETF | 128.0 | 128.06 | 127.78 | 127.89 | 6151200.0 |
| 2006-05-26 10:00:00 | SPY | ETF | 127.89 | 128.03 | 127.82 | 127.87 | 5094800.0 |
| 2006-05-26 10:30:00 | SPY | ETF | 127.88 | 127.98 | 127.51 | 127.81 | 7259500.0 |
| 2006-05-26 11:00:00 | SPY | ETF | 127.8 | 128.13 | 127.76 | 128.1 | 2834900.0 |
| 2006-05-26 11:30:00 | SPY | ETF | 128.09 | 128.25 | 128.05 | 128.11 | 7124600.0 |
| 2006-05-26 12:00:00 | SPY | ETF | 128.09 | 128.14 | 127.93 | 128.0 | 2796300.0 |
| 2006-05-26 12:30:00 | SPY | ETF | 127.99 | 128.17 | 127.98 | 128.07 | 1164100.0 |
| 2006-05-26 13:00:00 | SPY | ETF | 128.06 | 128.16 | 128.0 | 128.1 | 3940200.0 |
| 2006-05-26 13:30:00 | SPY | ETF | 128.11 | 128.17 | 128.0 | 128.16 | 2699600.0 |
| 2006-05-26 14:00:00 | SPY | ETF | 128.16 | 128.36 | 128.12 | 128.23 | 2334600.0 |
| 2006-05-26 14:30:00 | SPY | ETF | 128.24 | 128.3 | 128.11 | 128.12 | 2630800.0 |
| 2006-05-26 15:00:00 | SPY | ETF | 128.12 | 128.32 | 128.08 | 128.3 | 2151800.0 |
| 2006-05-26 15:30:00 | SPY | ETF | 128.28 | 128.37 | 128.26 | 128.3 | 4297100.0 |
| 2006-05-26 16:00:00 | SPY | ETF | 128.3 | 128.44 | 128.25 | 128.41 | 1805000.0 |
| 2006-05-26 16:30:00 | SPY | ETF | 128.4 | 128.4 | 128.37 | 128.4 | 101300.0 |
| 2006-05-26 17:00:00 | SPY | ETF | 128.38 | 128.38 | 128.32 | 128.32 | 3300.0 |
| 2006-05-26 17:30:00 | SPY | ETF | 128.4 | 128.4 | 128.4 | 128.4 | 5600.0 |
| 2006-05-26 18:00:00 | SPY | ETF | 128.4 | 128.43 | 128.35 | 128.43 | 900.0 |
| 2006-05-26 18:30:00 | SPY | ETF | 128.42 | 128.42 | 128.42 | 128.42 | 1200.0 |
| 2006-05-26 09:30:00 | QQQ | ETF | 39.45 | 39.47 | 39.28 | 39.39 | 18069500.0 |
| 2006-05-26 10:00:00 | QQQ | ETF | 39.39 | 39.49 | 39.37 | 39.39 | 8566000.0 |
| 2006-05-26 10:30:00 | QQQ | ETF | 39.4 | 39.43 | 39.23 | 39.36 | 10236400.0 |
| 2006-05-26 11:00:00 | QQQ | ETF | 39.35 | 39.48 | 39.33 | 39.47 | 5051400.0 |
| 2006-05-26 11:30:00 | QQQ | ETF | 39.47 | 39.5 | 39.41 | 39.46 | 5723700.0 |
| 2006-05-26 12:00:00 | QQQ | ETF | 39.46 | 39.47 | 39.35 | 39.4 | 4793900.0 |
| 2006-05-26 12:30:00 | QQQ | ETF | 39.4 | 39.47 | 39.4 | 39.43 | 1463800.0 |
| 2006-05-26 13:00:00 | QQQ | ETF | 39.43 | 39.43 | 39.36 | 39.39 | 1998100.0 |
| 2006-05-26 13:30:00 | QQQ | ETF | 39.4 | 39.44 | 38.39 | 39.43 | 3121700.0 |
| 2006-05-26 14:00:00 | QQQ | ETF | 39.44 | 39.58 | 39.4 | 39.45 | 6270700.0 |
| 2006-05-26 14:30:00 | QQQ | ETF | 39.46 | 39.48 | 39.37 | 39.4 | 3052500.0 |
| 2006-05-26 15:00:00 | QQQ | ETF | 39.4 | 39.47 | 39.38 | 39.46 | 2427700.0 |
| 2006-05-26 15:30:00 | QQQ | ETF | 39.45 | 39.51 | 39.41 | 39.5 | 7359300.0 |
| 2006-05-26 07:30:00 | IWM | ETF | 71.9 | 71.9 | 71.9 | 71.9 | 200.0 |
| 2006-05-26 08:00:00 | IWM | ETF | 72.2 | 72.26 | 72.16 | 72.26 | 160600.0 |
| 2006-05-26 08:30:00 | IWM | ETF | 72.44 | 72.75 | 72.3 | 72.55 | 1804700.0 |
| 2006-05-26 09:00:00 | IWM | ETF | 72.53 | 72.7 | 72.34 | 72.66 | 1300200.0 |
| 2006-05-26 09:30:00 | IWM | ETF | 72.65 | 72.7 | 72.38 | 72.47 | 5995500.0 |
| 2006-05-26 10:00:00 | IWM | ETF | 72.47 | 72.58 | 72.32 | 72.36 | 4096300.0 |
| 2006-05-26 10:30:00 | IWM | ETF | 72.36 | 72.41 | 72.02 | 72.24 | 4790100.0 |
| 2006-05-26 11:00:00 | IWM | ETF | 72.25 | 72.62 | 72.2 | 72.57 | 2495000.0 |
| 2006-05-26 11:30:00 | IWM | ETF | 72.57 | 72.72 | 72.52 | 72.54 | 2961000.0 |
| 2006-05-26 12:00:00 | IWM | ETF | 72.54 | 72.56 | 72.33 | 72.37 | 1306500.0 |
| 2006-05-26 12:30:00 | IWM | ETF | 72.36 | 72.52 | 72.25 | 72.44 | 489100.0 |
> showing 50 of 2,325 rows — these rows as CSV