PREVIEW / etf_30min / 2002-01-02
file: by_date/etf_30min/2002/2002-01-02.parquet size: 18 KB rows: 471
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-02 09:30:00 | SPY | ETF | 115.11 | 115.13 | 114.49 | 114.5 | 2733600.0 |
| 2002-01-02 10:00:00 | SPY | ETF | 114.49 | 114.88 | 114.24 | 114.37 | 3604600.0 |
| 2002-01-02 10:30:00 | SPY | ETF | 114.36 | 114.4 | 113.81 | 114.1 | 1060000.0 |
| 2002-01-02 11:00:00 | SPY | ETF | 114.11 | 114.47 | 114.0 | 114.31 | 750700.0 |
| 2002-01-02 11:30:00 | SPY | ETF | 114.32 | 114.57 | 114.25 | 114.28 | 474400.0 |
| 2002-01-02 12:00:00 | SPY | ETF | 114.26 | 114.44 | 114.18 | 114.43 | 334800.0 |
| 2002-01-02 12:30:00 | SPY | ETF | 114.4 | 114.47 | 114.25 | 114.34 | 897600.0 |
| 2002-01-02 13:00:00 | SPY | ETF | 114.31 | 114.52 | 114.26 | 114.42 | 578400.0 |
| 2002-01-02 13:30:00 | SPY | ETF | 114.42 | 114.95 | 114.38 | 114.89 | 576200.0 |
| 2002-01-02 14:00:00 | SPY | ETF | 114.94 | 115.02 | 114.51 | 114.61 | 627800.0 |
| 2002-01-02 14:30:00 | SPY | ETF | 114.61 | 114.94 | 114.43 | 114.6 | 765500.0 |
| 2002-01-02 15:00:00 | SPY | ETF | 114.61 | 115.2 | 114.42 | 115.19 | 1650700.0 |
| 2002-01-02 15:30:00 | SPY | ETF | 115.15 | 115.65 | 115.15 | 115.59 | 2092900.0 |
| 2002-01-02 16:00:00 | SPY | ETF | 115.62 | 115.75 | 115.5 | 115.5 | 3060500.0 |
| 2002-01-02 16:30:00 | SPY | ETF | 115.59 | 115.6 | 115.59 | 115.6 | 2300.0 |
| 2002-01-02 17:30:00 | SPY | ETF | 115.56 | 115.56 | 115.56 | 115.56 | 100.0 |
| 2002-01-02 18:00:00 | SPY | ETF | 115.61 | 115.61 | 115.41 | 115.41 | 1300.0 |
| 2002-01-02 09:30:00 | QQQ | ETF | 39.57 | 39.65 | 39.24 | 39.24 | 10788900.0 |
| 2002-01-02 10:00:00 | QQQ | ETF | 39.28 | 39.57 | 39.2 | 39.32 | 7847900.0 |
| 2002-01-02 10:30:00 | QQQ | ETF | 39.39 | 39.39 | 38.93 | 39.13 | 6901000.0 |
| 2002-01-02 11:00:00 | QQQ | ETF | 39.14 | 39.35 | 39.04 | 39.25 | 2790300.0 |
| 2002-01-02 11:30:00 | QQQ | ETF | 39.24 | 39.34 | 39.06 | 39.08 | 2212600.0 |
| 2002-01-02 12:00:00 | QQQ | ETF | 39.09 | 39.18 | 39.0 | 39.17 | 1516600.0 |
| 2002-01-02 12:30:00 | QQQ | ETF | 39.17 | 39.2 | 39.04 | 39.1 | 2729500.0 |
| 2002-01-02 13:00:00 | QQQ | ETF | 39.1 | 39.23 | 39.03 | 39.1 | 1416200.0 |
| 2002-01-02 13:30:00 | QQQ | ETF | 39.13 | 39.52 | 39.1 | 39.48 | 3691300.0 |
| 2002-01-02 14:00:00 | QQQ | ETF | 39.48 | 39.55 | 39.3 | 39.35 | 3250000.0 |
| 2002-01-02 14:30:00 | QQQ | ETF | 39.35 | 39.57 | 39.26 | 39.37 | 3917800.0 |
| 2002-01-02 15:00:00 | QQQ | ETF | 39.37 | 39.71 | 39.27 | 39.67 | 4906400.0 |
| 2002-01-02 15:30:00 | QQQ | ETF | 39.67 | 40.05 | 39.66 | 40.02 | 6013300.0 |
| 2002-01-02 16:00:00 | QQQ | ETF | 40.04 | 40.15 | 39.88 | 40.09 | 1949400.0 |
| 2002-01-02 16:30:00 | QQQ | ETF | 40.08 | 40.2 | 40.01 | 40.17 | 56400.0 |
| 2002-01-02 17:00:00 | QQQ | ETF | 40.15 | 40.15 | 40.1 | 40.15 | 21000.0 |
| 2002-01-02 17:30:00 | QQQ | ETF | 40.13 | 40.16 | 40.11 | 40.15 | 9100.0 |
| 2002-01-02 18:00:00 | QQQ | ETF | 40.16 | 40.17 | 40.12 | 40.12 | 18600.0 |
| 2002-01-02 09:30:00 | IWM | ETF | 48.55 | 48.645 | 48.15 | 48.345 | 191000.0 |
| 2002-01-02 10:00:00 | IWM | ETF | 48.335 | 48.39 | 47.875 | 47.895 | 85800.0 |
| 2002-01-02 10:30:00 | IWM | ETF | 47.875 | 47.875 | 47.64 | 47.675 | 113800.0 |
| 2002-01-02 11:00:00 | IWM | ETF | 47.735 | 47.855 | 47.72 | 47.825 | 22000.0 |
| 2002-01-02 11:30:00 | IWM | ETF | 47.85 | 47.91 | 47.8 | 47.875 | 492400.0 |
| 2002-01-02 12:00:00 | IWM | ETF | 47.875 | 47.925 | 47.835 | 47.925 | 43200.0 |
| 2002-01-02 12:30:00 | IWM | ETF | 47.895 | 47.98 | 47.83 | 47.83 | 21200.0 |
| 2002-01-02 13:00:00 | IWM | ETF | 47.835 | 47.985 | 47.68 | 47.745 | 115400.0 |
| 2002-01-02 13:30:00 | IWM | ETF | 47.685 | 47.9 | 47.68 | 47.9 | 45600.0 |
| 2002-01-02 14:00:00 | IWM | ETF | 47.985 | 48.0 | 47.885 | 47.895 | 15600.0 |
| 2002-01-02 14:30:00 | IWM | ETF | 47.875 | 48.085 | 47.84 | 48.065 | 116200.0 |
| 2002-01-02 15:00:00 | IWM | ETF | 48.035 | 48.215 | 47.9 | 48.195 | 106200.0 |
| 2002-01-02 15:30:00 | IWM | ETF | 48.205 | 48.355 | 48.14 | 48.355 | 84000.0 |
| 2002-01-02 16:00:00 | IWM | ETF | 48.5 | 48.515 | 48.06 | 48.515 | 13400.0 |
| 2002-01-02 09:30:00 | DIA | ETF | 100.48 | 100.48 | 99.91 | 100.03 | 168500.0 |
> showing 50 of 471 rows — these rows as CSV