PREVIEW / etf_1hour / 2015-09-10

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-09-10.parquet
  size:    238 KB
  rows:    7,613

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
2015-09-10 04:00:00	SPY	ETF	196.1	196.2	195.09	195.66	147652.0
2015-09-10 05:00:00	SPY	ETF	195.56	197.45	195.56	197.0	130338.0
2015-09-10 06:00:00	SPY	ETF	196.98	197.09	195.46	195.68	264486.0
2015-09-10 07:00:00	SPY	ETF	195.6	195.66	193.72	194.78	1021406.0
2015-09-10 08:00:00	SPY	ETF	194.8	195.61	193.6	194.01	4944317.0
2015-09-10 09:00:00	SPY	ETF	194.01	195.42	194.01	194.51	15769511.0
2015-09-10 10:00:00	SPY	ETF	194.52	196.32	194.25	195.93	24189652.0
2015-09-10 11:00:00	SPY	ETF	195.92	195.95	194.86	195.73	19531821.0
2015-09-10 12:00:00	SPY	ETF	195.74	196.24	195.465	195.86	11534557.0
2015-09-10 13:00:00	SPY	ETF	195.87	197.22	195.64	196.79	15492306.0
2015-09-10 14:00:00	SPY	ETF	196.79	196.97	195.91	195.93	15977461.0
2015-09-10 15:00:00	SPY	ETF	195.92	196.235	195.08	195.88	34401167.0
2015-09-10 16:00:00	SPY	ETF	195.85	196.0	195.43	195.8	10366137.0
2015-09-10 17:00:00	SPY	ETF	195.85	195.94	195.67	195.69	3831271.0
2015-09-10 18:00:00	SPY	ETF	195.72	196.02	195.61	196.01	121969.0
2015-09-10 19:00:00	SPY	ETF	196.03	196.09	195.5	195.57	127037.0
2015-09-10 04:00:00	QQQ	ETF	104.46	104.54	104.1	104.25	32626.0
2015-09-10 05:00:00	QQQ	ETF	104.4	105.2	104.25	104.96	5600.0
2015-09-10 06:00:00	QQQ	ETF	104.93	105.0	104.21	104.25	19050.0
2015-09-10 07:00:00	QQQ	ETF	104.27	104.27	103.78	103.84	56096.0
2015-09-10 08:00:00	QQQ	ETF	103.85	104.11	103.26	103.45	451006.0
2015-09-10 09:00:00	QQQ	ETF	103.47	104.35	103.47	103.94	5738215.0
2015-09-10 10:00:00	QQQ	ETF	103.94	105.21	103.72	104.935	8251824.0
2015-09-10 11:00:00	QQQ	ETF	104.93	104.96	104.27	104.73	4714903.0
2015-09-10 12:00:00	QQQ	ETF	104.74	105.07	104.66	104.89	3240510.0
2015-09-10 13:00:00	QQQ	ETF	104.89	105.68	104.7338	105.35	5556631.0
2015-09-10 14:00:00	QQQ	ETF	105.35	105.43	104.84	104.85	2821606.0
2015-09-10 15:00:00	QQQ	ETF	104.84	105.05	104.44	104.95	8750596.0
2015-09-10 16:00:00	QQQ	ETF	104.95	105.01	104.74	104.95	561404.0
2015-09-10 17:00:00	QQQ	ETF	104.97	105.05	104.93	104.93	13001.0
2015-09-10 18:00:00	QQQ	ETF	104.92	105.12	104.85	105.12	25687.0
2015-09-10 19:00:00	QQQ	ETF	105.1	105.12	104.79	104.79	7586.0
2015-09-10 04:00:00	IWM	ETF	114.74	114.74	114.74	114.74	100.0
2015-09-10 05:00:00	IWM	ETF	114.75	115.11	114.75	115.11	750.0
2015-09-10 06:00:00	IWM	ETF	115.09	115.09	114.5	114.55	800.0
2015-09-10 07:00:00	IWM	ETF	114.59	114.59	113.93	113.95	22316.0
2015-09-10 08:00:00	IWM	ETF	114.01	114.11	113.4	113.4	457157.0
2015-09-10 09:00:00	IWM	ETF	113.44	114.58	113.44	114.18	4484136.0
2015-09-10 10:00:00	IWM	ETF	114.195	115.28	113.96	115.04	5685126.0
2015-09-10 11:00:00	IWM	ETF	115.01	115.09	114.42	115.0	3414227.0
2015-09-10 12:00:00	IWM	ETF	115.01	115.24	114.625	114.75	2409948.0
2015-09-10 13:00:00	IWM	ETF	114.74	115.28	114.64	114.96	2752307.0
2015-09-10 14:00:00	IWM	ETF	114.97	115.045	114.39	114.42	2533667.0
2015-09-10 15:00:00	IWM	ETF	114.42	114.7	114.26	114.67	4568658.0
2015-09-10 16:00:00	IWM	ETF	114.66	114.75	114.42	114.52	900643.0
2015-09-10 17:00:00	IWM	ETF	114.55	114.58	114.55	114.58	7640.0
2015-09-10 18:00:00	IWM	ETF	114.5	114.5	114.5	114.5	300.0
2015-09-10 19:00:00	IWM	ETF	114.56	114.63	114.41	114.45	3945.0
2015-09-10 04:00:00	DIA	ETF	163.66	163.66	163.52	163.52	332.0
2015-09-10 05:00:00	DIA	ETF	164.51	164.51	164.51	164.51	100.0

> showing 50 of 7,613 rows — these rows as CSV

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