PREVIEW / etf_1hour / 2014-07-10

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-07-10.parquet
  size:    233 KB
  rows:    7,634

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-07-10 04:00:00	SPY	ETF	196.97	196.97	196.05	196.13	19218.0
2014-07-10 05:00:00	SPY	ETF	196.03	196.34	195.53	195.7	157925.0
2014-07-10 06:00:00	SPY	ETF	195.68	195.73	195.33	195.38	340730.0
2014-07-10 07:00:00	SPY	ETF	195.42	195.6	195.25	195.45	1046149.0
2014-07-10 08:00:00	SPY	ETF	195.47	195.61	195.12	195.12	1739333.0
2014-07-10 09:00:00	SPY	ETF	195.13	195.6	195.04	195.41	21412171.0
2014-07-10 10:00:00	SPY	ETF	195.4	196.15	195.37	196.14	20176481.0
2014-07-10 11:00:00	SPY	ETF	196.14	196.27	195.95	196.15	9282833.0
2014-07-10 12:00:00	SPY	ETF	196.14	196.48	196.04	196.32	8046970.0
2014-07-10 13:00:00	SPY	ETF	196.315	196.86	196.26	196.55	9002083.0
2014-07-10 14:00:00	SPY	ETF	196.56	196.68	196.2	196.2	7174648.0
2014-07-10 15:00:00	SPY	ETF	196.2	196.53	196.03	196.335	13982800.0
2014-07-10 16:00:00	SPY	ETF	196.31	197.1238	195.4655	196.16	5589836.0
2014-07-10 17:00:00	SPY	ETF	196.15	196.26	196.14	196.15	142652.0
2014-07-10 18:00:00	SPY	ETF	196.18	196.22	196.13	196.22	117732.0
2014-07-10 19:00:00	SPY	ETF	196.19	196.22	196.14	196.17	15591.0
2014-07-10 04:00:00	QQQ	ETF	94.99	94.99	94.65	94.65	6700.0
2014-07-10 05:00:00	QQQ	ETF	94.48	94.48	94.19	94.31	30690.0
2014-07-10 06:00:00	QQQ	ETF	94.26	94.27	94.06	94.06	40350.0
2014-07-10 07:00:00	QQQ	ETF	94.09	94.19	94.0	94.09	102414.0
2014-07-10 08:00:00	QQQ	ETF	94.12	94.15	93.79	93.81	378329.0
2014-07-10 09:00:00	QQQ	ETF	93.81	94.03	93.63	93.83	6997811.0
2014-07-10 10:00:00	QQQ	ETF	93.83	94.51	93.83	94.495	6111579.0
2014-07-10 11:00:00	QQQ	ETF	94.5	94.63	94.44	94.56	4286154.0
2014-07-10 12:00:00	QQQ	ETF	94.56	94.87	94.5	94.76	4019734.0
2014-07-10 13:00:00	QQQ	ETF	94.75	95.05	94.73	94.87	4354037.0
2014-07-10 14:00:00	QQQ	ETF	94.86	94.93	94.605	94.605	4851921.0
2014-07-10 15:00:00	QQQ	ETF	94.61	94.7881	94.49	94.66	5551986.0
2014-07-10 16:00:00	QQQ	ETF	94.67	94.69	94.3374	94.64	6884336.0
2014-07-10 17:00:00	QQQ	ETF	94.64	94.68	94.64	94.64	8871.0
2014-07-10 18:00:00	QQQ	ETF	94.65	94.66	94.6	94.6	4170.0
2014-07-10 19:00:00	QQQ	ETF	94.65	94.66	94.62	94.65	4550.0
2014-07-10 04:00:00	IWM	ETF	116.31	116.31	115.5	115.5	1200.0
2014-07-10 05:00:00	IWM	ETF	115.51	115.51	115.01	115.01	21300.0
2014-07-10 06:00:00	IWM	ETF	114.83	114.83	114.05	114.15	62855.0
2014-07-10 07:00:00	IWM	ETF	114.15	114.27	113.7	113.99	429363.0
2014-07-10 08:00:00	IWM	ETF	114.0	114.32	113.98	114.11	655575.0
2014-07-10 09:00:00	IWM	ETF	114.08	114.8	113.85	114.28	9534861.0
2014-07-10 10:00:00	IWM	ETF	114.27	115.02	114.25	114.99	10626153.0
2014-07-10 11:00:00	IWM	ETF	114.995	115.34	114.75	114.99	6385929.0
2014-07-10 12:00:00	IWM	ETF	114.985	115.49	114.85	115.43	2892237.0
2014-07-10 13:00:00	IWM	ETF	115.43	116.05	115.415	115.75	3617902.0
2014-07-10 14:00:00	IWM	ETF	115.76	115.88	115.26	115.26	3211243.0
2014-07-10 15:00:00	IWM	ETF	115.25	115.61	115.09	115.27	6494918.0
2014-07-10 16:00:00	IWM	ETF	115.27	115.2856	115.09	115.11	1313002.0
2014-07-10 17:00:00	IWM	ETF	115.1	115.25	115.08	115.14	12170.0
2014-07-10 18:00:00	IWM	ETF	115.14	115.15	115.14	115.15	395.0
2014-07-10 04:00:00	DIA	ETF	169.02	169.02	168.65	168.67	11300.0
2014-07-10 05:00:00	DIA	ETF	168.63	168.65	168.4	168.4	27800.0
2014-07-10 06:00:00	DIA	ETF	168.2	168.2	168.04	168.04	1400.0

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

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