PREVIEW / etf_1hour / 2013-07-25

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-07-25.parquet
  size:    206 KB
  rows:    6,417

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-25 04:00:00	SPY	ETF	168.38	168.5	168.01	168.05	30300.0
2013-07-25 05:00:00	SPY	ETF	168.04	168.1	167.64	167.73	127980.0
2013-07-25 06:00:00	SPY	ETF	167.68	167.88	167.65	167.88	160081.0
2013-07-25 07:00:00	SPY	ETF	167.88	168.2	167.88	168.11	479646.0
2013-07-25 08:00:00	SPY	ETF	167.87	168.33	167.87	168.1	847522.0
2013-07-25 09:00:00	SPY	ETF	168.13	168.55	167.97	168.43	15024713.0
2013-07-25 10:00:00	SPY	ETF	168.43	168.67	168.29	168.45	11981416.0
2013-07-25 11:00:00	SPY	ETF	168.46	168.46	167.94	168.13	11451663.0
2013-07-25 12:00:00	SPY	ETF	168.1201	168.823	168.07	168.79	10634813.0
2013-07-25 13:00:00	SPY	ETF	168.79	168.86	168.66	168.72	5858847.0
2013-07-25 14:00:00	SPY	ETF	168.72	168.92	168.44	168.455	9503680.0
2013-07-25 15:00:00	SPY	ETF	168.45	169.08	168.44	168.95	22095065.0
2013-07-25 16:00:00	SPY	ETF	168.94	168.99	168.46	168.98	15859003.0
2013-07-25 17:00:00	SPY	ETF	168.99	169.05	168.95	168.99	125931.0
2013-07-25 18:00:00	SPY	ETF	169.0	169.09	168.95	169.07	41877.0
2013-07-25 19:00:00	SPY	ETF	169.06	169.08	169.0	169.04	47805.0
2013-07-25 04:00:00	QQQ	ETF	74.77	74.8	74.58	74.58	24100.0
2013-07-25 05:00:00	QQQ	ETF	74.56	74.58	74.34	74.34	29688.0
2013-07-25 06:00:00	QQQ	ETF	74.32	74.44	74.32	74.44	15900.0
2013-07-25 07:00:00	QQQ	ETF	74.46	74.82	74.46	74.81	54800.0
2013-07-25 08:00:00	QQQ	ETF	74.82	74.95	74.46	74.89	614998.0
2013-07-25 09:00:00	QQQ	ETF	74.89	74.96	74.535	74.8	3423135.0
2013-07-25 10:00:00	QQQ	ETF	74.8	74.91	74.71	74.73	2334067.0
2013-07-25 11:00:00	QQQ	ETF	74.74	74.74	74.46	74.571	3255197.0
2013-07-25 12:00:00	QQQ	ETF	74.58	74.97	74.56	74.9501	2431261.0
2013-07-25 13:00:00	QQQ	ETF	74.96	74.98	74.87	74.88	1100842.0
2013-07-25 14:00:00	QQQ	ETF	74.89	74.96	74.78	74.785	1597350.0
2013-07-25 15:00:00	QQQ	ETF	74.78	75.06	74.77	74.98	5509448.0
2013-07-25 16:00:00	QQQ	ETF	74.98	75.0464	74.8	74.97	1761850.0
2013-07-25 17:00:00	QQQ	ETF	74.96	74.98	74.91	74.93	10657.0
2013-07-25 18:00:00	QQQ	ETF	74.93	74.95	74.9	74.91	4566.0
2013-07-25 19:00:00	QQQ	ETF	74.93	74.97	74.93	74.97	3210.0
2013-07-25 06:00:00	IWM	ETF	103.14	103.32	103.05	103.16	8347.0
2013-07-25 07:00:00	IWM	ETF	103.23	103.4	103.22	103.34	155520.0
2013-07-25 08:00:00	IWM	ETF	103.35	103.44	103.26	103.31	161145.0
2013-07-25 09:00:00	IWM	ETF	103.37	103.99	103.32	103.863	3373792.0
2013-07-25 10:00:00	IWM	ETF	103.87	104.09	103.76	104.05	5149097.0
2013-07-25 11:00:00	IWM	ETF	104.05	104.06	103.69	103.83	4278631.0
2013-07-25 12:00:00	IWM	ETF	103.83	104.505	103.77	104.46	3933620.0
2013-07-25 13:00:00	IWM	ETF	104.46	104.51	104.3	104.37	2238280.0
2013-07-25 14:00:00	IWM	ETF	104.38	104.5	104.17	104.18	2238771.0
2013-07-25 15:00:00	IWM	ETF	104.17	104.65	104.16	104.61	8091930.0
2013-07-25 16:00:00	IWM	ETF	104.61	104.63	103.5815	104.58	4840075.0
2013-07-25 17:00:00	IWM	ETF	104.6	104.63	104.5	104.6	28000.0
2013-07-25 18:00:00	IWM	ETF	104.58	104.61	104.56	104.61	4064.0
2013-07-25 19:00:00	IWM	ETF	104.61	104.65	104.61	104.64	1582.0
2013-07-25 04:00:00	DIA	ETF	154.75	154.75	154.7	154.7	2500.0
2013-07-25 05:00:00	DIA	ETF	154.65	154.65	154.37	154.37	18300.0
2013-07-25 06:00:00	DIA	ETF	154.45	154.45	154.45	154.45	900.0
2013-07-25 07:00:00	DIA	ETF	154.67	154.67	154.67	154.67	1800.0

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

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