PREVIEW / etf_1hour / 2012-11-06

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-11-06.parquet
  size:    186 KB
  rows:    5,699

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-11-06 04:00:00	SPY	ETF	142.04	142.22	142.04	142.22	32401.0
2012-11-06 05:00:00	SPY	ETF	142.17	142.39	142.17	142.28	33849.0
2012-11-06 06:00:00	SPY	ETF	142.27	142.38	142.27	142.32	32848.0
2012-11-06 07:00:00	SPY	ETF	142.35	142.41	142.09	142.14	87676.0
2012-11-06 08:00:00	SPY	ETF	142.1	142.35	141.99	142.28	571513.0
2012-11-06 09:00:00	SPY	ETF	142.29	142.58	142.13	142.56	11603919.0
2012-11-06 10:00:00	SPY	ETF	142.56	142.62	142.16	142.42	11210844.0
2012-11-06 11:00:00	SPY	ETF	142.43	143.265	142.37	143.2	16232856.0
2012-11-06 12:00:00	SPY	ETF	143.2	143.52	143.06	143.18	12304876.0
2012-11-06 13:00:00	SPY	ETF	143.18	143.39	143.08	143.22	7268440.0
2012-11-06 14:00:00	SPY	ETF	143.21	143.35	142.98	143.08	7511917.0
2012-11-06 15:00:00	SPY	ETF	143.08	143.11	142.79	142.92	27967886.0
2012-11-06 16:00:00	SPY	ETF	142.92	143.3409	142.23	143.24	9400521.0
2012-11-06 17:00:00	SPY	ETF	143.2	143.23	143.07	143.11	73035.0
2012-11-06 18:00:00	SPY	ETF	143.11	143.18	142.89	142.98	124854.0
2012-11-06 19:00:00	SPY	ETF	142.97	142.97	142.57	142.67	380228.0
2012-11-06 04:00:00	QQQ	ETF	65.76	65.76	65.76	65.76	3918.0
2012-11-06 05:00:00	QQQ	ETF	65.77	65.77	65.76	65.77	1100.0
2012-11-06 06:00:00	QQQ	ETF	65.72	65.79	65.72	65.79	6800.0
2012-11-06 07:00:00	QQQ	ETF	65.79	65.79	65.67	65.69	18643.0
2012-11-06 08:00:00	QQQ	ETF	65.7	65.78	65.63	65.76	77109.0
2012-11-06 09:00:00	QQQ	ETF	65.75	65.75	65.51	65.65	3226948.0
2012-11-06 10:00:00	QQQ	ETF	65.65	65.7	65.46	65.63	4122273.0
2012-11-06 11:00:00	QQQ	ETF	65.63	66.0	65.59	65.98	5190695.0
2012-11-06 12:00:00	QQQ	ETF	65.97	66.17	65.89	65.96	5812144.0
2012-11-06 13:00:00	QQQ	ETF	65.96	66.02	65.87	65.9	2126719.0
2012-11-06 14:00:00	QQQ	ETF	65.89	65.96	65.7	65.79	2207350.0
2012-11-06 15:00:00	QQQ	ETF	65.79	65.82	65.6317	65.75	5198764.0
2012-11-06 16:00:00	QQQ	ETF	65.74	65.85	65.7	65.85	952997.0
2012-11-06 17:00:00	QQQ	ETF	65.83	65.84	65.77	65.84	11330.0
2012-11-06 18:00:00	QQQ	ETF	65.82	65.83	65.69	65.75	23505.0
2012-11-06 19:00:00	QQQ	ETF	65.71	65.73	65.62	65.66	32011.0
2012-11-06 05:00:00	IWM	ETF	81.95	81.95	81.95	81.95	1000.0
2012-11-06 07:00:00	IWM	ETF	82.1	82.1	81.95	81.95	15400.0
2012-11-06 08:00:00	IWM	ETF	81.88	82.05	81.83	82.02	48527.0
2012-11-06 09:00:00	IWM	ETF	82.03	82.31	81.79	82.289	2769135.0
2012-11-06 10:00:00	IWM	ETF	82.3	82.36	81.97	82.15	3575561.0
2012-11-06 11:00:00	IWM	ETF	82.15	82.42	82.12	82.36	2885006.0
2012-11-06 12:00:00	IWM	ETF	82.36	82.57	82.339	82.43	3064846.0
2012-11-06 13:00:00	IWM	ETF	82.43	82.57	82.33	82.45	1579555.0
2012-11-06 14:00:00	IWM	ETF	82.44	82.51	82.26	82.34	1981024.0
2012-11-06 15:00:00	IWM	ETF	82.34	82.4016	82.17	82.34	6749654.0
2012-11-06 16:00:00	IWM	ETF	82.34	82.42	82.2547	82.42	1095691.0
2012-11-06 17:00:00	IWM	ETF	82.3307	82.39	82.3307	82.39	70200.0
2012-11-06 19:00:00	IWM	ETF	82.22	82.24	82.17	82.23	4813.0
2012-11-06 08:00:00	DIA	ETF	131.26	131.28	131.22	131.25	4400.0
2012-11-06 09:00:00	DIA	ETF	131.26	131.66	131.2	131.64	431307.0
2012-11-06 10:00:00	DIA	ETF	131.64	131.81	131.42	131.65	446546.0
2012-11-06 11:00:00	DIA	ETF	131.65	132.45	131.61	132.38	642379.0
2012-11-06 12:00:00	DIA	ETF	132.38	132.63	132.227	132.33	861212.0

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

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