PREVIEW / etf_1hour / 2017-01-20

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-01-20.parquet
  size:    272 KB
  rows:    8,688

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-01-20 04:00:00	SPY	ETF	226.5	226.62	226.5	226.59	18298.0
2017-01-20 05:00:00	SPY	ETF	226.56	226.69	226.56	226.59	18129.0
2017-01-20 06:00:00	SPY	ETF	226.57	226.82	226.47	226.47	203966.0
2017-01-20 07:00:00	SPY	ETF	226.47	226.66	226.46	226.62	133012.0
2017-01-20 08:00:00	SPY	ETF	226.62	226.8	226.46	226.68	486679.0
2017-01-20 09:00:00	SPY	ETF	226.7	227.31	226.35	227.105	13028039.0
2017-01-20 10:00:00	SPY	ETF	227.105	227.17	226.82	226.985	18067965.0
2017-01-20 11:00:00	SPY	ETF	226.985	227.11	226.82	226.97	16588636.0
2017-01-20 12:00:00	SPY	ETF	226.97	227.15	226.05	226.3301	19255855.0
2017-01-20 13:00:00	SPY	ETF	226.34	226.66	226.24	226.415	6772005.0
2017-01-20 14:00:00	SPY	ETF	226.42	226.5	226.11	226.335	7958033.0
2017-01-20 15:00:00	SPY	ETF	226.34	226.74	226.14	226.7	21877261.0
2017-01-20 16:00:00	SPY	ETF	226.69	226.77	226.54	226.71	14758149.0
2017-01-20 17:00:00	SPY	ETF	226.7	227.5	226.64	226.87	6550702.0
2017-01-20 18:00:00	SPY	ETF	226.87	226.98	226.81	226.87	36522.0
2017-01-20 19:00:00	SPY	ETF	226.87	226.9	226.74	226.81	63090.0
2017-01-20 04:00:00	QQQ	ETF	123.37	123.37	123.37	123.37	250.0
2017-01-20 06:00:00	QQQ	ETF	123.44	123.46	123.4	123.4	56449.0
2017-01-20 07:00:00	QQQ	ETF	123.38	123.46	123.36	123.46	47176.0
2017-01-20 08:00:00	QQQ	ETF	123.37	123.49	123.37	123.41	79525.0
2017-01-20 09:00:00	QQQ	ETF	123.43	123.83	123.36	123.709	3428666.0
2017-01-20 10:00:00	QQQ	ETF	123.71	123.73	123.28	123.33	2586270.0
2017-01-20 11:00:00	QQQ	ETF	123.34	123.47	123.28	123.45	1712704.0
2017-01-20 12:00:00	QQQ	ETF	123.44	123.52	122.92	123.1	3965616.0
2017-01-20 13:00:00	QQQ	ETF	123.1	123.27	123.071	123.1199	735746.0
2017-01-20 14:00:00	QQQ	ETF	123.12	123.19	122.95	123.1	1674795.0
2017-01-20 15:00:00	QQQ	ETF	123.1	123.29	123.0	123.25	2876284.0
2017-01-20 16:00:00	QQQ	ETF	123.24	123.3676	123.1115	123.24	2600454.0
2017-01-20 17:00:00	QQQ	ETF	123.33	123.36	123.26	123.3	53789.0
2017-01-20 18:00:00	QQQ	ETF	123.28	123.31	123.25	123.28	18726.0
2017-01-20 19:00:00	QQQ	ETF	123.25	123.25	123.2	123.25	15261.0
2017-01-20 06:00:00	IWM	ETF	134.07	134.07	134.07	134.07	283.0
2017-01-20 07:00:00	IWM	ETF	134.0	134.17	133.99	134.11	93743.0
2017-01-20 08:00:00	IWM	ETF	134.11	134.27	133.66	134.17	647372.0
2017-01-20 09:00:00	IWM	ETF	134.17	134.88	133.96	134.48	3258743.0
2017-01-20 10:00:00	IWM	ETF	134.48	134.68	134.34	134.58	2852040.0
2017-01-20 11:00:00	IWM	ETF	134.6	134.7	134.47	134.68	1717157.0
2017-01-20 12:00:00	IWM	ETF	134.68	134.72	133.82	133.98	4042046.0
2017-01-20 13:00:00	IWM	ETF	133.9899	134.48	133.98	134.31	1577738.0
2017-01-20 14:00:00	IWM	ETF	134.32	134.4	134.07	134.2	1418640.0
2017-01-20 15:00:00	IWM	ETF	134.2	134.4	133.94	134.38	5626896.0
2017-01-20 16:00:00	IWM	ETF	134.44	134.46	134.26	134.45	1624424.0
2017-01-20 17:00:00	IWM	ETF	134.44	134.5	134.44	134.5	418780.0
2017-01-20 18:00:00	IWM	ETF	134.47	134.5	134.46	134.46	1068.0
2017-01-20 19:00:00	IWM	ETF	134.48	134.52	134.48	134.52	4106.0
2017-01-20 07:00:00	DIA	ETF	197.3	197.45	197.3	197.42	2500.0
2017-01-20 08:00:00	DIA	ETF	197.41	197.57	197.38	197.5	13800.0
2017-01-20 09:00:00	DIA	ETF	197.44	198.2	197.3	197.97	2130977.0
2017-01-20 10:00:00	DIA	ETF	197.98	198.1	197.8	198.02	411212.0
2017-01-20 11:00:00	DIA	ETF	198.02	198.161	197.92	198.04	273418.0

> showing 50 of 8,688 rows — these rows as CSV

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