PREVIEW / etf_1hour / 2013-11-11

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-11-11.parquet
  size:    201 KB
  rows:    6,440

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-11 04:00:00	SPY	ETF	176.94	177.11	176.91	177.11	10185.0
2013-11-11 05:00:00	SPY	ETF	177.09	177.35	177.09	177.29	64010.0
2013-11-11 06:00:00	SPY	ETF	177.26	177.26	177.14	177.18	52098.0
2013-11-11 07:00:00	SPY	ETF	177.13	177.38	177.12	177.33	249307.0
2013-11-11 08:00:00	SPY	ETF	177.32	177.38	177.13	177.2	465485.0
2013-11-11 09:00:00	SPY	ETF	177.19	177.53	176.91	177.42	10977328.0
2013-11-11 10:00:00	SPY	ETF	177.42	177.5	177.12	177.41	11185268.0
2013-11-11 11:00:00	SPY	ETF	177.41	177.43	177.12	177.31	9294842.0
2013-11-11 12:00:00	SPY	ETF	177.31	177.31	177.16	177.27	5208455.0
2013-11-11 13:00:00	SPY	ETF	177.27	177.38	177.22	177.29	3931004.0
2013-11-11 14:00:00	SPY	ETF	177.295	177.34	177.23	177.3	4160441.0
2013-11-11 15:00:00	SPY	ETF	177.3	177.36	177.24	177.3	9055980.0
2013-11-11 16:00:00	SPY	ETF	177.29	177.3431	177.2141	177.27	6729184.0
2013-11-11 17:00:00	SPY	ETF	177.28	177.3	177.28	177.28	72365.0
2013-11-11 18:00:00	SPY	ETF	177.28	177.31	177.24	177.28	54083.0
2013-11-11 19:00:00	SPY	ETF	177.27	177.38	177.26	177.36	259939.0
2013-11-11 04:00:00	QQQ	ETF	82.37	82.43	82.37	82.42	7400.0
2013-11-11 05:00:00	QQQ	ETF	82.44	82.53	82.44	82.48	9000.0
2013-11-11 06:00:00	QQQ	ETF	82.5	82.5	82.45	82.47	12900.0
2013-11-11 07:00:00	QQQ	ETF	82.46	82.56	82.45	82.56	31707.0
2013-11-11 08:00:00	QQQ	ETF	82.55	82.56	82.42	82.44	337414.0
2013-11-11 09:00:00	QQQ	ETF	82.44	82.64	82.22	82.575	3599240.0
2013-11-11 10:00:00	QQQ	ETF	82.58	82.6	82.25	82.39	7366649.0
2013-11-11 11:00:00	QQQ	ETF	82.39	82.47	82.14	82.45	4619138.0
2013-11-11 12:00:00	QQQ	ETF	82.45	82.5	82.37	82.48	1153564.0
2013-11-11 13:00:00	QQQ	ETF	82.4899	82.55	82.45	82.5	841728.0
2013-11-11 14:00:00	QQQ	ETF	82.49	82.53	82.45	82.49	1295133.0
2013-11-11 15:00:00	QQQ	ETF	82.48	82.545	82.4	82.43	3499991.0
2013-11-11 16:00:00	QQQ	ETF	82.425	82.5577	82.36	82.38	1736797.0
2013-11-11 17:00:00	QQQ	ETF	82.41	82.42	82.41	82.42	5000.0
2013-11-11 18:00:00	QQQ	ETF	82.4	82.4	82.36	82.38	5975.0
2013-11-11 19:00:00	QQQ	ETF	82.39	82.41	82.38	82.38	7280.0
2013-11-11 04:00:00	IWM	ETF	109.23	109.49	108.53	108.53	1400.0
2013-11-11 05:00:00	IWM	ETF	109.49	109.49	109.49	109.49	700.0
2013-11-11 06:00:00	IWM	ETF	109.49	109.49	109.49	109.49	100.0
2013-11-11 07:00:00	IWM	ETF	109.27	109.35	109.26	109.35	73900.0
2013-11-11 08:00:00	IWM	ETF	109.34	109.34	109.15	109.16	151160.0
2013-11-11 09:00:00	IWM	ETF	109.12	109.49	108.64	109.38	4145639.0
2013-11-11 10:00:00	IWM	ETF	109.38	109.39	108.88	109.342	4333673.0
2013-11-11 11:00:00	IWM	ETF	109.35	109.55	109.06	109.49	2332746.0
2013-11-11 12:00:00	IWM	ETF	109.48	109.48	109.31	109.402	994132.0
2013-11-11 13:00:00	IWM	ETF	109.405	109.53	109.39	109.48	877542.0
2013-11-11 14:00:00	IWM	ETF	109.465	109.52	109.41	109.48	1270165.0
2013-11-11 15:00:00	IWM	ETF	109.475	109.595	109.36	109.36	3942979.0
2013-11-11 16:00:00	IWM	ETF	109.37	109.4402	109.2085	109.36	733294.0
2013-11-11 17:00:00	IWM	ETF	109.33	109.4	109.33	109.4	32100.0
2013-11-11 19:00:00	IWM	ETF	109.33	109.33	109.33	109.33	400.0
2013-11-11 06:00:00	DIA	ETF	157.4	157.4	157.4	157.4	100.0
2013-11-11 07:00:00	DIA	ETF	157.4	157.55	157.4	157.55	3100.0
2013-11-11 08:00:00	DIA	ETF	157.47	157.47	157.34	157.35	3975.0

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

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