PREVIEW / etf_1hour / 2015-05-21

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-05-21.parquet
  size:    233 KB
  rows:    7,433

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
2015-05-21 04:00:00	SPY	ETF	212.37	212.5	212.31	212.32	7155.0
2015-05-21 05:00:00	SPY	ETF	212.35	212.43	212.28	212.36	4002.0
2015-05-21 06:00:00	SPY	ETF	212.37	212.43	212.31	212.37	27593.0
2015-05-21 07:00:00	SPY	ETF	212.39	212.65	212.38	212.57	219249.0
2015-05-21 08:00:00	SPY	ETF	212.63	212.63	212.42	212.55	381182.0
2015-05-21 09:00:00	SPY	ETF	212.56	212.96	212.51	212.84	7399451.0
2015-05-21 10:00:00	SPY	ETF	212.84	213.37	212.74	213.235	8396994.0
2015-05-21 11:00:00	SPY	ETF	213.235	213.6	213.235	213.495	8121824.0
2015-05-21 12:00:00	SPY	ETF	213.49	213.64	213.39	213.465	4642063.0
2015-05-21 13:00:00	SPY	ETF	213.469	213.55	213.15	213.19	5252154.0
2015-05-21 14:00:00	SPY	ETF	213.2	213.58	213.15	213.48	5575255.0
2015-05-21 15:00:00	SPY	ETF	213.48	213.75	213.21	213.47	19508612.0
2015-05-21 16:00:00	SPY	ETF	213.5	213.51	213.31	213.41	4270253.0
2015-05-21 17:00:00	SPY	ETF	213.41	213.46	213.4	213.44	81052.0
2015-05-21 18:00:00	SPY	ETF	213.45	213.5	213.34	213.4	130671.0
2015-05-21 19:00:00	SPY	ETF	213.41	213.45	213.29	213.35	62733.0
2015-05-21 04:00:00	QQQ	ETF	109.58	109.7	109.58	109.7	1450.0
2015-05-21 06:00:00	QQQ	ETF	109.63	109.65	109.62	109.62	12250.0
2015-05-21 07:00:00	QQQ	ETF	109.65	109.76	109.64	109.74	19851.0
2015-05-21 08:00:00	QQQ	ETF	109.77	109.77	109.65	109.72	117043.0
2015-05-21 09:00:00	QQQ	ETF	109.72	109.99	109.66	109.95	1977659.0
2015-05-21 10:00:00	QQQ	ETF	109.9404	110.46	109.87	110.4	2361001.0
2015-05-21 11:00:00	QQQ	ETF	110.41	110.64	110.41	110.53	2348660.0
2015-05-21 12:00:00	QQQ	ETF	110.535	110.68	110.4951	110.57	1735059.0
2015-05-21 13:00:00	QQQ	ETF	110.57	110.62	110.34	110.39	2166067.0
2015-05-21 14:00:00	QQQ	ETF	110.39	110.6549	110.36	110.585	952907.0
2015-05-21 15:00:00	QQQ	ETF	110.5865	110.73	110.42	110.56	3212582.0
2015-05-21 16:00:00	QQQ	ETF	110.58	110.59	110.52	110.55	515697.0
2015-05-21 17:00:00	QQQ	ETF	110.56	110.57	110.55	110.55	2405.0
2015-05-21 18:00:00	QQQ	ETF	110.57	110.59	110.53	110.56	6010.0
2015-05-21 19:00:00	QQQ	ETF	110.58	110.58	110.52	110.53	42800.0
2015-05-21 07:00:00	IWM	ETF	124.9	124.92	124.82	124.82	1650.0
2015-05-21 08:00:00	IWM	ETF	124.87	124.97	124.8	124.97	116684.0
2015-05-21 09:00:00	IWM	ETF	124.92	125.28	124.72	124.904	2254001.0
2015-05-21 10:00:00	IWM	ETF	124.89	125.47	124.81	125.36	2099357.0
2015-05-21 11:00:00	IWM	ETF	125.37	125.45	124.77	124.91	2351451.0
2015-05-21 12:00:00	IWM	ETF	124.91	125.13	124.81	124.94	1013459.0
2015-05-21 13:00:00	IWM	ETF	124.94	125.01	124.48	124.585	1952019.0
2015-05-21 14:00:00	IWM	ETF	124.585	125.01	124.57	124.84	994142.0
2015-05-21 15:00:00	IWM	ETF	124.85	125.22	124.74	124.94	3306008.0
2015-05-21 16:00:00	IWM	ETF	124.94	124.97	124.77	124.85	877256.0
2015-05-21 17:00:00	IWM	ETF	124.85	124.97	124.8	124.8	37280.0
2015-05-21 18:00:00	IWM	ETF	124.8	124.85	124.8	124.85	19076.0
2015-05-21 19:00:00	IWM	ETF	124.85	124.86	124.84	124.86	4617.0
2015-05-21 06:00:00	DIA	ETF	182.18	182.18	182.18	182.18	125.0
2015-05-21 08:00:00	DIA	ETF	182.47	182.47	182.47	182.47	100.0
2015-05-21 09:00:00	DIA	ETF	182.57	182.72	182.36	182.59	404296.0
2015-05-21 10:00:00	DIA	ETF	182.58	182.92	182.51	182.7	338032.0
2015-05-21 11:00:00	DIA	ETF	182.71	183.03	182.71	182.86	478122.0
2015-05-21 12:00:00	DIA	ETF	182.87	183.0	182.7885	182.89	179274.0

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

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