PREVIEW / etf_1hour / 2012-11-20

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-11-20.parquet
  size:    185 KB
  rows:    5,720

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-11-20 04:00:00	SPY	ETF	138.7	138.86	138.65	138.76	16200.0
2012-11-20 05:00:00	SPY	ETF	138.76	139.06	138.76	139.06	51000.0
2012-11-20 06:00:00	SPY	ETF	139.05	139.05	138.91	138.96	29170.0
2012-11-20 07:00:00	SPY	ETF	138.91	139.09	138.63	138.74	492983.0
2012-11-20 08:00:00	SPY	ETF	138.74	139.15	138.72	138.97	1380833.0
2012-11-20 09:00:00	SPY	ETF	138.98	139.01	138.5	138.88	13323443.0
2012-11-20 10:00:00	SPY	ETF	138.88	139.26	138.72	138.95	14908829.0
2012-11-20 11:00:00	SPY	ETF	138.94	139.39	138.81	139.335	12439594.0
2012-11-20 12:00:00	SPY	ETF	139.335	139.42	138.98	139.125	11567677.0
2012-11-20 13:00:00	SPY	ETF	139.13	139.15	138.08	138.6201	18872237.0
2012-11-20 14:00:00	SPY	ETF	138.62	138.9	138.52	138.82	9895718.0
2012-11-20 15:00:00	SPY	ETF	138.817	139.25	138.79	139.23	20217611.0
2012-11-20 16:00:00	SPY	ETF	139.23	139.36	138.741	139.26	9576904.0
2012-11-20 17:00:00	SPY	ETF	139.27	139.35	139.26	139.32	1137968.0
2012-11-20 18:00:00	SPY	ETF	139.31	139.32	139.22	139.23	165126.0
2012-11-20 19:00:00	SPY	ETF	139.23	139.5	139.19	139.4	250469.0
2012-11-20 04:00:00	QQQ	ETF	63.57	63.58	63.55	63.55	8200.0
2012-11-20 05:00:00	QQQ	ETF	63.68	63.69	63.68	63.69	13000.0
2012-11-20 06:00:00	QQQ	ETF	63.71	63.71	63.69	63.69	6100.0
2012-11-20 07:00:00	QQQ	ETF	63.71	63.72	63.55	63.59	22900.0
2012-11-20 08:00:00	QQQ	ETF	63.56	63.79	63.56	63.77	136080.0
2012-11-20 09:00:00	QQQ	ETF	63.77	63.84	63.52	63.69	4300394.0
2012-11-20 10:00:00	QQQ	ETF	63.69	63.84	63.6401	63.65	6365751.0
2012-11-20 11:00:00	QQQ	ETF	63.65	63.88	63.58	63.86	2858820.0
2012-11-20 12:00:00	QQQ	ETF	63.87	63.89	63.63	63.718	3022342.0
2012-11-20 13:00:00	QQQ	ETF	63.71	63.72	63.19	63.51	13509490.0
2012-11-20 14:00:00	QQQ	ETF	63.5	63.64	63.44	63.58	1900079.0
2012-11-20 15:00:00	QQQ	ETF	63.59	63.8	63.55	63.8	3769797.0
2012-11-20 16:00:00	QQQ	ETF	63.8	63.83	63.5801	63.79	982409.0
2012-11-20 17:00:00	QQQ	ETF	63.78	63.8	63.78	63.8	11973.0
2012-11-20 18:00:00	QQQ	ETF	63.8	63.81	63.75	63.77	15068.0
2012-11-20 19:00:00	QQQ	ETF	63.77	63.84	63.77	63.8	18062.0
2012-11-20 07:00:00	IWM	ETF	79.22	79.22	78.99	79.01	80500.0
2012-11-20 08:00:00	IWM	ETF	79.01	79.24	79.01	79.16	51147.0
2012-11-20 09:00:00	IWM	ETF	79.1	79.1	78.64	79.01	4776943.0
2012-11-20 10:00:00	IWM	ETF	79.01	79.17	78.79	78.9	3515324.0
2012-11-20 11:00:00	IWM	ETF	78.9	79.35	78.79	79.26	3223284.0
2012-11-20 12:00:00	IWM	ETF	79.2655	79.29	79.0	79.11	1892247.0
2012-11-20 13:00:00	IWM	ETF	79.12	79.13	78.66	79.04	4037688.0
2012-11-20 14:00:00	IWM	ETF	79.03	79.21	78.92	79.06	5699773.0
2012-11-20 15:00:00	IWM	ETF	79.07	79.3	78.88	79.3	5250537.0
2012-11-20 16:00:00	IWM	ETF	79.3	79.48	78.9401	79.4	2770646.0
2012-11-20 17:00:00	IWM	ETF	79.4	79.43	79.38	79.43	10084.0
2012-11-20 18:00:00	IWM	ETF	79.43	79.43	79.41	79.41	3080.0
2012-11-20 19:00:00	IWM	ETF	79.4	79.4	79.4	79.4	3180.0
2012-11-20 07:00:00	DIA	ETF	127.49	127.49	127.24	127.24	600.0
2012-11-20 08:00:00	DIA	ETF	127.21	127.46	127.18	127.46	13086.0
2012-11-20 09:00:00	DIA	ETF	127.3	127.37	127.05	127.32	839866.0
2012-11-20 10:00:00	DIA	ETF	127.32	127.66	127.16	127.41	922495.0
2012-11-20 11:00:00	DIA	ETF	127.41	127.86	127.3	127.79	904523.0

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

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