PREVIEW / etf_30min / 2016-05-26

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-05-26.parquet
  size:    373 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
2016-05-26 04:00:00	SPY	ETF	209.44	209.44	209.26	209.26	38878.0
2016-05-26 04:30:00	SPY	ETF	209.19	209.34	209.16	209.18	2324.0
2016-05-26 05:00:00	SPY	ETF	209.29	209.33	209.28	209.28	3258.0
2016-05-26 05:30:00	SPY	ETF	209.32	209.37	209.32	209.34	1605.0
2016-05-26 06:00:00	SPY	ETF	209.39	209.51	209.32	209.51	4296.0
2016-05-26 06:30:00	SPY	ETF	209.49	209.62	209.49	209.55	7460.0
2016-05-26 07:00:00	SPY	ETF	209.5	209.52	209.42	209.43	22932.0
2016-05-26 07:30:00	SPY	ETF	209.42	209.65	209.42	209.6	162303.0
2016-05-26 08:00:00	SPY	ETF	209.46	209.69	209.151	209.59	297548.0
2016-05-26 08:30:00	SPY	ETF	209.6	209.63	209.38	209.45	283345.0
2016-05-26 09:00:00	SPY	ETF	209.45	209.57	209.41	209.47	241376.0
2016-05-26 09:30:00	SPY	ETF	209.44	209.71	209.01	209.0499	7802668.0
2016-05-26 10:00:00	SPY	ETF	209.05	209.47	209.05	209.34	4277386.0
2016-05-26 10:30:00	SPY	ETF	209.34	209.53	209.03	209.03	5121211.0
2016-05-26 11:00:00	SPY	ETF	209.03	209.33	208.97	209.3011	3565857.0
2016-05-26 11:30:00	SPY	ETF	209.31	209.3698	209.19	209.25	2150713.0
2016-05-26 12:00:00	SPY	ETF	209.26	209.4	209.1	209.17	2141610.0
2016-05-26 12:30:00	SPY	ETF	209.17	209.265	209.08	209.13	1744276.0
2016-05-26 13:00:00	SPY	ETF	209.13	209.37	209.06	209.317	1956301.0
2016-05-26 13:30:00	SPY	ETF	209.32	209.37	209.24	209.34	1707910.0
2016-05-26 14:00:00	SPY	ETF	209.34	209.52	209.29	209.435	2946645.0
2016-05-26 14:30:00	SPY	ETF	209.44	209.49	209.36	209.39	1848320.0
2016-05-26 15:00:00	SPY	ETF	209.4	209.6	209.39	209.47	3295399.0
2016-05-26 15:30:00	SPY	ETF	209.47	209.51	209.26	209.3264	8649512.0
2016-05-26 16:00:00	SPY	ETF	209.32	209.55	209.27	209.53	5134209.0
2016-05-26 16:30:00	SPY	ETF	209.53	209.65	209.34	209.61	242213.0
2016-05-26 17:00:00	SPY	ETF	209.62	209.62	209.59	209.61	39427.0
2016-05-26 17:30:00	SPY	ETF	209.61	209.64	209.6	209.62	10376.0
2016-05-26 18:00:00	SPY	ETF	209.61	209.61	209.53	209.6	54074.0
2016-05-26 18:30:00	SPY	ETF	209.58	209.62	209.58	209.6	8930.0
2016-05-26 19:00:00	SPY	ETF	209.62	209.62	209.58	209.62	14700.0
2016-05-26 19:30:00	SPY	ETF	209.62	209.7	209.59	209.67	80176.0
2016-05-26 04:00:00	QQQ	ETF	109.31	109.31	109.31	109.31	1714.0
2016-05-26 04:30:00	QQQ	ETF	109.28	109.28	109.28	109.28	300.0
2016-05-26 05:00:00	QQQ	ETF	109.28	109.28	109.28	109.28	110.0
2016-05-26 06:00:00	QQQ	ETF	109.37	109.4	109.37	109.4	200.0
2016-05-26 06:30:00	QQQ	ETF	109.45	109.46	109.45	109.46	932.0
2016-05-26 07:00:00	QQQ	ETF	109.39	109.39	109.38	109.38	800.0
2016-05-26 07:30:00	QQQ	ETF	109.37	109.49	109.37	109.45	5036.0
2016-05-26 08:00:00	QQQ	ETF	109.37	109.48	109.24	109.42	31542.0
2016-05-26 08:30:00	QQQ	ETF	109.5	109.5	109.34	109.4	13119.0
2016-05-26 09:00:00	QQQ	ETF	109.39	109.43	109.34	109.34	32553.0
2016-05-26 09:30:00	QQQ	ETF	109.35	109.5	109.11	109.12	3040425.0
2016-05-26 10:00:00	QQQ	ETF	109.13	109.42	109.09	109.3499	1489184.0
2016-05-26 10:30:00	QQQ	ETF	109.34	109.55	109.3	109.31	1571905.0
2016-05-26 11:00:00	QQQ	ETF	109.29	109.46	109.255	109.44	1059370.0
2016-05-26 11:30:00	QQQ	ETF	109.45	109.49	109.341	109.37	914751.0
2016-05-26 12:00:00	QQQ	ETF	109.37	109.44	109.3	109.325	657931.0
2016-05-26 12:30:00	QQQ	ETF	109.33	109.4	109.265	109.31	480313.0
2016-05-26 13:00:00	QQQ	ETF	109.31	109.47	109.28	109.455	515146.0

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

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