PREVIEW / etf_30min / 2001-11-16
file: by_date/etf_30min/2001/2001-11-16.parquet size: 17 KB rows: 436
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-11-16 09:30:00 | SPY | ETF | 115.08 | 115.1 | 114.22 | 114.5 | 2444600.0 |
| 2001-11-16 10:00:00 | SPY | ETF | 114.47 | 114.87 | 114.31 | 114.53 | 2106700.0 |
| 2001-11-16 10:30:00 | SPY | ETF | 114.48 | 114.66 | 114.27 | 114.57 | 674700.0 |
| 2001-11-16 11:00:00 | SPY | ETF | 114.51 | 114.66 | 114.38 | 114.57 | 446000.0 |
| 2001-11-16 11:30:00 | SPY | ETF | 114.52 | 114.52 | 114.0 | 114.22 | 855100.0 |
| 2001-11-16 12:00:00 | SPY | ETF | 114.17 | 114.33 | 113.92 | 113.98 | 795400.0 |
| 2001-11-16 12:30:00 | SPY | ETF | 114.0 | 114.19 | 113.94 | 114.11 | 670600.0 |
| 2001-11-16 13:00:00 | SPY | ETF | 114.12 | 114.24 | 113.74 | 113.81 | 1948600.0 |
| 2001-11-16 13:30:00 | SPY | ETF | 113.78 | 114.0 | 113.44 | 113.5 | 915200.0 |
| 2001-11-16 14:00:00 | SPY | ETF | 113.5 | 113.79 | 113.49 | 113.65 | 925500.0 |
| 2001-11-16 14:30:00 | SPY | ETF | 113.69 | 113.7 | 113.4 | 113.69 | 807300.0 |
| 2001-11-16 15:00:00 | SPY | ETF | 113.66 | 114.18 | 113.6 | 114.12 | 1589000.0 |
| 2001-11-16 15:30:00 | SPY | ETF | 114.17 | 114.39 | 113.98 | 114.31 | 2592300.0 |
| 2001-11-16 16:00:00 | SPY | ETF | 114.3 | 114.5 | 114.07 | 114.2 | 1182800.0 |
| 2001-11-16 16:30:00 | SPY | ETF | 114.35 | 114.87 | 114.35 | 114.87 | 5000.0 |
| 2001-11-16 17:00:00 | SPY | ETF | 114.87 | 114.87 | 114.4 | 114.4 | 11800.0 |
| 2001-11-16 18:00:00 | SPY | ETF | 114.66 | 114.7 | 114.66 | 114.7 | 500.0 |
| 2001-11-16 09:30:00 | QQQ | ETF | 39.48 | 39.57 | 39.16 | 39.38 | 9552300.0 |
| 2001-11-16 10:00:00 | QQQ | ETF | 39.37 | 39.68 | 39.21 | 39.37 | 8703700.0 |
| 2001-11-16 10:30:00 | QQQ | ETF | 39.38 | 39.56 | 39.16 | 39.49 | 3234400.0 |
| 2001-11-16 11:00:00 | QQQ | ETF | 39.51 | 39.65 | 39.43 | 39.6 | 4592200.0 |
| 2001-11-16 11:30:00 | QQQ | ETF | 39.6 | 39.61 | 39.27 | 39.4 | 3682200.0 |
| 2001-11-16 12:00:00 | QQQ | ETF | 39.4 | 39.49 | 39.13 | 39.23 | 3149400.0 |
| 2001-11-16 12:30:00 | QQQ | ETF | 39.22 | 39.4 | 39.15 | 39.33 | 2712000.0 |
| 2001-11-16 13:00:00 | QQQ | ETF | 39.33 | 39.4 | 39.01 | 39.07 | 3897200.0 |
| 2001-11-16 13:30:00 | QQQ | ETF | 39.07 | 39.23 | 38.92 | 38.95 | 3671700.0 |
| 2001-11-16 14:00:00 | QQQ | ETF | 38.95 | 39.15 | 38.92 | 39.1 | 3271600.0 |
| 2001-11-16 14:30:00 | QQQ | ETF | 39.08 | 39.16 | 38.95 | 39.13 | 3234900.0 |
| 2001-11-16 15:00:00 | QQQ | ETF | 39.12 | 39.4 | 39.1 | 39.38 | 3746200.0 |
| 2001-11-16 15:30:00 | QQQ | ETF | 39.37 | 39.49 | 39.25 | 39.45 | 7477700.0 |
| 2001-11-16 16:00:00 | QQQ | ETF | 39.42 | 39.48 | 39.33 | 39.42 | 1971500.0 |
| 2001-11-16 16:30:00 | QQQ | ETF | 39.41 | 39.52 | 39.41 | 39.45 | 31900.0 |
| 2001-11-16 17:00:00 | QQQ | ETF | 39.45 | 42.08 | 39.43 | 39.5 | 66200.0 |
| 2001-11-16 17:30:00 | QQQ | ETF | 39.5 | 39.55 | 39.48 | 39.5 | 20300.0 |
| 2001-11-16 18:00:00 | QQQ | ETF | 39.5 | 39.52 | 39.46 | 39.52 | 6900.0 |
| 2001-11-16 09:30:00 | IWM | ETF | 44.83 | 44.9 | 44.66 | 44.825 | 223400.0 |
| 2001-11-16 10:00:00 | IWM | ETF | 44.735 | 44.99 | 44.735 | 44.94 | 38600.0 |
| 2001-11-16 10:30:00 | IWM | ETF | 44.94 | 44.95 | 44.935 | 44.95 | 7400.0 |
| 2001-11-16 11:00:00 | IWM | ETF | 44.99 | 45.075 | 44.85 | 44.905 | 11400.0 |
| 2001-11-16 11:30:00 | IWM | ETF | 45.045 | 45.045 | 44.945 | 44.945 | 5200.0 |
| 2001-11-16 12:00:00 | IWM | ETF | 44.94 | 44.99 | 44.935 | 44.935 | 4800.0 |
| 2001-11-16 12:30:00 | IWM | ETF | 44.935 | 44.965 | 44.91 | 44.945 | 1600.0 |
| 2001-11-16 13:00:00 | IWM | ETF | 44.935 | 44.935 | 44.81 | 44.86 | 3400.0 |
| 2001-11-16 13:30:00 | IWM | ETF | 44.865 | 44.865 | 44.765 | 44.77 | 9400.0 |
| 2001-11-16 14:00:00 | IWM | ETF | 44.755 | 44.86 | 44.65 | 44.86 | 19600.0 |
| 2001-11-16 14:30:00 | IWM | ETF | 44.84 | 44.84 | 44.64 | 44.84 | 19200.0 |
| 2001-11-16 15:00:00 | IWM | ETF | 44.84 | 44.86 | 44.815 | 44.86 | 2600.0 |
| 2001-11-16 15:30:00 | IWM | ETF | 44.845 | 45.025 | 44.76 | 45.015 | 74600.0 |
| 2001-11-16 16:00:00 | IWM | ETF | 44.995 | 44.995 | 44.995 | 44.995 | 2000.0 |
| 2001-11-16 09:30:00 | DIA | ETF | 99.16 | 99.34 | 98.63 | 98.85 | 280700.0 |
> showing 50 of 436 rows — these rows as CSV