PREVIEW / etf_1hour / 2014-11-28

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-11-28.parquet
  size:    149 KB
  rows:    4,576

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-28 04:00:00	SPY	ETF	207.49	207.49	207.3	207.35	5505.0
2014-11-28 05:00:00	SPY	ETF	207.34	207.34	207.14	207.2	24506.0
2014-11-28 06:00:00	SPY	ETF	207.23	207.38	207.18	207.36	59141.0
2014-11-28 07:00:00	SPY	ETF	207.37	207.61	207.34	207.57	105609.0
2014-11-28 08:00:00	SPY	ETF	207.93	207.93	207.37	207.61	514055.0
2014-11-28 09:00:00	SPY	ETF	207.61	207.64	207.22	207.64	9792584.0
2014-11-28 10:00:00	SPY	ETF	207.64	207.81	207.51	207.65	7064351.0
2014-11-28 11:00:00	SPY	ETF	207.647	207.87	207.55	207.5701	8292838.0
2014-11-28 12:00:00	SPY	ETF	207.57	207.57	206.91	207.21	20230838.0
2014-11-28 13:00:00	SPY	ETF	207.21	207.4341	206.91	207.02	6990165.0
2014-11-28 14:00:00	SPY	ETF	207.01	207.02	206.93	207.01	253323.0
2014-11-28 15:00:00	SPY	ETF	206.98	206.98	206.87	206.89	94443.0
2014-11-28 16:00:00	SPY	ETF	206.91	206.95	206.9	206.95	11676.0
2014-11-28 04:00:00	QQQ	ETF	106.3	106.3	105.47	105.6	600.0
2014-11-28 05:00:00	QQQ	ETF	105.66	105.66	105.63	105.64	800.0
2014-11-28 06:00:00	QQQ	ETF	105.66	105.72	105.64	105.7	15600.0
2014-11-28 07:00:00	QQQ	ETF	105.68	105.79	105.68	105.79	27429.0
2014-11-28 08:00:00	QQQ	ETF	105.79	105.83	105.69	105.78	114717.0
2014-11-28 09:00:00	QQQ	ETF	105.769	105.969	105.73	105.96	3551861.0
2014-11-28 10:00:00	QQQ	ETF	105.9666	106.245	105.88	106.18	2942591.0
2014-11-28 11:00:00	QQQ	ETF	106.18	106.2299	106.07	106.1	1860157.0
2014-11-28 12:00:00	QQQ	ETF	106.1	106.179	105.8201	106.03	4609764.0
2014-11-28 13:00:00	QQQ	ETF	106.0	106.04	105.93	105.99	754983.0
2014-11-28 14:00:00	QQQ	ETF	105.97	105.97	105.9	105.9	13550.0
2014-11-28 15:00:00	QQQ	ETF	106.01	106.01	105.86	105.93	204973.0
2014-11-28 16:00:00	QQQ	ETF	105.93	105.93	105.86	105.86	1111.0
2014-11-28 04:00:00	IWM	ETF	118.03	118.03	118.03	118.03	100.0
2014-11-28 05:00:00	IWM	ETF	118.4	118.4	118.4	118.4	100.0
2014-11-28 06:00:00	IWM	ETF	118.45	118.45	118.45	118.45	100.0
2014-11-28 07:00:00	IWM	ETF	118.5	118.69	118.5	118.69	600.0
2014-11-28 08:00:00	IWM	ETF	118.68	118.71	118.54	118.6	41640.0
2014-11-28 09:00:00	IWM	ETF	118.58	118.64	117.9	118.23	4445447.0
2014-11-28 10:00:00	IWM	ETF	118.23	118.39	118.02	118.215	1645487.0
2014-11-28 11:00:00	IWM	ETF	118.21	118.3	117.86	117.9	2118214.0
2014-11-28 12:00:00	IWM	ETF	117.9	117.905	116.57	116.75	7624730.0
2014-11-28 13:00:00	IWM	ETF	116.75	117.55	116.16	116.71	2206595.0
2014-11-28 14:00:00	IWM	ETF	116.71	116.75	116.65	116.71	30470.0
2014-11-28 15:00:00	IWM	ETF	116.69	116.72	116.67	116.72	1750465.0
2014-11-28 16:00:00	IWM	ETF	116.69	116.69	116.69	116.69	1000.0
2014-11-28 06:00:00	DIA	ETF	177.7	177.7	177.7	177.7	100.0
2014-11-28 07:00:00	DIA	ETF	177.8	177.95	177.8	177.95	600.0
2014-11-28 08:00:00	DIA	ETF	177.95	178.18	177.95	178.18	14150.0
2014-11-28 09:00:00	DIA	ETF	178.2	178.55	178.1	178.55	1071787.0
2014-11-28 10:00:00	DIA	ETF	178.5431	178.64	178.41	178.485	817232.0
2014-11-28 11:00:00	DIA	ETF	178.48	178.69	178.46	178.6	593081.0
2014-11-28 12:00:00	DIA	ETF	178.59	178.59	177.86	178.12	1151928.0
2014-11-28 13:00:00	DIA	ETF	178.12	178.15	177.9	178.0	49368.0
2014-11-28 14:00:00	DIA	ETF	177.9	178.0	177.9	178.0	700.0
2014-11-28 16:00:00	DIA	ETF	178.1	178.1	178.1	178.1	100.0
2014-11-28 05:00:00	GLD	ETF	113.81	113.81	113.77	113.77	740.0

> showing 50 of 4,576 rows — these rows as CSV

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