PREVIEW / etf_30min / 2003-05-13
file: by_date/etf_30min/2003/2003-05-13.parquet size: 23 KB rows: 683
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 |
|---|---|---|---|---|---|---|---|
| 2003-05-13 08:00:00 | SPY | ETF | 94.44 | 94.5 | 94.37 | 94.5 | 33400.0 |
| 2003-05-13 08:30:00 | SPY | ETF | 94.51 | 94.58 | 94.44 | 94.45 | 30700.0 |
| 2003-05-13 09:00:00 | SPY | ETF | 94.46 | 94.59 | 94.46 | 94.59 | 22200.0 |
| 2003-05-13 09:30:00 | SPY | ETF | 94.53 | 94.72 | 94.33 | 94.55 | 4406800.0 |
| 2003-05-13 10:00:00 | SPY | ETF | 94.55 | 94.81 | 94.48 | 94.5 | 2909000.0 |
| 2003-05-13 10:30:00 | SPY | ETF | 94.5 | 94.73 | 94.3 | 94.7 | 2876700.0 |
| 2003-05-13 11:00:00 | SPY | ETF | 94.7 | 94.86 | 94.64 | 94.69 | 1629100.0 |
| 2003-05-13 11:30:00 | SPY | ETF | 94.69 | 94.87 | 94.53 | 94.86 | 1523700.0 |
| 2003-05-13 12:00:00 | SPY | ETF | 94.87 | 94.97 | 94.7 | 94.87 | 4229900.0 |
| 2003-05-13 12:30:00 | SPY | ETF | 94.87 | 95.1 | 94.82 | 95.07 | 1937100.0 |
| 2003-05-13 13:00:00 | SPY | ETF | 95.08 | 95.18 | 94.78 | 94.82 | 2271600.0 |
| 2003-05-13 13:30:00 | SPY | ETF | 94.81 | 94.89 | 94.57 | 94.6 | 1789500.0 |
| 2003-05-13 14:00:00 | SPY | ETF | 94.61 | 94.67 | 94.26 | 94.4 | 2885200.0 |
| 2003-05-13 14:30:00 | SPY | ETF | 94.4 | 94.61 | 94.33 | 94.53 | 2732000.0 |
| 2003-05-13 15:00:00 | SPY | ETF | 94.55 | 94.69 | 94.4 | 94.43 | 1202800.0 |
| 2003-05-13 15:30:00 | SPY | ETF | 94.45 | 94.65 | 94.37 | 94.64 | 2599700.0 |
| 2003-05-13 16:00:00 | SPY | ETF | 94.63 | 94.81 | 94.57 | 94.71 | 2438100.0 |
| 2003-05-13 16:30:00 | SPY | ETF | 94.71 | 94.71 | 94.64 | 94.66 | 103300.0 |
| 2003-05-13 17:00:00 | SPY | ETF | 94.66 | 94.67 | 94.58 | 94.61 | 70900.0 |
| 2003-05-13 17:30:00 | SPY | ETF | 94.65 | 94.71 | 94.65 | 94.68 | 35100.0 |
| 2003-05-13 18:00:00 | SPY | ETF | 94.67 | 94.7 | 94.66 | 94.67 | 5400.0 |
| 2003-05-13 18:30:00 | SPY | ETF | 94.69 | 94.7 | 94.69 | 94.7 | 2100.0 |
| 2003-05-13 19:00:00 | SPY | ETF | 94.7 | 94.7 | 94.66 | 94.66 | 1300.0 |
| 2003-05-13 19:30:00 | SPY | ETF | 94.66 | 94.67 | 94.66 | 94.66 | 700.0 |
| 2003-05-13 08:00:00 | QQQ | ETF | 28.6 | 28.63 | 28.56 | 28.62 | 28900.0 |
| 2003-05-13 08:30:00 | QQQ | ETF | 28.6 | 28.62 | 28.57 | 28.6 | 78300.0 |
| 2003-05-13 09:00:00 | QQQ | ETF | 28.59 | 28.64 | 28.58 | 28.63 | 54400.0 |
| 2003-05-13 09:30:00 | QQQ | ETF | 28.63 | 28.76 | 28.55 | 28.66 | 9119700.0 |
| 2003-05-13 10:00:00 | QQQ | ETF | 28.65 | 28.76 | 28.59 | 28.6 | 6503100.0 |
| 2003-05-13 10:30:00 | QQQ | ETF | 28.61 | 28.74 | 28.54 | 28.72 | 4443400.0 |
| 2003-05-13 11:00:00 | QQQ | ETF | 28.73 | 28.79 | 28.65 | 28.73 | 3058800.0 |
| 2003-05-13 11:30:00 | QQQ | ETF | 28.72 | 28.85 | 28.66 | 28.83 | 3247300.0 |
| 2003-05-13 12:00:00 | QQQ | ETF | 28.84 | 28.9 | 28.79 | 28.86 | 3536700.0 |
| 2003-05-13 12:30:00 | QQQ | ETF | 28.86 | 28.95 | 28.84 | 28.93 | 3290000.0 |
| 2003-05-13 13:00:00 | QQQ | ETF | 28.93 | 28.99 | 28.82 | 28.84 | 3966100.0 |
| 2003-05-13 13:30:00 | QQQ | ETF | 28.85 | 28.88 | 28.71 | 28.73 | 4591900.0 |
| 2003-05-13 14:00:00 | QQQ | ETF | 28.73 | 28.77 | 28.61 | 28.67 | 5238900.0 |
| 2003-05-13 14:30:00 | QQQ | ETF | 28.7 | 28.76 | 28.66 | 28.74 | 2229100.0 |
| 2003-05-13 15:00:00 | QQQ | ETF | 28.74 | 28.78 | 28.63 | 28.66 | 2826300.0 |
| 2003-05-13 15:30:00 | QQQ | ETF | 28.66 | 28.79 | 28.64 | 28.72 | 3558000.0 |
| 2003-05-13 16:00:00 | QQQ | ETF | 28.73 | 28.76 | 28.64 | 28.66 | 3119400.0 |
| 2003-05-13 16:30:00 | QQQ | ETF | 28.66 | 28.74 | 28.62 | 28.63 | 404600.0 |
| 2003-05-13 17:00:00 | QQQ | ETF | 28.63 | 28.63 | 28.56 | 28.57 | 1094800.0 |
| 2003-05-13 17:30:00 | QQQ | ETF | 28.58 | 28.63 | 28.56 | 28.62 | 196000.0 |
| 2003-05-13 18:00:00 | QQQ | ETF | 28.6 | 28.63 | 28.58 | 28.58 | 52600.0 |
| 2003-05-13 18:30:00 | QQQ | ETF | 28.58 | 28.62 | 28.58 | 28.62 | 2700.0 |
| 2003-05-13 19:00:00 | QQQ | ETF | 28.61 | 28.62 | 28.61 | 28.62 | 4400.0 |
| 2003-05-13 19:30:00 | QQQ | ETF | 28.62 | 28.64 | 28.62 | 28.62 | 12600.0 |
| 2003-05-13 09:30:00 | IWM | ETF | 41.685 | 41.685 | 41.375 | 41.55 | 484000.0 |
| 2003-05-13 10:00:00 | IWM | ETF | 41.555 | 41.63 | 41.515 | 41.55 | 153200.0 |
> showing 50 of 683 rows — these rows as CSV