PREVIEW / etf_1hour / 2013-11-26

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-11-26.parquet
  size:    207 KB
  rows:    6,483

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-11-26 04:00:00	SPY	ETF	180.87	180.87	180.66	180.66	7062.0
2013-11-26 05:00:00	SPY	ETF	180.69	180.7	180.63	180.65	11600.0
2013-11-26 06:00:00	SPY	ETF	180.69	180.71	180.62	180.67	22034.0
2013-11-26 07:00:00	SPY	ETF	180.71	180.9	180.67	180.83	124209.0
2013-11-26 08:00:00	SPY	ETF	180.91	180.91	180.7	180.7	519309.0
2013-11-26 09:00:00	SPY	ETF	180.7	180.94	180.65	180.72	10249748.0
2013-11-26 10:00:00	SPY	ETF	180.73	180.86	180.405	180.76	10103529.0
2013-11-26 11:00:00	SPY	ETF	180.765	180.9	180.68	180.68	6626564.0
2013-11-26 12:00:00	SPY	ETF	180.68	181.06	180.67	180.95	8420086.0
2013-11-26 13:00:00	SPY	ETF	180.95	181.15	180.9	181.115	6827319.0
2013-11-26 14:00:00	SPY	ETF	181.115	181.185	180.94	181.085	7867299.0
2013-11-26 15:00:00	SPY	ETF	181.0805	181.22	180.63	180.69	25426110.0
2013-11-26 16:00:00	SPY	ETF	180.68	181.1138	180.599	180.77	7269426.0
2013-11-26 17:00:00	SPY	ETF	180.77	180.77	180.64	180.71	289388.0
2013-11-26 18:00:00	SPY	ETF	180.7	180.71	180.64	180.67	81160.0
2013-11-26 19:00:00	SPY	ETF	180.67	180.77	180.66	180.74	87818.0
2013-11-26 04:00:00	QQQ	ETF	84.18	84.18	84.18	84.18	4200.0
2013-11-26 07:00:00	QQQ	ETF	84.17	84.24	84.17	84.23	13900.0
2013-11-26 08:00:00	QQQ	ETF	84.23	84.26	84.19	84.2	30209.0
2013-11-26 09:00:00	QQQ	ETF	84.21	84.31	84.095	84.13	2747036.0
2013-11-26 10:00:00	QQQ	ETF	84.13	84.37	84.025	84.34	4355852.0
2013-11-26 11:00:00	QQQ	ETF	84.34	84.47	84.331	84.35	2136298.0
2013-11-26 12:00:00	QQQ	ETF	84.35	84.65	84.34	84.6101	2457175.0
2013-11-26 13:00:00	QQQ	ETF	84.62	84.74	84.59	84.69	1448619.0
2013-11-26 14:00:00	QQQ	ETF	84.7	84.8	84.62	84.76	2753273.0
2013-11-26 15:00:00	QQQ	ETF	84.759	84.84	84.6	84.61	5392120.0
2013-11-26 16:00:00	QQQ	ETF	84.61	84.7102	84.136	84.65	2805080.0
2013-11-26 17:00:00	QQQ	ETF	84.64	84.64	84.63	84.63	9500.0
2013-11-26 18:00:00	QQQ	ETF	84.62	84.63	84.61	84.61	4070.0
2013-11-26 19:00:00	QQQ	ETF	84.61	84.61	84.61	84.61	2000.0
2013-11-26 06:00:00	IWM	ETF	111.86	111.98	111.86	111.98	600.0
2013-11-26 07:00:00	IWM	ETF	112.04	112.15	112.04	112.15	73276.0
2013-11-26 08:00:00	IWM	ETF	112.12	112.12	111.99	112.0	34791.0
2013-11-26 09:00:00	IWM	ETF	112.0	112.15	111.92	112.03	1826846.0
2013-11-26 10:00:00	IWM	ETF	112.03	112.3	111.9	112.29	3400379.0
2013-11-26 11:00:00	IWM	ETF	112.29	112.55	112.28	112.4092	2168739.0
2013-11-26 12:00:00	IWM	ETF	112.41	112.76	112.39	112.74	2031230.0
2013-11-26 13:00:00	IWM	ETF	112.74	112.85	112.63	112.84	1815141.0
2013-11-26 14:00:00	IWM	ETF	112.84	113.02	112.74	112.98	2459179.0
2013-11-26 15:00:00	IWM	ETF	112.98	113.02	112.71	112.8	7453823.0
2013-11-26 16:00:00	IWM	ETF	112.81	112.9157	111.8105	112.77	2527399.0
2013-11-26 17:00:00	IWM	ETF	112.82	112.82	112.71	112.71	400.0
2013-11-26 18:00:00	IWM	ETF	112.86	112.91	112.86	112.89	300.0
2013-11-26 19:00:00	IWM	ETF	112.82	112.82	112.72	112.72	500.0
2013-11-26 09:00:00	DIA	ETF	160.53	160.82	160.51	160.76	424065.0
2013-11-26 10:00:00	DIA	ETF	160.7501	160.81	160.46	160.64	622951.0
2013-11-26 11:00:00	DIA	ETF	160.65	160.8	160.565	160.565	344371.0
2013-11-26 12:00:00	DIA	ETF	160.56	160.82	160.56	160.69	340628.0
2013-11-26 13:00:00	DIA	ETF	160.69	160.81	160.63	160.81	425570.0
2013-11-26 14:00:00	DIA	ETF	160.82	160.97	160.69	160.83	577058.0

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

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