PREVIEW / etf_30min / 2001-07-03
file: by_date/etf_30min/2001/2001-07-03.parquet size: 11 KB rows: 214
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 |
|---|---|---|---|---|---|---|---|
| 2001-07-03 09:30:00 | SPY | ETF | 123.98 | 123.98 | 123.05 | 123.23 | 1031100.0 |
| 2001-07-03 10:00:00 | SPY | ETF | 123.2 | 123.61 | 123.2 | 123.59 | 634200.0 |
| 2001-07-03 10:30:00 | SPY | ETF | 123.54 | 123.63 | 123.33 | 123.54 | 176100.0 |
| 2001-07-03 11:00:00 | SPY | ETF | 123.47 | 123.64 | 123.41 | 123.41 | 217200.0 |
| 2001-07-03 11:30:00 | SPY | ETF | 123.43 | 123.83 | 123.36 | 123.77 | 187200.0 |
| 2001-07-03 12:00:00 | SPY | ETF | 123.74 | 123.95 | 123.62 | 123.65 | 283500.0 |
| 2001-07-03 12:30:00 | SPY | ETF | 123.68 | 123.77 | 123.51 | 123.63 | 365900.0 |
| 2001-07-03 13:00:00 | SPY | ETF | 123.7 | 124.1 | 123.51 | 124.1 | 300900.0 |
| 2001-07-03 09:30:00 | QQQ | ETF | 45.25 | 45.3 | 44.8 | 45.14 | 7318900.0 |
| 2001-07-03 10:00:00 | QQQ | ETF | 45.14 | 45.48 | 45.13 | 45.37 | 4157500.0 |
| 2001-07-03 10:30:00 | QQQ | ETF | 45.35 | 45.58 | 45.23 | 45.44 | 2440400.0 |
| 2001-07-03 11:00:00 | QQQ | ETF | 45.45 | 45.6 | 45.33 | 45.35 | 1866700.0 |
| 2001-07-03 11:30:00 | QQQ | ETF | 45.38 | 45.68 | 45.33 | 45.66 | 1251900.0 |
| 2001-07-03 12:00:00 | QQQ | ETF | 45.67 | 45.68 | 45.44 | 45.46 | 1324600.0 |
| 2001-07-03 12:30:00 | QQQ | ETF | 45.45 | 45.55 | 45.33 | 45.4 | 2157300.0 |
| 2001-07-03 13:00:00 | QQQ | ETF | 45.43 | 45.66 | 45.37 | 45.64 | 351600.0 |
| 2001-07-03 09:30:00 | IWM | ETF | 49.625 | 49.65 | 49.3 | 49.3 | 187800.0 |
| 2001-07-03 10:00:00 | IWM | ETF | 49.39 | 49.55 | 49.39 | 49.5 | 603600.0 |
| 2001-07-03 10:30:00 | IWM | ETF | 49.67 | 49.67 | 49.525 | 49.55 | 12200.0 |
| 2001-07-03 11:00:00 | IWM | ETF | 49.6 | 49.67 | 49.505 | 49.505 | 6200.0 |
| 2001-07-03 11:30:00 | IWM | ETF | 49.655 | 49.725 | 49.635 | 49.65 | 18800.0 |
| 2001-07-03 12:00:00 | IWM | ETF | 49.65 | 49.77 | 49.585 | 49.685 | 13000.0 |
| 2001-07-03 12:30:00 | IWM | ETF | 49.725 | 49.725 | 49.5 | 49.5 | 52600.0 |
| 2001-07-03 13:00:00 | IWM | ETF | 49.505 | 49.505 | 49.5 | 49.5 | 1200.0 |
| 2001-07-03 09:30:00 | DIA | ETF | 105.95 | 105.97 | 105.35 | 105.45 | 196600.0 |
| 2001-07-03 10:00:00 | DIA | ETF | 105.49 | 105.7 | 105.4 | 105.58 | 136500.0 |
| 2001-07-03 10:30:00 | DIA | ETF | 105.52 | 105.74 | 105.44 | 105.67 | 32500.0 |
| 2001-07-03 11:00:00 | DIA | ETF | 105.58 | 105.69 | 105.5 | 105.5 | 41600.0 |
| 2001-07-03 11:30:00 | DIA | ETF | 105.6 | 105.8 | 105.55 | 105.78 | 27100.0 |
| 2001-07-03 12:00:00 | DIA | ETF | 105.83 | 105.88 | 105.74 | 105.85 | 59400.0 |
| 2001-07-03 12:30:00 | DIA | ETF | 105.84 | 105.88 | 105.7 | 105.8 | 90600.0 |
| 2001-07-03 13:00:00 | DIA | ETF | 105.68 | 106.05 | 105.66 | 106.05 | 45900.0 |
> showing 32 of 214 rows — these rows as CSV