PREVIEW / etf_1hour / 2017-07-21

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-07-21.parquet
  size:    275 KB
  rows:    8,975

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-07-21 04:00:00	SPY	ETF	247.16	247.3	247.16	247.3	2804.0
2017-07-21 05:00:00	SPY	ETF	247.34	247.39	247.14	247.14	12834.0
2017-07-21 06:00:00	SPY	ETF	247.19	247.19	246.85	246.92	4199.0
2017-07-21 07:00:00	SPY	ETF	246.92	247.04	246.9	246.93	31477.0
2017-07-21 08:00:00	SPY	ETF	246.91	247.26	246.71	246.74	470951.0
2017-07-21 09:00:00	SPY	ETF	246.75	246.75	246.23	246.33	9843769.0
2017-07-21 10:00:00	SPY	ETF	246.33	246.55	246.18	246.26	28935583.0
2017-07-21 11:00:00	SPY	ETF	246.26	246.71	246.24	246.71	8063885.0
2017-07-21 12:00:00	SPY	ETF	246.71	246.8	246.58	246.77	5685650.0
2017-07-21 13:00:00	SPY	ETF	246.77	246.9	246.65	246.725	8429622.0
2017-07-21 14:00:00	SPY	ETF	246.725	246.77	246.55	246.68	4311158.0
2017-07-21 15:00:00	SPY	ETF	246.685	246.91	246.495	246.89	10697602.0
2017-07-21 16:00:00	SPY	ETF	246.89	246.9017	246.76	246.88	8064449.0
2017-07-21 17:00:00	SPY	ETF	246.87	246.9	246.81	246.85	2267111.0
2017-07-21 18:00:00	SPY	ETF	246.85	246.9	246.82	246.86	12869.0
2017-07-21 19:00:00	SPY	ETF	246.87	246.91	246.8	246.81	13754.0
2017-07-21 05:00:00	QQQ	ETF	144.24	144.25	144.23	144.23	1200.0
2017-07-21 06:00:00	QQQ	ETF	144.07	144.07	143.87	144.02	9970.0
2017-07-21 07:00:00	QQQ	ETF	143.99	144.01	143.9	143.92	19485.0
2017-07-21 08:00:00	QQQ	ETF	143.91	144.02	143.76	143.81	261064.0
2017-07-21 09:00:00	QQQ	ETF	143.8	143.8673	143.35	143.72	5482005.0
2017-07-21 10:00:00	QQQ	ETF	143.72	143.93	143.62	143.67	5023597.0
2017-07-21 11:00:00	QQQ	ETF	143.67	143.9	143.51	143.9	1508460.0
2017-07-21 12:00:00	QQQ	ETF	143.9	144.049	143.83	144.03	1065434.0
2017-07-21 13:00:00	QQQ	ETF	144.03	144.11	143.83	143.93	1679794.0
2017-07-21 14:00:00	QQQ	ETF	143.92	144.02	143.76	143.935	1557490.0
2017-07-21 15:00:00	QQQ	ETF	143.9375	144.11	143.845	144.1	3253521.0
2017-07-21 16:00:00	QQQ	ETF	144.105	144.16	144.02	144.13	9252605.0
2017-07-21 17:00:00	QQQ	ETF	144.1	144.14	144.07	144.13	5074.0
2017-07-21 18:00:00	QQQ	ETF	144.11	144.12	144.1	144.12	3548.0
2017-07-21 19:00:00	QQQ	ETF	144.13	144.14	144.04	144.04	9088.0
2017-07-21 05:00:00	IWM	ETF	143.43	143.43	143.34	143.34	800.0
2017-07-21 06:00:00	IWM	ETF	143.18	143.18	143.01	143.01	400.0
2017-07-21 07:00:00	IWM	ETF	143.15	143.27	143.12	143.12	10965.0
2017-07-21 08:00:00	IWM	ETF	143.15	143.16	142.87	142.87	103599.0
2017-07-21 09:00:00	IWM	ETF	142.82	143.33	142.76	142.86	3079997.0
2017-07-21 10:00:00	IWM	ETF	142.86	142.97	142.36	142.42	2828406.0
2017-07-21 11:00:00	IWM	ETF	142.41	142.89	142.39	142.73	2200476.0
2017-07-21 12:00:00	IWM	ETF	142.74	142.895	142.54	142.67	1174379.0
2017-07-21 13:00:00	IWM	ETF	142.67	142.76	142.53	142.61	803487.0
2017-07-21 14:00:00	IWM	ETF	142.6099	142.61	142.31	142.455	1869407.0
2017-07-21 15:00:00	IWM	ETF	142.46	142.6	142.25	142.53	4869226.0
2017-07-21 16:00:00	IWM	ETF	142.55	142.61	142.39	142.39	894817.0
2017-07-21 17:00:00	IWM	ETF	142.43	142.48	142.41	142.48	8621.0
2017-07-21 18:00:00	IWM	ETF	142.47	142.47	142.47	142.47	200.0
2017-07-21 19:00:00	IWM	ETF	142.42	142.48	142.42	142.48	1309.0
2017-07-21 08:00:00	DIA	ETF	215.62	215.91	215.59	215.59	4443.0
2017-07-21 09:00:00	DIA	ETF	215.47	215.5	214.9	214.93	836901.0
2017-07-21 10:00:00	DIA	ETF	214.92	215.48	214.76	214.95	459915.0
2017-07-21 11:00:00	DIA	ETF	214.94	215.29	214.92	215.29	213190.0

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

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