PREVIEW / etf_1hour / 2013-04-29

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-04-29.parquet
  size:    199 KB
  rows:    6,222

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-04-29 04:00:00	SPY	ETF	158.44	158.65	158.44	158.56	32659.0
2013-04-29 05:00:00	SPY	ETF	158.6	158.6	158.45	158.5	7200.0
2013-04-29 06:00:00	SPY	ETF	158.47	158.56	158.46	158.51	58583.0
2013-04-29 07:00:00	SPY	ETF	158.53	158.71	158.47	158.65	224988.0
2013-04-29 08:00:00	SPY	ETF	158.65	158.77	158.53	158.59	551893.0
2013-04-29 09:00:00	SPY	ETF	158.59	158.83	158.42	158.69	8830487.0
2013-04-29 10:00:00	SPY	ETF	158.7	159.21	158.63	159.15	15926774.0
2013-04-29 11:00:00	SPY	ETF	159.14	159.18	159.01	159.169	9210045.0
2013-04-29 12:00:00	SPY	ETF	159.16	159.54	159.13	159.375	11322232.0
2013-04-29 13:00:00	SPY	ETF	159.362	159.63	159.33	159.575	6397347.0
2013-04-29 14:00:00	SPY	ETF	159.575	159.65	159.5	159.56	7956924.0
2013-04-29 15:00:00	SPY	ETF	159.561	159.58	159.18	159.33	20271430.0
2013-04-29 16:00:00	SPY	ETF	159.29	159.38	158.2111	159.38	5805930.0
2013-04-29 17:00:00	SPY	ETF	159.36	159.38	159.32	159.32	103632.0
2013-04-29 18:00:00	SPY	ETF	159.32	159.34	159.23	159.24	64361.0
2013-04-29 19:00:00	SPY	ETF	159.23	159.24	159.18	159.2	32637.0
2013-04-29 04:00:00	QQQ	ETF	69.73	69.73	69.73	69.73	100.0
2013-04-29 05:00:00	QQQ	ETF	69.68	69.68	69.68	69.68	1600.0
2013-04-29 06:00:00	QQQ	ETF	69.73	69.74	69.7	69.74	1100.0
2013-04-29 07:00:00	QQQ	ETF	69.72	69.77	69.71	69.74	156399.0
2013-04-29 08:00:00	QQQ	ETF	69.73	69.8	69.72	69.73	134010.0
2013-04-29 09:00:00	QQQ	ETF	69.72	70.06	69.72	69.98	3224011.0
2013-04-29 10:00:00	QQQ	ETF	69.99	70.34	69.95	70.24	4882855.0
2013-04-29 11:00:00	QQQ	ETF	70.25	70.28	70.19	70.28	2204930.0
2013-04-29 12:00:00	QQQ	ETF	70.284	70.48	70.26	70.37	2933844.0
2013-04-29 13:00:00	QQQ	ETF	70.36	70.45	70.335	70.39	1478806.0
2013-04-29 14:00:00	QQQ	ETF	70.39	70.45	70.37	70.395	1553549.0
2013-04-29 15:00:00	QQQ	ETF	70.3901	70.4	70.19	70.2	5222259.0
2013-04-29 16:00:00	QQQ	ETF	70.2	70.3628	69.5697	70.21	7526115.0
2013-04-29 17:00:00	QQQ	ETF	70.22	70.27	70.2	70.27	7100.0
2013-04-29 18:00:00	QQQ	ETF	70.21	70.21	70.15	70.15	30075.0
2013-04-29 19:00:00	QQQ	ETF	70.15	70.18	70.15	70.16	15075.0
2013-04-29 05:00:00	IWM	ETF	93.29	93.31	93.22	93.22	8200.0
2013-04-29 06:00:00	IWM	ETF	93.23	93.23	93.23	93.23	1000.0
2013-04-29 07:00:00	IWM	ETF	93.2	93.32	93.2	93.28	51099.0
2013-04-29 08:00:00	IWM	ETF	93.27	93.33	93.18	93.24	33406.0
2013-04-29 09:00:00	IWM	ETF	93.23	93.48	92.92	93.35	2920967.0
2013-04-29 10:00:00	IWM	ETF	93.38	93.73	93.34	93.61	4111605.0
2013-04-29 11:00:00	IWM	ETF	93.61	93.65	93.52	93.63	1534427.0
2013-04-29 12:00:00	IWM	ETF	93.63	93.78	93.61	93.65	2047554.0
2013-04-29 13:00:00	IWM	ETF	93.65	93.77	93.58	93.7317	1083059.0
2013-04-29 14:00:00	IWM	ETF	93.7354	93.76	93.67	93.69	959911.0
2013-04-29 15:00:00	IWM	ETF	93.69	93.75	93.49	93.55	4649306.0
2013-04-29 16:00:00	IWM	ETF	93.55	93.8	93.53	93.61	1415043.0
2013-04-29 17:00:00	IWM	ETF	93.61	93.61	93.61	93.61	251331.0
2013-04-29 18:00:00	IWM	ETF	93.61	93.61	93.58	93.59	6300.0
2013-04-29 19:00:00	IWM	ETF	93.56	93.59	93.53	93.53	900.0
2013-04-29 07:00:00	DIA	ETF	147.22	147.29	147.22	147.28	7900.0
2013-04-29 08:00:00	DIA	ETF	147.31	147.38	147.28	147.3	6441.0
2013-04-29 09:00:00	DIA	ETF	147.29	147.35	146.91	147.15	378834.0

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

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