PREVIEW / etf_30min / 2015-11-30
file: by_date/etf_30min/2015/2015-11-30.parquet size: 377 KB rows: 12,903
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 |
|---|---|---|---|---|---|---|---|
| 2015-11-30 04:00:00 | SPY | ETF | 209.42 | 209.88 | 209.42 | 209.88 | 7401.0 |
| 2015-11-30 04:30:00 | SPY | ETF | 209.81 | 209.81 | 209.57 | 209.59 | 2800.0 |
| 2015-11-30 05:00:00 | SPY | ETF | 209.62 | 209.62 | 209.45 | 209.52 | 4941.0 |
| 2015-11-30 05:30:00 | SPY | ETF | 209.57 | 209.57 | 209.57 | 209.57 | 200.0 |
| 2015-11-30 06:00:00 | SPY | ETF | 209.62 | 210.06 | 209.62 | 209.99 | 11665.0 |
| 2015-11-30 06:30:00 | SPY | ETF | 210.02 | 210.02 | 209.77 | 209.77 | 31135.0 |
| 2015-11-30 07:00:00 | SPY | ETF | 209.78 | 210.08 | 209.75 | 210.07 | 84233.0 |
| 2015-11-30 07:30:00 | SPY | ETF | 210.11 | 210.19 | 209.94 | 210.13 | 111551.0 |
| 2015-11-30 08:00:00 | SPY | ETF | 210.12 | 210.18 | 209.29 | 210.11 | 237991.0 |
| 2015-11-30 08:30:00 | SPY | ETF | 210.13 | 210.17 | 209.97 | 210.09 | 380223.0 |
| 2015-11-30 09:00:00 | SPY | ETF | 210.1 | 210.12 | 209.74 | 209.74 | 372494.0 |
| 2015-11-30 09:30:00 | SPY | ETF | 209.75 | 209.89 | 209.14 | 209.1733 | 9260210.0 |
| 2015-11-30 10:00:00 | SPY | ETF | 209.17 | 209.35 | 209.02 | 209.295 | 7601712.0 |
| 2015-11-30 10:30:00 | SPY | ETF | 209.295 | 209.51 | 209.16 | 209.2249 | 4783586.0 |
| 2015-11-30 11:00:00 | SPY | ETF | 209.22 | 209.49 | 209.0 | 209.01 | 4648978.0 |
| 2015-11-30 11:30:00 | SPY | ETF | 209.015 | 209.08 | 208.72 | 208.84 | 4840483.0 |
| 2015-11-30 12:00:00 | SPY | ETF | 208.84 | 209.12 | 208.75 | 209.1 | 3870939.0 |
| 2015-11-30 12:30:00 | SPY | ETF | 209.1 | 209.12 | 208.9 | 208.935 | 3197039.0 |
| 2015-11-30 13:00:00 | SPY | ETF | 208.93 | 209.24 | 208.83 | 209.22 | 4187885.0 |
| 2015-11-30 13:30:00 | SPY | ETF | 209.22 | 209.48 | 209.125 | 209.375 | 5507722.0 |
| 2015-11-30 14:00:00 | SPY | ETF | 209.38 | 209.41 | 209.165 | 209.21 | 4071216.0 |
| 2015-11-30 14:30:00 | SPY | ETF | 209.21 | 209.27 | 208.81 | 208.84 | 4983421.0 |
| 2015-11-30 15:00:00 | SPY | ETF | 208.83 | 208.91 | 208.56 | 208.675 | 8527141.0 |
| 2015-11-30 15:30:00 | SPY | ETF | 208.68 | 208.98 | 208.56 | 208.67 | 24205842.0 |
| 2015-11-30 16:00:00 | SPY | ETF | 208.67 | 208.97 | 208.5172 | 208.92 | 17610810.0 |
| 2015-11-30 16:30:00 | SPY | ETF | 208.93 | 209.23 | 208.52 | 209.22 | 1502817.0 |
| 2015-11-30 17:00:00 | SPY | ETF | 209.19 | 209.2 | 209.15 | 209.2 | 98497.0 |
| 2015-11-30 17:30:00 | SPY | ETF | 209.18 | 209.26 | 208.69 | 209.23 | 713645.0 |
| 2015-11-30 18:00:00 | SPY | ETF | 209.23 | 209.6 | 208.69 | 209.49 | 132904.0 |
| 2015-11-30 18:30:00 | SPY | ETF | 209.46 | 209.49 | 209.37 | 209.43 | 22170.0 |
| 2015-11-30 19:00:00 | SPY | ETF | 209.41 | 209.56 | 209.39 | 209.47 | 76732.0 |
| 2015-11-30 19:30:00 | SPY | ETF | 209.48 | 209.65 | 209.48 | 209.57 | 167567.0 |
| 2015-11-30 04:00:00 | QQQ | ETF | 114.25 | 114.25 | 114.25 | 114.25 | 100.0 |
| 2015-11-30 06:00:00 | QQQ | ETF | 114.41 | 114.65 | 114.38 | 114.65 | 2200.0 |
| 2015-11-30 06:30:00 | QQQ | ETF | 114.61 | 114.63 | 114.6 | 114.6 | 1000.0 |
| 2015-11-30 07:00:00 | QQQ | ETF | 114.55 | 114.64 | 114.55 | 114.64 | 2460.0 |
| 2015-11-30 07:30:00 | QQQ | ETF | 114.71 | 114.77 | 114.67 | 114.77 | 7100.0 |
| 2015-11-30 08:00:00 | QQQ | ETF | 114.75 | 114.78 | 114.72 | 114.77 | 26956.0 |
| 2015-11-30 08:30:00 | QQQ | ETF | 114.77 | 114.77 | 114.71 | 114.73 | 91489.0 |
| 2015-11-30 09:00:00 | QQQ | ETF | 114.74 | 114.74 | 114.61 | 114.61 | 110183.0 |
| 2015-11-30 09:30:00 | QQQ | ETF | 114.6 | 114.65 | 114.2 | 114.2298 | 2366571.0 |
| 2015-11-30 10:00:00 | QQQ | ETF | 114.2299 | 114.36 | 114.01 | 114.22 | 1329402.0 |
| 2015-11-30 10:30:00 | QQQ | ETF | 114.22 | 114.39 | 114.05 | 114.15 | 995129.0 |
| 2015-11-30 11:00:00 | QQQ | ETF | 114.15 | 114.28 | 113.97 | 114.0 | 1057340.0 |
| 2015-11-30 11:30:00 | QQQ | ETF | 114.0 | 114.01 | 113.7 | 113.75 | 1371794.0 |
| 2015-11-30 12:00:00 | QQQ | ETF | 113.74 | 113.84 | 113.65 | 113.78 | 1015987.0 |
| 2015-11-30 12:30:00 | QQQ | ETF | 113.78 | 113.87 | 113.68 | 113.81 | 579355.0 |
| 2015-11-30 13:00:00 | QQQ | ETF | 113.8099 | 113.97 | 113.6801 | 113.97 | 849160.0 |
| 2015-11-30 13:30:00 | QQQ | ETF | 113.965 | 114.315 | 113.9 | 114.25 | 1542033.0 |
| 2015-11-30 14:00:00 | QQQ | ETF | 114.25 | 114.35 | 114.215 | 114.24 | 913699.0 |
> showing 50 of 12,903 rows — these rows as CSV