PREVIEW / etf_1hour / 2017-07-13

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-07-13.parquet
  size:    271 KB
  rows:    8,995

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-13 04:00:00	SPY	ETF	244.18	244.36	244.18	244.33	601.0
2017-07-13 05:00:00	SPY	ETF	244.37	244.48	244.27	244.33	13845.0
2017-07-13 06:00:00	SPY	ETF	244.3	244.33	244.2	244.2	61309.0
2017-07-13 07:00:00	SPY	ETF	244.2	244.21	243.95	244.0	107543.0
2017-07-13 08:00:00	SPY	ETF	244.02	244.18	244.0	244.1	268886.0
2017-07-13 09:00:00	SPY	ETF	244.1	244.33	243.9	244.27	4270135.0
2017-07-13 10:00:00	SPY	ETF	244.27	244.34	243.76	244.03	5793298.0
2017-07-13 11:00:00	SPY	ETF	244.02	244.44	244.01	244.36	4254865.0
2017-07-13 12:00:00	SPY	ETF	244.36	244.49	244.29	244.45	3058299.0
2017-07-13 13:00:00	SPY	ETF	244.44	244.49	244.255	244.36	2894156.0
2017-07-13 14:00:00	SPY	ETF	244.36	244.46	244.15	244.425	4060214.0
2017-07-13 15:00:00	SPY	ETF	244.42	244.55	244.3	244.41	8444469.0
2017-07-13 16:00:00	SPY	ETF	244.4	244.5	244.31	244.5	5155384.0
2017-07-13 17:00:00	SPY	ETF	244.49	244.49	244.39	244.45	62662.0
2017-07-13 18:00:00	SPY	ETF	244.44	244.44	244.34	244.42	45991.0
2017-07-13 19:00:00	SPY	ETF	244.42	244.46	244.39	244.43	29784.0
2017-07-13 04:00:00	QQQ	ETF	141.12	141.32	141.12	141.28	3438.0
2017-07-13 05:00:00	QQQ	ETF	141.32	141.42	141.28	141.31	5498.0
2017-07-13 06:00:00	QQQ	ETF	141.29	141.31	141.18	141.19	19230.0
2017-07-13 07:00:00	QQQ	ETF	141.14	141.19	141.0	141.02	117257.0
2017-07-13 08:00:00	QQQ	ETF	141.13	141.15	140.92	140.97	70333.0
2017-07-13 09:00:00	QQQ	ETF	140.96	141.35	140.675	141.28	3442654.0
2017-07-13 10:00:00	QQQ	ETF	141.28	141.35	140.6	140.9	5465624.0
2017-07-13 11:00:00	QQQ	ETF	140.905	141.12	140.79	141.1	2458751.0
2017-07-13 12:00:00	QQQ	ETF	141.09	141.29	141.03	141.27	1833287.0
2017-07-13 13:00:00	QQQ	ETF	141.275	141.309	140.76	140.93	4101953.0
2017-07-13 14:00:00	QQQ	ETF	140.93	141.1	140.65	141.05	3767493.0
2017-07-13 15:00:00	QQQ	ETF	141.04	141.16	140.9204	141.02	4692886.0
2017-07-13 16:00:00	QQQ	ETF	141.01	141.2214	140.9811	141.13	1214486.0
2017-07-13 17:00:00	QQQ	ETF	141.15	141.15	141.01	141.06	44327.0
2017-07-13 18:00:00	QQQ	ETF	141.09	141.11	141.04	141.1	15635.0
2017-07-13 19:00:00	QQQ	ETF	141.07	141.13	141.06	141.11	12854.0
2017-07-13 04:00:00	IWM	ETF	141.4	141.53	141.4	141.53	517.0
2017-07-13 05:00:00	IWM	ETF	141.5	141.5	141.5	141.5	200.0
2017-07-13 06:00:00	IWM	ETF	141.42	141.42	141.35	141.35	2200.0
2017-07-13 07:00:00	IWM	ETF	141.35	141.37	141.13	141.16	44116.0
2017-07-13 08:00:00	IWM	ETF	141.16	141.31	141.15	141.15	46809.0
2017-07-13 09:00:00	IWM	ETF	141.2	141.32	140.87	141.1	1788793.0
2017-07-13 10:00:00	IWM	ETF	141.1	141.23	140.38	140.66	3090324.0
2017-07-13 11:00:00	IWM	ETF	140.67	140.8775	140.55	140.68	1569013.0
2017-07-13 12:00:00	IWM	ETF	140.68	140.95	140.58	140.87	1137759.0
2017-07-13 13:00:00	IWM	ETF	140.86	141.09	140.64	141.035	1371047.0
2017-07-13 14:00:00	IWM	ETF	141.035	141.37	140.91	141.3175	1362835.0
2017-07-13 15:00:00	IWM	ETF	141.3101	141.56	141.13	141.5	2988304.0
2017-07-13 16:00:00	IWM	ETF	141.49	141.59	141.19	141.56	487602.0
2017-07-13 17:00:00	IWM	ETF	141.57	141.57	141.57	141.57	108.0
2017-07-13 18:00:00	IWM	ETF	141.56	141.56	141.5	141.5	1300.0
2017-07-13 19:00:00	IWM	ETF	141.5319	141.55	141.48	141.55	25600.0
2017-07-13 09:00:00	DIA	ETF	215.29	215.46	215.14	215.33	177292.0
2017-07-13 10:00:00	DIA	ETF	215.32	215.41	215.0	215.25	150952.0

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

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