PREVIEW / etf_30min / 2010-12-02
file: by_date/etf_30min/2010/2010-12-02.parquet size: 279 KB rows: 9,238
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-02 04:00:00 | SPY | ETF | 121.25 | 121.45 | 121.25 | 121.45 | 5300.0 |
| 2010-12-02 04:30:00 | SPY | ETF | 121.49 | 121.6 | 121.48 | 121.56 | 700.0 |
| 2010-12-02 05:00:00 | SPY | ETF | 121.43 | 121.43 | 121.4 | 121.41 | 800.0 |
| 2010-12-02 05:30:00 | SPY | ETF | 121.35 | 121.41 | 121.33 | 121.35 | 10300.0 |
| 2010-12-02 06:00:00 | SPY | ETF | 121.32 | 121.38 | 121.21 | 121.22 | 25900.0 |
| 2010-12-02 06:30:00 | SPY | ETF | 121.29 | 121.37 | 121.29 | 121.37 | 11800.0 |
| 2010-12-02 07:00:00 | SPY | ETF | 121.37 | 121.5 | 121.33 | 121.46 | 482800.0 |
| 2010-12-02 07:30:00 | SPY | ETF | 121.42 | 121.58 | 121.39 | 121.49 | 202456.0 |
| 2010-12-02 08:00:00 | SPY | ETF | 121.5 | 121.57 | 120.8 | 121.49 | 782077.0 |
| 2010-12-02 08:30:00 | SPY | ETF | 121.48 | 121.48 | 120.83 | 120.87 | 6104964.0 |
| 2010-12-02 09:00:00 | SPY | ETF | 120.87 | 121.26 | 120.7 | 121.19 | 3587759.0 |
| 2010-12-02 09:30:00 | SPY | ETF | 121.2 | 121.79 | 121.13 | 121.71 | 22010045.0 |
| 2010-12-02 10:00:00 | SPY | ETF | 121.78 | 122.12 | 121.695 | 122.02 | 19891207.0 |
| 2010-12-02 10:30:00 | SPY | ETF | 122.01 | 122.17 | 121.95 | 122.143 | 11523847.0 |
| 2010-12-02 11:00:00 | SPY | ETF | 122.15 | 122.39 | 122.05 | 122.35 | 13014807.0 |
| 2010-12-02 11:30:00 | SPY | ETF | 122.35 | 122.4 | 122.23 | 122.26 | 8598111.0 |
| 2010-12-02 12:00:00 | SPY | ETF | 122.26 | 122.35 | 122.18 | 122.21 | 5351034.0 |
| 2010-12-02 12:30:00 | SPY | ETF | 122.21 | 122.43 | 122.2 | 122.26 | 7691470.0 |
| 2010-12-02 13:00:00 | SPY | ETF | 122.26 | 122.33 | 122.17 | 122.29 | 9829507.0 |
| 2010-12-02 13:30:00 | SPY | ETF | 122.3 | 122.4 | 122.23 | 122.33 | 5469864.0 |
| 2010-12-02 14:00:00 | SPY | ETF | 122.33 | 122.65 | 122.31 | 122.55 | 10101603.0 |
| 2010-12-02 14:30:00 | SPY | ETF | 122.55 | 122.58 | 122.4 | 122.4 | 9175521.0 |
| 2010-12-02 15:00:00 | SPY | ETF | 122.4 | 122.55 | 122.31 | 122.53 | 10160861.0 |
| 2010-12-02 15:30:00 | SPY | ETF | 122.53 | 122.65 | 122.5 | 122.57 | 23283114.0 |
| 2010-12-02 16:00:00 | SPY | ETF | 122.56 | 122.8 | 121.425 | 122.75 | 13137974.0 |
| 2010-12-02 16:30:00 | SPY | ETF | 122.76 | 122.79 | 122.69 | 122.73 | 3324639.0 |
| 2010-12-02 17:00:00 | SPY | ETF | 122.73 | 122.84 | 122.65 | 122.84 | 1088064.0 |
| 2010-12-02 17:30:00 | SPY | ETF | 122.84 | 122.85 | 122.78 | 122.81 | 1042694.0 |
| 2010-12-02 18:00:00 | SPY | ETF | 122.79 | 122.79 | 122.7 | 122.77 | 87687.0 |
| 2010-12-02 18:30:00 | SPY | ETF | 122.73 | 122.75 | 122.7 | 122.7 | 13550.0 |
| 2010-12-02 19:00:00 | SPY | ETF | 122.69 | 122.71 | 122.63 | 122.64 | 89595.0 |
| 2010-12-02 19:30:00 | SPY | ETF | 122.64 | 122.77 | 122.61 | 122.77 | 27345.0 |
| 2010-12-02 04:00:00 | QQQ | ETF | 53.27 | 53.27 | 53.27 | 53.27 | 100.0 |
| 2010-12-02 04:30:00 | QQQ | ETF | 53.36 | 53.36 | 53.36 | 53.36 | 100.0 |
| 2010-12-02 06:00:00 | QQQ | ETF | 53.32 | 53.32 | 53.27 | 53.27 | 2925.0 |
| 2010-12-02 07:00:00 | QQQ | ETF | 53.31 | 53.41 | 53.3 | 53.4 | 24667.0 |
| 2010-12-02 07:30:00 | QQQ | ETF | 53.39 | 53.43 | 53.37 | 53.43 | 58489.0 |
| 2010-12-02 08:00:00 | QQQ | ETF | 53.4 | 53.43 | 53.35 | 53.35 | 84256.0 |
| 2010-12-02 08:30:00 | QQQ | ETF | 53.35 | 53.36 | 53.09 | 53.11 | 691536.0 |
| 2010-12-02 09:00:00 | QQQ | ETF | 53.09 | 53.3 | 53.07 | 53.26 | 1539712.0 |
| 2010-12-02 09:30:00 | QQQ | ETF | 53.27 | 53.48 | 53.21 | 53.48 | 12117569.0 |
| 2010-12-02 10:00:00 | QQQ | ETF | 53.48 | 53.61 | 53.44 | 53.49 | 7421332.0 |
| 2010-12-02 10:30:00 | QQQ | ETF | 53.49 | 53.52 | 53.37 | 53.51 | 4418481.0 |
| 2010-12-02 11:00:00 | QQQ | ETF | 53.5101 | 53.67 | 53.47 | 53.63 | 4845480.0 |
| 2010-12-02 11:30:00 | QQQ | ETF | 53.63 | 53.665 | 53.5679 | 53.6399 | 2360029.0 |
| 2010-12-02 12:00:00 | QQQ | ETF | 53.639 | 53.67 | 53.58 | 53.59 | 1400194.0 |
| 2010-12-02 12:30:00 | QQQ | ETF | 53.59 | 53.7 | 53.57 | 53.62 | 1927288.0 |
| 2010-12-02 13:00:00 | QQQ | ETF | 53.62 | 53.68 | 53.59 | 53.68 | 1691748.0 |
| 2010-12-02 13:30:00 | QQQ | ETF | 53.6747 | 53.72 | 53.64 | 53.6727 | 1514416.0 |
| 2010-12-02 14:00:00 | QQQ | ETF | 53.68 | 53.78 | 53.6599 | 53.73 | 2191765.0 |
> showing 50 of 9,238 rows — these rows as CSV