PREVIEW / etf_1hour / 2013-05-06

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-05-06.parquet
  size:    201 KB
  rows:    6,304

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-05-06 04:00:00	SPY	ETF	161.37	161.52	161.37	161.52	1200.0
2013-05-06 05:00:00	SPY	ETF	161.51	161.51	161.36	161.38	2699.0
2013-05-06 06:00:00	SPY	ETF	161.33	161.4	161.2	161.27	19299.0
2013-05-06 07:00:00	SPY	ETF	161.23	161.31	161.22	161.3	140777.0
2013-05-06 08:00:00	SPY	ETF	161.31	161.51	161.25	161.43	414783.0
2013-05-06 09:00:00	SPY	ETF	161.44	161.72	161.39	161.48	9645213.0
2013-05-06 10:00:00	SPY	ETF	161.48	161.84	161.46	161.52	13282279.0
2013-05-06 11:00:00	SPY	ETF	161.51	161.79	161.46	161.7599	7190493.0
2013-05-06 12:00:00	SPY	ETF	161.75	161.87	161.73	161.799	5752844.0
2013-05-06 13:00:00	SPY	ETF	161.8	161.99	161.74	161.98	6298166.0
2013-05-06 14:00:00	SPY	ETF	161.97	162.01	161.87	161.88	5290473.0
2013-05-06 15:00:00	SPY	ETF	161.8801	161.92	161.69	161.79	11933914.0
2013-05-06 16:00:00	SPY	ETF	161.79	161.85	161.45	161.77	2925812.0
2013-05-06 17:00:00	SPY	ETF	161.78	161.82	161.74	161.8	66312.0
2013-05-06 18:00:00	SPY	ETF	161.78	161.78	161.63	161.68	118289.0
2013-05-06 19:00:00	SPY	ETF	161.67	161.7	161.58	161.6	44069.0
2013-05-06 04:00:00	QQQ	ETF	72.25	72.25	72.19	72.19	23009.0
2013-05-06 06:00:00	QQQ	ETF	72.16	72.16	72.1	72.1	2196.0
2013-05-06 07:00:00	QQQ	ETF	72.1	72.13	72.1	72.13	3904.0
2013-05-06 08:00:00	QQQ	ETF	72.11	72.5	72.11	72.23	205274.0
2013-05-06 09:00:00	QQQ	ETF	72.23	72.39	72.19	72.3	2954009.0
2013-05-06 10:00:00	QQQ	ETF	72.3	72.43	72.21	72.23	4806077.0
2013-05-06 11:00:00	QQQ	ETF	72.22	72.43	72.2	72.42	1852934.0
2013-05-06 12:00:00	QQQ	ETF	72.42	72.45	72.355	72.4	1214212.0
2013-05-06 13:00:00	QQQ	ETF	72.409	72.51	72.36	72.5	1202293.0
2013-05-06 14:00:00	QQQ	ETF	72.49	72.51	72.41	72.42	2185415.0
2013-05-06 15:00:00	QQQ	ETF	72.43	72.47	72.36	72.4	3784895.0
2013-05-06 16:00:00	QQQ	ETF	72.4	72.41	72.35	72.37	775745.0
2013-05-06 17:00:00	QQQ	ETF	72.38	72.42	72.35	72.36	14100.0
2013-05-06 18:00:00	QQQ	ETF	72.35	72.35	72.31	72.32	27025.0
2013-05-06 19:00:00	QQQ	ETF	72.31	72.32	72.29	72.3	11118.0
2013-05-06 07:00:00	IWM	ETF	94.78	94.78	94.73	94.73	14900.0
2013-05-06 08:00:00	IWM	ETF	94.78	94.91	94.78	94.8	164917.0
2013-05-06 09:00:00	IWM	ETF	94.83	95.1	94.74	95.01	3327727.0
2013-05-06 10:00:00	IWM	ETF	95.02	95.39	94.93	94.99	6343330.0
2013-05-06 11:00:00	IWM	ETF	94.99	95.22	94.87	95.1801	3815599.0
2013-05-06 12:00:00	IWM	ETF	95.2	95.43	95.145	95.33	2518850.0
2013-05-06 13:00:00	IWM	ETF	95.34	95.4	95.23	95.38	1533930.0
2013-05-06 14:00:00	IWM	ETF	95.38	95.5	95.3	95.33	2180963.0
2013-05-06 15:00:00	IWM	ETF	95.33	95.45	95.2117	95.4	4885967.0
2013-05-06 16:00:00	IWM	ETF	95.39	95.45	94.95	95.42	1257808.0
2013-05-06 17:00:00	IWM	ETF	95.38	95.38	95.38	95.38	700.0
2013-05-06 18:00:00	IWM	ETF	95.32	95.32	95.32	95.32	500.0
2013-05-06 19:00:00	IWM	ETF	95.32	95.32	95.32	95.32	1000.0
2013-05-06 07:00:00	DIA	ETF	149.32	149.33	149.32	149.33	200.0
2013-05-06 08:00:00	DIA	ETF	149.29	149.35	149.29	149.34	6990.0
2013-05-06 09:00:00	DIA	ETF	149.31	149.44	149.14	149.199	424984.0
2013-05-06 10:00:00	DIA	ETF	149.19	149.4901	149.16	149.21	573983.0
2013-05-06 11:00:00	DIA	ETF	149.21	149.47	149.16	149.44	337646.0
2013-05-06 12:00:00	DIA	ETF	149.455	149.5582	149.41	149.4562	424395.0

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

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