PREVIEW / etf_1hour / 2013-07-09

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-07-09.parquet
  size:    204 KB
  rows:    6,495

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
2013-07-09 04:00:00	SPY	ETF	164.86	164.92	164.73	164.8	55450.0
2013-07-09 05:00:00	SPY	ETF	164.73	164.8	164.66	164.66	20290.0
2013-07-09 06:00:00	SPY	ETF	164.68	164.7	164.4	164.5	43250.0
2013-07-09 07:00:00	SPY	ETF	164.5	164.72	164.5	164.65	263083.0
2013-07-09 08:00:00	SPY	ETF	164.65	164.92	164.45	164.89	783251.0
2013-07-09 09:00:00	SPY	ETF	164.89	165.13	163.94	164.77	16448853.0
2013-07-09 10:00:00	SPY	ETF	164.77	164.78	164.27	164.755	22823290.0
2013-07-09 11:00:00	SPY	ETF	164.755	165.06	164.735	164.9	18182588.0
2013-07-09 12:00:00	SPY	ETF	164.9	165.2	164.87	165.17	9210012.0
2013-07-09 13:00:00	SPY	ETF	165.18	165.27	164.94	165.14	11249802.0
2013-07-09 14:00:00	SPY	ETF	165.14	165.33	165.03	165.08	9355418.0
2013-07-09 15:00:00	SPY	ETF	165.07	165.33	164.96	165.09	21899329.0
2013-07-09 16:00:00	SPY	ETF	165.08	165.255	163.9426	165.03	7494316.0
2013-07-09 17:00:00	SPY	ETF	165.04	165.19	165.03	165.15	317246.0
2013-07-09 18:00:00	SPY	ETF	165.15	165.19	165.11	165.15	59324.0
2013-07-09 19:00:00	SPY	ETF	165.15	165.16	165.11	165.11	27209.0
2013-07-09 04:00:00	QQQ	ETF	72.99	73.03	72.94	72.94	13100.0
2013-07-09 05:00:00	QQQ	ETF	72.91	72.91	72.91	72.91	800.0
2013-07-09 06:00:00	QQQ	ETF	72.88	72.91	72.8	72.8	8875.0
2013-07-09 07:00:00	QQQ	ETF	72.85	72.88	72.84	72.88	6500.0
2013-07-09 08:00:00	QQQ	ETF	72.85	73.01	72.85	72.99	50438.0
2013-07-09 09:00:00	QQQ	ETF	73.02	73.06	72.75	72.81	4088264.0
2013-07-09 10:00:00	QQQ	ETF	72.8	72.935	72.65	72.9192	4581588.0
2013-07-09 11:00:00	QQQ	ETF	72.92	73.1	72.89	72.99	3413249.0
2013-07-09 12:00:00	QQQ	ETF	72.99	73.12	72.95	73.1	2047495.0
2013-07-09 13:00:00	QQQ	ETF	73.0987	73.14	72.94	73.07	1572934.0
2013-07-09 14:00:00	QQQ	ETF	73.07	73.17	73.06	73.12	2907024.0
2013-07-09 15:00:00	QQQ	ETF	73.125	73.25	73.04	73.08	4707189.0
2013-07-09 16:00:00	QQQ	ETF	73.08	73.1982	72.911	73.05	2405307.0
2013-07-09 17:00:00	QQQ	ETF	73.04	73.13	73.04	73.1	9600.0
2013-07-09 18:00:00	QQQ	ETF	73.08	73.11	73.08	73.1	2940.0
2013-07-09 19:00:00	QQQ	ETF	73.11	73.12	73.09	73.09	5285.0
2013-07-09 04:00:00	IWM	ETF	100.48	100.63	100.24	100.52	800.0
2013-07-09 06:00:00	IWM	ETF	100.32	100.53	100.31	100.4	6900.0
2013-07-09 07:00:00	IWM	ETF	100.45	100.55	100.41	100.53	58700.0
2013-07-09 08:00:00	IWM	ETF	100.5	100.66	100.43	100.64	170596.0
2013-07-09 09:00:00	IWM	ETF	100.66	100.81	100.54	100.59	3763043.0
2013-07-09 10:00:00	IWM	ETF	100.59	100.68	100.3	100.64	5138232.0
2013-07-09 11:00:00	IWM	ETF	100.64	100.97	100.633	100.81	3834619.0
2013-07-09 12:00:00	IWM	ETF	100.8	101.2	100.75	101.12	3373461.0
2013-07-09 13:00:00	IWM	ETF	101.13	101.18	100.97	101.05	2330749.0
2013-07-09 14:00:00	IWM	ETF	101.04	101.18	100.9	100.93	3640079.0
2013-07-09 15:00:00	IWM	ETF	100.94	101.09	100.79	101.02	7298046.0
2013-07-09 16:00:00	IWM	ETF	101.01	101.08	100.9887	101.03	962015.0
2013-07-09 17:00:00	IWM	ETF	101.04	101.08	101.03	101.08	8311.0
2013-07-09 18:00:00	IWM	ETF	101.05	101.1	101.05	101.1	700.0
2013-07-09 19:00:00	IWM	ETF	101.1	101.1	101.05	101.1	400.0
2013-07-09 04:00:00	DIA	ETF	152.5	152.63	152.5	152.63	200.0
2013-07-09 08:00:00	DIA	ETF	152.5	152.63	152.37	152.63	25971.0
2013-07-09 09:00:00	DIA	ETF	152.63	152.86	152.62	152.78	744434.0

> showing 50 of 6,495 rows — these rows as CSV

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