PREVIEW / etf_1hour / 2016-12-05

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-12-05.parquet
  size:    275 KB
  rows:    8,827

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-05 04:00:00	SPY	ETF	220.54	221.0	220.04	220.72	22463.0
2016-12-05 05:00:00	SPY	ETF	220.7	220.7	220.45	220.51	11602.0
2016-12-05 06:00:00	SPY	ETF	220.6	220.76	220.56	220.7	48579.0
2016-12-05 07:00:00	SPY	ETF	220.72	220.76	220.44	220.57	208872.0
2016-12-05 08:00:00	SPY	ETF	220.53	220.75	220.37	220.55	221359.0
2016-12-05 09:00:00	SPY	ETF	220.55	221.18	220.42	221.1	8033093.0
2016-12-05 10:00:00	SPY	ETF	221.11	221.4	220.99	221.195	9036596.0
2016-12-05 11:00:00	SPY	ETF	221.19	221.3	220.87	220.99	5508233.0
2016-12-05 12:00:00	SPY	ETF	220.9989	221.03	220.72	220.935	6091318.0
2016-12-05 13:00:00	SPY	ETF	220.94	221.03	220.77	220.795	3742214.0
2016-12-05 14:00:00	SPY	ETF	220.8	220.82	220.5	220.72	9517970.0
2016-12-05 15:00:00	SPY	ETF	220.72	220.97	220.72	220.92	16475561.0
2016-12-05 16:00:00	SPY	ETF	220.92	221.15	220.7726	221.1	4610134.0
2016-12-05 17:00:00	SPY	ETF	221.09	221.15	221.0	221.13	125426.0
2016-12-05 18:00:00	SPY	ETF	221.13	221.13	220.87	221.08	205979.0
2016-12-05 19:00:00	SPY	ETF	221.11	221.14	220.99	221.02	35630.0
2016-12-05 04:00:00	QQQ	ETF	116.43	116.44	116.22	116.31	53993.0
2016-12-05 05:00:00	QQQ	ETF	116.31	116.32	116.17	116.2	25137.0
2016-12-05 06:00:00	QQQ	ETF	116.13	116.25	116.13	116.19	16354.0
2016-12-05 07:00:00	QQQ	ETF	116.24	116.31	116.11	116.16	98940.0
2016-12-05 08:00:00	QQQ	ETF	116.19	116.3	116.08	116.17	139648.0
2016-12-05 09:00:00	QQQ	ETF	116.18	116.62	115.77	116.54	3436498.0
2016-12-05 10:00:00	QQQ	ETF	116.55	117.06	116.5319	116.92	4404752.0
2016-12-05 11:00:00	QQQ	ETF	116.93	116.98	116.5443	116.61	1735850.0
2016-12-05 12:00:00	QQQ	ETF	116.63	116.72	116.34	116.68	1787643.0
2016-12-05 13:00:00	QQQ	ETF	116.68	116.72	116.48	116.52	923470.0
2016-12-05 14:00:00	QQQ	ETF	116.511	116.595	116.39	116.56	1869210.0
2016-12-05 15:00:00	QQQ	ETF	116.55	116.69	116.53	116.6	3983639.0
2016-12-05 16:00:00	QQQ	ETF	116.6	116.78	116.59	116.74	491127.0
2016-12-05 17:00:00	QQQ	ETF	116.59	116.71	116.59	116.71	99400.0
2016-12-05 18:00:00	QQQ	ETF	116.71	116.75	116.6	116.73	9195.0
2016-12-05 19:00:00	QQQ	ETF	116.73	116.77	116.71	116.74	8140.0
2016-12-05 04:00:00	IWM	ETF	131.7	131.71	131.7	131.71	380.0
2016-12-05 05:00:00	IWM	ETF	131.7	131.7	131.7	131.7	246.0
2016-12-05 06:00:00	IWM	ETF	131.9	131.95	131.79	131.95	1114.0
2016-12-05 07:00:00	IWM	ETF	131.95	131.95	131.85	131.86	89502.0
2016-12-05 08:00:00	IWM	ETF	131.85	131.94	131.74	131.9	37618.0
2016-12-05 09:00:00	IWM	ETF	131.89	132.99	131.88	132.95	4576445.0
2016-12-05 10:00:00	IWM	ETF	132.96	133.18	132.64	132.75	4325200.0
2016-12-05 11:00:00	IWM	ETF	132.76	132.885	132.62	132.68	1881154.0
2016-12-05 12:00:00	IWM	ETF	132.68	132.97	132.57	132.92	2197790.0
2016-12-05 13:00:00	IWM	ETF	132.93	133.0365	132.77	132.9	1620796.0
2016-12-05 14:00:00	IWM	ETF	132.91	133.08	132.55	132.87	2696246.0
2016-12-05 15:00:00	IWM	ETF	132.87	133.33	132.86	133.18	5284367.0
2016-12-05 16:00:00	IWM	ETF	133.17	133.54	133.15	133.5	1019239.0
2016-12-05 17:00:00	IWM	ETF	133.49	133.57	133.47	133.57	13729.0
2016-12-05 18:00:00	IWM	ETF	133.42	133.42	133.22	133.35	13310.0
2016-12-05 19:00:00	IWM	ETF	133.35	133.48	133.35	133.47	1970.0
2016-12-05 05:00:00	DIA	ETF	192.25	192.42	192.25	192.42	470.0
2016-12-05 06:00:00	DIA	ETF	192.47	192.47	192.47	192.47	100.0

> showing 50 of 8,827 rows — these rows as CSV

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