PREVIEW / etf_30min / 2006-11-02
file: by_date/etf_30min/2006/2006-11-02.parquet size: 82 KB rows: 2,954
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-02 07:00:00 | SPY | ETF | 137.07 | 137.2 | 137.05 | 137.16 | 64100.0 |
| 2006-11-02 07:30:00 | SPY | ETF | 137.16 | 137.2 | 137.04 | 137.14 | 115500.0 |
| 2006-11-02 08:00:00 | SPY | ETF | 137.12 | 137.22 | 136.92 | 137.1 | 1137300.0 |
| 2006-11-02 08:30:00 | SPY | ETF | 137.1 | 137.16 | 136.5 | 136.6 | 2848700.0 |
| 2006-11-02 09:00:00 | SPY | ETF | 136.59 | 136.9094 | 136.44 | 136.5 | 3330800.0 |
| 2006-11-02 09:30:00 | SPY | ETF | 136.51 | 136.67 | 136.36 | 136.45 | 8090600.0 |
| 2006-11-02 10:00:00 | SPY | ETF | 136.45 | 136.72 | 136.37 | 136.7 | 6733400.0 |
| 2006-11-02 10:30:00 | SPY | ETF | 136.69 | 136.84 | 136.5 | 136.76 | 4765500.0 |
| 2006-11-02 11:00:00 | SPY | ETF | 136.76 | 137.01 | 136.55 | 136.81 | 5556600.0 |
| 2006-11-02 11:30:00 | SPY | ETF | 136.8 | 136.83 | 136.57 | 136.62 | 3290300.0 |
| 2006-11-02 12:00:00 | SPY | ETF | 136.61 | 136.85 | 136.61 | 136.7089 | 2105900.0 |
| 2006-11-02 12:30:00 | SPY | ETF | 136.72 | 136.84 | 136.56 | 136.6 | 1671400.0 |
| 2006-11-02 13:00:00 | SPY | ETF | 136.6 | 136.81 | 136.5 | 136.76 | 1748000.0 |
| 2006-11-02 13:30:00 | SPY | ETF | 136.75 | 136.85 | 136.68 | 136.77 | 1905400.0 |
| 2006-11-02 14:00:00 | SPY | ETF | 136.77 | 136.85 | 136.66 | 136.69 | 2251000.0 |
| 2006-11-02 14:30:00 | SPY | ETF | 136.69 | 136.8 | 136.54 | 136.57 | 2988200.0 |
| 2006-11-02 15:00:00 | SPY | ETF | 136.57 | 136.78 | 136.56 | 136.7 | 1906500.0 |
| 2006-11-02 15:30:00 | SPY | ETF | 136.71 | 136.91 | 136.66 | 136.81 | 5779200.0 |
| 2006-11-02 16:00:00 | SPY | ETF | 136.8 | 136.86 | 136.725 | 136.81 | 1134800.0 |
| 2006-11-02 16:30:00 | SPY | ETF | 136.81 | 136.83 | 136.78 | 136.79 | 107300.0 |
| 2006-11-02 17:00:00 | SPY | ETF | 136.78 | 136.8 | 136.77 | 136.8 | 11500.0 |
| 2006-11-02 17:30:00 | SPY | ETF | 136.8 | 136.8 | 136.8 | 136.8 | 400.0 |
| 2006-11-02 18:00:00 | SPY | ETF | 136.79 | 136.79 | 136.75 | 136.75 | 10300.0 |
| 2006-11-02 18:30:00 | SPY | ETF | 136.75 | 136.75 | 136.75 | 136.75 | 500.0 |
| 2006-11-02 09:30:00 | QQQ | ETF | 41.82 | 41.92 | 41.74 | 41.86 | 15700900.0 |
| 2006-11-02 10:00:00 | QQQ | ETF | 41.85 | 41.97 | 41.81 | 41.96 | 10320300.0 |
| 2006-11-02 10:30:00 | QQQ | ETF | 41.96 | 42.08 | 41.9 | 42.03 | 11400000.0 |
| 2006-11-02 11:00:00 | QQQ | ETF | 42.04 | 42.14 | 41.99 | 42.01 | 8933600.0 |
| 2006-11-02 11:30:00 | QQQ | ETF | 42.01 | 42.05 | 41.94 | 41.97 | 6778200.0 |
| 2006-11-02 12:00:00 | QQQ | ETF | 41.97 | 42.07 | 41.96 | 42.01 | 4382200.0 |
| 2006-11-02 12:30:00 | QQQ | ETF | 42.01 | 42.06 | 41.9 | 41.95 | 7493900.0 |
| 2006-11-02 13:00:00 | QQQ | ETF | 41.94 | 42.01 | 41.88 | 41.98 | 6239700.0 |
| 2006-11-02 13:30:00 | QQQ | ETF | 41.98 | 42.02 | 41.95 | 41.97 | 1660200.0 |
| 2006-11-02 14:00:00 | QQQ | ETF | 41.97 | 42.01 | 41.95 | 41.99 | 3507000.0 |
| 2006-11-02 14:30:00 | QQQ | ETF | 41.98 | 42.03 | 41.95 | 41.95 | 2598000.0 |
| 2006-11-02 15:00:00 | QQQ | ETF | 41.95 | 42.02 | 41.94 | 41.98 | 2751800.0 |
| 2006-11-02 15:30:00 | QQQ | ETF | 41.98 | 42.06 | 41.96 | 42.03 | 8050300.0 |
| 2006-11-02 07:00:00 | IWM | ETF | 74.69 | 74.85 | 74.69 | 74.85 | 4700.0 |
| 2006-11-02 07:30:00 | IWM | ETF | 74.85 | 74.85 | 74.85 | 74.85 | 300.0 |
| 2006-11-02 08:00:00 | IWM | ETF | 74.71 | 74.75 | 74.62 | 74.62 | 42800.0 |
| 2006-11-02 08:30:00 | IWM | ETF | 74.61 | 74.62 | 74.23 | 74.3 | 703500.0 |
| 2006-11-02 09:00:00 | IWM | ETF | 74.29 | 74.58 | 74.13 | 74.14 | 1102300.0 |
| 2006-11-02 09:30:00 | IWM | ETF | 74.11 | 74.76 | 74.1 | 74.24 | 8986800.0 |
| 2006-11-02 10:00:00 | IWM | ETF | 74.25 | 74.57 | 74.17 | 74.55 | 3317600.0 |
| 2006-11-02 10:30:00 | IWM | ETF | 74.56 | 74.78 | 74.43 | 74.67 | 5998100.0 |
| 2006-11-02 11:00:00 | IWM | ETF | 74.68 | 74.9 | 74.61 | 74.61 | 4084200.0 |
| 2006-11-02 11:30:00 | IWM | ETF | 74.61 | 74.72 | 74.49 | 74.55 | 3933100.0 |
| 2006-11-02 12:00:00 | IWM | ETF | 74.55 | 74.79 | 74.46 | 74.6 | 3000700.0 |
| 2006-11-02 12:30:00 | IWM | ETF | 74.6 | 74.73 | 74.48 | 74.57 | 1764000.0 |
| 2006-11-02 13:00:00 | IWM | ETF | 74.57 | 74.73 | 74.5 | 74.65 | 1401700.0 |
> showing 50 of 2,954 rows — these rows as CSV