PREVIEW / etf_30min / 2001-08-06
file: by_date/etf_30min/2001/2001-08-06.parquet size: 14 KB rows: 349
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-08-06 09:30:00 | SPY | ETF | 121.35 | 121.51 | 121.23 | 121.25 | 710900.0 |
| 2001-08-06 10:00:00 | SPY | ETF | 121.24 | 121.51 | 120.99 | 121.04 | 841700.0 |
| 2001-08-06 10:30:00 | SPY | ETF | 121.04 | 121.14 | 120.68 | 120.84 | 679600.0 |
| 2001-08-06 11:00:00 | SPY | ETF | 120.83 | 120.99 | 120.79 | 120.88 | 397200.0 |
| 2001-08-06 11:30:00 | SPY | ETF | 120.88 | 121.03 | 120.71 | 120.8 | 701200.0 |
| 2001-08-06 12:00:00 | SPY | ETF | 120.77 | 120.84 | 120.55 | 120.55 | 432600.0 |
| 2001-08-06 12:30:00 | SPY | ETF | 120.55 | 120.62 | 120.37 | 120.53 | 598600.0 |
| 2001-08-06 13:00:00 | SPY | ETF | 120.53 | 120.68 | 120.52 | 120.55 | 144300.0 |
| 2001-08-06 13:30:00 | SPY | ETF | 120.57 | 120.57 | 120.36 | 120.56 | 557300.0 |
| 2001-08-06 14:00:00 | SPY | ETF | 120.57 | 120.59 | 120.17 | 120.26 | 438900.0 |
| 2001-08-06 14:30:00 | SPY | ETF | 120.27 | 120.38 | 120.1 | 120.36 | 389400.0 |
| 2001-08-06 15:00:00 | SPY | ETF | 120.36 | 120.43 | 120.15 | 120.27 | 437400.0 |
| 2001-08-06 15:30:00 | SPY | ETF | 120.23 | 120.53 | 120.19 | 120.45 | 1028000.0 |
| 2001-08-06 16:00:00 | SPY | ETF | 120.42 | 121.35 | 120.0 | 120.0 | 805700.0 |
| 2001-08-06 16:30:00 | SPY | ETF | 120.49 | 120.49 | 120.0 | 120.1 | 6100.0 |
| 2001-08-06 17:00:00 | SPY | ETF | 119.91 | 119.91 | 119.91 | 119.91 | 300.0 |
| 2001-08-06 17:30:00 | SPY | ETF | 120.31 | 120.39 | 120.2 | 120.39 | 300.0 |
| 2001-08-06 09:30:00 | QQQ | ETF | 42.53 | 42.83 | 42.48 | 42.62 | 4792600.0 |
| 2001-08-06 10:00:00 | QQQ | ETF | 42.62 | 42.9 | 42.5 | 42.59 | 2728500.0 |
| 2001-08-06 10:30:00 | QQQ | ETF | 42.56 | 42.69 | 42.37 | 42.55 | 2676500.0 |
| 2001-08-06 11:00:00 | QQQ | ETF | 42.56 | 42.77 | 42.5 | 42.65 | 2547700.0 |
| 2001-08-06 11:30:00 | QQQ | ETF | 42.64 | 42.76 | 42.53 | 42.64 | 1399500.0 |
| 2001-08-06 12:00:00 | QQQ | ETF | 42.64 | 42.71 | 42.5 | 42.51 | 1099000.0 |
| 2001-08-06 12:30:00 | QQQ | ETF | 42.51 | 42.56 | 42.39 | 42.46 | 1799600.0 |
| 2001-08-06 13:00:00 | QQQ | ETF | 42.43 | 42.57 | 42.42 | 42.53 | 1271500.0 |
| 2001-08-06 13:30:00 | QQQ | ETF | 42.52 | 42.62 | 42.42 | 42.6 | 1045000.0 |
| 2001-08-06 14:00:00 | QQQ | ETF | 42.59 | 42.62 | 42.41 | 42.48 | 1639700.0 |
| 2001-08-06 14:30:00 | QQQ | ETF | 42.48 | 42.6 | 42.35 | 42.55 | 1793500.0 |
| 2001-08-06 15:00:00 | QQQ | ETF | 42.53 | 42.55 | 42.36 | 42.42 | 2100500.0 |
| 2001-08-06 15:30:00 | QQQ | ETF | 42.46 | 42.54 | 42.39 | 42.48 | 3468200.0 |
| 2001-08-06 16:00:00 | QQQ | ETF | 42.47 | 42.65 | 42.43 | 42.49 | 1167300.0 |
| 2001-08-06 16:30:00 | QQQ | ETF | 42.48 | 42.52 | 42.44 | 42.5 | 38000.0 |
| 2001-08-06 17:00:00 | QQQ | ETF | 42.5 | 42.51 | 42.45 | 42.45 | 44100.0 |
| 2001-08-06 17:30:00 | QQQ | ETF | 42.45 | 42.52 | 42.45 | 42.5 | 26000.0 |
| 2001-08-06 18:00:00 | QQQ | ETF | 42.5 | 42.52 | 42.5 | 42.5 | 8200.0 |
| 2001-08-06 09:30:00 | IWM | ETF | 48.5 | 48.5 | 48.3 | 48.3 | 4000.0 |
| 2001-08-06 10:00:00 | IWM | ETF | 48.45 | 48.45 | 48.45 | 48.45 | 400.0 |
| 2001-08-06 10:30:00 | IWM | ETF | 48.385 | 48.385 | 48.255 | 48.255 | 1200.0 |
| 2001-08-06 11:00:00 | IWM | ETF | 48.2 | 48.2 | 48.2 | 48.2 | 200.0 |
| 2001-08-06 11:30:00 | IWM | ETF | 48.21 | 48.42 | 48.21 | 48.325 | 5600.0 |
| 2001-08-06 12:00:00 | IWM | ETF | 48.3 | 48.34 | 48.3 | 48.325 | 1000.0 |
| 2001-08-06 12:30:00 | IWM | ETF | 48.3 | 48.3 | 48.11 | 48.11 | 4400.0 |
| 2001-08-06 13:00:00 | IWM | ETF | 48.275 | 48.285 | 48.1 | 48.2 | 1000.0 |
| 2001-08-06 13:30:00 | IWM | ETF | 48.17 | 48.17 | 48.135 | 48.15 | 3000.0 |
| 2001-08-06 14:00:00 | IWM | ETF | 48.165 | 48.165 | 48.05 | 48.05 | 11800.0 |
| 2001-08-06 14:30:00 | IWM | ETF | 48.05 | 48.135 | 47.85 | 48.045 | 60200.0 |
| 2001-08-06 15:00:00 | IWM | ETF | 48.035 | 48.045 | 48.0 | 48.025 | 16200.0 |
| 2001-08-06 15:30:00 | IWM | ETF | 47.99 | 48.0 | 47.8 | 47.995 | 107000.0 |
| 2001-08-06 16:00:00 | IWM | ETF | 47.88 | 47.9 | 47.8 | 47.9 | 7200.0 |
| 2001-08-06 09:30:00 | DIA | ETF | 105.0 | 105.02 | 104.82 | 104.86 | 200400.0 |
> showing 50 of 349 rows — these rows as CSV