PREVIEW / etf_30min / 2009-02-11
file: by_date/etf_30min/2009/2009-02-11.parquet size: 201 KB rows: 6,750
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-11 04:00:00 | SPY | ETF | 83.34 | 83.47 | 83.32 | 83.43 | 6900.0 |
| 2009-02-11 04:30:00 | SPY | ETF | 83.55 | 83.55 | 83.32 | 83.51 | 1800.0 |
| 2009-02-11 05:00:00 | SPY | ETF | 83.36 | 83.39 | 83.36 | 83.38 | 6700.0 |
| 2009-02-11 05:30:00 | SPY | ETF | 83.57 | 83.57 | 83.57 | 83.57 | 300.0 |
| 2009-02-11 06:00:00 | SPY | ETF | 83.56 | 83.56 | 83.56 | 83.56 | 200.0 |
| 2009-02-11 06:30:00 | SPY | ETF | 83.66 | 83.66 | 83.12 | 83.12 | 10400.0 |
| 2009-02-11 07:00:00 | SPY | ETF | 83.14 | 83.25 | 82.94 | 83.17 | 380926.0 |
| 2009-02-11 07:30:00 | SPY | ETF | 83.15 | 83.23 | 82.77 | 82.88 | 754542.0 |
| 2009-02-11 08:00:00 | SPY | ETF | 83.67 | 83.67 | 82.79 | 83.36 | 2316009.0 |
| 2009-02-11 08:30:00 | SPY | ETF | 83.35 | 83.54 | 83.27 | 83.42 | 838339.0 |
| 2009-02-11 09:00:00 | SPY | ETF | 83.4 | 83.55 | 83.32 | 83.45 | 1679009.0 |
| 2009-02-11 09:30:00 | SPY | ETF | 83.45 | 83.97 | 83.26 | 83.7 | 29318087.0 |
| 2009-02-11 10:00:00 | SPY | ETF | 83.69 | 83.87 | 83.1 | 83.1 | 28309950.0 |
| 2009-02-11 10:30:00 | SPY | ETF | 83.1 | 83.69 | 82.88 | 83.57 | 28172006.0 |
| 2009-02-11 11:00:00 | SPY | ETF | 83.57 | 83.9 | 83.31 | 83.8299 | 21202256.0 |
| 2009-02-11 11:30:00 | SPY | ETF | 83.82 | 84.05 | 83.47 | 83.56 | 17350484.0 |
| 2009-02-11 12:00:00 | SPY | ETF | 83.56 | 83.72 | 83.27 | 83.5 | 10922234.0 |
| 2009-02-11 12:30:00 | SPY | ETF | 83.49 | 83.78 | 83.28 | 83.36 | 12632513.0 |
| 2009-02-11 13:00:00 | SPY | ETF | 83.37 | 83.65 | 83.15 | 83.34 | 16716959.0 |
| 2009-02-11 13:30:00 | SPY | ETF | 83.34 | 83.35 | 82.58 | 82.735 | 19816351.0 |
| 2009-02-11 14:00:00 | SPY | ETF | 82.72 | 83.61 | 82.4 | 82.91 | 22206293.0 |
| 2009-02-11 14:30:00 | SPY | ETF | 82.92 | 83.85 | 82.83 | 83.73 | 34162284.0 |
| 2009-02-11 15:00:00 | SPY | ETF | 83.73 | 84.0 | 83.48 | 83.58 | 30525172.0 |
| 2009-02-11 15:30:00 | SPY | ETF | 83.57 | 83.76 | 83.08 | 83.67 | 29152232.0 |
| 2009-02-11 16:00:00 | SPY | ETF | 83.65 | 83.77 | 82.66 | 83.55 | 7604845.0 |
| 2009-02-11 16:30:00 | SPY | ETF | 83.55 | 83.79 | 83.5249 | 83.71 | 3602795.0 |
| 2009-02-11 17:00:00 | SPY | ETF | 83.72 | 83.75 | 83.68 | 83.71 | 34677.0 |
| 2009-02-11 17:30:00 | SPY | ETF | 83.72 | 83.75 | 83.69 | 83.69 | 11125.0 |
| 2009-02-11 18:00:00 | SPY | ETF | 83.68 | 83.71 | 83.6 | 83.69 | 54323.0 |
| 2009-02-11 18:30:00 | SPY | ETF | 83.68 | 83.68 | 83.46 | 83.48 | 41179.0 |
| 2009-02-11 19:00:00 | SPY | ETF | 83.49 | 83.53 | 83.27 | 83.35 | 90694.0 |
| 2009-02-11 19:30:00 | SPY | ETF | 83.34 | 83.62 | 83.33 | 83.61 | 72292.0 |
| 2009-02-11 06:30:00 | QQQ | ETF | 30.37 | 30.37 | 30.36 | 30.36 | 1000.0 |
| 2009-02-11 07:00:00 | QQQ | ETF | 30.31 | 30.41 | 30.22 | 30.28 | 213916.0 |
| 2009-02-11 07:30:00 | QQQ | ETF | 30.28 | 30.33 | 30.13 | 30.17 | 268675.0 |
| 2009-02-11 08:00:00 | QQQ | ETF | 30.17 | 30.35 | 30.16 | 30.31 | 1549372.0 |
| 2009-02-11 08:30:00 | QQQ | ETF | 30.31 | 30.41 | 30.26 | 30.35 | 3649401.0 |
| 2009-02-11 09:00:00 | QQQ | ETF | 30.35 | 30.4 | 30.28 | 30.33 | 1360513.0 |
| 2009-02-11 09:30:00 | QQQ | ETF | 30.33 | 30.53 | 30.26 | 30.41 | 16891775.0 |
| 2009-02-11 10:00:00 | QQQ | ETF | 30.4 | 30.49 | 30.06 | 30.0601 | 18338607.0 |
| 2009-02-11 10:30:00 | QQQ | ETF | 30.07 | 30.43 | 29.9 | 30.2 | 14836972.0 |
| 2009-02-11 11:00:00 | QQQ | ETF | 30.2 | 30.36 | 30.1 | 30.33 | 6980131.0 |
| 2009-02-11 11:30:00 | QQQ | ETF | 30.32 | 30.46 | 30.18 | 30.23 | 12132598.0 |
| 2009-02-11 12:00:00 | QQQ | ETF | 30.2299 | 30.3 | 30.1 | 30.18 | 4853673.0 |
| 2009-02-11 12:30:00 | QQQ | ETF | 30.18 | 30.31 | 30.1 | 30.15 | 6768721.0 |
| 2009-02-11 13:00:00 | QQQ | ETF | 30.15 | 30.24 | 30.07 | 30.14 | 5939538.0 |
| 2009-02-11 13:30:00 | QQQ | ETF | 30.13 | 30.13 | 29.81 | 29.86 | 15430546.0 |
| 2009-02-11 14:00:00 | QQQ | ETF | 29.8595 | 29.99 | 29.73 | 29.95 | 12868398.0 |
| 2009-02-11 14:30:00 | QQQ | ETF | 29.95 | 30.36 | 29.92 | 30.29 | 17393927.0 |
| 2009-02-11 15:00:00 | QQQ | ETF | 30.28 | 30.37 | 30.0 | 30.21 | 11671909.0 |
> showing 50 of 6,750 rows — these rows as CSV