PREVIEW / etf_1hour / 2014-06-16

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-06-16.parquet
  size:    213 KB
  rows:    6,822

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-06-16 04:00:00	SPY	ETF	193.7	193.7	193.53	193.53	535.0
2014-06-16 06:00:00	SPY	ETF	193.99	194.42	193.53	193.67	101606.0
2014-06-16 07:00:00	SPY	ETF	193.71	193.77	193.6	193.73	192761.0
2014-06-16 08:00:00	SPY	ETF	193.777	193.9	193.64	193.85	1037252.0
2014-06-16 09:00:00	SPY	ETF	193.86	194.42	193.73	194.27	13258464.0
2014-06-16 10:00:00	SPY	ETF	194.28	194.7	194.25	194.47	11966271.0
2014-06-16 11:00:00	SPY	ETF	194.48	194.49	193.66	193.865	12311071.0
2014-06-16 12:00:00	SPY	ETF	193.87	194.25	193.81	194.21	6275388.0
2014-06-16 13:00:00	SPY	ETF	194.2	194.569	194.15	194.29	7626951.0
2014-06-16 14:00:00	SPY	ETF	194.28	194.4	194.17	194.17	6772411.0
2014-06-16 15:00:00	SPY	ETF	194.18	194.37	193.97	194.3	11773033.0
2014-06-16 16:00:00	SPY	ETF	194.3	194.604	194.1526	194.29	13238348.0
2014-06-16 17:00:00	SPY	ETF	194.3	194.32	194.26	194.31	540902.0
2014-06-16 18:00:00	SPY	ETF	194.3	194.39	194.3	194.32	20285.0
2014-06-16 19:00:00	SPY	ETF	194.36	194.36	194.33	194.33	43384.0
2014-06-16 07:00:00	QQQ	ETF	92.11	92.11	92.08	92.08	2700.0
2014-06-16 08:00:00	QQQ	ETF	92.05	92.19	92.04	92.17	79095.0
2014-06-16 09:00:00	QQQ	ETF	92.16	92.52	92.06	92.43	3570964.0
2014-06-16 10:00:00	QQQ	ETF	92.44	92.67	92.385	92.42	3402674.0
2014-06-16 11:00:00	QQQ	ETF	92.42	92.43	91.96	92.13	2857299.0
2014-06-16 12:00:00	QQQ	ETF	92.13	92.345	92.1	92.3	1623194.0
2014-06-16 13:00:00	QQQ	ETF	92.304	92.48	92.215	92.26	1721229.0
2014-06-16 14:00:00	QQQ	ETF	92.25	92.46	92.245	92.3374	1182240.0
2014-06-16 15:00:00	QQQ	ETF	92.33	92.43	92.22	92.39	2584996.0
2014-06-16 16:00:00	QQQ	ETF	92.4	92.43	92.3143	92.41	3026750.0
2014-06-16 17:00:00	QQQ	ETF	92.43	92.43	92.43	92.43	200.0
2014-06-16 18:00:00	QQQ	ETF	92.43	92.47	92.43	92.47	29323.0
2014-06-16 19:00:00	QQQ	ETF	92.46	92.47	92.44	92.44	6100.0
2014-06-16 05:00:00	IWM	ETF	115.12	115.12	115.12	115.12	100.0
2014-06-16 06:00:00	IWM	ETF	115.12	115.12	115.12	115.12	100.0
2014-06-16 07:00:00	IWM	ETF	115.12	115.27	114.97	115.17	14650.0
2014-06-16 08:00:00	IWM	ETF	115.59	115.59	115.33	115.38	77310.0
2014-06-16 09:00:00	IWM	ETF	115.38	115.88	115.29	115.74	2479807.0
2014-06-16 10:00:00	IWM	ETF	115.76	116.13	115.61	115.69	3570867.0
2014-06-16 11:00:00	IWM	ETF	115.69	115.7	115.1	115.495	4133965.0
2014-06-16 12:00:00	IWM	ETF	115.5	115.94	115.44	115.89	2346970.0
2014-06-16 13:00:00	IWM	ETF	115.88	116.11	115.82	115.905	2300578.0
2014-06-16 14:00:00	IWM	ETF	115.905	116.08	115.87	115.88	1509670.0
2014-06-16 15:00:00	IWM	ETF	115.88	116.15	115.72	116.13	3384906.0
2014-06-16 16:00:00	IWM	ETF	116.13	116.1609	116.07	116.14	4168525.0
2014-06-16 17:00:00	IWM	ETF	116.21	116.21	116.21	116.21	100.0
2014-06-16 18:00:00	IWM	ETF	116.21	116.22	116.21	116.22	1200.0
2014-06-16 19:00:00	IWM	ETF	116.15	116.15	116.13	116.13	615.0
2014-06-16 08:00:00	DIA	ETF	167.33	167.34	167.3	167.3	351.0
2014-06-16 09:00:00	DIA	ETF	167.3	167.61	167.14	167.53	476952.0
2014-06-16 10:00:00	DIA	ETF	167.53	167.9199	167.48	167.8	529765.0
2014-06-16 11:00:00	DIA	ETF	167.8	167.84	167.18	167.28	413993.0
2014-06-16 12:00:00	DIA	ETF	167.28	167.6	167.24	167.56	146974.0
2014-06-16 13:00:00	DIA	ETF	167.55	167.97	167.54	167.75	270473.0
2014-06-16 14:00:00	DIA	ETF	167.76	167.84	167.68	167.69	216501.0

> showing 50 of 6,822 rows — these rows as CSV

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