PREVIEW / etf_1hour / 2015-04-29

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-04-29.parquet
  size:    241 KB
  rows:    7,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
2015-04-29 04:00:00	SPY	ETF	211.56	211.71	211.53	211.69	1725.0
2015-04-29 05:00:00	SPY	ETF	211.54	211.57	211.46	211.47	9800.0
2015-04-29 06:00:00	SPY	ETF	211.49	211.55	211.43	211.43	38415.0
2015-04-29 07:00:00	SPY	ETF	211.44	211.5	211.13	211.24	334118.0
2015-04-29 08:00:00	SPY	ETF	211.24	211.42	210.28	210.42	2516653.0
2015-04-29 09:00:00	SPY	ETF	210.42	211.21	210.04	210.82	12795432.0
2015-04-29 10:00:00	SPY	ETF	210.822	210.98	210.1	210.56	20647656.0
2015-04-29 11:00:00	SPY	ETF	210.57	210.95	210.31	210.46	16250100.0
2015-04-29 12:00:00	SPY	ETF	210.46	210.52	209.6	210.14	13116315.0
2015-04-29 13:00:00	SPY	ETF	210.15	210.72	209.78	210.58	11120699.0
2015-04-29 14:00:00	SPY	ETF	210.57	211.29	210.07	210.83	22168645.0
2015-04-29 15:00:00	SPY	ETF	210.84	210.97	210.28	210.55	18585096.0
2015-04-29 16:00:00	SPY	ETF	210.56	211.3661	210.29	210.38	6397333.0
2015-04-29 17:00:00	SPY	ETF	210.37	210.39	210.33	210.37	156293.0
2015-04-29 18:00:00	SPY	ETF	210.36	210.45	210.28	210.31	80481.0
2015-04-29 19:00:00	SPY	ETF	210.3	210.34	210.22	210.25	36989.0
2015-04-29 06:00:00	QQQ	ETF	109.95	109.98	109.95	109.96	4900.0
2015-04-29 07:00:00	QQQ	ETF	109.94	109.94	109.8	109.89	20090.0
2015-04-29 08:00:00	QQQ	ETF	109.89	109.92	109.48	109.53	461377.0
2015-04-29 09:00:00	QQQ	ETF	109.53	110.07	109.29	109.81	3867512.0
2015-04-29 10:00:00	QQQ	ETF	109.82	109.91	109.35	109.5	5659241.0
2015-04-29 11:00:00	QQQ	ETF	109.5	109.75	109.35	109.395	2895844.0
2015-04-29 12:00:00	QQQ	ETF	109.4	109.43	108.75	109.06	5153880.0
2015-04-29 13:00:00	QQQ	ETF	109.06	109.51	108.88	109.4372	2403297.0
2015-04-29 14:00:00	QQQ	ETF	109.44	109.83	109.05	109.62	6103636.0
2015-04-29 15:00:00	QQQ	ETF	109.6201	109.68	109.255	109.34	3593636.0
2015-04-29 16:00:00	QQQ	ETF	109.35	109.36	109.16	109.16	857133.0
2015-04-29 17:00:00	QQQ	ETF	109.18	109.2	109.15	109.18	4382.0
2015-04-29 18:00:00	QQQ	ETF	109.19	109.19	109.12	109.12	18567.0
2015-04-29 19:00:00	QQQ	ETF	109.13	109.14	109.05	109.06	33489.0
2015-04-29 07:00:00	IWM	ETF	124.97	125.17	124.86	125.16	24300.0
2015-04-29 08:00:00	IWM	ETF	125.07	125.08	124.55	124.62	237328.0
2015-04-29 09:00:00	IWM	ETF	124.61	124.9	124.27	124.42	2623790.0
2015-04-29 10:00:00	IWM	ETF	124.42	124.61	124.165	124.56	2932607.0
2015-04-29 11:00:00	IWM	ETF	124.55	124.85	124.23	124.34	1721294.0
2015-04-29 12:00:00	IWM	ETF	124.345	124.4	123.63	123.92	3356017.0
2015-04-29 13:00:00	IWM	ETF	123.92	124.23	123.69	124.13	2426362.0
2015-04-29 14:00:00	IWM	ETF	124.12	124.57	123.77	124.27	5293406.0
2015-04-29 15:00:00	IWM	ETF	124.27	124.365	123.82	123.83	4451022.0
2015-04-29 16:00:00	IWM	ETF	123.82	123.9348	123.38	123.39	938558.0
2015-04-29 17:00:00	IWM	ETF	123.4	123.48	123.4	123.43	20221.0
2015-04-29 18:00:00	IWM	ETF	123.54	123.58	123.46	123.58	4000.0
2015-04-29 19:00:00	IWM	ETF	123.53	123.62	123.53	123.62	3245.0
2015-04-29 07:00:00	DIA	ETF	180.68	180.68	180.45	180.45	850.0
2015-04-29 08:00:00	DIA	ETF	180.57	180.57	179.88	179.95	14450.0
2015-04-29 09:00:00	DIA	ETF	179.95	180.7	179.439	180.29	881710.0
2015-04-29 10:00:00	DIA	ETF	180.33	180.47	179.79	180.26	919640.0
2015-04-29 11:00:00	DIA	ETF	180.26	180.61	179.98	180.1	523410.0
2015-04-29 12:00:00	DIA	ETF	180.1	180.17	179.24	179.8	849662.0
2015-04-29 13:00:00	DIA	ETF	179.8264	180.28	179.47	180.14	436464.0

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

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