PREVIEW / etf_30min / 2006-05-09
file: by_date/etf_30min/2006/2006-05-09.parquet size: 62 KB rows: 2,345
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-09 06:00:00 | SPY | ETF | 132.49 | 132.49 | 132.49 | 132.49 | 1000.0 |
| 2006-05-09 07:00:00 | SPY | ETF | 132.53 | 132.53 | 132.5 | 132.5 | 1700.0 |
| 2006-05-09 07:30:00 | SPY | ETF | 132.48 | 132.5 | 132.46 | 132.49 | 105200.0 |
| 2006-05-09 08:00:00 | SPY | ETF | 132.48 | 132.52 | 132.4 | 132.4 | 270300.0 |
| 2006-05-09 08:30:00 | SPY | ETF | 132.4 | 132.42 | 132.4 | 132.4 | 69400.0 |
| 2006-05-09 09:00:00 | SPY | ETF | 132.4 | 132.45 | 132.4 | 132.42 | 1202500.0 |
| 2006-05-09 09:30:00 | SPY | ETF | 132.42 | 132.48 | 132.31 | 132.4 | 3076700.0 |
| 2006-05-09 10:00:00 | SPY | ETF | 132.4 | 132.59 | 132.36 | 132.4 | 3177200.0 |
| 2006-05-09 10:30:00 | SPY | ETF | 132.42 | 132.63 | 132.41 | 132.56 | 1478600.0 |
| 2006-05-09 11:00:00 | SPY | ETF | 132.56 | 132.73 | 132.55 | 132.65 | 1874400.0 |
| 2006-05-09 11:30:00 | SPY | ETF | 132.63 | 132.77 | 132.61 | 132.63 | 1702400.0 |
| 2006-05-09 12:00:00 | SPY | ETF | 132.62 | 132.7 | 132.55 | 132.58 | 1246800.0 |
| 2006-05-09 12:30:00 | SPY | ETF | 132.58 | 132.62 | 132.46 | 132.51 | 1366200.0 |
| 2006-05-09 13:00:00 | SPY | ETF | 132.51 | 132.54 | 132.46 | 132.51 | 1453200.0 |
| 2006-05-09 13:30:00 | SPY | ETF | 132.5 | 132.54 | 132.41 | 132.46 | 1013700.0 |
| 2006-05-09 14:00:00 | SPY | ETF | 132.46 | 132.49 | 132.4 | 132.47 | 614500.0 |
| 2006-05-09 14:30:00 | SPY | ETF | 132.47 | 132.57 | 132.39 | 132.5 | 974100.0 |
| 2006-05-09 15:00:00 | SPY | ETF | 132.5 | 132.58 | 132.48 | 132.5 | 2610900.0 |
| 2006-05-09 15:30:00 | SPY | ETF | 132.5 | 132.63 | 132.5 | 132.53 | 2731000.0 |
| 2006-05-09 16:00:00 | SPY | ETF | 132.53 | 132.68 | 132.45 | 132.6 | 2149300.0 |
| 2006-05-09 16:30:00 | SPY | ETF | 132.62 | 132.64 | 132.59 | 132.64 | 9900.0 |
| 2006-05-09 17:00:00 | SPY | ETF | 132.6 | 132.6 | 132.52 | 132.54 | 26500.0 |
| 2006-05-09 17:30:00 | SPY | ETF | 132.54 | 132.6 | 132.5 | 132.51 | 82900.0 |
| 2006-05-09 18:00:00 | SPY | ETF | 132.52 | 132.53 | 132.51 | 132.51 | 800.0 |
| 2006-05-09 19:30:00 | SPY | ETF | 132.52 | 132.52 | 132.52 | 132.52 | 1200.0 |
| 2006-05-09 09:30:00 | QQQ | ETF | 42.1 | 42.1 | 42.0 | 42.04 | 6637600.0 |
| 2006-05-09 10:00:00 | QQQ | ETF | 42.03 | 42.08 | 42.0 | 42.03 | 4346700.0 |
| 2006-05-09 10:30:00 | QQQ | ETF | 42.02 | 42.07 | 42.01 | 42.05 | 4971900.0 |
| 2006-05-09 11:00:00 | QQQ | ETF | 42.05 | 42.18 | 42.03 | 42.11 | 6317500.0 |
| 2006-05-09 11:30:00 | QQQ | ETF | 42.11 | 42.18 | 42.11 | 42.14 | 1795700.0 |
| 2006-05-09 12:00:00 | QQQ | ETF | 42.13 | 42.16 | 42.07 | 42.08 | 1951300.0 |
| 2006-05-09 12:30:00 | QQQ | ETF | 42.08 | 42.09 | 42.02 | 42.05 | 2108900.0 |
| 2006-05-09 13:00:00 | QQQ | ETF | 42.04 | 42.06 | 42.0 | 42.04 | 2386100.0 |
| 2006-05-09 13:30:00 | QQQ | ETF | 42.05 | 42.06 | 41.98 | 42.02 | 1731900.0 |
| 2006-05-09 14:00:00 | QQQ | ETF | 42.01 | 42.03 | 41.99 | 42.0 | 1378800.0 |
| 2006-05-09 14:30:00 | QQQ | ETF | 42.0 | 42.04 | 41.97 | 42.03 | 3605700.0 |
| 2006-05-09 15:00:00 | QQQ | ETF | 42.03 | 42.05 | 42.01 | 42.02 | 2038100.0 |
| 2006-05-09 15:30:00 | QQQ | ETF | 42.02 | 42.08 | 42.02 | 42.04 | 4455900.0 |
| 2006-05-09 07:30:00 | IWM | ETF | 77.7 | 77.7 | 77.5 | 77.6 | 1400.0 |
| 2006-05-09 08:00:00 | IWM | ETF | 77.63 | 77.63 | 77.53 | 77.53 | 2900.0 |
| 2006-05-09 08:30:00 | IWM | ETF | 77.59 | 77.59 | 77.58 | 77.58 | 1200.0 |
| 2006-05-09 09:00:00 | IWM | ETF | 77.53 | 77.59 | 77.52 | 77.57 | 39700.0 |
| 2006-05-09 09:30:00 | IWM | ETF | 77.57 | 77.63 | 77.35 | 77.45 | 1816800.0 |
| 2006-05-09 10:00:00 | IWM | ETF | 77.45 | 77.6 | 77.41 | 77.47 | 1883500.0 |
| 2006-05-09 10:30:00 | IWM | ETF | 77.45 | 77.59 | 77.45 | 77.56 | 658000.0 |
| 2006-05-09 11:00:00 | IWM | ETF | 77.58 | 77.73 | 77.56 | 77.64 | 1830800.0 |
| 2006-05-09 11:30:00 | IWM | ETF | 77.65 | 77.79 | 77.64 | 77.73 | 596000.0 |
| 2006-05-09 12:00:00 | IWM | ETF | 77.73 | 77.77 | 77.66 | 77.68 | 663800.0 |
| 2006-05-09 12:30:00 | IWM | ETF | 77.67 | 77.71 | 77.56 | 77.62 | 489700.0 |
| 2006-05-09 13:00:00 | IWM | ETF | 77.62 | 77.65 | 77.53 | 77.59 | 537000.0 |
> showing 50 of 2,345 rows — these rows as CSV