PREVIEW / etf_1hour / 2011-08-18

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-18.parquet
  size:    193 KB
  rows:    6,004

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
2011-08-18 04:00:00	SPY	ETF	118.35	118.35	117.7	117.81	41294.0
2011-08-18 05:00:00	SPY	ETF	117.73	117.73	117.0	117.4	251532.0
2011-08-18 06:00:00	SPY	ETF	117.48	117.54	117.05	117.46	257129.0
2011-08-18 07:00:00	SPY	ETF	117.43	117.72	117.11	117.11	1405347.0
2011-08-18 08:00:00	SPY	ETF	117.15	118.0	116.65	116.73	6584719.0
2011-08-18 09:00:00	SPY	ETF	116.75	116.92	115.52	115.72	57195023.0
2011-08-18 10:00:00	SPY	ETF	115.72	115.72	113.68	114.92	104366799.0
2011-08-18 11:00:00	SPY	ETF	114.92	115.37	114.3	115.26	48910051.0
2011-08-18 12:00:00	SPY	ETF	115.26	119.714	114.71	114.88	32073827.0
2011-08-18 13:00:00	SPY	ETF	114.875	119.714	113.93	114.13	44029885.0
2011-08-18 14:00:00	SPY	ETF	114.13	114.95	113.85	113.87	42353175.0
2011-08-18 15:00:00	SPY	ETF	113.86	119.714	113.39	114.405	113822492.0
2011-08-18 16:00:00	SPY	ETF	114.59	119.714	113.6	114.85	45099657.0
2011-08-18 17:00:00	SPY	ETF	114.86	119.714	114.4	114.79	9480834.0
2011-08-18 18:00:00	SPY	ETF	114.79	115.0	114.61	114.94	318529.0
2011-08-18 19:00:00	SPY	ETF	114.99	115.02	114.19	114.24	527386.0
2011-08-18 04:00:00	QQQ	ETF	53.18	53.18	52.54	52.54	5260.0
2011-08-18 05:00:00	QQQ	ETF	52.33	52.44	52.22	52.44	29700.0
2011-08-18 06:00:00	QQQ	ETF	52.42	52.47	52.3	52.37	139250.0
2011-08-18 07:00:00	QQQ	ETF	52.4	52.49	52.25	52.28	775878.0
2011-08-18 08:00:00	QQQ	ETF	52.29	52.42	52.16	52.25	1569671.0
2011-08-18 09:00:00	QQQ	ETF	52.25	52.32	51.42	51.45	19796173.0
2011-08-18 10:00:00	QQQ	ETF	51.45	51.45	50.72	51.27	29541612.0
2011-08-18 11:00:00	QQQ	ETF	51.27	51.505	51.03	51.47	13001212.0
2011-08-18 12:00:00	QQQ	ETF	51.47	51.62	51.24	51.34	9355957.0
2011-08-18 13:00:00	QQQ	ETF	51.34	51.38	50.87	50.93	9623714.0
2011-08-18 14:00:00	QQQ	ETF	50.94	51.24	50.71	50.72	10378201.0
2011-08-18 15:00:00	QQQ	ETF	50.72	51.135	50.48	50.97	22608131.0
2011-08-18 16:00:00	QQQ	ETF	50.97	51.28	50.95	51.2	2108303.0
2011-08-18 17:00:00	QQQ	ETF	51.19	51.25	51.08	51.12	117608.0
2011-08-18 18:00:00	QQQ	ETF	51.17	51.22	51.11	51.21	74136.0
2011-08-18 19:00:00	QQQ	ETF	51.21	51.24	50.95	50.96	59440.0
2011-08-18 04:00:00	IWM	ETF	69.33	69.51	69.14	69.14	1333.0
2011-08-18 05:00:00	IWM	ETF	68.94	68.94	68.94	68.94	196.0
2011-08-18 06:00:00	IWM	ETF	68.95	69.02	68.82	68.82	5100.0
2011-08-18 07:00:00	IWM	ETF	69.05	69.1	68.6	68.77	48999.0
2011-08-18 08:00:00	IWM	ETF	68.74	68.86	68.45	68.5	1320687.0
2011-08-18 09:00:00	IWM	ETF	68.51	68.62	67.44	67.61	11154651.0
2011-08-18 10:00:00	IWM	ETF	67.6	67.6	66.33	67.46	20672149.0
2011-08-18 11:00:00	IWM	ETF	67.47	67.72	67.0	67.57	8627516.0
2011-08-18 12:00:00	IWM	ETF	67.58	67.6	66.98	67.03	7043238.0
2011-08-18 13:00:00	IWM	ETF	67.03	67.07	66.295	66.46	8200100.0
2011-08-18 14:00:00	IWM	ETF	66.45	66.94	66.3	66.3	9001398.0
2011-08-18 15:00:00	IWM	ETF	66.3	66.71	65.82	66.45	23749049.0
2011-08-18 16:00:00	IWM	ETF	66.45	70.3975	66.243	66.69	7655814.0
2011-08-18 17:00:00	IWM	ETF	66.65	70.3975	66.2394	66.55	1663694.0
2011-08-18 18:00:00	IWM	ETF	66.56	70.3973	66.54	66.66	2006066.0
2011-08-18 19:00:00	IWM	ETF	66.66	66.66	66.39	66.39	7391.0
2011-08-18 04:00:00	DIA	ETF	113.65	113.65	112.7	112.7	830.0
2011-08-18 06:00:00	DIA	ETF	112.4	112.4	112.2	112.2	7400.0

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

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