PREVIEW / etf_1hour / 2016-10-14

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-10-14.parquet
  size:    254 KB
  rows:    8,142

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-10-14 04:00:00	SPY	ETF	213.21	213.44	213.1	213.44	36610.0
2016-10-14 05:00:00	SPY	ETF	213.4	213.83	213.4	213.79	22345.0
2016-10-14 06:00:00	SPY	ETF	213.79	214.25	213.77	214.0	267068.0
2016-10-14 07:00:00	SPY	ETF	214.01	214.06	213.86	213.9	240763.0
2016-10-14 08:00:00	SPY	ETF	213.91	214.1	213.61	213.98	752921.0
2016-10-14 09:00:00	SPY	ETF	214.0	214.55	213.97	214.405	10530322.0
2016-10-14 10:00:00	SPY	ETF	214.4	214.69	214.17	214.195	10416966.0
2016-10-14 11:00:00	SPY	ETF	214.19	214.2	213.29	213.32	14032537.0
2016-10-14 12:00:00	SPY	ETF	213.33	213.58	213.04	213.45	9860023.0
2016-10-14 13:00:00	SPY	ETF	213.45	214.0611	213.26	213.51	10777597.0
2016-10-14 14:00:00	SPY	ETF	213.518	213.72	213.15	213.21	7735079.0
2016-10-14 15:00:00	SPY	ETF	213.21	213.68	213.03	213.09	16067845.0
2016-10-14 16:00:00	SPY	ETF	213.09	213.24	212.89	213.02	10892033.0
2016-10-14 17:00:00	SPY	ETF	213.02	214.34	212.96	213.0	261883.0
2016-10-14 18:00:00	SPY	ETF	213.05	213.12	213.02	213.03	33950.0
2016-10-14 19:00:00	SPY	ETF	213.03	213.07	212.97	212.98	16263.0
2016-10-14 04:00:00	QQQ	ETF	117.04	117.04	117.03	117.03	700.0
2016-10-14 05:00:00	QQQ	ETF	117.14	117.34	117.14	117.34	11450.0
2016-10-14 06:00:00	QQQ	ETF	117.35	117.59	117.35	117.47	28650.0
2016-10-14 07:00:00	QQQ	ETF	117.47	117.49	117.4	117.41	32851.0
2016-10-14 08:00:00	QQQ	ETF	117.39	117.5	117.32	117.44	97140.0
2016-10-14 09:00:00	QQQ	ETF	117.47	118.05	117.47	117.9146	2788915.0
2016-10-14 10:00:00	QQQ	ETF	117.91	118.05	117.77	117.87	1944239.0
2016-10-14 11:00:00	QQQ	ETF	117.87	117.9	117.22	117.23	2957065.0
2016-10-14 12:00:00	QQQ	ETF	117.24	117.39	117.08	117.338	1715252.0
2016-10-14 13:00:00	QQQ	ETF	117.33	117.605	117.21	117.3	1756609.0
2016-10-14 14:00:00	QQQ	ETF	117.29	117.38	117.07	117.091	2078221.0
2016-10-14 15:00:00	QQQ	ETF	117.1	117.4	117.1	117.14	3853240.0
2016-10-14 16:00:00	QQQ	ETF	117.13	117.19	116.98	117.12	462774.0
2016-10-14 17:00:00	QQQ	ETF	117.08	117.1	117.05	117.05	1472.0
2016-10-14 18:00:00	QQQ	ETF	117.1	117.1	117.06	117.06	2910.0
2016-10-14 19:00:00	QQQ	ETF	117.08	117.08	117.01	117.07	4319.0
2016-10-14 04:00:00	IWM	ETF	121.03	121.03	121.03	121.03	250.0
2016-10-14 05:00:00	IWM	ETF	121.24	121.42	121.24	121.42	2100.0
2016-10-14 07:00:00	IWM	ETF	121.55	121.59	121.5	121.5	75679.0
2016-10-14 08:00:00	IWM	ETF	121.51	121.57	121.33	121.37	68378.0
2016-10-14 09:00:00	IWM	ETF	121.35	121.82	121.13	121.68	3911412.0
2016-10-14 10:00:00	IWM	ETF	121.69	121.84	121.18	121.2	2547335.0
2016-10-14 11:00:00	IWM	ETF	121.2	121.22	120.48	120.53	3088008.0
2016-10-14 12:00:00	IWM	ETF	120.54	121.05	120.45	120.7042	2144981.0
2016-10-14 13:00:00	IWM	ETF	120.7048	121.06	120.55	120.65	1872948.0
2016-10-14 14:00:00	IWM	ETF	120.65	120.85	120.49	120.54	1672677.0
2016-10-14 15:00:00	IWM	ETF	120.54	120.8	120.41	120.41	3678955.0
2016-10-14 16:00:00	IWM	ETF	120.43	120.56	120.25	120.48	3604533.0
2016-10-14 17:00:00	IWM	ETF	120.48	120.89	120.45	120.47	17515.0
2016-10-14 18:00:00	IWM	ETF	120.52	120.52	120.48	120.48	325.0
2016-10-14 19:00:00	IWM	ETF	120.45	120.45	120.4	120.43	2475.0
2016-10-14 06:00:00	DIA	ETF	181.66	181.97	181.66	181.82	5269.0
2016-10-14 07:00:00	DIA	ETF	181.82	181.82	181.82	181.82	2994.0
2016-10-14 08:00:00	DIA	ETF	181.67	181.84	181.6	181.81	7163.0

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

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