PREVIEW / etf_1hour / 2014-03-20

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-03-20.parquet
  size:    214 KB
  rows:    6,766

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
2014-03-20 04:00:00	SPY	ETF	186.4	186.54	186.29	186.31	18241.0
2014-03-20 05:00:00	SPY	ETF	186.3	186.4	186.12	186.26	28047.0
2014-03-20 06:00:00	SPY	ETF	186.26	186.29	185.77	185.9	136347.0
2014-03-20 07:00:00	SPY	ETF	185.89	186.26	185.89	186.13	429743.0
2014-03-20 08:00:00	SPY	ETF	185.89	186.26	185.89	186.01	1261563.0
2014-03-20 09:00:00	SPY	ETF	186.02	186.55	185.87	186.29	14340191.0
2014-03-20 10:00:00	SPY	ETF	186.28	187.32	186.07	187.0	22295649.0
2014-03-20 11:00:00	SPY	ETF	187.0	187.2	186.73	187.18	14345912.0
2014-03-20 12:00:00	SPY	ETF	187.18	187.8101	187.0475	187.71	12781648.0
2014-03-20 13:00:00	SPY	ETF	187.76	187.87	187.56	187.77	8378970.0
2014-03-20 14:00:00	SPY	ETF	187.7701	187.89	187.66	187.67	7645934.0
2014-03-20 15:00:00	SPY	ETF	187.66	187.77	187.33	187.76	22170149.0
2014-03-20 16:00:00	SPY	ETF	187.75	187.93	186.5916	187.83	9667434.0
2014-03-20 17:00:00	SPY	ETF	187.83	187.87	187.63	187.72	1150109.0
2014-03-20 18:00:00	SPY	ETF	187.73	187.75	187.57	187.71	212435.0
2014-03-20 19:00:00	SPY	ETF	187.71	187.75	187.63	187.75	54744.0
2014-03-20 04:00:00	QQQ	ETF	89.95	89.95	89.95	89.95	500.0
2014-03-20 05:00:00	QQQ	ETF	89.85	89.91	89.82	89.91	6000.0
2014-03-20 06:00:00	QQQ	ETF	89.76	89.79	89.61	89.71	14900.0
2014-03-20 07:00:00	QQQ	ETF	89.72	89.85	89.67	89.8	11372.0
2014-03-20 08:00:00	QQQ	ETF	89.75	89.85	89.7	89.74	114708.0
2014-03-20 09:00:00	QQQ	ETF	89.72	90.01	89.58	89.83	4520352.0
2014-03-20 10:00:00	QQQ	ETF	89.82	90.36	89.71	90.16	5416943.0
2014-03-20 11:00:00	QQQ	ETF	90.16	90.23	89.97	90.22	2462692.0
2014-03-20 12:00:00	QQQ	ETF	90.21	90.48	90.15	90.48	2973188.0
2014-03-20 13:00:00	QQQ	ETF	90.48	90.56	90.34	90.41	3134664.0
2014-03-20 14:00:00	QQQ	ETF	90.41	90.49	90.34	90.34	1845985.0
2014-03-20 15:00:00	QQQ	ETF	90.34	90.34	90.11	90.29	5184714.0
2014-03-20 16:00:00	QQQ	ETF	90.29	90.44	90.002	90.39	2085394.0
2014-03-20 17:00:00	QQQ	ETF	90.4	90.41	90.29	90.37	104964.0
2014-03-20 18:00:00	QQQ	ETF	90.36	90.36	90.31	90.31	3900.0
2014-03-20 19:00:00	QQQ	ETF	90.36	90.38	90.33	90.38	13100.0
2014-03-20 05:00:00	IWM	ETF	118.73	118.73	118.73	118.73	1500.0
2014-03-20 06:00:00	IWM	ETF	118.53	118.7	118.42	118.43	1600.0
2014-03-20 07:00:00	IWM	ETF	118.43	118.71	118.41	118.63	53959.0
2014-03-20 08:00:00	IWM	ETF	118.63	118.7	118.5	118.55	281718.0
2014-03-20 09:00:00	IWM	ETF	118.55	118.94	118.16	118.48	4614027.0
2014-03-20 10:00:00	IWM	ETF	118.46	119.54	118.4	119.21	7214090.0
2014-03-20 11:00:00	IWM	ETF	119.19	119.24	118.82	119.042	3064113.0
2014-03-20 12:00:00	IWM	ETF	119.04	119.38	118.995	119.275	2330566.0
2014-03-20 13:00:00	IWM	ETF	119.27	119.4	119.1	119.25	1832375.0
2014-03-20 14:00:00	IWM	ETF	119.25	119.48	119.2	119.235	2236562.0
2014-03-20 15:00:00	IWM	ETF	119.23	119.25	118.93	119.18	5734592.0
2014-03-20 16:00:00	IWM	ETF	119.18	119.42	119.1	119.3	1318053.0
2014-03-20 17:00:00	IWM	ETF	119.2	119.2	119.16	119.16	254865.0
2014-03-20 18:00:00	IWM	ETF	119.2	119.32	119.2	119.32	2532.0
2014-03-20 19:00:00	IWM	ETF	119.19	119.19	119.19	119.19	100.0
2014-03-20 05:00:00	DIA	ETF	161.86	161.86	161.86	161.86	500.0
2014-03-20 07:00:00	DIA	ETF	161.51	161.51	161.5	161.5	3662.0
2014-03-20 08:00:00	DIA	ETF	162.0	162.0	161.65	161.7	1242.0

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

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