PREVIEW / etf_30min / 2016-02-25

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-02-25.parquet
  size:    386 KB
  rows:    12,966

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-02-25 04:00:00	SPY	ETF	192.94	193.49	192.81	193.42	37382.0
2016-02-25 04:30:00	SPY	ETF	193.48	193.48	193.08	193.26	16437.0
2016-02-25 05:00:00	SPY	ETF	193.26	193.42	193.0	193.35	52507.0
2016-02-25 05:30:00	SPY	ETF	193.3	193.71	193.3	193.65	14060.0
2016-02-25 06:00:00	SPY	ETF	193.64	193.74	193.42	193.73	24060.0
2016-02-25 06:30:00	SPY	ETF	193.73	194.0	193.68	193.99	82692.0
2016-02-25 07:00:00	SPY	ETF	193.98	194.26	193.89	193.89	292320.0
2016-02-25 07:30:00	SPY	ETF	193.93	193.99	193.77	193.8	207057.0
2016-02-25 08:00:00	SPY	ETF	193.78	194.17	193.54	193.64	558785.0
2016-02-25 08:30:00	SPY	ETF	193.74	194.0	193.52	193.84	913381.0
2016-02-25 09:00:00	SPY	ETF	193.8	194.16	193.69	193.72	660399.0
2016-02-25 09:30:00	SPY	ETF	193.73	194.26	193.255	193.37	11175674.0
2016-02-25 10:00:00	SPY	ETF	193.375	193.62	192.83	193.6001	9217121.0
2016-02-25 10:30:00	SPY	ETF	193.61	193.82	193.201	193.265	8762255.0
2016-02-25 11:00:00	SPY	ETF	193.26	193.56	193.02	193.47	5151870.0
2016-02-25 11:30:00	SPY	ETF	193.48	193.9	193.24	193.8	4779189.0
2016-02-25 12:00:00	SPY	ETF	193.8	193.94	193.62	193.702	2662598.0
2016-02-25 12:30:00	SPY	ETF	193.7	193.76	193.345	193.63	3540272.0
2016-02-25 13:00:00	SPY	ETF	193.63	194.125	193.57	194.12	5404656.0
2016-02-25 13:30:00	SPY	ETF	194.118	194.68	194.08	194.635	9179183.0
2016-02-25 14:00:00	SPY	ETF	194.63	194.82	194.42	194.62	6857193.0
2016-02-25 14:30:00	SPY	ETF	194.6125	194.69	194.32	194.435	4488871.0
2016-02-25 15:00:00	SPY	ETF	194.434	194.95	194.39	194.75	8855132.0
2016-02-25 15:30:00	SPY	ETF	194.75	195.54	194.64	195.53	18163282.0
2016-02-25 16:00:00	SPY	ETF	195.53	195.71	192.9162	195.63	5237186.0
2016-02-25 16:30:00	SPY	ETF	195.63	195.72	195.46	195.56	574052.0
2016-02-25 17:00:00	SPY	ETF	195.51	195.59	195.4	195.52	400602.0
2016-02-25 17:30:00	SPY	ETF	195.52	195.62	195.52	195.54	151725.0
2016-02-25 18:00:00	SPY	ETF	195.54	195.54	195.42	195.46	224615.0
2016-02-25 18:30:00	SPY	ETF	195.49	195.69	195.4	195.61	75952.0
2016-02-25 19:00:00	SPY	ETF	195.65	195.81	195.55	195.59	86235.0
2016-02-25 19:30:00	SPY	ETF	195.62	195.7	195.58	195.68	35944.0
2016-02-25 04:00:00	QQQ	ETF	102.48	102.62	102.48	102.59	450.0
2016-02-25 04:30:00	QQQ	ETF	102.52	102.52	102.38	102.43	7965.0
2016-02-25 05:00:00	QQQ	ETF	102.44	102.55	102.39	102.55	2300.0
2016-02-25 05:30:00	QQQ	ETF	102.77	102.77	102.77	102.77	300.0
2016-02-25 06:00:00	QQQ	ETF	102.72	102.72	102.62	102.67	2300.0
2016-02-25 06:30:00	QQQ	ETF	102.9	102.91	102.82	102.86	2424.0
2016-02-25 07:00:00	QQQ	ETF	102.94	103.05	102.87	102.87	46066.0
2016-02-25 07:30:00	QQQ	ETF	102.88	102.94	102.82	102.83	20956.0
2016-02-25 08:00:00	QQQ	ETF	102.81	102.81	102.55	102.69	215641.0
2016-02-25 08:30:00	QQQ	ETF	102.8	102.88	102.6	102.82	117280.0
2016-02-25 09:00:00	QQQ	ETF	102.86	102.99	102.75	102.75	64057.0
2016-02-25 09:30:00	QQQ	ETF	102.76	102.95	102.04	102.1	4123844.0
2016-02-25 10:00:00	QQQ	ETF	102.1	102.42	101.84	102.41	3394988.0
2016-02-25 10:30:00	QQQ	ETF	102.41	102.65	102.2	102.31	1847125.0
2016-02-25 11:00:00	QQQ	ETF	102.3	102.54	102.16	102.46	1021671.0
2016-02-25 11:30:00	QQQ	ETF	102.46	102.63	102.25	102.585	1229484.0
2016-02-25 12:00:00	QQQ	ETF	102.581	102.61	102.38	102.45	623044.0
2016-02-25 12:30:00	QQQ	ETF	102.44	102.44	102.19	102.389	923201.0

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

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