PREVIEW / etf_1hour / 2014-10-15

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-10-15.parquet
  size:    252 KB
  rows:    7,902

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
2014-10-15 04:00:00	SPY	ETF	187.83	187.83	187.27	187.36	73901.0
2014-10-15 05:00:00	SPY	ETF	187.33	187.82	187.15	187.67	333210.0
2014-10-15 06:00:00	SPY	ETF	187.63	187.87	187.5	187.52	299158.0
2014-10-15 07:00:00	SPY	ETF	187.54	187.69	186.3	186.34	1354902.0
2014-10-15 08:00:00	SPY	ETF	186.32	187.36	185.42	185.7	6769474.0
2014-10-15 09:00:00	SPY	ETF	185.69	187.83	183.65	185.87	52208121.0
2014-10-15 10:00:00	SPY	ETF	185.87	186.67	184.92	185.51	49935113.0
2014-10-15 11:00:00	SPY	ETF	185.51	186.14	184.26	184.8701	33614038.0
2014-10-15 12:00:00	SPY	ETF	184.88	184.89	183.22	183.41	30372236.0
2014-10-15 13:00:00	SPY	ETF	183.41	183.89	181.92	182.92	59689583.0
2014-10-15 14:00:00	SPY	ETF	182.92	187.694	182.45	184.74	51867072.0
2014-10-15 15:00:00	SPY	ETF	184.72	186.88	184.21	186.29	75881209.0
2014-10-15 16:00:00	SPY	ETF	186.33	187.694	183.905	185.12	14736972.0
2014-10-15 17:00:00	SPY	ETF	185.12	185.23	185.0	185.15	1530242.0
2014-10-15 18:00:00	SPY	ETF	185.19	185.38	184.81	185.12	329578.0
2014-10-15 19:00:00	SPY	ETF	185.11	185.45	184.92	185.25	138586.0
2014-10-15 04:00:00	QQQ	ETF	92.99	93.0	92.95	92.98	20300.0
2014-10-15 05:00:00	QQQ	ETF	92.98	93.08	92.89	93.08	10300.0
2014-10-15 06:00:00	QQQ	ETF	93.1	93.2	93.05	93.06	26197.0
2014-10-15 07:00:00	QQQ	ETF	93.13	93.13	92.4	92.4	274309.0
2014-10-15 08:00:00	QQQ	ETF	92.44	93.12	91.95	92.0	1282111.0
2014-10-15 09:00:00	QQQ	ETF	92.0	92.26	91.19	92.03	17997386.0
2014-10-15 10:00:00	QQQ	ETF	92.02	92.519	91.75	91.97	15660273.0
2014-10-15 11:00:00	QQQ	ETF	91.96	92.43	91.35	91.75	9447549.0
2014-10-15 12:00:00	QQQ	ETF	91.7442	91.7442	90.82	90.99	9295058.0
2014-10-15 13:00:00	QQQ	ETF	90.99	91.25	90.24	90.72	12273347.0
2014-10-15 14:00:00	QQQ	ETF	90.72	91.68	90.5	91.61	12789297.0
2014-10-15 15:00:00	QQQ	ETF	91.62	92.76	91.37	92.38	20588700.0
2014-10-15 16:00:00	QQQ	ETF	92.38	92.9553	91.4	91.55	3477786.0
2014-10-15 17:00:00	QQQ	ETF	91.55	91.73	91.5	91.7	68566.0
2014-10-15 18:00:00	QQQ	ETF	91.7	91.79	91.46	91.62	63957.0
2014-10-15 19:00:00	QQQ	ETF	91.61	91.81	91.52	91.67	33600.0
2014-10-15 05:00:00	IWM	ETF	105.6	105.7	105.6	105.7	700.0
2014-10-15 06:00:00	IWM	ETF	105.73	105.73	105.6	105.6	25375.0
2014-10-15 07:00:00	IWM	ETF	105.4	105.4	104.8	104.82	390270.0
2014-10-15 08:00:00	IWM	ETF	104.83	105.24	104.35	104.38	905895.0
2014-10-15 09:00:00	IWM	ETF	104.41	105.49	103.54	104.99	20326560.0
2014-10-15 10:00:00	IWM	ETF	104.99	105.92	104.88	105.18	15361185.0
2014-10-15 11:00:00	IWM	ETF	105.17	105.65	104.34	104.85	8633806.0
2014-10-15 12:00:00	IWM	ETF	104.85	104.96	104.25	104.47	7872912.0
2014-10-15 13:00:00	IWM	ETF	104.47	104.91	103.88	104.47	13067806.0
2014-10-15 14:00:00	IWM	ETF	104.49	105.16	103.94	104.985	12336626.0
2014-10-15 15:00:00	IWM	ETF	104.99	107.0	104.74	106.59	22441222.0
2014-10-15 16:00:00	IWM	ETF	106.6	106.64	105.423	106.02	4325919.0
2014-10-15 17:00:00	IWM	ETF	106.03	106.21	106.0	106.1	105695.0
2014-10-15 18:00:00	IWM	ETF	106.19	106.2	106.0	106.1	5634.0
2014-10-15 19:00:00	IWM	ETF	106.04	106.24	106.04	106.24	5003.0
2014-10-15 07:00:00	DIA	ETF	163.15	163.15	161.93	161.93	44299.0
2014-10-15 08:00:00	DIA	ETF	162.0	162.49	161.43	161.6	197984.0
2014-10-15 09:00:00	DIA	ETF	161.7	161.91	160.2	161.26	2883340.0

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

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