PREVIEW / etf_1hour / 2015-12-01

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-12-01.parquet
  size:    245 KB
  rows:    7,843

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-12-01 04:00:00	SPY	ETF	209.43	209.44	209.24	209.3	30375.0
2015-12-01 05:00:00	SPY	ETF	209.3	209.36	209.07	209.36	54490.0
2015-12-01 06:00:00	SPY	ETF	209.37	209.65	209.37	209.44	44404.0
2015-12-01 07:00:00	SPY	ETF	209.45	209.59	209.33	209.51	111106.0
2015-12-01 08:00:00	SPY	ETF	209.52	209.67	209.27	209.32	426233.0
2015-12-01 09:00:00	SPY	ETF	209.32	210.39	209.31	210.24	13009419.0
2015-12-01 10:00:00	SPY	ETF	210.23	210.26	209.11	209.89	20461107.0
2015-12-01 11:00:00	SPY	ETF	209.9	209.975	209.47	209.725	10494929.0
2015-12-01 12:00:00	SPY	ETF	209.725	210.12	209.69	210.055	7659962.0
2015-12-01 13:00:00	SPY	ETF	210.0501	210.06	209.53	209.66	6239018.0
2015-12-01 14:00:00	SPY	ETF	209.67	210.2	209.64	210.045	11426758.0
2015-12-01 15:00:00	SPY	ETF	210.05	210.82	210.025	210.74	21505171.0
2015-12-01 16:00:00	SPY	ETF	210.74	210.77	210.61	210.64	4496563.0
2015-12-01 17:00:00	SPY	ETF	210.66	210.71	210.63	210.63	204592.0
2015-12-01 18:00:00	SPY	ETF	210.62	210.68	210.48	210.48	164907.0
2015-12-01 19:00:00	SPY	ETF	210.51	210.63	210.49	210.62	80281.0
2015-12-01 04:00:00	QQQ	ETF	114.4	114.4	114.4	114.4	1000.0
2015-12-01 06:00:00	QQQ	ETF	114.53	114.53	114.49	114.49	5500.0
2015-12-01 07:00:00	QQQ	ETF	114.51	114.51	114.38	114.5	10389.0
2015-12-01 08:00:00	QQQ	ETF	114.49	114.52	114.4	114.41	44776.0
2015-12-01 09:00:00	QQQ	ETF	114.45	115.0	114.34	114.99	3952168.0
2015-12-01 10:00:00	QQQ	ETF	114.98	115.0	114.25	114.82	6511924.0
2015-12-01 11:00:00	QQQ	ETF	114.82	114.89	114.55	114.71	2361932.0
2015-12-01 12:00:00	QQQ	ETF	114.71	114.94	114.705	114.89	1594242.0
2015-12-01 13:00:00	QQQ	ETF	114.88	114.895	113.9108	114.5849	3507657.0
2015-12-01 14:00:00	QQQ	ETF	114.585	114.89	114.56	114.82	1467524.0
2015-12-01 15:00:00	QQQ	ETF	114.83	115.16	113.9108	115.15	6107481.0
2015-12-01 16:00:00	QQQ	ETF	115.14	115.2	114.46	115.17	1681021.0
2015-12-01 17:00:00	QQQ	ETF	115.17	115.17	115.11	115.14	1502.0
2015-12-01 18:00:00	QQQ	ETF	115.17	115.18	115.11	115.11	11091.0
2015-12-01 19:00:00	QQQ	ETF	115.13	115.16	115.13	115.16	2210.0
2015-12-01 07:00:00	IWM	ETF	119.65	119.67	119.6	119.67	4100.0
2015-12-01 08:00:00	IWM	ETF	119.69	119.71	119.53	119.55	52932.0
2015-12-01 09:00:00	IWM	ETF	119.59	119.87	119.41	119.75	2433659.0
2015-12-01 10:00:00	IWM	ETF	119.72	119.74	118.94	119.4	4594979.0
2015-12-01 11:00:00	IWM	ETF	119.405	119.45	118.9	119.0385	2548569.0
2015-12-01 12:00:00	IWM	ETF	119.035	119.44	119.035	119.3801	1945961.0
2015-12-01 13:00:00	IWM	ETF	119.375	119.53	119.18	119.41	1934841.0
2015-12-01 14:00:00	IWM	ETF	119.405	119.91	119.395	119.72	4089215.0
2015-12-01 15:00:00	IWM	ETF	119.71	119.89	119.7	119.86	3783648.0
2015-12-01 16:00:00	IWM	ETF	119.85	119.95	119.79	119.88	1088283.0
2015-12-01 17:00:00	IWM	ETF	119.9	119.9	119.82	119.82	535.0
2015-12-01 18:00:00	IWM	ETF	119.9	119.9	119.79	119.79	300.0
2015-12-01 06:00:00	DIA	ETF	178.1	178.14	177.93	177.96	2100.0
2015-12-01 07:00:00	DIA	ETF	177.9	177.9	177.9	177.9	200.0
2015-12-01 08:00:00	DIA	ETF	177.9	177.9	177.73	177.78	1800.0
2015-12-01 09:00:00	DIA	ETF	177.86	178.87	177.751	178.7111	890307.0
2015-12-01 10:00:00	DIA	ETF	178.71	178.74	177.64	178.42	1579169.0
2015-12-01 11:00:00	DIA	ETF	178.42	178.47	178.0	178.18	592672.0
2015-12-01 12:00:00	DIA	ETF	178.17	178.4713	178.14	178.45	241511.0

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

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