PREVIEW / etf_30min / 2008-12-02
file: by_date/etf_30min/2008/2008-12-02.parquet size: 182 KB rows: 6,462
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-02 04:00:00 | SPY | ETF | 82.69 | 82.79 | 82.66 | 82.66 | 3700.0 |
| 2008-12-02 04:30:00 | SPY | ETF | 82.67 | 83.0 | 82.54 | 83.0 | 2300.0 |
| 2008-12-02 05:00:00 | SPY | ETF | 83.0 | 83.59 | 83.0 | 83.59 | 8440.0 |
| 2008-12-02 05:30:00 | SPY | ETF | 83.49 | 83.49 | 83.3 | 83.31 | 1400.0 |
| 2008-12-02 06:00:00 | SPY | ETF | 83.29 | 83.78 | 83.29 | 83.55 | 18790.0 |
| 2008-12-02 06:30:00 | SPY | ETF | 83.62 | 84.01 | 83.5 | 84.01 | 176757.0 |
| 2008-12-02 07:00:00 | SPY | ETF | 84.0 | 84.12 | 83.73 | 83.91 | 371129.0 |
| 2008-12-02 07:30:00 | SPY | ETF | 83.93 | 83.95 | 83.32 | 83.61 | 648050.0 |
| 2008-12-02 08:00:00 | SPY | ETF | 83.92 | 84.02 | 82.35 | 83.53 | 4555118.0 |
| 2008-12-02 08:30:00 | SPY | ETF | 83.53 | 83.91 | 83.49 | 83.72 | 1519398.0 |
| 2008-12-02 09:00:00 | SPY | ETF | 83.73 | 83.75 | 83.31 | 83.47 | 1458762.0 |
| 2008-12-02 09:30:00 | SPY | ETF | 83.47 | 83.55 | 82.23 | 82.6 | 39322537.0 |
| 2008-12-02 10:00:00 | SPY | ETF | 82.61 | 84.26 | 82.3 | 83.92 | 50340107.0 |
| 2008-12-02 10:30:00 | SPY | ETF | 83.91 | 84.59 | 83.8775 | 84.13 | 31479362.0 |
| 2008-12-02 11:00:00 | SPY | ETF | 84.13 | 84.54 | 83.67 | 84.31 | 19569238.0 |
| 2008-12-02 11:30:00 | SPY | ETF | 84.32 | 84.83 | 83.87 | 84.64 | 25105113.0 |
| 2008-12-02 12:00:00 | SPY | ETF | 84.6325 | 85.21 | 84.55 | 85.11 | 19563449.0 |
| 2008-12-02 12:30:00 | SPY | ETF | 85.11 | 85.24 | 84.6 | 84.848 | 15217472.0 |
| 2008-12-02 13:00:00 | SPY | ETF | 84.85 | 85.1 | 84.61 | 84.79 | 10790277.0 |
| 2008-12-02 13:30:00 | SPY | ETF | 84.78 | 84.81 | 83.64 | 83.75 | 27421349.0 |
| 2008-12-02 14:00:00 | SPY | ETF | 83.75 | 83.92 | 82.29 | 82.74 | 41209417.0 |
| 2008-12-02 14:30:00 | SPY | ETF | 82.74 | 83.77 | 82.52 | 83.7 | 34831682.0 |
| 2008-12-02 15:00:00 | SPY | ETF | 83.7 | 84.88 | 82.77 | 84.61 | 50960869.0 |
| 2008-12-02 15:30:00 | SPY | ETF | 84.61 | 85.49 | 83.64 | 85.4 | 80068712.0 |
| 2008-12-02 16:00:00 | SPY | ETF | 85.31 | 85.5 | 82.038 | 85.28 | 8496154.0 |
| 2008-12-02 16:30:00 | SPY | ETF | 85.32 | 85.61 | 85.25 | 85.34 | 3413611.0 |
| 2008-12-02 17:00:00 | SPY | ETF | 85.32 | 85.38 | 85.2 | 85.21 | 111410.0 |
| 2008-12-02 17:30:00 | SPY | ETF | 85.3 | 85.3 | 85.22 | 85.24 | 22717.0 |
| 2008-12-02 18:00:00 | SPY | ETF | 85.2 | 85.34 | 85.0 | 85.1 | 750900.0 |
| 2008-12-02 18:30:00 | SPY | ETF | 85.09 | 85.12 | 84.99 | 84.99 | 30338.0 |
| 2008-12-02 19:00:00 | SPY | ETF | 84.99 | 85.13 | 84.96 | 85.04 | 20293.0 |
| 2008-12-02 19:30:00 | SPY | ETF | 85.02 | 85.05 | 84.93 | 85.0 | 119812.0 |
| 2008-12-02 05:00:00 | QQQ | ETF | 27.28 | 27.41 | 27.28 | 27.41 | 1050.0 |
| 2008-12-02 06:00:00 | QQQ | ETF | 27.39 | 27.48 | 27.39 | 27.47 | 3540.0 |
| 2008-12-02 06:30:00 | QQQ | ETF | 27.43 | 27.65 | 27.43 | 27.63 | 11400.0 |
| 2008-12-02 07:00:00 | QQQ | ETF | 27.66 | 27.67 | 27.48 | 27.54 | 233867.0 |
| 2008-12-02 07:30:00 | QQQ | ETF | 27.55 | 27.55 | 27.39 | 27.46 | 314322.0 |
| 2008-12-02 08:00:00 | QQQ | ETF | 27.45 | 27.51 | 27.25 | 27.35 | 2570189.0 |
| 2008-12-02 08:30:00 | QQQ | ETF | 27.35 | 27.44 | 27.33 | 27.36 | 789121.0 |
| 2008-12-02 09:00:00 | QQQ | ETF | 27.36 | 27.36 | 27.24 | 27.27 | 419818.0 |
| 2008-12-02 09:30:00 | QQQ | ETF | 27.28 | 27.3505 | 26.8404 | 27.05 | 19598385.0 |
| 2008-12-02 10:00:00 | QQQ | ETF | 27.0499 | 27.51 | 27.0 | 27.39 | 16853572.0 |
| 2008-12-02 10:30:00 | QQQ | ETF | 27.3885 | 27.68 | 27.38 | 27.61 | 14753508.0 |
| 2008-12-02 11:00:00 | QQQ | ETF | 27.61 | 27.7 | 27.45 | 27.63 | 8618196.0 |
| 2008-12-02 11:30:00 | QQQ | ETF | 27.63 | 27.77 | 27.52 | 27.73 | 9655373.0 |
| 2008-12-02 12:00:00 | QQQ | ETF | 27.73 | 27.89 | 27.68 | 27.85 | 6840607.0 |
| 2008-12-02 12:30:00 | QQQ | ETF | 27.86 | 27.88 | 27.65 | 27.77 | 5860590.0 |
| 2008-12-02 13:00:00 | QQQ | ETF | 27.76 | 27.85 | 27.69 | 27.73 | 4319258.0 |
| 2008-12-02 13:30:00 | QQQ | ETF | 27.72 | 27.73 | 27.41 | 27.44 | 10862647.0 |
| 2008-12-02 14:00:00 | QQQ | ETF | 27.44 | 27.49 | 26.99 | 27.1 | 15284359.0 |
> showing 50 of 6,462 rows — these rows as CSV