PREVIEW / etf_30min / 2003-06-05
file: by_date/etf_30min/2003/2003-06-05.parquet size: 25 KB rows: 737
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-06-05 08:00:00 | SPY | ETF | 99.08 | 99.1 | 98.93 | 99.06 | 8500.0 |
| 2003-06-05 08:30:00 | SPY | ETF | 99.0 | 99.0 | 98.61 | 98.63 | 158400.0 |
| 2003-06-05 09:00:00 | SPY | ETF | 98.62 | 98.65 | 98.56 | 98.6 | 22800.0 |
| 2003-06-05 09:30:00 | SPY | ETF | 98.58 | 98.93 | 98.27 | 98.79 | 7989700.0 |
| 2003-06-05 10:00:00 | SPY | ETF | 98.75 | 98.93 | 98.41 | 98.72 | 5111000.0 |
| 2003-06-05 10:30:00 | SPY | ETF | 98.72 | 99.13 | 98.69 | 98.8 | 3224200.0 |
| 2003-06-05 11:00:00 | SPY | ETF | 98.8 | 99.04 | 98.67 | 99.03 | 1792300.0 |
| 2003-06-05 11:30:00 | SPY | ETF | 99.0 | 99.02 | 98.7 | 98.93 | 1123300.0 |
| 2003-06-05 12:00:00 | SPY | ETF | 98.95 | 99.3 | 98.86 | 99.03 | 2562500.0 |
| 2003-06-05 12:30:00 | SPY | ETF | 99.02 | 99.49 | 98.99 | 99.31 | 3176600.0 |
| 2003-06-05 13:00:00 | SPY | ETF | 99.31 | 99.45 | 99.0 | 99.11 | 2172600.0 |
| 2003-06-05 13:30:00 | SPY | ETF | 99.11 | 99.33 | 98.89 | 98.99 | 1619300.0 |
| 2003-06-05 14:00:00 | SPY | ETF | 98.99 | 99.11 | 98.76 | 98.91 | 2005900.0 |
| 2003-06-05 14:30:00 | SPY | ETF | 98.87 | 99.39 | 98.82 | 99.35 | 1603900.0 |
| 2003-06-05 15:00:00 | SPY | ETF | 99.36 | 99.54 | 99.12 | 99.43 | 3331500.0 |
| 2003-06-05 15:30:00 | SPY | ETF | 99.43 | 99.59 | 99.29 | 99.53 | 3247500.0 |
| 2003-06-05 16:00:00 | SPY | ETF | 99.52 | 99.65 | 99.3 | 99.45 | 2293000.0 |
| 2003-06-05 16:30:00 | SPY | ETF | 99.4 | 99.57 | 99.4 | 99.55 | 276200.0 |
| 2003-06-05 17:00:00 | SPY | ETF | 99.58 | 99.66 | 99.55 | 99.65 | 34500.0 |
| 2003-06-05 17:30:00 | SPY | ETF | 99.65 | 99.85 | 99.63 | 99.85 | 39700.0 |
| 2003-06-05 18:00:00 | SPY | ETF | 99.87 | 99.95 | 99.84 | 99.95 | 89500.0 |
| 2003-06-05 18:30:00 | SPY | ETF | 99.9 | 100.0 | 99.9 | 99.97 | 6200.0 |
| 2003-06-05 19:00:00 | SPY | ETF | 99.99 | 100.0 | 99.94 | 99.94 | 6800.0 |
| 2003-06-05 19:30:00 | SPY | ETF | 99.99 | 99.99 | 99.9 | 99.9 | 13500.0 |
| 2003-06-05 08:00:00 | QQQ | ETF | 30.38 | 30.38 | 30.3 | 30.38 | 49300.0 |
| 2003-06-05 08:30:00 | QQQ | ETF | 30.37 | 30.37 | 30.22 | 30.23 | 107600.0 |
| 2003-06-05 09:00:00 | QQQ | ETF | 30.23 | 30.23 | 30.15 | 30.15 | 42200.0 |
| 2003-06-05 09:30:00 | QQQ | ETF | 30.13 | 30.24 | 29.97 | 30.17 | 17478500.0 |
| 2003-06-05 10:00:00 | QQQ | ETF | 30.17 | 30.29 | 30.03 | 30.24 | 8934100.0 |
| 2003-06-05 10:30:00 | QQQ | ETF | 30.22 | 30.38 | 30.2 | 30.24 | 6277400.0 |
| 2003-06-05 11:00:00 | QQQ | ETF | 30.24 | 30.3 | 30.13 | 30.27 | 5289400.0 |
| 2003-06-05 11:30:00 | QQQ | ETF | 30.25 | 30.28 | 30.16 | 30.26 | 2821800.0 |
| 2003-06-05 12:00:00 | QQQ | ETF | 30.26 | 30.39 | 30.24 | 30.29 | 4024100.0 |
| 2003-06-05 12:30:00 | QQQ | ETF | 30.28 | 30.55 | 30.25 | 30.46 | 6451700.0 |
| 2003-06-05 13:00:00 | QQQ | ETF | 30.45 | 30.5 | 30.33 | 30.38 | 3225600.0 |
| 2003-06-05 13:30:00 | QQQ | ETF | 30.39 | 30.45 | 30.27 | 30.32 | 2248400.0 |
| 2003-06-05 14:00:00 | QQQ | ETF | 30.32 | 30.36 | 30.21 | 30.25 | 2584500.0 |
| 2003-06-05 14:30:00 | QQQ | ETF | 30.26 | 30.57 | 30.24 | 30.57 | 4230600.0 |
| 2003-06-05 15:00:00 | QQQ | ETF | 30.55 | 30.59 | 30.42 | 30.54 | 6239600.0 |
| 2003-06-05 15:30:00 | QQQ | ETF | 30.54 | 30.64 | 30.48 | 30.61 | 6785800.0 |
| 2003-06-05 16:00:00 | QQQ | ETF | 30.58 | 30.69 | 30.48 | 30.5 | 1625500.0 |
| 2003-06-05 16:30:00 | QQQ | ETF | 30.51 | 30.62 | 30.5 | 30.62 | 1962600.0 |
| 2003-06-05 17:00:00 | QQQ | ETF | 30.6 | 30.67 | 30.59 | 30.67 | 113800.0 |
| 2003-06-05 17:30:00 | QQQ | ETF | 30.66 | 30.75 | 30.65 | 30.75 | 159100.0 |
| 2003-06-05 18:00:00 | QQQ | ETF | 30.75 | 30.87 | 30.72 | 30.86 | 534300.0 |
| 2003-06-05 18:30:00 | QQQ | ETF | 30.86 | 30.88 | 30.82 | 30.86 | 50600.0 |
| 2003-06-05 19:00:00 | QQQ | ETF | 30.87 | 30.88 | 30.83 | 30.83 | 20800.0 |
| 2003-06-05 19:30:00 | QQQ | ETF | 30.84 | 30.86 | 30.83 | 30.83 | 16000.0 |
| 2003-06-05 20:00:00 | QQQ | ETF | 30.85 | 30.85 | 30.85 | 30.85 | 1600.0 |
| 2003-06-05 09:30:00 | IWM | ETF | 44.825 | 44.895 | 44.67 | 44.84 | 431200.0 |
> showing 50 of 737 rows — these rows as CSV