PREVIEW / etf_30min / 2001-05-11
file: by_date/etf_30min/2001/2001-05-11.parquet size: 14 KB rows: 351
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-05-11 09:30:00 | SPY | ETF | 126.0 | 126.49 | 125.9 | 126.06 | 891500.0 |
| 2001-05-11 10:00:00 | SPY | ETF | 126.15 | 126.18 | 124.81 | 125.26 | 1365100.0 |
| 2001-05-11 10:30:00 | SPY | ETF | 125.23 | 125.39 | 125.04 | 125.05 | 376600.0 |
| 2001-05-11 11:00:00 | SPY | ETF | 125.09 | 125.33 | 124.91 | 125.29 | 387900.0 |
| 2001-05-11 11:30:00 | SPY | ETF | 125.25 | 125.33 | 124.96 | 125.2 | 201100.0 |
| 2001-05-11 12:00:00 | SPY | ETF | 125.21 | 125.21 | 124.72 | 124.85 | 508500.0 |
| 2001-05-11 12:30:00 | SPY | ETF | 124.83 | 125.11 | 124.6 | 125.05 | 329400.0 |
| 2001-05-11 13:00:00 | SPY | ETF | 125.06 | 125.27 | 124.97 | 125.18 | 404900.0 |
| 2001-05-11 13:30:00 | SPY | ETF | 125.19 | 125.2 | 124.75 | 124.75 | 183500.0 |
| 2001-05-11 14:00:00 | SPY | ETF | 124.8 | 124.97 | 124.66 | 124.77 | 176800.0 |
| 2001-05-11 14:30:00 | SPY | ETF | 124.79 | 125.08 | 124.72 | 124.85 | 153600.0 |
| 2001-05-11 15:00:00 | SPY | ETF | 124.79 | 124.85 | 124.4 | 124.52 | 1073800.0 |
| 2001-05-11 15:30:00 | SPY | ETF | 124.53 | 124.94 | 124.43 | 124.82 | 916500.0 |
| 2001-05-11 16:00:00 | SPY | ETF | 124.82 | 125.29 | 124.82 | 125.25 | 489300.0 |
| 2001-05-11 16:30:00 | SPY | ETF | 125.25 | 125.25 | 125.25 | 125.25 | 400.0 |
| 2001-05-11 17:30:00 | SPY | ETF | 125.25 | 125.25 | 125.15 | 125.15 | 2200.0 |
| 2001-05-11 18:00:00 | SPY | ETF | 125.15 | 125.15 | 125.15 | 125.15 | 2800.0 |
| 2001-05-11 09:30:00 | QQQ | ETF | 45.84 | 46.42 | 45.7 | 46.27 | 6947600.0 |
| 2001-05-11 10:00:00 | QQQ | ETF | 46.2 | 46.3 | 45.57 | 46.01 | 6865000.0 |
| 2001-05-11 10:30:00 | QQQ | ETF | 46.04 | 46.25 | 45.79 | 45.82 | 3732800.0 |
| 2001-05-11 11:00:00 | QQQ | ETF | 45.81 | 45.99 | 45.61 | 45.9 | 4817400.0 |
| 2001-05-11 11:30:00 | QQQ | ETF | 45.88 | 45.94 | 45.51 | 45.7 | 2585400.0 |
| 2001-05-11 12:00:00 | QQQ | ETF | 45.66 | 45.7 | 45.36 | 45.53 | 3267000.0 |
| 2001-05-11 12:30:00 | QQQ | ETF | 45.53 | 45.65 | 45.3 | 45.58 | 2466100.0 |
| 2001-05-11 13:00:00 | QQQ | ETF | 45.58 | 45.78 | 45.51 | 45.74 | 1812000.0 |
| 2001-05-11 13:30:00 | QQQ | ETF | 45.68 | 45.78 | 45.41 | 45.41 | 1572000.0 |
| 2001-05-11 14:00:00 | QQQ | ETF | 45.43 | 45.68 | 45.36 | 45.5 | 1639200.0 |
| 2001-05-11 14:30:00 | QQQ | ETF | 45.5 | 45.8 | 45.47 | 45.65 | 3001200.0 |
| 2001-05-11 15:00:00 | QQQ | ETF | 45.6 | 45.62 | 45.1 | 45.15 | 3652000.0 |
| 2001-05-11 15:30:00 | QQQ | ETF | 45.18 | 45.45 | 45.09 | 45.41 | 3625900.0 |
| 2001-05-11 16:00:00 | QQQ | ETF | 45.38 | 45.59 | 45.35 | 45.5 | 1157700.0 |
| 2001-05-11 16:30:00 | QQQ | ETF | 45.55 | 45.58 | 45.51 | 45.53 | 10900.0 |
| 2001-05-11 17:00:00 | QQQ | ETF | 45.55 | 45.65 | 45.53 | 45.65 | 3400.0 |
| 2001-05-11 17:30:00 | QQQ | ETF | 45.6 | 45.65 | 45.6 | 45.6 | 3300.0 |
| 2001-05-11 18:00:00 | QQQ | ETF | 45.66 | 45.7 | 45.6 | 45.67 | 5500.0 |
| 2001-05-11 09:30:00 | IWM | ETF | 48.825 | 49.175 | 48.825 | 49.05 | 50600.0 |
| 2001-05-11 10:00:00 | IWM | ETF | 49.0 | 49.0 | 48.575 | 48.6 | 93800.0 |
| 2001-05-11 10:30:00 | IWM | ETF | 48.58 | 48.7 | 48.55 | 48.6 | 29600.0 |
| 2001-05-11 11:00:00 | IWM | ETF | 48.6 | 48.8 | 48.505 | 48.6 | 27600.0 |
| 2001-05-11 11:30:00 | IWM | ETF | 48.6 | 48.77 | 48.55 | 48.575 | 44800.0 |
| 2001-05-11 12:00:00 | IWM | ETF | 48.675 | 48.7 | 48.505 | 48.67 | 60600.0 |
| 2001-05-11 12:30:00 | IWM | ETF | 48.53 | 48.55 | 48.53 | 48.53 | 10200.0 |
| 2001-05-11 13:00:00 | IWM | ETF | 48.53 | 48.6 | 48.505 | 48.575 | 77400.0 |
| 2001-05-11 13:30:00 | IWM | ETF | 48.55 | 48.67 | 48.55 | 48.625 | 27200.0 |
| 2001-05-11 14:00:00 | IWM | ETF | 48.575 | 48.62 | 48.5 | 48.62 | 30400.0 |
| 2001-05-11 14:30:00 | IWM | ETF | 48.505 | 48.67 | 48.505 | 48.66 | 11400.0 |
| 2001-05-11 15:00:00 | IWM | ETF | 48.505 | 48.67 | 48.4 | 48.45 | 338200.0 |
| 2001-05-11 15:30:00 | IWM | ETF | 48.355 | 48.5 | 48.325 | 48.375 | 72400.0 |
| 2001-05-11 16:00:00 | IWM | ETF | 48.475 | 48.565 | 48.4 | 48.46 | 18000.0 |
| 2001-05-11 09:30:00 | DIA | ETF | 109.11 | 109.37 | 108.95 | 109.11 | 517900.0 |
> showing 50 of 351 rows — these rows as CSV