PREVIEW / etf_30min / 2008-02-13
file: by_date/etf_30min/2008/2008-02-13.parquet size: 149 KB rows: 5,327
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-02-13 05:00:00 | SPY | ETF | 135.26 | 135.26 | 135.26 | 135.26 | 5000.0 |
| 2008-02-13 05:30:00 | SPY | ETF | 135.41 | 135.41 | 135.41 | 135.41 | 800.0 |
| 2008-02-13 06:00:00 | SPY | ETF | 135.41 | 135.44 | 135.24 | 135.31 | 14800.0 |
| 2008-02-13 06:30:00 | SPY | ETF | 135.24 | 135.24 | 135.1 | 135.11 | 19000.0 |
| 2008-02-13 07:00:00 | SPY | ETF | 135.09 | 135.58 | 135.09 | 135.58 | 659800.0 |
| 2008-02-13 07:30:00 | SPY | ETF | 135.58 | 135.58 | 135.45 | 135.51 | 399900.0 |
| 2008-02-13 08:00:00 | SPY | ETF | 135.5 | 135.55 | 134.58 | 135.38 | 1651700.0 |
| 2008-02-13 08:30:00 | SPY | ETF | 135.38 | 136.27 | 134.99 | 135.9 | 8043840.0 |
| 2008-02-13 09:00:00 | SPY | ETF | 135.89 | 136.18 | 134.51 | 136.07 | 2109313.0 |
| 2008-02-13 09:30:00 | SPY | ETF | 136.06 | 136.5 | 135.67 | 135.8 | 23321243.0 |
| 2008-02-13 10:00:00 | SPY | ETF | 135.79 | 136.21 | 135.46 | 135.65 | 19163019.0 |
| 2008-02-13 10:30:00 | SPY | ETF | 135.65 | 135.69 | 135.14 | 135.54 | 17555867.0 |
| 2008-02-13 11:00:00 | SPY | ETF | 135.53 | 135.94 | 135.45 | 135.93 | 9136464.0 |
| 2008-02-13 11:30:00 | SPY | ETF | 135.92 | 136.06 | 135.62 | 135.78 | 8820828.0 |
| 2008-02-13 12:00:00 | SPY | ETF | 135.78 | 136.23 | 135.72 | 135.87 | 9965414.0 |
| 2008-02-13 12:30:00 | SPY | ETF | 135.87 | 136.05 | 135.8 | 136.02 | 3511793.0 |
| 2008-02-13 13:00:00 | SPY | ETF | 136.02 | 137.1 | 135.88 | 136.451 | 13220204.0 |
| 2008-02-13 13:30:00 | SPY | ETF | 136.44 | 136.71 | 136.36 | 136.44 | 7002247.0 |
| 2008-02-13 14:00:00 | SPY | ETF | 136.45 | 136.53 | 136.08 | 136.2 | 8511242.0 |
| 2008-02-13 14:30:00 | SPY | ETF | 136.2 | 136.64 | 136.12 | 136.53 | 8691181.0 |
| 2008-02-13 15:00:00 | SPY | ETF | 136.53 | 136.84 | 136.39 | 136.74 | 12060308.0 |
| 2008-02-13 15:30:00 | SPY | ETF | 136.74 | 137.06 | 136.64 | 136.71 | 21223416.0 |
| 2008-02-13 16:00:00 | SPY | ETF | 136.68 | 136.82 | 135.5186 | 136.42 | 2173000.0 |
| 2008-02-13 16:30:00 | SPY | ETF | 136.47 | 136.62 | 136.38 | 136.59 | 1542800.0 |
| 2008-02-13 17:00:00 | SPY | ETF | 136.53 | 136.59 | 136.37 | 136.49 | 338100.0 |
| 2008-02-13 17:30:00 | SPY | ETF | 136.5 | 136.61 | 136.45 | 136.47 | 28900.0 |
| 2008-02-13 18:00:00 | SPY | ETF | 136.54 | 136.55 | 136.48 | 136.52 | 13100.0 |
| 2008-02-13 18:30:00 | SPY | ETF | 136.5 | 136.59 | 136.43 | 136.59 | 18400.0 |
| 2008-02-13 19:00:00 | SPY | ETF | 136.64 | 136.66 | 136.59 | 136.61 | 29500.0 |
| 2008-02-13 19:30:00 | SPY | ETF | 136.61 | 136.67 | 136.61 | 136.64 | 15900.0 |
| 2008-02-13 04:30:00 | QQQ | ETF | 43.99 | 44.04 | 43.99 | 44.04 | 500.0 |
| 2008-02-13 06:00:00 | QQQ | ETF | 44.11 | 44.11 | 44.03 | 44.08 | 22200.0 |
| 2008-02-13 06:30:00 | QQQ | ETF | 43.99 | 43.99 | 43.99 | 43.99 | 3300.0 |
| 2008-02-13 07:00:00 | QQQ | ETF | 44.0 | 44.12 | 43.99 | 44.12 | 129334.0 |
| 2008-02-13 07:30:00 | QQQ | ETF | 44.11 | 44.16 | 44.11 | 44.14 | 301443.0 |
| 2008-02-13 08:00:00 | QQQ | ETF | 44.13 | 44.19 | 44.02 | 44.07 | 3538680.0 |
| 2008-02-13 08:30:00 | QQQ | ETF | 44.16 | 44.44 | 44.08 | 44.34 | 3461449.0 |
| 2008-02-13 09:00:00 | QQQ | ETF | 44.34 | 44.4 | 44.31 | 44.4 | 1253957.0 |
| 2008-02-13 09:30:00 | QQQ | ETF | 44.39 | 44.54 | 44.2 | 44.33 | 28398290.0 |
| 2008-02-13 10:00:00 | QQQ | ETF | 44.33 | 44.47 | 44.25 | 44.34 | 10858071.0 |
| 2008-02-13 10:30:00 | QQQ | ETF | 44.33 | 44.36 | 44.16 | 44.27 | 8826347.0 |
| 2008-02-13 11:00:00 | QQQ | ETF | 44.27 | 44.41 | 44.24 | 44.41 | 4748307.0 |
| 2008-02-13 11:30:00 | QQQ | ETF | 44.4 | 44.44 | 44.28 | 44.35 | 8394168.0 |
| 2008-02-13 12:00:00 | QQQ | ETF | 44.35 | 44.48 | 44.33 | 44.38 | 7433391.0 |
| 2008-02-13 12:30:00 | QQQ | ETF | 44.38 | 44.44 | 44.35 | 44.43 | 1639152.0 |
| 2008-02-13 13:00:00 | QQQ | ETF | 44.42 | 44.66 | 44.34 | 44.585 | 11553390.0 |
| 2008-02-13 13:30:00 | QQQ | ETF | 44.58 | 44.88 | 44.56 | 44.74 | 12162819.0 |
| 2008-02-13 14:00:00 | QQQ | ETF | 44.74 | 44.76 | 44.61 | 44.65 | 7940438.0 |
| 2008-02-13 14:30:00 | QQQ | ETF | 44.65 | 44.8 | 44.62 | 44.77 | 4991050.0 |
| 2008-02-13 15:00:00 | QQQ | ETF | 44.775 | 44.85 | 44.7 | 44.81 | 10653362.0 |
> showing 50 of 5,327 rows — these rows as CSV