PREVIEW / etf_30min / 2014-10-17

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-10-17.parquet
  size:    377 KB
  rows:    12,740

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-10-17 04:00:00	SPY	ETF	187.0	188.0	187.0	187.68	37245.0
2014-10-17 04:30:00	SPY	ETF	187.7	188.19	187.65	188.0	4542.0
2014-10-17 05:00:00	SPY	ETF	188.09	188.2	187.82	188.1	38865.0
2014-10-17 05:30:00	SPY	ETF	188.11	188.12	187.9	187.98	51289.0
2014-10-17 06:00:00	SPY	ETF	188.0	188.43	188.0	188.3	38590.0
2014-10-17 06:30:00	SPY	ETF	188.15	188.22	187.82	187.82	366769.0
2014-10-17 07:00:00	SPY	ETF	187.8	188.34	187.75	188.34	591069.0
2014-10-17 07:30:00	SPY	ETF	188.34	188.37	188.08	188.09	509249.0
2014-10-17 08:00:00	SPY	ETF	188.08	188.21	187.69	188.06	940604.0
2014-10-17 08:30:00	SPY	ETF	188.06	188.41	187.83	187.94	1923120.0
2014-10-17 09:00:00	SPY	ETF	187.94	188.52	187.81	188.42	2764511.0
2014-10-17 09:30:00	SPY	ETF	188.42	188.52	187.62	188.2	27832492.0
2014-10-17 10:00:00	SPY	ETF	188.21	189.22	188.04	189.2	20208481.0
2014-10-17 10:30:00	SPY	ETF	189.2	189.24	188.65	188.9899	19144169.0
2014-10-17 11:00:00	SPY	ETF	188.985	189.45	188.85	189.35	12795161.0
2014-10-17 11:30:00	SPY	ETF	189.35	189.75	189.21	189.399	10412637.0
2014-10-17 12:00:00	SPY	ETF	189.39	189.62	188.95	189.11	10517037.0
2014-10-17 12:30:00	SPY	ETF	189.11	189.4	188.79	189.03	7774011.0
2014-10-17 13:00:00	SPY	ETF	189.03	189.24	188.45	188.48	13347746.0
2014-10-17 13:30:00	SPY	ETF	188.485	188.84	188.25	188.46	9814628.0
2014-10-17 14:00:00	SPY	ETF	188.465	188.465	187.63	188.12	14495803.0
2014-10-17 14:30:00	SPY	ETF	188.13	188.55	187.95	188.4	7755632.0
2014-10-17 15:00:00	SPY	ETF	188.4	188.87	187.77	188.72	13471743.0
2014-10-17 15:30:00	SPY	ETF	188.72	189.18	188.52	188.54	24644089.0
2014-10-17 16:00:00	SPY	ETF	188.52	189.1	188.2	188.67	9890513.0
2014-10-17 16:30:00	SPY	ETF	188.65	188.94	188.47	188.77	2859159.0
2014-10-17 17:00:00	SPY	ETF	188.77	188.77	188.62	188.76	221924.0
2014-10-17 17:30:00	SPY	ETF	188.7	188.95	188.7	188.89	131921.0
2014-10-17 18:00:00	SPY	ETF	188.9	188.9	188.83	188.88	27053.0
2014-10-17 18:30:00	SPY	ETF	188.87	188.92	188.64	188.64	85688.0
2014-10-17 19:00:00	SPY	ETF	188.65	188.65	187.95	188.28	213468.0
2014-10-17 19:30:00	SPY	ETF	188.29	188.59	188.29	188.55	45689.0
2014-10-17 04:00:00	QQQ	ETF	92.03	92.5	92.03	92.5	1900.0
2014-10-17 04:30:00	QQQ	ETF	92.64	92.69	92.64	92.69	300.0
2014-10-17 05:00:00	QQQ	ETF	92.77	92.82	92.66	92.82	13700.0
2014-10-17 05:30:00	QQQ	ETF	92.82	92.85	92.6	92.6	25050.0
2014-10-17 06:00:00	QQQ	ETF	92.68	92.97	92.68	92.92	33570.0
2014-10-17 06:30:00	QQQ	ETF	92.86	92.86	92.63	92.77	23500.0
2014-10-17 07:00:00	QQQ	ETF	92.7	92.89	92.64	92.88	36512.0
2014-10-17 07:30:00	QQQ	ETF	92.9	92.91	92.78	92.78	56690.0
2014-10-17 08:00:00	QQQ	ETF	92.77	92.89	92.63	92.82	217235.0
2014-10-17 08:30:00	QQQ	ETF	92.83	92.99	92.73	92.78	392351.0
2014-10-17 09:00:00	QQQ	ETF	92.78	93.02	92.77	92.98	1065306.0
2014-10-17 09:30:00	QQQ	ETF	92.99	93.2	92.46	92.97	9521347.0
2014-10-17 10:00:00	QQQ	ETF	92.97	93.47	92.9007	93.46	5361541.0
2014-10-17 10:30:00	QQQ	ETF	93.47	93.475	93.09	93.33	3409215.0
2014-10-17 11:00:00	QQQ	ETF	93.33	93.72	93.25	93.66	2644523.0
2014-10-17 11:30:00	QQQ	ETF	93.67	93.89	93.58	93.65	2798443.0
2014-10-17 12:00:00	QQQ	ETF	93.645	93.7498	93.4833	93.531	3820552.0
2014-10-17 12:30:00	QQQ	ETF	93.535	93.69	93.4032	93.51	2894737.0

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

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