PREVIEW / etf_30min / 2014-12-11

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-12-11.parquet
  size:    376 KB
  rows:    12,611

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
2014-12-11 04:00:00	SPY	ETF	203.9	204.04	203.87	204.03	4398.0
2014-12-11 04:30:00	SPY	ETF	204.04	204.04	203.89	203.96	41500.0
2014-12-11 05:00:00	SPY	ETF	203.97	204.04	203.8	203.81	41350.0
2014-12-11 05:30:00	SPY	ETF	203.81	203.86	203.6	203.64	29589.0
2014-12-11 06:00:00	SPY	ETF	203.65	203.76	203.59	203.59	51384.0
2014-12-11 06:30:00	SPY	ETF	203.58	203.65	203.35	203.36	40716.0
2014-12-11 07:00:00	SPY	ETF	203.33	203.6	203.33	203.59	70434.0
2014-12-11 07:30:00	SPY	ETF	203.55	203.99	203.55	203.92	260604.0
2014-12-11 08:00:00	SPY	ETF	203.65	203.97	203.34	203.51	810937.0
2014-12-11 08:30:00	SPY	ETF	203.54	204.19	203.48	204.08	1659141.0
2014-12-11 09:00:00	SPY	ETF	204.09	204.2	203.87	203.89	913872.0
2014-12-11 09:30:00	SPY	ETF	203.88	205.47	203.88	205.25	21911687.0
2014-12-11 10:00:00	SPY	ETF	205.24	205.88	205.14	205.8	13281611.0
2014-12-11 10:30:00	SPY	ETF	205.8	206.08	205.655	205.73	12335043.0
2014-12-11 11:00:00	SPY	ETF	205.725	206.11	205.64	205.855	9806905.0
2014-12-11 11:30:00	SPY	ETF	205.85	206.18	205.85	206.14	7339805.0
2014-12-11 12:00:00	SPY	ETF	206.13	206.19	205.85	205.94	4497651.0
2014-12-11 12:30:00	SPY	ETF	205.94	206.15	205.83	206.01	5589376.0
2014-12-11 13:00:00	SPY	ETF	206.02	206.05	205.53	205.57	5794022.0
2014-12-11 13:30:00	SPY	ETF	205.58	205.81	205.31	205.32	4552491.0
2014-12-11 14:00:00	SPY	ETF	205.31	205.45	204.82	204.85	12216471.0
2014-12-11 14:30:00	SPY	ETF	204.84	205.05	204.13	204.23	12538783.0
2014-12-11 15:00:00	SPY	ETF	204.23	205.17	204.2	205.01	11758519.0
2014-12-11 15:30:00	SPY	ETF	205.019	205.23	203.71	204.17	20438120.0
2014-12-11 16:00:00	SPY	ETF	204.16	205.19	202.89	203.52	6012216.0
2014-12-11 16:30:00	SPY	ETF	203.55	206.067	202.97	203.32	2046096.0
2014-12-11 17:00:00	SPY	ETF	203.3	203.57	203.29	203.55	354246.0
2014-12-11 17:30:00	SPY	ETF	203.55	203.59	203.53	203.55	125319.0
2014-12-11 18:00:00	SPY	ETF	203.54	203.7	203.46	203.47	138462.0
2014-12-11 18:30:00	SPY	ETF	203.47	203.57	203.45	203.49	75495.0
2014-12-11 19:00:00	SPY	ETF	203.53	203.54	203.23	203.26	77930.0
2014-12-11 19:30:00	SPY	ETF	203.29	203.62	203.24	203.55	91901.0
2014-12-11 05:00:00	QQQ	ETF	103.53	103.53	103.51	103.51	200.0
2014-12-11 05:30:00	QQQ	ETF	103.49	103.49	103.49	103.49	1000.0
2014-12-11 06:00:00	QQQ	ETF	103.42	103.43	103.36	103.36	10900.0
2014-12-11 06:30:00	QQQ	ETF	103.37	103.39	103.28	103.28	40360.0
2014-12-11 07:00:00	QQQ	ETF	103.22	103.36	103.21	103.36	32416.0
2014-12-11 07:30:00	QQQ	ETF	103.4	103.56	103.4	103.52	62646.0
2014-12-11 08:00:00	QQQ	ETF	103.55	103.56	103.31	103.45	164751.0
2014-12-11 08:30:00	QQQ	ETF	103.5	103.7	103.5	103.69	193833.0
2014-12-11 09:00:00	QQQ	ETF	103.67	103.73	103.6	103.61	207016.0
2014-12-11 09:30:00	QQQ	ETF	103.61	104.41	103.61	104.38	5990688.0
2014-12-11 10:00:00	QQQ	ETF	104.38	104.81	104.23	104.77	3765489.0
2014-12-11 10:30:00	QQQ	ETF	104.775	104.92	104.74	104.78	4062470.0
2014-12-11 11:00:00	QQQ	ETF	104.785	104.96	104.71	104.85	1980093.0
2014-12-11 11:30:00	QQQ	ETF	104.845	105.04	104.81	104.98	1609256.0
2014-12-11 12:00:00	QQQ	ETF	104.98	105.01	104.8	104.86	1052502.0
2014-12-11 12:30:00	QQQ	ETF	104.86	104.94	104.73	104.87	1620039.0
2014-12-11 13:00:00	QQQ	ETF	104.88	104.92	104.65	104.7	1037237.0
2014-12-11 13:30:00	QQQ	ETF	104.705	104.88	104.6	104.61	1251016.0

> showing 50 of 12,611 rows — these rows as CSV

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