PREVIEW / etf_1hour / 2014-11-21

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-11-21.parquet
  size:    240 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
2014-11-21 04:00:00	SPY	ETF	206.25	206.43	205.7	206.3	6911.0
2014-11-21 05:00:00	SPY	ETF	206.3	207.27	206.24	206.94	135467.0
2014-11-21 06:00:00	SPY	ETF	206.89	207.18	206.77	207.01	119307.0
2014-11-21 07:00:00	SPY	ETF	207.0	207.37	206.89	207.3	1132629.0
2014-11-21 08:00:00	SPY	ETF	207.3	207.56	205.91	207.41	2935904.0
2014-11-21 09:00:00	SPY	ETF	207.41	207.8445	207.26	207.39	28417881.0
2014-11-21 10:00:00	SPY	ETF	207.395	207.43	206.95	207.04	18706637.0
2014-11-21 11:00:00	SPY	ETF	207.044	207.05	206.73	206.8101	18100341.0
2014-11-21 12:00:00	SPY	ETF	206.81	206.9	206.4016	206.49	11644905.0
2014-11-21 13:00:00	SPY	ETF	206.485	206.56	205.98	206.43	13111688.0
2014-11-21 14:00:00	SPY	ETF	206.44	206.55	206.1	206.42	7904123.0
2014-11-21 15:00:00	SPY	ETF	206.42	206.79	206.395	206.68	17996030.0
2014-11-21 16:00:00	SPY	ETF	206.69	206.81	205.98	206.66	11287950.0
2014-11-21 17:00:00	SPY	ETF	206.66	206.81	206.62	206.8	2833651.0
2014-11-21 18:00:00	SPY	ETF	206.8	206.87	206.7	206.72	106752.0
2014-11-21 19:00:00	SPY	ETF	206.74	206.78	206.73	206.74	43324.0
2014-11-21 04:00:00	QQQ	ETF	103.82	104.04	103.82	104.04	1300.0
2014-11-21 05:00:00	QQQ	ETF	104.03	104.5	104.03	104.37	23300.0
2014-11-21 06:00:00	QQQ	ETF	104.36	104.51	104.3	104.42	28100.0
2014-11-21 07:00:00	QQQ	ETF	104.4	104.53	104.38	104.53	102996.0
2014-11-21 08:00:00	QQQ	ETF	104.49	104.67	104.44	104.54	354674.0
2014-11-21 09:00:00	QQQ	ETF	104.56	104.69	104.31	104.39	6111663.0
2014-11-21 10:00:00	QQQ	ETF	104.38	104.45	104.0	104.14	4236101.0
2014-11-21 11:00:00	QQQ	ETF	104.13	104.205	103.9	104.0222	2789049.0
2014-11-21 12:00:00	QQQ	ETF	104.029	104.136	103.89	103.93	2148703.0
2014-11-21 13:00:00	QQQ	ETF	103.92	103.975	103.54	103.84	3482948.0
2014-11-21 14:00:00	QQQ	ETF	103.84	103.93	103.57	103.8199	2810719.0
2014-11-21 15:00:00	QQQ	ETF	103.81	103.96	103.74	103.88	4066086.0
2014-11-21 16:00:00	QQQ	ETF	103.88	104.002	103.6688	103.85	2221209.0
2014-11-21 17:00:00	QQQ	ETF	103.83	103.84	103.82	103.84	5300.0
2014-11-21 18:00:00	QQQ	ETF	103.87	103.88	103.87	103.88	800.0
2014-11-21 19:00:00	QQQ	ETF	103.84	103.85	103.82	103.85	1070.0
2014-11-21 20:00:00	QQQ	ETF	103.8989	103.8989	103.8989	103.8989	700000.0
2014-11-21 04:00:00	IWM	ETF	117.01	117.19	117.01	117.02	638.0
2014-11-21 06:00:00	IWM	ETF	117.81	117.81	117.74	117.74	600.0
2014-11-21 07:00:00	IWM	ETF	117.71	118.11	117.42	118.06	226680.0
2014-11-21 08:00:00	IWM	ETF	118.05	118.25	117.95	118.24	443798.0
2014-11-21 09:00:00	IWM	ETF	118.25	118.33	117.33	117.58	5228753.0
2014-11-21 10:00:00	IWM	ETF	117.58	117.7	117.09	117.13	3352200.0
2014-11-21 11:00:00	IWM	ETF	117.12	117.3	116.9	117.2099	3055421.0
2014-11-21 12:00:00	IWM	ETF	117.203	117.36	117.03	117.195	2776015.0
2014-11-21 13:00:00	IWM	ETF	117.2	117.2	116.63	116.66	3529166.0
2014-11-21 14:00:00	IWM	ETF	116.655	116.8	116.16	116.67	6923543.0
2014-11-21 15:00:00	IWM	ETF	116.68	116.96	116.42	116.56	6477491.0
2014-11-21 16:00:00	IWM	ETF	116.56	116.9218	116.5	116.56	1154286.0
2014-11-21 17:00:00	IWM	ETF	116.57	116.57	116.47	116.47	5100.0
2014-11-21 19:00:00	IWM	ETF	116.55	116.55	116.55	116.55	128.0
2014-11-21 07:00:00	DIA	ETF	178.0	178.16	178.0	178.16	7215.0
2014-11-21 08:00:00	DIA	ETF	178.0	178.35	178.0	178.27	30511.0
2014-11-21 09:00:00	DIA	ETF	178.38	178.6	178.2851	178.42	937091.0

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

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