PREVIEW / etf_1hour / 2018-05-07

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-05-07.parquet
  size:    297 KB
  rows:    9,748

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
2018-05-07 04:00:00	SPY	ETF	266.61	267.0	266.61	266.85	9422.0
2018-05-07 05:00:00	SPY	ETF	266.9	266.98	266.75	266.86	6514.0
2018-05-07 06:00:00	SPY	ETF	266.9	267.11	266.74	267.02	42918.0
2018-05-07 07:00:00	SPY	ETF	267.03	267.4	266.93	266.99	209187.0
2018-05-07 08:00:00	SPY	ETF	266.99	267.31	266.6	267.03	349830.0
2018-05-07 09:00:00	SPY	ETF	267.03	267.78	266.63	267.74	6426471.0
2018-05-07 10:00:00	SPY	ETF	267.74	267.78	266.75	267.425	6898657.0
2018-05-07 11:00:00	SPY	ETF	267.425	267.65	267.095	267.545	4619020.0
2018-05-07 12:00:00	SPY	ETF	267.55	267.74	267.21	267.37	3216019.0
2018-05-07 13:00:00	SPY	ETF	267.37	267.66	267.09	267.59	3230074.0
2018-05-07 14:00:00	SPY	ETF	267.58	268.02	266.92	267.02	6600312.0
2018-05-07 15:00:00	SPY	ETF	267.0217	267.25	266.11	266.91	15870044.0
2018-05-07 16:00:00	SPY	ETF	266.9	267.04	266.71	266.92	5864098.0
2018-05-07 17:00:00	SPY	ETF	266.73	266.82	266.68	266.72	45802.0
2018-05-07 18:00:00	SPY	ETF	266.75	266.8	266.36	266.63	267559.0
2018-05-07 19:00:00	SPY	ETF	266.57	266.64	266.49	266.59	35576.0
2018-05-07 04:00:00	QQQ	ETF	165.6	166.02	165.6	165.94	15930.0
2018-05-07 05:00:00	QQQ	ETF	165.87	166.0	165.8	165.9	13673.0
2018-05-07 06:00:00	QQQ	ETF	165.85	165.97	165.7	165.92	14010.0
2018-05-07 07:00:00	QQQ	ETF	165.85	166.09	165.79	165.85	97081.0
2018-05-07 08:00:00	QQQ	ETF	166.04	166.04	165.61	165.85	179556.0
2018-05-07 09:00:00	QQQ	ETF	165.84	166.56	165.51	166.41	4964552.0
2018-05-07 10:00:00	QQQ	ETF	166.41	166.6	165.98	166.45	4141929.0
2018-05-07 11:00:00	QQQ	ETF	166.45	166.72	166.19	166.6352	2499253.0
2018-05-07 12:00:00	QQQ	ETF	166.63	166.67	166.14	166.2601	2042350.0
2018-05-07 13:00:00	QQQ	ETF	166.261	166.52	166.0	166.47	3859992.0
2018-05-07 14:00:00	QQQ	ETF	166.47	166.78	166.06	166.24	3591791.0
2018-05-07 15:00:00	QQQ	ETF	166.2408	166.46	165.545	166.15	6223629.0
2018-05-07 16:00:00	QQQ	ETF	166.15	166.3633	165.96	166.0	1714309.0
2018-05-07 17:00:00	QQQ	ETF	166.1	166.1	166.0	166.08	12632.0
2018-05-07 18:00:00	QQQ	ETF	166.04	166.18	165.81	166.07	60475.0
2018-05-07 19:00:00	QQQ	ETF	166.06	166.09	165.94	165.97	19263.0
2018-05-07 04:00:00	IWM	ETF	156.15	156.15	156.15	156.15	800.0
2018-05-07 06:00:00	IWM	ETF	156.18	156.18	156.15	156.15	400.0
2018-05-07 07:00:00	IWM	ETF	156.25	156.41	156.22	156.22	61012.0
2018-05-07 08:00:00	IWM	ETF	156.22	156.45	156.2	156.45	37724.0
2018-05-07 09:00:00	IWM	ETF	156.43	156.69	156.1	156.57	1502796.0
2018-05-07 10:00:00	IWM	ETF	156.6	157.0	156.32	156.86	2065686.0
2018-05-07 11:00:00	IWM	ETF	156.85	157.26	156.72	157.26	1164227.0
2018-05-07 12:00:00	IWM	ETF	157.26	157.46	157.12	157.45	1570982.0
2018-05-07 13:00:00	IWM	ETF	157.4442	157.625	157.24	157.57	1402731.0
2018-05-07 14:00:00	IWM	ETF	157.57	157.86	157.15	157.3	1901684.0
2018-05-07 15:00:00	IWM	ETF	157.3	157.49	156.81	157.01	3530288.0
2018-05-07 16:00:00	IWM	ETF	157.05	157.15	156.97	157.11	936367.0
2018-05-07 17:00:00	IWM	ETF	157.08	157.08	157.05	157.05	1800.0
2018-05-07 18:00:00	IWM	ETF	157.05	157.05	156.83	157.05	6245.0
2018-05-07 19:00:00	IWM	ETF	156.94	156.95	156.89	156.89	462.0
2018-05-07 04:00:00	DIA	ETF	243.46	243.46	243.46	243.46	400.0
2018-05-07 07:00:00	DIA	ETF	243.34	243.62	243.34	243.44	3191.0
2018-05-07 08:00:00	DIA	ETF	243.48	243.57	243.3	243.57	9565.0

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

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