PREVIEW / etf_1hour / 2014-02-07

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-02-07.parquet
  size:    223 KB
  rows:    6,920

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-02-07 04:00:00	SPY	ETF	177.47	177.78	177.46	177.76	61572.0
2014-02-07 05:00:00	SPY	ETF	177.74	177.76	177.63	177.69	56070.0
2014-02-07 06:00:00	SPY	ETF	177.66	177.76	177.54	177.76	101520.0
2014-02-07 07:00:00	SPY	ETF	177.65	177.91	177.65	177.89	276692.0
2014-02-07 08:00:00	SPY	ETF	177.89	178.62	176.35	178.43	14637989.0
2014-02-07 09:00:00	SPY	ETF	178.43	178.87	178.04	178.48	26471708.0
2014-02-07 10:00:00	SPY	ETF	178.48	178.7	177.73	178.291	27131866.0
2014-02-07 11:00:00	SPY	ETF	178.2999	178.93	178.15	178.93	14827560.0
2014-02-07 12:00:00	SPY	ETF	178.93	178.939	178.68	178.88	8360283.0
2014-02-07 13:00:00	SPY	ETF	178.87	179.44	178.86	179.37	14774009.0
2014-02-07 14:00:00	SPY	ETF	179.37	179.52	179.27	179.41	13057489.0
2014-02-07 15:00:00	SPY	ETF	179.42	179.87	179.42	179.69	31001449.0
2014-02-07 16:00:00	SPY	ETF	179.69	179.88	177.3921	179.7499	16714903.0
2014-02-07 17:00:00	SPY	ETF	179.81	179.88	179.77	179.85	1695133.0
2014-02-07 18:00:00	SPY	ETF	179.85	179.89	179.75	179.8	46459.0
2014-02-07 19:00:00	SPY	ETF	179.8	179.89	179.8	179.89	35463.0
2014-02-07 04:00:00	QQQ	ETF	85.91	86.02	85.91	86.02	633.0
2014-02-07 05:00:00	QQQ	ETF	86.0	86.0	85.99	85.99	200.0
2014-02-07 06:00:00	QQQ	ETF	86.01	86.06	85.95	86.02	3800.0
2014-02-07 07:00:00	QQQ	ETF	86.05	86.06	86.01	86.05	25410.0
2014-02-07 08:00:00	QQQ	ETF	86.08	86.31	85.4	86.25	746150.0
2014-02-07 09:00:00	QQQ	ETF	86.24	86.56	86.12	86.36	6417414.0
2014-02-07 10:00:00	QQQ	ETF	86.37	86.47	86.0	86.391	5920741.0
2014-02-07 11:00:00	QQQ	ETF	86.4	86.83	86.335	86.82	3548795.0
2014-02-07 12:00:00	QQQ	ETF	86.83	86.89	86.77	86.86	2559754.0
2014-02-07 13:00:00	QQQ	ETF	86.86	87.14	86.86	87.12	2971781.0
2014-02-07 14:00:00	QQQ	ETF	87.13	87.28	87.0701	87.12	4029867.0
2014-02-07 15:00:00	QQQ	ETF	87.12	87.359	87.12	87.27	6855501.0
2014-02-07 16:00:00	QQQ	ETF	87.28	87.4	86.316	87.38	3466696.0
2014-02-07 17:00:00	QQQ	ETF	85.77	87.45	85.77	87.4	29955.0
2014-02-07 18:00:00	QQQ	ETF	87.44	87.44	87.4	87.44	3650.0
2014-02-07 19:00:00	QQQ	ETF	87.44	87.44	87.37	87.44	3526.0
2014-02-07 05:00:00	IWM	ETF	109.61	109.61	109.61	109.61	400.0
2014-02-07 07:00:00	IWM	ETF	109.59	109.84	109.58	109.78	152300.0
2014-02-07 08:00:00	IWM	ETF	109.8	110.0	108.47	109.99	2287162.0
2014-02-07 09:00:00	IWM	ETF	109.99	110.67	109.59	110.37	7810712.0
2014-02-07 10:00:00	IWM	ETF	110.38	110.62	109.5	110.05	8917647.0
2014-02-07 11:00:00	IWM	ETF	110.07	110.57	109.975	110.51	5128593.0
2014-02-07 12:00:00	IWM	ETF	110.52	110.52	110.23	110.35	2143782.0
2014-02-07 13:00:00	IWM	ETF	110.35	110.6	110.25	110.51	3080547.0
2014-02-07 14:00:00	IWM	ETF	110.51	110.61	110.351	110.42	2419193.0
2014-02-07 15:00:00	IWM	ETF	110.43	110.835	110.42	110.745	6384904.0
2014-02-07 16:00:00	IWM	ETF	110.75	110.79	109.5867	110.74	3415107.0
2014-02-07 17:00:00	IWM	ETF	110.71	110.72	110.71	110.71	1200.0
2014-02-07 18:00:00	IWM	ETF	110.79	110.79	110.79	110.79	1200.0
2014-02-07 19:00:00	IWM	ETF	110.75	110.75	110.75	110.75	100.0
2014-02-07 06:00:00	DIA	ETF	156.2	156.2	156.2	156.2	1900.0
2014-02-07 07:00:00	DIA	ETF	156.21	156.37	156.21	156.37	16400.0
2014-02-07 08:00:00	DIA	ETF	156.39	156.69	155.1	156.69	81571.0
2014-02-07 09:00:00	DIA	ETF	156.67	157.01	156.36	156.71	1587526.0

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

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