PREVIEW / etf_1hour / 2016-07-28

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-07-28.parquet
  size:    251 KB
  rows:    8,011

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
2016-07-28 04:00:00	SPY	ETF	216.88	216.97	216.82	216.91	12257.0
2016-07-28 05:00:00	SPY	ETF	216.88	216.91	216.7	216.8	19625.0
2016-07-28 06:00:00	SPY	ETF	216.69	216.74	216.52	216.56	10173.0
2016-07-28 07:00:00	SPY	ETF	216.6	216.6	216.04	216.12	270826.0
2016-07-28 08:00:00	SPY	ETF	216.11	217.16	216.09	216.24	363105.0
2016-07-28 09:00:00	SPY	ETF	216.27	216.64	215.8	216.5	10404030.0
2016-07-28 10:00:00	SPY	ETF	216.5	216.65	215.75	215.82	10618392.0
2016-07-28 11:00:00	SPY	ETF	215.83	216.22	215.78	216.17	7154578.0
2016-07-28 12:00:00	SPY	ETF	216.175	216.31	215.98	216.16	4474474.0
2016-07-28 13:00:00	SPY	ETF	216.1608	216.63	216.11	216.63	4494944.0
2016-07-28 14:00:00	SPY	ETF	216.63	216.85	216.52	216.7	6469315.0
2016-07-28 15:00:00	SPY	ETF	216.7	217.11	216.6992	216.78	14456843.0
2016-07-28 16:00:00	SPY	ETF	216.78	216.97	216.68	216.97	4895792.0
2016-07-28 17:00:00	SPY	ETF	216.97	217.0	216.77	216.9	185344.0
2016-07-28 18:00:00	SPY	ETF	216.93	217.07	216.83	217.0	113459.0
2016-07-28 19:00:00	SPY	ETF	216.98	217.04	216.94	216.95	63859.0
2016-07-28 04:00:00	QQQ	ETF	114.99	115.08	114.99	115.0	3796.0
2016-07-28 06:00:00	QQQ	ETF	114.88	114.91	114.85	114.85	500.0
2016-07-28 07:00:00	QQQ	ETF	114.84	114.86	114.64	114.66	97259.0
2016-07-28 08:00:00	QQQ	ETF	114.8	114.8	114.67	114.67	38830.0
2016-07-28 09:00:00	QQQ	ETF	114.7	114.9425	114.4	114.82	2304249.0
2016-07-28 10:00:00	QQQ	ETF	114.82	114.9611	114.46	114.61	2885677.0
2016-07-28 11:00:00	QQQ	ETF	114.61	114.75	114.52	114.71	1480310.0
2016-07-28 12:00:00	QQQ	ETF	114.7093	114.78	114.53	114.56	1046807.0
2016-07-28 13:00:00	QQQ	ETF	114.57	114.86	114.52	114.8562	1546336.0
2016-07-28 14:00:00	QQQ	ETF	114.86	114.95	114.78	114.865	1635216.0
2016-07-28 15:00:00	QQQ	ETF	114.86	115.11	114.86	114.98	2960671.0
2016-07-28 16:00:00	QQQ	ETF	114.98	115.43	114.73	115.41	1480425.0
2016-07-28 17:00:00	QQQ	ETF	115.4	115.45	115.33	115.4	94025.0
2016-07-28 18:00:00	QQQ	ETF	115.4	115.45	115.27	115.36	30218.0
2016-07-28 19:00:00	QQQ	ETF	115.36	115.38	115.32	115.32	15077.0
2016-07-28 06:00:00	IWM	ETF	121.14	121.14	121.04	121.04	230.0
2016-07-28 07:00:00	IWM	ETF	120.95	121.0	120.81	120.81	83272.0
2016-07-28 08:00:00	IWM	ETF	120.86	120.92	120.83	120.83	12858.0
2016-07-28 09:00:00	IWM	ETF	120.88	121.235	120.53	121.0	1691654.0
2016-07-28 10:00:00	IWM	ETF	121.03	121.09	120.54	120.57	2123418.0
2016-07-28 11:00:00	IWM	ETF	120.58	120.87	120.565	120.84	1783488.0
2016-07-28 12:00:00	IWM	ETF	120.83	120.93	120.66	120.77	861840.0
2016-07-28 13:00:00	IWM	ETF	120.765	120.98	120.73	120.98	988577.0
2016-07-28 14:00:00	IWM	ETF	120.99	121.16	120.92	120.9908	1752563.0
2016-07-28 15:00:00	IWM	ETF	121.0	121.16	120.675	120.83	3628978.0
2016-07-28 16:00:00	IWM	ETF	120.83	120.98	120.72	120.84	1118497.0
2016-07-28 17:00:00	IWM	ETF	120.85	120.91	120.85	120.91	17200.0
2016-07-28 18:00:00	IWM	ETF	120.91	121.0	120.8	121.0	5996.0
2016-07-28 19:00:00	IWM	ETF	120.99	120.99	120.9	120.9	3950.0
2016-07-28 08:00:00	DIA	ETF	184.4	184.4	184.31	184.39	900.0
2016-07-28 09:00:00	DIA	ETF	184.28	184.45	183.84	184.3	296596.0
2016-07-28 10:00:00	DIA	ETF	184.32	184.48	183.52	183.6	420834.0
2016-07-28 11:00:00	DIA	ETF	183.61	183.91	183.57	183.86	223190.0
2016-07-28 12:00:00	DIA	ETF	183.86	183.9836	183.76	183.9173	118343.0

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

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