PREVIEW / etf_30min / 2016-10-17

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-10-17.parquet
  size:    389 KB
  rows:    13,335

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
2016-10-17 04:00:00	SPY	ETF	212.75	212.75	212.44	212.46	2307.0
2016-10-17 04:30:00	SPY	ETF	212.59	212.59	212.59	212.59	500.0
2016-10-17 05:00:00	SPY	ETF	212.5	212.5	212.23	212.23	450.0
2016-10-17 05:30:00	SPY	ETF	212.35	212.42	212.35	212.35	3326.0
2016-10-17 06:00:00	SPY	ETF	212.4	212.4	212.4	212.4	860.0
2016-10-17 06:30:00	SPY	ETF	212.65	212.65	212.55	212.57	2104.0
2016-10-17 07:00:00	SPY	ETF	212.68	212.94	212.56	212.91	86218.0
2016-10-17 07:30:00	SPY	ETF	212.9	212.98	212.75	212.89	107927.0
2016-10-17 08:00:00	SPY	ETF	212.7	213.03	212.431	212.91	401408.0
2016-10-17 08:30:00	SPY	ETF	212.91	213.09	212.72	213.04	334132.0
2016-10-17 09:00:00	SPY	ETF	213.04	213.14	212.89	213.09	543055.0
2016-10-17 09:30:00	SPY	ETF	213.09	213.39	212.5	212.61	7373315.0
2016-10-17 10:00:00	SPY	ETF	212.62	213.28	212.47	213.15	5980139.0
2016-10-17 10:30:00	SPY	ETF	213.16	213.21	212.65	212.82	3435788.0
2016-10-17 11:00:00	SPY	ETF	212.81	212.94	212.5689	212.64	2623382.0
2016-10-17 11:30:00	SPY	ETF	212.64	213.045	212.64	212.93	2499455.0
2016-10-17 12:00:00	SPY	ETF	212.93	212.96	212.6	212.63	2498408.0
2016-10-17 12:30:00	SPY	ETF	212.62	212.79	212.53	212.625	1912717.0
2016-10-17 13:00:00	SPY	ETF	212.62	212.74	212.34	212.43	2869457.0
2016-10-17 13:30:00	SPY	ETF	212.43	212.51	212.17	212.22	3026825.0
2016-10-17 14:00:00	SPY	ETF	212.225	212.59	212.21	212.571	3141838.0
2016-10-17 14:30:00	SPY	ETF	212.575	212.7	212.38	212.659	2826319.0
2016-10-17 15:00:00	SPY	ETF	212.65	212.66	212.39	212.45	3009128.0
2016-10-17 15:30:00	SPY	ETF	212.455	212.56	212.27	212.4	9744419.0
2016-10-17 16:00:00	SPY	ETF	212.41	212.83	212.38	212.66	2604372.0
2016-10-17 16:30:00	SPY	ETF	212.66	212.68	212.38	212.58	551859.0
2016-10-17 17:00:00	SPY	ETF	212.38	212.65	212.38	212.6	287243.0
2016-10-17 17:30:00	SPY	ETF	212.57	212.68	212.56	212.68	16377.0
2016-10-17 18:00:00	SPY	ETF	212.63	212.64	212.45	212.45	52805.0
2016-10-17 18:30:00	SPY	ETF	212.5	212.61	212.5	212.61	15240.0
2016-10-17 19:00:00	SPY	ETF	212.62	212.64	212.54	212.6	1154.0
2016-10-17 19:30:00	SPY	ETF	212.62	212.79	212.62	212.76	19389.0
2016-10-17 04:00:00	QQQ	ETF	117.0	117.0	116.73	116.73	13799.0
2016-10-17 05:00:00	QQQ	ETF	116.7	116.7	116.7	116.7	200.0
2016-10-17 05:30:00	QQQ	ETF	116.68	116.68	116.68	116.68	200.0
2016-10-17 06:30:00	QQQ	ETF	116.74	116.79	116.74	116.79	200.0
2016-10-17 07:00:00	QQQ	ETF	116.83	116.83	116.83	116.83	10000.0
2016-10-17 07:30:00	QQQ	ETF	116.95	116.95	116.88	116.92	12481.0
2016-10-17 08:00:00	QQQ	ETF	116.94	117.0	116.94	116.97	16928.0
2016-10-17 08:30:00	QQQ	ETF	116.98	117.09	116.9	117.05	52424.0
2016-10-17 09:00:00	QQQ	ETF	117.08	117.13	117.04	117.1	74832.0
2016-10-17 09:30:00	QQQ	ETF	117.1	117.17	116.672	116.71	1989121.0
2016-10-17 10:00:00	QQQ	ETF	116.71	117.3	116.7	117.25	1244302.0
2016-10-17 10:30:00	QQQ	ETF	117.25	117.28	116.99	117.07	614115.0
2016-10-17 11:00:00	QQQ	ETF	117.07	117.17	116.92	116.96	863937.0
2016-10-17 11:30:00	QQQ	ETF	116.97	117.16	116.9525	117.081	525202.0
2016-10-17 12:00:00	QQQ	ETF	117.08	117.14	116.94	116.97	506348.0
2016-10-17 12:30:00	QQQ	ETF	116.96	117.05	116.87	116.94	360777.0
2016-10-17 13:00:00	QQQ	ETF	116.95	117.01	116.79	116.83	723848.0
2016-10-17 13:30:00	QQQ	ETF	116.835	116.8795	116.7	116.72	571594.0

> showing 50 of 13,335 rows — these rows as CSV

> unlock the full archive -- $79 one-time