PREVIEW / etf_30min / 2003-03-07
file: by_date/etf_30min/2003/2003-03-07.parquet size: 21 KB rows: 624
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-03-07 08:00:00 | SPY | ETF | 82.13 | 82.13 | 82.0 | 82.0 | 14800.0 |
| 2003-03-07 08:30:00 | SPY | ETF | 81.91 | 81.91 | 81.59 | 81.7 | 74700.0 |
| 2003-03-07 09:00:00 | SPY | ETF | 81.67 | 81.76 | 81.63 | 81.65 | 63100.0 |
| 2003-03-07 09:30:00 | SPY | ETF | 81.61 | 82.33 | 81.43 | 82.13 | 9284100.0 |
| 2003-03-07 10:00:00 | SPY | ETF | 82.15 | 83.5 | 82.12 | 82.63 | 9280900.0 |
| 2003-03-07 10:30:00 | SPY | ETF | 82.63 | 82.89 | 82.29 | 82.41 | 4740900.0 |
| 2003-03-07 11:00:00 | SPY | ETF | 82.42 | 82.9 | 82.34 | 82.89 | 3083900.0 |
| 2003-03-07 11:30:00 | SPY | ETF | 82.9 | 83.09 | 82.67 | 83.08 | 2729600.0 |
| 2003-03-07 12:00:00 | SPY | ETF | 83.0 | 83.45 | 82.9 | 83.32 | 4079800.0 |
| 2003-03-07 12:30:00 | SPY | ETF | 83.31 | 83.45 | 83.16 | 83.25 | 2079500.0 |
| 2003-03-07 13:00:00 | SPY | ETF | 83.25 | 83.34 | 82.92 | 83.08 | 2253200.0 |
| 2003-03-07 13:30:00 | SPY | ETF | 83.06 | 83.15 | 82.77 | 82.84 | 1758100.0 |
| 2003-03-07 14:00:00 | SPY | ETF | 82.87 | 82.9 | 82.4 | 82.53 | 3867000.0 |
| 2003-03-07 14:30:00 | SPY | ETF | 82.55 | 82.97 | 82.42 | 82.85 | 2484100.0 |
| 2003-03-07 15:00:00 | SPY | ETF | 82.86 | 83.24 | 82.76 | 83.14 | 2273500.0 |
| 2003-03-07 15:30:00 | SPY | ETF | 83.15 | 83.5 | 82.98 | 83.37 | 4723100.0 |
| 2003-03-07 16:00:00 | SPY | ETF | 83.37 | 83.48 | 83.18 | 83.35 | 1412900.0 |
| 2003-03-07 16:30:00 | SPY | ETF | 83.34 | 83.4 | 83.32 | 83.39 | 15100.0 |
| 2003-03-07 17:00:00 | SPY | ETF | 83.4 | 83.5 | 83.0 | 83.45 | 41700.0 |
| 2003-03-07 17:30:00 | SPY | ETF | 83.45 | 83.49 | 83.45 | 83.45 | 1800.0 |
| 2003-03-07 18:00:00 | SPY | ETF | 83.41 | 83.46 | 83.41 | 83.45 | 3000.0 |
| 2003-03-07 18:30:00 | SPY | ETF | 83.45 | 83.5 | 83.45 | 83.5 | 800.0 |
| 2003-03-07 19:00:00 | SPY | ETF | 83.41 | 83.41 | 83.41 | 83.41 | 100.0 |
| 2003-03-07 19:30:00 | SPY | ETF | 83.45 | 83.5 | 83.45 | 83.5 | 900.0 |
| 2003-03-07 08:00:00 | QQQ | ETF | 24.2 | 24.2 | 24.17 | 24.17 | 53200.0 |
| 2003-03-07 08:30:00 | QQQ | ETF | 24.2 | 24.2 | 24.07 | 24.12 | 91200.0 |
| 2003-03-07 09:00:00 | QQQ | ETF | 24.1 | 24.11 | 24.08 | 24.08 | 15600.0 |
| 2003-03-07 09:30:00 | QQQ | ETF | 24.08 | 24.26 | 23.96 | 24.19 | 13989700.0 |
| 2003-03-07 10:00:00 | QQQ | ETF | 24.19 | 24.65 | 24.15 | 24.35 | 9796000.0 |
| 2003-03-07 10:30:00 | QQQ | ETF | 24.36 | 24.46 | 24.21 | 24.29 | 3863500.0 |
| 2003-03-07 11:00:00 | QQQ | ETF | 24.3 | 24.44 | 24.26 | 24.4 | 2973200.0 |
| 2003-03-07 11:30:00 | QQQ | ETF | 24.41 | 24.53 | 24.32 | 24.5 | 2400900.0 |
| 2003-03-07 12:00:00 | QQQ | ETF | 24.5 | 24.69 | 24.41 | 24.65 | 8137600.0 |
| 2003-03-07 12:30:00 | QQQ | ETF | 24.64 | 24.69 | 24.56 | 24.61 | 2934500.0 |
| 2003-03-07 13:00:00 | QQQ | ETF | 24.6 | 24.62 | 24.49 | 24.52 | 2777800.0 |
| 2003-03-07 13:30:00 | QQQ | ETF | 24.52 | 24.57 | 24.38 | 24.44 | 2058500.0 |
| 2003-03-07 14:00:00 | QQQ | ETF | 24.44 | 24.45 | 24.24 | 24.3 | 4202600.0 |
| 2003-03-07 14:30:00 | QQQ | ETF | 24.3 | 24.5 | 24.29 | 24.43 | 2748700.0 |
| 2003-03-07 15:00:00 | QQQ | ETF | 24.41 | 24.51 | 24.35 | 24.46 | 1926100.0 |
| 2003-03-07 15:30:00 | QQQ | ETF | 24.44 | 24.65 | 24.4 | 24.56 | 5098600.0 |
| 2003-03-07 16:00:00 | QQQ | ETF | 24.56 | 24.59 | 24.5 | 24.55 | 1542300.0 |
| 2003-03-07 16:30:00 | QQQ | ETF | 24.55 | 24.57 | 24.53 | 24.55 | 34000.0 |
| 2003-03-07 17:00:00 | QQQ | ETF | 24.55 | 24.57 | 24.55 | 24.55 | 68000.0 |
| 2003-03-07 17:30:00 | QQQ | ETF | 24.55 | 24.6 | 24.52 | 24.56 | 11300.0 |
| 2003-03-07 18:00:00 | QQQ | ETF | 24.56 | 24.59 | 24.55 | 24.55 | 23500.0 |
| 2003-03-07 18:30:00 | QQQ | ETF | 24.55 | 24.58 | 24.55 | 24.56 | 7000.0 |
| 2003-03-07 19:00:00 | QQQ | ETF | 24.58 | 24.58 | 24.54 | 24.54 | 1300.0 |
| 2003-03-07 19:30:00 | QQQ | ETF | 24.58 | 24.58 | 24.57 | 24.57 | 1900.0 |
| 2003-03-07 09:00:00 | IWM | ETF | 35.02 | 35.255 | 35.02 | 35.255 | 3000.0 |
| 2003-03-07 09:30:00 | IWM | ETF | 34.875 | 35.09 | 34.76 | 35.08 | 280400.0 |
> showing 50 of 624 rows — these rows as CSV