PREVIEW / etf_1hour / 2014-04-03

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-04-03.parquet
  size:    213 KB
  rows:    6,746

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-04-03 04:00:00	SPY	ETF	188.76	188.97	188.76	188.93	5948.0
2014-04-03 05:00:00	SPY	ETF	188.89	188.99	188.87	188.99	14056.0
2014-04-03 06:00:00	SPY	ETF	189.01	189.12	188.98	189.07	12991.0
2014-04-03 07:00:00	SPY	ETF	189.04	189.04	188.87	188.92	116758.0
2014-04-03 08:00:00	SPY	ETF	188.96	189.05	188.68	188.78	1070186.0
2014-04-03 09:00:00	SPY	ETF	188.79	189.24	188.78	189.12	8951724.0
2014-04-03 10:00:00	SPY	ETF	189.12	189.19	188.51	188.789	12439833.0
2014-04-03 11:00:00	SPY	ETF	188.78	188.81	188.44	188.51	8775299.0
2014-04-03 12:00:00	SPY	ETF	188.51	188.66	188.26	188.35	7483687.0
2014-04-03 13:00:00	SPY	ETF	188.35	188.76	188.32	188.54	8268594.0
2014-04-03 14:00:00	SPY	ETF	188.54	188.6224	188.05	188.39	9625936.0
2014-04-03 15:00:00	SPY	ETF	188.39	188.86	188.35	188.63	15448373.0
2014-04-03 16:00:00	SPY	ETF	188.63	188.94	188.5207	188.92	4191666.0
2014-04-03 17:00:00	SPY	ETF	188.93	189.0	188.63	188.91	99735.0
2014-04-03 18:00:00	SPY	ETF	188.92	188.94	188.87	188.94	115671.0
2014-04-03 19:00:00	SPY	ETF	188.94	188.99	188.89	188.96	70624.0
2014-04-03 04:00:00	QQQ	ETF	89.39	89.39	89.39	89.39	2500.0
2014-04-03 06:00:00	QQQ	ETF	89.52	89.58	89.52	89.58	4269.0
2014-04-03 07:00:00	QQQ	ETF	89.51	89.51	89.43	89.43	33400.0
2014-04-03 08:00:00	QQQ	ETF	89.42	89.48	89.33	89.35	221383.0
2014-04-03 09:00:00	QQQ	ETF	89.33	89.655	89.29	89.63	3063226.0
2014-04-03 10:00:00	QQQ	ETF	89.64	89.679	89.091	89.32	5141372.0
2014-04-03 11:00:00	QQQ	ETF	89.3274	89.34	88.95	88.9901	4794722.0
2014-04-03 12:00:00	QQQ	ETF	88.99	89.03	88.521	88.62	3578040.0
2014-04-03 13:00:00	QQQ	ETF	88.61	88.84	88.59	88.71	2606603.0
2014-04-03 14:00:00	QQQ	ETF	88.7	88.72	88.22	88.48	3744656.0
2014-04-03 15:00:00	QQQ	ETF	88.48	88.81	88.4499	88.72	4709257.0
2014-04-03 16:00:00	QQQ	ETF	88.72	89.4226	88.72	88.85	1452208.0
2014-04-03 17:00:00	QQQ	ETF	88.85	88.91	88.83	88.85	164860.0
2014-04-03 18:00:00	QQQ	ETF	88.87	88.87	88.85	88.87	12085.0
2014-04-03 19:00:00	QQQ	ETF	88.83	88.9	88.82	88.87	15744.0
2014-04-03 07:00:00	IWM	ETF	118.51	118.52	118.28	118.3	136400.0
2014-04-03 08:00:00	IWM	ETF	118.28	118.28	118.06	118.12	155277.0
2014-04-03 09:00:00	IWM	ETF	118.11	118.46	118.11	118.36	3071106.0
2014-04-03 10:00:00	IWM	ETF	118.35	118.42	117.365	117.66	7619751.0
2014-04-03 11:00:00	IWM	ETF	117.67	117.67	117.19	117.43	3358442.0
2014-04-03 12:00:00	IWM	ETF	117.43	117.66	116.96	117.14	3722741.0
2014-04-03 13:00:00	IWM	ETF	117.14	117.47	117.07	117.18	2712354.0
2014-04-03 14:00:00	IWM	ETF	117.19	117.25	116.68	117.05	4201102.0
2014-04-03 15:00:00	IWM	ETF	117.04	117.48	116.87	117.17	7174285.0
2014-04-03 16:00:00	IWM	ETF	117.17	117.504	117.15	117.41	1885559.0
2014-04-03 17:00:00	IWM	ETF	117.4	117.41	117.15	117.41	9800.0
2014-04-03 18:00:00	IWM	ETF	117.36	117.36	117.36	117.36	275.0
2014-04-03 19:00:00	IWM	ETF	117.42	117.42	117.42	117.42	200.0
2014-04-03 08:00:00	DIA	ETF	165.4	165.52	165.39	165.46	2860.0
2014-04-03 09:00:00	DIA	ETF	165.83	165.83	165.41	165.62	946826.0
2014-04-03 10:00:00	DIA	ETF	165.64	165.7	165.1515	165.32	602891.0
2014-04-03 11:00:00	DIA	ETF	165.33	165.35	165.17	165.24	362720.0
2014-04-03 12:00:00	DIA	ETF	165.23	165.36	165.11	165.21	314901.0
2014-04-03 13:00:00	DIA	ETF	165.2	165.41	165.17	165.26	244253.0

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

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