PREVIEW / etf_1hour / 2016-06-09

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-06-09.parquet
  size:    248 KB
  rows:    7,993

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-06-09 04:00:00	SPY	ETF	211.66	211.69	211.51	211.68	9532.0
2016-06-09 05:00:00	SPY	ETF	211.69	211.73	211.6	211.67	21999.0
2016-06-09 06:00:00	SPY	ETF	211.6	211.72	211.56	211.72	54084.0
2016-06-09 07:00:00	SPY	ETF	211.71	211.74	211.52	211.6	213947.0
2016-06-09 08:00:00	SPY	ETF	211.6	211.971	211.4	211.49	826216.0
2016-06-09 09:00:00	SPY	ETF	211.49	211.8	211.37	211.71	10026726.0
2016-06-09 10:00:00	SPY	ETF	211.7	211.7001	211.27	211.515	10733491.0
2016-06-09 11:00:00	SPY	ETF	211.515	211.76	211.24	211.35	10427221.0
2016-06-09 12:00:00	SPY	ETF	211.35	211.74	211.19	211.7	9983556.0
2016-06-09 13:00:00	SPY	ETF	211.7	211.98	211.53	211.73	5942492.0
2016-06-09 14:00:00	SPY	ETF	211.72	212.1	211.6	212.005	10510676.0
2016-06-09 15:00:00	SPY	ETF	212.005	212.22	211.9	212.01	10390572.0
2016-06-09 16:00:00	SPY	ETF	212.01	212.14	211.863	211.94	3167131.0
2016-06-09 17:00:00	SPY	ETF	211.94	211.98	211.91	211.92	173738.0
2016-06-09 18:00:00	SPY	ETF	211.91	211.92	211.73	211.79	70521.0
2016-06-09 19:00:00	SPY	ETF	211.8	211.89	211.77	211.85	29010.0
2016-06-09 04:00:00	QQQ	ETF	110.1	110.1	109.93	109.96	1043.0
2016-06-09 05:00:00	QQQ	ETF	110.01	110.01	109.98	109.98	243.0
2016-06-09 07:00:00	QQQ	ETF	110.03	110.04	109.98	110.01	5201.0
2016-06-09 08:00:00	QQQ	ETF	110.03	110.04	109.91	109.93	120682.0
2016-06-09 09:00:00	QQQ	ETF	109.93	110.3097	109.86	110.24	2341684.0
2016-06-09 10:00:00	QQQ	ETF	110.24	110.29	109.95	110.17	2256550.0
2016-06-09 11:00:00	QQQ	ETF	110.16	110.27	109.91	109.97	2558527.0
2016-06-09 12:00:00	QQQ	ETF	109.97	110.09	109.71	110.065	2530780.0
2016-06-09 13:00:00	QQQ	ETF	110.07	110.28	109.8989	110.0501	2128557.0
2016-06-09 14:00:00	QQQ	ETF	110.05	110.31	109.97	110.215	2354851.0
2016-06-09 15:00:00	QQQ	ETF	110.2199	110.2988	110.14	110.18	2061824.0
2016-06-09 16:00:00	QQQ	ETF	110.17	110.23	110.11	110.19	408559.0
2016-06-09 17:00:00	QQQ	ETF	110.14	110.18	110.14	110.15	4426.0
2016-06-09 18:00:00	QQQ	ETF	110.15	110.15	110.08	110.08	3982.0
2016-06-09 19:00:00	QQQ	ETF	110.11	110.13	110.1	110.13	5417.0
2016-06-09 04:00:00	IWM	ETF	118.0	118.05	118.0	118.05	756.0
2016-06-09 05:00:00	IWM	ETF	118.09	118.09	118.09	118.09	100.0
2016-06-09 06:00:00	IWM	ETF	118.0	118.05	118.0	118.05	200.0
2016-06-09 07:00:00	IWM	ETF	118.08	118.08	117.92	117.96	17257.0
2016-06-09 08:00:00	IWM	ETF	118.0	118.04	117.89	117.93	116073.0
2016-06-09 09:00:00	IWM	ETF	117.93	117.96	117.46	117.66	3189150.0
2016-06-09 10:00:00	IWM	ETF	117.64	117.71	117.32	117.54	3410612.0
2016-06-09 11:00:00	IWM	ETF	117.55	117.85	117.44	117.475	1693868.0
2016-06-09 12:00:00	IWM	ETF	117.47	117.74	117.29	117.695	2667124.0
2016-06-09 13:00:00	IWM	ETF	117.7	117.86	117.45	117.635	1691254.0
2016-06-09 14:00:00	IWM	ETF	117.63	117.89	117.53	117.73	1479661.0
2016-06-09 15:00:00	IWM	ETF	117.735	117.88	117.66	117.66	3944864.0
2016-06-09 16:00:00	IWM	ETF	117.66	117.8	117.52	117.52	541070.0
2016-06-09 17:00:00	IWM	ETF	117.55	117.55	117.5	117.5	363091.0
2016-06-09 18:00:00	IWM	ETF	117.5	117.53	117.5	117.51	643.0
2016-06-09 19:00:00	IWM	ETF	117.54	117.55	117.54	117.54	1500.0
2016-06-09 06:00:00	DIA	ETF	179.55	179.58	179.55	179.58	200.0
2016-06-09 07:00:00	DIA	ETF	179.59	179.59	179.5	179.5	221.0
2016-06-09 08:00:00	DIA	ETF	179.49	179.49	179.49	179.49	100.0

> showing 50 of 7,993 rows — these rows as CSV

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