PREVIEW / etf_1hour / 2013-12-10

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-12-10.parquet
  size:    211 KB
  rows:    6,674

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-10 04:00:00	SPY	ETF	181.56	181.63	181.5	181.63	2874.0
2013-12-10 05:00:00	SPY	ETF	181.61	181.62	181.53	181.55	8308.0
2013-12-10 06:00:00	SPY	ETF	181.57	181.63	181.57	181.62	1072.0
2013-12-10 07:00:00	SPY	ETF	181.62	181.62	181.27	181.29	225206.0
2013-12-10 08:00:00	SPY	ETF	181.3	181.34	180.8	180.88	821678.0
2013-12-10 09:00:00	SPY	ETF	180.87	181.2	180.82	181.1	9525230.0
2013-12-10 10:00:00	SPY	ETF	181.11	181.36	181.05	181.18	8607890.0
2013-12-10 11:00:00	SPY	ETF	181.18	181.2	180.79	180.865	8270308.0
2013-12-10 12:00:00	SPY	ETF	180.87	181.07	180.68	181.005	7865848.0
2013-12-10 13:00:00	SPY	ETF	181.0	181.09	180.635	180.74	6274981.0
2013-12-10 14:00:00	SPY	ETF	180.74	180.96	180.71	180.93	7183376.0
2013-12-10 15:00:00	SPY	ETF	180.93	181.11	180.73	180.77	15653562.0
2013-12-10 16:00:00	SPY	ETF	180.78	180.91	180.7413	180.89	8952670.0
2013-12-10 17:00:00	SPY	ETF	180.88	180.9	180.87	180.9	386136.0
2013-12-10 18:00:00	SPY	ETF	180.9	181.17	180.75	181.07	3310772.0
2013-12-10 19:00:00	SPY	ETF	181.07	181.35	181.07	181.29	3217335.0
2013-12-10 04:00:00	QQQ	ETF	86.46	86.51	86.46	86.51	6800.0
2013-12-10 05:00:00	QQQ	ETF	86.48	86.48	86.48	86.48	800.0
2013-12-10 06:00:00	QQQ	ETF	86.48	86.48	86.48	86.48	300.0
2013-12-10 07:00:00	QQQ	ETF	86.48	86.48	86.36	86.36	20300.0
2013-12-10 08:00:00	QQQ	ETF	86.33	86.33	86.12	86.15	63672.0
2013-12-10 09:00:00	QQQ	ETF	86.15	86.3399	86.12	86.2	3782169.0
2013-12-10 10:00:00	QQQ	ETF	86.21	86.45	86.19	86.35	4221145.0
2013-12-10 11:00:00	QQQ	ETF	86.34	86.43	86.26	86.3	3704850.0
2013-12-10 12:00:00	QQQ	ETF	86.29	86.3799	86.18	86.3201	2790482.0
2013-12-10 13:00:00	QQQ	ETF	86.32	86.37	86.18	86.22	1679320.0
2013-12-10 14:00:00	QQQ	ETF	86.22	86.36	86.2	86.33	2769380.0
2013-12-10 15:00:00	QQQ	ETF	86.33	86.44	86.27	86.29	4362889.0
2013-12-10 16:00:00	QQQ	ETF	86.29	86.3999	86.256	86.33	949071.0
2013-12-10 17:00:00	QQQ	ETF	86.33	86.34	86.32	86.33	84580.0
2013-12-10 18:00:00	QQQ	ETF	86.33	86.41	86.33	86.34	611590.0
2013-12-10 19:00:00	QQQ	ETF	86.34	86.42	86.34	86.41	719864.0
2013-12-10 07:00:00	IWM	ETF	112.56	112.56	112.46	112.46	25100.0
2013-12-10 08:00:00	IWM	ETF	112.38	112.42	112.05	112.08	148910.0
2013-12-10 09:00:00	IWM	ETF	112.08	112.32	111.94	112.03	3385869.0
2013-12-10 10:00:00	IWM	ETF	112.04	112.58	112.02	112.28	3888336.0
2013-12-10 11:00:00	IWM	ETF	112.27	112.29	111.445	111.59	5754221.0
2013-12-10 12:00:00	IWM	ETF	111.59	111.7	111.311	111.615	2501340.0
2013-12-10 13:00:00	IWM	ETF	111.61	111.65	111.24	111.29	2810282.0
2013-12-10 14:00:00	IWM	ETF	111.28	111.5	111.24	111.415	3372731.0
2013-12-10 15:00:00	IWM	ETF	111.42	111.68	111.3601	111.4	6251882.0
2013-12-10 16:00:00	IWM	ETF	111.4	111.7899	111.3677	111.5	1081927.0
2013-12-10 17:00:00	IWM	ETF	111.54	111.55	111.48	111.48	5000.0
2013-12-10 18:00:00	IWM	ETF	111.54	111.66	111.53	111.64	4597.0
2013-12-10 19:00:00	IWM	ETF	111.69	111.78	111.69	111.77	2170.0
2013-12-10 07:00:00	DIA	ETF	160.26	160.26	160.15	160.15	1300.0
2013-12-10 08:00:00	DIA	ETF	160.2	160.2	159.65	159.65	18574.0
2013-12-10 09:00:00	DIA	ETF	159.68	160.09	159.66	159.98	559353.0
2013-12-10 10:00:00	DIA	ETF	159.98	160.19	159.93	160.06	614895.0
2013-12-10 11:00:00	DIA	ETF	160.05	160.05	159.73	159.79	409718.0

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

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