PREVIEW / etf_1hour / 2014-12-31

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-12-31.parquet
  size:    241 KB
  rows:    7,657

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
2014-12-31 04:00:00	SPY	ETF	208.09	208.3	208.09	208.23	7220.0
2014-12-31 05:00:00	SPY	ETF	208.16	208.22	208.11	208.2	7400.0
2014-12-31 06:00:00	SPY	ETF	208.14	208.14	208.05	208.05	3100.0
2014-12-31 07:00:00	SPY	ETF	208.06	208.17	208.06	208.15	14966.0
2014-12-31 08:00:00	SPY	ETF	208.14	208.23	208.01	208.11	156662.0
2014-12-31 09:00:00	SPY	ETF	208.11	208.14	207.71	207.8	7573477.0
2014-12-31 10:00:00	SPY	ETF	207.8	208.19	207.8	208.1068	8858084.0
2014-12-31 11:00:00	SPY	ETF	208.1	208.14	207.82	207.91	10788625.0
2014-12-31 12:00:00	SPY	ETF	207.92	207.94	206.96	207.15	12894585.0
2014-12-31 13:00:00	SPY	ETF	207.1599	207.47	207.0	207.15	8696712.0
2014-12-31 14:00:00	SPY	ETF	207.15	207.15	206.1	206.33	17640815.0
2014-12-31 15:00:00	SPY	ETF	206.39	208.02	205.39	205.52	36932065.0
2014-12-31 16:00:00	SPY	ETF	205.51	207.9	205.44	205.57	13190601.0
2014-12-31 17:00:00	SPY	ETF	205.53	205.7	205.5	205.5	795108.0
2014-12-31 18:00:00	SPY	ETF	205.52	205.64	205.52	205.62	10033.0
2014-12-31 19:00:00	SPY	ETF	205.62	205.68	205.59	205.66	10394.0
2014-12-31 07:00:00	QQQ	ETF	104.45	104.49	104.45	104.48	938.0
2014-12-31 08:00:00	QQQ	ETF	104.49	104.65	104.46	104.48	55685.0
2014-12-31 09:00:00	QQQ	ETF	104.5	104.65	104.435	104.53	2706266.0
2014-12-31 10:00:00	QQQ	ETF	104.53	104.91	104.53	104.87	2168874.0
2014-12-31 11:00:00	QQQ	ETF	104.876	104.89	104.57	104.615	1916953.0
2014-12-31 12:00:00	QQQ	ETF	104.61	104.631	103.98	104.129	2862077.0
2014-12-31 13:00:00	QQQ	ETF	104.13	104.28	104.01	104.08	1284516.0
2014-12-31 14:00:00	QQQ	ETF	104.08	104.085	103.47	103.5499	3585629.0
2014-12-31 15:00:00	QQQ	ETF	103.545	103.72	103.1	103.23	7212744.0
2014-12-31 16:00:00	QQQ	ETF	103.23	104.5249	103.19	103.29	1157823.0
2014-12-31 17:00:00	QQQ	ETF	103.29	103.39	103.25	103.33	272504.0
2014-12-31 18:00:00	QQQ	ETF	103.33	103.37	103.33	103.37	1100.0
2014-12-31 19:00:00	QQQ	ETF	103.37	103.38	103.37	103.38	500.0
2014-12-31 07:00:00	IWM	ETF	120.65	120.73	120.65	120.69	2792.0
2014-12-31 08:00:00	IWM	ETF	120.68	120.83	120.68	120.75	24590.0
2014-12-31 09:00:00	IWM	ETF	120.73	120.94	120.59	120.795	3306471.0
2014-12-31 10:00:00	IWM	ETF	120.77	121.41	120.765	121.3	2858537.0
2014-12-31 11:00:00	IWM	ETF	121.3	121.33	121.005	121.2	2321347.0
2014-12-31 12:00:00	IWM	ETF	121.21	121.24	120.55	120.75	3314911.0
2014-12-31 13:00:00	IWM	ETF	120.75	120.88	120.525	120.62	3503611.0
2014-12-31 14:00:00	IWM	ETF	120.61	120.61	120.12	120.295	5445690.0
2014-12-31 15:00:00	IWM	ETF	120.29	120.45	119.54	119.63	9507781.0
2014-12-31 16:00:00	IWM	ETF	119.62	120.8544	119.34	119.5	2072520.0
2014-12-31 17:00:00	IWM	ETF	119.62	119.9	119.52	119.78	73614.0
2014-12-31 18:00:00	IWM	ETF	119.68	119.68	119.68	119.68	100.0
2014-12-31 19:00:00	IWM	ETF	119.68	119.68	119.68	119.68	300.0
2014-12-31 08:00:00	DIA	ETF	179.9	179.95	179.81	179.9	3159.0
2014-12-31 09:00:00	DIA	ETF	179.86	179.98	179.76	179.84	364836.0
2014-12-31 10:00:00	DIA	ETF	179.82	180.12	179.78	180.02	567624.0
2014-12-31 11:00:00	DIA	ETF	180.03	180.04	179.802	179.89	167308.0
2014-12-31 12:00:00	DIA	ETF	179.91	179.92	179.0	179.149	882192.0
2014-12-31 13:00:00	DIA	ETF	179.15	179.48	179.11	179.24	318967.0
2014-12-31 14:00:00	DIA	ETF	179.23	179.24	178.43	178.759	622289.0
2014-12-31 15:00:00	DIA	ETF	178.75	179.08	177.88	177.93	1177194.0

> showing 50 of 7,657 rows — these rows as CSV

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