PREVIEW / etf_1hour / 2016-01-22

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-01-22.parquet
  size:    257 KB
  rows:    8,256

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-01-22 04:00:00	SPY	ETF	188.64	189.71	188.64	189.03	99498.0
2016-01-22 05:00:00	SPY	ETF	188.9	189.42	188.84	189.2	42847.0
2016-01-22 06:00:00	SPY	ETF	189.1	189.4	189.1	189.24	197733.0
2016-01-22 07:00:00	SPY	ETF	189.23	189.59	189.04	189.34	394098.0
2016-01-22 08:00:00	SPY	ETF	189.35	189.62	186.8	189.1	1596955.0
2016-01-22 09:00:00	SPY	ETF	189.08	190.29	189.07	190.24	29554162.0
2016-01-22 10:00:00	SPY	ETF	190.24	190.56	189.49	189.5	29015192.0
2016-01-22 11:00:00	SPY	ETF	189.5	189.85	188.88	189.09	19711893.0
2016-01-22 12:00:00	SPY	ETF	189.08	189.99	189.055	189.9361	12018052.0
2016-01-22 13:00:00	SPY	ETF	189.94	190.435	189.59	190.41	11615415.0
2016-01-22 14:00:00	SPY	ETF	190.4	190.76	189.84	190.28	20176453.0
2016-01-22 15:00:00	SPY	ETF	190.285	190.61	189.72	190.49	28258024.0
2016-01-22 16:00:00	SPY	ETF	190.49	190.57	190.01	190.45	12846757.0
2016-01-22 17:00:00	SPY	ETF	190.45	190.55	190.43	190.5	90680.0
2016-01-22 18:00:00	SPY	ETF	190.5	190.78	190.49	190.75	128807.0
2016-01-22 19:00:00	SPY	ETF	190.75	190.76	190.65	190.73	58931.0
2016-01-22 04:00:00	QQQ	ETF	102.13	102.81	102.13	102.43	3825.0
2016-01-22 05:00:00	QQQ	ETF	102.27	102.46	102.25	102.46	7350.0
2016-01-22 06:00:00	QQQ	ETF	102.4	102.68	102.4	102.63	34650.0
2016-01-22 07:00:00	QQQ	ETF	102.6	102.8	102.52	102.69	41607.0
2016-01-22 08:00:00	QQQ	ETF	102.69	102.82	102.48	102.53	210742.0
2016-01-22 09:00:00	QQQ	ETF	102.55	103.25	102.53	103.2	7591175.0
2016-01-22 10:00:00	QQQ	ETF	103.21	103.585	103.0	103.03	8090224.0
2016-01-22 11:00:00	QQQ	ETF	103.02	103.29	102.75	102.88	4186599.0
2016-01-22 12:00:00	QQQ	ETF	102.86	103.42	102.83	103.38	3037010.0
2016-01-22 13:00:00	QQQ	ETF	103.38	103.57	103.17	103.56	2348499.0
2016-01-22 14:00:00	QQQ	ETF	103.55	103.81	103.32	103.55	3776553.0
2016-01-22 15:00:00	QQQ	ETF	103.55	103.78	103.27	103.76	7757823.0
2016-01-22 16:00:00	QQQ	ETF	103.76	103.79	103.49	103.66	1137358.0
2016-01-22 17:00:00	QQQ	ETF	103.7	103.7	103.6	103.66	14901.0
2016-01-22 18:00:00	QQQ	ETF	103.65	103.99	103.65	103.99	51184.0
2016-01-22 19:00:00	QQQ	ETF	103.99	103.99	103.85	103.88	12522.0
2016-01-22 20:00:00	QQQ	ETF	103.7755	103.7755	103.7755	103.7755	500000.0
2016-01-22 04:00:00	IWM	ETF	100.25	100.52	100.19	100.34	6486.0
2016-01-22 05:00:00	IWM	ETF	100.22	100.49	100.16	100.49	3500.0
2016-01-22 06:00:00	IWM	ETF	100.4	100.61	100.4	100.6	58210.0
2016-01-22 07:00:00	IWM	ETF	100.53	100.86	100.45	100.62	136621.0
2016-01-22 08:00:00	IWM	ETF	100.58	101.3763	100.35	100.37	447116.0
2016-01-22 09:00:00	IWM	ETF	100.45	101.48	100.13	101.468	7473696.0
2016-01-22 10:00:00	IWM	ETF	101.46	101.61	100.44	100.48	9196661.0
2016-01-22 11:00:00	IWM	ETF	100.48	100.94	100.25	100.391	5509859.0
2016-01-22 12:00:00	IWM	ETF	100.39	101.0	100.37	100.945	2795633.0
2016-01-22 13:00:00	IWM	ETF	100.95	101.29	100.57	101.27	2943427.0
2016-01-22 14:00:00	IWM	ETF	101.27	101.4	100.68	101.02	3893831.0
2016-01-22 15:00:00	IWM	ETF	101.01	101.38	100.7	101.36	7091133.0
2016-01-22 16:00:00	IWM	ETF	101.36	101.41	100.67	101.06	2512382.0
2016-01-22 17:00:00	IWM	ETF	101.05	101.2	101.01	101.2	15115.0
2016-01-22 18:00:00	IWM	ETF	101.25	101.25	101.2	101.2	400.0
2016-01-22 19:00:00	IWM	ETF	101.35	101.35	101.2	101.34	4090.0
2016-01-22 04:00:00	DIA	ETF	160.08	160.37	160.08	160.37	1200.0

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

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