PREVIEW / etf_30min / 2003-11-13
file: by_date/etf_30min/2003/2003-11-13.parquet size: 26 KB rows: 829
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-11-13 08:00:00 | SPY | ETF | 106.27 | 106.36 | 106.26 | 106.34 | 7100.0 |
| 2003-11-13 08:30:00 | SPY | ETF | 106.3 | 106.3 | 105.99 | 106.04 | 371800.0 |
| 2003-11-13 09:00:00 | SPY | ETF | 106.04 | 106.05 | 105.99 | 105.99 | 20400.0 |
| 2003-11-13 09:30:00 | SPY | ETF | 106.01 | 106.15 | 105.9 | 106.08 | 3463300.0 |
| 2003-11-13 10:00:00 | SPY | ETF | 106.11 | 106.24 | 105.96 | 106.06 | 3014300.0 |
| 2003-11-13 10:30:00 | SPY | ETF | 106.06 | 106.09 | 105.78 | 105.85 | 1926300.0 |
| 2003-11-13 11:00:00 | SPY | ETF | 105.84 | 105.99 | 105.81 | 105.99 | 954400.0 |
| 2003-11-13 11:30:00 | SPY | ETF | 105.97 | 106.14 | 105.9 | 106.1 | 2285600.0 |
| 2003-11-13 12:00:00 | SPY | ETF | 106.1 | 106.13 | 106.0 | 106.1 | 1099800.0 |
| 2003-11-13 12:30:00 | SPY | ETF | 106.09 | 106.25 | 106.03 | 106.24 | 1520000.0 |
| 2003-11-13 13:00:00 | SPY | ETF | 106.24 | 106.25 | 106.0 | 106.06 | 816900.0 |
| 2003-11-13 13:30:00 | SPY | ETF | 106.05 | 106.16 | 105.99 | 106.08 | 520500.0 |
| 2003-11-13 14:00:00 | SPY | ETF | 106.07 | 106.12 | 105.91 | 106.05 | 885100.0 |
| 2003-11-13 14:30:00 | SPY | ETF | 106.04 | 106.33 | 105.96 | 106.31 | 1448100.0 |
| 2003-11-13 15:00:00 | SPY | ETF | 106.31 | 106.52 | 106.17 | 106.18 | 3848800.0 |
| 2003-11-13 15:30:00 | SPY | ETF | 106.18 | 106.5 | 106.16 | 106.35 | 2138500.0 |
| 2003-11-13 16:00:00 | SPY | ETF | 106.36 | 106.45 | 106.2598 | 106.35 | 2222500.0 |
| 2003-11-13 16:30:00 | SPY | ETF | 106.37 | 106.4 | 106.31 | 106.31 | 43100.0 |
| 2003-11-13 17:00:00 | SPY | ETF | 106.32 | 106.32 | 106.23 | 106.27 | 470300.0 |
| 2003-11-13 17:30:00 | SPY | ETF | 106.24 | 106.26 | 106.23 | 106.25 | 7000.0 |
| 2003-11-13 18:00:00 | SPY | ETF | 106.26 | 106.34 | 106.26 | 106.34 | 800.0 |
| 2003-11-13 18:30:00 | SPY | ETF | 106.36 | 106.36 | 106.35 | 106.35 | 700.0 |
| 2003-11-13 19:00:00 | SPY | ETF | 106.32 | 106.32 | 106.32 | 106.32 | 500.0 |
| 2003-11-13 19:30:00 | SPY | ETF | 106.31 | 106.31 | 106.31 | 106.31 | 300.0 |
| 2003-11-13 08:00:00 | QQQ | ETF | 35.89 | 35.93 | 35.87 | 35.9 | 52000.0 |
| 2003-11-13 08:30:00 | QQQ | ETF | 35.91 | 35.91 | 35.66 | 35.68 | 219000.0 |
| 2003-11-13 09:00:00 | QQQ | ETF | 35.69 | 35.73 | 35.69 | 35.71 | 68000.0 |
| 2003-11-13 09:30:00 | QQQ | ETF | 35.71 | 35.83 | 35.61 | 35.74 | 8519800.0 |
| 2003-11-13 10:00:00 | QQQ | ETF | 35.75 | 35.82 | 35.66 | 35.744 | 7027300.0 |
| 2003-11-13 10:30:00 | QQQ | ETF | 35.74 | 35.76 | 35.55 | 35.59 | 4675900.0 |
| 2003-11-13 11:00:00 | QQQ | ETF | 35.585 | 35.67 | 35.55 | 35.62 | 2595400.0 |
| 2003-11-13 11:30:00 | QQQ | ETF | 35.6 | 35.73 | 35.595 | 35.7 | 2186700.0 |
| 2003-11-13 12:00:00 | QQQ | ETF | 35.69 | 35.73 | 35.62 | 35.69 | 2742700.0 |
| 2003-11-13 12:30:00 | QQQ | ETF | 35.69 | 35.763 | 35.65 | 35.76 | 2866200.0 |
| 2003-11-13 13:00:00 | QQQ | ETF | 35.75 | 35.76 | 35.6 | 35.64 | 2343200.0 |
| 2003-11-13 13:30:00 | QQQ | ETF | 35.642 | 35.68 | 35.58 | 35.62 | 2380800.0 |
| 2003-11-13 14:00:00 | QQQ | ETF | 35.63 | 35.65 | 35.55 | 35.59 | 2481200.0 |
| 2003-11-13 14:30:00 | QQQ | ETF | 35.59 | 35.753 | 35.55 | 35.73 | 4713400.0 |
| 2003-11-13 15:00:00 | QQQ | ETF | 35.75 | 35.85 | 35.673 | 35.691 | 8231000.0 |
| 2003-11-13 15:30:00 | QQQ | ETF | 35.683 | 35.9 | 35.66 | 35.79 | 7316500.0 |
| 2003-11-13 16:00:00 | QQQ | ETF | 35.79 | 35.83 | 35.74 | 35.74 | 966800.0 |
| 2003-11-13 16:30:00 | QQQ | ETF | 35.76 | 35.76 | 35.69 | 35.71 | 443700.0 |
| 2003-11-13 17:00:00 | QQQ | ETF | 35.71 | 35.71 | 35.64 | 35.64 | 267200.0 |
| 2003-11-13 17:30:00 | QQQ | ETF | 35.63 | 35.662 | 35.62 | 35.64 | 66900.0 |
| 2003-11-13 18:00:00 | QQQ | ETF | 35.68 | 35.69 | 35.66 | 35.69 | 25500.0 |
| 2003-11-13 18:30:00 | QQQ | ETF | 35.69 | 35.69 | 35.69 | 35.69 | 3800.0 |
| 2003-11-13 19:00:00 | QQQ | ETF | 35.71 | 35.71 | 35.7 | 35.71 | 5800.0 |
| 2003-11-13 19:30:00 | QQQ | ETF | 35.69 | 35.69 | 35.68 | 35.69 | 3300.0 |
| 2003-11-13 08:30:00 | IWM | ETF | 53.565 | 53.565 | 53.565 | 53.565 | 400.0 |
| 2003-11-13 09:00:00 | IWM | ETF | 53.73 | 53.765 | 53.73 | 53.765 | 4000.0 |
> showing 50 of 829 rows — these rows as CSV