PREVIEW / etf_1hour / 2013-07-19

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-07-19.parquet
  size:    200 KB
  rows:    6,255

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-19 04:00:00	SPY	ETF	168.2	168.3	168.19	168.19	15460.0
2013-07-19 05:00:00	SPY	ETF	168.16	168.36	168.15	168.33	19394.0
2013-07-19 06:00:00	SPY	ETF	168.36	168.41	168.31	168.34	51420.0
2013-07-19 07:00:00	SPY	ETF	168.34	168.64	168.3	168.53	270369.0
2013-07-19 08:00:00	SPY	ETF	168.51	168.64	168.28	168.33	667172.0
2013-07-19 09:00:00	SPY	ETF	168.33	168.68	168.16	168.48	18015891.0
2013-07-19 10:00:00	SPY	ETF	168.49	168.81	168.38	168.73	16412815.0
2013-07-19 11:00:00	SPY	ETF	168.73	168.92	168.61	168.7	11154242.0
2013-07-19 12:00:00	SPY	ETF	168.71	168.81	168.64	168.72	8551413.0
2013-07-19 13:00:00	SPY	ETF	168.73	168.87	168.67	168.825	6570514.0
2013-07-19 14:00:00	SPY	ETF	168.829	169.06	168.8	168.92	8902468.0
2013-07-19 15:00:00	SPY	ETF	168.92	169.19	168.9	169.17	22093242.0
2013-07-19 16:00:00	SPY	ETF	169.18	169.48	168.5109	169.44	8550881.0
2013-07-19 17:00:00	SPY	ETF	169.43	169.49	168.8761	169.45	198001.0
2013-07-19 18:00:00	SPY	ETF	169.47	169.61	169.47	169.51	88076.0
2013-07-19 19:00:00	SPY	ETF	169.5	169.6	169.47	169.6	34429.0
2013-07-19 04:00:00	QQQ	ETF	75.24	75.24	74.62	74.62	27200.0
2013-07-19 05:00:00	QQQ	ETF	74.6	74.63	74.58	74.63	4285.0
2013-07-19 06:00:00	QQQ	ETF	74.63	74.64	74.61	74.63	1750.0
2013-07-19 07:00:00	QQQ	ETF	74.64	74.78	74.64	74.77	75377.0
2013-07-19 08:00:00	QQQ	ETF	74.67	74.77	74.65	74.72	261206.0
2013-07-19 09:00:00	QQQ	ETF	74.72	74.74	74.48	74.55	8773626.0
2013-07-19 10:00:00	QQQ	ETF	74.55	74.649	74.43	74.55	5939815.0
2013-07-19 11:00:00	QQQ	ETF	74.55	74.66	74.391	74.44	4939297.0
2013-07-19 12:00:00	QQQ	ETF	74.45	74.52	74.39	74.46	1454323.0
2013-07-19 13:00:00	QQQ	ETF	74.465	74.5	74.37	74.485	1578952.0
2013-07-19 14:00:00	QQQ	ETF	74.48	74.6	74.44	74.46	1728999.0
2013-07-19 15:00:00	QQQ	ETF	74.46	74.6	74.4	74.6	5695111.0
2013-07-19 16:00:00	QQQ	ETF	74.6	75.3971	74.44	74.69	5545492.0
2013-07-19 17:00:00	QQQ	ETF	74.7	74.74	74.4952	74.7	27533.0
2013-07-19 18:00:00	QQQ	ETF	74.69	74.69	74.69	74.69	500.0
2013-07-19 19:00:00	QQQ	ETF	74.73	74.79	74.72	74.72	1683.0
2013-07-19 04:00:00	IWM	ETF	103.8	103.8	103.79	103.79	1000.0
2013-07-19 05:00:00	IWM	ETF	103.89	103.89	103.89	103.89	100.0
2013-07-19 07:00:00	IWM	ETF	104.04	104.05	104.0	104.0	12500.0
2013-07-19 08:00:00	IWM	ETF	104.04	104.04	103.86	103.9	180700.0
2013-07-19 09:00:00	IWM	ETF	103.91	104.16	103.74	103.85	3414694.0
2013-07-19 10:00:00	IWM	ETF	103.86	104.25	103.84	104.2	3712706.0
2013-07-19 11:00:00	IWM	ETF	104.2	104.31	103.99	104.06	3122808.0
2013-07-19 12:00:00	IWM	ETF	104.06	104.16	104.04	104.11	1131406.0
2013-07-19 13:00:00	IWM	ETF	104.12	104.21	104.06	104.19	1093674.0
2013-07-19 14:00:00	IWM	ETF	104.19	104.28	104.17	104.21	2116134.0
2013-07-19 15:00:00	IWM	ETF	104.21	104.29	104.19	104.26	6158413.0
2013-07-19 16:00:00	IWM	ETF	104.26	104.43	104.22	104.36	910447.0
2013-07-19 17:00:00	IWM	ETF	104.36	104.41	104.36	104.41	5928.0
2013-07-19 18:00:00	IWM	ETF	104.36	104.69	104.36	104.5	2074.0
2013-07-19 19:00:00	IWM	ETF	104.44	104.44	104.44	104.44	667.0
2013-07-19 07:00:00	DIA	ETF	154.96	155.0	154.91	154.91	9186.0
2013-07-19 08:00:00	DIA	ETF	154.91	154.92	154.76	154.78	33500.0
2013-07-19 09:00:00	DIA	ETF	154.78	154.94	154.57	154.68	1486476.0

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

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