PREVIEW / etf_1hour / 2013-02-14

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-02-14.parquet
  size:    194 KB
  rows:    6,083

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-02-14 04:00:00	SPY	ETF	152.04	152.1	151.99	151.99	2800.0
2013-02-14 05:00:00	SPY	ETF	151.85	151.85	151.51	151.51	25585.0
2013-02-14 06:00:00	SPY	ETF	151.5	151.62	151.4	151.57	89456.0
2013-02-14 07:00:00	SPY	ETF	151.57	151.8	151.51	151.75	2510421.0
2013-02-14 08:00:00	SPY	ETF	151.75	151.96	151.35	151.71	2252764.0
2013-02-14 09:00:00	SPY	ETF	151.7	151.99	151.52	151.83	11496224.0
2013-02-14 10:00:00	SPY	ETF	151.84	152.29	151.83	152.18	11427812.0
2013-02-14 11:00:00	SPY	ETF	152.18	152.25	151.99	152.11	6898875.0
2013-02-14 12:00:00	SPY	ETF	152.11	152.31	152.07	152.2871	6916774.0
2013-02-14 13:00:00	SPY	ETF	152.29	152.38	152.14	152.24	5950715.0
2013-02-14 14:00:00	SPY	ETF	152.235	152.44	152.2	152.345	6886029.0
2013-02-14 15:00:00	SPY	ETF	152.345	152.47	152.21	152.29	13025249.0
2013-02-14 16:00:00	SPY	ETF	152.3	152.4	152.2048	152.3188	10697797.0
2013-02-14 17:00:00	SPY	ETF	152.27	152.35	152.26	152.33	843052.0
2013-02-14 18:00:00	SPY	ETF	152.32	152.32	152.25	152.27	55199.0
2013-02-14 19:00:00	SPY	ETF	152.28	152.3	152.25	152.26	24050.0
2013-02-14 04:00:00	QQQ	ETF	67.85	67.85	67.8	67.8	400.0
2013-02-14 05:00:00	QQQ	ETF	67.75	67.75	67.65	67.66	1600.0
2013-02-14 06:00:00	QQQ	ETF	67.63	67.63	67.62	67.62	7700.0
2013-02-14 07:00:00	QQQ	ETF	67.65	67.73	67.64	67.73	18920.0
2013-02-14 08:00:00	QQQ	ETF	67.66	67.81	67.53	67.71	99775.0
2013-02-14 09:00:00	QQQ	ETF	67.71	67.83	67.62	67.67	3786613.0
2013-02-14 10:00:00	QQQ	ETF	67.6799	67.94	67.67	67.89	4725633.0
2013-02-14 11:00:00	QQQ	ETF	67.89	67.9201	67.83	67.88	2398462.0
2013-02-14 12:00:00	QQQ	ETF	67.87	68.031	67.86	68.03	1595083.0
2013-02-14 13:00:00	QQQ	ETF	68.028	68.05	67.92	67.96	2049327.0
2013-02-14 14:00:00	QQQ	ETF	67.96	68.04	67.91	67.94	3178339.0
2013-02-14 15:00:00	QQQ	ETF	67.94	68.02	67.87	67.94	4624435.0
2013-02-14 16:00:00	QQQ	ETF	67.94	67.95	67.8827	67.91	1705790.0
2013-02-14 17:00:00	QQQ	ETF	67.91	67.95	67.91	67.95	17950.0
2013-02-14 18:00:00	QQQ	ETF	67.95	67.95	67.93	67.93	15450.0
2013-02-14 19:00:00	QQQ	ETF	67.94	67.94	67.94	67.94	3000.0
2013-02-14 05:00:00	IWM	ETF	91.2	91.2	91.2	91.2	400.0
2013-02-14 06:00:00	IWM	ETF	91.11	91.12	91.08	91.12	34760.0
2013-02-14 07:00:00	IWM	ETF	91.12	91.27	91.1	91.24	42600.0
2013-02-14 08:00:00	IWM	ETF	91.24	91.39	91.04	91.21	352385.0
2013-02-14 09:00:00	IWM	ETF	91.24	91.52	91.16	91.38	3537681.0
2013-02-14 10:00:00	IWM	ETF	91.38	91.65	91.35	91.62	3688434.0
2013-02-14 11:00:00	IWM	ETF	91.62	91.68	91.5	91.65	1544667.0
2013-02-14 12:00:00	IWM	ETF	91.66	91.79	91.62	91.74	1741819.0
2013-02-14 13:00:00	IWM	ETF	91.74	91.82	91.6135	91.74	1199085.0
2013-02-14 14:00:00	IWM	ETF	91.735	91.8	91.68	91.752	1052516.0
2013-02-14 15:00:00	IWM	ETF	91.76	91.875	91.68	91.69	5082121.0
2013-02-14 16:00:00	IWM	ETF	91.69	91.74	91.62	91.63	1179591.0
2013-02-14 17:00:00	IWM	ETF	91.7	91.7	91.63	91.63	24788.0
2013-02-14 18:00:00	IWM	ETF	91.72	91.72	91.72	91.72	1000.0
2013-02-14 19:00:00	IWM	ETF	91.64	91.64	91.64	91.64	9800.0
2013-02-14 05:00:00	DIA	ETF	139.35	139.35	139.35	139.35	100.0
2013-02-14 08:00:00	DIA	ETF	139.47	139.49	139.42	139.42	7346.0
2013-02-14 09:00:00	DIA	ETF	139.4	139.78	139.2601	139.71	580556.0

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

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