PREVIEW / etf_30min / 2005-12-19
file: by_date/etf_30min/2005/2005-12-19.parquet size: 57 KB rows: 2,043
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-12-19 07:00:00 | SPY | ETF | 126.8 | 126.86 | 126.79 | 126.86 | 33000.0 |
| 2005-12-19 07:30:00 | SPY | ETF | 126.8 | 126.83 | 126.75 | 126.78 | 17900.0 |
| 2005-12-19 08:00:00 | SPY | ETF | 126.75 | 126.82 | 126.69 | 126.7 | 92200.0 |
| 2005-12-19 08:30:00 | SPY | ETF | 126.7 | 126.76 | 126.7 | 126.75 | 457400.0 |
| 2005-12-19 09:00:00 | SPY | ETF | 126.74 | 126.78 | 126.71 | 126.73 | 108300.0 |
| 2005-12-19 09:30:00 | SPY | ETF | 126.73 | 126.77 | 126.52 | 126.56 | 4442000.0 |
| 2005-12-19 10:00:00 | SPY | ETF | 126.56 | 126.87 | 126.53 | 126.75 | 4118400.0 |
| 2005-12-19 10:30:00 | SPY | ETF | 126.73 | 126.83 | 126.49 | 126.59 | 2301800.0 |
| 2005-12-19 11:00:00 | SPY | ETF | 126.59 | 126.7 | 126.54 | 126.66 | 1944100.0 |
| 2005-12-19 11:30:00 | SPY | ETF | 126.67 | 126.75 | 126.61 | 126.65 | 1456500.0 |
| 2005-12-19 12:00:00 | SPY | ETF | 126.66 | 126.83 | 126.66 | 126.76 | 1266000.0 |
| 2005-12-19 12:30:00 | SPY | ETF | 126.76 | 126.78 | 126.64 | 126.67 | 2087000.0 |
| 2005-12-19 13:00:00 | SPY | ETF | 126.67 | 126.69 | 126.36 | 126.54 | 4990600.0 |
| 2005-12-19 13:30:00 | SPY | ETF | 126.54 | 126.56 | 126.16 | 126.28 | 4891100.0 |
| 2005-12-19 14:00:00 | SPY | ETF | 126.28 | 126.29 | 125.9 | 125.9 | 4435500.0 |
| 2005-12-19 14:30:00 | SPY | ETF | 125.9 | 126.1 | 125.82 | 125.96 | 5119700.0 |
| 2005-12-19 15:00:00 | SPY | ETF | 125.95 | 126.03 | 125.74 | 125.8 | 3164200.0 |
| 2005-12-19 15:30:00 | SPY | ETF | 125.79 | 125.84 | 125.69 | 125.78 | 4995000.0 |
| 2005-12-19 16:00:00 | SPY | ETF | 125.79 | 125.86 | 125.7 | 125.82 | 658800.0 |
| 2005-12-19 16:30:00 | SPY | ETF | 125.82 | 125.86 | 125.79 | 125.84 | 126900.0 |
| 2005-12-19 17:00:00 | SPY | ETF | 125.8 | 125.81 | 125.74 | 125.74 | 15900.0 |
| 2005-12-19 17:30:00 | SPY | ETF | 125.74 | 125.75 | 125.73 | 125.73 | 110300.0 |
| 2005-12-19 18:00:00 | SPY | ETF | 125.74 | 125.83 | 125.74 | 125.83 | 61100.0 |
| 2005-12-19 18:30:00 | SPY | ETF | 125.75 | 125.75 | 125.75 | 125.75 | 200.0 |
| 2005-12-19 19:00:00 | SPY | ETF | 125.76 | 125.8 | 125.76 | 125.8 | 1400.0 |
| 2005-12-19 09:30:00 | QQQ | ETF | 41.68 | 41.71 | 41.44 | 41.5 | 11640200.0 |
| 2005-12-19 10:00:00 | QQQ | ETF | 41.51 | 41.66 | 41.47 | 41.59 | 5248500.0 |
| 2005-12-19 10:30:00 | QQQ | ETF | 41.59 | 41.63 | 41.5 | 41.55 | 3722800.0 |
| 2005-12-19 11:00:00 | QQQ | ETF | 41.55 | 41.62 | 41.54 | 41.61 | 3710700.0 |
| 2005-12-19 11:30:00 | QQQ | ETF | 41.61 | 41.62 | 41.55 | 41.56 | 2053600.0 |
| 2005-12-19 12:00:00 | QQQ | ETF | 41.56 | 41.59 | 41.54 | 41.57 | 1814000.0 |
| 2005-12-19 12:30:00 | QQQ | ETF | 41.57 | 41.57 | 41.53 | 41.54 | 1351400.0 |
| 2005-12-19 13:00:00 | QQQ | ETF | 41.53 | 41.53 | 41.34 | 41.42 | 5866500.0 |
| 2005-12-19 13:30:00 | QQQ | ETF | 41.43 | 41.44 | 41.22 | 41.29 | 6549400.0 |
| 2005-12-19 14:00:00 | QQQ | ETF | 41.29 | 41.32 | 41.19 | 41.19 | 4741700.0 |
| 2005-12-19 14:30:00 | QQQ | ETF | 41.19 | 41.28 | 41.17 | 41.23 | 3931400.0 |
| 2005-12-19 15:00:00 | QQQ | ETF | 41.23 | 41.24 | 41.04 | 41.07 | 7893400.0 |
| 2005-12-19 15:30:00 | QQQ | ETF | 41.06 | 41.1 | 40.0 | 40.92 | 12533700.0 |
| 2005-12-19 07:30:00 | IWM | ETF | 68.01 | 68.02 | 67.93 | 67.93 | 2300.0 |
| 2005-12-19 08:00:00 | IWM | ETF | 67.94 | 67.94 | 67.94 | 67.94 | 100.0 |
| 2005-12-19 08:30:00 | IWM | ETF | 67.97 | 67.97 | 67.97 | 67.97 | 20000.0 |
| 2005-12-19 09:00:00 | IWM | ETF | 67.95 | 67.97 | 67.84 | 67.95 | 262200.0 |
| 2005-12-19 09:30:00 | IWM | ETF | 67.95 | 67.97 | 67.47 | 67.52 | 1877000.0 |
| 2005-12-19 10:00:00 | IWM | ETF | 67.52 | 67.72 | 67.5 | 67.58 | 1227200.0 |
| 2005-12-19 10:30:00 | IWM | ETF | 67.59 | 67.66 | 67.42 | 67.49 | 1190200.0 |
| 2005-12-19 11:00:00 | IWM | ETF | 67.49 | 67.64 | 67.48 | 67.6 | 710000.0 |
| 2005-12-19 11:30:00 | IWM | ETF | 67.6 | 67.62 | 67.51 | 67.53 | 528100.0 |
| 2005-12-19 12:00:00 | IWM | ETF | 67.53 | 67.58 | 67.5 | 67.54 | 431700.0 |
| 2005-12-19 12:30:00 | IWM | ETF | 67.54 | 67.58 | 67.48 | 67.55 | 764300.0 |
| 2005-12-19 13:00:00 | IWM | ETF | 67.55 | 67.56 | 67.34 | 67.41 | 1728400.0 |
> showing 50 of 2,043 rows — these rows as CSV