PREVIEW / etf_1hour / 2017-12-28

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-12-28.parquet
  size:    286 KB
  rows:    9,466

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-12-28 04:00:00	SPY	ETF	267.58	267.85	267.58	267.8	20679.0
2017-12-28 05:00:00	SPY	ETF	267.84	267.85	267.83	267.83	5275.0
2017-12-28 06:00:00	SPY	ETF	267.85	267.9	267.82	267.9	3800.0
2017-12-28 07:00:00	SPY	ETF	267.86	267.9	267.8	267.84	56792.0
2017-12-28 08:00:00	SPY	ETF	267.84	267.88	267.64	267.88	91694.0
2017-12-28 09:00:00	SPY	ETF	267.88	267.9	267.49	267.585	4583636.0
2017-12-28 10:00:00	SPY	ETF	267.59	267.7	267.465	267.66	5610288.0
2017-12-28 11:00:00	SPY	ETF	267.65	267.74	267.51	267.685	6438771.0
2017-12-28 12:00:00	SPY	ETF	267.68	267.71	267.57	267.61	4317916.0
2017-12-28 13:00:00	SPY	ETF	267.61	267.64	267.47	267.5401	3743246.0
2017-12-28 14:00:00	SPY	ETF	267.54	267.65	267.45	267.62	3157490.0
2017-12-28 15:00:00	SPY	ETF	267.62	267.92	267.56	267.86	9578709.0
2017-12-28 16:00:00	SPY	ETF	267.87	267.9262	267.69	267.75	6155504.0
2017-12-28 17:00:00	SPY	ETF	267.76	267.87	267.62	267.65	313887.0
2017-12-28 18:00:00	SPY	ETF	267.68	267.88	267.68	267.78	46265.0
2017-12-28 19:00:00	SPY	ETF	267.78	267.9	267.78	267.9	26070.0
2017-12-28 04:00:00	QQQ	ETF	156.96	157.05	156.96	157.0	6600.0
2017-12-28 06:00:00	QQQ	ETF	157.07	157.15	157.07	157.15	11753.0
2017-12-28 07:00:00	QQQ	ETF	157.12	157.23	157.1	157.18	28291.0
2017-12-28 08:00:00	QQQ	ETF	156.54	157.19	156.54	157.12	41719.0
2017-12-28 09:00:00	QQQ	ETF	157.03	157.0653	156.82	156.845	1470336.0
2017-12-28 10:00:00	QQQ	ETF	156.85	156.87	156.57	156.74	2058672.0
2017-12-28 11:00:00	QQQ	ETF	156.74	156.88	156.69	156.82	1632705.0
2017-12-28 12:00:00	QQQ	ETF	156.82	156.87	156.7638	156.805	779299.0
2017-12-28 13:00:00	QQQ	ETF	156.8	156.81	156.62	156.685	1418799.0
2017-12-28 14:00:00	QQQ	ETF	156.6701	156.69	156.54	156.58	2321053.0
2017-12-28 15:00:00	QQQ	ETF	156.58	156.75	156.56	156.735	2555291.0
2017-12-28 16:00:00	QQQ	ETF	156.73	156.7816	156.56	156.57	1965094.0
2017-12-28 17:00:00	QQQ	ETF	156.58	156.59	156.51	156.56	9500.0
2017-12-28 18:00:00	QQQ	ETF	156.59	156.7	156.59	156.68	8300.0
2017-12-28 19:00:00	QQQ	ETF	156.68	156.73	156.68	156.7	13019.0
2017-12-28 06:00:00	IWM	ETF	153.25	153.29	153.25	153.29	1100.0
2017-12-28 07:00:00	IWM	ETF	153.27	153.28	153.26	153.28	4158.0
2017-12-28 08:00:00	IWM	ETF	153.24	153.29	153.22	153.29	7426.0
2017-12-28 09:00:00	IWM	ETF	153.33	153.44	153.015	153.125	954014.0
2017-12-28 10:00:00	IWM	ETF	153.13	153.25	153.02	153.22	1124451.0
2017-12-28 11:00:00	IWM	ETF	153.21	153.49	153.06	153.46	867198.0
2017-12-28 12:00:00	IWM	ETF	153.4625	153.59	153.34	153.36	550169.0
2017-12-28 13:00:00	IWM	ETF	153.36	153.5	153.31	153.4463	514974.0
2017-12-28 14:00:00	IWM	ETF	153.44	153.52	153.365	153.47	704358.0
2017-12-28 15:00:00	IWM	ETF	153.4601	153.75	153.37	153.74	1932161.0
2017-12-28 16:00:00	IWM	ETF	153.74	153.75	153.6	153.62	588524.0
2017-12-28 17:00:00	IWM	ETF	153.62	153.68	153.57	153.68	2159.0
2017-12-28 18:00:00	IWM	ETF	153.67	153.67	153.67	153.67	899.0
2017-12-28 19:00:00	IWM	ETF	153.72	153.76	153.72	153.73	5174.0
2017-12-28 07:00:00	DIA	ETF	247.88	247.88	247.8	247.8	610.0
2017-12-28 08:00:00	DIA	ETF	247.95	247.95	247.95	247.95	100.0
2017-12-28 09:00:00	DIA	ETF	247.99	248.19	247.83	247.93	442277.0
2017-12-28 10:00:00	DIA	ETF	247.93	248.12	247.81	248.04	382211.0
2017-12-28 11:00:00	DIA	ETF	248.03	248.07	247.88	247.93	241565.0

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

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