PREVIEW / etf_1hour / 2017-08-03

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-08-03.parquet
  size:    276 KB
  rows:    9,054

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
2017-08-03 04:00:00	SPY	ETF	246.91	247.11	246.91	247.11	15720.0
2017-08-03 05:00:00	SPY	ETF	247.29	247.29	247.14	247.14	1350.0
2017-08-03 06:00:00	SPY	ETF	247.19	247.39	247.16	247.31	48100.0
2017-08-03 07:00:00	SPY	ETF	247.31	247.31	247.11	247.29	82048.0
2017-08-03 08:00:00	SPY	ETF	247.24	247.48	247.16	247.46	249350.0
2017-08-03 09:00:00	SPY	ETF	247.46	247.46	246.91	246.99	3864968.0
2017-08-03 10:00:00	SPY	ETF	246.99	247.29	246.84	247.23	5831488.0
2017-08-03 11:00:00	SPY	ETF	247.23	247.31	246.93	246.95	3890547.0
2017-08-03 12:00:00	SPY	ETF	246.95	247.13	246.9	247.01	3088797.0
2017-08-03 13:00:00	SPY	ETF	247.0133	247.17	246.79	247.1	3921136.0
2017-08-03 14:00:00	SPY	ETF	247.1	247.18	246.97	247.005	2557760.0
2017-08-03 15:00:00	SPY	ETF	247.005	247.23	246.64	246.98	10731928.0
2017-08-03 16:00:00	SPY	ETF	246.97	247.31	246.94	247.08	4834782.0
2017-08-03 17:00:00	SPY	ETF	247.08	247.14	246.96	247.11	288124.0
2017-08-03 18:00:00	SPY	ETF	247.05	247.12	247.01	247.06	63617.0
2017-08-03 19:00:00	SPY	ETF	247.06	247.06	246.88	246.91	52163.0
2017-08-03 04:00:00	QQQ	ETF	143.69	143.78	143.67	143.75	2870.0
2017-08-03 05:00:00	QQQ	ETF	143.89	143.89	143.89	143.89	100.0
2017-08-03 06:00:00	QQQ	ETF	143.99	144.18	143.96	144.17	6700.0
2017-08-03 07:00:00	QQQ	ETF	144.05	144.08	144.03	144.05	2475.0
2017-08-03 08:00:00	QQQ	ETF	144.19	144.25	144.07	144.22	35773.0
2017-08-03 09:00:00	QQQ	ETF	144.22	144.23	143.395	143.53	3461936.0
2017-08-03 10:00:00	QQQ	ETF	143.52	143.78	143.13	143.75	4926714.0
2017-08-03 11:00:00	QQQ	ETF	143.74	143.88	143.46	143.49	1849185.0
2017-08-03 12:00:00	QQQ	ETF	143.49	143.75	143.42	143.6	1560283.0
2017-08-03 13:00:00	QQQ	ETF	143.6	143.62	143.28	143.57	1643272.0
2017-08-03 14:00:00	QQQ	ETF	143.57	143.6868	143.49	143.57	2450102.0
2017-08-03 15:00:00	QQQ	ETF	143.57	143.72	143.185	143.4246	7504593.0
2017-08-03 16:00:00	QQQ	ETF	143.41	143.634	143.38	143.39	772049.0
2017-08-03 17:00:00	QQQ	ETF	143.47	143.47	143.35	143.39	9101.0
2017-08-03 18:00:00	QQQ	ETF	143.43	143.43	143.3	143.39	16723.0
2017-08-03 19:00:00	QQQ	ETF	143.36	143.36	143.28	143.29	14350.0
2017-08-03 04:00:00	IWM	ETF	139.94	139.94	139.94	139.94	2610.0
2017-08-03 05:00:00	IWM	ETF	140.26	140.26	140.26	140.26	1509.0
2017-08-03 06:00:00	IWM	ETF	140.35	140.4	140.35	140.4	2583.0
2017-08-03 07:00:00	IWM	ETF	140.3	140.3	140.17	140.2	6406.0
2017-08-03 08:00:00	IWM	ETF	140.31	140.48	140.3	140.44	44190.0
2017-08-03 09:00:00	IWM	ETF	140.37	140.54	140.05	140.2	1773993.0
2017-08-03 10:00:00	IWM	ETF	140.18	140.27	139.84	140.09	2509282.0
2017-08-03 11:00:00	IWM	ETF	140.09	140.17	139.81	139.95	2003095.0
2017-08-03 12:00:00	IWM	ETF	139.945	140.05	139.81	139.99	1378741.0
2017-08-03 13:00:00	IWM	ETF	139.99	140.02	139.48	139.76	1944448.0
2017-08-03 14:00:00	IWM	ETF	139.76	139.77	139.47	139.52	1593823.0
2017-08-03 15:00:00	IWM	ETF	139.52	139.64	139.16	139.55	5181728.0
2017-08-03 16:00:00	IWM	ETF	139.53	139.77	139.4506	139.55	843478.0
2017-08-03 17:00:00	IWM	ETF	139.51	139.64	139.44	139.61	331809.0
2017-08-03 18:00:00	IWM	ETF	139.54	139.64	139.54	139.59	1392.0
2017-08-03 19:00:00	IWM	ETF	139.59	139.6	139.53	139.54	3899.0
2017-08-03 07:00:00	DIA	ETF	219.78	219.78	219.78	219.78	100.0
2017-08-03 08:00:00	DIA	ETF	219.85	220.04	219.85	220.04	25428.0

> showing 50 of 9,054 rows — these rows as CSV

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