PREVIEW / etf_1hour / 2012-11-30

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-11-30.parquet
  size:    185 KB
  rows:    5,763

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-30 04:00:00	SPY	ETF	142.2	142.31	142.17	142.17	1250.0
2012-11-30 05:00:00	SPY	ETF	142.15	142.36	142.15	142.34	9838.0
2012-11-30 06:00:00	SPY	ETF	142.31	142.59	142.31	142.42	158388.0
2012-11-30 07:00:00	SPY	ETF	142.42	142.53	142.31	142.35	152963.0
2012-11-30 08:00:00	SPY	ETF	142.33	142.43	142.1	142.21	981078.0
2012-11-30 09:00:00	SPY	ETF	142.2	142.25	141.91	142.07	14900270.0
2012-11-30 10:00:00	SPY	ETF	142.07	142.3	141.78	142.02	18216732.0
2012-11-30 11:00:00	SPY	ETF	142.02	142.11	141.66	141.825	14969792.0
2012-11-30 12:00:00	SPY	ETF	141.845	142.01	141.69	141.825	14342528.0
2012-11-30 13:00:00	SPY	ETF	141.83	142.09	141.8	141.9699	10002852.0
2012-11-30 14:00:00	SPY	ETF	141.96	142.15	141.76	141.771	10869989.0
2012-11-30 15:00:00	SPY	ETF	141.77	142.42	141.68	142.059	30344058.0
2012-11-30 16:00:00	SPY	ETF	142.04	142.25	141.89	142.12	19055779.0
2012-11-30 17:00:00	SPY	ETF	142.13	142.27	141.9622	142.02	791678.0
2012-11-30 18:00:00	SPY	ETF	142.07	142.2	142.01	142.12	210749.0
2012-11-30 19:00:00	SPY	ETF	142.12	142.27	142.07	142.24	58912.0
2012-11-30 04:00:00	QQQ	ETF	66.07	66.07	66.05	66.05	386.0
2012-11-30 05:00:00	QQQ	ETF	66.03	66.05	66.03	66.05	700.0
2012-11-30 06:00:00	QQQ	ETF	66.08	66.13	66.08	66.13	500.0
2012-11-30 07:00:00	QQQ	ETF	66.11	66.12	66.04	66.05	2800.0
2012-11-30 08:00:00	QQQ	ETF	66.06	66.07	65.93	65.93	265881.0
2012-11-30 09:00:00	QQQ	ETF	65.93	65.97	65.75	65.8	4571854.0
2012-11-30 10:00:00	QQQ	ETF	65.78	65.9	65.71	65.83	3911310.0
2012-11-30 11:00:00	QQQ	ETF	65.83	65.85	65.61	65.745	3345899.0
2012-11-30 12:00:00	QQQ	ETF	65.75	65.82	65.67	65.715	2654791.0
2012-11-30 13:00:00	QQQ	ETF	65.72	65.84	65.7	65.81	1944914.0
2012-11-30 14:00:00	QQQ	ETF	65.81	65.9	65.69	65.695	2045352.0
2012-11-30 15:00:00	QQQ	ETF	65.69	65.97	65.64	65.82	7571079.0
2012-11-30 16:00:00	QQQ	ETF	65.81	65.91	65.7101	65.91	1756183.0
2012-11-30 17:00:00	QQQ	ETF	65.9	65.93	65.7781	65.9	92178.0
2012-11-30 18:00:00	QQQ	ETF	65.89	65.9	65.88	65.9	7399.0
2012-11-30 19:00:00	QQQ	ETF	65.89	65.92	65.89	65.89	3600.0
2012-11-30 04:00:00	IWM	ETF	82.38	82.38	82.38	82.38	100.0
2012-11-30 06:00:00	IWM	ETF	82.65	82.65	82.65	82.65	10100.0
2012-11-30 07:00:00	IWM	ETF	82.6	82.67	82.57	82.59	30300.0
2012-11-30 08:00:00	IWM	ETF	82.59	82.65	82.23	82.44	1327721.0
2012-11-30 09:00:00	IWM	ETF	82.37	82.44	82.14	82.16	4886516.0
2012-11-30 10:00:00	IWM	ETF	82.15	82.3	81.98	82.11	4087744.0
2012-11-30 11:00:00	IWM	ETF	82.09	82.13	81.73	81.9	4005149.0
2012-11-30 12:00:00	IWM	ETF	81.91	82.04	81.82	81.92	3516019.0
2012-11-30 13:00:00	IWM	ETF	81.91	81.98	81.79	81.88	1920085.0
2012-11-30 14:00:00	IWM	ETF	81.88	82.11	81.85	81.91	2390801.0
2012-11-30 15:00:00	IWM	ETF	81.9	82.15	81.845	82.11	6929550.0
2012-11-30 16:00:00	IWM	ETF	82.1	82.24	82.0	82.17	2294236.0
2012-11-30 17:00:00	IWM	ETF	82.2	82.28	81.963	82.28	123395.0
2012-11-30 18:00:00	IWM	ETF	82.21	82.21	82.18	82.18	1500.0
2012-11-30 04:00:00	DIA	ETF	130.34	130.34	130.26	130.26	200.0
2012-11-30 05:00:00	DIA	ETF	130.38	130.52	130.38	130.46	800.0
2012-11-30 06:00:00	DIA	ETF	130.52	130.56	130.52	130.55	400.0
2012-11-30 07:00:00	DIA	ETF	130.49	130.5	130.42	130.42	29600.0

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

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