PREVIEW / etf_30min / 2016-05-05

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-05-05.parquet
  size:    388 KB
  rows:    13,180

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-05-05 04:00:00	SPY	ETF	205.71	206.35	205.66	206.35	11923.0
2016-05-05 04:30:00	SPY	ETF	206.26	206.46	206.26	206.34	2597.0
2016-05-05 05:00:00	SPY	ETF	206.34	206.35	206.29	206.3	6941.0
2016-05-05 05:30:00	SPY	ETF	206.25	206.25	205.86	205.88	5349.0
2016-05-05 06:00:00	SPY	ETF	205.9	205.9	205.71	205.73	41395.0
2016-05-05 06:30:00	SPY	ETF	205.72	205.93	205.64	205.93	92597.0
2016-05-05 07:00:00	SPY	ETF	205.94	206.04	205.68	205.8	157737.0
2016-05-05 07:30:00	SPY	ETF	205.82	205.97	205.81	205.9	173132.0
2016-05-05 08:00:00	SPY	ETF	205.87	205.97	205.77	205.9	334897.0
2016-05-05 08:30:00	SPY	ETF	205.88	205.94	205.68	205.8	291289.0
2016-05-05 09:00:00	SPY	ETF	205.81	205.81	205.5	205.57	503707.0
2016-05-05 09:30:00	SPY	ETF	205.56	205.73	205.24	205.43	7383190.0
2016-05-05 10:00:00	SPY	ETF	205.44	205.98	205.275	205.3332	6491918.0
2016-05-05 10:30:00	SPY	ETF	205.33	205.54	205.19	205.48	3927008.0
2016-05-05 11:00:00	SPY	ETF	205.49	205.588	205.05	205.1909	3802667.0
2016-05-05 11:30:00	SPY	ETF	205.19	205.73	205.17	205.615	3333154.0
2016-05-05 12:00:00	SPY	ETF	205.62	205.74	205.35	205.4	1827932.0
2016-05-05 12:30:00	SPY	ETF	205.4	205.47	205.22	205.37	2642864.0
2016-05-05 13:00:00	SPY	ETF	205.37	205.395	204.49	204.55	4609301.0
2016-05-05 13:30:00	SPY	ETF	204.55	204.75	204.47	204.68	4073858.0
2016-05-05 14:00:00	SPY	ETF	204.68	204.98	204.55	204.86	4717054.0
2016-05-05 14:30:00	SPY	ETF	204.85	205.09	204.72	204.73	3981390.0
2016-05-05 15:00:00	SPY	ETF	204.73	204.965	204.54	204.88	4792300.0
2016-05-05 15:30:00	SPY	ETF	204.88	205.0	204.68	204.98	9183632.0
2016-05-05 16:00:00	SPY	ETF	204.98	205.01	204.8	204.93	3558043.0
2016-05-05 16:30:00	SPY	ETF	204.93	205.1429	204.84	204.88	262976.0
2016-05-05 17:00:00	SPY	ETF	204.88	204.88	204.82	204.88	557610.0
2016-05-05 17:30:00	SPY	ETF	204.85	204.88	204.83	204.88	38228.0
2016-05-05 18:00:00	SPY	ETF	204.86	204.86	204.63	204.68	55267.0
2016-05-05 18:30:00	SPY	ETF	204.69	204.69	204.43	204.52	75754.0
2016-05-05 19:00:00	SPY	ETF	204.54	204.65	204.54	204.65	27146.0
2016-05-05 19:30:00	SPY	ETF	204.65	204.89	204.65	204.89	52326.0
2016-05-05 04:00:00	QQQ	ETF	105.7	105.94	105.7	105.93	6000.0
2016-05-05 04:30:00	QQQ	ETF	105.95	105.97	105.9	105.9	10598.0
2016-05-05 05:00:00	QQQ	ETF	105.87	105.9	105.87	105.9	1600.0
2016-05-05 05:30:00	QQQ	ETF	105.83	105.83	105.6	105.6	5902.0
2016-05-05 06:00:00	QQQ	ETF	105.62	105.63	105.53	105.53	2524.0
2016-05-05 06:30:00	QQQ	ETF	105.5	105.52	105.48	105.52	2895.0
2016-05-05 07:00:00	QQQ	ETF	105.62	105.64	105.49	105.53	28194.0
2016-05-05 07:30:00	QQQ	ETF	105.57	105.61	105.55	105.59	5699.0
2016-05-05 08:00:00	QQQ	ETF	105.6	105.61	105.56	105.58	49984.0
2016-05-05 08:30:00	QQQ	ETF	105.54	105.6	105.5	105.55	35970.0
2016-05-05 09:00:00	QQQ	ETF	105.55	105.55	105.38	105.43	129167.0
2016-05-05 09:30:00	QQQ	ETF	105.43	105.5	105.05	105.14	3273580.0
2016-05-05 10:00:00	QQQ	ETF	105.13	105.59	105.05	105.13	2088924.0
2016-05-05 10:30:00	QQQ	ETF	105.13	105.3738	105.05	105.36	1421199.0
2016-05-05 11:00:00	QQQ	ETF	105.37	105.48	105.16	105.21	1346745.0
2016-05-05 11:30:00	QQQ	ETF	105.218	105.66	105.21	105.51	962650.0
2016-05-05 12:00:00	QQQ	ETF	105.51	105.5865	105.369	105.41	701808.0
2016-05-05 12:30:00	QQQ	ETF	105.41	105.4101	105.29	105.34	685113.0

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

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