PREVIEW / etf_1hour / 2014-12-10

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-12-10.parquet
  size:    237 KB
  rows:    7,484

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-12-10 04:00:00	SPY	ETF	206.24	206.28	206.2	206.21	1100.0
2014-12-10 05:00:00	SPY	ETF	206.2	206.3	206.14	206.23	10420.0
2014-12-10 06:00:00	SPY	ETF	206.25	206.25	206.12	206.15	116910.0
2014-12-10 07:00:00	SPY	ETF	206.15	206.32	205.7	205.88	328565.0
2014-12-10 08:00:00	SPY	ETF	205.89	206.47	205.76	205.89	725953.0
2014-12-10 09:00:00	SPY	ETF	205.88	205.98	205.14	205.37	13844290.0
2014-12-10 10:00:00	SPY	ETF	205.37	205.5	204.69	205.45	18044562.0
2014-12-10 11:00:00	SPY	ETF	205.45	205.465	204.76	205.2799	12706455.0
2014-12-10 12:00:00	SPY	ETF	205.29	205.295	204.62	204.9768	9017156.0
2014-12-10 13:00:00	SPY	ETF	204.96	205.23	203.99	204.01	15018246.0
2014-12-10 14:00:00	SPY	ETF	204.0	204.27	203.06	203.065	26262046.0
2014-12-10 15:00:00	SPY	ETF	203.06	204.11	202.93	203.17	49674462.0
2014-12-10 16:00:00	SPY	ETF	203.18	205.35	203.05	203.2	10329624.0
2014-12-10 17:00:00	SPY	ETF	203.21	204.2748	203.0	203.13	758013.0
2014-12-10 18:00:00	SPY	ETF	203.13	203.34	203.0	203.15	331266.0
2014-12-10 19:00:00	SPY	ETF	203.16	203.36	202.97	203.29	144821.0
2014-12-10 05:00:00	QQQ	ETF	104.79	104.79	104.79	104.79	2500.0
2014-12-10 06:00:00	QQQ	ETF	104.81	104.81	104.77	104.8	2300.0
2014-12-10 07:00:00	QQQ	ETF	104.84	104.9	104.65	104.7	52121.0
2014-12-10 08:00:00	QQQ	ETF	104.88	104.88	104.66	104.73	77723.0
2014-12-10 09:00:00	QQQ	ETF	104.72	105.03	104.4743	104.65	5696319.0
2014-12-10 10:00:00	QQQ	ETF	104.65	104.71	104.16	104.68	5885440.0
2014-12-10 11:00:00	QQQ	ETF	104.675	104.69	104.315	104.66	3188711.0
2014-12-10 12:00:00	QQQ	ETF	104.66	104.66	104.19	104.325	1887819.0
2014-12-10 13:00:00	QQQ	ETF	104.33	104.52	103.78	103.8	2884142.0
2014-12-10 14:00:00	QQQ	ETF	103.81	103.9	103.23	103.23	6874446.0
2014-12-10 15:00:00	QQQ	ETF	103.23	103.74	103.12	103.31	9464433.0
2014-12-10 16:00:00	QQQ	ETF	103.31	104.2349	103.22	103.3	1470984.0
2014-12-10 17:00:00	QQQ	ETF	103.3	103.35	103.23	103.31	76406.0
2014-12-10 18:00:00	QQQ	ETF	103.31	103.41	103.25	103.33	96619.0
2014-12-10 19:00:00	QQQ	ETF	103.32	103.41	103.21	103.38	44022.0
2014-12-10 07:00:00	IWM	ETF	117.9	117.98	117.47	117.47	3000.0
2014-12-10 08:00:00	IWM	ETF	117.57	117.77	117.48	117.67	105701.0
2014-12-10 09:00:00	IWM	ETF	117.65	118.16	117.31	117.53	5792247.0
2014-12-10 10:00:00	IWM	ETF	117.53	117.659	116.97	117.6	7520461.0
2014-12-10 11:00:00	IWM	ETF	117.6	117.76	117.13	117.41	4098393.0
2014-12-10 12:00:00	IWM	ETF	117.4	117.43	116.9	117.16	3454018.0
2014-12-10 13:00:00	IWM	ETF	117.15	117.32	116.42	116.44	3291678.0
2014-12-10 14:00:00	IWM	ETF	116.45	116.55	115.66	115.66	6483795.0
2014-12-10 15:00:00	IWM	ETF	115.66	116.27	115.56	115.71	8686880.0
2014-12-10 16:00:00	IWM	ETF	115.71	118.2205	115.59	115.61	2403021.0
2014-12-10 17:00:00	IWM	ETF	115.62	115.64	115.51	115.56	30570.0
2014-12-10 18:00:00	IWM	ETF	115.63	115.76	115.63	115.76	18310.0
2014-12-10 19:00:00	IWM	ETF	115.67	115.84	115.66	115.81	12229.0
2014-12-10 04:00:00	DIA	ETF	177.75	177.75	177.75	177.75	134.0
2014-12-10 08:00:00	DIA	ETF	177.5	177.5	177.4	177.5	37100.0
2014-12-10 09:00:00	DIA	ETF	177.42	177.5	176.6299	176.78	1035082.0
2014-12-10 10:00:00	DIA	ETF	176.8	176.88	176.35	176.8	969004.0
2014-12-10 11:00:00	DIA	ETF	176.82	176.82	176.27	176.66	586178.0
2014-12-10 12:00:00	DIA	ETF	176.64	176.695	176.2	176.44	366147.0

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

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