PREVIEW / etf_1hour / 2016-03-18

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-03-18.parquet
  size:    250 KB
  rows:    8,062

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-03-18 04:00:00	SPY	ETF	203.85	203.85	203.25	203.65	11916.0
2016-03-18 05:00:00	SPY	ETF	203.7	204.01	203.7	203.73	81226.0
2016-03-18 06:00:00	SPY	ETF	203.8	204.13	203.8	204.1	105600.0
2016-03-18 07:00:00	SPY	ETF	204.06	204.13	203.93	203.95	162506.0
2016-03-18 08:00:00	SPY	ETF	203.95	204.21	203.39	204.05	592604.0
2016-03-18 09:00:00	SPY	ETF	204.07	204.42	203.8	204.36	18760222.0
2016-03-18 10:00:00	SPY	ETF	204.36	204.58	204.13	204.44	24260802.0
2016-03-18 11:00:00	SPY	ETF	204.44	204.78	204.28	204.48	12268009.0
2016-03-18 12:00:00	SPY	ETF	204.48	204.67	204.34	204.45	9910317.0
2016-03-18 13:00:00	SPY	ETF	204.46	204.495	203.8	204.128	10553656.0
2016-03-18 14:00:00	SPY	ETF	204.13	204.32	204.04	204.0901	11732442.0
2016-03-18 15:00:00	SPY	ETF	204.095	204.69	204.09	204.44	30160420.0
2016-03-18 16:00:00	SPY	ETF	204.44	204.5244	204.16	204.44	13825897.0
2016-03-18 17:00:00	SPY	ETF	204.4	204.5	204.12	204.26	3139425.0
2016-03-18 18:00:00	SPY	ETF	204.19	204.38	204.13	204.2	114737.0
2016-03-18 19:00:00	SPY	ETF	204.21	204.25	203.77	204.19	116916.0
2016-03-18 04:00:00	QQQ	ETF	107.14	107.14	107.14	107.14	100.0
2016-03-18 06:00:00	QQQ	ETF	107.27	107.4	107.27	107.4	799.0
2016-03-18 07:00:00	QQQ	ETF	107.46	107.5	107.39	107.39	11245.0
2016-03-18 08:00:00	QQQ	ETF	107.39	107.49	107.35	107.39	69485.0
2016-03-18 09:00:00	QQQ	ETF	107.4	107.555	106.8	106.94	5964990.0
2016-03-18 10:00:00	QQQ	ETF	106.94	107.33	106.91	107.29	4715604.0
2016-03-18 11:00:00	QQQ	ETF	107.29	107.635	107.29	107.46	2397110.0
2016-03-18 12:00:00	QQQ	ETF	107.4666	107.61	107.4109	107.56	2117868.0
2016-03-18 13:00:00	QQQ	ETF	107.566	107.58	106.866	107.09	3884979.0
2016-03-18 14:00:00	QQQ	ETF	107.09	107.3	107.05	107.18	2275509.0
2016-03-18 15:00:00	QQQ	ETF	107.1801	107.51	107.1801	107.39	3506626.0
2016-03-18 16:00:00	QQQ	ETF	107.39	107.42	107.2	107.3	1377569.0
2016-03-18 17:00:00	QQQ	ETF	107.3	107.31	107.25	107.25	41391.0
2016-03-18 18:00:00	QQQ	ETF	107.27	107.29	107.25	107.27	3499.0
2016-03-18 19:00:00	QQQ	ETF	107.26	107.26	107.26	107.26	4275.0
2016-03-18 05:00:00	IWM	ETF	108.7	108.7	108.7	108.7	2500.0
2016-03-18 06:00:00	IWM	ETF	108.8	108.9	108.8	108.88	6000.0
2016-03-18 07:00:00	IWM	ETF	108.88	108.92	108.8	108.8	17488.0
2016-03-18 08:00:00	IWM	ETF	108.72	108.84	108.71	108.81	20764.0
2016-03-18 09:00:00	IWM	ETF	108.82	109.54	108.62	109.38	4006009.0
2016-03-18 10:00:00	IWM	ETF	109.38	109.74	109.24	109.48	4810185.0
2016-03-18 11:00:00	IWM	ETF	109.48	109.69	109.4	109.66	3088263.0
2016-03-18 12:00:00	IWM	ETF	109.66	109.95	109.55	109.725	3260750.0
2016-03-18 13:00:00	IWM	ETF	109.72	109.77	109.29	109.665	3500670.0
2016-03-18 14:00:00	IWM	ETF	109.66	109.77	109.48	109.505	3284530.0
2016-03-18 15:00:00	IWM	ETF	109.51	109.85	109.5	109.64	6773230.0
2016-03-18 16:00:00	IWM	ETF	109.66	109.78	109.5658	109.76	1815778.0
2016-03-18 17:00:00	IWM	ETF	109.75	109.77	109.6	109.6	960514.0
2016-03-18 18:00:00	IWM	ETF	109.61	109.62	109.6	109.62	1550.0
2016-03-18 19:00:00	IWM	ETF	109.62	109.62	109.58	109.6	7179.0
2016-03-18 05:00:00	DIA	ETF	174.9	174.9	174.88	174.88	1600.0
2016-03-18 07:00:00	DIA	ETF	175.03	175.03	175.02	175.02	3000.0
2016-03-18 08:00:00	DIA	ETF	175.02	175.18	175.02	175.18	6430.0
2016-03-18 09:00:00	DIA	ETF	175.16	175.53	174.96	175.53	714083.0

> showing 50 of 8,062 rows — these rows as CSV

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