PREVIEW / etf_1hour / 2015-09-18

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-09-18.parquet
  size:    243 KB
  rows:    7,784

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-18 04:00:00	SPY	ETF	198.81	198.96	198.18	198.32	62461.0
2015-09-18 05:00:00	SPY	ETF	198.3	198.64	197.81	197.92	44239.0
2015-09-18 06:00:00	SPY	ETF	197.91	197.97	196.92	197.1	211688.0
2015-09-18 07:00:00	SPY	ETF	197.05	197.16	196.34	196.53	952774.0
2015-09-18 08:00:00	SPY	ETF	196.53	197.68	196.14	196.47	3023236.0
2015-09-18 09:00:00	SPY	ETF	196.45	196.72	195.25	196.08	36193797.0
2015-09-18 10:00:00	SPY	ETF	196.09	197.33	195.92	196.9	31625151.0
2015-09-18 11:00:00	SPY	ETF	196.9	197.56	196.6	197.2	15065047.0
2015-09-18 12:00:00	SPY	ETF	197.2	197.25	196.09	196.365	15998084.0
2015-09-18 13:00:00	SPY	ETF	196.3799	196.7	195.54	195.64	18609439.0
2015-09-18 14:00:00	SPY	ETF	195.63	196.48	195.52	196.14	31565627.0
2015-09-18 15:00:00	SPY	ETF	196.15	198.6844	194.96	195.42	44942009.0
2015-09-18 16:00:00	SPY	ETF	195.41	197.103	195.29	195.57	19817836.0
2015-09-18 17:00:00	SPY	ETF	195.6	195.86	195.58	195.65	1154366.0
2015-09-18 18:00:00	SPY	ETF	195.65	195.79	195.59	195.65	526514.0
2015-09-18 19:00:00	SPY	ETF	195.64	195.66	195.44	195.62	104757.0
2015-09-18 04:00:00	QQQ	ETF	106.78	106.85	106.54	106.54	33400.0
2015-09-18 05:00:00	QQQ	ETF	106.66	106.66	106.36	106.36	8350.0
2015-09-18 06:00:00	QQQ	ETF	106.42	106.42	105.86	105.98	41910.0
2015-09-18 07:00:00	QQQ	ETF	105.98	105.98	105.55	105.72	153631.0
2015-09-18 08:00:00	QQQ	ETF	105.71	105.85	105.52	105.73	281992.0
2015-09-18 09:00:00	QQQ	ETF	105.71	105.97	105.08	105.7	8189585.0
2015-09-18 10:00:00	QQQ	ETF	105.7	106.35	105.61	106.04	5127411.0
2015-09-18 11:00:00	QQQ	ETF	106.05	106.6	106.02	106.37	3945157.0
2015-09-18 12:00:00	QQQ	ETF	106.39	106.405	105.68	105.85	3061357.0
2015-09-18 13:00:00	QQQ	ETF	105.85	106.04	105.294	105.345	3603496.0
2015-09-18 14:00:00	QQQ	ETF	105.34	105.92	105.28	105.73	3086184.0
2015-09-18 15:00:00	QQQ	ETF	105.73	105.86	105.17	105.36	7514917.0
2015-09-18 16:00:00	QQQ	ETF	105.36	105.78	105.3	105.56	1766633.0
2015-09-18 17:00:00	QQQ	ETF	105.58	105.7	105.58	105.61	15547.0
2015-09-18 18:00:00	QQQ	ETF	105.55	105.65	105.55	105.65	1503850.0
2015-09-18 19:00:00	QQQ	ETF	105.58	105.64	105.58	105.61	7404.0
2015-09-18 06:00:00	IWM	ETF	117.0	117.0	116.57	116.57	1600.0
2015-09-18 07:00:00	IWM	ETF	116.58	116.58	116.29	116.45	43300.0
2015-09-18 08:00:00	IWM	ETF	116.29	116.5	116.16	116.36	175494.0
2015-09-18 09:00:00	IWM	ETF	116.35	116.51	115.51	116.31	4960286.0
2015-09-18 10:00:00	IWM	ETF	116.3	116.73	115.99	116.46	6318621.0
2015-09-18 11:00:00	IWM	ETF	116.47	116.84	116.29	116.585	3101063.0
2015-09-18 12:00:00	IWM	ETF	116.59	116.62	116.05	116.32	2637230.0
2015-09-18 13:00:00	IWM	ETF	116.31	116.52	115.785	115.83	3034607.0
2015-09-18 14:00:00	IWM	ETF	115.83	116.19	115.68	116.01	2858328.0
2015-09-18 15:00:00	IWM	ETF	116.01	116.12	115.4	115.71	9138531.0
2015-09-18 16:00:00	IWM	ETF	115.72	116.31	115.66	115.99	2233963.0
2015-09-18 17:00:00	IWM	ETF	115.99	116.11	115.99	116.1	1269646.0
2015-09-18 18:00:00	IWM	ETF	116.0	116.15	116.0	116.15	3700.0
2015-09-18 07:00:00	DIA	ETF	164.75	166.76	164.75	164.75	4303.0
2015-09-18 08:00:00	DIA	ETF	165.4	165.4	164.28	164.78	10892.0
2015-09-18 09:00:00	DIA	ETF	164.75	164.75	163.59	163.83	1348817.0
2015-09-18 10:00:00	DIA	ETF	163.84	164.94	163.71	164.69	1758718.0
2015-09-18 11:00:00	DIA	ETF	164.7	165.24	164.42	164.97	1196832.0

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

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