PREVIEW / etf_1hour / 2016-07-25

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-07-25.parquet
  size:    249 KB
  rows:    7,980

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-25 04:00:00	SPY	ETF	217.15	217.46	217.1	217.29	12797.0
2016-07-25 05:00:00	SPY	ETF	217.26	217.29	217.12	217.24	17903.0
2016-07-25 06:00:00	SPY	ETF	217.14	217.22	217.07	217.22	8242.0
2016-07-25 07:00:00	SPY	ETF	217.22	217.32	217.12	217.25	47075.0
2016-07-25 08:00:00	SPY	ETF	217.25	217.28	217.04	217.04	223087.0
2016-07-25 09:00:00	SPY	ETF	217.05	217.15	216.55	216.59	6422445.0
2016-07-25 10:00:00	SPY	ETF	216.58	216.63	216.2	216.285	9066649.0
2016-07-25 11:00:00	SPY	ETF	216.29	216.34	216.01	216.1065	6680069.0
2016-07-25 12:00:00	SPY	ETF	216.1	216.31	215.97	216.2258	4365658.0
2016-07-25 13:00:00	SPY	ETF	216.22	216.39	216.09	216.33	3909271.0
2016-07-25 14:00:00	SPY	ETF	216.32	216.51	216.22	216.28	4871793.0
2016-07-25 15:00:00	SPY	ETF	216.28	216.68	216.19	216.67	10321311.0
2016-07-25 16:00:00	SPY	ETF	216.67	216.7	216.53	216.7	5606402.0
2016-07-25 17:00:00	SPY	ETF	216.67	216.74	216.64	216.67	58665.0
2016-07-25 18:00:00	SPY	ETF	216.67	216.69	216.54	216.56	56466.0
2016-07-25 19:00:00	SPY	ETF	216.56	216.6	216.55	216.57	45214.0
2016-07-25 04:00:00	QQQ	ETF	113.64	113.64	113.64	113.64	398.0
2016-07-25 06:00:00	QQQ	ETF	113.58	113.58	113.52	113.52	4800.0
2016-07-25 07:00:00	QQQ	ETF	113.64	113.65	113.56	113.62	16470.0
2016-07-25 08:00:00	QQQ	ETF	113.6	113.62	113.53	113.53	17929.0
2016-07-25 09:00:00	QQQ	ETF	113.54	113.69	113.4225	113.46	1976172.0
2016-07-25 10:00:00	QQQ	ETF	113.45	113.59	113.32	113.49	1538560.0
2016-07-25 11:00:00	QQQ	ETF	113.49	113.5458	113.33	113.37	1111327.0
2016-07-25 12:00:00	QQQ	ETF	113.38	113.4477	113.28	113.4	1207853.0
2016-07-25 13:00:00	QQQ	ETF	113.41	113.55	113.33	113.48	872549.0
2016-07-25 14:00:00	QQQ	ETF	113.47	113.57	113.42	113.45	1155890.0
2016-07-25 15:00:00	QQQ	ETF	113.45	113.67	113.39	113.67	1600408.0
2016-07-25 16:00:00	QQQ	ETF	113.66	113.66	113.5	113.64	219307.0
2016-07-25 17:00:00	QQQ	ETF	113.64	113.64	113.64	113.64	1151.0
2016-07-25 18:00:00	QQQ	ETF	113.6	113.6	113.53	113.53	2259.0
2016-07-25 19:00:00	QQQ	ETF	113.57	113.6	113.55	113.56	5310.0
2016-07-25 04:00:00	IWM	ETF	120.38	120.38	120.38	120.38	100.0
2016-07-25 06:00:00	IWM	ETF	120.31	120.31	120.25	120.25	200.0
2016-07-25 07:00:00	IWM	ETF	120.4	120.4	120.28	120.36	24000.0
2016-07-25 08:00:00	IWM	ETF	120.36	120.36	120.17	120.17	28337.0
2016-07-25 09:00:00	IWM	ETF	120.16	120.46	120.08	120.37	1986467.0
2016-07-25 10:00:00	IWM	ETF	120.37	120.41	119.99	120.19	2298570.0
2016-07-25 11:00:00	IWM	ETF	120.18	120.18	119.76	119.95	2238001.0
2016-07-25 12:00:00	IWM	ETF	119.96	120.18	119.86	120.14	969991.0
2016-07-25 13:00:00	IWM	ETF	120.14	120.31	120.0	120.25	1114032.0
2016-07-25 14:00:00	IWM	ETF	120.245	120.37	120.17	120.21	865752.0
2016-07-25 15:00:00	IWM	ETF	120.21	120.25	120.0	120.2	2467947.0
2016-07-25 16:00:00	IWM	ETF	120.2	120.26	120.06	120.26	856990.0
2016-07-25 17:00:00	IWM	ETF	120.26	120.26	120.24	120.24	7765.0
2016-07-25 18:00:00	IWM	ETF	120.24	120.24	120.22	120.22	2200.0
2016-07-25 19:00:00	IWM	ETF	120.22	120.25	120.22	120.22	2722.0
2016-07-25 08:00:00	DIA	ETF	185.43	185.55	185.37	185.37	1750.0
2016-07-25 09:00:00	DIA	ETF	185.36	185.36	184.89	184.94	269752.0
2016-07-25 10:00:00	DIA	ETF	184.91	184.96	184.5681	184.63	290267.0
2016-07-25 11:00:00	DIA	ETF	184.62	184.65	184.45	184.51	192453.0

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

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