PREVIEW / etf_30min / 2016-10-18

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-10-18.parquet
  size:    401 KB
  rows:    13,729

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-10-18 04:00:00	SPY	ETF	213.68	213.8	213.61	213.64	20360.0
2016-10-18 04:30:00	SPY	ETF	213.68	213.9	213.68	213.76	15001.0
2016-10-18 05:00:00	SPY	ETF	213.74	213.78	213.71	213.71	30679.0
2016-10-18 05:30:00	SPY	ETF	213.78	213.78	213.68	213.69	27861.0
2016-10-18 06:00:00	SPY	ETF	213.68	213.73	213.58	213.73	6309.0
2016-10-18 06:30:00	SPY	ETF	213.73	213.78	213.67	213.67	4011.0
2016-10-18 07:00:00	SPY	ETF	213.69	213.89	213.62	213.87	212815.0
2016-10-18 07:30:00	SPY	ETF	213.87	214.07	213.8	213.92	377506.0
2016-10-18 08:00:00	SPY	ETF	213.94	214.07	213.67	213.96	377953.0
2016-10-18 08:30:00	SPY	ETF	214.0	214.34	213.98	214.09	913872.0
2016-10-18 09:00:00	SPY	ETF	214.1	214.26	214.05	214.26	463962.0
2016-10-18 09:30:00	SPY	ETF	214.24	214.29	213.53	213.6692	10201706.0
2016-10-18 10:00:00	SPY	ETF	213.665	213.76	213.27	213.41	5318001.0
2016-10-18 10:30:00	SPY	ETF	213.41	214.24	213.41	213.665	3797108.0
2016-10-18 11:00:00	SPY	ETF	213.67	213.9	213.61	213.89	5271680.0
2016-10-18 11:30:00	SPY	ETF	213.88	214.19	213.79	214.18	4354589.0
2016-10-18 12:00:00	SPY	ETF	214.175	214.31	214.08	214.145	4223064.0
2016-10-18 12:30:00	SPY	ETF	214.14	214.2	213.91	213.97	2775363.0
2016-10-18 13:00:00	SPY	ETF	213.97	214.09	213.94	214.02	2169389.0
2016-10-18 13:30:00	SPY	ETF	214.01	214.07	213.84	214.0001	2882218.0
2016-10-18 14:00:00	SPY	ETF	214.005	214.14	213.88	214.135	4213921.0
2016-10-18 14:30:00	SPY	ETF	214.135	214.18	213.93	214.08	3584975.0
2016-10-18 15:00:00	SPY	ETF	214.08	214.1	213.79	213.81	3365307.0
2016-10-18 15:30:00	SPY	ETF	213.81	213.9	213.67	213.69	11215691.0
2016-10-18 16:00:00	SPY	ETF	213.68	213.73	213.38	213.47	6363244.0
2016-10-18 16:30:00	SPY	ETF	213.47	214.0	213.47	213.56	823788.0
2016-10-18 17:00:00	SPY	ETF	213.58	213.6	213.53	213.53	36765.0
2016-10-18 17:30:00	SPY	ETF	213.52	213.71	213.52	213.58	197623.0
2016-10-18 18:00:00	SPY	ETF	213.57	213.63	213.52	213.63	50194.0
2016-10-18 18:30:00	SPY	ETF	213.6	213.65	213.55	213.6	24920.0
2016-10-18 19:00:00	SPY	ETF	213.6	213.65	213.6	213.63	5878.0
2016-10-18 19:30:00	SPY	ETF	213.6	213.65	213.6	213.65	13606.0
2016-10-18 04:00:00	QQQ	ETF	117.68	117.7	117.68	117.7	5166.0
2016-10-18 04:30:00	QQQ	ETF	117.75	117.83	117.75	117.83	1599.0
2016-10-18 05:00:00	QQQ	ETF	117.73	117.8	117.73	117.79	30406.0
2016-10-18 05:30:00	QQQ	ETF	117.8	117.8	117.72	117.72	21800.0
2016-10-18 06:00:00	QQQ	ETF	117.7	117.73	117.69	117.72	12312.0
2016-10-18 06:30:00	QQQ	ETF	117.79	117.8	117.74	117.74	18500.0
2016-10-18 07:00:00	QQQ	ETF	117.73	117.86	117.72	117.86	200254.0
2016-10-18 07:30:00	QQQ	ETF	117.85	117.95	117.84	117.93	145768.0
2016-10-18 08:00:00	QQQ	ETF	117.92	118.05	117.89	117.95	78690.0
2016-10-18 08:30:00	QQQ	ETF	117.97	118.2	117.96	118.14	204959.0
2016-10-18 09:00:00	QQQ	ETF	118.14	118.19	118.1	118.19	94607.0
2016-10-18 09:30:00	QQQ	ETF	118.18	118.25	117.94	118.05	2092213.0
2016-10-18 10:00:00	QQQ	ETF	118.05	118.11	117.8	117.89	1167727.0
2016-10-18 10:30:00	QQQ	ETF	117.89	118.11	117.89	118.08	885811.0
2016-10-18 11:00:00	QQQ	ETF	118.08	118.18	118.065	118.12	1146665.0
2016-10-18 11:30:00	QQQ	ETF	118.13	118.35	118.08	118.345	1226270.0
2016-10-18 12:00:00	QQQ	ETF	118.35	118.4	118.28	118.38	736935.0
2016-10-18 12:30:00	QQQ	ETF	118.38	118.41	118.24	118.3	718437.0

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

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