PREVIEW / etf_1hour / 2011-08-12

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-12.parquet
  size:    187 KB
  rows:    5,739

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-12 04:00:00	SPY	ETF	116.53	117.27	116.29	116.84	23402.0
2011-08-12 05:00:00	SPY	ETF	116.86	117.87	116.86	117.79	33600.0
2011-08-12 06:00:00	SPY	ETF	117.79	117.84	117.04	117.14	167178.0
2011-08-12 07:00:00	SPY	ETF	117.37	118.21	117.34	117.95	1425433.0
2011-08-12 08:00:00	SPY	ETF	117.95	118.47	115.64	118.29	5382067.0
2011-08-12 09:00:00	SPY	ETF	118.28	119.17	117.63	118.015	53857830.0
2011-08-12 10:00:00	SPY	ETF	118.01	118.63	117.28	117.98	59826659.0
2011-08-12 11:00:00	SPY	ETF	117.98	119.215	117.69	118.9911	36959459.0
2011-08-12 12:00:00	SPY	ETF	119.0	119.11	118.23	118.52	26712026.0
2011-08-12 13:00:00	SPY	ETF	118.52	118.88	118.29	118.78	16821859.0
2011-08-12 14:00:00	SPY	ETF	118.77	118.91	117.76	118.18	37290134.0
2011-08-12 15:00:00	SPY	ETF	118.17	118.48	117.61	118.16	48109775.0
2011-08-12 16:00:00	SPY	ETF	118.16	118.59	117.5209	118.19	20589317.0
2011-08-12 17:00:00	SPY	ETF	118.21	118.36	118.14	118.14	510426.0
2011-08-12 18:00:00	SPY	ETF	118.18	118.3	118.15	118.27	92111.0
2011-08-12 19:00:00	SPY	ETF	118.28	118.33	118.22	118.26	24819.0
2011-08-12 04:00:00	QQQ	ETF	52.5	52.61	52.49	52.61	9822.0
2011-08-12 05:00:00	QQQ	ETF	52.98	53.14	52.98	53.14	200.0
2011-08-12 06:00:00	QQQ	ETF	53.19	53.19	53.0	53.0	1150.0
2011-08-12 07:00:00	QQQ	ETF	52.95	53.29	52.95	53.2	89800.0
2011-08-12 08:00:00	QQQ	ETF	53.17	53.44	52.98	53.35	831805.0
2011-08-12 09:00:00	QQQ	ETF	53.32	53.6	52.94	53.14	17743552.0
2011-08-12 10:00:00	QQQ	ETF	53.14	53.6752	52.88	53.46	18501482.0
2011-08-12 11:00:00	QQQ	ETF	53.47	53.9	53.32	53.81	10197210.0
2011-08-12 12:00:00	QQQ	ETF	53.81	53.85	53.45	53.58	5437857.0
2011-08-12 13:00:00	QQQ	ETF	53.58	53.85	53.56	53.81	3970613.0
2011-08-12 14:00:00	QQQ	ETF	53.82	53.89	53.43	53.57	8297505.0
2011-08-12 15:00:00	QQQ	ETF	53.5679	53.74	53.42	53.57	9501779.0
2011-08-12 16:00:00	QQQ	ETF	53.57	53.69	53.1988	53.63	4294669.0
2011-08-12 17:00:00	QQQ	ETF	53.61	53.65	53.6	53.61	12592.0
2011-08-12 18:00:00	QQQ	ETF	53.63	53.65	53.6	53.6	22464.0
2011-08-12 19:00:00	QQQ	ETF	53.6	53.63	53.56	53.58	67515.0
2011-08-12 04:00:00	IWM	ETF	68.52	68.9	68.35	68.9	986.0
2011-08-12 05:00:00	IWM	ETF	68.66	69.24	68.66	69.24	2375.0
2011-08-12 06:00:00	IWM	ETF	69.01	69.01	69.01	69.01	187.0
2011-08-12 07:00:00	IWM	ETF	69.13	69.65	69.13	69.51	185200.0
2011-08-12 08:00:00	IWM	ETF	69.55	69.96	69.28	69.91	718633.0
2011-08-12 09:00:00	IWM	ETF	69.91	70.6	69.26	69.57	17541002.0
2011-08-12 10:00:00	IWM	ETF	69.57	69.89	68.8	69.55	17893750.0
2011-08-12 11:00:00	IWM	ETF	69.55	70.4	69.23	70.23	9077498.0
2011-08-12 12:00:00	IWM	ETF	70.23	70.33	69.52	69.83	5714252.0
2011-08-12 13:00:00	IWM	ETF	69.8398	70.0	69.593	69.997	3283655.0
2011-08-12 14:00:00	IWM	ETF	70.0	70.23	69.26	69.59	7576960.0
2011-08-12 15:00:00	IWM	ETF	69.59	69.87	69.35	69.79	10068208.0
2011-08-12 16:00:00	IWM	ETF	69.78	69.91	69.7274	69.83	2572825.0
2011-08-12 17:00:00	IWM	ETF	69.85	69.85	69.79	69.8	4200.0
2011-08-12 19:00:00	IWM	ETF	69.77	69.79	69.75	69.79	800.0
2011-08-12 04:00:00	DIA	ETF	111.29	111.29	111.29	111.29	500.0
2011-08-12 05:00:00	DIA	ETF	111.09	111.39	111.09	111.39	700.0
2011-08-12 07:00:00	DIA	ETF	111.17	111.94	111.17	111.94	3000.0

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

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