PREVIEW / etf_30min / 2003-10-14
file: by_date/etf_30min/2003/2003-10-14.parquet size: 25 KB rows: 790
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-10-14 08:00:00 | SPY | ETF | 105.07 | 105.13 | 105.07 | 105.12 | 7300.0 |
| 2003-10-14 08:30:00 | SPY | ETF | 105.08 | 105.08 | 104.9 | 104.97 | 22000.0 |
| 2003-10-14 09:00:00 | SPY | ETF | 104.97 | 104.97 | 104.75 | 104.77 | 70800.0 |
| 2003-10-14 09:30:00 | SPY | ETF | 104.8 | 104.9 | 104.36 | 104.6 | 4071000.0 |
| 2003-10-14 10:00:00 | SPY | ETF | 104.59 | 104.83 | 104.48 | 104.65 | 2368600.0 |
| 2003-10-14 10:30:00 | SPY | ETF | 104.63 | 104.79 | 104.51 | 104.79 | 1473700.0 |
| 2003-10-14 11:00:00 | SPY | ETF | 104.78 | 104.84 | 104.59 | 104.68 | 4277500.0 |
| 2003-10-14 11:30:00 | SPY | ETF | 104.727 | 104.74 | 104.52 | 104.56 | 1030500.0 |
| 2003-10-14 12:00:00 | SPY | ETF | 104.58 | 104.79 | 104.46 | 104.75 | 1181100.0 |
| 2003-10-14 12:30:00 | SPY | ETF | 104.74 | 104.9 | 104.63 | 104.67 | 1432600.0 |
| 2003-10-14 13:00:00 | SPY | ETF | 104.66 | 104.79 | 104.63 | 104.72 | 698500.0 |
| 2003-10-14 13:30:00 | SPY | ETF | 104.74 | 105.16 | 104.66 | 105.06 | 1824300.0 |
| 2003-10-14 14:00:00 | SPY | ETF | 105.02 | 105.17 | 105.0 | 105.06 | 1888300.0 |
| 2003-10-14 14:30:00 | SPY | ETF | 105.05 | 105.16 | 104.94 | 105.0 | 787700.0 |
| 2003-10-14 15:00:00 | SPY | ETF | 105.01 | 105.26 | 104.96 | 105.09 | 3135200.0 |
| 2003-10-14 15:30:00 | SPY | ETF | 105.1 | 105.36 | 105.09 | 105.29 | 2129100.0 |
| 2003-10-14 16:00:00 | SPY | ETF | 105.32 | 105.44 | 105.21 | 105.37 | 3031500.0 |
| 2003-10-14 16:30:00 | SPY | ETF | 105.35 | 105.37 | 105.19 | 105.3 | 70700.0 |
| 2003-10-14 17:00:00 | SPY | ETF | 105.28 | 105.38 | 105.28 | 105.32 | 21000.0 |
| 2003-10-14 17:30:00 | SPY | ETF | 105.33 | 105.43 | 105.33 | 105.4 | 6800.0 |
| 2003-10-14 18:00:00 | SPY | ETF | 105.37 | 105.41 | 105.35 | 105.41 | 3100.0 |
| 2003-10-14 18:30:00 | SPY | ETF | 105.41 | 105.41 | 105.41 | 105.41 | 200.0 |
| 2003-10-14 19:00:00 | SPY | ETF | 105.4 | 105.44 | 105.4 | 105.44 | 1000.0 |
| 2003-10-14 19:30:00 | SPY | ETF | 105.45 | 105.49 | 105.45 | 105.49 | 400.0 |
| 2003-10-14 08:00:00 | QQQ | ETF | 35.2 | 35.24 | 35.2 | 35.21 | 49900.0 |
| 2003-10-14 08:30:00 | QQQ | ETF | 35.21 | 35.21 | 35.15 | 35.2 | 126600.0 |
| 2003-10-14 09:00:00 | QQQ | ETF | 35.19 | 35.19 | 35.08 | 35.1 | 162400.0 |
| 2003-10-14 09:30:00 | QQQ | ETF | 35.1 | 35.14 | 34.96 | 35.05 | 8166500.0 |
| 2003-10-14 10:00:00 | QQQ | ETF | 35.07 | 35.16 | 35.0 | 35.073 | 5074100.0 |
| 2003-10-14 10:30:00 | QQQ | ETF | 35.07 | 35.16 | 34.99 | 35.15 | 3885500.0 |
| 2003-10-14 11:00:00 | QQQ | ETF | 35.15 | 35.193 | 35.06 | 35.131 | 3012900.0 |
| 2003-10-14 11:30:00 | QQQ | ETF | 35.13 | 35.15 | 35.05 | 35.07 | 1877400.0 |
| 2003-10-14 12:00:00 | QQQ | ETF | 35.07 | 35.142 | 35.02 | 35.116 | 2874400.0 |
| 2003-10-14 12:30:00 | QQQ | ETF | 35.12 | 35.16 | 35.06 | 35.07 | 2454600.0 |
| 2003-10-14 13:00:00 | QQQ | ETF | 35.077 | 35.14 | 35.06 | 35.13 | 1162900.0 |
| 2003-10-14 13:30:00 | QQQ | ETF | 35.13 | 35.3 | 35.096 | 35.24 | 5780300.0 |
| 2003-10-14 14:00:00 | QQQ | ETF | 35.24 | 35.28 | 35.185 | 35.22 | 3093300.0 |
| 2003-10-14 14:30:00 | QQQ | ETF | 35.24 | 35.29 | 35.15 | 35.19 | 3539100.0 |
| 2003-10-14 15:00:00 | QQQ | ETF | 35.196 | 35.32 | 35.17 | 35.26 | 3715500.0 |
| 2003-10-14 15:30:00 | QQQ | ETF | 35.26 | 35.35 | 35.25 | 35.31 | 6974000.0 |
| 2003-10-14 16:00:00 | QQQ | ETF | 35.31 | 35.47 | 35.2 | 35.45 | 4730500.0 |
| 2003-10-14 16:30:00 | QQQ | ETF | 35.45 | 35.48 | 35.36 | 35.45 | 1645600.0 |
| 2003-10-14 17:00:00 | QQQ | ETF | 35.45 | 35.489 | 35.43 | 35.45 | 315800.0 |
| 2003-10-14 17:30:00 | QQQ | ETF | 35.45 | 35.5 | 35.39 | 35.5 | 1599000.0 |
| 2003-10-14 18:00:00 | QQQ | ETF | 35.47 | 35.51 | 35.448 | 35.49 | 135500.0 |
| 2003-10-14 18:30:00 | QQQ | ETF | 35.5 | 35.5 | 35.46 | 35.5 | 45300.0 |
| 2003-10-14 19:00:00 | QQQ | ETF | 35.5 | 35.51 | 35.49 | 35.51 | 26700.0 |
| 2003-10-14 19:30:00 | QQQ | ETF | 35.51 | 35.53 | 35.49 | 35.51 | 17200.0 |
| 2003-10-14 09:30:00 | IWM | ETF | 52.675 | 52.8 | 52.44 | 52.78 | 875400.0 |
| 2003-10-14 10:00:00 | IWM | ETF | 52.775 | 52.92 | 52.675 | 52.83 | 1281200.0 |
> showing 50 of 790 rows — these rows as CSV