PREVIEW / etf_30min / 2008-12-12
file: by_date/etf_30min/2008/2008-12-12.parquet size: 189 KB rows: 6,640
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-12 04:00:00 | SPY | ETF | 84.42 | 85.18 | 84.42 | 85.08 | 19020.0 |
| 2008-12-12 04:30:00 | SPY | ETF | 84.94 | 85.13 | 84.93 | 85.12 | 2890.0 |
| 2008-12-12 05:00:00 | SPY | ETF | 84.71 | 84.78 | 84.64 | 84.64 | 4500.0 |
| 2008-12-12 05:30:00 | SPY | ETF | 84.65 | 84.68 | 84.33 | 84.33 | 47400.0 |
| 2008-12-12 06:00:00 | SPY | ETF | 84.16 | 84.28 | 83.85 | 84.14 | 44920.0 |
| 2008-12-12 06:30:00 | SPY | ETF | 83.95 | 84.46 | 83.95 | 84.24 | 193684.0 |
| 2008-12-12 07:00:00 | SPY | ETF | 84.24 | 85.14 | 84.22 | 84.74 | 1348843.0 |
| 2008-12-12 07:30:00 | SPY | ETF | 84.74 | 84.81 | 84.28 | 84.68 | 591668.0 |
| 2008-12-12 08:00:00 | SPY | ETF | 84.63 | 86.6 | 83.95 | 84.57 | 3966348.0 |
| 2008-12-12 08:30:00 | SPY | ETF | 84.63 | 85.06 | 84.58 | 84.79 | 4870943.0 |
| 2008-12-12 09:00:00 | SPY | ETF | 84.79 | 86.45 | 84.36 | 85.51 | 13868818.0 |
| 2008-12-12 09:30:00 | SPY | ETF | 85.55 | 87.22 | 85.2 | 86.89 | 59153683.0 |
| 2008-12-12 10:00:00 | SPY | ETF | 86.9 | 87.34 | 86.3 | 86.77 | 29992380.0 |
| 2008-12-12 10:30:00 | SPY | ETF | 86.77 | 87.6 | 86.11 | 87.53 | 29177906.0 |
| 2008-12-12 11:00:00 | SPY | ETF | 87.52 | 87.79 | 86.98 | 87.05 | 21298413.0 |
| 2008-12-12 11:30:00 | SPY | ETF | 87.05 | 87.22 | 86.4 | 86.8 | 18418896.0 |
| 2008-12-12 12:00:00 | SPY | ETF | 86.8 | 87.5 | 86.8 | 87.39 | 14669657.0 |
| 2008-12-12 12:30:00 | SPY | ETF | 87.39 | 88.54 | 87.21 | 88.34 | 20728967.0 |
| 2008-12-12 13:00:00 | SPY | ETF | 88.34 | 88.59 | 87.5 | 87.74 | 16518261.0 |
| 2008-12-12 13:30:00 | SPY | ETF | 87.74 | 87.79 | 86.87 | 87.1901 | 19742564.0 |
| 2008-12-12 14:00:00 | SPY | ETF | 87.18 | 88.05 | 86.95 | 87.29 | 24380425.0 |
| 2008-12-12 14:30:00 | SPY | ETF | 87.29 | 88.45 | 86.67 | 88.26 | 28155581.0 |
| 2008-12-12 15:00:00 | SPY | ETF | 88.26 | 88.9 | 87.57 | 88.12 | 29366267.0 |
| 2008-12-12 15:30:00 | SPY | ETF | 88.12 | 88.6 | 87.51 | 88.45 | 41467631.0 |
| 2008-12-12 16:00:00 | SPY | ETF | 88.46 | 89.2 | 86.5121 | 89.09 | 17781650.0 |
| 2008-12-12 16:30:00 | SPY | ETF | 89.08 | 89.16 | 88.48 | 89.12 | 11009700.0 |
| 2008-12-12 17:00:00 | SPY | ETF | 89.05 | 89.25 | 89.0 | 89.23 | 86912.0 |
| 2008-12-12 17:30:00 | SPY | ETF | 89.23 | 89.33 | 89.21 | 89.28 | 244013.0 |
| 2008-12-12 18:00:00 | SPY | ETF | 89.28 | 89.38 | 89.26 | 89.27 | 24135.0 |
| 2008-12-12 18:30:00 | SPY | ETF | 89.3 | 89.31 | 89.19 | 89.26 | 23047.0 |
| 2008-12-12 19:00:00 | SPY | ETF | 89.26 | 89.4 | 89.26 | 89.36 | 10333.0 |
| 2008-12-12 19:30:00 | SPY | ETF | 89.4 | 89.45 | 89.3 | 89.45 | 22626.0 |
| 2008-12-12 04:00:00 | QQQ | ETF | 28.34 | 28.36 | 28.34 | 28.36 | 376.0 |
| 2008-12-12 04:30:00 | QQQ | ETF | 28.37 | 28.46 | 28.37 | 28.39 | 300.0 |
| 2008-12-12 05:00:00 | QQQ | ETF | 28.27 | 28.27 | 28.27 | 28.27 | 400.0 |
| 2008-12-12 06:00:00 | QQQ | ETF | 28.07 | 28.14 | 28.05 | 28.14 | 1800.0 |
| 2008-12-12 06:30:00 | QQQ | ETF | 28.05 | 28.16 | 28.05 | 28.16 | 5500.0 |
| 2008-12-12 07:00:00 | QQQ | ETF | 28.11 | 28.4 | 28.05 | 28.28 | 214325.0 |
| 2008-12-12 07:30:00 | QQQ | ETF | 28.27 | 28.34 | 28.25 | 28.34 | 156901.0 |
| 2008-12-12 08:00:00 | QQQ | ETF | 28.29 | 28.42 | 28.14 | 28.37 | 1887176.0 |
| 2008-12-12 08:30:00 | QQQ | ETF | 28.39 | 28.5 | 28.36 | 28.44 | 924295.0 |
| 2008-12-12 09:00:00 | QQQ | ETF | 28.43 | 28.81 | 28.42 | 28.69 | 2850963.0 |
| 2008-12-12 09:30:00 | QQQ | ETF | 28.69 | 29.2 | 28.47 | 29.11 | 23623496.0 |
| 2008-12-12 10:00:00 | QQQ | ETF | 29.11 | 29.34 | 28.95 | 29.11 | 14886204.0 |
| 2008-12-12 10:30:00 | QQQ | ETF | 29.11 | 29.45 | 28.91 | 29.43 | 10097264.0 |
| 2008-12-12 11:00:00 | QQQ | ETF | 29.42 | 29.53 | 29.22 | 29.23 | 10774176.0 |
| 2008-12-12 11:30:00 | QQQ | ETF | 29.23 | 29.28 | 29.05 | 29.19 | 6525165.0 |
| 2008-12-12 12:00:00 | QQQ | ETF | 29.2 | 29.33 | 29.17 | 29.3 | 5251265.0 |
| 2008-12-12 12:30:00 | QQQ | ETF | 29.3 | 29.71 | 29.25 | 29.63 | 6337475.0 |
| 2008-12-12 13:00:00 | QQQ | ETF | 29.63 | 29.7 | 29.39 | 29.49 | 7331654.0 |
> showing 50 of 6,640 rows — these rows as CSV