PREVIEW / etf_30min / 2003-12-01
file: by_date/etf_30min/2003/2003-12-01.parquet size: 27 KB rows: 861
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-12-01 08:00:00 | SPY | ETF | 106.9 | 106.95 | 106.84 | 106.88 | 18600.0 |
| 2003-12-01 08:30:00 | SPY | ETF | 106.87 | 106.91 | 106.76 | 106.76 | 24600.0 |
| 2003-12-01 09:00:00 | SPY | ETF | 106.8 | 106.89 | 106.8 | 106.87 | 13700.0 |
| 2003-12-01 09:30:00 | SPY | ETF | 106.85 | 107.09 | 106.83 | 107.02 | 4617500.0 |
| 2003-12-01 10:00:00 | SPY | ETF | 107.02 | 107.39 | 106.95 | 107.21 | 4425400.0 |
| 2003-12-01 10:30:00 | SPY | ETF | 107.2 | 107.24 | 106.98 | 107.08 | 2050800.0 |
| 2003-12-01 11:00:00 | SPY | ETF | 107.07 | 107.32 | 107.05 | 107.26 | 1948700.0 |
| 2003-12-01 11:30:00 | SPY | ETF | 107.25 | 107.35 | 107.21 | 107.3 | 884400.0 |
| 2003-12-01 12:00:00 | SPY | ETF | 107.31 | 107.54 | 107.28 | 107.44 | 1743400.0 |
| 2003-12-01 12:30:00 | SPY | ETF | 107.43 | 107.51 | 107.36 | 107.44 | 831500.0 |
| 2003-12-01 13:00:00 | SPY | ETF | 107.45 | 107.45 | 107.25 | 107.35 | 1602800.0 |
| 2003-12-01 13:30:00 | SPY | ETF | 107.33 | 107.4 | 107.3 | 107.36 | 741200.0 |
| 2003-12-01 14:00:00 | SPY | ETF | 107.33 | 107.37 | 106.8 | 107.1 | 3378200.0 |
| 2003-12-01 14:30:00 | SPY | ETF | 107.11 | 107.37 | 107.1 | 107.33 | 2796600.0 |
| 2003-12-01 15:00:00 | SPY | ETF | 107.33 | 107.55 | 107.33 | 107.48 | 1674400.0 |
| 2003-12-01 15:30:00 | SPY | ETF | 107.5 | 107.68 | 107.45 | 107.57 | 3462800.0 |
| 2003-12-01 16:00:00 | SPY | ETF | 107.57 | 107.61 | 107.53 | 107.55 | 1488600.0 |
| 2003-12-01 16:30:00 | SPY | ETF | 107.56 | 107.6 | 107.51 | 107.53 | 2082300.0 |
| 2003-12-01 17:00:00 | SPY | ETF | 107.52 | 107.53 | 107.47 | 107.52 | 59000.0 |
| 2003-12-01 17:30:00 | SPY | ETF | 107.51 | 107.51 | 107.51 | 107.51 | 700.0 |
| 2003-12-01 18:00:00 | SPY | ETF | 107.5 | 107.5432 | 107.5 | 107.5432 | 10100.0 |
| 2003-12-01 18:30:00 | SPY | ETF | 107.52 | 107.53 | 107.52 | 107.53 | 1100.0 |
| 2003-12-01 08:00:00 | QQQ | ETF | 35.7 | 35.75 | 35.69 | 35.7 | 83500.0 |
| 2003-12-01 08:30:00 | QQQ | ETF | 35.69 | 35.71 | 35.69 | 35.69 | 62100.0 |
| 2003-12-01 09:00:00 | QQQ | ETF | 35.69 | 35.71 | 35.68 | 35.7 | 50700.0 |
| 2003-12-01 09:30:00 | QQQ | ETF | 35.71 | 35.8 | 35.68 | 35.72 | 9283700.0 |
| 2003-12-01 10:00:00 | QQQ | ETF | 35.72 | 36.0 | 35.72 | 35.89 | 11286400.0 |
| 2003-12-01 10:30:00 | QQQ | ETF | 35.89 | 35.9 | 35.66 | 35.73 | 5031500.0 |
| 2003-12-01 11:00:00 | QQQ | ETF | 35.73 | 35.89 | 35.7 | 35.85 | 2787400.0 |
| 2003-12-01 11:30:00 | QQQ | ETF | 35.86 | 35.9 | 35.8 | 35.86 | 1667800.0 |
| 2003-12-01 12:00:00 | QQQ | ETF | 35.86 | 35.95 | 35.85 | 35.85 | 2441200.0 |
| 2003-12-01 12:30:00 | QQQ | ETF | 35.85 | 35.89 | 35.8 | 35.82 | 1365200.0 |
| 2003-12-01 13:00:00 | QQQ | ETF | 35.84 | 35.85 | 35.71 | 35.8 | 3075100.0 |
| 2003-12-01 13:30:00 | QQQ | ETF | 35.8 | 35.81 | 35.71 | 35.751 | 2415900.0 |
| 2003-12-01 14:00:00 | QQQ | ETF | 35.756 | 35.77 | 35.47 | 35.62 | 6952000.0 |
| 2003-12-01 14:30:00 | QQQ | ETF | 35.62 | 35.79 | 35.62 | 35.78 | 7449200.0 |
| 2003-12-01 15:00:00 | QQQ | ETF | 35.78 | 35.93 | 35.75 | 35.9 | 5595600.0 |
| 2003-12-01 15:30:00 | QQQ | ETF | 35.9 | 35.9783 | 35.88 | 35.92 | 8676400.0 |
| 2003-12-01 16:00:00 | QQQ | ETF | 35.92 | 35.93 | 35.87 | 35.91 | 2437700.0 |
| 2003-12-01 16:30:00 | QQQ | ETF | 35.89 | 35.91 | 35.88 | 35.88 | 167000.0 |
| 2003-12-01 17:00:00 | QQQ | ETF | 35.877 | 35.9 | 35.86 | 35.88 | 61200.0 |
| 2003-12-01 17:30:00 | QQQ | ETF | 35.9 | 35.9 | 35.86 | 35.87 | 9500.0 |
| 2003-12-01 18:00:00 | QQQ | ETF | 35.87 | 35.9 | 35.87 | 35.89 | 34200.0 |
| 2003-12-01 18:30:00 | QQQ | ETF | 35.88 | 35.89 | 35.87 | 35.87 | 7200.0 |
| 2003-12-01 19:00:00 | QQQ | ETF | 35.89 | 35.89 | 35.87 | 35.88 | 3800.0 |
| 2003-12-01 19:30:00 | QQQ | ETF | 35.89 | 35.9 | 35.87 | 35.87 | 8900.0 |
| 2003-12-01 08:00:00 | IWM | ETF | 55.0 | 55.0 | 55.0 | 55.0 | 200.0 |
| 2003-12-01 09:00:00 | IWM | ETF | 54.99 | 54.99 | 54.935 | 54.935 | 2400.0 |
| 2003-12-01 09:30:00 | IWM | ETF | 54.935 | 55.195 | 54.925 | 55.15 | 1264400.0 |
| 2003-12-01 10:00:00 | IWM | ETF | 55.185 | 55.365 | 55.125 | 55.3 | 600400.0 |
> showing 50 of 861 rows — these rows as CSV