PREVIEW / etf_1hour / 2012-02-03

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-02-03.parquet
  size:    193 KB
  rows:    5,984

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
2012-02-03 04:00:00	SPY	ETF	132.69	132.93	132.69	132.93	8008.0
2012-02-03 05:00:00	SPY	ETF	132.96	133.04	132.96	133.04	5755.0
2012-02-03 06:00:00	SPY	ETF	132.95	133.02	132.85	132.96	46467.0
2012-02-03 07:00:00	SPY	ETF	132.92	133.04	132.72	132.77	175489.0
2012-02-03 08:00:00	SPY	ETF	132.78	134.12	132.68	133.94	8680004.0
2012-02-03 09:00:00	SPY	ETF	133.94	134.06	133.77	134.021	17752421.0
2012-02-03 10:00:00	SPY	ETF	134.025	134.41	134.02	134.26	25513343.0
2012-02-03 11:00:00	SPY	ETF	134.25	134.42	134.14	134.265	14728912.0
2012-02-03 12:00:00	SPY	ETF	134.265	134.56	134.21	134.45	16158401.0
2012-02-03 13:00:00	SPY	ETF	134.45	134.48	134.31	134.35	8804107.0
2012-02-03 14:00:00	SPY	ETF	134.35	134.51	134.35	134.5	14055684.0
2012-02-03 15:00:00	SPY	ETF	134.5	134.62	134.29	134.55	30927758.0
2012-02-03 16:00:00	SPY	ETF	134.56	134.6	134.32	134.54	11957900.0
2012-02-03 17:00:00	SPY	ETF	134.51	134.57	134.34	134.38	1375399.0
2012-02-03 18:00:00	SPY	ETF	134.37	134.48	134.37	134.48	55668.0
2012-02-03 19:00:00	SPY	ETF	134.47	134.52	134.46	134.49	25617.0
2012-02-03 04:00:00	QQQ	ETF	61.34	61.34	61.34	61.34	200.0
2012-02-03 06:00:00	QQQ	ETF	61.34	61.37	61.33	61.33	6000.0
2012-02-03 07:00:00	QQQ	ETF	61.39	61.43	61.34	61.34	5650.0
2012-02-03 08:00:00	QQQ	ETF	61.34	61.86	61.2	61.76	1393688.0
2012-02-03 09:00:00	QQQ	ETF	61.76	61.9	61.6799	61.87	6431524.0
2012-02-03 10:00:00	QQQ	ETF	61.88	62.02	61.819	61.98	7046246.0
2012-02-03 11:00:00	QQQ	ETF	61.98	62.05	61.91	61.96	4032792.0
2012-02-03 12:00:00	QQQ	ETF	61.95	62.12	61.93	62.0718	3705616.0
2012-02-03 13:00:00	QQQ	ETF	62.08	62.1	62.0	62.0	1739215.0
2012-02-03 14:00:00	QQQ	ETF	62.005	62.08	62.0	62.06	2709571.0
2012-02-03 15:00:00	QQQ	ETF	62.06	62.07	61.95	62.04	7338364.0
2012-02-03 16:00:00	QQQ	ETF	62.03	62.05	61.93	62.0	911952.0
2012-02-03 17:00:00	QQQ	ETF	62.02	62.03	61.98	61.98	10481.0
2012-02-03 18:00:00	QQQ	ETF	61.98	62.0	61.95	62.0	9173.0
2012-02-03 19:00:00	QQQ	ETF	61.99	62.07	61.94	62.01	20291.0
2012-02-03 07:00:00	IWM	ETF	81.35	81.4	81.25	81.25	40997.0
2012-02-03 08:00:00	IWM	ETF	81.26	82.5	81.24	82.46	3232083.0
2012-02-03 09:00:00	IWM	ETF	82.46	82.52	82.242	82.41	9665997.0
2012-02-03 10:00:00	IWM	ETF	82.41	82.84	82.41	82.78	9438940.0
2012-02-03 11:00:00	IWM	ETF	82.77	82.92	82.6859	82.78	5592594.0
2012-02-03 12:00:00	IWM	ETF	82.7872	83.14	82.74	83.07	4351248.0
2012-02-03 13:00:00	IWM	ETF	83.07	83.07	82.86	82.88	2984407.0
2012-02-03 14:00:00	IWM	ETF	82.88	83.2229	82.88	83.135	9446386.0
2012-02-03 15:00:00	IWM	ETF	83.13	83.14	82.85	82.99	10723141.0
2012-02-03 16:00:00	IWM	ETF	82.98	83.03	82.75	82.86	3029136.0
2012-02-03 18:00:00	IWM	ETF	82.9	82.9	82.9	82.9	2500.0
2012-02-03 19:00:00	IWM	ETF	83.0	83.0	82.96	82.96	490.0
2012-02-03 07:00:00	DIA	ETF	127.29	127.29	127.03	127.03	431.0
2012-02-03 08:00:00	DIA	ETF	126.95	128.17	126.5	127.95	159991.0
2012-02-03 09:00:00	DIA	ETF	127.99	128.11	127.83	128.06	772614.0
2012-02-03 10:00:00	DIA	ETF	128.1	128.49	128.06	128.2	2738721.0
2012-02-03 11:00:00	DIA	ETF	128.21	128.28	128.04	128.14	532459.0
2012-02-03 12:00:00	DIA	ETF	128.13	128.4	128.1	128.3	492293.0
2012-02-03 13:00:00	DIA	ETF	128.31	128.3469	128.15	128.19	291721.0

> showing 50 of 5,984 rows — these rows as CSV

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