PREVIEW / etf_30min / 2016-12-06

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-12-06.parquet
  size:    431 KB
  rows:    14,618

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-12-06 04:00:00	SPY	ETF	220.97	221.04	220.93	220.95	5109.0
2016-12-06 04:30:00	SPY	ETF	220.95	221.05	220.95	221.05	3904.0
2016-12-06 05:00:00	SPY	ETF	221.12	221.22	221.05	221.05	6518.0
2016-12-06 05:30:00	SPY	ETF	221.0	221.0	220.97	220.97	7402.0
2016-12-06 06:00:00	SPY	ETF	221.04	221.1	221.02	221.07	5807.0
2016-12-06 06:30:00	SPY	ETF	221.1	221.16	221.07	221.1	4007.0
2016-12-06 07:00:00	SPY	ETF	221.11	221.12	221.02	221.1	10505.0
2016-12-06 07:30:00	SPY	ETF	221.06	221.26	221.06	221.22	69422.0
2016-12-06 08:00:00	SPY	ETF	221.07	221.4	221.07	221.4	240532.0
2016-12-06 08:30:00	SPY	ETF	221.37	221.47	221.27	221.32	107243.0
2016-12-06 09:00:00	SPY	ETF	221.32	221.39	221.19	221.22	464562.0
2016-12-06 09:30:00	SPY	ETF	221.22	221.24	220.72	220.81	5505783.0
2016-12-06 10:00:00	SPY	ETF	220.8	221.02	220.662	220.675	4037092.0
2016-12-06 10:30:00	SPY	ETF	220.68	221.12	220.68	221.02	3585590.0
2016-12-06 11:00:00	SPY	ETF	221.03	221.12	220.85	221.04	3562821.0
2016-12-06 11:30:00	SPY	ETF	221.04	221.11	220.85	221.09	3437551.0
2016-12-06 12:00:00	SPY	ETF	221.09	221.32	221.05	221.29	3981417.0
2016-12-06 12:30:00	SPY	ETF	221.295	221.41	221.22	221.31	2800203.0
2016-12-06 13:00:00	SPY	ETF	221.31	221.44	221.26	221.285	1941889.0
2016-12-06 13:30:00	SPY	ETF	221.29	221.44	221.2	221.4	3489144.0
2016-12-06 14:00:00	SPY	ETF	221.4	221.53	221.32	221.4327	2119998.0
2016-12-06 14:30:00	SPY	ETF	221.44	221.57	221.41	221.5566	2927488.0
2016-12-06 15:00:00	SPY	ETF	221.5588	221.61	221.3	221.33	3902013.0
2016-12-06 15:30:00	SPY	ETF	221.33	221.7441	221.33	221.69	10650041.0
2016-12-06 16:00:00	SPY	ETF	221.69	221.74	221.3201	221.6	3464238.0
2016-12-06 16:30:00	SPY	ETF	221.61	221.7	221.6	221.7	1059330.0
2016-12-06 17:00:00	SPY	ETF	221.7	221.75	221.62	221.71	221661.0
2016-12-06 17:30:00	SPY	ETF	221.72	221.76	221.7	221.72	149098.0
2016-12-06 18:00:00	SPY	ETF	221.73	221.74	221.68	221.71	103870.0
2016-12-06 18:30:00	SPY	ETF	221.71	221.71	221.61	221.66	73023.0
2016-12-06 19:00:00	SPY	ETF	221.63	221.64	221.59	221.59	17044.0
2016-12-06 19:30:00	SPY	ETF	221.62	221.74	221.61	221.72	33052.0
2016-12-06 04:00:00	QQQ	ETF	116.79	116.79	116.79	116.79	350.0
2016-12-06 05:00:00	QQQ	ETF	116.86	116.86	116.86	116.86	250.0
2016-12-06 06:00:00	QQQ	ETF	116.79	116.79	116.79	116.79	100.0
2016-12-06 06:30:00	QQQ	ETF	116.79	116.79	116.74	116.74	900.0
2016-12-06 07:00:00	QQQ	ETF	116.71	116.76	116.71	116.76	2099.0
2016-12-06 07:30:00	QQQ	ETF	116.79	116.94	116.79	116.93	12218.0
2016-12-06 08:00:00	QQQ	ETF	116.93	116.97	116.88	116.97	22625.0
2016-12-06 08:30:00	QQQ	ETF	116.96	116.98	116.87	116.91	65872.0
2016-12-06 09:00:00	QQQ	ETF	116.93	116.95	116.86	116.86	100712.0
2016-12-06 09:30:00	QQQ	ETF	116.88	116.93	116.39	116.905	2545376.0
2016-12-06 10:00:00	QQQ	ETF	116.895	117.08	116.522	116.55	1649453.0
2016-12-06 10:30:00	QQQ	ETF	116.56	116.88	116.56	116.75	1248222.0
2016-12-06 11:00:00	QQQ	ETF	116.75	116.79	116.57	116.65	764247.0
2016-12-06 11:30:00	QQQ	ETF	116.65	116.665	116.39	116.59	808335.0
2016-12-06 12:00:00	QQQ	ETF	116.59	116.68	116.54	116.619	663691.0
2016-12-06 12:30:00	QQQ	ETF	116.62	116.73	116.5	116.53	653554.0
2016-12-06 13:00:00	QQQ	ETF	116.53	116.65	116.52	116.54	353819.0
2016-12-06 13:30:00	QQQ	ETF	116.535	116.73	116.505	116.696	542780.0

> showing 50 of 14,618 rows — these rows as CSV

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