PREVIEW / etf_30min / 2003-04-28
file: by_date/etf_30min/2003/2003-04-28.parquet size: 22 KB rows: 659
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-28 08:00:00 | SPY | ETF | 90.49 | 90.6 | 90.49 | 90.6 | 19700.0 |
| 2003-04-28 08:30:00 | SPY | ETF | 90.55 | 90.66 | 90.5 | 90.58 | 47000.0 |
| 2003-04-28 09:00:00 | SPY | ETF | 90.55 | 90.56 | 90.37 | 90.44 | 131000.0 |
| 2003-04-28 09:30:00 | SPY | ETF | 90.44 | 90.9 | 90.3 | 90.9 | 5583700.0 |
| 2003-04-28 10:00:00 | SPY | ETF | 90.9 | 91.22 | 90.83 | 91.13 | 4911100.0 |
| 2003-04-28 10:30:00 | SPY | ETF | 91.14 | 91.76 | 91.08 | 91.71 | 4813000.0 |
| 2003-04-28 11:00:00 | SPY | ETF | 91.71 | 91.92 | 91.67 | 91.74 | 3378300.0 |
| 2003-04-28 11:30:00 | SPY | ETF | 91.72 | 91.98 | 91.6 | 91.68 | 2410100.0 |
| 2003-04-28 12:00:00 | SPY | ETF | 91.65 | 91.73 | 91.52 | 91.65 | 1616600.0 |
| 2003-04-28 12:30:00 | SPY | ETF | 91.64 | 91.79 | 91.5 | 91.75 | 1727200.0 |
| 2003-04-28 13:00:00 | SPY | ETF | 91.76 | 91.8 | 91.56 | 91.56 | 1143200.0 |
| 2003-04-28 13:30:00 | SPY | ETF | 91.56 | 91.73 | 91.39 | 91.66 | 2038600.0 |
| 2003-04-28 14:00:00 | SPY | ETF | 91.68 | 92.0 | 91.64 | 91.96 | 2178100.0 |
| 2003-04-28 14:30:00 | SPY | ETF | 91.96 | 92.09 | 91.85 | 92.03 | 2649900.0 |
| 2003-04-28 15:00:00 | SPY | ETF | 92.0 | 92.19 | 91.9 | 92.16 | 3406500.0 |
| 2003-04-28 15:30:00 | SPY | ETF | 92.16 | 92.17 | 91.62 | 91.86 | 3860600.0 |
| 2003-04-28 16:00:00 | SPY | ETF | 91.86 | 91.97 | 91.74 | 91.84 | 2250100.0 |
| 2003-04-28 16:30:00 | SPY | ETF | 91.8 | 91.83 | 91.75 | 91.77 | 29500.0 |
| 2003-04-28 17:00:00 | SPY | ETF | 91.75 | 91.75 | 91.72 | 91.72 | 4500.0 |
| 2003-04-28 17:30:00 | SPY | ETF | 91.75 | 91.81 | 91.75 | 91.81 | 4100.0 |
| 2003-04-28 18:00:00 | SPY | ETF | 91.81 | 91.85 | 91.77 | 91.77 | 27700.0 |
| 2003-04-28 18:30:00 | SPY | ETF | 91.75 | 91.75 | 91.72 | 91.72 | 900.0 |
| 2003-04-28 19:00:00 | SPY | ETF | 91.77 | 91.8 | 91.77 | 91.8 | 500.0 |
| 2003-04-28 19:30:00 | SPY | ETF | 91.77 | 91.8 | 91.77 | 91.8 | 1200.0 |
| 2003-04-28 08:00:00 | QQQ | ETF | 27.1 | 27.1 | 27.05 | 27.08 | 10500.0 |
| 2003-04-28 08:30:00 | QQQ | ETF | 27.06 | 27.12 | 27.02 | 27.1 | 58400.0 |
| 2003-04-28 09:00:00 | QQQ | ETF | 27.08 | 27.1 | 27.01 | 27.04 | 76200.0 |
| 2003-04-28 09:30:00 | QQQ | ETF | 27.05 | 27.25 | 26.95 | 27.22 | 8725500.0 |
| 2003-04-28 10:00:00 | QQQ | ETF | 27.22 | 27.29 | 27.15 | 27.24 | 6115600.0 |
| 2003-04-28 10:30:00 | QQQ | ETF | 27.24 | 27.48 | 27.22 | 27.46 | 7515500.0 |
| 2003-04-28 11:00:00 | QQQ | ETF | 27.46 | 27.54 | 27.43 | 27.46 | 5310200.0 |
| 2003-04-28 11:30:00 | QQQ | ETF | 27.45 | 27.56 | 27.44 | 27.5 | 3271900.0 |
| 2003-04-28 12:00:00 | QQQ | ETF | 27.48 | 27.49 | 27.4 | 27.44 | 2150800.0 |
| 2003-04-28 12:30:00 | QQQ | ETF | 27.44 | 27.5 | 27.4 | 27.47 | 2382900.0 |
| 2003-04-28 13:00:00 | QQQ | ETF | 27.48 | 27.52 | 27.45 | 27.45 | 1858600.0 |
| 2003-04-28 13:30:00 | QQQ | ETF | 27.45 | 27.49 | 27.37 | 27.47 | 1828300.0 |
| 2003-04-28 14:00:00 | QQQ | ETF | 27.47 | 27.59 | 27.44 | 27.55 | 2641800.0 |
| 2003-04-28 14:30:00 | QQQ | ETF | 27.56 | 27.62 | 27.52 | 27.54 | 2587600.0 |
| 2003-04-28 15:00:00 | QQQ | ETF | 27.54 | 27.63 | 27.51 | 27.61 | 3101600.0 |
| 2003-04-28 15:30:00 | QQQ | ETF | 27.61 | 27.62 | 27.47 | 27.52 | 4890100.0 |
| 2003-04-28 16:00:00 | QQQ | ETF | 27.52 | 27.55 | 27.44 | 27.5 | 1860900.0 |
| 2003-04-28 16:30:00 | QQQ | ETF | 27.5 | 27.54 | 27.44 | 27.44 | 267200.0 |
| 2003-04-28 17:00:00 | QQQ | ETF | 27.44 | 27.48 | 27.42 | 27.46 | 190900.0 |
| 2003-04-28 17:30:00 | QQQ | ETF | 27.46 | 27.47 | 27.45 | 27.46 | 5500.0 |
| 2003-04-28 18:00:00 | QQQ | ETF | 27.46 | 27.47 | 27.43 | 27.46 | 10100.0 |
| 2003-04-28 18:30:00 | QQQ | ETF | 27.45 | 27.48 | 27.45 | 27.48 | 2600.0 |
| 2003-04-28 19:00:00 | QQQ | ETF | 27.45 | 27.45 | 27.44 | 27.44 | 2000.0 |
| 2003-04-28 19:30:00 | QQQ | ETF | 27.49 | 27.49 | 27.47 | 27.47 | 15100.0 |
| 2003-04-28 09:30:00 | IWM | ETF | 38.9 | 38.99 | 38.78 | 38.99 | 381600.0 |
| 2003-04-28 10:00:00 | IWM | ETF | 38.995 | 39.19 | 38.995 | 39.175 | 212000.0 |
> showing 50 of 659 rows — these rows as CSV