PREVIEW / etf_30min / 2017-02-24
file: by_date/etf_30min/2017/2017-02-24.parquet size: 433 KB rows: 14,854
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 |
|---|---|---|---|---|---|---|---|
| 2017-02-24 04:00:00 | SPY | ETF | 236.17 | 236.17 | 236.17 | 236.17 | 150.0 |
| 2017-02-24 04:30:00 | SPY | ETF | 236.15 | 236.3 | 236.15 | 236.3 | 571.0 |
| 2017-02-24 05:00:00 | SPY | ETF | 236.22 | 236.22 | 236.19 | 236.19 | 11154.0 |
| 2017-02-24 05:30:00 | SPY | ETF | 236.07 | 236.07 | 235.82 | 235.98 | 13214.0 |
| 2017-02-24 06:00:00 | SPY | ETF | 235.95 | 235.95 | 235.59 | 235.66 | 57985.0 |
| 2017-02-24 06:30:00 | SPY | ETF | 235.65 | 235.73 | 235.32 | 235.35 | 522720.0 |
| 2017-02-24 07:00:00 | SPY | ETF | 235.4 | 235.63 | 235.37 | 235.54 | 193222.0 |
| 2017-02-24 07:30:00 | SPY | ETF | 235.53 | 235.61 | 235.35 | 235.35 | 185725.0 |
| 2017-02-24 08:00:00 | SPY | ETF | 235.52 | 235.6 | 235.31 | 235.44 | 523619.0 |
| 2017-02-24 08:30:00 | SPY | ETF | 235.45 | 235.54 | 235.35 | 235.4 | 279750.0 |
| 2017-02-24 09:00:00 | SPY | ETF | 235.41 | 235.52 | 235.21 | 235.45 | 1076504.0 |
| 2017-02-24 09:30:00 | SPY | ETF | 235.46 | 235.96 | 235.41 | 235.94 | 8232609.0 |
| 2017-02-24 10:00:00 | SPY | ETF | 235.94 | 236.18 | 235.61 | 235.73 | 7303964.0 |
| 2017-02-24 10:30:00 | SPY | ETF | 235.72 | 236.03 | 235.64 | 236.01 | 4146846.0 |
| 2017-02-24 11:00:00 | SPY | ETF | 236.0 | 236.24 | 235.95 | 236.08 | 3419046.0 |
| 2017-02-24 11:30:00 | SPY | ETF | 236.07 | 236.1 | 235.805 | 235.835 | 2960344.0 |
| 2017-02-24 12:00:00 | SPY | ETF | 235.83 | 236.19 | 235.81 | 236.16 | 2912002.0 |
| 2017-02-24 12:30:00 | SPY | ETF | 236.15 | 236.22 | 236.04 | 236.12 | 3317325.0 |
| 2017-02-24 13:00:00 | SPY | ETF | 236.115 | 236.15 | 235.86 | 235.88 | 2541357.0 |
| 2017-02-24 13:30:00 | SPY | ETF | 235.88 | 236.08 | 235.835 | 236.075 | 2525759.0 |
| 2017-02-24 14:00:00 | SPY | ETF | 236.08 | 236.1 | 235.95 | 236.04 | 1741182.0 |
| 2017-02-24 14:30:00 | SPY | ETF | 236.045 | 236.14 | 235.96 | 235.98 | 2938335.0 |
| 2017-02-24 15:00:00 | SPY | ETF | 235.98 | 236.27 | 235.9 | 236.25 | 4609857.0 |
| 2017-02-24 15:30:00 | SPY | ETF | 236.25 | 236.7932 | 236.23 | 236.78 | 17005999.0 |
| 2017-02-24 16:00:00 | SPY | ETF | 236.79 | 236.8399 | 236.44 | 236.74 | 13720529.0 |
| 2017-02-24 16:30:00 | SPY | ETF | 236.74 | 236.76 | 236.63 | 236.68 | 417915.0 |
| 2017-02-24 17:00:00 | SPY | ETF | 236.67 | 236.74 | 236.65 | 236.69 | 76577.0 |
| 2017-02-24 17:30:00 | SPY | ETF | 236.68 | 236.7 | 236.67 | 236.68 | 8108.0 |
| 2017-02-24 18:00:00 | SPY | ETF | 236.69 | 236.69 | 236.66 | 236.69 | 29768.0 |
| 2017-02-24 18:30:00 | SPY | ETF | 236.69 | 236.71 | 236.69 | 236.71 | 2611.0 |
| 2017-02-24 19:00:00 | SPY | ETF | 236.72 | 236.74 | 236.71 | 236.73 | 6051.0 |
| 2017-02-24 19:30:00 | SPY | ETF | 236.73 | 236.74 | 236.69 | 236.74 | 29447.0 |
| 2017-02-24 04:00:00 | QQQ | ETF | 129.73 | 129.73 | 129.73 | 129.73 | 1000.0 |
| 2017-02-24 04:30:00 | QQQ | ETF | 129.74 | 129.8 | 129.74 | 129.8 | 1097.0 |
| 2017-02-24 05:00:00 | QQQ | ETF | 129.72 | 129.72 | 129.71 | 129.71 | 1000.0 |
| 2017-02-24 05:30:00 | QQQ | ETF | 129.64 | 129.64 | 129.55 | 129.59 | 10848.0 |
| 2017-02-24 06:00:00 | QQQ | ETF | 129.58 | 129.58 | 129.36 | 129.41 | 23629.0 |
| 2017-02-24 06:30:00 | QQQ | ETF | 129.41 | 129.43 | 129.24 | 129.27 | 42661.0 |
| 2017-02-24 07:00:00 | QQQ | ETF | 129.26 | 129.41 | 129.25 | 129.35 | 31657.0 |
| 2017-02-24 07:30:00 | QQQ | ETF | 129.34 | 129.41 | 129.29 | 129.29 | 45805.0 |
| 2017-02-24 08:00:00 | QQQ | ETF | 129.37 | 129.37 | 129.22 | 129.26 | 73599.0 |
| 2017-02-24 08:30:00 | QQQ | ETF | 129.27 | 129.31 | 129.21 | 129.25 | 115928.0 |
| 2017-02-24 09:00:00 | QQQ | ETF | 129.3 | 129.49 | 129.22 | 129.49 | 383398.0 |
| 2017-02-24 09:30:00 | QQQ | ETF | 129.47 | 129.74 | 129.38 | 129.73 | 4077473.0 |
| 2017-02-24 10:00:00 | QQQ | ETF | 129.73 | 129.85 | 129.43 | 129.54 | 2312106.0 |
| 2017-02-24 10:30:00 | QQQ | ETF | 129.5418 | 129.73 | 129.53 | 129.72 | 1080678.0 |
| 2017-02-24 11:00:00 | QQQ | ETF | 129.71 | 129.87 | 129.69 | 129.82 | 1108793.0 |
| 2017-02-24 11:30:00 | QQQ | ETF | 129.82 | 129.82 | 129.6 | 129.62 | 564393.0 |
| 2017-02-24 12:00:00 | QQQ | ETF | 129.61 | 129.82 | 129.6 | 129.79 | 462207.0 |
| 2017-02-24 12:30:00 | QQQ | ETF | 129.78 | 129.86 | 129.75 | 129.82 | 411993.0 |
> showing 50 of 14,854 rows — these rows as CSV