PREVIEW / etf_30min / 2003-01-03
file: by_date/etf_30min/2003/2003-01-03.parquet size: 20 KB rows: 612
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-01-03 08:00:00 | SPY | ETF | 91.13 | 91.2 | 91.1 | 91.2 | 5200.0 |
| 2003-01-03 08:30:00 | SPY | ETF | 91.1 | 91.1 | 90.97 | 90.97 | 30600.0 |
| 2003-01-03 09:00:00 | SPY | ETF | 90.98 | 91.04 | 90.95 | 90.95 | 9800.0 |
| 2003-01-03 09:30:00 | SPY | ETF | 90.98 | 91.08 | 90.66 | 90.98 | 4442700.0 |
| 2003-01-03 10:00:00 | SPY | ETF | 90.99 | 91.38 | 90.66 | 90.85 | 5242900.0 |
| 2003-01-03 10:30:00 | SPY | ETF | 90.86 | 91.06 | 90.7 | 90.81 | 1548800.0 |
| 2003-01-03 11:00:00 | SPY | ETF | 90.79 | 90.91 | 90.61 | 90.81 | 1821100.0 |
| 2003-01-03 11:30:00 | SPY | ETF | 90.81 | 90.95 | 90.72 | 90.83 | 1606700.0 |
| 2003-01-03 12:00:00 | SPY | ETF | 90.86 | 90.86 | 90.6 | 90.74 | 1357000.0 |
| 2003-01-03 12:30:00 | SPY | ETF | 90.74 | 90.88 | 90.63 | 90.8 | 1023300.0 |
| 2003-01-03 13:00:00 | SPY | ETF | 90.8 | 90.97 | 90.72 | 90.91 | 760800.0 |
| 2003-01-03 13:30:00 | SPY | ETF | 90.9 | 91.2 | 90.88 | 91.01 | 1474600.0 |
| 2003-01-03 14:00:00 | SPY | ETF | 91.03 | 91.03 | 90.69 | 90.71 | 1189200.0 |
| 2003-01-03 14:30:00 | SPY | ETF | 90.69 | 90.88 | 90.53 | 90.67 | 2044600.0 |
| 2003-01-03 15:00:00 | SPY | ETF | 90.65 | 91.0 | 90.5 | 90.95 | 1637000.0 |
| 2003-01-03 15:30:00 | SPY | ETF | 90.98 | 91.11 | 90.79 | 91.11 | 2335700.0 |
| 2003-01-03 16:00:00 | SPY | ETF | 91.1 | 91.35 | 91.05 | 91.33 | 2490800.0 |
| 2003-01-03 16:30:00 | SPY | ETF | 91.3 | 91.42 | 91.25 | 91.42 | 10300.0 |
| 2003-01-03 17:00:00 | SPY | ETF | 91.38 | 91.38 | 91.09 | 91.35 | 80800.0 |
| 2003-01-03 17:30:00 | SPY | ETF | 91.4 | 91.4 | 91.4 | 91.4 | 1200.0 |
| 2003-01-03 18:00:00 | SPY | ETF | 91.38 | 91.39 | 91.38 | 91.39 | 1500.0 |
| 2003-01-03 18:30:00 | SPY | ETF | 91.33 | 91.33 | 91.29 | 91.29 | 700.0 |
| 2003-01-03 19:00:00 | SPY | ETF | 91.29 | 91.29 | 91.29 | 91.29 | 500.0 |
| 2003-01-03 19:30:00 | SPY | ETF | 91.39 | 91.41 | 91.39 | 91.41 | 1000.0 |
| 2003-01-03 08:00:00 | QQQ | ETF | 25.4 | 25.57 | 25.4 | 25.53 | 18300.0 |
| 2003-01-03 08:30:00 | QQQ | ETF | 25.53 | 25.53 | 25.45 | 25.45 | 23100.0 |
| 2003-01-03 09:00:00 | QQQ | ETF | 25.46 | 25.49 | 25.42 | 25.45 | 19000.0 |
| 2003-01-03 09:30:00 | QQQ | ETF | 25.45 | 25.54 | 25.28 | 25.53 | 7782200.0 |
| 2003-01-03 10:00:00 | QQQ | ETF | 25.52 | 25.7 | 25.4 | 25.47 | 6553400.0 |
| 2003-01-03 10:30:00 | QQQ | ETF | 25.47 | 25.57 | 25.36 | 25.44 | 2738000.0 |
| 2003-01-03 11:00:00 | QQQ | ETF | 25.43 | 25.46 | 25.33 | 25.4 | 1413000.0 |
| 2003-01-03 11:30:00 | QQQ | ETF | 25.42 | 25.5 | 25.4 | 25.49 | 1376500.0 |
| 2003-01-03 12:00:00 | QQQ | ETF | 25.47 | 25.48 | 25.34 | 25.42 | 1301200.0 |
| 2003-01-03 12:30:00 | QQQ | ETF | 25.42 | 25.47 | 25.37 | 25.45 | 778600.0 |
| 2003-01-03 13:00:00 | QQQ | ETF | 25.46 | 25.54 | 25.43 | 25.53 | 1038300.0 |
| 2003-01-03 13:30:00 | QQQ | ETF | 25.54 | 25.64 | 25.51 | 25.58 | 2245500.0 |
| 2003-01-03 14:00:00 | QQQ | ETF | 25.59 | 25.6 | 25.48 | 25.5 | 1563300.0 |
| 2003-01-03 14:30:00 | QQQ | ETF | 25.5 | 25.55 | 25.35 | 25.44 | 2240000.0 |
| 2003-01-03 15:00:00 | QQQ | ETF | 25.44 | 25.56 | 25.37 | 25.55 | 2215700.0 |
| 2003-01-03 15:30:00 | QQQ | ETF | 25.55 | 25.65 | 25.45 | 25.61 | 2970900.0 |
| 2003-01-03 16:00:00 | QQQ | ETF | 25.63 | 25.75 | 25.59 | 25.73 | 1273800.0 |
| 2003-01-03 16:30:00 | QQQ | ETF | 25.72 | 25.8 | 25.65 | 25.78 | 108500.0 |
| 2003-01-03 17:00:00 | QQQ | ETF | 25.77 | 25.78 | 25.73 | 25.75 | 14900.0 |
| 2003-01-03 17:30:00 | QQQ | ETF | 25.75 | 25.75 | 25.73 | 25.75 | 21600.0 |
| 2003-01-03 18:00:00 | QQQ | ETF | 25.76 | 25.77 | 25.72 | 25.75 | 21300.0 |
| 2003-01-03 18:30:00 | QQQ | ETF | 25.75 | 25.79 | 25.75 | 25.78 | 1900.0 |
| 2003-01-03 19:00:00 | QQQ | ETF | 25.78 | 25.83 | 25.78 | 25.83 | 10900.0 |
| 2003-01-03 19:30:00 | QQQ | ETF | 25.83 | 25.86 | 25.8 | 25.86 | 5200.0 |
| 2003-01-03 09:30:00 | IWM | ETF | 39.0 | 39.0 | 38.72 | 38.88 | 449600.0 |
| 2003-01-03 10:00:00 | IWM | ETF | 38.92 | 39.05 | 38.72 | 38.85 | 511600.0 |
> showing 50 of 612 rows — these rows as CSV