PREVIEW / etf_1hour / 2001-03-02
file: by_date/etf_1hour/2001/2001-03-02.parquet size: 11 KB rows: 199
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:00:00 | SPY | ETF | 122.5 | 123.4 | 122.5 | 122.8 | 1317500.0 |
| 2001-03-02 10:00:00 | SPY | ETF | 122.77 | 124.19 | 122.3 | 123.85 | 2207100.0 |
| 2001-03-02 11:00:00 | SPY | ETF | 123.76 | 123.92 | 122.98 | 123.75 | 685200.0 |
| 2001-03-02 12:00:00 | SPY | ETF | 123.75 | 125.05 | 123.7 | 124.65 | 2172200.0 |
| 2001-03-02 13:00:00 | SPY | ETF | 124.65 | 125.65 | 124.58 | 125.3 | 1861600.0 |
| 2001-03-02 14:00:00 | SPY | ETF | 125.34 | 125.46 | 124.42 | 124.6 | 2082400.0 |
| 2001-03-02 15:00:00 | SPY | ETF | 124.6 | 124.8 | 123.6 | 123.72 | 1455700.0 |
| 2001-03-02 16:00:00 | SPY | ETF | 123.6 | 125.42 | 123.57 | 124.75 | 415600.0 |
| 2001-03-02 09:00:00 | QQQ | ETF | 47.2 | 47.7 | 46.55 | 47.0 | 11599900.0 |
| 2001-03-02 10:00:00 | QQQ | ETF | 46.95 | 47.93 | 46.5 | 47.47 | 14393400.0 |
| 2001-03-02 11:00:00 | QQQ | ETF | 47.54 | 47.85 | 47.0 | 47.75 | 6921300.0 |
| 2001-03-02 12:00:00 | QQQ | ETF | 47.75 | 48.77 | 47.65 | 48.37 | 11433700.0 |
| 2001-03-02 13:00:00 | QQQ | ETF | 48.35 | 49.63 | 48.33 | 49.33 | 15403000.0 |
| 2001-03-02 14:00:00 | QQQ | ETF | 49.28 | 49.36 | 48.17 | 48.44 | 13997000.0 |
| 2001-03-02 15:00:00 | QQQ | ETF | 48.45 | 48.65 | 46.7 | 46.8 | 16933400.0 |
| 2001-03-02 16:00:00 | QQQ | ETF | 46.86 | 46.9 | 46.65 | 46.8 | 1646900.0 |
| 2001-03-02 17:00:00 | QQQ | ETF | 46.85 | 47.0 | 46.7 | 46.78 | 59000.0 |
| 2001-03-02 18:00:00 | QQQ | ETF | 46.8 | 46.95 | 46.8 | 46.8 | 5900.0 |
| 2001-03-02 09:00:00 | IWM | ETF | 46.65 | 47.05 | 46.625 | 47.05 | 137000.0 |
| 2001-03-02 10:00:00 | IWM | ETF | 46.775 | 47.495 | 46.65 | 47.495 | 140200.0 |
| 2001-03-02 11:00:00 | IWM | ETF | 47.47 | 47.49 | 47.205 | 47.35 | 291800.0 |
| 2001-03-02 12:00:00 | IWM | ETF | 47.5 | 47.85 | 47.375 | 47.69 | 52400.0 |
| 2001-03-02 13:00:00 | IWM | ETF | 47.95 | 48.15 | 47.88 | 48.0 | 66400.0 |
| 2001-03-02 14:00:00 | IWM | ETF | 47.875 | 47.875 | 47.675 | 47.725 | 45600.0 |
| 2001-03-02 15:00:00 | IWM | ETF | 47.65 | 47.745 | 47.375 | 47.7 | 260000.0 |
| 2001-03-02 16:00:00 | IWM | ETF | 47.525 | 47.525 | 47.525 | 47.525 | 21000.0 |
| 2001-03-02 09:00:00 | DIA | ETF | 103.52 | 103.92 | 103.3 | 103.3 | 318700.0 |
| 2001-03-02 10:00:00 | DIA | ETF | 103.36 | 104.5 | 103.01 | 104.2 | 748800.0 |
| 2001-03-02 11:00:00 | DIA | ETF | 104.05 | 104.46 | 103.6 | 104.3 | 185400.0 |
| 2001-03-02 12:00:00 | DIA | ETF | 104.2 | 105.8 | 104.2 | 105.25 | 435900.0 |
| 2001-03-02 13:00:00 | DIA | ETF | 105.25 | 105.99 | 105.25 | 105.85 | 290800.0 |
| 2001-03-02 14:00:00 | DIA | ETF | 105.8 | 105.8 | 105.13 | 105.25 | 122900.0 |
| 2001-03-02 15:00:00 | DIA | ETF | 105.18 | 105.45 | 104.36 | 104.61 | 552000.0 |
| 2001-03-02 16:00:00 | DIA | ETF | 104.61 | 104.9 | 104.6 | 104.8 | 65100.0 |
| 2001-03-02 17:00:00 | DIA | ETF | 106.0 | 106.0 | 106.0 | 106.0 | 300.0 |
> showing 35 of 199 rows — these rows as CSV