PREVIEW / etf_30min / 2003-04-24
file: by_date/etf_30min/2003/2003-04-24.parquet size: 22 KB rows: 669
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-04-24 08:00:00 | SPY | ETF | 91.56 | 91.6 | 91.4 | 91.59 | 30400.0 |
| 2003-04-24 08:30:00 | SPY | ETF | 91.46 | 91.73 | 91.43 | 91.64 | 11600.0 |
| 2003-04-24 09:00:00 | SPY | ETF | 91.65 | 91.68 | 91.48 | 91.49 | 16000.0 |
| 2003-04-24 09:30:00 | SPY | ETF | 91.53 | 91.69 | 91.27 | 91.42 | 4235600.0 |
| 2003-04-24 10:00:00 | SPY | ETF | 91.42 | 91.83 | 91.36 | 91.8 | 3123800.0 |
| 2003-04-24 10:30:00 | SPY | ETF | 91.82 | 91.85 | 91.03 | 91.2 | 3267100.0 |
| 2003-04-24 11:00:00 | SPY | ETF | 91.25 | 91.31 | 90.96 | 91.05 | 3800800.0 |
| 2003-04-24 11:30:00 | SPY | ETF | 91.06 | 91.24 | 90.96 | 91.16 | 1840900.0 |
| 2003-04-24 12:00:00 | SPY | ETF | 91.15 | 91.25 | 91.04 | 91.18 | 1103100.0 |
| 2003-04-24 12:30:00 | SPY | ETF | 91.19 | 91.42 | 91.12 | 91.31 | 2495300.0 |
| 2003-04-24 13:00:00 | SPY | ETF | 91.33 | 91.39 | 91.21 | 91.3 | 1720600.0 |
| 2003-04-24 13:30:00 | SPY | ETF | 91.28 | 91.57 | 91.15 | 91.57 | 2280200.0 |
| 2003-04-24 14:00:00 | SPY | ETF | 91.56 | 91.69 | 91.47 | 91.55 | 2378600.0 |
| 2003-04-24 14:30:00 | SPY | ETF | 91.53 | 92.05 | 91.45 | 91.9 | 3360500.0 |
| 2003-04-24 15:00:00 | SPY | ETF | 91.88 | 92.08 | 91.63 | 91.77 | 3457800.0 |
| 2003-04-24 15:30:00 | SPY | ETF | 91.71 | 91.75 | 91.3 | 91.42 | 4700900.0 |
| 2003-04-24 16:00:00 | SPY | ETF | 91.43 | 91.46 | 91.35 | 91.38 | 1553600.0 |
| 2003-04-24 16:30:00 | SPY | ETF | 91.38 | 91.54 | 91.3 | 91.54 | 131900.0 |
| 2003-04-24 17:00:00 | SPY | ETF | 91.52 | 91.54 | 91.47 | 91.52 | 314800.0 |
| 2003-04-24 17:30:00 | SPY | ETF | 91.5 | 91.5 | 91.47 | 91.47 | 8700.0 |
| 2003-04-24 18:00:00 | SPY | ETF | 91.49 | 91.52 | 91.45 | 91.47 | 11000.0 |
| 2003-04-24 18:30:00 | SPY | ETF | 91.46 | 91.46 | 91.4 | 91.4 | 5500.0 |
| 2003-04-24 19:00:00 | SPY | ETF | 91.4 | 91.4 | 91.38 | 91.39 | 12600.0 |
| 2003-04-24 19:30:00 | SPY | ETF | 91.38 | 91.41 | 91.38 | 91.4 | 1800.0 |
| 2003-04-24 08:00:00 | QQQ | ETF | 27.44 | 27.44 | 27.39 | 27.43 | 49600.0 |
| 2003-04-24 08:30:00 | QQQ | ETF | 27.43 | 27.47 | 27.39 | 27.43 | 67500.0 |
| 2003-04-24 09:00:00 | QQQ | ETF | 27.43 | 27.46 | 27.33 | 27.35 | 82800.0 |
| 2003-04-24 09:30:00 | QQQ | ETF | 27.36 | 27.54 | 27.3 | 27.44 | 12812700.0 |
| 2003-04-24 10:00:00 | QQQ | ETF | 27.44 | 27.63 | 27.41 | 27.59 | 7874200.0 |
| 2003-04-24 10:30:00 | QQQ | ETF | 27.59 | 27.65 | 27.33 | 27.39 | 4979700.0 |
| 2003-04-24 11:00:00 | QQQ | ETF | 27.4 | 27.44 | 27.27 | 27.28 | 7201000.0 |
| 2003-04-24 11:30:00 | QQQ | ETF | 27.28 | 27.42 | 27.27 | 27.4 | 2044300.0 |
| 2003-04-24 12:00:00 | QQQ | ETF | 27.38 | 27.44 | 27.34 | 27.38 | 2382400.0 |
| 2003-04-24 12:30:00 | QQQ | ETF | 27.37 | 27.48 | 27.35 | 27.43 | 1623300.0 |
| 2003-04-24 13:00:00 | QQQ | ETF | 27.43 | 27.5 | 27.39 | 27.41 | 2411400.0 |
| 2003-04-24 13:30:00 | QQQ | ETF | 27.42 | 27.52 | 27.38 | 27.5 | 1686900.0 |
| 2003-04-24 14:00:00 | QQQ | ETF | 27.5 | 27.58 | 27.48 | 27.51 | 3377400.0 |
| 2003-04-24 14:30:00 | QQQ | ETF | 27.51 | 27.75 | 27.45 | 27.66 | 6421200.0 |
| 2003-04-24 15:00:00 | QQQ | ETF | 27.66 | 27.74 | 27.59 | 27.69 | 5604000.0 |
| 2003-04-24 15:30:00 | QQQ | ETF | 27.67 | 27.67 | 27.49 | 27.56 | 4984700.0 |
| 2003-04-24 16:00:00 | QQQ | ETF | 27.54 | 27.6 | 27.48 | 27.52 | 1865000.0 |
| 2003-04-24 16:30:00 | QQQ | ETF | 27.53 | 27.62 | 27.53 | 27.62 | 225900.0 |
| 2003-04-24 17:00:00 | QQQ | ETF | 27.62 | 27.62 | 27.56 | 27.57 | 58900.0 |
| 2003-04-24 17:30:00 | QQQ | ETF | 27.59 | 27.6 | 27.55 | 27.55 | 32800.0 |
| 2003-04-24 18:00:00 | QQQ | ETF | 27.57 | 27.59 | 27.56 | 27.56 | 40700.0 |
| 2003-04-24 18:30:00 | QQQ | ETF | 27.54 | 27.56 | 27.5 | 27.55 | 41000.0 |
| 2003-04-24 19:00:00 | QQQ | ETF | 27.5 | 27.52 | 27.47 | 27.48 | 59800.0 |
| 2003-04-24 19:30:00 | QQQ | ETF | 27.48 | 27.53 | 27.48 | 27.52 | 5700.0 |
| 2003-04-24 09:30:00 | IWM | ETF | 39.155 | 39.3 | 39.075 | 39.235 | 204200.0 |
| 2003-04-24 10:00:00 | IWM | ETF | 39.245 | 39.35 | 39.245 | 39.34 | 302000.0 |
> showing 50 of 669 rows — these rows as CSV