PREVIEW / etf_30min / 2006-01-30
file: by_date/etf_30min/2006/2006-01-30.parquet size: 57 KB rows: 2,114
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-01-30 05:00:00 | SPY | ETF | 128.3 | 128.34 | 128.3 | 128.34 | 400.0 |
| 2006-01-30 06:30:00 | SPY | ETF | 128.37 | 128.37 | 128.37 | 128.37 | 1100.0 |
| 2006-01-30 07:00:00 | SPY | ETF | 128.41 | 128.45 | 128.4 | 128.43 | 5400.0 |
| 2006-01-30 07:30:00 | SPY | ETF | 128.44 | 128.48 | 128.41 | 128.41 | 22200.0 |
| 2006-01-30 08:00:00 | SPY | ETF | 128.43 | 128.58 | 128.43 | 128.48 | 63000.0 |
| 2006-01-30 08:30:00 | SPY | ETF | 128.52 | 128.56 | 128.44 | 128.44 | 354800.0 |
| 2006-01-30 09:00:00 | SPY | ETF | 128.43 | 128.49 | 128.35 | 128.44 | 244300.0 |
| 2006-01-30 09:30:00 | SPY | ETF | 128.44 | 128.68 | 128.42 | 128.5 | 4074600.0 |
| 2006-01-30 10:00:00 | SPY | ETF | 128.5 | 128.68 | 128.43 | 128.44 | 3072100.0 |
| 2006-01-30 10:30:00 | SPY | ETF | 128.47 | 128.57 | 128.41 | 128.52 | 1652500.0 |
| 2006-01-30 11:00:00 | SPY | ETF | 128.51 | 128.52 | 128.35 | 128.42 | 3794200.0 |
| 2006-01-30 11:30:00 | SPY | ETF | 128.43 | 128.52 | 128.37 | 128.4 | 1152000.0 |
| 2006-01-30 12:00:00 | SPY | ETF | 128.41 | 128.61 | 128.37 | 128.55 | 1109900.0 |
| 2006-01-30 12:30:00 | SPY | ETF | 128.55 | 128.78 | 128.55 | 128.61 | 2413000.0 |
| 2006-01-30 13:00:00 | SPY | ETF | 128.61 | 128.69 | 128.56 | 128.61 | 1637000.0 |
| 2006-01-30 13:30:00 | SPY | ETF | 128.61 | 128.81 | 128.56 | 128.71 | 1530500.0 |
| 2006-01-30 14:00:00 | SPY | ETF | 128.73 | 128.76 | 128.58 | 128.67 | 2054800.0 |
| 2006-01-30 14:30:00 | SPY | ETF | 128.66 | 128.73 | 128.63 | 128.7005 | 1281700.0 |
| 2006-01-30 15:00:00 | SPY | ETF | 128.71 | 128.71 | 128.41 | 128.49 | 3372100.0 |
| 2006-01-30 15:30:00 | SPY | ETF | 128.49 | 128.55 | 128.3657 | 128.53 | 3741400.0 |
| 2006-01-30 16:00:00 | SPY | ETF | 128.52 | 128.53 | 128.43 | 128.47 | 478700.0 |
| 2006-01-30 16:30:00 | SPY | ETF | 128.46 | 128.47 | 128.38 | 128.42 | 41200.0 |
| 2006-01-30 17:00:00 | SPY | ETF | 128.42 | 128.44 | 128.42 | 128.44 | 5300.0 |
| 2006-01-30 18:00:00 | SPY | ETF | 128.43 | 128.44 | 128.43 | 128.43 | 600.0 |
| 2006-01-30 18:30:00 | SPY | ETF | 128.47 | 128.49 | 128.47 | 128.49 | 1100.0 |
| 2006-01-30 19:00:00 | SPY | ETF | 128.48 | 128.48 | 128.45 | 128.45 | 1200.0 |
| 2006-01-30 19:30:00 | SPY | ETF | 128.49 | 128.51 | 128.46 | 128.51 | 2700.0 |
| 2006-01-30 09:30:00 | QQQ | ETF | 42.15 | 42.29 | 42.12 | 42.15 | 14260600.0 |
| 2006-01-30 10:00:00 | QQQ | ETF | 42.15 | 42.23 | 42.12 | 42.13 | 4298200.0 |
| 2006-01-30 10:30:00 | QQQ | ETF | 42.13 | 42.22 | 42.11 | 42.19 | 2181400.0 |
| 2006-01-30 11:00:00 | QQQ | ETF | 42.19 | 42.19 | 42.1 | 42.12 | 2454000.0 |
| 2006-01-30 11:30:00 | QQQ | ETF | 42.12 | 42.19 | 42.11 | 42.13 | 1554500.0 |
| 2006-01-30 12:00:00 | QQQ | ETF | 42.13 | 42.21 | 42.11 | 42.19 | 1633200.0 |
| 2006-01-30 12:30:00 | QQQ | ETF | 42.19 | 42.31 | 42.19 | 42.24 | 3911900.0 |
| 2006-01-30 13:00:00 | QQQ | ETF | 42.24 | 42.27 | 42.21 | 42.23 | 1798400.0 |
| 2006-01-30 13:30:00 | QQQ | ETF | 42.22 | 42.32 | 42.22 | 42.27 | 2361800.0 |
| 2006-01-30 14:00:00 | QQQ | ETF | 42.27 | 42.29 | 42.19 | 42.2 | 3967200.0 |
| 2006-01-30 14:30:00 | QQQ | ETF | 42.2 | 42.25 | 42.19 | 42.21 | 2196500.0 |
| 2006-01-30 15:00:00 | QQQ | ETF | 42.21 | 42.21 | 42.07 | 42.14 | 4948000.0 |
| 2006-01-30 15:30:00 | QQQ | ETF | 42.14 | 42.2 | 42.09 | 42.19 | 4990300.0 |
| 2006-01-30 07:00:00 | IWM | ETF | 72.63 | 72.63 | 72.63 | 72.63 | 400.0 |
| 2006-01-30 08:00:00 | IWM | ETF | 72.64 | 72.75 | 72.64 | 72.75 | 111700.0 |
| 2006-01-30 08:30:00 | IWM | ETF | 72.74 | 72.75 | 72.71 | 72.71 | 10800.0 |
| 2006-01-30 09:00:00 | IWM | ETF | 72.67 | 72.7 | 72.67 | 72.7 | 10500.0 |
| 2006-01-30 09:30:00 | IWM | ETF | 72.7 | 72.9 | 72.59 | 72.72 | 2797800.0 |
| 2006-01-30 10:00:00 | IWM | ETF | 72.72 | 72.91 | 72.67 | 72.72 | 1273400.0 |
| 2006-01-30 10:30:00 | IWM | ETF | 72.72 | 72.79 | 72.64 | 72.75 | 1387400.0 |
| 2006-01-30 11:00:00 | IWM | ETF | 72.74 | 72.77 | 72.62 | 72.66 | 1254100.0 |
| 2006-01-30 11:30:00 | IWM | ETF | 72.67 | 72.78 | 72.66 | 72.7 | 606900.0 |
| 2006-01-30 12:00:00 | IWM | ETF | 72.7 | 72.86 | 72.67 | 72.8 | 854300.0 |
> showing 50 of 2,114 rows — these rows as CSV