PREVIEW / etf_30min / 2001-03-02
file: by_date/etf_30min/2001/2001-03-02.parquet size: 14 KB rows: 323
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-03-02 09:30:00 | SPY | ETF | 122.5 | 123.4 | 122.5 | 122.8 | 1317500.0 |
| 2001-03-02 10:00:00 | SPY | ETF | 122.77 | 123.6 | 122.3 | 123.4 | 1245500.0 |
| 2001-03-02 10:30:00 | SPY | ETF | 123.5 | 124.19 | 123.31 | 123.85 | 961600.0 |
| 2001-03-02 11:00:00 | SPY | ETF | 123.76 | 123.85 | 122.98 | 123.3 | 440300.0 |
| 2001-03-02 11:30:00 | SPY | ETF | 123.3 | 123.92 | 123.27 | 123.75 | 244900.0 |
| 2001-03-02 12:00:00 | SPY | ETF | 123.75 | 125.05 | 123.7 | 124.72 | 1235300.0 |
| 2001-03-02 12:30:00 | SPY | ETF | 124.66 | 124.81 | 124.4 | 124.65 | 936900.0 |
| 2001-03-02 13:00:00 | SPY | ETF | 124.65 | 125.25 | 124.58 | 125.07 | 990800.0 |
| 2001-03-02 13:30:00 | SPY | ETF | 125.16 | 125.65 | 125.16 | 125.3 | 870800.0 |
| 2001-03-02 14:00:00 | SPY | ETF | 125.34 | 125.34 | 124.65 | 125.16 | 983000.0 |
| 2001-03-02 14:30:00 | SPY | ETF | 125.0 | 125.46 | 124.42 | 124.6 | 1099400.0 |
| 2001-03-02 15:00:00 | SPY | ETF | 124.6 | 124.8 | 123.75 | 123.77 | 667600.0 |
| 2001-03-02 15:30:00 | SPY | ETF | 123.74 | 124.55 | 123.6 | 123.72 | 788100.0 |
| 2001-03-02 16:00:00 | SPY | ETF | 123.6 | 123.9 | 123.57 | 123.75 | 383300.0 |
| 2001-03-02 16:30:00 | SPY | ETF | 125.42 | 125.42 | 123.81 | 124.75 | 32300.0 |
| 2001-03-02 09:00:00 | QQQ | ETF | 47.2 | 47.2 | 47.2 | 47.2 | 4000.0 |
| 2001-03-02 09:30:00 | QQQ | ETF | 47.2 | 47.7 | 46.55 | 47.0 | 11595900.0 |
| 2001-03-02 10:00:00 | QQQ | ETF | 46.95 | 47.78 | 46.5 | 47.53 | 9399400.0 |
| 2001-03-02 10:30:00 | QQQ | ETF | 47.55 | 47.93 | 47.26 | 47.47 | 4994000.0 |
| 2001-03-02 11:00:00 | QQQ | ETF | 47.54 | 47.61 | 47.0 | 47.2 | 4281800.0 |
| 2001-03-02 11:30:00 | QQQ | ETF | 47.2 | 47.85 | 47.2 | 47.75 | 2639500.0 |
| 2001-03-02 12:00:00 | QQQ | ETF | 47.75 | 48.77 | 47.65 | 48.4 | 7521200.0 |
| 2001-03-02 12:30:00 | QQQ | ETF | 48.4 | 48.48 | 47.99 | 48.37 | 3912500.0 |
| 2001-03-02 13:00:00 | QQQ | ETF | 48.35 | 49.25 | 48.33 | 48.93 | 7044500.0 |
| 2001-03-02 13:30:00 | QQQ | ETF | 48.9 | 49.63 | 48.85 | 49.33 | 8358500.0 |
| 2001-03-02 14:00:00 | QQQ | ETF | 49.28 | 49.36 | 48.43 | 49.13 | 7036800.0 |
| 2001-03-02 14:30:00 | QQQ | ETF | 49.1 | 49.27 | 48.17 | 48.44 | 6960200.0 |
| 2001-03-02 15:00:00 | QQQ | ETF | 48.45 | 48.65 | 47.35 | 47.35 | 7802000.0 |
| 2001-03-02 15:30:00 | QQQ | ETF | 47.46 | 47.8 | 46.7 | 46.8 | 9131400.0 |
| 2001-03-02 16:00:00 | QQQ | ETF | 46.86 | 46.89 | 46.65 | 46.7 | 1593500.0 |
| 2001-03-02 16:30:00 | QQQ | ETF | 46.75 | 46.9 | 46.69 | 46.8 | 53400.0 |
| 2001-03-02 17:00:00 | QQQ | ETF | 46.85 | 46.9 | 46.7 | 46.8 | 50200.0 |
| 2001-03-02 17:30:00 | QQQ | ETF | 46.8 | 47.0 | 46.77 | 46.78 | 8800.0 |
| 2001-03-02 18:00:00 | QQQ | ETF | 46.8 | 46.95 | 46.8 | 46.8 | 5900.0 |
| 2001-03-02 09:30:00 | IWM | ETF | 46.65 | 47.05 | 46.625 | 47.05 | 137000.0 |
| 2001-03-02 10:00:00 | IWM | ETF | 46.775 | 47.05 | 46.65 | 47.05 | 87200.0 |
| 2001-03-02 10:30:00 | IWM | ETF | 47.4 | 47.495 | 47.3 | 47.495 | 53000.0 |
| 2001-03-02 11:00:00 | IWM | ETF | 47.47 | 47.49 | 47.205 | 47.25 | 51800.0 |
| 2001-03-02 11:30:00 | IWM | ETF | 47.425 | 47.425 | 47.35 | 47.35 | 240000.0 |
| 2001-03-02 12:00:00 | IWM | ETF | 47.5 | 47.8 | 47.375 | 47.6 | 37000.0 |
| 2001-03-02 12:30:00 | IWM | ETF | 47.65 | 47.85 | 47.65 | 47.69 | 15400.0 |
| 2001-03-02 13:00:00 | IWM | ETF | 47.95 | 48.15 | 47.88 | 48.0 | 63400.0 |
| 2001-03-02 13:30:00 | IWM | ETF | 48.075 | 48.075 | 48.0 | 48.0 | 3000.0 |
| 2001-03-02 14:00:00 | IWM | ETF | 47.875 | 47.875 | 47.675 | 47.875 | 41600.0 |
| 2001-03-02 14:30:00 | IWM | ETF | 47.725 | 47.725 | 47.725 | 47.725 | 4000.0 |
| 2001-03-02 15:00:00 | IWM | ETF | 47.65 | 47.745 | 47.425 | 47.5 | 38800.0 |
| 2001-03-02 15:30:00 | IWM | ETF | 47.375 | 47.7 | 47.375 | 47.7 | 221200.0 |
| 2001-03-02 16:00:00 | IWM | ETF | 47.525 | 47.525 | 47.525 | 47.525 | 21000.0 |
| 2001-03-02 09:30:00 | DIA | ETF | 103.52 | 103.92 | 103.3 | 103.3 | 318700.0 |
| 2001-03-02 10:00:00 | DIA | ETF | 103.36 | 103.99 | 103.01 | 103.86 | 271900.0 |
> showing 50 of 323 rows — these rows as CSV