PREVIEW / etf_1hour / 2012-02-01

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-02-01.parquet
  size:    189 KB
  rows:    5,866

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-01 04:00:00	SPY	ETF	131.75	132.25	131.75	132.25	84100.0
2012-02-01 05:00:00	SPY	ETF	132.3	132.3	132.04	132.21	10699.0
2012-02-01 06:00:00	SPY	ETF	132.21	132.23	132.09	132.13	55150.0
2012-02-01 07:00:00	SPY	ETF	132.09	132.45	132.0	132.21	406079.0
2012-02-01 08:00:00	SPY	ETF	132.2	132.32	131.21	132.1	1373570.0
2012-02-01 09:00:00	SPY	ETF	132.11	132.51	131.21	132.28	16455289.0
2012-02-01 10:00:00	SPY	ETF	132.28	132.79	132.14	132.72	24573096.0
2012-02-01 11:00:00	SPY	ETF	132.72	132.84	132.54	132.7	17536319.0
2012-02-01 12:00:00	SPY	ETF	132.695	133.0	132.69	132.8999	13645668.0
2012-02-01 13:00:00	SPY	ETF	132.8985	133.14	132.8	132.845	20061583.0
2012-02-01 14:00:00	SPY	ETF	132.85	132.92	132.71	132.83	14462395.0
2012-02-01 15:00:00	SPY	ETF	132.84	133.0	132.33	132.45	37628858.0
2012-02-01 16:00:00	SPY	ETF	132.45	133.05	131.245	132.52	14602484.0
2012-02-01 17:00:00	SPY	ETF	132.53	132.6	132.4	132.58	1295721.0
2012-02-01 18:00:00	SPY	ETF	132.58	132.64	132.54	132.55	62519.0
2012-02-01 19:00:00	SPY	ETF	132.55	132.91	132.55	132.78	415388.0
2012-02-01 04:00:00	QQQ	ETF	60.74	60.82	60.74	60.82	2000.0
2012-02-01 05:00:00	QQQ	ETF	60.75	60.85	60.75	60.81	4958.0
2012-02-01 06:00:00	QQQ	ETF	60.83	60.9	60.83	60.9	9000.0
2012-02-01 07:00:00	QQQ	ETF	60.84	60.99	60.78	60.87	466123.0
2012-02-01 08:00:00	QQQ	ETF	60.85	60.86	60.75	60.78	846168.0
2012-02-01 09:00:00	QQQ	ETF	60.78	60.95	60.53	60.7799	6749928.0
2012-02-01 10:00:00	QQQ	ETF	60.77	60.97	60.66	60.9599	7372729.0
2012-02-01 11:00:00	QQQ	ETF	60.96	61.09	60.85	61.04	6313488.0
2012-02-01 12:00:00	QQQ	ETF	61.03	61.15	61.03	61.11	3364129.0
2012-02-01 13:00:00	QQQ	ETF	61.105	61.24	61.1	61.12	4500004.0
2012-02-01 14:00:00	QQQ	ETF	61.13	61.17	61.08	61.11	3200882.0
2012-02-01 15:00:00	QQQ	ETF	61.12	61.17	60.95	61.01	7976237.0
2012-02-01 16:00:00	QQQ	ETF	61.01	61.16	60.5125	61.12	1938568.0
2012-02-01 17:00:00	QQQ	ETF	61.12	61.14	61.11	61.12	13705.0
2012-02-01 18:00:00	QQQ	ETF	61.16	61.16	61.12	61.14	10712.0
2012-02-01 19:00:00	QQQ	ETF	61.16	61.26	61.16	61.24	35703.0
2012-02-01 04:00:00	IWM	ETF	79.65	79.75	79.65	79.75	300.0
2012-02-01 06:00:00	IWM	ETF	79.78	79.79	79.78	79.79	10000.0
2012-02-01 07:00:00	IWM	ETF	79.65	79.96	79.62	79.81	113724.0
2012-02-01 08:00:00	IWM	ETF	79.81	79.81	79.07	79.63	418753.0
2012-02-01 09:00:00	IWM	ETF	79.62	79.84	79.07	79.6338	4004021.0
2012-02-01 10:00:00	IWM	ETF	79.64	80.35	79.47	80.31	11884978.0
2012-02-01 11:00:00	IWM	ETF	80.31	80.55	80.26	80.47	8374221.0
2012-02-01 12:00:00	IWM	ETF	80.47	80.725	80.46	80.7	6073515.0
2012-02-01 13:00:00	IWM	ETF	80.69	80.9	80.4991	80.69	5958333.0
2012-02-01 14:00:00	IWM	ETF	80.7	80.78	80.59	80.649	4637895.0
2012-02-01 15:00:00	IWM	ETF	80.65	80.82	80.48	80.75	11993340.0
2012-02-01 16:00:00	IWM	ETF	80.75	80.87	80.42	80.87	8013220.0
2012-02-01 17:00:00	IWM	ETF	80.85	80.97	80.82	80.97	106009.0
2012-02-01 18:00:00	IWM	ETF	80.89	81.0	80.89	80.9	5167.0
2012-02-01 19:00:00	IWM	ETF	80.95	81.05	80.95	80.99	20273.0
2012-02-01 07:00:00	DIA	ETF	126.83	127.05	126.83	127.0	26000.0
2012-02-01 08:00:00	DIA	ETF	126.94	126.94	125.3	126.85	31023.0
2012-02-01 09:00:00	DIA	ETF	126.86	127.33	126.86	127.0562	564933.0

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

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