PREVIEW / etf_30min / 2016-09-28

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-09-28.parquet
  size:    399 KB
  rows:    13,418

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-09-28 04:00:00	SPY	ETF	215.76	216.08	215.76	215.89	39623.0
2016-09-28 04:30:00	SPY	ETF	215.88	215.9	215.84	215.89	2907.0
2016-09-28 05:00:00	SPY	ETF	215.81	215.81	215.16	215.19	21069.0
2016-09-28 05:30:00	SPY	ETF	215.14	215.27	215.1	215.26	17326.0
2016-09-28 06:00:00	SPY	ETF	215.24	215.36	215.21	215.36	7042.0
2016-09-28 06:30:00	SPY	ETF	215.36	215.6	215.36	215.56	90502.0
2016-09-28 07:00:00	SPY	ETF	215.55	215.6	215.51	215.59	62205.0
2016-09-28 07:30:00	SPY	ETF	215.6	215.75	215.47	215.59	111811.0
2016-09-28 08:00:00	SPY	ETF	215.59	215.7	215.08	215.63	193124.0
2016-09-28 08:30:00	SPY	ETF	215.63	215.72	215.48	215.51	247943.0
2016-09-28 09:00:00	SPY	ETF	215.51	215.84	215.51	215.83	438367.0
2016-09-28 09:30:00	SPY	ETF	215.83	216.0	215.66	215.78	6846374.0
2016-09-28 10:00:00	SPY	ETF	215.785	215.97	215.44	215.59	4182636.0
2016-09-28 10:30:00	SPY	ETF	215.59	215.73	214.97	215.0894	7255079.0
2016-09-28 11:00:00	SPY	ETF	215.08	215.08	214.71	215.0111	5364499.0
2016-09-28 11:30:00	SPY	ETF	215.02	215.28	214.8	215.22	4103225.0
2016-09-28 12:00:00	SPY	ETF	215.22	215.41	215.03	215.16	3229500.0
2016-09-28 12:30:00	SPY	ETF	215.165	215.4	214.965	215.25	2213128.0
2016-09-28 13:00:00	SPY	ETF	215.24	215.4	215.03	215.36	2397534.0
2016-09-28 13:30:00	SPY	ETF	215.37	215.67	215.37	215.56	4815580.0
2016-09-28 14:00:00	SPY	ETF	215.555	216.53	215.46	216.3699	9585933.0
2016-09-28 14:30:00	SPY	ETF	216.37	216.6	216.16	216.47	7961423.0
2016-09-28 15:00:00	SPY	ETF	216.47	216.5	216.21	216.25	5878320.0
2016-09-28 15:30:00	SPY	ETF	216.25	216.82	216.145	216.68	13417377.0
2016-09-28 16:00:00	SPY	ETF	216.69	216.7	215.5643	216.59	5801882.0
2016-09-28 16:30:00	SPY	ETF	216.59	216.64	216.53	216.56	329650.0
2016-09-28 17:00:00	SPY	ETF	216.56	216.58	215.28	216.56	306155.0
2016-09-28 17:30:00	SPY	ETF	216.55	216.56	216.53	216.53	20432.0
2016-09-28 18:00:00	SPY	ETF	216.53	216.64	216.48	216.55	161855.0
2016-09-28 18:30:00	SPY	ETF	216.54	216.54	216.5	216.53	35091.0
2016-09-28 19:00:00	SPY	ETF	216.54	216.61	216.48	216.57	43955.0
2016-09-28 19:30:00	SPY	ETF	216.57	216.71	216.56	216.63	61536.0
2016-09-28 04:00:00	QQQ	ETF	118.71	118.77	118.71	118.74	2682.0
2016-09-28 04:30:00	QQQ	ETF	118.68	118.68	118.68	118.68	424.0
2016-09-28 05:00:00	QQQ	ETF	118.64	118.64	118.25	118.25	22099.0
2016-09-28 05:30:00	QQQ	ETF	118.29	118.36	118.27	118.35	2549.0
2016-09-28 06:30:00	QQQ	ETF	118.51	118.54	118.47	118.53	15200.0
2016-09-28 07:00:00	QQQ	ETF	118.5	118.53	118.46	118.46	3570.0
2016-09-28 07:30:00	QQQ	ETF	118.57	118.61	118.5	118.5	10880.0
2016-09-28 08:00:00	QQQ	ETF	118.53	118.61	118.53	118.54	57137.0
2016-09-28 08:30:00	QQQ	ETF	118.59	118.59	118.48	118.5	55142.0
2016-09-28 09:00:00	QQQ	ETF	118.53	118.64	118.53	118.63	79304.0
2016-09-28 09:30:00	QQQ	ETF	118.62	118.67	118.5	118.57	1636762.0
2016-09-28 10:00:00	QQQ	ETF	118.57	118.72	118.39	118.55	916376.0
2016-09-28 10:30:00	QQQ	ETF	118.55	118.6093	118.24	118.29	998981.0
2016-09-28 11:00:00	QQQ	ETF	118.28	118.3	118.1085	118.24	853925.0
2016-09-28 11:30:00	QQQ	ETF	118.24	118.38	118.09	118.36	961759.0
2016-09-28 12:00:00	QQQ	ETF	118.36	118.42	118.24	118.29	633516.0
2016-09-28 12:30:00	QQQ	ETF	118.295	118.42	118.2	118.362	363609.0
2016-09-28 13:00:00	QQQ	ETF	118.355	118.41	118.22	118.39	286665.0

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

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