PREVIEW / etf_1hour / 2016-12-28

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-12-28.parquet
  size:    272 KB
  rows:    8,832

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-28 04:00:00	SPY	ETF	226.27	226.38	226.27	226.38	3673.0
2016-12-28 05:00:00	SPY	ETF	226.39	226.44	226.39	226.44	8002.0
2016-12-28 06:00:00	SPY	ETF	226.43	226.45	226.38	226.41	4302.0
2016-12-28 07:00:00	SPY	ETF	226.44	226.45	226.37	226.45	176448.0
2016-12-28 08:00:00	SPY	ETF	226.45	226.57	226.43	226.55	380618.0
2016-12-28 09:00:00	SPY	ETF	226.56	226.63	225.5	225.53	5957544.0
2016-12-28 10:00:00	SPY	ETF	225.52	225.59	225.32	225.45	9292528.0
2016-12-28 11:00:00	SPY	ETF	225.44	225.72	225.4	225.4	6235501.0
2016-12-28 12:00:00	SPY	ETF	225.4	225.41	224.58	224.8	9802920.0
2016-12-28 13:00:00	SPY	ETF	224.7959	224.88	224.56	224.61	3694950.0
2016-12-28 14:00:00	SPY	ETF	224.61	226.2518	224.35	224.585	6280135.0
2016-12-28 15:00:00	SPY	ETF	224.58	224.72	224.27	224.43	11403459.0
2016-12-28 16:00:00	SPY	ETF	224.42	224.56	224.33	224.4	7451084.0
2016-12-28 17:00:00	SPY	ETF	224.41	224.44	224.39	224.44	29233.0
2016-12-28 18:00:00	SPY	ETF	224.44	224.58	224.44	224.56	58333.0
2016-12-28 19:00:00	SPY	ETF	224.52	224.54	224.49	224.49	13785.0
2016-12-28 04:00:00	QQQ	ETF	120.77	121.03	120.77	121.03	1517.0
2016-12-28 07:00:00	QQQ	ETF	121.05	121.07	121.04	121.06	12838.0
2016-12-28 08:00:00	QQQ	ETF	121.05	121.17	121.01	121.1	75240.0
2016-12-28 09:00:00	QQQ	ETF	121.12	121.19	120.41	120.44	2827280.0
2016-12-28 10:00:00	QQQ	ETF	120.44	120.56	120.2	120.31	2786045.0
2016-12-28 11:00:00	QQQ	ETF	120.31	120.61	120.28	120.36	971259.0
2016-12-28 12:00:00	QQQ	ETF	120.36	120.36	119.94	120.03	1638733.0
2016-12-28 13:00:00	QQQ	ETF	120.04	120.11	119.9	119.94	994166.0
2016-12-28 14:00:00	QQQ	ETF	119.95	120.06	119.85	120.015	1066695.0
2016-12-28 15:00:00	QQQ	ETF	120.015	120.1	119.795	119.9	3531381.0
2016-12-28 16:00:00	QQQ	ETF	119.9	120.0066	119.84	119.86	492914.0
2016-12-28 17:00:00	QQQ	ETF	119.9	119.9	119.86	119.89	2094.0
2016-12-28 18:00:00	QQQ	ETF	119.9	119.95	119.89	119.93	7104.0
2016-12-28 19:00:00	QQQ	ETF	119.87	119.89	119.86	119.86	2980.0
2016-12-28 04:00:00	IWM	ETF	136.67	136.67	136.67	136.67	500.0
2016-12-28 05:00:00	IWM	ETF	136.7	136.74	136.7	136.74	500.0
2016-12-28 06:00:00	IWM	ETF	136.74	136.74	136.74	136.74	200.0
2016-12-28 07:00:00	IWM	ETF	136.75	136.75	136.71	136.71	2265.0
2016-12-28 08:00:00	IWM	ETF	136.78	136.92	136.77	136.77	57622.0
2016-12-28 09:00:00	IWM	ETF	136.88	136.98	136.08	136.1101	2348028.0
2016-12-28 10:00:00	IWM	ETF	136.12	136.1412	135.47	135.7063	3716664.0
2016-12-28 11:00:00	IWM	ETF	135.7	136.155	135.6786	135.83	1667434.0
2016-12-28 12:00:00	IWM	ETF	135.82	135.82	135.15	135.37	2376547.0
2016-12-28 13:00:00	IWM	ETF	135.38	135.385	134.92	134.9711	1591845.0
2016-12-28 14:00:00	IWM	ETF	134.98	135.19	134.83	135.05	1982967.0
2016-12-28 15:00:00	IWM	ETF	135.045	135.3099	134.93	135.22	4672911.0
2016-12-28 16:00:00	IWM	ETF	135.25	135.37	135.1	135.24	677969.0
2016-12-28 17:00:00	IWM	ETF	135.16	135.16	135.1	135.1	4013.0
2016-12-28 18:00:00	IWM	ETF	135.23	135.26	135.16	135.26	2050.0
2016-12-28 19:00:00	IWM	ETF	135.24	135.24	135.2	135.2	1102.0
2016-12-28 08:00:00	DIA	ETF	199.49	199.49	199.49	199.49	12600.0
2016-12-28 09:00:00	DIA	ETF	199.43	199.56	198.96	198.98	602489.0
2016-12-28 10:00:00	DIA	ETF	198.98	199.08	198.8605	198.96	400651.0
2016-12-28 11:00:00	DIA	ETF	198.96	199.19	198.95	198.98	213259.0

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

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