PREVIEW / etf_1hour / 2016-11-07

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-11-07.parquet
  size:    270 KB
  rows:    8,684

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-11-07 04:00:00	SPY	ETF	209.86	211.66	209.86	211.54	64674.0
2016-11-07 05:00:00	SPY	ETF	211.54	211.54	211.28	211.44	63645.0
2016-11-07 06:00:00	SPY	ETF	211.48	211.51	211.26	211.3	185177.0
2016-11-07 07:00:00	SPY	ETF	211.29	211.37	211.1	211.27	742306.0
2016-11-07 08:00:00	SPY	ETF	211.27	211.47	211.12	211.42	776647.0
2016-11-07 09:00:00	SPY	ETF	211.41	211.85	211.3	211.7589	13097025.0
2016-11-07 10:00:00	SPY	ETF	211.76	212.365	211.71	212.34	12788178.0
2016-11-07 11:00:00	SPY	ETF	212.34	212.79	212.32	212.78	12788202.0
2016-11-07 12:00:00	SPY	ETF	212.775	212.91	212.64	212.775	10730499.0
2016-11-07 13:00:00	SPY	ETF	212.7758	212.94	212.665	212.89	6613137.0
2016-11-07 14:00:00	SPY	ETF	212.89	212.93	212.46	212.57	10945122.0
2016-11-07 15:00:00	SPY	ETF	212.57	213.19	212.39	213.1	26522620.0
2016-11-07 16:00:00	SPY	ETF	213.12	213.52	213.05	213.46	10895307.0
2016-11-07 17:00:00	SPY	ETF	213.45	213.45	213.15	213.37	315456.0
2016-11-07 18:00:00	SPY	ETF	213.36	213.42	213.22	213.26	225404.0
2016-11-07 19:00:00	SPY	ETF	213.25	213.25	213.07	213.19	114310.0
2016-11-07 04:00:00	QQQ	ETF	115.35	115.6	115.32	115.57	15982.0
2016-11-07 05:00:00	QQQ	ETF	115.5	115.5	115.43	115.46	6920.0
2016-11-07 06:00:00	QQQ	ETF	115.49	115.5	115.35	115.36	64925.0
2016-11-07 07:00:00	QQQ	ETF	115.36	115.39	115.27	115.38	68567.0
2016-11-07 08:00:00	QQQ	ETF	115.37	115.48	115.27	115.41	253320.0
2016-11-07 09:00:00	QQQ	ETF	115.43	115.61	115.3	115.5737	3215409.0
2016-11-07 10:00:00	QQQ	ETF	115.58	116.078	115.57	116.078	3039197.0
2016-11-07 11:00:00	QQQ	ETF	116.08	116.4	116.08	116.36	2867591.0
2016-11-07 12:00:00	QQQ	ETF	116.37	116.4599	116.23	116.32	2238158.0
2016-11-07 13:00:00	QQQ	ETF	116.32	116.44	116.27	116.3885	1140406.0
2016-11-07 14:00:00	QQQ	ETF	116.39	116.42	116.04	116.13	1668365.0
2016-11-07 15:00:00	QQQ	ETF	116.13	116.47	116.03	116.36	5835887.0
2016-11-07 16:00:00	QQQ	ETF	116.355	116.64	116.2823	116.64	1270261.0
2016-11-07 17:00:00	QQQ	ETF	116.59	116.63	116.34	116.62	22815.0
2016-11-07 18:00:00	QQQ	ETF	116.6	116.6	116.44	116.49	18611.0
2016-11-07 19:00:00	QQQ	ETF	116.43	116.44	116.38	116.39	12225.0
2016-11-07 04:00:00	IWM	ETF	117.57	118.06	117.57	118.05	17017.0
2016-11-07 05:00:00	IWM	ETF	117.91	117.92	117.91	117.92	616.0
2016-11-07 06:00:00	IWM	ETF	117.97	117.97	117.8	117.84	70738.0
2016-11-07 07:00:00	IWM	ETF	117.81	117.86	117.71	117.8	109772.0
2016-11-07 08:00:00	IWM	ETF	117.8	118.1	117.8	118.01	256666.0
2016-11-07 09:00:00	IWM	ETF	118.05	118.15	117.7082	118.08	5479522.0
2016-11-07 10:00:00	IWM	ETF	118.08	118.48	118.01	118.46	4531894.0
2016-11-07 11:00:00	IWM	ETF	118.45	118.64	118.38	118.5438	2883141.0
2016-11-07 12:00:00	IWM	ETF	118.545	118.82	118.4678	118.52	2463948.0
2016-11-07 13:00:00	IWM	ETF	118.515	118.62	118.28	118.46	1785328.0
2016-11-07 14:00:00	IWM	ETF	118.46	118.52	118.23	118.29	1666980.0
2016-11-07 15:00:00	IWM	ETF	118.3	118.78	118.06	118.54	5512800.0
2016-11-07 16:00:00	IWM	ETF	118.54	118.83	118.2212	118.73	2454446.0
2016-11-07 17:00:00	IWM	ETF	118.71	118.71	118.57	118.7	234546.0
2016-11-07 18:00:00	IWM	ETF	118.7	118.78	118.57	118.62	756599.0
2016-11-07 19:00:00	IWM	ETF	118.61	118.69	118.57	118.6	7716.0
2016-11-07 07:00:00	DIA	ETF	181.49	181.49	180.93	180.93	1416.0
2016-11-07 08:00:00	DIA	ETF	181.5	181.5	180.89	181.22	11330.0

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

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