PREVIEW / etf_1hour / 2011-08-10

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-10.parquet
  size:    191 KB
  rows:    5,867

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-10 04:00:00	SPY	ETF	117.26	117.26	116.3	117.0	177400.0
2011-08-10 05:00:00	SPY	ETF	117.0	117.82	117.0	117.31	20915.0
2011-08-10 06:00:00	SPY	ETF	117.27	117.49	117.05	117.2	145588.0
2011-08-10 07:00:00	SPY	ETF	117.2	117.36	116.6	116.68	5735959.0
2011-08-10 08:00:00	SPY	ETF	116.7	117.44	115.55	115.65	11184497.0
2011-08-10 09:00:00	SPY	ETF	115.64	115.86	114.02	114.2	70891010.0
2011-08-10 10:00:00	SPY	ETF	114.19	114.77	112.79	113.66	106724588.0
2011-08-10 11:00:00	SPY	ETF	113.64	114.29	112.72	113.94	67616075.0
2011-08-10 12:00:00	SPY	ETF	113.93	114.55	113.22	114.32	47814940.0
2011-08-10 13:00:00	SPY	ETF	114.31	115.25	113.42	115.22	48805686.0
2011-08-10 14:00:00	SPY	ETF	115.22	116.28	114.63	114.66	74358264.0
2011-08-10 15:00:00	SPY	ETF	114.66	114.91	111.95	112.25	122187773.0
2011-08-10 16:00:00	SPY	ETF	112.24	117.4901	112.06	113.31	44043947.0
2011-08-10 17:00:00	SPY	ETF	113.3	117.4901	112.3157	112.81	56070613.0
2011-08-10 18:00:00	SPY	ETF	112.78	117.4901	112.11	112.24	2911563.0
2011-08-10 19:00:00	SPY	ETF	112.24	112.97	112.22	112.95	690874.0
2011-08-10 04:00:00	QQQ	ETF	52.72	52.76	52.43	52.43	1466.0
2011-08-10 05:00:00	QQQ	ETF	52.8	52.94	52.8	52.94	2600.0
2011-08-10 06:00:00	QQQ	ETF	52.74	52.84	52.74	52.8	5308.0
2011-08-10 07:00:00	QQQ	ETF	52.61	52.65	52.4	52.44	248985.0
2011-08-10 08:00:00	QQQ	ETF	52.45	52.73	51.92	51.94	4689339.0
2011-08-10 09:00:00	QQQ	ETF	51.93	52.06	51.37	51.5	26021505.0
2011-08-10 10:00:00	QQQ	ETF	51.51	51.81	51.04	51.36	35960144.0
2011-08-10 11:00:00	QQQ	ETF	51.36	51.77	50.98	51.61	19659612.0
2011-08-10 12:00:00	QQQ	ETF	51.61	51.9	51.32	51.73	14167571.0
2011-08-10 13:00:00	QQQ	ETF	51.73	52.21	51.36	52.2	13298458.0
2011-08-10 14:00:00	QQQ	ETF	52.2009	52.6	51.8	51.82	21162411.0
2011-08-10 15:00:00	QQQ	ETF	51.81	53.0438	50.8	50.89	28968167.0
2011-08-10 16:00:00	QQQ	ETF	50.89	51.44	50.8	51.39	5810490.0
2011-08-10 17:00:00	QQQ	ETF	51.36	51.4	51.11	51.17	145205.0
2011-08-10 18:00:00	QQQ	ETF	51.15	51.18	50.91	51.0	66291.0
2011-08-10 19:00:00	QQQ	ETF	50.99	51.35	50.99	51.35	40940.0
2011-08-10 04:00:00	IWM	ETF	69.02	69.02	68.5	68.5	3337.0
2011-08-10 05:00:00	IWM	ETF	69.06	69.06	69.01	69.01	200.0
2011-08-10 06:00:00	IWM	ETF	69.04	69.04	69.04	69.04	2000.0
2011-08-10 07:00:00	IWM	ETF	68.81	68.81	68.53	68.54	59380.0
2011-08-10 08:00:00	IWM	ETF	68.71	68.71	67.57	67.69	1408955.0
2011-08-10 09:00:00	IWM	ETF	67.68	68.16	66.71	67.41	23655143.0
2011-08-10 10:00:00	IWM	ETF	67.42	67.99	66.64	67.31	33046184.0
2011-08-10 11:00:00	IWM	ETF	67.28	67.53	66.74	67.27	16434820.0
2011-08-10 12:00:00	IWM	ETF	67.28	67.65	66.74	67.38	11729769.0
2011-08-10 13:00:00	IWM	ETF	67.36	68.01	66.8	67.91	13295425.0
2011-08-10 14:00:00	IWM	ETF	67.91	68.83	67.56	67.58	21097717.0
2011-08-10 15:00:00	IWM	ETF	67.58	67.86	65.87	66.02	26968757.0
2011-08-10 16:00:00	IWM	ETF	66.02	69.5754	65.985	66.53	10296965.0
2011-08-10 17:00:00	IWM	ETF	66.55	69.5752	66.16	66.46	3580841.0
2011-08-10 18:00:00	IWM	ETF	66.34	66.35	66.09	66.09	19441.0
2011-08-10 19:00:00	IWM	ETF	66.01	66.57	66.01	66.27	27492.0
2011-08-10 05:00:00	DIA	ETF	112.37	112.37	112.37	112.37	100.0
2011-08-10 07:00:00	DIA	ETF	111.7	111.9	111.3	111.36	17366.0

> showing 50 of 5,867 rows — these rows as CSV

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