PREVIEW / etf_30min / 2006-04-26
file: by_date/etf_30min/2006/2006-04-26.parquet size: 60 KB rows: 2,181
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-04-26 05:30:00 | SPY | ETF | 130.58 | 130.58 | 130.58 | 130.58 | 300.0 |
| 2006-04-26 07:00:00 | SPY | ETF | 130.66 | 130.66 | 130.62 | 130.62 | 57500.0 |
| 2006-04-26 07:30:00 | SPY | ETF | 130.6 | 130.6 | 130.57 | 130.6 | 3300.0 |
| 2006-04-26 08:00:00 | SPY | ETF | 130.6 | 130.69 | 130.57 | 130.67 | 458400.0 |
| 2006-04-26 08:30:00 | SPY | ETF | 130.7 | 130.72 | 130.37 | 130.54 | 2252600.0 |
| 2006-04-26 09:00:00 | SPY | ETF | 130.54 | 130.57 | 130.46 | 130.51 | 298300.0 |
| 2006-04-26 09:30:00 | SPY | ETF | 130.5 | 131.0 | 130.46 | 130.92 | 7091300.0 |
| 2006-04-26 10:00:00 | SPY | ETF | 130.9 | 131.14 | 130.6 | 131.09 | 11936700.0 |
| 2006-04-26 10:30:00 | SPY | ETF | 131.09 | 131.14 | 130.74 | 130.83 | 9161600.0 |
| 2006-04-26 11:00:00 | SPY | ETF | 130.83 | 130.97 | 130.6 | 130.71 | 4341600.0 |
| 2006-04-26 11:30:00 | SPY | ETF | 130.7 | 131.12 | 130.61 | 130.75 | 2654100.0 |
| 2006-04-26 12:00:00 | SPY | ETF | 130.74 | 130.88 | 130.63 | 130.82 | 3176000.0 |
| 2006-04-26 12:30:00 | SPY | ETF | 130.83 | 130.91 | 130.75 | 130.75 | 663300.0 |
| 2006-04-26 13:00:00 | SPY | ETF | 130.75 | 130.97 | 130.7 | 130.71 | 1213900.0 |
| 2006-04-26 13:30:00 | SPY | ETF | 130.7 | 130.92 | 130.65 | 130.87 | 1731100.0 |
| 2006-04-26 14:00:00 | SPY | ETF | 130.87 | 130.97 | 130.62 | 130.73 | 3328700.0 |
| 2006-04-26 14:30:00 | SPY | ETF | 130.74 | 130.78 | 130.55 | 130.66 | 2109800.0 |
| 2006-04-26 15:00:00 | SPY | ETF | 130.66 | 130.74 | 130.3 | 130.4 | 6445100.0 |
| 2006-04-26 15:30:00 | SPY | ETF | 130.39 | 130.62 | 130.38 | 130.58 | 6267500.0 |
| 2006-04-26 16:00:00 | SPY | ETF | 130.59 | 130.59 | 130.25 | 130.41 | 697500.0 |
| 2006-04-26 16:30:00 | SPY | ETF | 130.42 | 130.5 | 130.39 | 130.5 | 173700.0 |
| 2006-04-26 17:00:00 | SPY | ETF | 130.47 | 130.47 | 130.44 | 130.45 | 136300.0 |
| 2006-04-26 17:30:00 | SPY | ETF | 130.41 | 130.49 | 130.41 | 130.42 | 1100.0 |
| 2006-04-26 18:00:00 | SPY | ETF | 130.47 | 130.47 | 130.43 | 130.45 | 4200.0 |
| 2006-04-26 18:30:00 | SPY | ETF | 130.48 | 130.49 | 130.48 | 130.49 | 500.0 |
| 2006-04-26 19:00:00 | SPY | ETF | 130.5 | 130.5 | 130.5 | 130.5 | 200.0 |
| 2006-04-26 19:30:00 | SPY | ETF | 130.51 | 130.53 | 130.51 | 130.53 | 300.0 |
| 2006-04-26 09:30:00 | QQQ | ETF | 41.87 | 42.01 | 41.86 | 41.96 | 10684500.0 |
| 2006-04-26 10:00:00 | QQQ | ETF | 41.96 | 42.04 | 41.83 | 42.02 | 13265900.0 |
| 2006-04-26 10:30:00 | QQQ | ETF | 42.02 | 42.06 | 41.91 | 41.94 | 6434400.0 |
| 2006-04-26 11:00:00 | QQQ | ETF | 41.94 | 42.02 | 41.78 | 41.85 | 7640600.0 |
| 2006-04-26 11:30:00 | QQQ | ETF | 41.84 | 42.02 | 41.79 | 41.82 | 3138200.0 |
| 2006-04-26 12:00:00 | QQQ | ETF | 41.82 | 41.9 | 41.77 | 41.87 | 3879400.0 |
| 2006-04-26 12:30:00 | QQQ | ETF | 41.87 | 41.89 | 41.84 | 41.85 | 1460100.0 |
| 2006-04-26 13:00:00 | QQQ | ETF | 41.84 | 41.98 | 41.84 | 41.88 | 4047300.0 |
| 2006-04-26 13:30:00 | QQQ | ETF | 41.87 | 41.94 | 41.84 | 41.92 | 2182700.0 |
| 2006-04-26 14:00:00 | QQQ | ETF | 41.92 | 41.94 | 41.79 | 41.85 | 4344900.0 |
| 2006-04-26 14:30:00 | QQQ | ETF | 41.85 | 41.87 | 41.8 | 41.83 | 2712400.0 |
| 2006-04-26 15:00:00 | QQQ | ETF | 41.83 | 41.86 | 41.7 | 41.72 | 5970300.0 |
| 2006-04-26 15:30:00 | QQQ | ETF | 41.73 | 41.88 | 41.73 | 41.88 | 6228300.0 |
| 2006-04-26 07:30:00 | IWM | ETF | 76.2 | 76.2 | 76.12 | 76.13 | 5000.0 |
| 2006-04-26 08:00:00 | IWM | ETF | 76.18 | 76.19 | 76.15 | 76.18 | 7800.0 |
| 2006-04-26 08:30:00 | IWM | ETF | 76.23 | 76.23 | 76.06 | 76.12 | 18400.0 |
| 2006-04-26 09:00:00 | IWM | ETF | 76.15 | 76.15 | 76.06 | 76.06 | 30800.0 |
| 2006-04-26 09:30:00 | IWM | ETF | 76.06 | 76.37 | 76.0 | 76.33 | 3989800.0 |
| 2006-04-26 10:00:00 | IWM | ETF | 76.34 | 76.71 | 76.1 | 76.71 | 5390200.0 |
| 2006-04-26 10:30:00 | IWM | ETF | 76.71 | 76.75 | 76.25 | 76.3 | 3317600.0 |
| 2006-04-26 11:00:00 | IWM | ETF | 76.31 | 76.52 | 76.23 | 76.29 | 2228900.0 |
| 2006-04-26 11:30:00 | IWM | ETF | 76.29 | 76.3 | 76.12 | 76.19 | 1356100.0 |
| 2006-04-26 12:00:00 | IWM | ETF | 76.19 | 76.39 | 76.11 | 76.35 | 1451600.0 |
> showing 50 of 2,181 rows — these rows as CSV