PREVIEW / etf_30min / 2001-10-19
file: by_date/etf_30min/2001/2001-10-19.parquet size: 16 KB rows: 400
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-10-19 09:30:00 | SPY | ETF | 107.0 | 107.2 | 106.7 | 106.83 | 2380100.0 |
| 2001-10-19 10:00:00 | SPY | ETF | 106.71 | 106.76 | 106.07 | 106.3 | 3185400.0 |
| 2001-10-19 10:30:00 | SPY | ETF | 106.27 | 106.53 | 106.12 | 106.53 | 1040400.0 |
| 2001-10-19 11:00:00 | SPY | ETF | 106.52 | 106.63 | 106.4 | 106.45 | 748400.0 |
| 2001-10-19 11:30:00 | SPY | ETF | 106.43 | 106.48 | 106.01 | 106.06 | 2062200.0 |
| 2001-10-19 12:00:00 | SPY | ETF | 106.04 | 106.38 | 106.04 | 106.26 | 528000.0 |
| 2001-10-19 12:30:00 | SPY | ETF | 106.27 | 106.33 | 106.08 | 106.2 | 190900.0 |
| 2001-10-19 13:00:00 | SPY | ETF | 106.19 | 106.59 | 106.12 | 106.58 | 912100.0 |
| 2001-10-19 13:30:00 | SPY | ETF | 106.58 | 106.75 | 106.46 | 106.64 | 585900.0 |
| 2001-10-19 14:00:00 | SPY | ETF | 106.63 | 107.05 | 106.54 | 106.84 | 811700.0 |
| 2001-10-19 14:30:00 | SPY | ETF | 106.84 | 107.28 | 106.79 | 107.04 | 2500400.0 |
| 2001-10-19 15:00:00 | SPY | ETF | 107.02 | 107.44 | 106.94 | 107.36 | 1941100.0 |
| 2001-10-19 15:30:00 | SPY | ETF | 107.37 | 107.91 | 107.3 | 107.55 | 3470800.0 |
| 2001-10-19 16:00:00 | SPY | ETF | 107.56 | 107.6 | 107.33 | 107.36 | 1032100.0 |
| 2001-10-19 16:30:00 | SPY | ETF | 107.35 | 107.35 | 107.35 | 107.35 | 1500.0 |
| 2001-10-19 17:00:00 | SPY | ETF | 107.25 | 108.15 | 107.14 | 107.5 | 3600.0 |
| 2001-10-19 17:30:00 | SPY | ETF | 107.6 | 107.6 | 107.6 | 107.6 | 200.0 |
| 2001-10-19 18:00:00 | SPY | ETF | 107.7 | 107.7 | 107.67 | 107.67 | 200.0 |
| 2001-10-19 09:30:00 | QQQ | ETF | 32.86 | 33.17 | 32.76 | 32.8 | 8326400.0 |
| 2001-10-19 10:00:00 | QQQ | ETF | 32.77 | 32.84 | 32.51 | 32.72 | 9031700.0 |
| 2001-10-19 10:30:00 | QQQ | ETF | 32.72 | 32.88 | 32.61 | 32.88 | 3473400.0 |
| 2001-10-19 11:00:00 | QQQ | ETF | 32.88 | 32.93 | 32.68 | 32.7 | 2582800.0 |
| 2001-10-19 11:30:00 | QQQ | ETF | 32.69 | 32.73 | 32.45 | 32.46 | 3878700.0 |
| 2001-10-19 12:00:00 | QQQ | ETF | 32.46 | 32.73 | 32.45 | 32.65 | 2565000.0 |
| 2001-10-19 12:30:00 | QQQ | ETF | 32.66 | 32.69 | 32.55 | 32.58 | 1217800.0 |
| 2001-10-19 13:00:00 | QQQ | ETF | 32.61 | 32.82 | 32.56 | 32.79 | 2203200.0 |
| 2001-10-19 13:30:00 | QQQ | ETF | 32.78 | 33.06 | 32.75 | 33.05 | 5135200.0 |
| 2001-10-19 14:00:00 | QQQ | ETF | 33.03 | 33.39 | 32.95 | 33.27 | 7242100.0 |
| 2001-10-19 14:30:00 | QQQ | ETF | 33.25 | 33.55 | 33.22 | 33.32 | 6931000.0 |
| 2001-10-19 15:00:00 | QQQ | ETF | 33.32 | 33.61 | 33.25 | 33.5 | 5343900.0 |
| 2001-10-19 15:30:00 | QQQ | ETF | 33.49 | 33.75 | 33.46 | 33.55 | 8323700.0 |
| 2001-10-19 16:00:00 | QQQ | ETF | 33.53 | 33.68 | 33.2 | 33.55 | 4127900.0 |
| 2001-10-19 16:30:00 | QQQ | ETF | 33.55 | 33.56 | 33.51 | 33.52 | 128900.0 |
| 2001-10-19 17:00:00 | QQQ | ETF | 33.52 | 33.54 | 33.5 | 33.54 | 3800.0 |
| 2001-10-19 17:30:00 | QQQ | ETF | 33.54 | 33.58 | 33.5 | 33.51 | 20700.0 |
| 2001-10-19 18:00:00 | QQQ | ETF | 33.55 | 33.58 | 33.5 | 33.5 | 15600.0 |
| 2001-10-19 09:30:00 | IWM | ETF | 41.725 | 42.0 | 41.725 | 41.99 | 57800.0 |
| 2001-10-19 10:00:00 | IWM | ETF | 41.75 | 41.795 | 41.725 | 41.755 | 51200.0 |
| 2001-10-19 10:30:00 | IWM | ETF | 41.845 | 41.955 | 41.79 | 41.955 | 18200.0 |
| 2001-10-19 11:00:00 | IWM | ETF | 41.96 | 42.05 | 41.955 | 42.0 | 70400.0 |
| 2001-10-19 11:30:00 | IWM | ETF | 41.875 | 41.875 | 41.81 | 41.875 | 9000.0 |
| 2001-10-19 12:00:00 | IWM | ETF | 41.865 | 41.87 | 41.785 | 41.87 | 3600.0 |
| 2001-10-19 12:30:00 | IWM | ETF | 41.87 | 41.87 | 41.815 | 41.865 | 2800.0 |
| 2001-10-19 13:00:00 | IWM | ETF | 41.865 | 41.875 | 41.8 | 41.855 | 17000.0 |
| 2001-10-19 13:30:00 | IWM | ETF | 41.95 | 42.0 | 41.935 | 41.975 | 58400.0 |
| 2001-10-19 14:00:00 | IWM | ETF | 42.015 | 42.11 | 42.015 | 42.095 | 5800.0 |
| 2001-10-19 14:30:00 | IWM | ETF | 42.045 | 42.3 | 42.045 | 42.21 | 108200.0 |
| 2001-10-19 15:00:00 | IWM | ETF | 42.2 | 42.385 | 42.125 | 42.385 | 68000.0 |
| 2001-10-19 15:30:00 | IWM | ETF | 42.465 | 42.475 | 42.275 | 42.325 | 17000.0 |
| 2001-10-19 16:00:00 | IWM | ETF | 42.3 | 42.3 | 42.3 | 42.3 | 21600.0 |
> showing 50 of 400 rows — these rows as CSV