PREVIEW / etf_1hour / 2013-12-11

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-12-11.parquet
  size:    214 KB
  rows:    6,677

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
2013-12-11 04:00:00	SPY	ETF	180.8	181.37	180.48	180.66	37144.0
2013-12-11 05:00:00	SPY	ETF	180.63	180.81	180.63	180.74	12976.0
2013-12-11 06:00:00	SPY	ETF	180.72	180.85	180.64	180.69	62754.0
2013-12-11 07:00:00	SPY	ETF	180.7	180.96	180.66	180.92	196749.0
2013-12-11 08:00:00	SPY	ETF	180.92	181.0	180.66	180.9	431611.0
2013-12-11 09:00:00	SPY	ETF	180.9	180.93	180.02	180.29	12736240.0
2013-12-11 10:00:00	SPY	ETF	180.29	180.3	179.67	179.92	18462338.0
2013-12-11 11:00:00	SPY	ETF	179.92	179.98	179.44	179.65	12957667.0
2013-12-11 12:00:00	SPY	ETF	179.65	179.65	179.15	179.35	12587741.0
2013-12-11 13:00:00	SPY	ETF	179.36	179.7	179.28	179.69	10053734.0
2013-12-11 14:00:00	SPY	ETF	179.698	179.7	179.15	179.22	10341615.0
2013-12-11 15:00:00	SPY	ETF	179.22	179.281	178.5	178.68	35614301.0
2013-12-11 16:00:00	SPY	ETF	178.68	180.7702	178.59	178.64	8785650.0
2013-12-11 17:00:00	SPY	ETF	178.64	178.64	178.5	178.64	809320.0
2013-12-11 18:00:00	SPY	ETF	178.64	178.8	178.64	178.7	77747.0
2013-12-11 19:00:00	SPY	ETF	178.7	178.8	178.7	178.74	376266.0
2013-12-11 04:00:00	QQQ	ETF	86.13	86.19	86.06	86.19	7520.0
2013-12-11 05:00:00	QQQ	ETF	86.22	86.25	86.22	86.22	2900.0
2013-12-11 06:00:00	QQQ	ETF	86.25	86.25	86.19	86.19	3200.0
2013-12-11 07:00:00	QQQ	ETF	86.18	86.31	86.17	86.3	278294.0
2013-12-11 08:00:00	QQQ	ETF	86.25	86.36	86.25	86.3	78961.0
2013-12-11 09:00:00	QQQ	ETF	86.3	86.401	85.9799	86.13	5090245.0
2013-12-11 10:00:00	QQQ	ETF	86.13	86.13	85.815	85.95	5828951.0
2013-12-11 11:00:00	QQQ	ETF	85.95	86.0	85.75	85.82	3175830.0
2013-12-11 12:00:00	QQQ	ETF	85.811	85.82	85.4801	85.53	4024861.0
2013-12-11 13:00:00	QQQ	ETF	85.54	85.71	85.5	85.7	2092745.0
2013-12-11 14:00:00	QQQ	ETF	85.695	85.699	85.41	85.439	2580320.0
2013-12-11 15:00:00	QQQ	ETF	85.44	85.47	85.06	85.19	10837796.0
2013-12-11 16:00:00	QQQ	ETF	85.2	86.086	85.18	85.22	1692581.0
2013-12-11 17:00:00	QQQ	ETF	85.22	85.23	85.17	85.2	161991.0
2013-12-11 18:00:00	QQQ	ETF	85.24	85.34	85.24	85.27	84608.0
2013-12-11 19:00:00	QQQ	ETF	85.28	85.33	85.28	85.3	161055.0
2013-12-11 06:00:00	IWM	ETF	111.73	111.76	111.46	111.46	2300.0
2013-12-11 07:00:00	IWM	ETF	111.49	111.67	111.45	111.64	2840.0
2013-12-11 08:00:00	IWM	ETF	111.66	111.74	111.61	111.64	200496.0
2013-12-11 09:00:00	IWM	ETF	111.61	111.69	110.6	110.86	4486763.0
2013-12-11 10:00:00	IWM	ETF	110.85	110.89	110.25	110.45	6306513.0
2013-12-11 11:00:00	IWM	ETF	110.45	110.47	109.85	110.1	5538069.0
2013-12-11 12:00:00	IWM	ETF	110.105	110.11	109.5	109.68	4148072.0
2013-12-11 13:00:00	IWM	ETF	109.69	110.1	109.66	110.095	2898994.0
2013-12-11 14:00:00	IWM	ETF	110.1	110.1	109.61	109.715	2918373.0
2013-12-11 15:00:00	IWM	ETF	109.72	109.74	109.32	109.63	8494523.0
2013-12-11 16:00:00	IWM	ETF	109.635	111.3834	109.4964	109.69	2636420.0
2013-12-11 17:00:00	IWM	ETF	109.66	111.3834	109.65	109.69	513021.0
2013-12-11 18:00:00	IWM	ETF	109.69	109.79	109.69	109.79	1050.0
2013-12-11 19:00:00	IWM	ETF	109.79	109.89	109.79	109.89	600.0
2013-12-11 07:00:00	DIA	ETF	159.72	159.72	159.72	159.72	100.0
2013-12-11 08:00:00	DIA	ETF	159.93	159.95	159.88	159.91	24546.0
2013-12-11 09:00:00	DIA	ETF	159.93	159.93	159.13	159.33	1229847.0
2013-12-11 10:00:00	DIA	ETF	159.32	159.36	158.85	159.13	1160699.0

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

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