PREVIEW / etf_1hour / 2017-07-07

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-07-07.parquet
  size:    273 KB
  rows:    9,037

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
2017-07-07 04:00:00	SPY	ETF	240.75	240.82	240.68	240.68	9825.0
2017-07-07 05:00:00	SPY	ETF	240.68	240.81	240.63	240.63	12722.0
2017-07-07 06:00:00	SPY	ETF	240.75	240.85	240.72	240.77	89090.0
2017-07-07 07:00:00	SPY	ETF	240.76	240.76	240.65	240.69	43064.0
2017-07-07 08:00:00	SPY	ETF	240.69	241.54	240.66	241.14	1163080.0
2017-07-07 09:00:00	SPY	ETF	241.15	241.56	241.0	241.49	5695317.0
2017-07-07 10:00:00	SPY	ETF	241.48	241.58	241.05	241.31	5089453.0
2017-07-07 11:00:00	SPY	ETF	241.31	242.0301	241.23	241.94	7032703.0
2017-07-07 12:00:00	SPY	ETF	241.94	242.21	241.921	242.15	3873508.0
2017-07-07 13:00:00	SPY	ETF	242.14	242.28	242.085	242.2	2500542.0
2017-07-07 14:00:00	SPY	ETF	242.2	242.27	242.0214	242.04	3983671.0
2017-07-07 15:00:00	SPY	ETF	242.04	242.26	241.94	242.1	13674709.0
2017-07-07 16:00:00	SPY	ETF	242.1	242.16	241.8174	242.1	11127308.0
2017-07-07 17:00:00	SPY	ETF	242.09	242.12	242.05	242.05	1092507.0
2017-07-07 18:00:00	SPY	ETF	242.06	242.08	242.03	242.07	48101.0
2017-07-07 19:00:00	SPY	ETF	242.03	242.07	242.02	242.06	24676.0
2017-07-07 04:00:00	QQQ	ETF	136.25	136.37	136.22	136.37	5447.0
2017-07-07 05:00:00	QQQ	ETF	136.34	136.34	136.19	136.19	6999.0
2017-07-07 06:00:00	QQQ	ETF	136.33	136.5	136.31	136.39	74485.0
2017-07-07 07:00:00	QQQ	ETF	136.38	136.49	136.3	136.34	30182.0
2017-07-07 08:00:00	QQQ	ETF	136.31	137.13	136.3	136.68	485313.0
2017-07-07 09:00:00	QQQ	ETF	136.69	137.395	136.6	137.35	6220917.0
2017-07-07 10:00:00	QQQ	ETF	137.34	137.46	136.99	137.21	5301837.0
2017-07-07 11:00:00	QQQ	ETF	137.22	137.79	137.14	137.68	3488132.0
2017-07-07 12:00:00	QQQ	ETF	137.69	137.88	137.64	137.805	1614929.0
2017-07-07 13:00:00	QQQ	ETF	137.8	138.13	137.77	138.05	2285089.0
2017-07-07 14:00:00	QQQ	ETF	138.05	138.07	137.73	137.84	3283713.0
2017-07-07 15:00:00	QQQ	ETF	137.84	137.88	137.62	137.72	5477945.0
2017-07-07 16:00:00	QQQ	ETF	137.72	137.78	137.58	137.67	1923543.0
2017-07-07 17:00:00	QQQ	ETF	137.63	137.7	137.61	137.62	7675.0
2017-07-07 18:00:00	QQQ	ETF	137.68	137.7	137.62	137.62	1306.0
2017-07-07 19:00:00	QQQ	ETF	137.7	137.7	137.62	137.67	5058.0
2017-07-07 04:00:00	IWM	ETF	139.1	139.1	139.0	139.0	602.0
2017-07-07 06:00:00	IWM	ETF	139.12	139.14	139.08	139.14	47418.0
2017-07-07 07:00:00	IWM	ETF	139.14	139.17	139.08	139.13	10513.0
2017-07-07 08:00:00	IWM	ETF	139.13	139.68	139.13	139.41	270024.0
2017-07-07 09:00:00	IWM	ETF	139.38	139.87	139.18	139.72	2183229.0
2017-07-07 10:00:00	IWM	ETF	139.72	139.74	139.35	139.45	2441278.0
2017-07-07 11:00:00	IWM	ETF	139.45	140.31	139.41	140.09	3658219.0
2017-07-07 12:00:00	IWM	ETF	140.09	140.49	140.09	140.3108	1571215.0
2017-07-07 13:00:00	IWM	ETF	140.32	140.45	140.09	140.19	1477900.0
2017-07-07 14:00:00	IWM	ETF	140.19	140.39	140.12	140.18	1268941.0
2017-07-07 15:00:00	IWM	ETF	140.19	140.68	140.14	140.48	4327427.0
2017-07-07 16:00:00	IWM	ETF	140.49	140.5413	140.11	140.13	1376115.0
2017-07-07 17:00:00	IWM	ETF	140.14	140.3	140.14	140.25	12560.0
2017-07-07 18:00:00	IWM	ETF	140.26	140.26	140.24	140.24	4385.0
2017-07-07 19:00:00	IWM	ETF	140.24	140.24	140.15	140.15	2300.0
2017-07-07 08:00:00	DIA	ETF	213.15	213.67	213.13	213.57	1650.0
2017-07-07 09:00:00	DIA	ETF	213.57	213.86	213.44	213.7361	190502.0
2017-07-07 10:00:00	DIA	ETF	213.75	213.7875	213.42	213.62	188521.0

> showing 50 of 9,037 rows — these rows as CSV

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