PREVIEW / etf_1hour / 2013-12-09

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-12-09.parquet
  size:    208 KB
  rows:    6,583

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-12-09 04:00:00	SPY	ETF	181.26	181.26	181.14	181.19	59642.0
2013-12-09 05:00:00	SPY	ETF	181.17	181.17	181.05	181.11	17298.0
2013-12-09 06:00:00	SPY	ETF	181.14	181.17	181.02	181.05	19495.0
2013-12-09 07:00:00	SPY	ETF	181.07	181.24	181.07	181.22	124849.0
2013-12-09 08:00:00	SPY	ETF	181.22	181.39	181.12	181.29	393642.0
2013-12-09 09:00:00	SPY	ETF	181.29	181.65	181.23	181.63	11639125.0
2013-12-09 10:00:00	SPY	ETF	181.621	181.67	181.16	181.4	11962530.0
2013-12-09 11:00:00	SPY	ETF	181.4	181.6699	181.37	181.489	9189952.0
2013-12-09 12:00:00	SPY	ETF	181.48	181.57	181.35	181.45	4642195.0
2013-12-09 13:00:00	SPY	ETF	181.46	181.65	181.39	181.4252	4856822.0
2013-12-09 14:00:00	SPY	ETF	181.4275	181.49	181.25	181.34	5391270.0
2013-12-09 15:00:00	SPY	ETF	181.35	181.445	181.18	181.38	13441053.0
2013-12-09 16:00:00	SPY	ETF	181.38	181.45	180.9977	181.42	7136026.0
2013-12-09 17:00:00	SPY	ETF	181.4	181.46	181.36	181.43	95078.0
2013-12-09 18:00:00	SPY	ETF	181.45	181.55	181.45	181.5	129546.0
2013-12-09 19:00:00	SPY	ETF	181.47	181.58	181.46	181.55	86760.0
2013-12-09 04:00:00	QQQ	ETF	86.16	86.19	86.14	86.14	20000.0
2013-12-09 05:00:00	QQQ	ETF	86.17	86.17	86.11	86.11	4000.0
2013-12-09 06:00:00	QQQ	ETF	86.14	86.15	86.11	86.14	5020.0
2013-12-09 07:00:00	QQQ	ETF	86.14	86.23	86.14	86.23	69304.0
2013-12-09 08:00:00	QQQ	ETF	86.22	86.29	86.22	86.26	54357.0
2013-12-09 09:00:00	QQQ	ETF	86.27	86.48	86.2	86.46	4278538.0
2013-12-09 10:00:00	QQQ	ETF	86.46	86.49	86.27	86.4399	3570799.0
2013-12-09 11:00:00	QQQ	ETF	86.44	86.53	86.385	86.39	1914963.0
2013-12-09 12:00:00	QQQ	ETF	86.39	86.4301	86.31	86.36	1486065.0
2013-12-09 13:00:00	QQQ	ETF	86.3682	86.45	86.35	86.41	1286896.0
2013-12-09 14:00:00	QQQ	ETF	86.4	86.415	86.29	86.359	2240532.0
2013-12-09 15:00:00	QQQ	ETF	86.36	86.385	86.25	86.34	4971902.0
2013-12-09 16:00:00	QQQ	ETF	86.33	86.42	86.29	86.39	1479366.0
2013-12-09 17:00:00	QQQ	ETF	86.39	86.39	86.34	86.34	1397.0
2013-12-09 18:00:00	QQQ	ETF	86.42	86.45	86.41	86.41	7200.0
2013-12-09 19:00:00	QQQ	ETF	86.42	86.46	86.41	86.46	2525.0
2013-12-09 06:00:00	IWM	ETF	112.33	112.33	112.33	112.33	200.0
2013-12-09 07:00:00	IWM	ETF	112.39	112.51	112.39	112.5	2950.0
2013-12-09 08:00:00	IWM	ETF	112.49	112.61	112.46	112.55	172920.0
2013-12-09 09:00:00	IWM	ETF	112.57	112.87	112.56	112.85	2508702.0
2013-12-09 10:00:00	IWM	ETF	112.86	112.89	111.89	112.21	6339324.0
2013-12-09 11:00:00	IWM	ETF	112.215	112.415	112.18	112.22	2019809.0
2013-12-09 12:00:00	IWM	ETF	112.23	112.43	112.12	112.37	1535560.0
2013-12-09 13:00:00	IWM	ETF	112.36	112.415	112.17	112.245	1701939.0
2013-12-09 14:00:00	IWM	ETF	112.245	112.3	112.02	112.18	1954368.0
2013-12-09 15:00:00	IWM	ETF	112.18	112.43	112.02	112.41	4450895.0
2013-12-09 16:00:00	IWM	ETF	112.42	112.57	112.2654	112.57	7952674.0
2013-12-09 17:00:00	IWM	ETF	112.51	112.61	112.5	112.55	7211.0
2013-12-09 18:00:00	IWM	ETF	112.52	112.55	112.5	112.55	9200.0
2013-12-09 19:00:00	IWM	ETF	112.54	112.55	112.54	112.55	884.0
2013-12-09 07:00:00	DIA	ETF	160.25	160.25	160.25	160.25	100.0
2013-12-09 08:00:00	DIA	ETF	160.24	160.24	160.19	160.19	9800.0
2013-12-09 09:00:00	DIA	ETF	160.11	160.47	160.11	160.44	814817.0
2013-12-09 10:00:00	DIA	ETF	160.45	160.53	160.11	160.25	813373.0

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

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