PREVIEW / etf_1hour / 2012-07-16

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-07-16.parquet
  size:    178 KB
  rows:    5,496

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
2012-07-16 04:00:00	SPY	ETF	135.53	135.55	135.37	135.37	6750.0
2012-07-16 05:00:00	SPY	ETF	135.45	135.5	135.29	135.35	19500.0
2012-07-16 06:00:00	SPY	ETF	135.35	135.55	135.34	135.41	15250.0
2012-07-16 07:00:00	SPY	ETF	135.38	135.48	135.36	135.43	135766.0
2012-07-16 08:00:00	SPY	ETF	135.42	135.47	135.2	135.38	1671237.0
2012-07-16 09:00:00	SPY	ETF	135.4	135.54	135.0	135.02	12309111.0
2012-07-16 10:00:00	SPY	ETF	135.02	135.6	134.9	135.39	14421497.0
2012-07-16 11:00:00	SPY	ETF	135.39	135.83	135.32	135.54	11654876.0
2012-07-16 12:00:00	SPY	ETF	135.54	135.66	135.18	135.38	10228697.0
2012-07-16 13:00:00	SPY	ETF	135.39	135.6	135.26	135.49	8196301.0
2012-07-16 14:00:00	SPY	ETF	135.49	135.76	135.47	135.56	10175039.0
2012-07-16 15:00:00	SPY	ETF	135.565	135.66	135.245	135.42	16408506.0
2012-07-16 16:00:00	SPY	ETF	135.41	135.6	135.26	135.32	5920389.0
2012-07-16 17:00:00	SPY	ETF	135.34	135.36	135.27	135.31	5023716.0
2012-07-16 18:00:00	SPY	ETF	135.3	135.34	135.24	135.25	48144.0
2012-07-16 19:00:00	SPY	ETF	135.27	135.31	135.24	135.25	68080.0
2012-07-16 07:00:00	QQQ	ETF	63.19	63.24	63.19	63.22	41200.0
2012-07-16 08:00:00	QQQ	ETF	63.19	63.24	63.13	63.19	274366.0
2012-07-16 09:00:00	QQQ	ETF	63.21	63.37	62.96	63.01	4013095.0
2012-07-16 10:00:00	QQQ	ETF	63.01	63.32	62.95	63.22	3653583.0
2012-07-16 11:00:00	QQQ	ETF	63.23	63.52	63.18	63.37	5061490.0
2012-07-16 12:00:00	QQQ	ETF	63.37	63.43	63.08	63.19	3402547.0
2012-07-16 13:00:00	QQQ	ETF	63.19	63.4	63.141	63.3	2135660.0
2012-07-16 14:00:00	QQQ	ETF	63.31	63.41	63.18	63.24	2784723.0
2012-07-16 15:00:00	QQQ	ETF	63.25	63.32	63.06	63.2	3883193.0
2012-07-16 16:00:00	QQQ	ETF	63.2	63.384	63.1217	63.21	427943.0
2012-07-16 17:00:00	QQQ	ETF	63.22	63.22	63.15	63.15	7473.0
2012-07-16 18:00:00	QQQ	ETF	63.17	63.21	63.16	63.16	2353.0
2012-07-16 19:00:00	QQQ	ETF	63.17	63.2	63.17	63.2	1155.0
2012-07-16 07:00:00	IWM	ETF	79.6	79.6	79.56	79.57	9868.0
2012-07-16 08:00:00	IWM	ETF	79.59	80.19	79.38	79.59	110604.0
2012-07-16 09:00:00	IWM	ETF	79.6	79.73	79.16	79.26	4031379.0
2012-07-16 10:00:00	IWM	ETF	79.25	79.71	79.111	79.51	5702763.0
2012-07-16 11:00:00	IWM	ETF	79.51	79.88	79.48	79.61	3324802.0
2012-07-16 12:00:00	IWM	ETF	79.61	79.68	79.29	79.48	3349698.0
2012-07-16 13:00:00	IWM	ETF	79.475	79.66	79.41	79.6	2409086.0
2012-07-16 14:00:00	IWM	ETF	79.6	79.8	79.53	79.59	2837366.0
2012-07-16 15:00:00	IWM	ETF	79.5899	79.66	79.3	79.48	4479643.0
2012-07-16 16:00:00	IWM	ETF	79.48	79.8686	79.43	79.47	1679017.0
2012-07-16 17:00:00	IWM	ETF	79.48	79.48	79.41	79.41	20300.0
2012-07-16 18:00:00	IWM	ETF	79.44	79.44	79.4	79.4	1983.0
2012-07-16 19:00:00	IWM	ETF	79.44	79.44	79.44	79.44	900.0
2012-07-16 08:00:00	DIA	ETF	127.14	127.25	127.11	127.25	3250.0
2012-07-16 09:00:00	DIA	ETF	127.29	127.37	126.8318	126.86	214286.0
2012-07-16 10:00:00	DIA	ETF	126.84	127.26	126.75	127.04	260110.0
2012-07-16 11:00:00	DIA	ETF	127.01	127.51	126.96	127.3	265068.0
2012-07-16 12:00:00	DIA	ETF	127.2918	127.34	126.94	127.13	160721.0
2012-07-16 13:00:00	DIA	ETF	127.13	127.26	126.985	127.17	159424.0
2012-07-16 14:00:00	DIA	ETF	127.18	127.45	127.18	127.31	346270.0
2012-07-16 15:00:00	DIA	ETF	127.31	127.36	126.99	127.1	535359.0

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

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