PREVIEW / etf_1hour / 2016-01-26

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-01-26.parquet
  size:    253 KB
  rows:    8,050

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-01-26 04:00:00	SPY	ETF	186.52	186.95	186.25	186.95	50157.0
2016-01-26 05:00:00	SPY	ETF	186.93	187.54	186.81	187.41	82740.0
2016-01-26 06:00:00	SPY	ETF	187.44	188.29	187.23	188.11	196750.0
2016-01-26 07:00:00	SPY	ETF	188.08	188.53	187.74	187.9	654394.0
2016-01-26 08:00:00	SPY	ETF	187.87	188.5	186.43	188.3	1466613.0
2016-01-26 09:00:00	SPY	ETF	188.32	189.17	188.02	188.26	15012488.0
2016-01-26 10:00:00	SPY	ETF	188.27	189.93	188.26	189.435	18268411.0
2016-01-26 11:00:00	SPY	ETF	189.43	189.95	189.23	189.535	26162420.0
2016-01-26 12:00:00	SPY	ETF	189.54	190.49	189.53	190.109	15806283.0
2016-01-26 13:00:00	SPY	ETF	190.11	190.53	189.96	190.07	15923101.0
2016-01-26 14:00:00	SPY	ETF	190.06	190.09	189.48	189.74	11657272.0
2016-01-26 15:00:00	SPY	ETF	189.74	190.28	189.36	190.18	24910928.0
2016-01-26 16:00:00	SPY	ETF	190.19	190.25	189.37	189.4	8074784.0
2016-01-26 17:00:00	SPY	ETF	189.36	190.24	189.2	189.22	423105.0
2016-01-26 18:00:00	SPY	ETF	189.22	189.45	188.74	189.28	645514.0
2016-01-26 19:00:00	SPY	ETF	189.32	189.43	188.95	189.4	204687.0
2016-01-26 20:00:00	SPY	ETF	190.1922	190.1922	190.1922	190.1922	278500.0
2016-01-26 04:00:00	QQQ	ETF	101.42	101.47	101.23	101.38	36896.0
2016-01-26 05:00:00	QQQ	ETF	101.91	102.06	101.78	102.03	4890.0
2016-01-26 06:00:00	QQQ	ETF	102.08	102.48	101.98	102.43	31000.0
2016-01-26 07:00:00	QQQ	ETF	102.41	102.65	102.22	102.32	167912.0
2016-01-26 08:00:00	QQQ	ETF	102.62	102.69	102.15	102.55	235677.0
2016-01-26 09:00:00	QQQ	ETF	102.58	102.81	101.76	101.89	5982791.0
2016-01-26 10:00:00	QQQ	ETF	101.9	102.99	101.89	102.68	5663141.0
2016-01-26 11:00:00	QQQ	ETF	102.67	103.11	102.66	102.89	3782201.0
2016-01-26 12:00:00	QQQ	ETF	102.895	103.45	102.89	103.24	2894094.0
2016-01-26 13:00:00	QQQ	ETF	103.24	103.59	103.14	103.23	2518675.0
2016-01-26 14:00:00	QQQ	ETF	103.235	103.24	102.83	102.9501	3353138.0
2016-01-26 15:00:00	QQQ	ETF	102.95	103.2	102.66	103.17	5120033.0
2016-01-26 16:00:00	QQQ	ETF	103.17	103.41	102.71	102.79	2105793.0
2016-01-26 17:00:00	QQQ	ETF	102.79	102.92	102.38	102.38	177277.0
2016-01-26 18:00:00	QQQ	ETF	102.4	102.61	102.17	102.44	107889.0
2016-01-26 19:00:00	QQQ	ETF	102.47	102.63	102.32	102.63	48790.0
2016-01-26 04:00:00	IWM	ETF	98.4	98.4	98.4	98.4	273.0
2016-01-26 05:00:00	IWM	ETF	98.72	99.01	98.72	99.01	1994.0
2016-01-26 06:00:00	IWM	ETF	99.09	99.39	98.93	99.39	12000.0
2016-01-26 07:00:00	IWM	ETF	99.38	99.6	99.12	99.2	200396.0
2016-01-26 08:00:00	IWM	ETF	99.2	99.58	99.04	99.44	174865.0
2016-01-26 09:00:00	IWM	ETF	99.43	100.32	99.18	99.33	4616139.0
2016-01-26 10:00:00	IWM	ETF	99.34	100.53	99.33	99.96	5447730.0
2016-01-26 11:00:00	IWM	ETF	99.95	100.67	99.93	100.57	3270308.0
2016-01-26 12:00:00	IWM	ETF	100.57	101.32	100.57	100.96	4436826.0
2016-01-26 13:00:00	IWM	ETF	100.96	101.4	100.92	100.935	2695483.0
2016-01-26 14:00:00	IWM	ETF	100.93	101.09	100.64	100.87	2985275.0
2016-01-26 15:00:00	IWM	ETF	100.86	101.16	100.52	101.1	6201322.0
2016-01-26 16:00:00	IWM	ETF	101.11	101.13	100.5	100.5	1386620.0
2016-01-26 17:00:00	IWM	ETF	100.5	100.6	100.18	100.18	36589.0
2016-01-26 18:00:00	IWM	ETF	100.18	100.43	100.18	100.43	1676.0
2016-01-26 19:00:00	IWM	ETF	100.35	100.42	100.35	100.42	1713.0
2016-01-26 06:00:00	DIA	ETF	158.5	158.64	158.4	158.4	800.0

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

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