PREVIEW / etf_30min / 2008-12-11
file: by_date/etf_30min/2008/2008-12-11.parquet size: 191 KB rows: 6,668
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-11 04:00:00 | SPY | ETF | 89.4 | 89.46 | 89.39 | 89.41 | 2100.0 |
| 2008-12-11 04:30:00 | SPY | ETF | 89.4 | 89.59 | 89.37 | 89.48 | 5900.0 |
| 2008-12-11 05:00:00 | SPY | ETF | 89.53 | 90.02 | 89.48 | 90.02 | 2500.0 |
| 2008-12-11 05:30:00 | SPY | ETF | 90.11 | 90.46 | 90.1 | 90.37 | 4100.0 |
| 2008-12-11 06:00:00 | SPY | ETF | 90.41 | 90.41 | 90.17 | 90.32 | 17996.0 |
| 2008-12-11 06:30:00 | SPY | ETF | 90.25 | 90.45 | 90.09 | 90.45 | 142416.0 |
| 2008-12-11 07:00:00 | SPY | ETF | 90.36 | 90.36 | 89.92 | 89.97 | 627936.0 |
| 2008-12-11 07:30:00 | SPY | ETF | 89.98 | 90.15 | 89.9 | 90.04 | 219109.0 |
| 2008-12-11 08:00:00 | SPY | ETF | 89.53 | 90.41 | 89.53 | 89.58 | 1979412.0 |
| 2008-12-11 08:30:00 | SPY | ETF | 89.56 | 89.7 | 89.09 | 89.6 | 2120205.0 |
| 2008-12-11 09:00:00 | SPY | ETF | 89.59 | 89.77 | 89.42 | 89.56 | 1659938.0 |
| 2008-12-11 09:30:00 | SPY | ETF | 89.54 | 90.25 | 89.04 | 90.06 | 30914223.0 |
| 2008-12-11 10:00:00 | SPY | ETF | 90.06 | 90.85 | 89.8 | 90.58 | 29949136.0 |
| 2008-12-11 10:30:00 | SPY | ETF | 90.59 | 90.9 | 90.2 | 90.36 | 18465578.0 |
| 2008-12-11 11:00:00 | SPY | ETF | 90.35 | 90.71 | 89.97 | 90.05 | 17327068.0 |
| 2008-12-11 11:30:00 | SPY | ETF | 90.04 | 90.75 | 89.93 | 90.68 | 16187076.0 |
| 2008-12-11 12:00:00 | SPY | ETF | 90.68 | 91.0 | 90.23 | 90.39 | 18327017.0 |
| 2008-12-11 12:30:00 | SPY | ETF | 90.39 | 90.91 | 90.34 | 90.81 | 12342788.0 |
| 2008-12-11 13:00:00 | SPY | ETF | 90.8 | 90.84 | 89.9 | 90.14 | 12865821.0 |
| 2008-12-11 13:30:00 | SPY | ETF | 90.15 | 90.35 | 89.72 | 89.82 | 10718775.0 |
| 2008-12-11 14:00:00 | SPY | ETF | 89.82 | 90.01 | 89.41 | 89.65 | 13519751.0 |
| 2008-12-11 14:30:00 | SPY | ETF | 89.6405 | 89.96 | 88.35 | 88.46 | 32366562.0 |
| 2008-12-11 15:00:00 | SPY | ETF | 88.47 | 89.9 | 87.68 | 88.14 | 44120199.0 |
| 2008-12-11 15:30:00 | SPY | ETF | 88.13 | 88.25 | 87.37 | 87.95 | 66751346.0 |
| 2008-12-11 16:00:00 | SPY | ETF | 87.97 | 90.4334 | 87.31 | 87.47 | 10226363.0 |
| 2008-12-11 16:30:00 | SPY | ETF | 87.47 | 87.87 | 86.75 | 86.97 | 10695946.0 |
| 2008-12-11 17:00:00 | SPY | ETF | 86.97 | 87.04 | 86.38 | 86.47 | 1580875.0 |
| 2008-12-11 17:30:00 | SPY | ETF | 86.47 | 86.55 | 86.25 | 86.43 | 1800438.0 |
| 2008-12-11 18:00:00 | SPY | ETF | 86.41 | 86.53 | 86.15 | 86.35 | 1034883.0 |
| 2008-12-11 18:30:00 | SPY | ETF | 86.34 | 86.46 | 86.01 | 86.07 | 303639.0 |
| 2008-12-11 19:00:00 | SPY | ETF | 86.04 | 86.04 | 85.71 | 85.74 | 310208.0 |
| 2008-12-11 19:30:00 | SPY | ETF | 85.71 | 85.8 | 85.59 | 85.67 | 223859.0 |
| 2008-12-11 04:00:00 | QQQ | ETF | 29.79 | 29.79 | 29.79 | 29.79 | 200.0 |
| 2008-12-11 04:30:00 | QQQ | ETF | 29.85 | 29.85 | 29.85 | 29.85 | 100.0 |
| 2008-12-11 05:00:00 | QQQ | ETF | 29.85 | 29.85 | 29.85 | 29.85 | 100.0 |
| 2008-12-11 05:30:00 | QQQ | ETF | 29.99 | 30.15 | 29.99 | 30.15 | 400.0 |
| 2008-12-11 07:00:00 | QQQ | ETF | 30.17 | 30.21 | 30.05 | 30.05 | 432465.0 |
| 2008-12-11 07:30:00 | QQQ | ETF | 30.1 | 30.11 | 29.98 | 30.03 | 158465.0 |
| 2008-12-11 08:00:00 | QQQ | ETF | 30.01 | 30.01 | 29.85 | 29.85 | 1355834.0 |
| 2008-12-11 08:30:00 | QQQ | ETF | 29.84 | 29.85 | 29.65 | 29.77 | 738085.0 |
| 2008-12-11 09:00:00 | QQQ | ETF | 29.78 | 29.83 | 29.75 | 29.8 | 682773.0 |
| 2008-12-11 09:30:00 | QQQ | ETF | 29.8 | 29.91 | 29.53 | 29.9 | 17107903.0 |
| 2008-12-11 10:00:00 | QQQ | ETF | 29.9 | 30.12 | 29.86 | 30.07 | 13275495.0 |
| 2008-12-11 10:30:00 | QQQ | ETF | 30.07 | 30.22 | 30.01 | 30.09 | 8592135.0 |
| 2008-12-11 11:00:00 | QQQ | ETF | 30.09 | 30.22 | 29.9 | 29.98 | 6885258.0 |
| 2008-12-11 11:30:00 | QQQ | ETF | 29.98 | 30.16 | 29.93 | 30.14 | 5790949.0 |
| 2008-12-11 12:00:00 | QQQ | ETF | 30.15 | 30.27 | 30.09 | 30.1101 | 6897073.0 |
| 2008-12-11 12:30:00 | QQQ | ETF | 30.11 | 30.25 | 30.08 | 30.22 | 4864540.0 |
| 2008-12-11 13:00:00 | QQQ | ETF | 30.22 | 30.23 | 29.91 | 29.98 | 5497931.0 |
| 2008-12-11 13:30:00 | QQQ | ETF | 29.99 | 30.04 | 29.79 | 29.83 | 5093761.0 |
> showing 50 of 6,668 rows — these rows as CSV