PREVIEW / etf_1hour / 2013-11-05

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-11-05.parquet
  size:    206 KB
  rows:    6,541

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-11-05 04:00:00	SPY	ETF	176.66	176.66	176.26	176.3	47620.0
2013-11-05 05:00:00	SPY	ETF	176.33	176.41	176.29	176.33	14941.0
2013-11-05 06:00:00	SPY	ETF	176.35	176.45	176.26	176.29	87300.0
2013-11-05 07:00:00	SPY	ETF	176.33	176.38	176.21	176.33	429181.0
2013-11-05 08:00:00	SPY	ETF	176.33	176.4	176.07	176.11	1223516.0
2013-11-05 09:00:00	SPY	ETF	176.11	176.23	175.67	175.801	12869186.0
2013-11-05 10:00:00	SPY	ETF	175.8	176.425	175.57	176.33	19710148.0
2013-11-05 11:00:00	SPY	ETF	176.335	176.5	176.211	176.45	9416646.0
2013-11-05 12:00:00	SPY	ETF	176.46	176.75	176.4	176.56	7249329.0
2013-11-05 13:00:00	SPY	ETF	176.56	176.6999	176.36	176.3701	4569888.0
2013-11-05 14:00:00	SPY	ETF	176.371	176.72	176.35	176.59	5763071.0
2013-11-05 15:00:00	SPY	ETF	176.58	176.72	176.25	176.32	15715038.0
2013-11-05 16:00:00	SPY	ETF	176.31	176.42	176.14	176.24	5548607.0
2013-11-05 17:00:00	SPY	ETF	176.23	176.29	176.18	176.25	1975316.0
2013-11-05 18:00:00	SPY	ETF	176.25	176.26	176.12	176.2	80138.0
2013-11-05 19:00:00	SPY	ETF	176.18	176.44	176.18	176.37	144515.0
2013-11-05 04:00:00	QQQ	ETF	82.86	82.86	82.62	82.62	14900.0
2013-11-05 05:00:00	QQQ	ETF	82.64	82.64	82.62	82.62	2800.0
2013-11-05 06:00:00	QQQ	ETF	82.64	82.67	82.62	82.64	7400.0
2013-11-05 07:00:00	QQQ	ETF	82.66	82.67	82.6	82.66	120200.0
2013-11-05 08:00:00	QQQ	ETF	82.65	82.7	82.56	82.57	89700.0
2013-11-05 09:00:00	QQQ	ETF	82.58	82.74	82.45	82.53	4791408.0
2013-11-05 10:00:00	QQQ	ETF	82.53	82.91	82.37	82.87	6267221.0
2013-11-05 11:00:00	QQQ	ETF	82.88	82.96	82.83	82.91	3350692.0
2013-11-05 12:00:00	QQQ	ETF	82.9	83.08	82.87	83.0137	1927837.0
2013-11-05 13:00:00	QQQ	ETF	83.015	83.12	82.96	82.97	1627948.0
2013-11-05 14:00:00	QQQ	ETF	82.96	83.19	82.96	83.13	1778351.0
2013-11-05 15:00:00	QQQ	ETF	83.13	83.22	83.01	83.04	4562270.0
2013-11-05 16:00:00	QQQ	ETF	83.04	83.12	82.5656	82.99	1327295.0
2013-11-05 17:00:00	QQQ	ETF	82.98	83.0	82.9335	82.97	502250.0
2013-11-05 18:00:00	QQQ	ETF	82.99	82.99	82.91	82.96	9675.0
2013-11-05 19:00:00	QQQ	ETF	82.99	83.05	82.99	83.05	4250.0
2013-11-05 07:00:00	IWM	ETF	109.59	109.63	109.57	109.63	1700.0
2013-11-05 08:00:00	IWM	ETF	109.64	109.7	109.49	109.5	80932.0
2013-11-05 09:00:00	IWM	ETF	109.49	109.63	108.99	109.11	4217684.0
2013-11-05 10:00:00	IWM	ETF	109.12	109.78	108.86	109.53	7990687.0
2013-11-05 11:00:00	IWM	ETF	109.53	109.64	109.31	109.59	2066161.0
2013-11-05 12:00:00	IWM	ETF	109.585	109.93	109.57	109.69	1780884.0
2013-11-05 13:00:00	IWM	ETF	109.7	109.87	109.47	109.4803	1251448.0
2013-11-05 14:00:00	IWM	ETF	109.48	109.855	109.43	109.73	1816128.0
2013-11-05 15:00:00	IWM	ETF	109.73	109.85	109.57	109.65	4475976.0
2013-11-05 16:00:00	IWM	ETF	109.65	109.7453	109.3884	109.6	1312172.0
2013-11-05 17:00:00	IWM	ETF	109.61	109.62	109.6	109.6	307800.0
2013-11-05 18:00:00	IWM	ETF	109.55	109.55	109.55	109.55	155.0
2013-11-05 19:00:00	IWM	ETF	109.59	109.71	109.51	109.71	1900.0
2013-11-05 04:00:00	DIA	ETF	155.6	155.6	155.6	155.6	100.0
2013-11-05 06:00:00	DIA	ETF	155.62	155.62	155.62	155.62	372.0
2013-11-05 07:00:00	DIA	ETF	155.55	155.55	155.55	155.55	400.0
2013-11-05 08:00:00	DIA	ETF	155.62	155.62	155.38	155.4	7440.0
2013-11-05 09:00:00	DIA	ETF	155.32	155.44	154.99	155.094	819911.0

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

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