PREVIEW / etf_1hour / 2015-11-18

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-11-18.parquet
  size:    244 KB
  rows:    7,723

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
2015-11-18 04:00:00	SPY	ETF	205.25	205.33	205.22	205.3	53365.0
2015-11-18 05:00:00	SPY	ETF	205.27	205.34	205.09	205.15	13046.0
2015-11-18 06:00:00	SPY	ETF	205.27	205.9	205.27	205.9	42597.0
2015-11-18 07:00:00	SPY	ETF	205.95	206.1	205.75	205.83	214182.0
2015-11-18 08:00:00	SPY	ETF	205.82	206.37	205.76	206.32	905918.0
2015-11-18 09:00:00	SPY	ETF	206.32	206.77	205.99	206.5	10204086.0
2015-11-18 10:00:00	SPY	ETF	206.49	206.725	206.13	206.54	11043714.0
2015-11-18 11:00:00	SPY	ETF	206.54	207.22	206.2477	206.95	11769851.0
2015-11-18 12:00:00	SPY	ETF	206.95	207.19	206.67	206.93	8822889.0
2015-11-18 13:00:00	SPY	ETF	206.93	207.29	206.88	206.89	7430640.0
2015-11-18 14:00:00	SPY	ETF	206.91	208.08	206.74	208.06	22141107.0
2015-11-18 15:00:00	SPY	ETF	208.05	208.9	207.8	208.71	32679550.0
2015-11-18 16:00:00	SPY	ETF	208.71	208.82	205.3958	208.56	14073543.0
2015-11-18 17:00:00	SPY	ETF	208.57	208.68	208.51	208.52	102510.0
2015-11-18 18:00:00	SPY	ETF	208.52	208.83	208.49	208.82	108774.0
2015-11-18 19:00:00	SPY	ETF	208.74	209.03	208.69	208.95	86404.0
2015-11-18 06:00:00	QQQ	ETF	111.46	111.7	111.46	111.7	4900.0
2015-11-18 07:00:00	QQQ	ETF	111.76	111.88	111.75	111.81	39619.0
2015-11-18 08:00:00	QQQ	ETF	111.84	112.08	111.8	112.03	143261.0
2015-11-18 09:00:00	QQQ	ETF	112.01	112.31	111.83	112.13	3138349.0
2015-11-18 10:00:00	QQQ	ETF	112.14	112.38	112.07	112.3	3669904.0
2015-11-18 11:00:00	QQQ	ETF	112.3	112.69	112.14	112.59	4105361.0
2015-11-18 12:00:00	QQQ	ETF	112.59	112.71	112.43	112.53	2770943.0
2015-11-18 13:00:00	QQQ	ETF	112.53	112.79	112.51	112.685	1926530.0
2015-11-18 14:00:00	QQQ	ETF	112.68	113.28	112.56	113.26	6540314.0
2015-11-18 15:00:00	QQQ	ETF	113.26	113.74	113.045	113.61	8455667.0
2015-11-18 16:00:00	QQQ	ETF	113.63	113.7	113.6	113.61	511110.0
2015-11-18 17:00:00	QQQ	ETF	113.6	113.64	113.58	113.63	36818.0
2015-11-18 18:00:00	QQQ	ETF	113.58	113.74	113.54	113.71	33423.0
2015-11-18 19:00:00	QQQ	ETF	113.71	113.84	113.7	113.8	54842.0
2015-11-18 04:00:00	IWM	ETF	114.47	114.47	114.42	114.42	200.0
2015-11-18 07:00:00	IWM	ETF	114.9	114.97	114.74	114.82	60749.0
2015-11-18 08:00:00	IWM	ETF	114.75	115.14	114.72	115.09	59959.0
2015-11-18 09:00:00	IWM	ETF	115.04	115.3	114.52	115.0401	3615291.0
2015-11-18 10:00:00	IWM	ETF	115.03	115.39	114.54	115.02	5580645.0
2015-11-18 11:00:00	IWM	ETF	115.02	115.5	114.93	115.43	4331198.0
2015-11-18 12:00:00	IWM	ETF	115.43	115.67	115.27	115.505	2421762.0
2015-11-18 13:00:00	IWM	ETF	115.51	115.7999	115.47	115.54	2096955.0
2015-11-18 14:00:00	IWM	ETF	115.55	116.17	115.43	116.15	5943398.0
2015-11-18 15:00:00	IWM	ETF	116.145	116.65	116.04	116.53	7226353.0
2015-11-18 16:00:00	IWM	ETF	116.53	116.65	116.3134	116.54	1245482.0
2015-11-18 17:00:00	IWM	ETF	116.53	116.55	116.53	116.53	1000.0
2015-11-18 18:00:00	IWM	ETF	116.55	116.55	116.55	116.55	1000.0
2015-11-18 19:00:00	IWM	ETF	116.5	116.6	116.5	116.6	11560.0
2015-11-18 08:00:00	DIA	ETF	175.54	175.66	175.54	175.66	3400.0
2015-11-18 09:00:00	DIA	ETF	175.75	176.37	175.667	176.17	633389.0
2015-11-18 10:00:00	DIA	ETF	176.17	176.33	175.9	176.24	493663.0
2015-11-18 11:00:00	DIA	ETF	176.23	176.77	175.96	176.52	546394.0
2015-11-18 12:00:00	DIA	ETF	176.53	176.75	176.33	176.54	431198.0
2015-11-18 13:00:00	DIA	ETF	176.53	176.76	176.371	176.38	386150.0

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

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