PREVIEW / etf_30min / 2001-12-26
file: by_date/etf_30min/2001/2001-12-26.parquet size: 16 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-12-26 09:30:00 | SPY | ETF | 114.65 | 115.64 | 114.65 | 115.6 | 1480400.0 |
| 2001-12-26 10:00:00 | SPY | ETF | 115.65 | 116.07 | 115.6 | 115.92 | 859600.0 |
| 2001-12-26 10:30:00 | SPY | ETF | 115.94 | 116.21 | 115.91 | 115.97 | 818000.0 |
| 2001-12-26 11:00:00 | SPY | ETF | 115.95 | 116.08 | 115.89 | 115.97 | 348900.0 |
| 2001-12-26 11:30:00 | SPY | ETF | 116.0 | 116.15 | 115.96 | 116.05 | 308100.0 |
| 2001-12-26 12:00:00 | SPY | ETF | 116.05 | 116.1 | 115.93 | 115.95 | 193500.0 |
| 2001-12-26 12:30:00 | SPY | ETF | 115.98 | 116.05 | 115.93 | 116.02 | 310600.0 |
| 2001-12-26 13:00:00 | SPY | ETF | 115.99 | 116.02 | 115.74 | 115.81 | 846100.0 |
| 2001-12-26 13:30:00 | SPY | ETF | 115.81 | 115.9 | 115.76 | 115.86 | 642600.0 |
| 2001-12-26 14:00:00 | SPY | ETF | 115.83 | 116.02 | 115.83 | 115.85 | 240000.0 |
| 2001-12-26 14:30:00 | SPY | ETF | 115.85 | 116.07 | 115.84 | 116.0 | 398000.0 |
| 2001-12-26 15:00:00 | SPY | ETF | 116.03 | 116.03 | 115.55 | 115.56 | 1101900.0 |
| 2001-12-26 15:30:00 | SPY | ETF | 115.55 | 115.55 | 115.19 | 115.25 | 1200600.0 |
| 2001-12-26 16:00:00 | SPY | ETF | 115.31 | 115.6 | 115.22 | 115.6 | 1307200.0 |
| 2001-12-26 17:00:00 | SPY | ETF | 115.54 | 115.54 | 115.54 | 115.54 | 3500.0 |
| 2001-12-26 09:30:00 | QQQ | ETF | 39.37 | 40.09 | 39.37 | 40.04 | 7376400.0 |
| 2001-12-26 10:00:00 | QQQ | ETF | 40.05 | 40.25 | 39.98 | 40.08 | 3731600.0 |
| 2001-12-26 10:30:00 | QQQ | ETF | 40.06 | 40.27 | 40.05 | 40.1 | 3175700.0 |
| 2001-12-26 11:00:00 | QQQ | ETF | 40.1 | 40.22 | 40.06 | 40.15 | 2225900.0 |
| 2001-12-26 11:30:00 | QQQ | ETF | 40.15 | 40.3 | 40.11 | 40.22 | 3470500.0 |
| 2001-12-26 12:00:00 | QQQ | ETF | 40.28 | 40.28 | 40.12 | 40.14 | 740700.0 |
| 2001-12-26 12:30:00 | QQQ | ETF | 40.15 | 40.19 | 40.11 | 40.18 | 754500.0 |
| 2001-12-26 13:00:00 | QQQ | ETF | 40.15 | 40.18 | 39.97 | 40.08 | 1509600.0 |
| 2001-12-26 13:30:00 | QQQ | ETF | 40.07 | 40.14 | 40.03 | 40.04 | 933100.0 |
| 2001-12-26 14:00:00 | QQQ | ETF | 40.05 | 40.14 | 39.99 | 40.01 | 1271600.0 |
| 2001-12-26 14:30:00 | QQQ | ETF | 40.02 | 40.14 | 39.97 | 40.05 | 1817000.0 |
| 2001-12-26 15:00:00 | QQQ | ETF | 40.06 | 40.13 | 39.64 | 39.67 | 3483100.0 |
| 2001-12-26 15:30:00 | QQQ | ETF | 39.65 | 39.72 | 39.5 | 39.65 | 5163900.0 |
| 2001-12-26 16:00:00 | QQQ | ETF | 39.66 | 39.75 | 39.62 | 39.7 | 779100.0 |
| 2001-12-26 16:30:00 | QQQ | ETF | 39.7 | 39.75 | 39.7 | 39.72 | 13000.0 |
| 2001-12-26 17:00:00 | QQQ | ETF | 39.7 | 39.74 | 39.69 | 39.69 | 11400.0 |
| 2001-12-26 17:30:00 | QQQ | ETF | 39.69 | 39.69 | 39.65 | 39.69 | 12300.0 |
| 2001-12-26 18:00:00 | QQQ | ETF | 39.71 | 39.71 | 39.71 | 39.71 | 400.0 |
| 2001-12-26 09:30:00 | IWM | ETF | 48.3 | 48.62 | 48.3 | 48.61 | 56200.0 |
| 2001-12-26 10:00:00 | IWM | ETF | 48.615 | 48.87 | 48.615 | 48.825 | 39400.0 |
| 2001-12-26 10:30:00 | IWM | ETF | 48.695 | 48.82 | 48.695 | 48.795 | 52000.0 |
| 2001-12-26 11:00:00 | IWM | ETF | 48.775 | 48.785 | 48.67 | 48.74 | 6600.0 |
| 2001-12-26 11:30:00 | IWM | ETF | 48.64 | 48.75 | 48.61 | 48.7 | 89200.0 |
| 2001-12-26 12:00:00 | IWM | ETF | 48.7 | 48.745 | 48.62 | 48.7 | 6200.0 |
| 2001-12-26 12:30:00 | IWM | ETF | 48.655 | 48.735 | 48.61 | 48.71 | 6200.0 |
| 2001-12-26 13:00:00 | IWM | ETF | 48.715 | 48.735 | 48.63 | 48.65 | 168800.0 |
| 2001-12-26 13:30:00 | IWM | ETF | 48.65 | 48.71 | 48.6 | 48.705 | 8200.0 |
| 2001-12-26 14:00:00 | IWM | ETF | 48.705 | 48.705 | 48.615 | 48.675 | 44400.0 |
| 2001-12-26 14:30:00 | IWM | ETF | 48.62 | 48.685 | 48.605 | 48.605 | 33000.0 |
| 2001-12-26 15:00:00 | IWM | ETF | 48.66 | 48.67 | 48.6 | 48.615 | 98800.0 |
| 2001-12-26 15:30:00 | IWM | ETF | 48.605 | 48.74 | 48.5 | 48.74 | 153800.0 |
| 2001-12-26 16:00:00 | IWM | ETF | 48.75 | 48.75 | 48.71 | 48.71 | 200200.0 |
| 2001-12-26 09:30:00 | DIA | ETF | 100.49 | 101.07 | 100.46 | 101.04 | 119300.0 |
| 2001-12-26 10:00:00 | DIA | ETF | 101.09 | 101.5 | 101.09 | 101.39 | 100300.0 |
| 2001-12-26 10:30:00 | DIA | ETF | 101.45 | 101.71 | 101.45 | 101.58 | 131700.0 |
> showing 50 of 436 rows — these rows as CSV