PREVIEW / etf_30min / 2004-08-11
file: by_date/etf_30min/2004/2004-08-11.parquet size: 36 KB rows: 1,170
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-08-11 08:00:00 | SPY | ETF | 107.46 | 107.6 | 107.46 | 107.6 | 105400.0 |
| 2004-08-11 08:30:00 | SPY | ETF | 107.58 | 107.64 | 107.55 | 107.63 | 48100.0 |
| 2004-08-11 09:00:00 | SPY | ETF | 107.65 | 107.7 | 107.57 | 107.69 | 113100.0 |
| 2004-08-11 09:30:00 | SPY | ETF | 107.68 | 107.7 | 107.31 | 107.39 | 6006700.0 |
| 2004-08-11 10:00:00 | SPY | ETF | 107.4 | 107.49 | 107.1 | 107.43 | 6053800.0 |
| 2004-08-11 10:30:00 | SPY | ETF | 107.41 | 107.78 | 107.23 | 107.74 | 6206200.0 |
| 2004-08-11 11:00:00 | SPY | ETF | 107.73 | 108.08 | 107.71 | 107.84 | 7011800.0 |
| 2004-08-11 11:30:00 | SPY | ETF | 107.84 | 107.85 | 107.59 | 107.63 | 2534300.0 |
| 2004-08-11 12:00:00 | SPY | ETF | 107.62 | 107.78 | 107.47 | 107.76 | 2912700.0 |
| 2004-08-11 12:30:00 | SPY | ETF | 107.74 | 107.75 | 107.63 | 107.71 | 918600.0 |
| 2004-08-11 13:00:00 | SPY | ETF | 107.7 | 107.98 | 107.7 | 107.81 | 2194200.0 |
| 2004-08-11 13:30:00 | SPY | ETF | 107.82 | 107.87 | 107.57 | 107.71 | 2209700.0 |
| 2004-08-11 14:00:00 | SPY | ETF | 107.71 | 107.86 | 107.5 | 107.8 | 2539200.0 |
| 2004-08-11 14:30:00 | SPY | ETF | 107.81 | 108.11 | 107.62 | 108.05 | 2718900.0 |
| 2004-08-11 15:00:00 | SPY | ETF | 108.08 | 108.33 | 107.96 | 108.16 | 4168400.0 |
| 2004-08-11 15:30:00 | SPY | ETF | 108.15 | 108.24 | 107.91 | 108.09 | 3490000.0 |
| 2004-08-11 16:00:00 | SPY | ETF | 108.1 | 108.19 | 107.56 | 108.16 | 695300.0 |
| 2004-08-11 16:30:00 | SPY | ETF | 108.15 | 108.24 | 108.13 | 108.24 | 9100.0 |
| 2004-08-11 17:00:00 | SPY | ETF | 108.27 | 108.33 | 108.23 | 108.33 | 6500.0 |
| 2004-08-11 17:30:00 | SPY | ETF | 108.25 | 108.25 | 108.23 | 108.23 | 4500.0 |
| 2004-08-11 18:00:00 | SPY | ETF | 108.3 | 108.37 | 108.059 | 108.059 | 55100.0 |
| 2004-08-11 18:30:00 | SPY | ETF | 108.32 | 108.32 | 108.3 | 108.32 | 16000.0 |
| 2004-08-11 19:00:00 | SPY | ETF | 108.32 | 108.32 | 108.27 | 108.27 | 15300.0 |
| 2004-08-11 19:30:00 | SPY | ETF | 108.29 | 108.29 | 108.24 | 108.24 | 1400.0 |
| 2004-08-11 08:00:00 | QQQ | ETF | 32.94 | 32.94 | 32.79 | 32.85 | 181100.0 |
| 2004-08-11 08:30:00 | QQQ | ETF | 32.86 | 32.87 | 32.82 | 32.86 | 233300.0 |
| 2004-08-11 09:00:00 | QQQ | ETF | 32.86 | 32.88 | 32.82 | 32.86 | 393200.0 |
| 2004-08-11 09:30:00 | QQQ | ETF | 32.85 | 32.88 | 32.61 | 32.68 | 18724200.0 |
| 2004-08-11 10:00:00 | QQQ | ETF | 32.67 | 32.72 | 32.56 | 32.674 | 13685200.0 |
| 2004-08-11 10:30:00 | QQQ | ETF | 32.68 | 32.8 | 32.59 | 32.8 | 11003800.0 |
| 2004-08-11 11:00:00 | QQQ | ETF | 32.8 | 32.93 | 32.76 | 32.84 | 11738600.0 |
| 2004-08-11 11:30:00 | QQQ | ETF | 32.84 | 32.85 | 32.7 | 32.71 | 5156800.0 |
| 2004-08-11 12:00:00 | QQQ | ETF | 32.72 | 32.77 | 32.64 | 32.73 | 6574800.0 |
| 2004-08-11 12:30:00 | QQQ | ETF | 32.739 | 32.77 | 32.71 | 32.74 | 2278600.0 |
| 2004-08-11 13:00:00 | QQQ | ETF | 32.746 | 32.881 | 32.746 | 32.82 | 3880100.0 |
| 2004-08-11 13:30:00 | QQQ | ETF | 32.823 | 32.846 | 32.71 | 32.76 | 3874300.0 |
| 2004-08-11 14:00:00 | QQQ | ETF | 32.76 | 32.82 | 32.659 | 32.81 | 6849900.0 |
| 2004-08-11 14:30:00 | QQQ | ETF | 32.8 | 32.93 | 32.77 | 32.93 | 5582700.0 |
| 2004-08-11 15:00:00 | QQQ | ETF | 32.933 | 33.04 | 32.87 | 32.97 | 9801700.0 |
| 2004-08-11 15:30:00 | QQQ | ETF | 32.97 | 33.03 | 32.83 | 32.91 | 11130600.0 |
| 2004-08-11 16:00:00 | QQQ | ETF | 32.92 | 32.97 | 32.88 | 32.94 | 3227300.0 |
| 2004-08-11 16:30:00 | QQQ | ETF | 32.947 | 32.98 | 32.94 | 32.98 | 60900.0 |
| 2004-08-11 17:00:00 | QQQ | ETF | 32.98 | 33.0 | 32.97 | 32.98 | 121100.0 |
| 2004-08-11 17:30:00 | QQQ | ETF | 32.98 | 33.0 | 32.96 | 33.0 | 44500.0 |
| 2004-08-11 18:00:00 | QQQ | ETF | 33.0 | 33.02 | 32.98 | 33.01 | 16500.0 |
| 2004-08-11 18:30:00 | QQQ | ETF | 33.02 | 33.02 | 33.0 | 33.02 | 5500.0 |
| 2004-08-11 19:00:00 | QQQ | ETF | 33.01 | 33.01 | 33.0 | 33.0 | 4100.0 |
| 2004-08-11 19:30:00 | QQQ | ETF | 33.0 | 33.0 | 32.97 | 32.98 | 5000.0 |
| 2004-08-11 08:30:00 | IWM | ETF | 52.17 | 52.17 | 52.17 | 52.17 | 3000.0 |
| 2004-08-11 09:00:00 | IWM | ETF | 52.195 | 52.205 | 52.195 | 52.195 | 4200.0 |
> showing 50 of 1,170 rows — these rows as CSV