PREVIEW / etf_30min / 2004-11-01
file: by_date/etf_30min/2004/2004-11-01.parquet size: 37 KB rows: 1,285
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 |
|---|---|---|---|---|---|---|---|
| 2004-11-01 08:00:00 | SPY | ETF | 113.48 | 113.52 | 113.48 | 113.48 | 5900.0 |
| 2004-11-01 08:30:00 | SPY | ETF | 113.48 | 113.59 | 113.48 | 113.58 | 21400.0 |
| 2004-11-01 09:00:00 | SPY | ETF | 113.53 | 113.57 | 113.5 | 113.55 | 28600.0 |
| 2004-11-01 09:30:00 | SPY | ETF | 113.56 | 113.59 | 113.37 | 113.45 | 3262100.0 |
| 2004-11-01 10:00:00 | SPY | ETF | 113.45 | 113.46 | 113.2 | 113.29 | 2592600.0 |
| 2004-11-01 10:30:00 | SPY | ETF | 113.29 | 113.52 | 113.24 | 113.46 | 2493700.0 |
| 2004-11-01 11:00:00 | SPY | ETF | 113.46 | 113.84 | 113.43 | 113.72 | 5828100.0 |
| 2004-11-01 11:30:00 | SPY | ETF | 113.73 | 113.76 | 113.58 | 113.64 | 1615400.0 |
| 2004-11-01 12:00:00 | SPY | ETF | 113.64 | 113.71 | 113.49 | 113.59 | 2038500.0 |
| 2004-11-01 12:30:00 | SPY | ETF | 113.59 | 113.66 | 113.55 | 113.57 | 1617100.0 |
| 2004-11-01 13:00:00 | SPY | ETF | 113.58 | 113.59 | 113.2 | 113.26 | 1721800.0 |
| 2004-11-01 13:30:00 | SPY | ETF | 113.27 | 113.38 | 113.2 | 113.37 | 1851700.0 |
| 2004-11-01 14:00:00 | SPY | ETF | 113.37 | 113.4 | 113.22 | 113.31 | 1429300.0 |
| 2004-11-01 14:30:00 | SPY | ETF | 113.31 | 113.6 | 113.25 | 113.51 | 1683400.0 |
| 2004-11-01 15:00:00 | SPY | ETF | 113.53 | 113.57 | 113.37 | 113.47 | 1183700.0 |
| 2004-11-01 15:30:00 | SPY | ETF | 113.46 | 113.54 | 113.35 | 113.49 | 2402700.0 |
| 2004-11-01 16:00:00 | SPY | ETF | 113.49 | 113.58 | 113.45 | 113.53 | 3319000.0 |
| 2004-11-01 16:30:00 | SPY | ETF | 113.52 | 113.52 | 113.45 | 113.48 | 73700.0 |
| 2004-11-01 17:00:00 | SPY | ETF | 113.46 | 113.47 | 113.44 | 113.44 | 28700.0 |
| 2004-11-01 17:30:00 | SPY | ETF | 113.49 | 113.52 | 113.49 | 113.51 | 24000.0 |
| 2004-11-01 18:00:00 | SPY | ETF | 113.47 | 113.47 | 113.47 | 113.47 | 1700.0 |
| 2004-11-01 18:30:00 | SPY | ETF | 113.45 | 113.45 | 113.42 | 113.42 | 1500.0 |
| 2004-11-01 19:00:00 | SPY | ETF | 113.45 | 113.46 | 113.45 | 113.46 | 10000.0 |
| 2004-11-01 08:00:00 | QQQ | ETF | 36.93 | 36.95 | 36.92 | 36.92 | 11900.0 |
| 2004-11-01 08:30:00 | QQQ | ETF | 36.92 | 36.96 | 36.92 | 36.94 | 97200.0 |
| 2004-11-01 09:00:00 | QQQ | ETF | 36.94 | 36.99 | 36.91 | 36.97 | 225000.0 |
| 2004-11-01 09:30:00 | QQQ | ETF | 36.98 | 36.98 | 36.88 | 36.901 | 8025200.0 |
| 2004-11-01 10:00:00 | QQQ | ETF | 36.91 | 36.94 | 36.8 | 36.84 | 5707800.0 |
| 2004-11-01 10:30:00 | QQQ | ETF | 36.84 | 37.09 | 36.8 | 37.02 | 7132500.0 |
| 2004-11-01 11:00:00 | QQQ | ETF | 37.01 | 37.18 | 37.0 | 37.11 | 10228900.0 |
| 2004-11-01 11:30:00 | QQQ | ETF | 37.11 | 37.14 | 37.055 | 37.1 | 4451700.0 |
| 2004-11-01 12:00:00 | QQQ | ETF | 37.1 | 37.165 | 37.01 | 37.055 | 4036600.0 |
| 2004-11-01 12:30:00 | QQQ | ETF | 37.055 | 37.156 | 37.02 | 37.09 | 2887600.0 |
| 2004-11-01 13:00:00 | QQQ | ETF | 37.08 | 37.1 | 36.9 | 36.91 | 4110700.0 |
| 2004-11-01 13:30:00 | QQQ | ETF | 36.92 | 37.01 | 36.86 | 36.986 | 4941200.0 |
| 2004-11-01 14:00:00 | QQQ | ETF | 36.99 | 37.03 | 36.92 | 36.964 | 3851600.0 |
| 2004-11-01 14:30:00 | QQQ | ETF | 36.97 | 37.07 | 36.94 | 37.033 | 4325800.0 |
| 2004-11-01 15:00:00 | QQQ | ETF | 37.04 | 37.042 | 36.94 | 37.02 | 3206800.0 |
| 2004-11-01 15:30:00 | QQQ | ETF | 37.02 | 37.04 | 36.97 | 37.02 | 4478100.0 |
| 2004-11-01 16:00:00 | QQQ | ETF | 37.024 | 37.05 | 36.98 | 37.03 | 2830900.0 |
| 2004-11-01 16:30:00 | QQQ | ETF | 37.03 | 37.03 | 36.92 | 36.932 | 446300.0 |
| 2004-11-01 17:00:00 | QQQ | ETF | 36.936 | 36.95 | 36.92 | 36.933 | 80300.0 |
| 2004-11-01 17:30:00 | QQQ | ETF | 36.94 | 37.01 | 36.92 | 37.01 | 35700.0 |
| 2004-11-01 18:00:00 | QQQ | ETF | 36.932 | 36.96 | 36.92 | 36.94 | 116300.0 |
| 2004-11-01 18:30:00 | QQQ | ETF | 36.93 | 36.93 | 36.93 | 36.93 | 400.0 |
| 2004-11-01 19:00:00 | QQQ | ETF | 36.94 | 36.94 | 36.93 | 36.93 | 3400.0 |
| 2004-11-01 19:30:00 | QQQ | ETF | 36.95 | 36.95 | 36.95 | 36.95 | 30000.0 |
| 2004-11-01 08:00:00 | IWM | ETF | 58.12 | 58.12 | 58.12 | 58.12 | 600.0 |
| 2004-11-01 08:30:00 | IWM | ETF | 58.17 | 58.17 | 58.17 | 58.17 | 1000.0 |
| 2004-11-01 09:00:00 | IWM | ETF | 58.2 | 58.2 | 58.2 | 58.2 | 2000.0 |
> showing 50 of 1,285 rows — these rows as CSV