PREVIEW / etf_1hour / 2018-02-07

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-02-07.parquet
  size:    324 KB
  rows:    10,615

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
2018-02-07 04:00:00	SPY	ETF	266.94	267.2	266.38	266.61	63844.0
2018-02-07 05:00:00	SPY	ETF	266.7	267.06	266.42	266.58	35183.0
2018-02-07 06:00:00	SPY	ETF	266.42	268.16	266.32	268.0	142457.0
2018-02-07 07:00:00	SPY	ETF	268.17	268.49	267.7	268.06	714228.0
2018-02-07 08:00:00	SPY	ETF	267.92	268.54	265.92	267.97	760290.0
2018-02-07 09:00:00	SPY	ETF	267.92	270.4	267.72	270.06	18087195.0
2018-02-07 10:00:00	SPY	ETF	270.06	271.3	269.65	271.14	21241661.0
2018-02-07 11:00:00	SPY	ETF	271.125	272.36	270.74	271.62	16166347.0
2018-02-07 12:00:00	SPY	ETF	271.63	271.78	270.065	270.19	19756733.0
2018-02-07 13:00:00	SPY	ETF	270.2	270.67	268.3	269.7	24689776.0
2018-02-07 14:00:00	SPY	ETF	269.71	270.12	267.97	269.0197	14542365.0
2018-02-07 15:00:00	SPY	ETF	269.01	270.72	267.63	267.66	30788919.0
2018-02-07 16:00:00	SPY	ETF	267.65	269.8611	266.02	266.4	17764956.0
2018-02-07 17:00:00	SPY	ETF	266.48	270.8768	266.12	266.22	487717.0
2018-02-07 18:00:00	SPY	ETF	266.23	266.48	264.3	264.5	313060.0
2018-02-07 19:00:00	SPY	ETF	264.56	267.67	264.56	265.92	296791.0
2018-02-07 04:00:00	QQQ	ETF	160.72	160.84	160.33	160.6	62308.0
2018-02-07 05:00:00	QQQ	ETF	160.77	161.0	160.36	160.46	21719.0
2018-02-07 06:00:00	QQQ	ETF	160.42	161.29	160.42	161.29	70498.0
2018-02-07 07:00:00	QQQ	ETF	161.3	161.7	161.25	161.51	250036.0
2018-02-07 08:00:00	QQQ	ETF	162.31	162.31	160.02	161.6	200096.0
2018-02-07 09:00:00	QQQ	ETF	161.54	162.35	161.24	162.18	13052356.0
2018-02-07 10:00:00	QQQ	ETF	162.17	162.97	161.935	162.86	10274886.0
2018-02-07 11:00:00	QQQ	ETF	162.87	163.55	162.55	162.929	6476600.0
2018-02-07 12:00:00	QQQ	ETF	162.93	163.0	161.45	161.6	5777068.0
2018-02-07 13:00:00	QQQ	ETF	161.6	161.98	160.2895	161.68	9603879.0
2018-02-07 14:00:00	QQQ	ETF	161.7	161.91	160.26	160.89	6823593.0
2018-02-07 15:00:00	QQQ	ETF	160.89	162.03	160.2	160.21	10978099.0
2018-02-07 16:00:00	QQQ	ETF	160.2	160.34	159.1	159.45	3210835.0
2018-02-07 17:00:00	QQQ	ETF	159.6	160.16	159.25	159.36	111411.0
2018-02-07 18:00:00	QQQ	ETF	159.4	159.61	158.07	158.07	1089497.0
2018-02-07 19:00:00	QQQ	ETF	158.29	159.62	158.29	159.46	74793.0
2018-02-07 04:00:00	IWM	ETF	148.65	148.68	148.08	148.13	10016.0
2018-02-07 05:00:00	IWM	ETF	148.54	148.67	148.39	148.39	9639.0
2018-02-07 06:00:00	IWM	ETF	148.4	149.47	148.37	149.47	7220.0
2018-02-07 07:00:00	IWM	ETF	149.48	149.79	149.22	149.55	59568.0
2018-02-07 08:00:00	IWM	ETF	149.64	149.64	149.01	149.31	109378.0
2018-02-07 09:00:00	IWM	ETF	149.27	150.65	148.61	149.91	5048879.0
2018-02-07 10:00:00	IWM	ETF	149.89	150.54	149.38	150.35	6335394.0
2018-02-07 11:00:00	IWM	ETF	150.34	150.78	149.81	150.21	4143017.0
2018-02-07 12:00:00	IWM	ETF	150.22	150.67	149.97	149.98	3204093.0
2018-02-07 13:00:00	IWM	ETF	149.99	150.36	149.34	150.14	4174055.0
2018-02-07 14:00:00	IWM	ETF	150.15	150.55	149.39	149.9499	2648337.0
2018-02-07 15:00:00	IWM	ETF	149.93	150.79	149.78	149.82	4494570.0
2018-02-07 16:00:00	IWM	ETF	149.82	149.9	148.33	148.76	1286960.0
2018-02-07 17:00:00	IWM	ETF	148.76	149.797	148.7	148.8	129295.0
2018-02-07 18:00:00	IWM	ETF	148.7	148.73	147.75	147.8	71258.0
2018-02-07 19:00:00	IWM	ETF	147.95	149.7933	147.95	148.82	135596.0
2018-02-07 04:00:00	DIA	ETF	246.56	246.56	246.2	246.21	433.0
2018-02-07 06:00:00	DIA	ETF	246.33	247.7	246.14	247.7	3400.0

> showing 50 of 10,615 rows — these rows as CSV

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