PREVIEW / etf_1hour / 2017-12-29

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-12-29.parquet
  size:    301 KB
  rows:    9,962

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-29 04:00:00	SPY	ETF	267.94	268.18	267.94	268.18	1288.0
2017-12-29 05:00:00	SPY	ETF	268.3	268.57	268.3	268.54	41418.0
2017-12-29 06:00:00	SPY	ETF	268.52	268.62	268.52	268.62	27923.0
2017-12-29 07:00:00	SPY	ETF	268.58	268.98	268.56	268.68	323868.0
2017-12-29 08:00:00	SPY	ETF	268.58	268.84	268.51	268.55	264092.0
2017-12-29 09:00:00	SPY	ETF	268.54	268.66	267.89	267.98	4895981.0
2017-12-29 10:00:00	SPY	ETF	267.99	268.01	267.52	267.725	5138241.0
2017-12-29 11:00:00	SPY	ETF	267.72	267.87	267.51	267.78	6097048.0
2017-12-29 12:00:00	SPY	ETF	267.78	267.82	267.58	267.64	4216148.0
2017-12-29 13:00:00	SPY	ETF	267.64	267.72	267.29	267.42	5697970.0
2017-12-29 14:00:00	SPY	ETF	267.42	267.535	267.37	267.5089	8109864.0
2017-12-29 15:00:00	SPY	ETF	267.51	267.805	266.64	266.88	22254523.0
2017-12-29 16:00:00	SPY	ETF	266.89	267.7378	265.97	265.98	33046327.0
2017-12-29 17:00:00	SPY	ETF	265.99	266.8601	265.85	265.93	2039792.0
2017-12-29 18:00:00	SPY	ETF	265.93	265.93	265.77	265.78	96611.0
2017-12-29 19:00:00	SPY	ETF	265.78	266.12	265.78	266.0	67594.0
2017-12-29 04:00:00	QQQ	ETF	156.8	156.8	156.78	156.79	900.0
2017-12-29 05:00:00	QQQ	ETF	156.89	156.91	156.88	156.91	1791.0
2017-12-29 06:00:00	QQQ	ETF	156.93	157.1	156.93	157.04	8647.0
2017-12-29 07:00:00	QQQ	ETF	157.03	157.14	157.03	157.11	15499.0
2017-12-29 08:00:00	QQQ	ETF	157.03	157.14	156.92	156.93	104001.0
2017-12-29 09:00:00	QQQ	ETF	156.92	157.03	156.46	156.53	2396586.0
2017-12-29 10:00:00	QQQ	ETF	156.53	156.62	156.1	156.21	4340271.0
2017-12-29 11:00:00	QQQ	ETF	156.22	156.33	156.02	156.33	3411154.0
2017-12-29 12:00:00	QQQ	ETF	156.33	156.479	156.26	156.31	1690594.0
2017-12-29 13:00:00	QQQ	ETF	156.3	156.38	156.095	156.1499	2301839.0
2017-12-29 14:00:00	QQQ	ETF	156.149	156.24	156.12	156.2	881453.0
2017-12-29 15:00:00	QQQ	ETF	156.2	156.39	155.7	155.75	5957946.0
2017-12-29 16:00:00	QQQ	ETF	155.76	156.1624	155.18	155.21	1464234.0
2017-12-29 17:00:00	QQQ	ETF	155.21	155.76	155.21	155.24	755333.0
2017-12-29 18:00:00	QQQ	ETF	155.25	155.33	155.24	155.32	19889.0
2017-12-29 19:00:00	QQQ	ETF	155.32	155.5	155.18	155.4	22753.0
2017-12-29 05:00:00	IWM	ETF	154.06	154.13	154.06	154.13	4003.0
2017-12-29 06:00:00	IWM	ETF	154.2	154.25	154.17	154.25	11697.0
2017-12-29 07:00:00	IWM	ETF	154.2	154.41	154.19	154.27	8457.0
2017-12-29 08:00:00	IWM	ETF	154.26	154.32	154.1	154.13	55059.0
2017-12-29 09:00:00	IWM	ETF	154.2	154.2	153.37	153.52	1317415.0
2017-12-29 10:00:00	IWM	ETF	153.51	153.72	153.33	153.63	1107312.0
2017-12-29 11:00:00	IWM	ETF	153.64	153.7	153.37	153.495	1695913.0
2017-12-29 12:00:00	IWM	ETF	153.49	153.59	153.395	153.52	640135.0
2017-12-29 13:00:00	IWM	ETF	153.51	153.65	153.33	153.38	1094390.0
2017-12-29 14:00:00	IWM	ETF	153.37	153.37	152.99	153.01	1989676.0
2017-12-29 15:00:00	IWM	ETF	153.0	153.19	152.39	152.45	5456375.0
2017-12-29 16:00:00	IWM	ETF	152.45	154.26	151.81	152.14	2617470.0
2017-12-29 17:00:00	IWM	ETF	152.37	152.46	152.21	152.26	531723.0
2017-12-29 18:00:00	IWM	ETF	152.3	152.46	152.22	152.25	6786.0
2017-12-29 19:00:00	IWM	ETF	152.25	152.36	152.24	152.35	9830.0
2017-12-29 05:00:00	DIA	ETF	248.23	248.23	248.23	248.23	200.0
2017-12-29 07:00:00	DIA	ETF	248.23	248.48	248.23	248.48	969.0
2017-12-29 08:00:00	DIA	ETF	248.65	248.75	248.65	248.75	400.0

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

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