PREVIEW / etf_1hour / 2014-11-13

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-11-13.parquet
  size:    231 KB
  rows:    7,248

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-13 04:00:00	SPY	ETF	204.48	204.69	204.41	204.59	7318.0
2014-11-13 05:00:00	SPY	ETF	204.52	204.82	204.49	204.73	20099.0
2014-11-13 06:00:00	SPY	ETF	204.76	204.87	204.66	204.75	56139.0
2014-11-13 07:00:00	SPY	ETF	204.78	204.78	204.43	204.54	339281.0
2014-11-13 08:00:00	SPY	ETF	204.52	204.71	204.06	204.19	834833.0
2014-11-13 09:00:00	SPY	ETF	204.19	204.68	204.13	204.58	8790481.0
2014-11-13 10:00:00	SPY	ETF	204.58	204.83	204.36	204.65	10857774.0
2014-11-13 11:00:00	SPY	ETF	204.655	204.7	203.74	204.0699	14119208.0
2014-11-13 12:00:00	SPY	ETF	204.07	204.28	203.84	203.965	6592461.0
2014-11-13 13:00:00	SPY	ETF	203.9699	204.03	203.21	203.585	10903348.0
2014-11-13 14:00:00	SPY	ETF	203.585	203.87	203.26	203.685	9027441.0
2014-11-13 15:00:00	SPY	ETF	203.685	204.33	203.63	204.17	16427626.0
2014-11-13 16:00:00	SPY	ETF	204.18	204.21	203.85	203.9	3913359.0
2014-11-13 17:00:00	SPY	ETF	203.9	203.92	203.81	203.82	177010.0
2014-11-13 18:00:00	SPY	ETF	203.81	204.05	203.74	204.04	183679.0
2014-11-13 19:00:00	SPY	ETF	204.02	204.06	203.97	204.05	82406.0
2014-11-13 04:00:00	QQQ	ETF	102.68	102.88	102.68	102.88	2000.0
2014-11-13 05:00:00	QQQ	ETF	102.94	102.94	102.94	102.94	100.0
2014-11-13 06:00:00	QQQ	ETF	102.88	102.95	102.85	102.88	3500.0
2014-11-13 07:00:00	QQQ	ETF	102.84	102.85	102.74	102.81	68822.0
2014-11-13 08:00:00	QQQ	ETF	102.79	102.81	102.6	102.64	124407.0
2014-11-13 09:00:00	QQQ	ETF	102.64	103.12	102.46	103.1001	3530309.0
2014-11-13 10:00:00	QQQ	ETF	103.11	103.28	103.0161	103.15	3546717.0
2014-11-13 11:00:00	QQQ	ETF	103.16	103.17	102.63	102.82	3746212.0
2014-11-13 12:00:00	QQQ	ETF	102.82	103.11	102.71	103.0	1585997.0
2014-11-13 13:00:00	QQQ	ETF	103.0	103.04	102.42	102.73	3327108.0
2014-11-13 14:00:00	QQQ	ETF	102.73	102.83	102.47	102.71	2525222.0
2014-11-13 15:00:00	QQQ	ETF	102.7	102.925	102.66	102.89	3369336.0
2014-11-13 16:00:00	QQQ	ETF	102.89	102.91	102.69	102.74	2129582.0
2014-11-13 17:00:00	QQQ	ETF	102.75	102.77	102.69	102.69	10387.0
2014-11-13 18:00:00	QQQ	ETF	102.68	102.8	102.67	102.8	6500.0
2014-11-13 19:00:00	QQQ	ETF	102.8	102.85	102.8	102.81	7660.0
2014-11-13 04:00:00	IWM	ETF	118.14	118.25	118.14	118.25	500.0
2014-11-13 06:00:00	IWM	ETF	118.45	118.45	118.45	118.45	600.0
2014-11-13 07:00:00	IWM	ETF	118.3	118.3	118.14	118.21	9700.0
2014-11-13 08:00:00	IWM	ETF	118.2	118.2	117.91	118.01	49103.0
2014-11-13 09:00:00	IWM	ETF	117.97	118.25	117.88	118.12	1940278.0
2014-11-13 10:00:00	IWM	ETF	118.12	118.24	117.81	117.84	2614303.0
2014-11-13 11:00:00	IWM	ETF	117.84	117.85	116.93	117.245	4721598.0
2014-11-13 12:00:00	IWM	ETF	117.245	117.54	117.125	117.345	1629513.0
2014-11-13 13:00:00	IWM	ETF	117.34	117.4	116.78	116.97	2729428.0
2014-11-13 14:00:00	IWM	ETF	116.975	117.06	116.68	116.81	3016225.0
2014-11-13 15:00:00	IWM	ETF	116.815	117.13	116.62	116.91	5554204.0
2014-11-13 16:00:00	IWM	ETF	116.92	117.9	116.75	116.8	651159.0
2014-11-13 17:00:00	IWM	ETF	116.82	116.82	116.72	116.72	1200.0
2014-11-13 18:00:00	IWM	ETF	116.8	116.8	116.8	116.8	200.0
2014-11-13 07:00:00	DIA	ETF	176.44	176.44	176.44	176.44	286.0
2014-11-13 08:00:00	DIA	ETF	176.2	176.22	176.2	176.22	200.0
2014-11-13 09:00:00	DIA	ETF	176.28	176.71	176.15	176.635	1368463.0
2014-11-13 10:00:00	DIA	ETF	176.67	176.98	176.46	176.869	872532.0

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

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