PREVIEW / etf_30min / 2008-12-01
file: by_date/etf_30min/2008/2008-12-01.parquet size: 187 KB rows: 6,635
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-12-01 04:00:00 | SPY | ETF | 88.71 | 88.71 | 88.5 | 88.5 | 1600.0 |
| 2008-12-01 04:30:00 | SPY | ETF | 88.35 | 88.35 | 88.1 | 88.1 | 2450.0 |
| 2008-12-01 05:00:00 | SPY | ETF | 88.1 | 88.17 | 87.9 | 88.17 | 2700.0 |
| 2008-12-01 05:30:00 | SPY | ETF | 88.06 | 88.06 | 87.6 | 87.94 | 3620.0 |
| 2008-12-01 06:00:00 | SPY | ETF | 87.88 | 88.12 | 87.88 | 88.12 | 31550.0 |
| 2008-12-01 06:30:00 | SPY | ETF | 88.13 | 88.13 | 87.71 | 88.0 | 75450.0 |
| 2008-12-01 07:00:00 | SPY | ETF | 88.09 | 88.14 | 87.87 | 87.95 | 361739.0 |
| 2008-12-01 07:30:00 | SPY | ETF | 87.95 | 87.99 | 87.37 | 87.7 | 597110.0 |
| 2008-12-01 08:00:00 | SPY | ETF | 87.7 | 90.09 | 87.47 | 87.7 | 1087961.0 |
| 2008-12-01 08:30:00 | SPY | ETF | 87.68 | 88.66 | 87.54 | 87.74 | 672976.0 |
| 2008-12-01 09:00:00 | SPY | ETF | 87.74 | 87.87 | 87.24 | 87.5 | 1533322.0 |
| 2008-12-01 09:30:00 | SPY | ETF | 87.51 | 87.55 | 85.68 | 85.83 | 53290142.0 |
| 2008-12-01 10:00:00 | SPY | ETF | 85.83 | 87.45 | 85.55 | 85.63 | 29955500.0 |
| 2008-12-01 10:30:00 | SPY | ETF | 85.63 | 85.87 | 85.25 | 85.27 | 22790954.0 |
| 2008-12-01 11:00:00 | SPY | ETF | 85.27 | 86.99 | 84.94 | 85.03 | 17724313.0 |
| 2008-12-01 11:30:00 | SPY | ETF | 85.03 | 87.39 | 84.97 | 85.28 | 13729555.0 |
| 2008-12-01 12:00:00 | SPY | ETF | 85.29 | 85.46 | 84.64 | 84.72 | 17866416.0 |
| 2008-12-01 12:30:00 | SPY | ETF | 84.72 | 84.9 | 84.39 | 84.53 | 11963776.0 |
| 2008-12-01 13:00:00 | SPY | ETF | 84.52 | 87.19 | 84.51 | 84.85 | 11554093.0 |
| 2008-12-01 13:30:00 | SPY | ETF | 84.84 | 85.27 | 84.4 | 84.85 | 17689047.0 |
| 2008-12-01 14:00:00 | SPY | ETF | 84.85 | 84.93 | 84.26 | 84.78 | 19229228.0 |
| 2008-12-01 14:30:00 | SPY | ETF | 84.77 | 86.21 | 84.52 | 84.84 | 23507917.0 |
| 2008-12-01 15:00:00 | SPY | ETF | 84.83 | 85.0 | 83.76 | 83.88 | 32136508.0 |
| 2008-12-01 15:30:00 | SPY | ETF | 83.89 | 84.87 | 81.97 | 82.09 | 66046407.0 |
| 2008-12-01 16:00:00 | SPY | ETF | 82.1 | 90.0257 | 81.82 | 82.08 | 23940795.0 |
| 2008-12-01 16:30:00 | SPY | ETF | 82.1 | 90.0257 | 81.83 | 82.05 | 2144915.0 |
| 2008-12-01 17:00:00 | SPY | ETF | 82.05 | 82.14 | 81.86 | 81.96 | 820095.0 |
| 2008-12-01 17:30:00 | SPY | ETF | 81.93 | 82.08 | 81.89 | 82.08 | 221241.0 |
| 2008-12-01 18:00:00 | SPY | ETF | 82.08 | 82.19 | 82.0 | 82.0 | 357020.0 |
| 2008-12-01 18:30:00 | SPY | ETF | 82.03 | 82.19 | 81.99 | 82.0 | 443399.0 |
| 2008-12-01 19:00:00 | SPY | ETF | 82.01 | 82.35 | 82.0 | 82.33 | 192150.0 |
| 2008-12-01 19:30:00 | SPY | ETF | 82.34 | 82.4 | 82.22 | 82.39 | 152438.0 |
| 2008-12-01 20:00:00 | SPY | ETF | 82.4 | 82.4 | 82.4 | 82.4 | 500.0 |
| 2008-12-01 04:00:00 | QQQ | ETF | 28.82 | 28.82 | 28.79 | 28.79 | 1650.0 |
| 2008-12-01 04:30:00 | QQQ | ETF | 28.76 | 28.76 | 28.64 | 28.64 | 2100.0 |
| 2008-12-01 06:30:00 | QQQ | ETF | 28.56 | 28.56 | 28.56 | 28.56 | 100.0 |
| 2008-12-01 07:00:00 | QQQ | ETF | 28.56 | 28.58 | 28.56 | 28.58 | 2107.0 |
| 2008-12-01 07:30:00 | QQQ | ETF | 28.56 | 28.56 | 28.38 | 28.5 | 227328.0 |
| 2008-12-01 08:00:00 | QQQ | ETF | 28.5 | 28.75 | 28.42 | 28.56 | 864498.0 |
| 2008-12-01 08:30:00 | QQQ | ETF | 28.55 | 28.59 | 28.46 | 28.54 | 897423.0 |
| 2008-12-01 09:00:00 | QQQ | ETF | 28.55 | 28.65 | 28.48 | 28.5 | 2140943.0 |
| 2008-12-01 09:30:00 | QQQ | ETF | 28.5 | 28.51 | 27.95 | 27.98 | 24704414.0 |
| 2008-12-01 10:00:00 | QQQ | ETF | 27.98 | 28.0801 | 27.85 | 27.87 | 13037409.0 |
| 2008-12-01 10:30:00 | QQQ | ETF | 27.87 | 27.93 | 27.65 | 27.65 | 7691383.0 |
| 2008-12-01 11:00:00 | QQQ | ETF | 27.65 | 27.74 | 27.56 | 27.6 | 7589535.0 |
| 2008-12-01 11:30:00 | QQQ | ETF | 27.6 | 27.79 | 27.5801 | 27.7001 | 4023798.0 |
| 2008-12-01 12:00:00 | QQQ | ETF | 27.7 | 27.74 | 27.54 | 27.58 | 4618359.0 |
| 2008-12-01 12:30:00 | QQQ | ETF | 27.59 | 27.66 | 27.44 | 27.47 | 5587333.0 |
| 2008-12-01 13:00:00 | QQQ | ETF | 27.48 | 27.64 | 27.48 | 27.58 | 3591922.0 |
| 2008-12-01 13:30:00 | QQQ | ETF | 27.585 | 27.7 | 27.42 | 27.57 | 8923253.0 |
> showing 50 of 6,635 rows — these rows as CSV