PREVIEW / etf_30min / 2005-12-05
file: by_date/etf_30min/2005/2005-12-05.parquet size: 55 KB rows: 2,016
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 |
|---|---|---|---|---|---|---|---|
| 2005-12-05 05:00:00 | SPY | ETF | 126.78 | 126.78 | 126.78 | 126.78 | 2400.0 |
| 2005-12-05 06:00:00 | SPY | ETF | 126.77 | 126.78 | 126.77 | 126.78 | 25000.0 |
| 2005-12-05 07:00:00 | SPY | ETF | 126.78 | 126.78 | 126.75 | 126.75 | 20200.0 |
| 2005-12-05 07:30:00 | SPY | ETF | 126.75 | 126.8 | 126.75 | 126.8 | 6400.0 |
| 2005-12-05 08:00:00 | SPY | ETF | 126.79 | 126.84 | 126.69 | 126.79 | 651400.0 |
| 2005-12-05 08:30:00 | SPY | ETF | 126.84 | 126.85 | 126.72 | 126.72 | 219700.0 |
| 2005-12-05 09:00:00 | SPY | ETF | 126.7 | 126.72 | 126.63 | 126.64 | 295000.0 |
| 2005-12-05 09:30:00 | SPY | ETF | 126.64 | 126.73 | 126.54 | 126.63 | 5166800.0 |
| 2005-12-05 10:00:00 | SPY | ETF | 126.64 | 126.66 | 126.3 | 126.33 | 7579800.0 |
| 2005-12-05 10:30:00 | SPY | ETF | 126.34 | 126.42 | 126.18 | 126.23 | 4152800.0 |
| 2005-12-05 11:00:00 | SPY | ETF | 126.23 | 126.55 | 126.21 | 126.47 | 3197500.0 |
| 2005-12-05 11:30:00 | SPY | ETF | 126.47 | 126.5 | 126.36 | 126.41 | 2639200.0 |
| 2005-12-05 12:00:00 | SPY | ETF | 126.43 | 126.43 | 126.33 | 126.4 | 2230500.0 |
| 2005-12-05 12:30:00 | SPY | ETF | 126.4 | 126.69 | 126.4 | 126.62 | 2940000.0 |
| 2005-12-05 13:00:00 | SPY | ETF | 126.61 | 126.68 | 126.55 | 126.65 | 2189900.0 |
| 2005-12-05 13:30:00 | SPY | ETF | 126.65 | 126.66 | 126.43 | 126.49 | 2370000.0 |
| 2005-12-05 14:00:00 | SPY | ETF | 126.49 | 126.51 | 126.34 | 126.42 | 3098500.0 |
| 2005-12-05 14:30:00 | SPY | ETF | 126.42 | 126.66 | 126.34 | 126.57 | 4268300.0 |
| 2005-12-05 15:00:00 | SPY | ETF | 126.57 | 126.6 | 126.41 | 126.46 | 4946500.0 |
| 2005-12-05 15:30:00 | SPY | ETF | 126.46 | 126.66 | 126.46 | 126.63 | 4637800.0 |
| 2005-12-05 16:00:00 | SPY | ETF | 126.64 | 126.68 | 126.58 | 126.61 | 341000.0 |
| 2005-12-05 16:30:00 | SPY | ETF | 126.62 | 126.73 | 126.61 | 126.63 | 2533900.0 |
| 2005-12-05 17:00:00 | SPY | ETF | 126.62 | 126.62 | 126.61 | 126.62 | 20700.0 |
| 2005-12-05 17:30:00 | SPY | ETF | 126.6 | 126.64 | 126.55 | 126.6 | 77700.0 |
| 2005-12-05 18:00:00 | SPY | ETF | 126.6 | 126.62 | 126.6 | 126.6 | 18200.0 |
| 2005-12-05 19:00:00 | SPY | ETF | 126.62 | 126.62 | 126.62 | 126.62 | 1000.0 |
| 2005-12-05 09:30:00 | QQQ | ETF | 42.05 | 42.06 | 41.95 | 42.0 | 5646800.0 |
| 2005-12-05 10:00:00 | QQQ | ETF | 42.0 | 42.01 | 41.69 | 41.73 | 10964900.0 |
| 2005-12-05 10:30:00 | QQQ | ETF | 41.73 | 41.98 | 41.63 | 41.66 | 6779800.0 |
| 2005-12-05 11:00:00 | QQQ | ETF | 41.66 | 41.78 | 41.65 | 41.75 | 5168700.0 |
| 2005-12-05 11:30:00 | QQQ | ETF | 41.75 | 41.78 | 41.71 | 41.75 | 2125700.0 |
| 2005-12-05 12:00:00 | QQQ | ETF | 41.74 | 41.75 | 41.69 | 41.74 | 1849200.0 |
| 2005-12-05 12:30:00 | QQQ | ETF | 41.73 | 41.84 | 41.73 | 41.81 | 2952800.0 |
| 2005-12-05 13:00:00 | QQQ | ETF | 41.81 | 41.83 | 41.78 | 41.81 | 1560100.0 |
| 2005-12-05 13:30:00 | QQQ | ETF | 41.81 | 41.82 | 41.7 | 41.73 | 2968900.0 |
| 2005-12-05 14:00:00 | QQQ | ETF | 41.72 | 41.74 | 41.66 | 41.72 | 3604500.0 |
| 2005-12-05 14:30:00 | QQQ | ETF | 41.73 | 41.81 | 41.69 | 41.8 | 3682800.0 |
| 2005-12-05 15:00:00 | QQQ | ETF | 41.8 | 41.8 | 41.7 | 41.73 | 3273700.0 |
| 2005-12-05 15:30:00 | QQQ | ETF | 41.73 | 41.81 | 41.72 | 41.79 | 4922400.0 |
| 2005-12-05 07:30:00 | IWM | ETF | 68.86 | 68.86 | 68.86 | 68.86 | 5000.0 |
| 2005-12-05 08:00:00 | IWM | ETF | 68.87 | 68.87 | 68.78 | 68.83 | 22000.0 |
| 2005-12-05 08:30:00 | IWM | ETF | 68.82 | 68.82 | 68.78 | 68.78 | 24000.0 |
| 2005-12-05 09:00:00 | IWM | ETF | 68.75 | 68.76 | 68.73 | 68.76 | 2200.0 |
| 2005-12-05 09:30:00 | IWM | ETF | 68.71 | 68.76 | 68.3401 | 68.44 | 6006300.0 |
| 2005-12-05 10:00:00 | IWM | ETF | 68.44 | 68.45 | 68.01 | 68.08 | 3678600.0 |
| 2005-12-05 10:30:00 | IWM | ETF | 68.07 | 68.14 | 67.93 | 67.95 | 1649400.0 |
| 2005-12-05 11:00:00 | IWM | ETF | 67.94 | 68.18 | 67.92 | 68.14 | 1636900.0 |
| 2005-12-05 11:30:00 | IWM | ETF | 68.14 | 68.2 | 68.08 | 68.12 | 415200.0 |
| 2005-12-05 12:00:00 | IWM | ETF | 68.12 | 68.19 | 68.06 | 68.18 | 325800.0 |
| 2005-12-05 12:30:00 | IWM | ETF | 68.18 | 68.35 | 68.17 | 68.29 | 734700.0 |
> showing 50 of 2,016 rows — these rows as CSV