PREVIEW / etf_1hour / 2012-12-26

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-12-26.parquet
  size:    184 KB
  rows:    5,750

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-12-26 04:00:00	SPY	ETF	142.4	142.4	142.4	142.4	100.0
2012-12-26 05:00:00	SPY	ETF	142.39	142.39	142.39	142.39	100.0
2012-12-26 06:00:00	SPY	ETF	142.49	142.49	142.41	142.41	2700.0
2012-12-26 07:00:00	SPY	ETF	142.42	142.63	142.42	142.58	116726.0
2012-12-26 08:00:00	SPY	ETF	142.58	142.62	142.42	142.49	252444.0
2012-12-26 09:00:00	SPY	ETF	142.49	142.76	142.33	142.53	6777533.0
2012-12-26 10:00:00	SPY	ETF	142.54	142.62	142.02	142.02	9827624.0
2012-12-26 11:00:00	SPY	ETF	142.02	142.18	141.35	141.655	15828000.0
2012-12-26 12:00:00	SPY	ETF	141.66	141.83	141.48	141.759	9859319.0
2012-12-26 13:00:00	SPY	ETF	141.759	141.8	141.62	141.69	9066708.0
2012-12-26 14:00:00	SPY	ETF	141.69	142.18	141.685	142.06	11103940.0
2012-12-26 15:00:00	SPY	ETF	142.07	142.095	141.69	141.71	22697397.0
2012-12-26 16:00:00	SPY	ETF	141.73	142.4068	141.48	141.57	10321400.0
2012-12-26 17:00:00	SPY	ETF	141.55	142.4065	141.52	141.62	6174330.0
2012-12-26 18:00:00	SPY	ETF	141.6	141.66	141.56	141.63	1037137.0
2012-12-26 19:00:00	SPY	ETF	141.65	141.71	141.61	141.71	29765.0
2012-12-26 06:00:00	QQQ	ETF	65.47	65.47	65.4	65.4	17061.0
2012-12-26 07:00:00	QQQ	ETF	65.11	65.15	65.05	65.07	17700.0
2012-12-26 08:00:00	QQQ	ETF	65.05	65.12	65.03	65.04	37345.0
2012-12-26 09:00:00	QQQ	ETF	65.05	65.18	64.99	65.0801	1783709.0
2012-12-26 10:00:00	QQQ	ETF	65.09	65.14	64.67	64.67	1707314.0
2012-12-26 11:00:00	QQQ	ETF	64.66	64.6999	64.29	64.5669	3773017.0
2012-12-26 12:00:00	QQQ	ETF	64.57	64.59	64.38	64.5	2027894.0
2012-12-26 13:00:00	QQQ	ETF	64.509	64.61	64.44	64.54	1662454.0
2012-12-26 14:00:00	QQQ	ETF	64.5426	64.74	64.54	64.71	3274668.0
2012-12-26 15:00:00	QQQ	ETF	64.7	64.71	64.48	64.52	6187395.0
2012-12-26 16:00:00	QQQ	ETF	64.52	64.5502	64.45	64.52	1085109.0
2012-12-26 17:00:00	QQQ	ETF	64.48	64.57	64.48	64.57	8725.0
2012-12-26 18:00:00	QQQ	ETF	64.54	64.54	64.48	64.49	11141.0
2012-12-26 19:00:00	QQQ	ETF	64.5	64.52	64.5	64.52	3500.0
2012-12-26 07:00:00	IWM	ETF	83.89	83.89	83.89	83.89	100.0
2012-12-26 08:00:00	IWM	ETF	83.86	84.05	83.86	83.9	22507.0
2012-12-26 09:00:00	IWM	ETF	83.91	84.01	83.6999	83.86	1281499.0
2012-12-26 10:00:00	IWM	ETF	83.851	83.99	83.43	83.44	2301162.0
2012-12-26 11:00:00	IWM	ETF	83.44	83.49	83.15	83.41	4034873.0
2012-12-26 12:00:00	IWM	ETF	83.42	83.48	83.23	83.39	1542211.0
2012-12-26 13:00:00	IWM	ETF	83.39	83.41	83.24	83.32	1235843.0
2012-12-26 14:00:00	IWM	ETF	83.32	83.62	83.32	83.58	1845659.0
2012-12-26 15:00:00	IWM	ETF	83.58	83.59	83.13	83.16	6231669.0
2012-12-26 16:00:00	IWM	ETF	83.16	83.4	83.02	83.08	3614204.0
2012-12-26 17:00:00	IWM	ETF	83.09	83.13	83.08	83.13	14400.0
2012-12-26 18:00:00	IWM	ETF	83.15	83.16	83.15	83.16	800.0
2012-12-26 19:00:00	IWM	ETF	83.13	83.14	83.13	83.14	1200.0
2012-12-26 07:00:00	DIA	ETF	131.2	131.2	131.2	131.2	100.0
2012-12-26 08:00:00	DIA	ETF	131.22	131.27	131.22	131.23	620.0
2012-12-26 09:00:00	DIA	ETF	131.27	131.479	131.21	131.32	355626.0
2012-12-26 10:00:00	DIA	ETF	131.33	131.4	131.01	131.01	340429.0
2012-12-26 11:00:00	DIA	ETF	131.0	131.04	130.47	130.7	646513.0
2012-12-26 12:00:00	DIA	ETF	130.72	130.838	130.54	130.771	396014.0
2012-12-26 13:00:00	DIA	ETF	130.77	130.805	130.65	130.72	185965.0

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

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