PREVIEW / etf_1hour / 2014-04-04

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-04-04.parquet
  size:    222 KB
  rows:    6,982

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-04-04 04:00:00	SPY	ETF	189.05	189.13	189.01	189.13	22563.0
2014-04-04 05:00:00	SPY	ETF	189.12	189.2	189.12	189.15	12237.0
2014-04-04 06:00:00	SPY	ETF	189.17	189.2	189.04	189.09	76612.0
2014-04-04 07:00:00	SPY	ETF	189.07	189.21	189.04	189.16	258838.0
2014-04-04 08:00:00	SPY	ETF	189.15	189.68	188.72	189.54	3672555.0
2014-04-04 09:00:00	SPY	ETF	189.54	189.74	188.66	188.98	19011150.0
2014-04-04 10:00:00	SPY	ETF	188.98	189.55	188.97	189.05	21121631.0
2014-04-04 11:00:00	SPY	ETF	189.045	189.06	187.72	188.0201	25094287.0
2014-04-04 12:00:00	SPY	ETF	188.03	188.045	187.02	187.17	19030161.0
2014-04-04 13:00:00	SPY	ETF	187.18	189.25	186.86	186.965	16297876.0
2014-04-04 14:00:00	SPY	ETF	186.96	187.1	186.1	186.585	20645131.0
2014-04-04 15:00:00	SPY	ETF	186.58	186.89	186.2	186.39	28917529.0
2014-04-04 16:00:00	SPY	ETF	186.41	189.0458	186.31	186.69	10283008.0
2014-04-04 17:00:00	SPY	ETF	186.68	186.72	186.52	186.53	293754.0
2014-04-04 18:00:00	SPY	ETF	186.57	186.57	186.36	186.47	152698.0
2014-04-04 19:00:00	SPY	ETF	186.47	186.59	186.45	186.59	92420.0
2014-04-04 05:00:00	QQQ	ETF	88.94	88.98	88.94	88.97	3000.0
2014-04-04 06:00:00	QQQ	ETF	88.94	88.96	88.94	88.96	3025.0
2014-04-04 07:00:00	QQQ	ETF	88.97	89.04	88.97	89.02	39400.0
2014-04-04 08:00:00	QQQ	ETF	89.02	89.3	88.95	89.2	908034.0
2014-04-04 09:00:00	QQQ	ETF	89.19	89.41	88.02	88.35	12464336.0
2014-04-04 10:00:00	QQQ	ETF	88.35	88.84	87.85	87.87	14354128.0
2014-04-04 11:00:00	QQQ	ETF	87.88	87.89	86.95	87.1499	13904201.0
2014-04-04 12:00:00	QQQ	ETF	87.14	87.15	86.5	86.62	13974455.0
2014-04-04 13:00:00	QQQ	ETF	86.6196	86.88	86.46	86.62	8215675.0
2014-04-04 14:00:00	QQQ	ETF	86.62	86.75	86.14	86.46	10875129.0
2014-04-04 15:00:00	QQQ	ETF	86.45	86.73	86.22	86.34	13633108.0
2014-04-04 16:00:00	QQQ	ETF	86.35	88.7287	86.33	86.55	15320039.0
2014-04-04 17:00:00	QQQ	ETF	88.7287	88.7287	86.37	86.5	9062566.0
2014-04-04 18:00:00	QQQ	ETF	86.5	86.58	86.41	86.54	23968.0
2014-04-04 19:00:00	QQQ	ETF	86.5	86.56	86.43	86.55	17608.0
2014-04-04 07:00:00	IWM	ETF	117.54	117.55	117.52	117.55	18200.0
2014-04-04 08:00:00	IWM	ETF	117.53	117.98	117.4	117.79	1458297.0
2014-04-04 09:00:00	IWM	ETF	117.86	118.12	116.96	117.22	6632656.0
2014-04-04 10:00:00	IWM	ETF	117.23	117.92	117.21	117.25	6776140.0
2014-04-04 11:00:00	IWM	ETF	117.24	117.32	115.04	115.312	13619018.0
2014-04-04 12:00:00	IWM	ETF	115.31	115.32	114.34	114.52	14108653.0
2014-04-04 13:00:00	IWM	ETF	114.515	114.99	114.21	114.55	7884241.0
2014-04-04 14:00:00	IWM	ETF	114.54	114.72	114.02	114.48	9277036.0
2014-04-04 15:00:00	IWM	ETF	114.48	114.86	114.26	114.49	11006898.0
2014-04-04 16:00:00	IWM	ETF	114.51	117.2427	114.49	114.7	2633790.0
2014-04-04 17:00:00	IWM	ETF	114.69	114.71	114.6	114.7	6290.0
2014-04-04 18:00:00	IWM	ETF	114.65	114.7	114.53	114.61	19631.0
2014-04-04 19:00:00	IWM	ETF	114.64	114.76	114.64	114.76	19884.0
2014-04-04 06:00:00	DIA	ETF	165.64	165.64	165.64	165.64	100.0
2014-04-04 07:00:00	DIA	ETF	165.73	165.73	165.73	165.73	100.0
2014-04-04 08:00:00	DIA	ETF	165.7	166.15	165.7	166.02	35604.0
2014-04-04 09:00:00	DIA	ETF	166.04	166.18	165.38	165.59	1002485.0
2014-04-04 10:00:00	DIA	ETF	165.59	166.02	165.59	165.75	1449340.0
2014-04-04 11:00:00	DIA	ETF	165.73	165.73	164.95	165.24	1685697.0

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

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