PREVIEW / etf_1hour / 2012-07-05

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-07-05.parquet
  size:    185 KB
  rows:    5,743

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-07-05 04:00:00	SPY	ETF	137.37	137.42	137.25	137.35	2800.0
2012-07-05 05:00:00	SPY	ETF	137.36	137.46	137.33	137.36	7700.0
2012-07-05 06:00:00	SPY	ETF	137.4	137.85	137.28	137.85	76800.0
2012-07-05 07:00:00	SPY	ETF	137.76	138.06	137.12	137.22	2638675.0
2012-07-05 08:00:00	SPY	ETF	137.25	138.25	136.76	137.02	5792271.0
2012-07-05 09:00:00	SPY	ETF	137.03	137.23	136.55	136.62	21504706.0
2012-07-05 10:00:00	SPY	ETF	136.61	137.8	136.29	136.89	20209903.0
2012-07-05 11:00:00	SPY	ETF	136.89	137.16	136.88	136.97	15772595.0
2012-07-05 12:00:00	SPY	ETF	136.9701	137.13	136.81	136.99	8218997.0
2012-07-05 13:00:00	SPY	ETF	136.99	137.35	136.97	137.32	9129874.0
2012-07-05 14:00:00	SPY	ETF	137.33	137.4	137.07	137.08	9345370.0
2012-07-05 15:00:00	SPY	ETF	137.08	137.17	136.73	136.805	24692604.0
2012-07-05 16:00:00	SPY	ETF	136.81	137.4144	136.58	136.85	7700769.0
2012-07-05 17:00:00	SPY	ETF	136.83	136.85	136.81	136.81	11798.0
2012-07-05 18:00:00	SPY	ETF	136.8	136.82	136.71	136.81	62710.0
2012-07-05 19:00:00	SPY	ETF	136.82	136.87	136.76	136.87	90505.0
2012-07-05 05:00:00	QQQ	ETF	64.9	64.9	64.9	64.9	500.0
2012-07-05 06:00:00	QQQ	ETF	65.0	65.03	65.0	65.03	3200.0
2012-07-05 07:00:00	QQQ	ETF	65.16	65.21	64.73	64.77	1356273.0
2012-07-05 08:00:00	QQQ	ETF	64.78	65.44	64.6	64.77	2942673.0
2012-07-05 09:00:00	QQQ	ETF	64.77	64.92	64.62	64.66	5582137.0
2012-07-05 10:00:00	QQQ	ETF	64.66	65.0	64.48	64.97	6147269.0
2012-07-05 11:00:00	QQQ	ETF	64.97	65.13	64.94	65.0	5896704.0
2012-07-05 12:00:00	QQQ	ETF	65.01	65.09	64.96	65.039	2964468.0
2012-07-05 13:00:00	QQQ	ETF	65.04	65.22	65.0101	65.21	2235637.0
2012-07-05 14:00:00	QQQ	ETF	65.2018	65.25	65.04	65.05	2684258.0
2012-07-05 15:00:00	QQQ	ETF	65.0499	65.13	64.92	64.93	3926297.0
2012-07-05 16:00:00	QQQ	ETF	64.93	65.0378	64.85	64.93	797964.0
2012-07-05 17:00:00	QQQ	ETF	64.95	64.95	64.87	64.87	22960.0
2012-07-05 18:00:00	QQQ	ETF	64.88	64.9	64.85	64.89	10884.0
2012-07-05 19:00:00	QQQ	ETF	64.9	64.92	64.89	64.91	8392.0
2012-07-05 04:00:00	IWM	ETF	81.43	81.64	81.43	81.64	3400.0
2012-07-05 05:00:00	IWM	ETF	81.64	81.64	81.64	81.64	500.0
2012-07-05 06:00:00	IWM	ETF	81.78	81.8	81.78	81.8	300.0
2012-07-05 07:00:00	IWM	ETF	81.77	81.95	81.45	81.45	74906.0
2012-07-05 08:00:00	IWM	ETF	81.46	81.98	81.26	81.49	490568.0
2012-07-05 09:00:00	IWM	ETF	81.49	81.76	81.14	81.1701	6882421.0
2012-07-05 10:00:00	IWM	ETF	81.17	81.66	81.03	81.6	7205030.0
2012-07-05 11:00:00	IWM	ETF	81.6	81.84	81.485	81.65	4739426.0
2012-07-05 12:00:00	IWM	ETF	81.64	81.73	81.49	81.65	2420484.0
2012-07-05 13:00:00	IWM	ETF	81.64	81.72	81.44	81.6901	4223291.0
2012-07-05 14:00:00	IWM	ETF	81.695	81.72	81.53	81.57	2149190.0
2012-07-05 15:00:00	IWM	ETF	81.57	81.64	81.4	81.47	5005973.0
2012-07-05 16:00:00	IWM	ETF	81.46	81.59	81.37	81.5	568401.0
2012-07-05 17:00:00	IWM	ETF	81.52	81.52	81.51	81.51	1800.0
2012-07-05 18:00:00	IWM	ETF	81.5	81.51	81.44	81.51	2146.0
2012-07-05 19:00:00	IWM	ETF	81.44	81.47	81.44	81.47	10850.0
2012-07-05 08:00:00	DIA	ETF	129.15	129.53	128.53	128.62	24075.0
2012-07-05 09:00:00	DIA	ETF	128.79	128.79	128.44	128.59	642294.0
2012-07-05 10:00:00	DIA	ETF	128.54	128.86	128.3	128.8	1232330.0

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

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