PREVIEW / etf_30min / 2005-01-06
file: by_date/etf_30min/2005/2005-01-06.parquet size: 42 KB rows: 1,446
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-01-06 08:00:00 | SPY | ETF | 118.49 | 118.49 | 118.4 | 118.42 | 215600.0 |
| 2005-01-06 08:30:00 | SPY | ETF | 118.39 | 118.46 | 118.35 | 118.43 | 81800.0 |
| 2005-01-06 09:00:00 | SPY | ETF | 118.44 | 118.52 | 118.43 | 118.44 | 32600.0 |
| 2005-01-06 09:30:00 | SPY | ETF | 118.44 | 118.69 | 118.39 | 118.54 | 5283900.0 |
| 2005-01-06 10:00:00 | SPY | ETF | 118.55 | 118.7 | 118.4 | 118.6 | 4442900.0 |
| 2005-01-06 10:30:00 | SPY | ETF | 118.62 | 118.62 | 118.26 | 118.35 | 4864100.0 |
| 2005-01-06 11:00:00 | SPY | ETF | 118.34 | 118.79 | 118.3 | 118.76 | 5350100.0 |
| 2005-01-06 11:30:00 | SPY | ETF | 118.76 | 118.98 | 118.68 | 118.74 | 3613200.0 |
| 2005-01-06 12:00:00 | SPY | ETF | 118.75 | 118.87 | 118.64 | 118.78 | 1348500.0 |
| 2005-01-06 12:30:00 | SPY | ETF | 118.78 | 118.81 | 118.6 | 118.61 | 1373900.0 |
| 2005-01-06 13:00:00 | SPY | ETF | 118.62 | 119.04 | 118.55 | 118.94 | 2295300.0 |
| 2005-01-06 13:30:00 | SPY | ETF | 118.94 | 119.14 | 118.87 | 119.08 | 3422100.0 |
| 2005-01-06 14:00:00 | SPY | ETF | 119.08 | 119.15 | 118.93 | 119.05 | 2251300.0 |
| 2005-01-06 14:30:00 | SPY | ETF | 119.05 | 119.11 | 118.8 | 118.8 | 2736700.0 |
| 2005-01-06 15:00:00 | SPY | ETF | 118.83 | 118.88 | 118.59 | 118.71 | 3717400.0 |
| 2005-01-06 15:30:00 | SPY | ETF | 118.71 | 118.91 | 118.68 | 118.71 | 4498400.0 |
| 2005-01-06 16:00:00 | SPY | ETF | 118.73 | 118.79 | 118.6 | 118.6 | 1164500.0 |
| 2005-01-06 16:30:00 | SPY | ETF | 118.6 | 118.65 | 118.58 | 118.65 | 250200.0 |
| 2005-01-06 17:00:00 | SPY | ETF | 118.64 | 118.7 | 118.6 | 118.62 | 23900.0 |
| 2005-01-06 17:30:00 | SPY | ETF | 118.64 | 118.64 | 118.62 | 118.63 | 3900.0 |
| 2005-01-06 18:00:00 | SPY | ETF | 118.66 | 118.73 | 118.63 | 118.73 | 459700.0 |
| 2005-01-06 19:00:00 | SPY | ETF | 118.62 | 118.62 | 118.61 | 118.61 | 9200.0 |
| 2005-01-06 09:30:00 | QQQ | ETF | 38.62 | 38.71 | 38.54 | 38.63 | 15092100.0 |
| 2005-01-06 10:00:00 | QQQ | ETF | 38.64 | 38.67 | 38.51 | 38.61 | 8038000.0 |
| 2005-01-06 10:30:00 | QQQ | ETF | 38.62 | 38.63 | 38.38 | 38.43 | 11780700.0 |
| 2005-01-06 11:00:00 | QQQ | ETF | 38.43 | 38.62 | 38.39 | 38.61 | 9565500.0 |
| 2005-01-06 11:30:00 | QQQ | ETF | 38.61 | 38.7 | 38.53 | 38.56 | 6240600.0 |
| 2005-01-06 12:00:00 | QQQ | ETF | 38.57 | 38.6 | 38.49 | 38.58 | 4256600.0 |
| 2005-01-06 12:30:00 | QQQ | ETF | 38.57 | 38.6 | 38.5 | 38.5 | 2576100.0 |
| 2005-01-06 13:00:00 | QQQ | ETF | 38.5 | 38.59 | 38.44 | 38.54 | 4814600.0 |
| 2005-01-06 13:30:00 | QQQ | ETF | 38.53 | 38.7 | 38.53 | 38.66 | 5562900.0 |
| 2005-01-06 14:00:00 | QQQ | ETF | 38.65 | 38.67 | 38.56 | 38.64 | 3756800.0 |
| 2005-01-06 14:30:00 | QQQ | ETF | 38.64 | 38.64 | 38.5 | 38.51 | 3826000.0 |
| 2005-01-06 15:00:00 | QQQ | ETF | 38.51 | 38.53 | 38.4 | 38.46 | 7489200.0 |
| 2005-01-06 15:30:00 | QQQ | ETF | 38.45 | 38.55 | 38.35 | 38.35 | 9028100.0 |
| 2005-01-06 08:00:00 | IWM | ETF | 61.605 | 61.605 | 61.605 | 61.605 | 1000.0 |
| 2005-01-06 08:30:00 | IWM | ETF | 61.565 | 61.85 | 61.565 | 61.695 | 70400.0 |
| 2005-01-06 09:00:00 | IWM | ETF | 61.675 | 61.745 | 61.65 | 61.715 | 79400.0 |
| 2005-01-06 09:30:00 | IWM | ETF | 61.67 | 61.9 | 61.225 | 61.735 | 4833600.0 |
| 2005-01-06 10:00:00 | IWM | ETF | 61.74 | 61.875 | 61.555 | 61.795 | 2184400.0 |
| 2005-01-06 10:30:00 | IWM | ETF | 61.78 | 61.85 | 61.425 | 61.455 | 1863600.0 |
| 2005-01-06 11:00:00 | IWM | ETF | 61.445 | 61.825 | 61.34 | 61.805 | 3339800.0 |
| 2005-01-06 11:30:00 | IWM | ETF | 61.82 | 62.0 | 61.8 | 61.86 | 1328000.0 |
| 2005-01-06 12:00:00 | IWM | ETF | 61.87 | 61.92 | 61.805 | 61.8749 | 778000.0 |
| 2005-01-06 12:30:00 | IWM | ETF | 61.875 | 61.88 | 61.725 | 61.725 | 469600.0 |
| 2005-01-06 13:00:00 | IWM | ETF | 61.735 | 61.93 | 61.66 | 61.8 | 906800.0 |
| 2005-01-06 13:30:00 | IWM | ETF | 61.805 | 62.2 | 61.755 | 62.06 | 1309200.0 |
| 2005-01-06 14:00:00 | IWM | ETF | 62.065 | 62.095 | 61.955 | 62.03 | 646400.0 |
| 2005-01-06 14:30:00 | IWM | ETF | 62.055 | 62.1 | 61.865 | 61.875 | 957600.0 |
| 2005-01-06 15:00:00 | IWM | ETF | 61.87 | 61.985 | 61.725 | 61.785 | 1052400.0 |
> showing 50 of 1,446 rows — these rows as CSV