PREVIEW / etf_1hour / 2012-09-07

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-09-07.parquet
  size:    189 KB
  rows:    5,978

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-09-07 04:00:00	SPY	ETF	144.01	144.21	144.01	144.15	38775.0
2012-09-07 05:00:00	SPY	ETF	144.12	144.24	144.12	144.15	27523.0
2012-09-07 06:00:00	SPY	ETF	144.24	144.34	144.21	144.3	113800.0
2012-09-07 07:00:00	SPY	ETF	144.24	144.39	144.18	144.35	332115.0
2012-09-07 08:00:00	SPY	ETF	144.36	144.43	143.43	144.02	6677519.0
2012-09-07 09:00:00	SPY	ETF	144.02	144.33	143.88	144.06	19438997.0
2012-09-07 10:00:00	SPY	ETF	144.07	144.29	143.92	144.19	16421970.0
2012-09-07 11:00:00	SPY	ETF	144.19	144.23	144.01	144.15	11072216.0
2012-09-07 12:00:00	SPY	ETF	144.15	144.25	144.06	144.22	5812346.0
2012-09-07 13:00:00	SPY	ETF	144.22	144.26	144.09	144.09	5970220.0
2012-09-07 14:00:00	SPY	ETF	144.09	144.29	144.07	144.2	6787844.0
2012-09-07 15:00:00	SPY	ETF	144.19	144.35	144.11	144.33	18378306.0
2012-09-07 16:00:00	SPY	ETF	144.34	144.5221	144.15	144.43	12439234.0
2012-09-07 17:00:00	SPY	ETF	144.42	144.47	144.33	144.33	194819.0
2012-09-07 18:00:00	SPY	ETF	144.34	144.37	144.33	144.37	25902.0
2012-09-07 19:00:00	SPY	ETF	144.36	144.45	144.36	144.41	28074.0
2012-09-07 06:00:00	QQQ	ETF	69.7	69.7	69.7	69.7	495.0
2012-09-07 07:00:00	QQQ	ETF	69.63	69.69	69.63	69.67	13895.0
2012-09-07 08:00:00	QQQ	ETF	69.68	69.68	69.25	69.44	2492595.0
2012-09-07 09:00:00	QQQ	ETF	69.44	69.5	69.23	69.35	7776970.0
2012-09-07 10:00:00	QQQ	ETF	69.34	69.55	69.3	69.42	5343920.0
2012-09-07 11:00:00	QQQ	ETF	69.42	69.43	69.32	69.36	3541251.0
2012-09-07 12:00:00	QQQ	ETF	69.37	69.43	69.3	69.4	1798103.0
2012-09-07 13:00:00	QQQ	ETF	69.41	69.45	69.31	69.32	2603742.0
2012-09-07 14:00:00	QQQ	ETF	69.32	69.45	69.3135	69.38	2099893.0
2012-09-07 15:00:00	QQQ	ETF	69.39	69.43	69.32	69.405	4195484.0
2012-09-07 16:00:00	QQQ	ETF	69.43	69.5398	69.35	69.39	1201792.0
2012-09-07 17:00:00	QQQ	ETF	69.39	69.41	69.35	69.38	3025.0
2012-09-07 18:00:00	QQQ	ETF	69.36	69.36	69.36	69.36	1000.0
2012-09-07 19:00:00	QQQ	ETF	69.38	69.41	69.38	69.41	6625.0
2012-09-07 06:00:00	IWM	ETF	83.95	83.95	83.95	83.95	1000.0
2012-09-07 07:00:00	IWM	ETF	83.95	84.07	83.94	84.07	59600.0
2012-09-07 08:00:00	IWM	ETF	83.98	84.21	83.15	84.01	961492.0
2012-09-07 09:00:00	IWM	ETF	83.98	84.11	83.7	83.98	5388016.0
2012-09-07 10:00:00	IWM	ETF	83.99	84.4	83.85	84.35	6693838.0
2012-09-07 11:00:00	IWM	ETF	84.35	84.36	84.075	84.205	3220793.0
2012-09-07 12:00:00	IWM	ETF	84.21	84.3	84.075	84.29	2303976.0
2012-09-07 13:00:00	IWM	ETF	84.28	84.315	84.13	84.14	1680638.0
2012-09-07 14:00:00	IWM	ETF	84.14	84.25	84.11	84.2	1882412.0
2012-09-07 15:00:00	IWM	ETF	84.2001	84.24	84.0701	84.2	6278467.0
2012-09-07 16:00:00	IWM	ETF	84.21	84.34	84.1231	84.23	1515697.0
2012-09-07 17:00:00	IWM	ETF	84.26	84.33	84.25	84.26	1400.0
2012-09-07 18:00:00	IWM	ETF	84.24	84.26	84.24	84.26	928.0
2012-09-07 08:00:00	DIA	ETF	133.1	133.24	132.8	132.88	19778.0
2012-09-07 09:00:00	DIA	ETF	132.86	133.09	132.76	132.86	736502.0
2012-09-07 10:00:00	DIA	ETF	132.86	133.0	132.69	132.86	635732.0
2012-09-07 11:00:00	DIA	ETF	132.85	132.85	132.64	132.76	429806.0
2012-09-07 12:00:00	DIA	ETF	132.76	132.8	132.65	132.76	268920.0
2012-09-07 13:00:00	DIA	ETF	132.76	132.79	132.62	132.65	520159.0
2012-09-07 14:00:00	DIA	ETF	132.63	132.8	132.57	132.73	652133.0

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

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