PREVIEW / etf_1hour / 2011-09-12

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-09-12.parquet
  size:    186 KB
  rows:    5,788

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
2011-09-12 04:00:00	SPY	ETF	115.92	115.92	114.02	114.68	35184.0
2011-09-12 05:00:00	SPY	ETF	114.59	114.78	114.32	114.65	60800.0
2011-09-12 06:00:00	SPY	ETF	114.65	114.65	113.92	113.92	65766.0
2011-09-12 07:00:00	SPY	ETF	113.95	114.53	113.81	114.18	1258058.0
2011-09-12 08:00:00	SPY	ETF	114.25	114.6	113.52	114.55	5341351.0
2011-09-12 09:00:00	SPY	ETF	114.56	116.07	114.32	115.85	40172544.0
2011-09-12 10:00:00	SPY	ETF	115.85	116.25	114.61	114.658	47750941.0
2011-09-12 11:00:00	SPY	ETF	114.65	115.59	114.61	115.13	27066824.0
2011-09-12 12:00:00	SPY	ETF	115.12	115.32	114.63	114.96	18932070.0
2011-09-12 13:00:00	SPY	ETF	114.96	115.2	114.24	114.66	25983295.0
2011-09-12 14:00:00	SPY	ETF	114.66	115.52	114.05	114.735	52511968.0
2011-09-12 15:00:00	SPY	ETF	114.735	116.76	114.46	116.7	65836627.0
2011-09-12 16:00:00	SPY	ETF	116.71	117.16	114.4	116.96	15655050.0
2011-09-12 17:00:00	SPY	ETF	116.95	117.39	116.89	117.21	549515.0
2011-09-12 18:00:00	SPY	ETF	117.25	117.9	116.66	117.36	1442864.0
2011-09-12 19:00:00	SPY	ETF	117.35	117.44	117.11	117.12	252614.0
2011-09-12 04:00:00	QQQ	ETF	52.65	52.79	52.4	52.7	28938.0
2011-09-12 06:00:00	QQQ	ETF	52.61	52.61	52.61	52.61	400.0
2011-09-12 07:00:00	QQQ	ETF	52.42	52.6	52.39	52.39	132728.0
2011-09-12 08:00:00	QQQ	ETF	52.47	52.58	52.18	52.57	601322.0
2011-09-12 09:00:00	QQQ	ETF	52.58	53.47	52.53	53.36	8049783.0
2011-09-12 10:00:00	QQQ	ETF	53.36	53.6	52.87	52.89	10151634.0
2011-09-12 11:00:00	QQQ	ETF	52.891	53.42	52.8725	53.18	5511044.0
2011-09-12 12:00:00	QQQ	ETF	53.175	53.28	52.88	53.005	7245328.0
2011-09-12 13:00:00	QQQ	ETF	53.01	53.13	52.655	52.84	5876642.0
2011-09-12 14:00:00	QQQ	ETF	52.83	53.35	52.57	52.99	9189052.0
2011-09-12 15:00:00	QQQ	ETF	52.985	53.88	52.885	53.88	14913949.0
2011-09-12 16:00:00	QQQ	ETF	53.89	54.1	53.86	54.01	1774010.0
2011-09-12 17:00:00	QQQ	ETF	54.0	54.15	54.0	54.1	86202.0
2011-09-12 18:00:00	QQQ	ETF	54.1	54.28	53.86	54.15	67312.0
2011-09-12 19:00:00	QQQ	ETF	54.16	54.21	54.09	54.09	103073.0
2011-09-12 04:00:00	IWM	ETF	66.28	66.28	66.28	66.28	642.0
2011-09-12 05:00:00	IWM	ETF	66.42	66.5	66.42	66.5	642.0
2011-09-12 06:00:00	IWM	ETF	66.13	66.13	66.13	66.13	200.0
2011-09-12 07:00:00	IWM	ETF	66.08	66.45	66.08	66.14	117050.0
2011-09-12 08:00:00	IWM	ETF	66.31	66.59	65.82	66.57	683298.0
2011-09-12 09:00:00	IWM	ETF	66.58	68.1	66.3	67.89	16073835.0
2011-09-12 10:00:00	IWM	ETF	67.9	68.25	66.74	66.76	15204347.0
2011-09-12 11:00:00	IWM	ETF	66.76	67.73	66.74	67.2	7795550.0
2011-09-12 12:00:00	IWM	ETF	67.2	67.42	66.87	67.17	5868456.0
2011-09-12 13:00:00	IWM	ETF	67.16	67.4	66.51	66.91	8427611.0
2011-09-12 14:00:00	IWM	ETF	66.91	67.56	66.4	66.92	13091913.0
2011-09-12 15:00:00	IWM	ETF	66.93	68.12	66.61	68.11	19456682.0
2011-09-12 16:00:00	IWM	ETF	68.11	68.34	67.7765	68.22	7544939.0
2011-09-12 17:00:00	IWM	ETF	68.21	68.53	68.17	68.48	244718.0
2011-09-12 18:00:00	IWM	ETF	68.44	68.51	68.39	68.45	6910.0
2011-09-12 19:00:00	IWM	ETF	68.5	68.53	68.37	68.4	11555.0
2011-09-12 04:00:00	DIA	ETF	108.65	108.65	108.55	108.55	1500.0
2011-09-12 05:00:00	DIA	ETF	108.5	108.5	108.35	108.35	3895.0
2011-09-12 06:00:00	DIA	ETF	108.3	108.3	108.05	108.05	8000.0

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

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