PREVIEW / etf_1hour / 2014-01-21

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-01-21.parquet
  size:    220 KB
  rows:    6,948

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-01-21 04:00:00	SPY	ETF	184.15	184.3	184.13	184.15	108550.0
2014-01-21 05:00:00	SPY	ETF	184.12	184.35	184.12	184.26	30357.0
2014-01-21 06:00:00	SPY	ETF	184.27	184.4	184.27	184.3	98741.0
2014-01-21 07:00:00	SPY	ETF	184.34	184.47	184.24	184.39	196674.0
2014-01-21 08:00:00	SPY	ETF	184.39	184.72	183.63	184.57	507124.0
2014-01-21 09:00:00	SPY	ETF	184.54	184.77	184.5	184.59	10090306.0
2014-01-21 10:00:00	SPY	ETF	184.58	184.62	183.83	184.01	13463886.0
2014-01-21 11:00:00	SPY	ETF	184.01	184.07	183.09	183.36	15336743.0
2014-01-21 12:00:00	SPY	ETF	183.36	183.74	183.05	183.74	9631778.0
2014-01-21 13:00:00	SPY	ETF	183.74	184.195	183.73	184.05	7053848.0
2014-01-21 14:00:00	SPY	ETF	184.05	184.24	183.91	184.06	7055731.0
2014-01-21 15:00:00	SPY	ETF	184.06	184.23	183.89	184.19	16100150.0
2014-01-21 16:00:00	SPY	ETF	184.19	184.29	183.695	183.695	7830001.0
2014-01-21 17:00:00	SPY	ETF	184.11	184.15	184.09	184.12	51620.0
2014-01-21 18:00:00	SPY	ETF	184.13	184.13	184.02	184.05	42842.0
2014-01-21 19:00:00	SPY	ETF	184.05	184.14	184.05	184.14	29218.0
2014-01-21 04:00:00	QQQ	ETF	88.24	88.33	88.01	88.25	3300.0
2014-01-21 05:00:00	QQQ	ETF	88.31	88.31	88.28	88.28	400.0
2014-01-21 06:00:00	QQQ	ETF	88.32	88.4	88.32	88.38	14140.0
2014-01-21 07:00:00	QQQ	ETF	88.33	88.41	88.31	88.39	109881.0
2014-01-21 08:00:00	QQQ	ETF	88.36	88.4	88.35	88.39	98703.0
2014-01-21 09:00:00	QQQ	ETF	88.39	88.59	88.39	88.54	4329143.0
2014-01-21 10:00:00	QQQ	ETF	88.53	88.55	88.12	88.27	5088983.0
2014-01-21 11:00:00	QQQ	ETF	88.265	88.3	87.81	88.08	3770583.0
2014-01-21 12:00:00	QQQ	ETF	88.08	88.3	87.91	88.29	1907240.0
2014-01-21 13:00:00	QQQ	ETF	88.2874	88.4897	88.27	88.4199	1741917.0
2014-01-21 14:00:00	QQQ	ETF	88.42	88.52	88.36	88.46	1551072.0
2014-01-21 15:00:00	QQQ	ETF	88.46	88.56	88.38	88.56	4263243.0
2014-01-21 16:00:00	QQQ	ETF	88.56	88.6	88.3271	88.49	1505720.0
2014-01-21 17:00:00	QQQ	ETF	87.85	88.5	87.85	88.47	15672.0
2014-01-21 18:00:00	QQQ	ETF	88.5	88.5	88.43	88.44	7120.0
2014-01-21 19:00:00	QQQ	ETF	88.45	88.5	88.45	88.48	15988.0
2014-01-21 04:00:00	IWM	ETF	116.4	116.4	116.4	116.4	100.0
2014-01-21 06:00:00	IWM	ETF	116.57	116.57	116.57	116.57	100.0
2014-01-21 07:00:00	IWM	ETF	116.57	116.67	116.49	116.66	55442.0
2014-01-21 08:00:00	IWM	ETF	116.58	116.66	116.56	116.64	135392.0
2014-01-21 09:00:00	IWM	ETF	116.64	116.87	116.63	116.775	2414104.0
2014-01-21 10:00:00	IWM	ETF	116.76	116.8	116.18	116.33	3953376.0
2014-01-21 11:00:00	IWM	ETF	116.33	116.38	115.78	116.1	3629192.0
2014-01-21 12:00:00	IWM	ETF	116.09	116.37	115.86	116.355	2573828.0
2014-01-21 13:00:00	IWM	ETF	116.36	116.62	116.36	116.4975	1857545.0
2014-01-21 14:00:00	IWM	ETF	116.5	116.62	116.4	116.49	1227417.0
2014-01-21 15:00:00	IWM	ETF	116.49	116.67	116.4	116.65	4633165.0
2014-01-21 16:00:00	IWM	ETF	116.65	116.73	116.45	116.53	7105568.0
2014-01-21 18:00:00	IWM	ETF	116.55	116.55	116.54	116.54	3500.0
2014-01-21 19:00:00	IWM	ETF	116.54	116.54	116.54	116.54	500.0
2014-01-21 04:00:00	DIA	ETF	164.63	164.63	164.63	164.63	100.0
2014-01-21 06:00:00	DIA	ETF	164.75	164.75	164.75	164.75	2000.0
2014-01-21 07:00:00	DIA	ETF	164.61	164.8	164.61	164.8	1150.0
2014-01-21 08:00:00	DIA	ETF	164.75	164.999	164.75	164.82	3510.0

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

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