PREVIEW / etf_30min / 2005-06-22
file: by_date/etf_30min/2005/2005-06-22.parquet size: 43 KB rows: 1,503
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-22 07:00:00 | SPY | ETF | 121.76 | 121.79 | 121.76 | 121.79 | 3100.0 |
| 2005-06-22 07:30:00 | SPY | ETF | 121.8 | 121.83 | 121.79 | 121.79 | 28000.0 |
| 2005-06-22 08:00:00 | SPY | ETF | 121.79 | 121.8 | 121.74 | 121.76 | 37800.0 |
| 2005-06-22 08:30:00 | SPY | ETF | 121.78 | 121.8 | 121.77 | 121.8 | 17100.0 |
| 2005-06-22 09:00:00 | SPY | ETF | 121.79 | 121.8 | 121.69 | 121.69 | 105900.0 |
| 2005-06-22 09:30:00 | SPY | ETF | 121.68 | 121.94 | 121.59 | 121.62 | 5767000.0 |
| 2005-06-22 10:00:00 | SPY | ETF | 121.63 | 121.85 | 121.46 | 121.56 | 2427200.0 |
| 2005-06-22 10:30:00 | SPY | ETF | 121.54 | 121.76 | 121.16 | 121.23 | 5051200.0 |
| 2005-06-22 11:00:00 | SPY | ETF | 121.25 | 121.36 | 121.1 | 121.3 | 2837300.0 |
| 2005-06-22 11:30:00 | SPY | ETF | 121.31 | 121.35 | 121.15 | 121.19 | 1953600.0 |
| 2005-06-22 12:00:00 | SPY | ETF | 121.19 | 121.4 | 121.16 | 121.3 | 1211600.0 |
| 2005-06-22 12:30:00 | SPY | ETF | 121.3 | 121.47 | 121.25 | 121.44 | 2482400.0 |
| 2005-06-22 13:00:00 | SPY | ETF | 121.44 | 121.54 | 121.4 | 121.45 | 1974000.0 |
| 2005-06-22 13:30:00 | SPY | ETF | 121.45 | 121.45 | 121.27 | 121.3 | 1041400.0 |
| 2005-06-22 14:00:00 | SPY | ETF | 121.28 | 121.32 | 121.07 | 121.29 | 3333600.0 |
| 2005-06-22 14:30:00 | SPY | ETF | 121.3 | 121.41 | 121.18 | 121.4 | 2410500.0 |
| 2005-06-22 15:00:00 | SPY | ETF | 121.4 | 121.51 | 121.24 | 121.36 | 2528200.0 |
| 2005-06-22 15:30:00 | SPY | ETF | 121.35 | 121.45 | 121.27 | 121.38 | 3613200.0 |
| 2005-06-22 16:00:00 | SPY | ETF | 121.39 | 121.7 | 121.27 | 121.27 | 2366700.0 |
| 2005-06-22 16:30:00 | SPY | ETF | 121.57 | 121.57 | 121.49 | 121.52 | 211700.0 |
| 2005-06-22 17:00:00 | SPY | ETF | 121.52 | 121.55 | 121.51 | 121.55 | 5600.0 |
| 2005-06-22 17:30:00 | SPY | ETF | 121.56 | 121.57 | 121.53 | 121.57 | 302000.0 |
| 2005-06-22 18:00:00 | SPY | ETF | 121.53 | 121.55 | 121.53 | 121.54 | 6700.0 |
| 2005-06-22 18:30:00 | SPY | ETF | 121.57 | 121.57 | 121.57 | 121.57 | 2000.0 |
| 2005-06-22 19:00:00 | SPY | ETF | 121.53 | 121.53 | 121.53 | 121.53 | 300.0 |
| 2005-06-22 19:30:00 | SPY | ETF | 121.53 | 121.54 | 121.53 | 121.54 | 3400.0 |
| 2005-06-22 09:30:00 | QQQ | ETF | 38.0 | 38.1 | 37.94 | 37.94 | 10661700.0 |
| 2005-06-22 10:00:00 | QQQ | ETF | 37.94 | 37.98 | 37.88 | 37.9 | 6174100.0 |
| 2005-06-22 10:30:00 | QQQ | ETF | 37.9 | 38.02 | 37.71 | 37.74 | 10352100.0 |
| 2005-06-22 11:00:00 | QQQ | ETF | 37.75 | 37.76 | 37.63 | 37.71 | 10269700.0 |
| 2005-06-22 11:30:00 | QQQ | ETF | 37.7 | 37.76 | 37.66 | 37.69 | 7076100.0 |
| 2005-06-22 12:00:00 | QQQ | ETF | 37.69 | 37.77 | 37.69 | 37.76 | 1787700.0 |
| 2005-06-22 12:30:00 | QQQ | ETF | 37.76 | 37.87 | 37.72 | 37.86 | 2948100.0 |
| 2005-06-22 13:00:00 | QQQ | ETF | 37.86 | 37.91 | 37.86 | 37.86 | 4457500.0 |
| 2005-06-22 13:30:00 | QQQ | ETF | 37.86 | 37.87 | 37.8 | 37.82 | 2002500.0 |
| 2005-06-22 14:00:00 | QQQ | ETF | 37.81 | 37.82 | 37.74 | 37.81 | 4555900.0 |
| 2005-06-22 14:30:00 | QQQ | ETF | 37.81 | 37.84 | 37.75 | 37.81 | 4328100.0 |
| 2005-06-22 15:00:00 | QQQ | ETF | 37.81 | 37.87 | 37.78 | 37.78 | 2961800.0 |
| 2005-06-22 15:30:00 | QQQ | ETF | 37.78 | 37.84 | 37.76 | 37.83 | 4962900.0 |
| 2005-06-22 08:00:00 | IWM | ETF | 64.02 | 64.02 | 64.02 | 64.02 | 2000.0 |
| 2005-06-22 08:30:00 | IWM | ETF | 64.08 | 64.11 | 64.08 | 64.11 | 12000.0 |
| 2005-06-22 09:00:00 | IWM | ETF | 64.07 | 64.09 | 64.0 | 64.0 | 25900.0 |
| 2005-06-22 09:30:00 | IWM | ETF | 63.97 | 64.22 | 63.93 | 63.93 | 2516900.0 |
| 2005-06-22 10:00:00 | IWM | ETF | 63.93 | 64.0 | 63.82 | 63.86 | 1928600.0 |
| 2005-06-22 10:30:00 | IWM | ETF | 63.85 | 63.95 | 63.65 | 63.69 | 1513800.0 |
| 2005-06-22 11:00:00 | IWM | ETF | 63.68 | 63.72 | 63.49 | 63.65 | 875400.0 |
| 2005-06-22 11:30:00 | IWM | ETF | 63.65 | 63.76 | 63.54 | 63.55 | 950700.0 |
| 2005-06-22 12:00:00 | IWM | ETF | 63.56 | 63.69 | 63.55 | 63.67 | 159300.0 |
| 2005-06-22 12:30:00 | IWM | ETF | 63.67 | 63.81 | 63.63 | 63.78 | 320700.0 |
| 2005-06-22 13:00:00 | IWM | ETF | 63.79 | 63.96 | 63.79 | 63.88 | 1931100.0 |
> showing 50 of 1,503 rows — these rows as CSV