PREVIEW / etf_30min / 2005-06-14
file: by_date/etf_30min/2005/2005-06-14.parquet size: 42 KB rows: 1,498
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-14 06:30:00 | SPY | ETF | 120.56 | 120.56 | 120.56 | 120.56 | 1000.0 |
| 2005-06-14 07:00:00 | SPY | ETF | 120.56 | 120.56 | 120.45 | 120.46 | 83800.0 |
| 2005-06-14 07:30:00 | SPY | ETF | 120.43 | 120.55 | 120.43 | 120.55 | 28000.0 |
| 2005-06-14 08:00:00 | SPY | ETF | 120.57 | 120.66 | 120.55 | 120.55 | 133100.0 |
| 2005-06-14 08:30:00 | SPY | ETF | 120.65 | 120.86 | 120.58 | 120.66 | 483200.0 |
| 2005-06-14 09:00:00 | SPY | ETF | 120.62 | 120.62 | 120.41 | 120.43 | 219200.0 |
| 2005-06-14 09:30:00 | SPY | ETF | 120.45 | 120.78 | 120.38 | 120.72 | 6127400.0 |
| 2005-06-14 10:00:00 | SPY | ETF | 120.72 | 120.86 | 120.48 | 120.52 | 3609500.0 |
| 2005-06-14 10:30:00 | SPY | ETF | 120.53 | 120.69 | 120.49 | 120.57 | 1918300.0 |
| 2005-06-14 11:00:00 | SPY | ETF | 120.57 | 120.7 | 120.53 | 120.56 | 1278700.0 |
| 2005-06-14 11:30:00 | SPY | ETF | 120.57 | 120.79 | 120.54 | 120.73 | 1317800.0 |
| 2005-06-14 12:00:00 | SPY | ETF | 120.73 | 120.74 | 120.59 | 120.63 | 916400.0 |
| 2005-06-14 12:30:00 | SPY | ETF | 120.63 | 120.75 | 120.6 | 120.6992 | 809900.0 |
| 2005-06-14 13:00:00 | SPY | ETF | 120.7 | 120.7 | 120.51 | 120.64 | 1499200.0 |
| 2005-06-14 13:30:00 | SPY | ETF | 120.64 | 121.14 | 120.57 | 121.13 | 3317900.0 |
| 2005-06-14 14:00:00 | SPY | ETF | 121.13 | 121.2 | 120.61 | 120.74 | 4146000.0 |
| 2005-06-14 14:30:00 | SPY | ETF | 120.74 | 120.8 | 120.56 | 120.72 | 1994500.0 |
| 2005-06-14 15:00:00 | SPY | ETF | 120.72 | 120.85 | 120.63 | 120.74 | 1377800.0 |
| 2005-06-14 15:30:00 | SPY | ETF | 120.74 | 120.84 | 120.62 | 120.83 | 2982700.0 |
| 2005-06-14 16:00:00 | SPY | ETF | 120.84 | 120.95 | 120.77 | 120.8 | 1066200.0 |
| 2005-06-14 16:30:00 | SPY | ETF | 120.81 | 120.84 | 120.8 | 120.84 | 115400.0 |
| 2005-06-14 17:00:00 | SPY | ETF | 120.81 | 120.82 | 120.78 | 120.8 | 25600.0 |
| 2005-06-14 17:30:00 | SPY | ETF | 120.77 | 120.85 | 120.77 | 120.84 | 3000.0 |
| 2005-06-14 18:00:00 | SPY | ETF | 120.78 | 120.79 | 120.78 | 120.79 | 500.0 |
| 2005-06-14 09:30:00 | QQQ | ETF | 37.69 | 37.84 | 37.63 | 37.79 | 8412000.0 |
| 2005-06-14 10:00:00 | QQQ | ETF | 37.79 | 37.79 | 37.6 | 37.61 | 6690400.0 |
| 2005-06-14 10:30:00 | QQQ | ETF | 37.62 | 37.67 | 37.59 | 37.63 | 4606600.0 |
| 2005-06-14 11:00:00 | QQQ | ETF | 37.62 | 37.67 | 37.6 | 37.6 | 2216200.0 |
| 2005-06-14 11:30:00 | QQQ | ETF | 37.6 | 37.64 | 37.58 | 37.63 | 2105300.0 |
| 2005-06-14 12:00:00 | QQQ | ETF | 37.63 | 37.64 | 37.55 | 37.55 | 2961200.0 |
| 2005-06-14 12:30:00 | QQQ | ETF | 37.56 | 37.61 | 37.54 | 37.6 | 2536800.0 |
| 2005-06-14 13:00:00 | QQQ | ETF | 37.59 | 37.6 | 37.52 | 37.56 | 3118500.0 |
| 2005-06-14 13:30:00 | QQQ | ETF | 37.56 | 37.69 | 37.54 | 37.69 | 5182900.0 |
| 2005-06-14 14:00:00 | QQQ | ETF | 37.69 | 37.73 | 37.53 | 37.57 | 5337800.0 |
| 2005-06-14 14:30:00 | QQQ | ETF | 37.56 | 37.58 | 37.51 | 37.54 | 2668900.0 |
| 2005-06-14 15:00:00 | QQQ | ETF | 37.53 | 37.61 | 37.51 | 37.55 | 4182200.0 |
| 2005-06-14 15:30:00 | QQQ | ETF | 37.55 | 37.59 | 37.5 | 37.59 | 4392600.0 |
| 2005-06-14 07:00:00 | IWM | ETF | 62.63 | 62.63 | 62.63 | 62.63 | 200.0 |
| 2005-06-14 08:30:00 | IWM | ETF | 62.66 | 62.66 | 62.66 | 62.66 | 200.0 |
| 2005-06-14 09:00:00 | IWM | ETF | 62.62 | 62.62 | 62.55 | 62.55 | 5300.0 |
| 2005-06-14 09:30:00 | IWM | ETF | 62.7 | 62.81 | 62.47 | 62.79 | 2226800.0 |
| 2005-06-14 10:00:00 | IWM | ETF | 62.79 | 62.94 | 62.66 | 62.68 | 2278900.0 |
| 2005-06-14 10:30:00 | IWM | ETF | 62.69 | 62.81 | 62.64 | 62.74 | 813100.0 |
| 2005-06-14 11:00:00 | IWM | ETF | 62.73 | 62.86 | 62.72 | 62.82 | 836000.0 |
| 2005-06-14 11:30:00 | IWM | ETF | 62.82 | 62.9 | 62.75 | 62.84 | 437000.0 |
| 2005-06-14 12:00:00 | IWM | ETF | 62.84 | 62.87 | 62.78 | 62.83 | 373400.0 |
| 2005-06-14 12:30:00 | IWM | ETF | 62.82 | 62.91 | 62.81 | 62.87 | 297900.0 |
| 2005-06-14 13:00:00 | IWM | ETF | 62.87 | 62.87 | 62.7 | 62.83 | 745800.0 |
| 2005-06-14 13:30:00 | IWM | ETF | 62.82 | 63.12 | 62.79 | 63.12 | 1181700.0 |
| 2005-06-14 14:00:00 | IWM | ETF | 63.13 | 63.17 | 62.82 | 62.91 | 1467100.0 |
> showing 50 of 1,498 rows — these rows as CSV