PREVIEW / etf_1hour / 2011-11-07

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-11-07.parquet
  size:    180 KB
  rows:    5,537

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
2011-11-07 04:00:00	SPY	ETF	124.42	124.42	123.88	124.1	125163.0
2011-11-07 05:00:00	SPY	ETF	124.03	124.5	123.8	124.5	34882.0
2011-11-07 06:00:00	SPY	ETF	124.48	125.37	124.48	124.49	173636.0
2011-11-07 07:00:00	SPY	ETF	124.52	125.36	124.5	125.22	492081.0
2011-11-07 08:00:00	SPY	ETF	125.26	125.31	124.22	125.17	1811598.0
2011-11-07 09:00:00	SPY	ETF	125.17	126.16	125.05	125.9	27690754.0
2011-11-07 10:00:00	SPY	ETF	125.9	125.975	124.71	124.82	33635315.0
2011-11-07 11:00:00	SPY	ETF	124.82	125.24	124.62	124.72	24994677.0
2011-11-07 12:00:00	SPY	ETF	124.72	125.05	124.2	124.56	23755466.0
2011-11-07 13:00:00	SPY	ETF	124.56	125.37	124.46	125.26	16286133.0
2011-11-07 14:00:00	SPY	ETF	125.27	125.96	125.15	125.94	29748057.0
2011-11-07 15:00:00	SPY	ETF	125.95	126.39	125.69	126.27	30360979.0
2011-11-07 16:00:00	SPY	ETF	126.28	126.48	124.8	126.48	5265089.0
2011-11-07 17:00:00	SPY	ETF	126.49	127.05	126.41	126.72	558016.0
2011-11-07 18:00:00	SPY	ETF	126.67	126.74	126.28	126.39	272612.0
2011-11-07 19:00:00	SPY	ETF	126.39	126.44	126.22	126.28	168472.0
2011-11-07 04:00:00	QQQ	ETF	57.25	57.25	57.15	57.22	5110.0
2011-11-07 05:00:00	QQQ	ETF	57.12	57.36	57.11	57.36	14600.0
2011-11-07 06:00:00	QQQ	ETF	57.41	57.64	57.41	57.64	14974.0
2011-11-07 07:00:00	QQQ	ETF	57.5	57.75	57.44	57.71	77123.0
2011-11-07 08:00:00	QQQ	ETF	57.71	57.71	57.5	57.67	223624.0
2011-11-07 09:00:00	QQQ	ETF	57.67	58.07	57.63	57.98	5803733.0
2011-11-07 10:00:00	QQQ	ETF	57.9829	58.02	57.3	57.3299	8519257.0
2011-11-07 11:00:00	QQQ	ETF	57.33	57.555	57.28	57.42	4543534.0
2011-11-07 12:00:00	QQQ	ETF	57.425	57.56	57.17	57.33	5966253.0
2011-11-07 13:00:00	QQQ	ETF	57.33	57.74	57.31	57.69	3112563.0
2011-11-07 14:00:00	QQQ	ETF	57.69	58.03	57.66	58.02	11457262.0
2011-11-07 15:00:00	QQQ	ETF	58.02	58.25	57.96	58.21	13578713.0
2011-11-07 16:00:00	QQQ	ETF	58.21	58.35	58.21	58.33	1381998.0
2011-11-07 17:00:00	QQQ	ETF	58.34	58.49	58.34	58.42	56417.0
2011-11-07 18:00:00	QQQ	ETF	58.41	58.43	58.29	58.3	44571.0
2011-11-07 19:00:00	QQQ	ETF	58.31	58.32	58.22	58.26	32699.0
2011-11-07 04:00:00	IWM	ETF	74.2	74.2	73.38	73.38	2250.0
2011-11-07 05:00:00	IWM	ETF	73.4	73.4	73.4	73.4	500.0
2011-11-07 06:00:00	IWM	ETF	74.39	74.39	73.71	73.71	1890.0
2011-11-07 07:00:00	IWM	ETF	73.71	74.52	73.71	74.52	198686.0
2011-11-07 08:00:00	IWM	ETF	74.51	74.61	74.14	74.36	172042.0
2011-11-07 09:00:00	IWM	ETF	74.38	74.87	74.28	74.45	8931306.0
2011-11-07 10:00:00	IWM	ETF	74.46	74.49	73.25	73.44	13133672.0
2011-11-07 11:00:00	IWM	ETF	73.43	73.88	73.34	73.42	7270661.0
2011-11-07 12:00:00	IWM	ETF	73.41	73.62	72.9	73.219	7100930.0
2011-11-07 13:00:00	IWM	ETF	73.24	73.86	73.14	73.8	3859908.0
2011-11-07 14:00:00	IWM	ETF	73.8	74.62	73.78	74.5826	7590802.0
2011-11-07 15:00:00	IWM	ETF	74.59	74.7	74.12	74.42	10207091.0
2011-11-07 16:00:00	IWM	ETF	74.43	74.57	74.33	74.57	1373987.0
2011-11-07 17:00:00	IWM	ETF	74.5951	74.82	74.56	74.76	528470.0
2011-11-07 18:00:00	IWM	ETF	74.57	74.63	74.56	74.57	3000.0
2011-11-07 19:00:00	IWM	ETF	74.6	74.6	74.5	74.5	3700.0
2011-11-07 06:00:00	DIA	ETF	118.86	119.13	118.86	119.13	650.0
2011-11-07 07:00:00	DIA	ETF	119.15	119.4	119.15	119.4	1220.0

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

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