PREVIEW / etf_30min / 2015-11-10
file: by_date/etf_30min/2015/2015-11-10.parquet size: 375 KB rows: 12,674
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-10 04:00:00 | SPY | ETF | 208.25 | 208.33 | 207.82 | 207.82 | 5830.0 |
| 2015-11-10 04:30:00 | SPY | ETF | 207.86 | 207.86 | 207.57 | 207.61 | 20903.0 |
| 2015-11-10 05:00:00 | SPY | ETF | 207.61 | 207.68 | 207.56 | 207.56 | 3451.0 |
| 2015-11-10 05:30:00 | SPY | ETF | 207.61 | 207.67 | 207.43 | 207.43 | 6743.0 |
| 2015-11-10 06:00:00 | SPY | ETF | 207.45 | 207.61 | 207.45 | 207.61 | 7488.0 |
| 2015-11-10 06:30:00 | SPY | ETF | 207.67 | 207.9 | 207.67 | 207.85 | 9830.0 |
| 2015-11-10 07:00:00 | SPY | ETF | 207.81 | 207.81 | 207.43 | 207.47 | 48045.0 |
| 2015-11-10 07:30:00 | SPY | ETF | 207.47 | 207.53 | 207.28 | 207.48 | 64416.0 |
| 2015-11-10 08:00:00 | SPY | ETF | 207.77 | 208.17 | 207.42 | 207.7 | 236287.0 |
| 2015-11-10 08:30:00 | SPY | ETF | 207.68 | 208.08 | 207.59 | 207.59 | 339125.0 |
| 2015-11-10 09:00:00 | SPY | ETF | 207.59 | 207.71 | 207.5 | 207.5 | 541051.0 |
| 2015-11-10 09:30:00 | SPY | ETF | 207.51 | 208.2 | 207.43 | 208.06 | 9733882.0 |
| 2015-11-10 10:00:00 | SPY | ETF | 208.06 | 208.13 | 207.19 | 207.4 | 7084430.0 |
| 2015-11-10 10:30:00 | SPY | ETF | 207.4 | 207.81 | 207.27 | 207.76 | 4132569.0 |
| 2015-11-10 11:00:00 | SPY | ETF | 207.76 | 207.95 | 207.41 | 207.53 | 5423534.0 |
| 2015-11-10 11:30:00 | SPY | ETF | 207.52 | 207.9 | 207.5 | 207.81 | 2994909.0 |
| 2015-11-10 12:00:00 | SPY | ETF | 207.81 | 208.14 | 207.705 | 207.94 | 3337931.0 |
| 2015-11-10 12:30:00 | SPY | ETF | 207.94 | 207.94 | 207.59 | 207.77 | 2461747.0 |
| 2015-11-10 13:00:00 | SPY | ETF | 207.77 | 207.84 | 207.57 | 207.8 | 2122980.0 |
| 2015-11-10 13:30:00 | SPY | ETF | 207.81 | 208.23 | 207.74 | 208.125 | 3576938.0 |
| 2015-11-10 14:00:00 | SPY | ETF | 208.125 | 208.18 | 207.9 | 208.015 | 2939863.0 |
| 2015-11-10 14:30:00 | SPY | ETF | 208.01 | 208.6 | 207.97 | 208.34 | 5260613.0 |
| 2015-11-10 15:00:00 | SPY | ETF | 208.34 | 208.49 | 208.19 | 208.32 | 4378117.0 |
| 2015-11-10 15:30:00 | SPY | ETF | 208.31 | 208.51 | 208.1 | 208.51 | 11968088.0 |
| 2015-11-10 16:00:00 | SPY | ETF | 208.5 | 208.63 | 208.2857 | 208.54 | 4843271.0 |
| 2015-11-10 16:30:00 | SPY | ETF | 208.53 | 208.53 | 208.36 | 208.43 | 1413522.0 |
| 2015-11-10 17:00:00 | SPY | ETF | 208.45 | 208.5 | 208.44 | 208.46 | 43551.0 |
| 2015-11-10 17:30:00 | SPY | ETF | 208.45 | 208.45 | 208.36 | 208.41 | 22960.0 |
| 2015-11-10 18:00:00 | SPY | ETF | 208.38 | 208.44 | 208.27 | 208.29 | 43155.0 |
| 2015-11-10 18:30:00 | SPY | ETF | 208.28 | 208.56 | 208.28 | 208.31 | 10957.0 |
| 2015-11-10 19:00:00 | SPY | ETF | 208.3 | 208.45 | 208.3 | 208.41 | 12048.0 |
| 2015-11-10 19:30:00 | SPY | ETF | 208.44 | 208.44 | 208.35 | 208.4 | 36764.0 |
| 2015-11-10 04:30:00 | QQQ | ETF | 113.3 | 113.31 | 113.25 | 113.3 | 16350.0 |
| 2015-11-10 06:00:00 | QQQ | ETF | 113.18 | 113.21 | 113.18 | 113.21 | 1410.0 |
| 2015-11-10 06:30:00 | QQQ | ETF | 113.29 | 113.45 | 113.29 | 113.45 | 900.0 |
| 2015-11-10 07:00:00 | QQQ | ETF | 113.43 | 113.43 | 113.11 | 113.11 | 12995.0 |
| 2015-11-10 07:30:00 | QQQ | ETF | 113.11 | 113.13 | 112.93 | 112.96 | 33000.0 |
| 2015-11-10 08:00:00 | QQQ | ETF | 113.37 | 113.37 | 113.04 | 113.14 | 29721.0 |
| 2015-11-10 08:30:00 | QQQ | ETF | 113.13 | 113.18 | 113.1 | 113.11 | 123355.0 |
| 2015-11-10 09:00:00 | QQQ | ETF | 113.12 | 113.15 | 112.94 | 112.96 | 242985.0 |
| 2015-11-10 09:30:00 | QQQ | ETF | 112.96 | 113.19 | 112.68 | 113.08 | 5212976.0 |
| 2015-11-10 10:00:00 | QQQ | ETF | 113.08 | 113.18 | 112.63 | 112.78 | 2326013.0 |
| 2015-11-10 10:30:00 | QQQ | ETF | 112.77 | 113.07 | 112.73 | 113.04 | 1278781.0 |
| 2015-11-10 11:00:00 | QQQ | ETF | 113.05 | 113.21 | 112.9319 | 112.99 | 1754878.0 |
| 2015-11-10 11:30:00 | QQQ | ETF | 113.0 | 113.17 | 112.9 | 113.065 | 1003056.0 |
| 2015-11-10 12:00:00 | QQQ | ETF | 113.055 | 113.14 | 112.895 | 113.0872 | 828842.0 |
| 2015-11-10 12:30:00 | QQQ | ETF | 113.08 | 113.1 | 112.89 | 112.95 | 802649.0 |
| 2015-11-10 13:00:00 | QQQ | ETF | 112.94 | 112.9891 | 112.78 | 112.9 | 923733.0 |
| 2015-11-10 13:30:00 | QQQ | ETF | 112.91 | 113.18 | 112.89 | 113.1005 | 1301163.0 |
| 2015-11-10 14:00:00 | QQQ | ETF | 113.1 | 113.15 | 112.925 | 112.99 | 947370.0 |
> showing 50 of 12,674 rows — these rows as CSV