PREVIEW / etf_30min / 2017-06-13

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-06-13.parquet
  size:    424 KB
  rows:    14,683

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-06-13 04:00:00	SPY	ETF	243.77	243.97	243.77	243.85	22330.0
2017-06-13 04:30:00	SPY	ETF	243.86	243.86	243.86	243.86	3500.0
2017-06-13 05:00:00	SPY	ETF	243.83	243.83	243.73	243.73	4000.0
2017-06-13 05:30:00	SPY	ETF	243.68	243.68	243.68	243.68	2500.0
2017-06-13 06:00:00	SPY	ETF	243.75	243.79	243.75	243.79	1140.0
2017-06-13 06:30:00	SPY	ETF	243.73	243.73	243.68	243.72	3500.0
2017-06-13 07:00:00	SPY	ETF	243.68	243.75	243.68	243.69	48813.0
2017-06-13 07:30:00	SPY	ETF	243.71	243.73	243.68	243.7	24223.0
2017-06-13 08:00:00	SPY	ETF	243.7	243.79	243.64	243.78	115409.0
2017-06-13 08:30:00	SPY	ETF	243.77	243.89	243.76	243.85	136839.0
2017-06-13 09:00:00	SPY	ETF	243.89	243.99	243.87	243.99	337663.0
2017-06-13 09:30:00	SPY	ETF	243.98	244.28	243.93	244.06	6788952.0
2017-06-13 10:00:00	SPY	ETF	244.065	244.11	243.87	244.05	3583082.0
2017-06-13 10:30:00	SPY	ETF	244.05	244.16	243.66	243.68	4798703.0
2017-06-13 11:00:00	SPY	ETF	243.68	243.99	243.5799	243.95	3355372.0
2017-06-13 11:30:00	SPY	ETF	243.96	244.211	243.88	244.15	3538742.0
2017-06-13 12:00:00	SPY	ETF	244.145	244.19	244.05	244.1	1958604.0
2017-06-13 12:30:00	SPY	ETF	244.09	244.38	244.07	244.35	2338969.0
2017-06-13 13:00:00	SPY	ETF	244.355	244.45	244.26	244.41	1576819.0
2017-06-13 13:30:00	SPY	ETF	244.42	244.43	244.14	244.31	2238102.0
2017-06-13 14:00:00	SPY	ETF	244.315	244.53	244.29	244.37	2740358.0
2017-06-13 14:30:00	SPY	ETF	244.36	244.45	244.245	244.32	3791227.0
2017-06-13 15:00:00	SPY	ETF	244.325	244.58	244.285	244.575	5964839.0
2017-06-13 15:30:00	SPY	ETF	244.575	244.61	244.23	244.52	8823914.0
2017-06-13 16:00:00	SPY	ETF	244.51	244.55	244.4	244.49	5922681.0
2017-06-13 16:30:00	SPY	ETF	244.49	244.56	244.46	244.5	181499.0
2017-06-13 17:00:00	SPY	ETF	244.5	244.61	244.48	244.61	180417.0
2017-06-13 17:30:00	SPY	ETF	244.6	244.64	243.795	244.62	180037.0
2017-06-13 18:00:00	SPY	ETF	244.56	244.56	244.5	244.54	156840.0
2017-06-13 18:30:00	SPY	ETF	244.56	244.56	244.51	244.52	16140.0
2017-06-13 19:00:00	SPY	ETF	244.53	244.53	244.48	244.52	37079.0
2017-06-13 19:30:00	SPY	ETF	244.52	244.55	244.5	244.54	28135.0
2017-06-13 04:00:00	QQQ	ETF	139.6	139.74	139.6	139.67	6837.0
2017-06-13 04:30:00	QQQ	ETF	139.67	139.73	139.67	139.73	547.0
2017-06-13 05:00:00	QQQ	ETF	139.67	139.69	139.61	139.61	4008.0
2017-06-13 05:30:00	QQQ	ETF	139.62	139.62	139.53	139.57	8450.0
2017-06-13 06:00:00	QQQ	ETF	139.59	139.61	139.59	139.61	2100.0
2017-06-13 06:30:00	QQQ	ETF	139.62	139.67	139.62	139.65	6304.0
2017-06-13 07:00:00	QQQ	ETF	139.63	139.64	139.58	139.58	18747.0
2017-06-13 07:30:00	QQQ	ETF	139.57	139.77	139.57	139.77	67170.0
2017-06-13 08:00:00	QQQ	ETF	139.78	139.84	139.61	139.84	161742.0
2017-06-13 08:30:00	QQQ	ETF	139.82	139.96	139.82	139.89	191384.0
2017-06-13 09:00:00	QQQ	ETF	139.89	140.02	139.87	140.01	463825.0
2017-06-13 09:30:00	QQQ	ETF	140.02	140.55	139.98	140.3	8282260.0
2017-06-13 10:00:00	QQQ	ETF	140.31	140.3256	139.89	139.99	3926516.0
2017-06-13 10:30:00	QQQ	ETF	139.99	140.29	139.43	139.46	4303776.0
2017-06-13 11:00:00	QQQ	ETF	139.465	139.94	139.28	139.81	3277949.0
2017-06-13 11:30:00	QQQ	ETF	139.81	140.1	139.63	140.09	1993677.0
2017-06-13 12:00:00	QQQ	ETF	140.085	140.17	139.95	139.96	2036706.0
2017-06-13 12:30:00	QQQ	ETF	139.9618	140.29	139.92	140.27	2229427.0

> showing 50 of 14,683 rows — these rows as CSV

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