PREVIEW / etf_30min / 2017-05-09
file: by_date/etf_30min/2017/2017-05-09.parquet size: 436 KB rows: 14,878
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-05-09 04:00:00 | SPY | ETF | 239.7 | 239.7 | 239.7 | 239.7 | 290.0 |
| 2017-05-09 05:00:00 | SPY | ETF | 239.75 | 239.78 | 239.74 | 239.78 | 3700.0 |
| 2017-05-09 05:30:00 | SPY | ETF | 239.8 | 239.84 | 239.76 | 239.84 | 4500.0 |
| 2017-05-09 06:00:00 | SPY | ETF | 239.84 | 239.88 | 239.71 | 239.71 | 15000.0 |
| 2017-05-09 06:30:00 | SPY | ETF | 239.73 | 239.93 | 239.73 | 239.93 | 24900.0 |
| 2017-05-09 07:00:00 | SPY | ETF | 239.88 | 239.95 | 239.87 | 239.92 | 27975.0 |
| 2017-05-09 07:30:00 | SPY | ETF | 239.95 | 239.96 | 239.84 | 239.92 | 20468.0 |
| 2017-05-09 08:00:00 | SPY | ETF | 239.89 | 240.03 | 239.87 | 240.03 | 127912.0 |
| 2017-05-09 08:30:00 | SPY | ETF | 240.02 | 240.08 | 239.94 | 239.96 | 56878.0 |
| 2017-05-09 09:00:00 | SPY | ETF | 239.94 | 239.99 | 239.86 | 239.94 | 179137.0 |
| 2017-05-09 09:30:00 | SPY | ETF | 239.96 | 240.06 | 239.8 | 239.99 | 4683723.0 |
| 2017-05-09 10:00:00 | SPY | ETF | 239.99 | 240.19 | 239.99 | 240.11 | 4589646.0 |
| 2017-05-09 10:30:00 | SPY | ETF | 240.1 | 240.12 | 239.89 | 239.94 | 3070127.0 |
| 2017-05-09 11:00:00 | SPY | ETF | 239.95 | 240.02 | 239.69 | 239.85 | 2566350.0 |
| 2017-05-09 11:30:00 | SPY | ETF | 239.835 | 239.95 | 239.76 | 239.95 | 1849869.0 |
| 2017-05-09 12:00:00 | SPY | ETF | 239.95 | 239.995 | 239.76 | 239.7942 | 3292940.0 |
| 2017-05-09 12:30:00 | SPY | ETF | 239.795 | 239.8 | 239.61 | 239.65 | 2278388.0 |
| 2017-05-09 13:00:00 | SPY | ETF | 239.65 | 239.75 | 239.4 | 239.42 | 2447212.0 |
| 2017-05-09 13:30:00 | SPY | ETF | 239.42 | 239.69 | 239.4 | 239.6862 | 1907485.0 |
| 2017-05-09 14:00:00 | SPY | ETF | 239.68 | 239.72 | 239.49 | 239.5 | 1650709.0 |
| 2017-05-09 14:30:00 | SPY | ETF | 239.505 | 239.665 | 239.48 | 239.6 | 3165268.0 |
| 2017-05-09 15:00:00 | SPY | ETF | 239.61 | 239.74 | 239.58 | 239.65 | 3114083.0 |
| 2017-05-09 15:30:00 | SPY | ETF | 239.64 | 239.65 | 239.04 | 239.46 | 11530759.0 |
| 2017-05-09 16:00:00 | SPY | ETF | 239.44 | 239.5049 | 239.35 | 239.43 | 3539654.0 |
| 2017-05-09 16:30:00 | SPY | ETF | 239.43 | 239.51 | 239.43 | 239.45 | 302818.0 |
| 2017-05-09 17:00:00 | SPY | ETF | 239.45 | 239.47 | 239.44 | 239.45 | 163921.0 |
| 2017-05-09 17:30:00 | SPY | ETF | 239.47 | 239.47 | 239.39 | 239.4 | 34866.0 |
| 2017-05-09 18:00:00 | SPY | ETF | 239.38 | 239.51 | 239.26 | 239.27 | 57740.0 |
| 2017-05-09 18:30:00 | SPY | ETF | 239.27 | 239.28 | 239.14 | 239.15 | 87961.0 |
| 2017-05-09 19:00:00 | SPY | ETF | 239.16 | 239.16 | 239.03 | 239.08 | 38286.0 |
| 2017-05-09 19:30:00 | SPY | ETF | 239.08 | 239.12 | 239.0 | 239.01 | 18116.0 |
| 2017-05-09 04:00:00 | QQQ | ETF | 137.91 | 137.91 | 137.85 | 137.85 | 590.0 |
| 2017-05-09 05:00:00 | QQQ | ETF | 137.88 | 137.88 | 137.88 | 137.88 | 600.0 |
| 2017-05-09 06:00:00 | QQQ | ETF | 137.91 | 137.91 | 137.9 | 137.9 | 600.0 |
| 2017-05-09 07:00:00 | QQQ | ETF | 137.9 | 137.95 | 137.9 | 137.94 | 3585.0 |
| 2017-05-09 07:30:00 | QQQ | ETF | 137.95 | 137.95 | 137.92 | 137.95 | 13600.0 |
| 2017-05-09 08:00:00 | QQQ | ETF | 137.95 | 138.04 | 137.95 | 138.03 | 61130.0 |
| 2017-05-09 08:30:00 | QQQ | ETF | 138.03 | 138.05 | 138.0 | 138.0 | 18431.0 |
| 2017-05-09 09:00:00 | QQQ | ETF | 138.01 | 138.05 | 138.0 | 138.02 | 55810.0 |
| 2017-05-09 09:30:00 | QQQ | ETF | 138.05 | 138.39 | 137.93 | 138.38 | 2918711.0 |
| 2017-05-09 10:00:00 | QQQ | ETF | 138.39 | 138.628 | 138.38 | 138.52 | 2341712.0 |
| 2017-05-09 10:30:00 | QQQ | ETF | 138.52 | 138.58 | 138.36 | 138.38 | 2043643.0 |
| 2017-05-09 11:00:00 | QQQ | ETF | 138.39 | 138.48 | 138.25 | 138.395 | 2620156.0 |
| 2017-05-09 11:30:00 | QQQ | ETF | 138.3999 | 138.41 | 138.2599 | 138.31 | 550562.0 |
| 2017-05-09 12:00:00 | QQQ | ETF | 138.31 | 138.44 | 138.3 | 138.39 | 862996.0 |
| 2017-05-09 12:30:00 | QQQ | ETF | 138.3847 | 138.41 | 138.3 | 138.321 | 819642.0 |
| 2017-05-09 13:00:00 | QQQ | ETF | 138.33 | 138.39 | 138.13 | 138.16 | 912204.0 |
| 2017-05-09 13:30:00 | QQQ | ETF | 138.16 | 138.28 | 138.13 | 138.26 | 1608072.0 |
| 2017-05-09 14:00:00 | QQQ | ETF | 138.26 | 138.3 | 138.19 | 138.22 | 814277.0 |
| 2017-05-09 14:30:00 | QQQ | ETF | 138.225 | 138.3 | 138.21 | 138.25 | 465583.0 |
> showing 50 of 14,878 rows — these rows as CSV