PREVIEW / etf_1hour / 2014-06-18

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-06-18.parquet
  size:    216 KB
  rows:    6,850

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-18 04:00:00	SPY	ETF	194.83	194.83	194.83	194.83	500.0
2014-06-18 05:00:00	SPY	ETF	194.74	194.74	194.74	194.74	850.0
2014-06-18 06:00:00	SPY	ETF	194.78	194.83	194.76	194.83	30135.0
2014-06-18 07:00:00	SPY	ETF	194.79	194.85	194.72	194.74	478619.0
2014-06-18 08:00:00	SPY	ETF	194.75	194.84	194.72	194.82	222599.0
2014-06-18 09:00:00	SPY	ETF	194.82	195.08	194.68	195.02	8134340.0
2014-06-18 10:00:00	SPY	ETF	195.02	195.07	194.5	194.51	10487211.0
2014-06-18 11:00:00	SPY	ETF	194.5	194.76	194.45	194.675	5858365.0
2014-06-18 12:00:00	SPY	ETF	194.67	194.9	194.6	194.86	7841267.0
2014-06-18 13:00:00	SPY	ETF	194.865	194.9	194.53	194.71	9477544.0
2014-06-18 14:00:00	SPY	ETF	194.7	195.69	194.4	195.6	25729725.0
2014-06-18 15:00:00	SPY	ETF	195.61	196.37	195.59	196.25	26343714.0
2014-06-18 16:00:00	SPY	ETF	196.24	196.35	194.8456	196.24	8577557.0
2014-06-18 17:00:00	SPY	ETF	196.25	196.26	196.18	196.21	129197.0
2014-06-18 18:00:00	SPY	ETF	196.21	196.28	196.18	196.28	41518.0
2014-06-18 19:00:00	SPY	ETF	196.27	196.28	196.21	196.24	77055.0
2014-06-18 04:00:00	QQQ	ETF	92.64	92.64	92.64	92.64	1500.0
2014-06-18 07:00:00	QQQ	ETF	92.57	92.57	92.57	92.57	100.0
2014-06-18 08:00:00	QQQ	ETF	92.61	92.61	92.51	92.53	6968.0
2014-06-18 09:00:00	QQQ	ETF	92.56	92.6	92.39	92.43	3183459.0
2014-06-18 10:00:00	QQQ	ETF	92.4397	92.5	92.24	92.27	2674228.0
2014-06-18 11:00:00	QQQ	ETF	92.27	92.385	92.24	92.34	1254426.0
2014-06-18 12:00:00	QQQ	ETF	92.35	92.4	92.28	92.37	1128566.0
2014-06-18 13:00:00	QQQ	ETF	92.37	92.38	92.07	92.158	1839230.0
2014-06-18 14:00:00	QQQ	ETF	92.14	92.73	91.98	92.6999	8727153.0
2014-06-18 15:00:00	QQQ	ETF	92.7	93.1	92.69	92.99	8481408.0
2014-06-18 16:00:00	QQQ	ETF	92.99	93.06	92.4169	92.98	1342917.0
2014-06-18 17:00:00	QQQ	ETF	92.99	93.0	92.98	92.98	3448.0
2014-06-18 18:00:00	QQQ	ETF	92.98	93.0	92.97	93.0	9733.0
2014-06-18 19:00:00	QQQ	ETF	92.98	93.0	92.97	93.0	13130.0
2014-06-18 07:00:00	IWM	ETF	116.96	116.96	116.96	116.96	100.0
2014-06-18 08:00:00	IWM	ETF	116.76	116.98	116.76	116.97	7449.0
2014-06-18 09:00:00	IWM	ETF	116.94	116.99	116.65	116.89	4043284.0
2014-06-18 10:00:00	IWM	ETF	116.91	116.99	116.55	116.56	3365380.0
2014-06-18 11:00:00	IWM	ETF	116.56	116.8	116.5	116.72	2492897.0
2014-06-18 12:00:00	IWM	ETF	116.72	116.93	116.63	116.92	1290721.0
2014-06-18 13:00:00	IWM	ETF	116.92	116.94	116.56	116.73	1330811.0
2014-06-18 14:00:00	IWM	ETF	116.64	117.55	116.57	117.35	9776094.0
2014-06-18 15:00:00	IWM	ETF	117.34	117.81	117.32	117.74	7616715.0
2014-06-18 16:00:00	IWM	ETF	117.74	117.94	117.7279	117.92	2113707.0
2014-06-18 17:00:00	IWM	ETF	117.92	118.0	117.92	117.95	33331.0
2014-06-18 18:00:00	IWM	ETF	117.95	117.96	117.95	117.96	11887.0
2014-06-18 19:00:00	IWM	ETF	117.96	117.98	117.91	117.98	11828.0
2014-06-18 08:00:00	DIA	ETF	168.0	168.02	167.95	168.02	1735.0
2014-06-18 09:00:00	DIA	ETF	167.96	168.11	167.73	168.05	424638.0
2014-06-18 10:00:00	DIA	ETF	168.06	168.09	167.52	167.52	686133.0
2014-06-18 11:00:00	DIA	ETF	167.52	167.7	167.48	167.64	411680.0
2014-06-18 12:00:00	DIA	ETF	167.6446	167.93	167.62	167.9115	172893.0
2014-06-18 13:00:00	DIA	ETF	167.92	167.97	167.69	167.77	269725.0
2014-06-18 14:00:00	DIA	ETF	167.75	168.51	167.35	168.45	1250879.0

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

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