PREVIEW / etf_1hour / 2012-06-29

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-06-29.parquet
  size:    196 KB
  rows:    6,056

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-06-29 04:00:00	SPY	ETF	134.2	134.64	134.2	134.47	27454.0
2012-06-29 05:00:00	SPY	ETF	134.41	134.61	134.3	134.57	31278.0
2012-06-29 06:00:00	SPY	ETF	134.51	134.65	134.35	134.62	138552.0
2012-06-29 07:00:00	SPY	ETF	134.62	134.9	134.54	134.69	1658550.0
2012-06-29 08:00:00	SPY	ETF	134.69	135.46	134.67	135.23	4561563.0
2012-06-29 09:00:00	SPY	ETF	135.25	135.29	134.28	135.06	29134046.0
2012-06-29 10:00:00	SPY	ETF	135.06	135.59	135.06	135.37	29881599.0
2012-06-29 11:00:00	SPY	ETF	135.37	135.54	135.26	135.42	19471017.0
2012-06-29 12:00:00	SPY	ETF	135.425	135.49	135.32	135.475	13834997.0
2012-06-29 13:00:00	SPY	ETF	135.49	135.67	135.45	135.61	15866490.0
2012-06-29 14:00:00	SPY	ETF	135.61	135.85	135.51	135.83	21758924.0
2012-06-29 15:00:00	SPY	ETF	135.839	136.24	135.55	136.22	44396669.0
2012-06-29 16:00:00	SPY	ETF	136.22	136.5	135.435	136.37	26616526.0
2012-06-29 17:00:00	SPY	ETF	136.37	136.44	135.1434	136.38	917299.0
2012-06-29 18:00:00	SPY	ETF	136.39	136.48	136.37	136.37	113604.0
2012-06-29 19:00:00	SPY	ETF	136.38	136.49	136.35	136.38	80580.0
2012-06-29 04:00:00	QQQ	ETF	62.65	62.9	62.65	62.83	3500.0
2012-06-29 05:00:00	QQQ	ETF	63.01	63.01	62.68	62.68	640.0
2012-06-29 06:00:00	QQQ	ETF	62.88	62.99	62.87	62.95	9522.0
2012-06-29 07:00:00	QQQ	ETF	62.96	63.11	62.96	63.02	181858.0
2012-06-29 08:00:00	QQQ	ETF	63.02	63.35	63.01	63.29	756269.0
2012-06-29 09:00:00	QQQ	ETF	63.3	63.51	63.21	63.35	6919274.0
2012-06-29 10:00:00	QQQ	ETF	63.36	63.68	63.36	63.61	9215789.0
2012-06-29 11:00:00	QQQ	ETF	63.62	63.79	63.582	63.69	4666902.0
2012-06-29 12:00:00	QQQ	ETF	63.69	63.81	63.67	63.795	3075932.0
2012-06-29 13:00:00	QQQ	ETF	63.8	63.86	63.79	63.84	2224641.0
2012-06-29 14:00:00	QQQ	ETF	63.84	64.01	63.825	64.009	4559479.0
2012-06-29 15:00:00	QQQ	ETF	64.01	64.14	63.82	64.14	10138531.0
2012-06-29 16:00:00	QQQ	ETF	64.15	64.32	63.28	64.25	1620292.0
2012-06-29 17:00:00	QQQ	ETF	64.25	64.26	62.1979	64.2	1029844.0
2012-06-29 18:00:00	QQQ	ETF	64.2	64.22	64.18	64.21	6765.0
2012-06-29 19:00:00	QQQ	ETF	64.21	64.22	64.17	64.17	4000.0
2012-06-29 04:00:00	IWM	ETF	77.88	78.45	77.88	78.4	11412.0
2012-06-29 05:00:00	IWM	ETF	78.39	78.39	78.39	78.39	200.0
2012-06-29 06:00:00	IWM	ETF	78.46	78.46	78.46	78.46	1000.0
2012-06-29 07:00:00	IWM	ETF	78.54	78.75	78.51	78.57	128495.0
2012-06-29 08:00:00	IWM	ETF	78.59	79.07	78.57	78.94	906554.0
2012-06-29 09:00:00	IWM	ETF	78.95	79.07	78.56	78.74	9220429.0
2012-06-29 10:00:00	IWM	ETF	78.75	79.11	78.75	79.0201	11529681.0
2012-06-29 11:00:00	IWM	ETF	79.02	79.27	78.94	79.195	6359973.0
2012-06-29 12:00:00	IWM	ETF	79.19	79.33	79.11	79.33	3757542.0
2012-06-29 13:00:00	IWM	ETF	79.32	79.6025	79.32	79.55	3971760.0
2012-06-29 14:00:00	IWM	ETF	79.54	79.73	79.44	79.7	5873273.0
2012-06-29 15:00:00	IWM	ETF	79.7	79.71	79.35	79.68	11861801.0
2012-06-29 16:00:00	IWM	ETF	79.66	79.88	77.3304	79.82	5863431.0
2012-06-29 17:00:00	IWM	ETF	79.77	79.8	79.77	79.8	8787.0
2012-06-29 18:00:00	IWM	ETF	79.76	79.76	79.66	79.71	12825.0
2012-06-29 19:00:00	IWM	ETF	79.72	79.72	79.7	79.72	3976.0
2012-06-29 05:00:00	DIA	ETF	126.67	126.67	126.67	126.67	300.0
2012-06-29 07:00:00	DIA	ETF	127.0	127.18	126.9	126.98	1660.0

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

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