PREVIEW / etf_1hour / 2012-11-29

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-11-29.parquet
  size:    188 KB
  rows:    5,948

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-29 04:00:00	SPY	ETF	142.21	142.37	142.21	142.31	81393.0
2012-11-29 05:00:00	SPY	ETF	142.23	142.26	142.13	142.17	183923.0
2012-11-29 06:00:00	SPY	ETF	142.18	142.35	142.14	142.21	137211.0
2012-11-29 07:00:00	SPY	ETF	142.21	142.3	142.09	142.275	482253.0
2012-11-29 08:00:00	SPY	ETF	142.28	142.28	141.48	141.96	1190218.0
2012-11-29 09:00:00	SPY	ETF	141.96	142.42	141.91	142.36	16839781.0
2012-11-29 10:00:00	SPY	ETF	142.36	142.51	141.75	142.18	27006488.0
2012-11-29 11:00:00	SPY	ETF	142.18	142.35	141.37	141.72	33966457.0
2012-11-29 12:00:00	SPY	ETF	141.72	142.13	141.555	141.98	16955840.0
2012-11-29 13:00:00	SPY	ETF	141.98	142.39	141.88	142.2622	10327315.0
2012-11-29 14:00:00	SPY	ETF	142.261	142.37	142.17	142.23	8870999.0
2012-11-29 15:00:00	SPY	ETF	142.23	142.28	141.81	142.14	24274040.0
2012-11-29 16:00:00	SPY	ETF	142.13	142.32	141.5114	142.14	8317727.0
2012-11-29 17:00:00	SPY	ETF	142.14	142.14	141.78	141.83	1781850.0
2012-11-29 18:00:00	SPY	ETF	141.83	141.84	141.65	141.76	186988.0
2012-11-29 19:00:00	SPY	ETF	141.77	141.87	141.69	141.81	108359.0
2012-11-29 04:00:00	QQQ	ETF	65.91	66.0	65.91	66.0	195487.0
2012-11-29 05:00:00	QQQ	ETF	65.95	65.95	65.91	65.94	127300.0
2012-11-29 06:00:00	QQQ	ETF	65.94	65.98	65.9	65.91	99200.0
2012-11-29 07:00:00	QQQ	ETF	65.91	65.95	65.9	65.935	117146.0
2012-11-29 08:00:00	QQQ	ETF	65.93	66.02	65.81	65.81	359933.0
2012-11-29 09:00:00	QQQ	ETF	65.81	66.13	65.76	66.04	7332803.0
2012-11-29 10:00:00	QQQ	ETF	66.04	66.135	65.75	66.03	8551265.0
2012-11-29 11:00:00	QQQ	ETF	66.04	66.06	65.58	65.78	7267483.0
2012-11-29 12:00:00	QQQ	ETF	65.78	65.97	65.67	65.861	3360358.0
2012-11-29 13:00:00	QQQ	ETF	65.87	66.02	65.79	65.98	1959071.0
2012-11-29 14:00:00	QQQ	ETF	65.972	66.07	65.87	65.985	2324582.0
2012-11-29 15:00:00	QQQ	ETF	65.98	66.02	65.82	65.91	5058102.0
2012-11-29 16:00:00	QQQ	ETF	65.91	65.95	65.5411	65.89	1391349.0
2012-11-29 17:00:00	QQQ	ETF	65.88	65.8811	65.75	65.77	201790.0
2012-11-29 18:00:00	QQQ	ETF	65.77	65.77	65.72	65.75	3835.0
2012-11-29 19:00:00	QQQ	ETF	65.74	65.8	65.74	65.8	21360.0
2012-11-29 04:00:00	IWM	ETF	81.92	81.95	81.92	81.95	203.0
2012-11-29 05:00:00	IWM	ETF	82.0	82.0	82.0	82.0	2000.0
2012-11-29 06:00:00	IWM	ETF	82.2	82.38	82.2	82.2	700.0
2012-11-29 07:00:00	IWM	ETF	82.2	82.38	82.15	82.35	154591.0
2012-11-29 08:00:00	IWM	ETF	82.32	82.32	81.31	82.02	180768.0
2012-11-29 09:00:00	IWM	ETF	82.0	82.29	81.92	82.18	5098097.0
2012-11-29 10:00:00	IWM	ETF	82.21	82.41	81.765	82.07	10373662.0
2012-11-29 11:00:00	IWM	ETF	82.08	82.22	81.62	81.75	5845758.0
2012-11-29 12:00:00	IWM	ETF	81.75	82.09	81.66	82.08	2506792.0
2012-11-29 13:00:00	IWM	ETF	82.08	82.22	81.96	82.14	1814496.0
2012-11-29 14:00:00	IWM	ETF	82.14	82.3	82.05	82.23	2608984.0
2012-11-29 15:00:00	IWM	ETF	82.23	82.31	81.97	82.23	7702372.0
2012-11-29 16:00:00	IWM	ETF	82.24	82.41	81.2562	82.26	4477699.0
2012-11-29 17:00:00	IWM	ETF	82.16	82.16	82.0368	82.1	65995.0
2012-11-29 18:00:00	IWM	ETF	82.04	82.04	82.03	82.03	1100.0
2012-11-29 19:00:00	IWM	ETF	82.02	82.04	82.01	82.02	2500.0
2012-11-29 04:00:00	DIA	ETF	130.34	130.35	130.34	130.35	200.0
2012-11-29 06:00:00	DIA	ETF	130.35	130.35	130.35	130.35	100.0

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

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