PREVIEW / etf_30min / 2008-11-26
file: by_date/etf_30min/2008/2008-11-26.parquet size: 186 KB rows: 6,561
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 |
|---|---|---|---|---|---|---|---|
| 2008-11-26 04:00:00 | SPY | ETF | 85.66 | 85.68 | 85.44 | 85.47 | 1900.0 |
| 2008-11-26 04:30:00 | SPY | ETF | 85.83 | 85.91 | 85.23 | 85.25 | 3400.0 |
| 2008-11-26 05:00:00 | SPY | ETF | 85.15 | 85.22 | 85.0 | 85.15 | 800.0 |
| 2008-11-26 05:30:00 | SPY | ETF | 84.5 | 84.77 | 84.5 | 84.77 | 20300.0 |
| 2008-11-26 06:00:00 | SPY | ETF | 84.89 | 84.89 | 84.76 | 84.78 | 7500.0 |
| 2008-11-26 06:30:00 | SPY | ETF | 84.71 | 84.78 | 84.59 | 84.75 | 9700.0 |
| 2008-11-26 07:00:00 | SPY | ETF | 84.93 | 85.11 | 84.81 | 85.07 | 936726.0 |
| 2008-11-26 07:30:00 | SPY | ETF | 85.08 | 85.17 | 83.99 | 84.09 | 2570137.0 |
| 2008-11-26 08:00:00 | SPY | ETF | 84.09 | 85.05 | 83.86 | 84.01 | 8922038.0 |
| 2008-11-26 08:30:00 | SPY | ETF | 83.97 | 85.747 | 83.47 | 84.27 | 10835941.0 |
| 2008-11-26 09:00:00 | SPY | ETF | 84.26 | 84.59 | 84.24 | 84.3 | 1492646.0 |
| 2008-11-26 09:30:00 | SPY | ETF | 84.3 | 85.6 | 84.24 | 85.26 | 33772922.0 |
| 2008-11-26 10:00:00 | SPY | ETF | 85.27 | 85.99 | 84.83 | 85.81 | 27129510.0 |
| 2008-11-26 10:30:00 | SPY | ETF | 85.81 | 86.33 | 85.29 | 86.2 | 25002668.0 |
| 2008-11-26 11:00:00 | SPY | ETF | 86.18 | 86.9 | 85.78 | 86.51 | 21673975.0 |
| 2008-11-26 11:30:00 | SPY | ETF | 86.51 | 87.23 | 86.42 | 86.73 | 20265351.0 |
| 2008-11-26 12:00:00 | SPY | ETF | 86.74 | 86.94 | 86.38 | 86.85 | 11785894.0 |
| 2008-11-26 12:30:00 | SPY | ETF | 86.85 | 87.5 | 86.7 | 87.29 | 18507288.0 |
| 2008-11-26 13:00:00 | SPY | ETF | 87.29 | 87.76 | 87.01 | 87.37 | 20384670.0 |
| 2008-11-26 13:30:00 | SPY | ETF | 87.37 | 87.39 | 86.83 | 87.04 | 12782249.0 |
| 2008-11-26 14:00:00 | SPY | ETF | 87.045 | 87.67 | 86.7 | 87.55 | 12280242.0 |
| 2008-11-26 14:30:00 | SPY | ETF | 87.55 | 88.67 | 87.55 | 88.44 | 33228544.0 |
| 2008-11-26 15:00:00 | SPY | ETF | 88.43 | 89.11 | 88.17 | 88.91 | 33768835.0 |
| 2008-11-26 15:30:00 | SPY | ETF | 88.91 | 89.15 | 88.31 | 89.04 | 51027725.0 |
| 2008-11-26 16:00:00 | SPY | ETF | 89.04 | 89.2 | 86.1379 | 88.97 | 14613809.0 |
| 2008-11-26 16:30:00 | SPY | ETF | 88.97 | 89.15 | 88.85 | 88.99 | 2564121.0 |
| 2008-11-26 17:00:00 | SPY | ETF | 89.01 | 89.06 | 86.14 | 88.99 | 3138370.0 |
| 2008-11-26 17:30:00 | SPY | ETF | 88.97 | 89.0 | 88.82 | 88.84 | 1072872.0 |
| 2008-11-26 18:00:00 | SPY | ETF | 88.87 | 88.9 | 88.61 | 88.67 | 67174.0 |
| 2008-11-26 18:30:00 | SPY | ETF | 88.7 | 88.91 | 88.63 | 88.65 | 114718.0 |
| 2008-11-26 19:00:00 | SPY | ETF | 88.65 | 88.8 | 88.63 | 88.68 | 30850.0 |
| 2008-11-26 19:30:00 | SPY | ETF | 88.69 | 88.72 | 88.61 | 88.68 | 17973.0 |
| 2008-11-26 04:00:00 | QQQ | ETF | 28.09 | 28.09 | 28.04 | 28.09 | 450.0 |
| 2008-11-26 04:30:00 | QQQ | ETF | 28.1 | 28.14 | 27.95 | 27.95 | 900.0 |
| 2008-11-26 05:00:00 | QQQ | ETF | 27.93 | 27.93 | 27.81 | 27.81 | 750.0 |
| 2008-11-26 05:30:00 | QQQ | ETF | 27.78 | 27.78 | 27.75 | 27.75 | 300.0 |
| 2008-11-26 06:00:00 | QQQ | ETF | 27.79 | 27.79 | 27.79 | 27.79 | 100.0 |
| 2008-11-26 06:30:00 | QQQ | ETF | 27.74 | 27.77 | 27.69 | 27.77 | 500.0 |
| 2008-11-26 07:00:00 | QQQ | ETF | 27.8 | 27.96 | 27.8 | 27.94 | 163755.0 |
| 2008-11-26 07:30:00 | QQQ | ETF | 27.96 | 27.98 | 27.74 | 27.81 | 903553.0 |
| 2008-11-26 08:00:00 | QQQ | ETF | 27.81 | 27.96 | 27.74 | 27.74 | 4174944.0 |
| 2008-11-26 08:30:00 | QQQ | ETF | 27.74 | 27.89 | 27.66 | 27.83 | 691984.0 |
| 2008-11-26 09:00:00 | QQQ | ETF | 27.84 | 27.97 | 27.84 | 27.89 | 503822.0 |
| 2008-11-26 09:30:00 | QQQ | ETF | 27.88 | 28.37 | 27.81 | 28.26 | 20407548.0 |
| 2008-11-26 10:00:00 | QQQ | ETF | 28.27 | 28.61 | 28.19 | 28.52 | 18022796.0 |
| 2008-11-26 10:30:00 | QQQ | ETF | 28.52 | 28.72 | 28.41 | 28.65 | 10272527.0 |
| 2008-11-26 11:00:00 | QQQ | ETF | 28.65 | 28.84 | 28.51 | 28.71 | 9159163.0 |
| 2008-11-26 11:30:00 | QQQ | ETF | 28.72 | 28.93 | 28.7 | 28.81 | 9020832.0 |
| 2008-11-26 12:00:00 | QQQ | ETF | 28.81 | 28.84 | 28.66 | 28.8 | 6397505.0 |
| 2008-11-26 12:30:00 | QQQ | ETF | 28.79 | 28.97 | 28.75 | 28.95 | 6446095.0 |
> showing 50 of 6,561 rows — these rows as CSV