PREVIEW / etf_30min / 2001-02-02
file: by_date/etf_30min/2001/2001-02-02.parquet size: 14 KB rows: 345
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-02 09:30:00 | SPY | ETF | 137.4 | 137.99 | 137.4 | 137.64 | 1079800.0 |
| 2001-02-02 10:00:00 | SPY | ETF | 137.6 | 137.8 | 137.36 | 137.37 | 338300.0 |
| 2001-02-02 10:30:00 | SPY | ETF | 137.39 | 137.49 | 136.75 | 136.78 | 586800.0 |
| 2001-02-02 11:00:00 | SPY | ETF | 136.88 | 136.88 | 136.35 | 136.35 | 643800.0 |
| 2001-02-02 11:30:00 | SPY | ETF | 136.42 | 136.6 | 136.01 | 136.02 | 477400.0 |
| 2001-02-02 12:00:00 | SPY | ETF | 136.09 | 136.45 | 136.0 | 136.15 | 486700.0 |
| 2001-02-02 12:30:00 | SPY | ETF | 136.37 | 136.51 | 135.83 | 135.83 | 967400.0 |
| 2001-02-02 13:00:00 | SPY | ETF | 135.85 | 136.05 | 135.56 | 136.0 | 663500.0 |
| 2001-02-02 13:30:00 | SPY | ETF | 136.05 | 136.3 | 135.9 | 135.98 | 250600.0 |
| 2001-02-02 14:00:00 | SPY | ETF | 135.95 | 136.3 | 135.82 | 135.9 | 287000.0 |
| 2001-02-02 14:30:00 | SPY | ETF | 135.83 | 135.99 | 135.56 | 135.56 | 604300.0 |
| 2001-02-02 15:00:00 | SPY | ETF | 135.56 | 136.26 | 135.08 | 135.2 | 616600.0 |
| 2001-02-02 15:30:00 | SPY | ETF | 135.2 | 135.42 | 135.0 | 135.08 | 623900.0 |
| 2001-02-02 16:00:00 | SPY | ETF | 135.0 | 135.09 | 134.75 | 134.8 | 638700.0 |
| 2001-02-02 16:30:00 | SPY | ETF | 134.8 | 134.8 | 134.8 | 134.8 | 200.0 |
| 2001-02-02 17:00:00 | SPY | ETF | 135.0 | 135.0 | 135.0 | 135.0 | 300.0 |
| 2001-02-02 18:00:00 | SPY | ETF | 135.0 | 135.0 | 135.0 | 135.0 | 200.0 |
| 2001-02-02 09:30:00 | QQQ | ETF | 64.94 | 65.29 | 64.14 | 64.5 | 5592500.0 |
| 2001-02-02 10:00:00 | QQQ | ETF | 64.35 | 64.68 | 63.91 | 63.99 | 3948500.0 |
| 2001-02-02 10:30:00 | QQQ | ETF | 63.99 | 64.11 | 63.29 | 63.35 | 3924500.0 |
| 2001-02-02 11:00:00 | QQQ | ETF | 63.31 | 63.66 | 62.91 | 63.05 | 3063600.0 |
| 2001-02-02 11:30:00 | QQQ | ETF | 62.91 | 63.29 | 62.8 | 62.88 | 3860800.0 |
| 2001-02-02 12:00:00 | QQQ | ETF | 62.85 | 63.4 | 62.8 | 63.3 | 2185000.0 |
| 2001-02-02 12:30:00 | QQQ | ETF | 63.3 | 63.48 | 62.94 | 63.11 | 2340900.0 |
| 2001-02-02 13:00:00 | QQQ | ETF | 63.0 | 63.1 | 62.68 | 63.05 | 2379700.0 |
| 2001-02-02 13:30:00 | QQQ | ETF | 63.0 | 63.35 | 62.84 | 62.98 | 3513000.0 |
| 2001-02-02 14:00:00 | QQQ | ETF | 62.91 | 63.2 | 62.64 | 62.74 | 1718100.0 |
| 2001-02-02 14:30:00 | QQQ | ETF | 62.74 | 62.85 | 62.4 | 62.54 | 2060700.0 |
| 2001-02-02 15:00:00 | QQQ | ETF | 62.51 | 62.62 | 61.9 | 62.09 | 4354900.0 |
| 2001-02-02 15:30:00 | QQQ | ETF | 62.06 | 62.24 | 61.54 | 61.7 | 5772700.0 |
| 2001-02-02 16:00:00 | QQQ | ETF | 61.7 | 62.29 | 61.48 | 61.6 | 1779500.0 |
| 2001-02-02 16:30:00 | QQQ | ETF | 61.67 | 61.75 | 61.5 | 61.6 | 37700.0 |
| 2001-02-02 17:00:00 | QQQ | ETF | 61.55 | 61.56 | 61.4 | 61.5 | 18000.0 |
| 2001-02-02 17:30:00 | QQQ | ETF | 61.46 | 61.99 | 61.36 | 61.45 | 14400.0 |
| 2001-02-02 18:00:00 | QQQ | ETF | 61.44 | 61.6 | 61.4 | 61.4 | 32700.0 |
| 2001-02-02 09:30:00 | IWM | ETF | 50.9 | 50.9 | 50.825 | 50.825 | 8600.0 |
| 2001-02-02 10:00:00 | IWM | ETF | 50.825 | 50.825 | 50.825 | 50.825 | 200.0 |
| 2001-02-02 10:30:00 | IWM | ETF | 50.575 | 50.575 | 50.575 | 50.575 | 1000.0 |
| 2001-02-02 11:00:00 | IWM | ETF | 50.5 | 50.675 | 50.45 | 50.45 | 113800.0 |
| 2001-02-02 11:30:00 | IWM | ETF | 50.475 | 50.475 | 50.25 | 50.45 | 34400.0 |
| 2001-02-02 12:00:00 | IWM | ETF | 50.3 | 50.475 | 50.25 | 50.475 | 82600.0 |
| 2001-02-02 12:30:00 | IWM | ETF | 50.4 | 50.415 | 50.4 | 50.41 | 1800.0 |
| 2001-02-02 13:00:00 | IWM | ETF | 50.225 | 50.325 | 50.1 | 50.265 | 164400.0 |
| 2001-02-02 13:30:00 | IWM | ETF | 50.4 | 50.4 | 50.175 | 50.175 | 6600.0 |
| 2001-02-02 14:00:00 | IWM | ETF | 50.25 | 50.45 | 50.25 | 50.275 | 2800.0 |
| 2001-02-02 14:30:00 | IWM | ETF | 50.2 | 50.2 | 50.0 | 50.05 | 216400.0 |
| 2001-02-02 15:00:00 | IWM | ETF | 50.175 | 50.175 | 49.975 | 49.975 | 64400.0 |
| 2001-02-02 15:30:00 | IWM | ETF | 49.975 | 50.045 | 49.7 | 49.7 | 160000.0 |
| 2001-02-02 16:00:00 | IWM | ETF | 49.685 | 49.685 | 49.685 | 49.685 | 200.0 |
| 2001-02-02 09:30:00 | DIA | ETF | 109.8 | 110.38 | 109.79 | 110.2 | 208800.0 |
> showing 50 of 345 rows — these rows as CSV