PREVIEW / etf_1hour / 2014-03-10

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-03-10.parquet
  size:    211 KB
  rows:    6,679

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-10 04:00:00	SPY	ETF	187.92	188.17	187.61	188.17	17295.0
2014-03-10 05:00:00	SPY	ETF	188.17	188.36	188.17	188.2	11162.0
2014-03-10 06:00:00	SPY	ETF	188.16	188.2	188.07	188.13	120823.0
2014-03-10 07:00:00	SPY	ETF	188.12	188.24	187.97	188.08	316301.0
2014-03-10 08:00:00	SPY	ETF	188.12	188.19	187.72	187.88	649894.0
2014-03-10 09:00:00	SPY	ETF	187.88	188.22	187.7	188.11	10316524.0
2014-03-10 10:00:00	SPY	ETF	188.11	188.1399	187.08	187.25	14996104.0
2014-03-10 11:00:00	SPY	ETF	187.25	187.87	187.13	187.5649	10186228.0
2014-03-10 12:00:00	SPY	ETF	187.56	188.0	187.48	187.96	6906221.0
2014-03-10 13:00:00	SPY	ETF	187.96	187.99	187.55	187.615	6072934.0
2014-03-10 14:00:00	SPY	ETF	187.61	187.95	187.52	187.905	6055146.0
2014-03-10 15:00:00	SPY	ETF	187.905	188.23	187.68	188.18	13802527.0
2014-03-10 16:00:00	SPY	ETF	188.18	188.34	187.65	188.25	3561537.0
2014-03-10 17:00:00	SPY	ETF	188.25	188.28	188.11	188.11	339589.0
2014-03-10 18:00:00	SPY	ETF	188.11	188.15	188.07	188.14	56716.0
2014-03-10 19:00:00	SPY	ETF	188.11	188.14	188.09	188.09	47821.0
2014-03-10 05:00:00	QQQ	ETF	90.6	90.6	90.6	90.6	100.0
2014-03-10 06:00:00	QQQ	ETF	90.53	90.55	90.52	90.53	2500.0
2014-03-10 07:00:00	QQQ	ETF	90.55	90.58	90.5	90.53	34500.0
2014-03-10 08:00:00	QQQ	ETF	90.53	90.53	90.38	90.46	130161.0
2014-03-10 09:00:00	QQQ	ETF	90.46	90.651	90.33	90.65	4060820.0
2014-03-10 10:00:00	QQQ	ETF	90.64	90.655	90.03	90.14	3963879.0
2014-03-10 11:00:00	QQQ	ETF	90.12	90.51	90.07	90.35	2039283.0
2014-03-10 12:00:00	QQQ	ETF	90.345	90.54	90.315	90.52	1456000.0
2014-03-10 13:00:00	QQQ	ETF	90.529	90.54	90.26	90.31	1111067.0
2014-03-10 14:00:00	QQQ	ETF	90.3	90.501	90.25	90.4803	1048679.0
2014-03-10 15:00:00	QQQ	ETF	90.48	90.61	90.33	90.6	2848209.0
2014-03-10 16:00:00	QQQ	ETF	90.6	90.7	90.3418	90.66	938040.0
2014-03-10 17:00:00	QQQ	ETF	90.65	90.65	90.62	90.62	12100.0
2014-03-10 18:00:00	QQQ	ETF	90.62	90.62	90.58	90.58	3852.0
2014-03-10 19:00:00	QQQ	ETF	90.61	90.61	90.58	90.58	2520.0
2014-03-10 06:00:00	IWM	ETF	119.44	119.44	119.44	119.44	100.0
2014-03-10 07:00:00	IWM	ETF	119.4	119.5	119.28	119.39	43700.0
2014-03-10 08:00:00	IWM	ETF	119.42	119.42	119.17	119.3	162198.0
2014-03-10 09:00:00	IWM	ETF	119.3	119.58	119.12	119.43	4471625.0
2014-03-10 10:00:00	IWM	ETF	119.42	119.45	118.5	118.61	6868804.0
2014-03-10 11:00:00	IWM	ETF	118.6	119.29	118.49	118.93	3907916.0
2014-03-10 12:00:00	IWM	ETF	118.92	119.17	118.84	119.16	2099347.0
2014-03-10 13:00:00	IWM	ETF	119.16	119.24	118.72	118.79	2739076.0
2014-03-10 14:00:00	IWM	ETF	118.795	119.075	118.71	119.04	1730910.0
2014-03-10 15:00:00	IWM	ETF	119.035	119.33	118.7	119.29	5611457.0
2014-03-10 16:00:00	IWM	ETF	119.29	119.47	119.25	119.47	1272354.0
2014-03-10 17:00:00	IWM	ETF	119.43	119.43	119.14	119.16	1991318.0
2014-03-10 19:00:00	IWM	ETF	119.28	119.28	119.18	119.18	600.0
2014-03-10 07:00:00	DIA	ETF	164.29	164.3	164.29	164.3	2000.0
2014-03-10 08:00:00	DIA	ETF	164.06	164.24	163.95	163.95	7650.0
2014-03-10 09:00:00	DIA	ETF	164.09	164.16	163.8	163.94	565294.0
2014-03-10 10:00:00	DIA	ETF	163.94	163.96	163.21	163.28	1195878.0
2014-03-10 11:00:00	DIA	ETF	163.26	163.82	163.18	163.57	655135.0
2014-03-10 12:00:00	DIA	ETF	163.56	163.85	163.499	163.81	320876.0

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

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