PREVIEW / etf_1hour / 2012-04-10

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-04-10.parquet
  size:    194 KB
  rows:    5,978

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
2012-04-10 04:00:00	SPY	ETF	138.24	138.5	138.24	138.42	3600.0
2012-04-10 05:00:00	SPY	ETF	138.37	138.42	138.29	138.42	4904.0
2012-04-10 06:00:00	SPY	ETF	138.37	138.4	138.19	138.26	29500.0
2012-04-10 07:00:00	SPY	ETF	138.16	138.23	137.94	138.2	258059.0
2012-04-10 08:00:00	SPY	ETF	138.23	138.26	138.01	138.06	1067521.0
2012-04-10 09:00:00	SPY	ETF	138.06	138.34	137.83	138.15	14774630.0
2012-04-10 10:00:00	SPY	ETF	138.15	138.23	137.45	137.53	28411523.0
2012-04-10 11:00:00	SPY	ETF	137.53	137.66	136.58	136.81	37315460.0
2012-04-10 12:00:00	SPY	ETF	136.81	136.82	136.2	136.409	36280118.0
2012-04-10 13:00:00	SPY	ETF	136.409	136.48	135.95	136.26	26403388.0
2012-04-10 14:00:00	SPY	ETF	136.27	136.36	135.76	136.08	26136443.0
2012-04-10 15:00:00	SPY	ETF	136.08	136.3	135.81	135.86	50530143.0
2012-04-10 16:00:00	SPY	ETF	135.86	138.1112	135.84	136.43	11345645.0
2012-04-10 17:00:00	SPY	ETF	136.4	136.54	136.38	136.48	744969.0
2012-04-10 18:00:00	SPY	ETF	136.48	136.49	136.35	136.37	59923.0
2012-04-10 19:00:00	SPY	ETF	136.41	136.56	136.39	136.5	175053.0
2012-04-10 04:00:00	QQQ	ETF	67.26	67.26	67.26	67.26	200.0
2012-04-10 06:00:00	QQQ	ETF	67.19	67.19	67.19	67.19	200.0
2012-04-10 07:00:00	QQQ	ETF	67.2	67.22	67.13	67.22	56800.0
2012-04-10 08:00:00	QQQ	ETF	67.23	67.26	67.17	67.19	495248.0
2012-04-10 09:00:00	QQQ	ETF	67.19	67.43	67.1	67.37	4971833.0
2012-04-10 10:00:00	QQQ	ETF	67.361	67.44	67.0	67.1	6976644.0
2012-04-10 11:00:00	QQQ	ETF	67.1	67.17	66.47	66.6027	11241152.0
2012-04-10 12:00:00	QQQ	ETF	66.61	66.62	66.14	66.36	10693448.0
2012-04-10 13:00:00	QQQ	ETF	66.36	66.39	66.09	66.27	6945118.0
2012-04-10 14:00:00	QQQ	ETF	66.25	66.345	65.92	66.18	7782293.0
2012-04-10 15:00:00	QQQ	ETF	66.18	66.26	65.95	66.12	13514134.0
2012-04-10 16:00:00	QQQ	ETF	66.13	66.34	66.12	66.34	1159428.0
2012-04-10 17:00:00	QQQ	ETF	66.34	66.38	66.31	66.36	45215.0
2012-04-10 18:00:00	QQQ	ETF	66.35	66.36	66.3	66.3	13510.0
2012-04-10 19:00:00	QQQ	ETF	66.32	66.4	66.32	66.36	29400.0
2012-04-10 06:00:00	IWM	ETF	80.2	80.22	80.15	80.15	30500.0
2012-04-10 07:00:00	IWM	ETF	80.1	80.11	79.8	80.02	102700.0
2012-04-10 08:00:00	IWM	ETF	80.04	80.11	79.94	80.05	159957.0
2012-04-10 09:00:00	IWM	ETF	80.03	80.16	79.8	79.87	7623809.0
2012-04-10 10:00:00	IWM	ETF	79.87	79.91	79.16	79.23	14108204.0
2012-04-10 11:00:00	IWM	ETF	79.23	79.32	78.48	78.67	12927045.0
2012-04-10 12:00:00	IWM	ETF	78.67	78.75	78.355	78.62	9454540.0
2012-04-10 13:00:00	IWM	ETF	78.615	78.7	78.29	78.48	8103205.0
2012-04-10 14:00:00	IWM	ETF	78.47	78.6	78.28	78.42	7389111.0
2012-04-10 15:00:00	IWM	ETF	78.42	78.42	78.14	78.34	14681739.0
2012-04-10 16:00:00	IWM	ETF	78.35	80.1904	78.2611	78.65	5732397.0
2012-04-10 17:00:00	IWM	ETF	78.65	78.7	78.65	78.68	43000.0
2012-04-10 18:00:00	IWM	ETF	78.69	78.69	78.62	78.64	808.0
2012-04-10 19:00:00	IWM	ETF	78.69	78.79	78.64	78.72	2000.0
2012-04-10 07:00:00	DIA	ETF	129.16	129.16	128.99	128.99	300.0
2012-04-10 08:00:00	DIA	ETF	129.16	129.16	129.01	129.02	8505.0
2012-04-10 09:00:00	DIA	ETF	129.04	129.07	128.74	128.9	574616.0
2012-04-10 10:00:00	DIA	ETF	128.91	128.98	128.32	128.38	1205065.0
2012-04-10 11:00:00	DIA	ETF	128.38	128.51	127.78	127.94	1841352.0

> showing 50 of 5,978 rows — these rows as CSV

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