PREVIEW / etf_1hour / 2013-11-19

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-11-19.parquet
  size:    210 KB
  rows:    6,635

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
2013-11-19 04:00:00	SPY	ETF	179.22	179.32	179.09	179.17	32156.0
2013-11-19 05:00:00	SPY	ETF	179.17	179.21	178.99	179.16	84011.0
2013-11-19 06:00:00	SPY	ETF	179.15	179.26	179.1	179.13	170650.0
2013-11-19 07:00:00	SPY	ETF	179.13	179.16	178.94	179.08	376395.0
2013-11-19 08:00:00	SPY	ETF	179.07	179.33	178.96	179.29	461649.0
2013-11-19 09:00:00	SPY	ETF	179.28	179.49	178.88	179.39	12046259.0
2013-11-19 10:00:00	SPY	ETF	179.39	179.87	179.38	179.685	14641087.0
2013-11-19 11:00:00	SPY	ETF	179.69	179.71	179.14	179.3799	9609054.0
2013-11-19 12:00:00	SPY	ETF	179.38	179.7	179.31	179.33	7591306.0
2013-11-19 13:00:00	SPY	ETF	179.325	179.36	178.75	178.82	12009928.0
2013-11-19 14:00:00	SPY	ETF	178.82	179.4406	178.72	179.07	14430618.0
2013-11-19 15:00:00	SPY	ETF	179.07	179.45	178.92	179.04	16243034.0
2013-11-19 16:00:00	SPY	ETF	179.05	179.4406	178.97	179.06	3969941.0
2013-11-19 17:00:00	SPY	ETF	179.04	179.06	179.0	179.03	22993.0
2013-11-19 18:00:00	SPY	ETF	179.05	179.52	179.03	179.34	600874.0
2013-11-19 19:00:00	SPY	ETF	179.32	179.33	178.95	178.95	221705.0
2013-11-19 05:00:00	QQQ	ETF	82.9	82.9	82.9	82.9	100.0
2013-11-19 06:00:00	QQQ	ETF	83.02	83.07	82.98	82.98	24000.0
2013-11-19 07:00:00	QQQ	ETF	82.99	83.01	82.92	83.01	26100.0
2013-11-19 08:00:00	QQQ	ETF	83.01	83.15	82.94	83.11	43441.0
2013-11-19 09:00:00	QQQ	ETF	83.1	83.33	82.91	83.32	5750500.0
2013-11-19 10:00:00	QQQ	ETF	83.32	83.49	83.225	83.305	3911886.0
2013-11-19 11:00:00	QQQ	ETF	83.31	83.34	83.08	83.209	2284638.0
2013-11-19 12:00:00	QQQ	ETF	83.2001	83.3693	83.09	83.09	1661498.0
2013-11-19 13:00:00	QQQ	ETF	83.09	83.11	82.76	82.8099	3172792.0
2013-11-19 14:00:00	QQQ	ETF	82.8	83.04	82.76	82.95	3603678.0
2013-11-19 15:00:00	QQQ	ETF	82.94	83.15	82.86	82.91	4186053.0
2013-11-19 16:00:00	QQQ	ETF	82.91	83.214	82.85	82.88	614826.0
2013-11-19 17:00:00	QQQ	ETF	82.9	82.9	82.87	82.89	7300.0
2013-11-19 18:00:00	QQQ	ETF	82.89	83.07	82.89	83.02	12371.0
2013-11-19 19:00:00	QQQ	ETF	82.95	82.95	82.9	82.9	11810.0
2013-11-19 05:00:00	IWM	ETF	110.0	110.0	110.0	110.0	300.0
2013-11-19 06:00:00	IWM	ETF	110.03	110.05	109.95	109.95	5300.0
2013-11-19 07:00:00	IWM	ETF	109.91	109.91	109.82	109.9	18400.0
2013-11-19 08:00:00	IWM	ETF	109.91	110.11	109.82	110.07	202337.0
2013-11-19 09:00:00	IWM	ETF	110.04	110.41	109.56	110.21	5520727.0
2013-11-19 10:00:00	IWM	ETF	110.21	110.67	110.19	110.61	4861123.0
2013-11-19 11:00:00	IWM	ETF	110.6	110.69	110.04	110.15	3567177.0
2013-11-19 12:00:00	IWM	ETF	110.16	110.38	109.86	109.87	2495713.0
2013-11-19 13:00:00	IWM	ETF	109.88	109.93	109.14	109.23	5593020.0
2013-11-19 14:00:00	IWM	ETF	109.22	109.58	108.99	109.395	4707272.0
2013-11-19 15:00:00	IWM	ETF	109.39	109.72	109.23	109.41	5228828.0
2013-11-19 16:00:00	IWM	ETF	109.41	109.4906	109.355	109.47	822787.0
2013-11-19 17:00:00	IWM	ETF	109.51	109.51	109.51	109.51	200.0
2013-11-19 18:00:00	IWM	ETF	109.46	109.71	109.46	109.66	6325.0
2013-11-19 19:00:00	IWM	ETF	109.62	109.69	109.5	109.52	6616.0
2013-11-19 06:00:00	DIA	ETF	159.45	159.45	159.45	159.45	100.0
2013-11-19 07:00:00	DIA	ETF	159.37	159.37	159.27	159.31	9200.0
2013-11-19 08:00:00	DIA	ETF	159.32	159.58	159.32	159.58	7600.0
2013-11-19 09:00:00	DIA	ETF	159.61	159.75	159.26	159.55	829893.0

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

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