PREVIEW / etf_1hour / 2011-08-08

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-08.parquet
  size:    211 KB
  rows:    6,541

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-08 04:00:00	SPY	ETF	118.1	118.77	117.78	117.78	32131.0
2011-08-08 05:00:00	SPY	ETF	117.85	118.08	116.98	117.34	113460.0
2011-08-08 06:00:00	SPY	ETF	117.34	117.91	116.84	117.28	352587.0
2011-08-08 07:00:00	SPY	ETF	117.32	118.01	117.17	117.8	3573485.0
2011-08-08 08:00:00	SPY	ETF	117.8	119.216	116.76	117.1	8616992.0
2011-08-08 09:00:00	SPY	ETF	117.11	120.12	116.74	117.56	71733312.0
2011-08-08 10:00:00	SPY	ETF	117.56	117.83	115.27	115.8101	104853692.0
2011-08-08 11:00:00	SPY	ETF	115.81	117.33	115.5333	116.31	68515010.0
2011-08-08 12:00:00	SPY	ETF	116.31	120.1218	115.39	115.61	43435878.0
2011-08-08 13:00:00	SPY	ETF	115.61	116.01	114.08	114.13	65045795.0
2011-08-08 14:00:00	SPY	ETF	114.13	114.84	112.02	113.19	109740067.0
2011-08-08 15:00:00	SPY	ETF	113.18	115.47	112.25	112.28	148668889.0
2011-08-08 16:00:00	SPY	ETF	112.22	117.45	111.48	111.88	38404048.0
2011-08-08 17:00:00	SPY	ETF	111.88	120.1218	111.25	111.58	32273890.0
2011-08-08 18:00:00	SPY	ETF	111.55	112.26	110.6	110.72	1432484.0
2011-08-08 19:00:00	SPY	ETF	110.78	111.23	110.77	111.15	589281.0
2011-08-08 04:00:00	QQQ	ETF	53.36	53.36	52.66	52.66	7450.0
2011-08-08 05:00:00	QQQ	ETF	52.55	52.55	52.3	52.34	12500.0
2011-08-08 06:00:00	QQQ	ETF	52.38	52.5	52.18	52.3	15220.0
2011-08-08 07:00:00	QQQ	ETF	52.42	52.7	52.35	52.63	476678.0
2011-08-08 08:00:00	QQQ	ETF	52.39	52.75	52.35	52.38	2645756.0
2011-08-08 09:00:00	QQQ	ETF	52.38	53.12	52.18	52.69	27212902.0
2011-08-08 10:00:00	QQQ	ETF	52.7	52.78	51.57	51.92	38236406.0
2011-08-08 11:00:00	QQQ	ETF	51.92	52.62	51.82	52.2107	23551074.0
2011-08-08 12:00:00	QQQ	ETF	52.21	52.22	51.84	52.01	11684988.0
2011-08-08 13:00:00	QQQ	ETF	52.01	52.21	51.5	51.52	23376128.0
2011-08-08 14:00:00	QQQ	ETF	51.52	51.84	50.625	51.025	31391448.0
2011-08-08 15:00:00	QQQ	ETF	51.03	51.89	50.62	50.62	31513250.0
2011-08-08 16:00:00	QQQ	ETF	50.63	50.8252	49.93	50.13	5730524.0
2011-08-08 17:00:00	QQQ	ETF	50.15	50.2	49.91	49.95	224060.0
2011-08-08 18:00:00	QQQ	ETF	49.95	50.06	49.53	49.64	442614.0
2011-08-08 19:00:00	QQQ	ETF	49.67	49.85	49.66	49.76	113212.0
2011-08-08 04:00:00	IWM	ETF	70.61	70.61	70.19	70.26	1483.0
2011-08-08 05:00:00	IWM	ETF	69.9	69.9	69.53	69.68	1750.0
2011-08-08 06:00:00	IWM	ETF	69.51	69.56	69.28	69.28	15851.0
2011-08-08 07:00:00	IWM	ETF	69.35	69.88	69.33	69.59	39449.0
2011-08-08 08:00:00	IWM	ETF	70.45	70.69	69.15	69.25	1458170.0
2011-08-08 09:00:00	IWM	ETF	69.24	70.65	68.88	70.04	21006789.0
2011-08-08 10:00:00	IWM	ETF	70.04	70.25	68.44	68.78	29098282.0
2011-08-08 11:00:00	IWM	ETF	68.78	69.8	68.62	68.9	17436261.0
2011-08-08 12:00:00	IWM	ETF	68.89	68.91	67.98	68.02	11664581.0
2011-08-08 13:00:00	IWM	ETF	68.018	68.25	67.22	67.28	12930954.0
2011-08-08 14:00:00	IWM	ETF	67.28	67.6	65.88	66.47	23711379.0
2011-08-08 15:00:00	IWM	ETF	66.46	68.01	65.1	65.14	31259160.0
2011-08-08 16:00:00	IWM	ETF	65.13	65.33	64.47	64.57	8799195.0
2011-08-08 17:00:00	IWM	ETF	64.54	64.6	64.03	64.3	460621.0
2011-08-08 18:00:00	IWM	ETF	64.32	64.43	63.95	64.15	34145.0
2011-08-08 19:00:00	IWM	ETF	64.17	64.35	64.0	64.21	15801.0
2011-08-08 04:00:00	DIA	ETF	112.0	112.1	112.0	112.1	1100.0
2011-08-08 05:00:00	DIA	ETF	112.03	112.24	112.03	112.24	300.0

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

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