PREVIEW / etf_1hour / 2012-12-20

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-12-20.parquet
  size:    194 KB
  rows:    6,005

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-20 04:00:00	SPY	ETF	144.27	144.37	144.27	144.3	18238.0
2012-12-20 05:00:00	SPY	ETF	144.3	144.44	144.25	144.44	35640.0
2012-12-20 06:00:00	SPY	ETF	144.39	144.51	144.36	144.48	44741.0
2012-12-20 07:00:00	SPY	ETF	144.48	144.61	144.38	144.49	409943.0
2012-12-20 08:00:00	SPY	ETF	144.43	144.58	144.07	144.43	3392858.0
2012-12-20 09:00:00	SPY	ETF	144.44	144.59	143.98	144.03	14823674.0
2012-12-20 10:00:00	SPY	ETF	144.03	144.65	144.02	144.5	19238799.0
2012-12-20 11:00:00	SPY	ETF	144.51	144.61	144.22	144.44	13719979.0
2012-12-20 12:00:00	SPY	ETF	144.435	144.53	144.33	144.52	9919332.0
2012-12-20 13:00:00	SPY	ETF	144.51	144.94	144.3	144.91	14326401.0
2012-12-20 14:00:00	SPY	ETF	144.92	145.04	144.75	144.979	12302499.0
2012-12-20 15:00:00	SPY	ETF	144.97	145.14	144.68	145.09	27917992.0
2012-12-20 16:00:00	SPY	ETF	145.09	145.34	144.3133	145.21	38283728.0
2012-12-20 17:00:00	SPY	ETF	145.21	145.3	145.21	145.3	4303441.0
2012-12-20 18:00:00	SPY	ETF	145.28	145.3	145.15	145.18	351977.0
2012-12-20 19:00:00	SPY	ETF	145.17	145.19	144.81	144.92	228469.0
2012-12-20 04:00:00	QQQ	ETF	66.24	66.3	66.24	66.27	3968.0
2012-12-20 06:00:00	QQQ	ETF	66.33	66.38	66.33	66.38	6900.0
2012-12-20 07:00:00	QQQ	ETF	66.38	66.43	66.36	66.36	39900.0
2012-12-20 08:00:00	QQQ	ETF	66.36	66.41	66.23	66.41	1404755.0
2012-12-20 09:00:00	QQQ	ETF	66.41	66.5	65.93	65.96	5440132.0
2012-12-20 10:00:00	QQQ	ETF	65.97	66.289	65.96	66.1	4467310.0
2012-12-20 11:00:00	QQQ	ETF	66.09	66.19	65.97	66.09	2700203.0
2012-12-20 12:00:00	QQQ	ETF	66.09	66.15	66.02	66.11	2955608.0
2012-12-20 13:00:00	QQQ	ETF	66.11	66.3	65.98	66.279	3967882.0
2012-12-20 14:00:00	QQQ	ETF	66.2779	66.41	66.17	66.36	4130945.0
2012-12-20 15:00:00	QQQ	ETF	66.35	66.36	66.16	66.25	7972796.0
2012-12-20 16:00:00	QQQ	ETF	66.25	66.35	66.2151	66.28	4000567.0
2012-12-20 17:00:00	QQQ	ETF	66.28	66.32	66.27	66.3	61734.0
2012-12-20 18:00:00	QQQ	ETF	66.3	66.31	66.27	66.27	18290.0
2012-12-20 19:00:00	QQQ	ETF	66.27	66.27	66.18	66.19	25540.0
2012-12-20 07:00:00	IWM	ETF	84.12	84.12	84.04	84.04	700.0
2012-12-20 08:00:00	IWM	ETF	84.04	84.04	83.84	83.96	493773.0
2012-12-20 09:00:00	IWM	ETF	84.08	84.24	83.85	83.88	3043112.0
2012-12-20 10:00:00	IWM	ETF	83.89	84.33	83.88	84.31	4692419.0
2012-12-20 11:00:00	IWM	ETF	84.31	84.37	84.14	84.28	3252216.0
2012-12-20 12:00:00	IWM	ETF	84.29	84.41	84.27	84.35	2072868.0
2012-12-20 13:00:00	IWM	ETF	84.35	84.57	84.23	84.52	3483066.0
2012-12-20 14:00:00	IWM	ETF	84.52	84.61	84.43	84.56	4529337.0
2012-12-20 15:00:00	IWM	ETF	84.56	84.58	84.35	84.51	8216603.0
2012-12-20 16:00:00	IWM	ETF	84.51	84.81	84.3	84.76	3867390.0
2012-12-20 17:00:00	IWM	ETF	84.77	84.85	84.54	84.85	18982.0
2012-12-20 18:00:00	IWM	ETF	84.85	84.86	84.79	84.85	10000.0
2012-12-20 19:00:00	IWM	ETF	84.73	84.73	84.66	84.69	12896.0
2012-12-20 06:00:00	DIA	ETF	132.84	132.84	132.84	132.84	1000.0
2012-12-20 07:00:00	DIA	ETF	132.84	132.84	132.84	132.84	200.0
2012-12-20 08:00:00	DIA	ETF	132.82	132.82	132.62	132.67	13100.0
2012-12-20 09:00:00	DIA	ETF	132.67	132.77	132.27	132.27	748846.0
2012-12-20 10:00:00	DIA	ETF	132.32	132.84	132.32	132.65	1035326.0
2012-12-20 11:00:00	DIA	ETF	132.64	132.75	132.42	132.58	639054.0

> showing 50 of 6,005 rows — these rows as CSV

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