PREVIEW / etf_1hour / 2014-11-20

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-11-20.parquet
  size:    227 KB
  rows:    7,205

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
2014-11-20 04:00:00	SPY	ETF	205.0	205.0	204.4	204.58	32815.0
2014-11-20 05:00:00	SPY	ETF	204.57	204.57	204.34	204.39	38773.0
2014-11-20 06:00:00	SPY	ETF	204.42	204.56	204.21	204.28	72139.0
2014-11-20 07:00:00	SPY	ETF	204.28	204.5	204.25	204.47	237726.0
2014-11-20 08:00:00	SPY	ETF	204.48	205.5	204.17	204.23	986713.0
2014-11-20 09:00:00	SPY	ETF	204.23	204.92	204.06	204.86	10619140.0
2014-11-20 10:00:00	SPY	ETF	204.825	205.52	204.825	205.415	13836596.0
2014-11-20 11:00:00	SPY	ETF	205.41	205.71	205.4	205.5199	7265702.0
2014-11-20 12:00:00	SPY	ETF	205.515	205.64	205.38	205.45	5114970.0
2014-11-20 13:00:00	SPY	ETF	205.46	205.56	205.32	205.4806	4349962.0
2014-11-20 14:00:00	SPY	ETF	205.484	205.63	205.33	205.35	6073142.0
2014-11-20 15:00:00	SPY	ETF	205.35	205.625	205.24	205.59	16655232.0
2014-11-20 16:00:00	SPY	ETF	205.6	205.76	205.1767	205.76	5564090.0
2014-11-20 17:00:00	SPY	ETF	205.74	205.74	205.68	205.71	147201.0
2014-11-20 18:00:00	SPY	ETF	205.7	205.7	205.58	205.59	137422.0
2014-11-20 19:00:00	SPY	ETF	205.59	205.64	205.5	205.63	106472.0
2014-11-20 04:00:00	QQQ	ETF	102.92	102.92	102.76	102.76	1050.0
2014-11-20 05:00:00	QQQ	ETF	102.75	102.77	102.72	102.75	10800.0
2014-11-20 06:00:00	QQQ	ETF	102.74	102.82	102.71	102.74	31800.0
2014-11-20 07:00:00	QQQ	ETF	102.73	102.83	102.72	102.8	14400.0
2014-11-20 08:00:00	QQQ	ETF	102.79	102.9	102.74	102.75	129321.0
2014-11-20 09:00:00	QQQ	ETF	102.75	103.265	102.67	103.26	3481791.0
2014-11-20 10:00:00	QQQ	ETF	103.255	103.57	103.17	103.53	3554909.0
2014-11-20 11:00:00	QQQ	ETF	103.54	103.72	103.521	103.62	2125081.0
2014-11-20 12:00:00	QQQ	ETF	103.62	103.73	103.55	103.68	1641215.0
2014-11-20 13:00:00	QQQ	ETF	103.6868	103.7	103.53	103.64	1221688.0
2014-11-20 14:00:00	QQQ	ETF	103.645	103.76	103.56	103.57	1167986.0
2014-11-20 15:00:00	QQQ	ETF	103.57	103.68	103.515	103.67	3089228.0
2014-11-20 16:00:00	QQQ	ETF	103.67	103.79	102.95	103.74	943610.0
2014-11-20 17:00:00	QQQ	ETF	103.74	103.76	103.72	103.72	15584.0
2014-11-20 18:00:00	QQQ	ETF	103.72	103.73	103.64	103.64	51423.0
2014-11-20 19:00:00	QQQ	ETF	103.65	103.67	103.58	103.67	23515.0
2014-11-20 06:00:00	IWM	ETF	114.7	114.7	114.7	114.7	600.0
2014-11-20 07:00:00	IWM	ETF	114.78	114.92	114.78	114.86	14300.0
2014-11-20 08:00:00	IWM	ETF	114.92	114.99	114.55	114.57	98449.0
2014-11-20 09:00:00	IWM	ETF	114.57	115.4	114.45	115.3	3569998.0
2014-11-20 10:00:00	IWM	ETF	115.31	115.94	115.31	115.75	2793604.0
2014-11-20 11:00:00	IWM	ETF	115.75	116.03	115.74	115.865	2198881.0
2014-11-20 12:00:00	IWM	ETF	115.8601	116.15	115.8232	115.985	1673653.0
2014-11-20 13:00:00	IWM	ETF	115.99	116.1331	115.865	116.13	1404291.0
2014-11-20 14:00:00	IWM	ETF	116.14	116.24	116.0	116.01	1756132.0
2014-11-20 15:00:00	IWM	ETF	116.01	116.46	115.91	116.44	5213229.0
2014-11-20 16:00:00	IWM	ETF	116.45	116.48	115.109	116.48	1783925.0
2014-11-20 17:00:00	IWM	ETF	116.44	116.46	116.37	116.375	17728.0
2014-11-20 18:00:00	IWM	ETF	116.39	116.39	116.39	116.39	1850.0
2014-11-20 19:00:00	IWM	ETF	116.39	116.43	116.39	116.39	3356.0
2014-11-20 08:00:00	DIA	ETF	176.4	176.4	176.15	176.16	23150.0
2014-11-20 09:00:00	DIA	ETF	176.16	176.47	175.98	176.42	287518.0
2014-11-20 10:00:00	DIA	ETF	176.42	176.95	176.42	176.86	666418.0
2014-11-20 11:00:00	DIA	ETF	176.86	177.1	176.86	176.98	297605.0

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

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