PREVIEW / etf_30min / 2004-04-02
file: by_date/etf_30min/2004/2004-04-02.parquet size: 36 KB rows: 1,254
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-04-02 08:00:00 | SPY | ETF | 113.64 | 114.19 | 113.64 | 114.08 | 108400.0 |
| 2004-04-02 08:30:00 | SPY | ETF | 114.0 | 114.91 | 113.99 | 114.68 | 1406900.0 |
| 2004-04-02 09:00:00 | SPY | ETF | 114.69 | 114.88 | 114.65 | 114.84 | 179300.0 |
| 2004-04-02 09:30:00 | SPY | ETF | 114.81 | 114.84 | 114.28 | 114.609 | 10988500.0 |
| 2004-04-02 10:00:00 | SPY | ETF | 114.6 | 114.63 | 113.91 | 114.09 | 6156000.0 |
| 2004-04-02 10:30:00 | SPY | ETF | 114.09 | 114.36 | 114.03 | 114.28 | 2329700.0 |
| 2004-04-02 11:00:00 | SPY | ETF | 114.29 | 114.34 | 114.13 | 114.23 | 1582700.0 |
| 2004-04-02 11:30:00 | SPY | ETF | 114.23 | 114.47 | 114.23 | 114.36 | 2567300.0 |
| 2004-04-02 12:00:00 | SPY | ETF | 114.37 | 114.45 | 114.17 | 114.42 | 1587100.0 |
| 2004-04-02 12:30:00 | SPY | ETF | 114.4 | 114.65 | 114.39 | 114.6 | 1725900.0 |
| 2004-04-02 13:00:00 | SPY | ETF | 114.58 | 114.59 | 114.33 | 114.36 | 1327700.0 |
| 2004-04-02 13:30:00 | SPY | ETF | 114.36 | 114.48 | 114.25 | 114.46 | 1197000.0 |
| 2004-04-02 14:00:00 | SPY | ETF | 114.47 | 114.54 | 114.08 | 114.12 | 3121200.0 |
| 2004-04-02 14:30:00 | SPY | ETF | 114.1 | 114.27 | 113.95 | 114.07 | 3149000.0 |
| 2004-04-02 15:00:00 | SPY | ETF | 114.05 | 114.35 | 114.01 | 114.33 | 2992600.0 |
| 2004-04-02 15:30:00 | SPY | ETF | 114.34 | 114.47 | 114.21 | 114.42 | 3860500.0 |
| 2004-04-02 16:00:00 | SPY | ETF | 114.42 | 114.67 | 114.34 | 114.62 | 2251600.0 |
| 2004-04-02 16:30:00 | SPY | ETF | 114.57 | 114.63 | 114.53 | 114.6 | 131400.0 |
| 2004-04-02 17:00:00 | SPY | ETF | 114.57 | 114.57 | 114.55 | 114.57 | 5000.0 |
| 2004-04-02 17:30:00 | SPY | ETF | 114.6 | 114.64 | 114.52 | 114.52 | 7800.0 |
| 2004-04-02 18:30:00 | SPY | ETF | 114.53 | 114.53 | 114.53 | 114.53 | 2200.0 |
| 2004-04-02 19:30:00 | SPY | ETF | 114.55 | 114.55 | 114.55 | 114.55 | 500.0 |
| 2004-04-02 08:00:00 | QQQ | ETF | 36.11 | 36.4 | 36.11 | 36.35 | 221700.0 |
| 2004-04-02 08:30:00 | QQQ | ETF | 36.35 | 36.92 | 36.35 | 36.74 | 3346900.0 |
| 2004-04-02 09:00:00 | QQQ | ETF | 36.74 | 36.97 | 36.74 | 36.89 | 1566900.0 |
| 2004-04-02 09:30:00 | QQQ | ETF | 36.89 | 37.0 | 36.68 | 36.83 | 27917600.0 |
| 2004-04-02 10:00:00 | QQQ | ETF | 36.828 | 36.84 | 36.52 | 36.62 | 16068800.0 |
| 2004-04-02 10:30:00 | QQQ | ETF | 36.59 | 36.72 | 36.56 | 36.7 | 8467500.0 |
| 2004-04-02 11:00:00 | QQQ | ETF | 36.697 | 36.74 | 36.62 | 36.7 | 6783600.0 |
| 2004-04-02 11:30:00 | QQQ | ETF | 36.69 | 36.79 | 36.67 | 36.77 | 4390900.0 |
| 2004-04-02 12:00:00 | QQQ | ETF | 36.77 | 36.86 | 36.7 | 36.84 | 6150900.0 |
| 2004-04-02 12:30:00 | QQQ | ETF | 36.84 | 36.95 | 36.81 | 36.9 | 9427200.0 |
| 2004-04-02 13:00:00 | QQQ | ETF | 36.901 | 36.93 | 36.82 | 36.852 | 6485900.0 |
| 2004-04-02 13:30:00 | QQQ | ETF | 36.86 | 36.97 | 36.8 | 36.97 | 5027600.0 |
| 2004-04-02 14:00:00 | QQQ | ETF | 36.95 | 37.04 | 36.81 | 36.83 | 9194600.0 |
| 2004-04-02 14:30:00 | QQQ | ETF | 36.83 | 36.911 | 36.76 | 36.89 | 6514700.0 |
| 2004-04-02 15:00:00 | QQQ | ETF | 36.89 | 36.99 | 36.83 | 36.97 | 5488900.0 |
| 2004-04-02 15:30:00 | QQQ | ETF | 36.96 | 37.0 | 36.87 | 37.0 | 11940600.0 |
| 2004-04-02 16:00:00 | QQQ | ETF | 37.0 | 37.16 | 36.841 | 37.09 | 5423200.0 |
| 2004-04-02 16:30:00 | QQQ | ETF | 37.08 | 37.09 | 37.055 | 37.08 | 125900.0 |
| 2004-04-02 17:00:00 | QQQ | ETF | 37.08 | 37.09 | 37.03 | 37.05 | 253100.0 |
| 2004-04-02 17:30:00 | QQQ | ETF | 37.05 | 37.1 | 37.05 | 37.05 | 59000.0 |
| 2004-04-02 18:00:00 | QQQ | ETF | 37.05 | 37.06 | 37.04 | 37.06 | 19300.0 |
| 2004-04-02 18:30:00 | QQQ | ETF | 37.08 | 37.09 | 37.08 | 37.09 | 5300.0 |
| 2004-04-02 19:00:00 | QQQ | ETF | 37.09 | 37.1 | 37.04 | 37.1 | 10400.0 |
| 2004-04-02 19:30:00 | QQQ | ETF | 37.04 | 37.09 | 37.04 | 37.09 | 1200.0 |
| 2004-04-02 08:30:00 | IWM | ETF | 60.015 | 60.27 | 59.985 | 60.2 | 154800.0 |
| 2004-04-02 09:00:00 | IWM | ETF | 60.215 | 60.285 | 60.215 | 60.26 | 63000.0 |
| 2004-04-02 09:30:00 | IWM | ETF | 60.28 | 60.47 | 59.95 | 60.2 | 3160400.0 |
| 2004-04-02 10:00:00 | IWM | ETF | 60.2 | 60.275 | 59.855 | 59.875 | 1768800.0 |
> showing 50 of 1,254 rows — these rows as CSV