PREVIEW / etf_30min / 2008-12-22
file: by_date/etf_30min/2008/2008-12-22.parquet size: 207 KB rows: 6,689
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-22 04:00:00 | SPY | ETF | 88.15 | 88.15 | 88.1 | 88.1 | 3387.0 |
| 2008-12-22 04:30:00 | SPY | ETF | 88.07 | 88.13 | 88.07 | 88.13 | 600.0 |
| 2008-12-22 05:00:00 | SPY | ETF | 87.81 | 87.81 | 87.81 | 87.81 | 300.0 |
| 2008-12-22 05:30:00 | SPY | ETF | 87.95 | 88.05 | 87.95 | 88.04 | 460.0 |
| 2008-12-22 06:00:00 | SPY | ETF | 88.06 | 88.29 | 88.06 | 88.29 | 5500.0 |
| 2008-12-22 06:30:00 | SPY | ETF | 88.41 | 88.88 | 88.41 | 88.88 | 25050.0 |
| 2008-12-22 07:00:00 | SPY | ETF | 88.8 | 88.8 | 88.54 | 88.63 | 48227.0 |
| 2008-12-22 07:30:00 | SPY | ETF | 88.63 | 88.88 | 88.63 | 88.7 | 222263.0 |
| 2008-12-22 08:00:00 | SPY | ETF | 88.69 | 88.99 | 88.59 | 88.9 | 774692.0 |
| 2008-12-22 08:30:00 | SPY | ETF | 88.91 | 88.93 | 88.49 | 88.55 | 422703.0 |
| 2008-12-22 09:00:00 | SPY | ETF | 88.54 | 89.15 | 88.42 | 88.5 | 1556019.0 |
| 2008-12-22 09:30:00 | SPY | ETF | 88.58 | 88.67 | 87.78 | 88.02 | 18294215.0 |
| 2008-12-22 10:00:00 | SPY | ETF | 88.02 | 88.5 | 87.51 | 87.74 | 13029810.0 |
| 2008-12-22 10:30:00 | SPY | ETF | 87.73 | 88.5 | 87.64 | 87.95 | 9253794.0 |
| 2008-12-22 11:00:00 | SPY | ETF | 87.95 | 87.95 | 87.35 | 87.4001 | 9109206.0 |
| 2008-12-22 11:30:00 | SPY | ETF | 87.4 | 87.42 | 86.91 | 87.3293 | 14360309.0 |
| 2008-12-22 12:00:00 | SPY | ETF | 87.32 | 87.41 | 87.01 | 87.1499 | 7801931.0 |
| 2008-12-22 12:30:00 | SPY | ETF | 87.14 | 87.52 | 87.03 | 87.36 | 8519955.0 |
| 2008-12-22 13:00:00 | SPY | ETF | 87.37 | 87.58 | 87.2 | 87.4 | 9620951.0 |
| 2008-12-22 13:30:00 | SPY | ETF | 87.405 | 87.41 | 86.8 | 86.95 | 10179988.0 |
| 2008-12-22 14:00:00 | SPY | ETF | 86.95 | 87.12 | 86.11 | 86.29 | 20013718.0 |
| 2008-12-22 14:30:00 | SPY | ETF | 86.3 | 86.67 | 86.02 | 86.08 | 19127640.0 |
| 2008-12-22 15:00:00 | SPY | ETF | 86.08 | 87.0856 | 85.49 | 85.64 | 30123573.0 |
| 2008-12-22 15:30:00 | SPY | ETF | 85.63 | 87.09 | 85.61 | 86.95 | 43775746.0 |
| 2008-12-22 16:00:00 | SPY | ETF | 86.81 | 88.6041 | 85.64 | 87.35 | 11831200.0 |
| 2008-12-22 16:30:00 | SPY | ETF | 87.35 | 87.4 | 87.06 | 87.32 | 1996129.0 |
| 2008-12-22 17:00:00 | SPY | ETF | 87.32 | 87.36 | 87.14 | 87.17 | 208120.0 |
| 2008-12-22 17:30:00 | SPY | ETF | 87.19 | 87.27 | 87.17 | 87.25 | 114503.0 |
| 2008-12-22 18:00:00 | SPY | ETF | 87.17 | 87.27 | 87.04 | 87.16 | 234751.0 |
| 2008-12-22 18:30:00 | SPY | ETF | 87.15 | 87.25 | 87.11 | 87.22 | 55242.0 |
| 2008-12-22 19:00:00 | SPY | ETF | 87.22 | 87.4 | 87.22 | 87.4 | 30008.0 |
| 2008-12-22 19:30:00 | SPY | ETF | 87.39 | 87.44 | 87.35 | 87.38 | 67838.0 |
| 2008-12-22 05:00:00 | QQQ | ETF | 29.6 | 29.64 | 29.58 | 29.58 | 300.0 |
| 2008-12-22 05:30:00 | QQQ | ETF | 29.67 | 29.67 | 29.67 | 29.67 | 200.0 |
| 2008-12-22 06:00:00 | QQQ | ETF | 29.74 | 29.78 | 29.74 | 29.78 | 200.0 |
| 2008-12-22 06:30:00 | QQQ | ETF | 29.81 | 29.9 | 29.78 | 29.9 | 2900.0 |
| 2008-12-22 07:00:00 | QQQ | ETF | 29.91 | 29.92 | 29.86 | 29.87 | 23917.0 |
| 2008-12-22 07:30:00 | QQQ | ETF | 29.85 | 29.94 | 29.85 | 29.9 | 23447.0 |
| 2008-12-22 08:00:00 | QQQ | ETF | 29.9 | 29.93 | 29.82 | 29.92 | 399111.0 |
| 2008-12-22 08:30:00 | QQQ | ETF | 29.93 | 30.0 | 29.79 | 29.82 | 313495.0 |
| 2008-12-22 09:00:00 | QQQ | ETF | 29.81 | 29.93 | 29.76 | 29.85 | 476434.0 |
| 2008-12-22 09:30:00 | QQQ | ETF | 29.85 | 29.92 | 29.44 | 29.53 | 10666099.0 |
| 2008-12-22 10:00:00 | QQQ | ETF | 29.52 | 29.54 | 29.36 | 29.39 | 5245711.0 |
| 2008-12-22 10:30:00 | QQQ | ETF | 29.39 | 29.57 | 29.37 | 29.53 | 4540692.0 |
| 2008-12-22 11:00:00 | QQQ | ETF | 29.53 | 29.54 | 29.37 | 29.4 | 3281355.0 |
| 2008-12-22 11:30:00 | QQQ | ETF | 29.4 | 29.41 | 29.16 | 29.2901 | 6574657.0 |
| 2008-12-22 12:00:00 | QQQ | ETF | 29.29 | 29.3 | 29.18 | 29.21 | 2633879.0 |
| 2008-12-22 12:30:00 | QQQ | ETF | 29.2099 | 29.29 | 29.16 | 29.26 | 3168177.0 |
| 2008-12-22 13:00:00 | QQQ | ETF | 29.25 | 29.32 | 29.21 | 29.262 | 3697740.0 |
| 2008-12-22 13:30:00 | QQQ | ETF | 29.2695 | 29.27 | 29.05 | 29.0999 | 3988084.0 |
> showing 50 of 6,689 rows — these rows as CSV