PREVIEW / etf_1hour / 2014-11-14

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-11-14.parquet
  size:    228 KB
  rows:    7,202

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-14 04:00:00	SPY	ETF	203.97	204.38	203.97	204.3	23868.0
2014-11-14 05:00:00	SPY	ETF	204.35	204.35	204.13	204.14	8490.0
2014-11-14 06:00:00	SPY	ETF	204.18	204.18	203.84	203.89	38430.0
2014-11-14 07:00:00	SPY	ETF	203.92	204.02	203.79	203.98	164524.0
2014-11-14 08:00:00	SPY	ETF	203.92	204.29	203.92	204.07	1120150.0
2014-11-14 09:00:00	SPY	ETF	204.08	204.28	203.86	204.1	8713578.0
2014-11-14 10:00:00	SPY	ETF	204.1	204.49	203.76	204.28	13784102.0
2014-11-14 11:00:00	SPY	ETF	204.29	204.38	204.03	204.16	9232981.0
2014-11-14 12:00:00	SPY	ETF	204.16	204.27	204.02	204.09	5760173.0
2014-11-14 13:00:00	SPY	ETF	204.08	204.16	203.85	203.855	5684063.0
2014-11-14 14:00:00	SPY	ETF	203.86	204.22	203.72	203.95	6153903.0
2014-11-14 15:00:00	SPY	ETF	203.95	204.2599	203.94	204.25	15811569.0
2014-11-14 16:00:00	SPY	ETF	204.25	204.36	203.9771	204.36	13072214.0
2014-11-14 17:00:00	SPY	ETF	204.36	204.43	204.34	204.38	158708.0
2014-11-14 18:00:00	SPY	ETF	204.38	204.44	204.37	204.41	48190.0
2014-11-14 19:00:00	SPY	ETF	204.42	204.53	204.39	204.52	33144.0
2014-11-14 04:00:00	QQQ	ETF	102.8	102.9	102.8	102.9	7500.0
2014-11-14 05:00:00	QQQ	ETF	102.9	102.9	102.87	102.87	10600.0
2014-11-14 06:00:00	QQQ	ETF	102.88	102.88	102.77	102.77	8600.0
2014-11-14 07:00:00	QQQ	ETF	102.78	102.85	102.73	102.75	52845.0
2014-11-14 08:00:00	QQQ	ETF	102.78	102.93	102.75	102.83	138662.0
2014-11-14 09:00:00	QQQ	ETF	102.82	102.97	102.59	102.77	3226142.0
2014-11-14 10:00:00	QQQ	ETF	102.77	103.09	102.53	103.06	3852143.0
2014-11-14 11:00:00	QQQ	ETF	103.075	103.17	102.97	103.06	1699338.0
2014-11-14 12:00:00	QQQ	ETF	103.07	103.16	102.99	103.08	1114521.0
2014-11-14 13:00:00	QQQ	ETF	103.08	103.16	102.93	102.94	1297337.0
2014-11-14 14:00:00	QQQ	ETF	102.935	103.06	102.81	103.014	1856928.0
2014-11-14 15:00:00	QQQ	ETF	103.01	103.21	103.0	103.2	3539724.0
2014-11-14 16:00:00	QQQ	ETF	103.2	103.22	102.943	103.22	1370750.0
2014-11-14 17:00:00	QQQ	ETF	103.21	103.24	103.15	103.2	12752.0
2014-11-14 18:00:00	QQQ	ETF	103.21	103.24	103.17	103.17	572.0
2014-11-14 19:00:00	QQQ	ETF	103.22	103.33	103.22	103.32	11655.0
2014-11-14 07:00:00	IWM	ETF	116.9	116.9	116.7	116.74	15900.0
2014-11-14 08:00:00	IWM	ETF	116.84	117.04	116.8	116.98	80650.0
2014-11-14 09:00:00	IWM	ETF	116.97	117.09	116.37	116.57	2790025.0
2014-11-14 10:00:00	IWM	ETF	116.585	117.21	116.55	116.9	3801036.0
2014-11-14 11:00:00	IWM	ETF	116.91	117.06	116.63	116.7499	2299900.0
2014-11-14 12:00:00	IWM	ETF	116.75	116.89	116.7	116.76	1293815.0
2014-11-14 13:00:00	IWM	ETF	116.76	116.81	116.63	116.645	1276988.0
2014-11-14 14:00:00	IWM	ETF	116.64	116.84	116.56	116.75	1521532.0
2014-11-14 15:00:00	IWM	ETF	116.75	116.89	116.59	116.68	3945556.0
2014-11-14 16:00:00	IWM	ETF	116.69	116.79	116.66	116.77	4405340.0
2014-11-14 19:00:00	IWM	ETF	116.75	116.75	116.75	116.75	100.0
2014-11-14 08:00:00	DIA	ETF	176.47	176.47	176.4	176.4	300.0
2014-11-14 09:00:00	DIA	ETF	176.45	176.5399	176.27	176.44	635952.0
2014-11-14 10:00:00	DIA	ETF	176.45	176.65	176.17	176.49	783366.0
2014-11-14 11:00:00	DIA	ETF	176.51	176.58	176.33	176.39	297700.0
2014-11-14 12:00:00	DIA	ETF	176.38	176.44	176.25	176.31	221614.0
2014-11-14 13:00:00	DIA	ETF	176.3	176.3875	176.2	176.21	230974.0
2014-11-14 14:00:00	DIA	ETF	176.2	176.28	176.12	176.183	455125.0

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

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