PREVIEW / etf_1hour / 2012-04-05

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-04-05.parquet
  size:    181 KB
  rows:    5,644

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-05 04:00:00	SPY	ETF	140.14	140.15	139.5	139.56	21500.0
2012-04-05 05:00:00	SPY	ETF	139.68	139.7	139.03	139.08	70690.0
2012-04-05 06:00:00	SPY	ETF	139.02	139.35	138.92	139.35	167995.0
2012-04-05 07:00:00	SPY	ETF	139.32	139.38	139.16	139.38	363825.0
2012-04-05 08:00:00	SPY	ETF	139.36	139.95	138.95	139.31	3044958.0
2012-04-05 09:00:00	SPY	ETF	139.32	139.82	139.2417	139.665	15532791.0
2012-04-05 10:00:00	SPY	ETF	139.67	140.13	139.65	140.13	17656266.0
2012-04-05 11:00:00	SPY	ETF	140.125	140.2	139.83	140.0	15636766.0
2012-04-05 12:00:00	SPY	ETF	139.9993	140.04	139.76	139.81	9448318.0
2012-04-05 13:00:00	SPY	ETF	139.81	139.91	139.47	139.5887	11990751.0
2012-04-05 14:00:00	SPY	ETF	139.59	139.83	139.55	139.78	10833101.0
2012-04-05 15:00:00	SPY	ETF	139.79	139.93	139.66	139.796	24966630.0
2012-04-05 16:00:00	SPY	ETF	139.79	140.0525	138.87	139.66	17731408.0
2012-04-05 17:00:00	SPY	ETF	139.62	139.8406	139.56	139.61	158831.0
2012-04-05 18:00:00	SPY	ETF	139.62	139.69	139.57	139.65	249727.0
2012-04-05 19:00:00	SPY	ETF	139.65	139.68	139.55	139.6	31707.0
2012-04-05 05:00:00	QQQ	ETF	66.98	66.98	66.98	66.98	4000.0
2012-04-05 06:00:00	QQQ	ETF	66.93	67.02	66.88	67.01	85800.0
2012-04-05 07:00:00	QQQ	ETF	67.09	67.14	67.02	67.14	54730.0
2012-04-05 08:00:00	QQQ	ETF	67.14	67.3	66.99	67.16	1148644.0
2012-04-05 09:00:00	QQQ	ETF	67.16	67.38	67.13	67.28	2420153.0
2012-04-05 10:00:00	QQQ	ETF	67.28	67.57	67.26	67.57	5596600.0
2012-04-05 11:00:00	QQQ	ETF	67.57	67.7	67.53	67.7	4162306.0
2012-04-05 12:00:00	QQQ	ETF	67.7	67.78	67.64	67.66	3687178.0
2012-04-05 13:00:00	QQQ	ETF	67.665	67.74	67.56	67.62	3055542.0
2012-04-05 14:00:00	QQQ	ETF	67.6299	67.725	67.58	67.69	2673760.0
2012-04-05 15:00:00	QQQ	ETF	67.6972	67.78	67.61	67.72	5779689.0
2012-04-05 16:00:00	QQQ	ETF	67.72	67.7913	67.62	67.67	1031865.0
2012-04-05 17:00:00	QQQ	ETF	67.68	67.68	67.64	67.68	19795.0
2012-04-05 18:00:00	QQQ	ETF	67.68	67.7	67.66	67.69	16087.0
2012-04-05 19:00:00	QQQ	ETF	67.68	67.73	67.68	67.73	4055.0
2012-04-05 04:00:00	IWM	ETF	81.71	81.71	81.71	81.71	500.0
2012-04-05 05:00:00	IWM	ETF	81.45	81.45	81.24	81.24	2100.0
2012-04-05 06:00:00	IWM	ETF	81.15	81.49	81.05	81.3	69700.0
2012-04-05 07:00:00	IWM	ETF	81.34	81.46	81.28	81.46	119975.0
2012-04-05 08:00:00	IWM	ETF	81.07	81.58	81.07	81.5	431237.0
2012-04-05 09:00:00	IWM	ETF	81.53	81.82	81.42	81.59	3648409.0
2012-04-05 10:00:00	IWM	ETF	81.59	81.98	81.5	81.97	7522176.0
2012-04-05 11:00:00	IWM	ETF	81.97	82.0	81.68	81.85	3634197.0
2012-04-05 12:00:00	IWM	ETF	81.86	81.9	81.73	81.7546	1499449.0
2012-04-05 13:00:00	IWM	ETF	81.76	81.85	81.48	81.59	2991342.0
2012-04-05 14:00:00	IWM	ETF	81.59	81.68	81.5	81.58	2233174.0
2012-04-05 15:00:00	IWM	ETF	81.58	81.765	81.43	81.57	5468119.0
2012-04-05 16:00:00	IWM	ETF	81.56	81.6689	81.4	81.47	912268.0
2012-04-05 17:00:00	IWM	ETF	81.5	81.53	81.48	81.5	11800.0
2012-04-05 18:00:00	IWM	ETF	81.5	81.52	81.5	81.52	200.0
2012-04-05 07:00:00	DIA	ETF	130.01	130.06	129.99	129.99	1500.0
2012-04-05 08:00:00	DIA	ETF	130.01	130.14	129.95	130.02	13030.0
2012-04-05 09:00:00	DIA	ETF	130.06	130.35	129.93	130.26	368060.0
2012-04-05 10:00:00	DIA	ETF	130.26	130.62	130.25	130.62	711355.0

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

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