PREVIEW / etf_30min / 2001-02-05
file: by_date/etf_30min/2001/2001-02-05.parquet size: 13 KB rows: 326
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-02-05 09:30:00 | SPY | ETF | 134.8 | 135.4 | 134.8 | 135.36 | 771300.0 |
| 2001-02-05 10:00:00 | SPY | ETF | 135.4 | 135.5 | 134.97 | 135.31 | 435600.0 |
| 2001-02-05 10:30:00 | SPY | ETF | 135.42 | 135.6 | 134.87 | 134.95 | 306400.0 |
| 2001-02-05 11:00:00 | SPY | ETF | 134.91 | 135.46 | 134.91 | 135.28 | 212700.0 |
| 2001-02-05 11:30:00 | SPY | ETF | 135.2 | 135.35 | 134.91 | 135.1 | 159000.0 |
| 2001-02-05 12:00:00 | SPY | ETF | 135.19 | 135.34 | 134.98 | 135.3 | 161500.0 |
| 2001-02-05 12:30:00 | SPY | ETF | 135.27 | 135.27 | 134.9 | 135.14 | 60100.0 |
| 2001-02-05 13:00:00 | SPY | ETF | 135.1 | 135.18 | 134.98 | 135.07 | 82200.0 |
| 2001-02-05 13:30:00 | SPY | ETF | 135.0 | 135.25 | 134.75 | 135.25 | 315300.0 |
| 2001-02-05 14:00:00 | SPY | ETF | 135.29 | 135.39 | 135.05 | 135.39 | 233500.0 |
| 2001-02-05 14:30:00 | SPY | ETF | 135.3 | 135.7 | 135.14 | 135.65 | 346900.0 |
| 2001-02-05 15:00:00 | SPY | ETF | 135.56 | 135.85 | 135.37 | 135.8 | 294400.0 |
| 2001-02-05 15:30:00 | SPY | ETF | 135.8 | 135.9 | 135.3 | 135.89 | 268500.0 |
| 2001-02-05 16:00:00 | SPY | ETF | 135.89 | 135.94 | 135.67 | 135.79 | 555300.0 |
| 2001-02-05 16:30:00 | SPY | ETF | 135.44 | 136.0 | 135.44 | 136.0 | 56100.0 |
| 2001-02-05 09:30:00 | QQQ | ETF | 61.19 | 61.39 | 60.58 | 61.11 | 6573100.0 |
| 2001-02-05 10:00:00 | QQQ | ETF | 61.1 | 61.72 | 60.84 | 61.63 | 3503300.0 |
| 2001-02-05 10:30:00 | QQQ | ETF | 61.56 | 61.9 | 61.0 | 61.07 | 2583400.0 |
| 2001-02-05 11:00:00 | QQQ | ETF | 61.06 | 61.78 | 61.04 | 61.5 | 2378700.0 |
| 2001-02-05 11:30:00 | QQQ | ETF | 61.49 | 61.55 | 60.88 | 61.04 | 2836900.0 |
| 2001-02-05 12:00:00 | QQQ | ETF | 61.03 | 61.19 | 60.87 | 61.1 | 1317500.0 |
| 2001-02-05 12:30:00 | QQQ | ETF | 61.1 | 61.12 | 60.6 | 60.76 | 1173300.0 |
| 2001-02-05 13:00:00 | QQQ | ETF | 60.68 | 60.8 | 60.41 | 60.45 | 1986200.0 |
| 2001-02-05 13:30:00 | QQQ | ETF | 60.45 | 60.55 | 60.12 | 60.47 | 2698900.0 |
| 2001-02-05 14:00:00 | QQQ | ETF | 60.48 | 60.74 | 60.25 | 60.7 | 1783600.0 |
| 2001-02-05 14:30:00 | QQQ | ETF | 60.69 | 61.25 | 60.46 | 61.12 | 2726500.0 |
| 2001-02-05 15:00:00 | QQQ | ETF | 61.12 | 61.64 | 61.03 | 61.63 | 2776900.0 |
| 2001-02-05 15:30:00 | QQQ | ETF | 61.63 | 61.68 | 61.12 | 61.56 | 2633900.0 |
| 2001-02-05 16:00:00 | QQQ | ETF | 61.65 | 61.65 | 61.4 | 61.47 | 539600.0 |
| 2001-02-05 16:30:00 | QQQ | ETF | 61.49 | 61.79 | 61.49 | 61.7 | 24600.0 |
| 2001-02-05 17:00:00 | QQQ | ETF | 61.7 | 61.73 | 61.6 | 61.7 | 22400.0 |
| 2001-02-05 17:30:00 | QQQ | ETF | 61.68 | 61.7 | 61.64 | 61.7 | 4400.0 |
| 2001-02-05 18:00:00 | QQQ | ETF | 61.65 | 61.65 | 61.6 | 61.6 | 1300.0 |
| 2001-02-05 09:30:00 | IWM | ETF | 49.5 | 49.75 | 49.5 | 49.6 | 81200.0 |
| 2001-02-05 10:00:00 | IWM | ETF | 49.85 | 49.875 | 49.675 | 49.875 | 5800.0 |
| 2001-02-05 10:30:00 | IWM | ETF | 49.875 | 49.9 | 49.81 | 49.835 | 3800.0 |
| 2001-02-05 11:00:00 | IWM | ETF | 49.795 | 49.795 | 49.79 | 49.79 | 600.0 |
| 2001-02-05 11:30:00 | IWM | ETF | 49.75 | 49.925 | 49.75 | 49.795 | 1800.0 |
| 2001-02-05 12:00:00 | IWM | ETF | 49.795 | 49.815 | 49.65 | 49.815 | 3000.0 |
| 2001-02-05 12:30:00 | IWM | ETF | 49.82 | 49.82 | 49.65 | 49.65 | 15800.0 |
| 2001-02-05 13:00:00 | IWM | ETF | 49.65 | 49.65 | 49.6 | 49.65 | 12000.0 |
| 2001-02-05 13:30:00 | IWM | ETF | 49.6 | 49.6 | 49.455 | 49.455 | 25600.0 |
| 2001-02-05 14:00:00 | IWM | ETF | 49.775 | 49.775 | 49.75 | 49.75 | 1400.0 |
| 2001-02-05 14:30:00 | IWM | ETF | 49.725 | 49.95 | 49.6 | 49.75 | 16200.0 |
| 2001-02-05 15:00:00 | IWM | ETF | 49.9 | 49.975 | 49.7 | 49.775 | 360800.0 |
| 2001-02-05 15:30:00 | IWM | ETF | 49.995 | 49.995 | 49.995 | 49.995 | 10000.0 |
| 2001-02-05 16:00:00 | IWM | ETF | 49.785 | 49.785 | 49.785 | 49.785 | 800.0 |
| 2001-02-05 09:30:00 | DIA | ETF | 108.87 | 109.23 | 108.75 | 109.0 | 313700.0 |
| 2001-02-05 10:00:00 | DIA | ETF | 109.0 | 109.35 | 108.92 | 109.34 | 133000.0 |
| 2001-02-05 10:30:00 | DIA | ETF | 109.33 | 109.35 | 108.85 | 108.96 | 75100.0 |
> showing 50 of 326 rows — these rows as CSV