PREVIEW / etf_1hour / 2011-10-17

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-10-17.parquet
  size:    180 KB
  rows:    5,559

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-10-17 04:00:00	SPY	ETF	123.01	123.6	123.01	123.41	57709.0
2011-10-17 05:00:00	SPY	ETF	123.49	123.5	122.93	122.98	64835.0
2011-10-17 06:00:00	SPY	ETF	122.98	123.06	122.58	122.59	95747.0
2011-10-17 07:00:00	SPY	ETF	122.58	122.63	122.16	122.32	1937180.0
2011-10-17 08:00:00	SPY	ETF	122.32	123.5	122.0	122.09	4642739.0
2011-10-17 09:00:00	SPY	ETF	122.08	122.11	121.5	121.57	23464055.0
2011-10-17 10:00:00	SPY	ETF	121.58	121.6142	120.87	121.21	34213245.0
2011-10-17 11:00:00	SPY	ETF	121.2	121.43	120.96	121.0	16568311.0
2011-10-17 12:00:00	SPY	ETF	121.0	121.07	120.55	120.63	15732122.0
2011-10-17 13:00:00	SPY	ETF	120.63	120.92	120.33	120.61	18545430.0
2011-10-17 14:00:00	SPY	ETF	120.6	122.5492	120.03	120.43	21820009.0
2011-10-17 15:00:00	SPY	ETF	120.43	120.759	119.93	120.21	42540280.0
2011-10-17 16:00:00	SPY	ETF	120.22	121.9	119.66	119.77	20334928.0
2011-10-17 17:00:00	SPY	ETF	119.79	119.81	119.29	119.66	644907.0
2011-10-17 18:00:00	SPY	ETF	119.65	120.24	119.55	119.8	395807.0
2011-10-17 19:00:00	SPY	ETF	119.82	119.96	119.69	119.69	225956.0
2011-10-17 04:00:00	QQQ	ETF	58.56	58.72	58.56	58.72	1111.0
2011-10-17 05:00:00	QQQ	ETF	58.54	58.54	58.4	58.4	4400.0
2011-10-17 06:00:00	QQQ	ETF	58.4	58.5	58.25	58.25	19950.0
2011-10-17 07:00:00	QQQ	ETF	58.22	58.23	58.0	58.04	894688.0
2011-10-17 08:00:00	QQQ	ETF	58.04	58.22	57.8	57.85	3667249.0
2011-10-17 09:00:00	QQQ	ETF	57.85	58.09	57.75	57.87	10810940.0
2011-10-17 10:00:00	QQQ	ETF	57.87	57.9106	57.64	57.689	8208967.0
2011-10-17 11:00:00	QQQ	ETF	57.68	57.87	57.55	57.5571	5022855.0
2011-10-17 12:00:00	QQQ	ETF	57.55	57.55	57.2199	57.3	5975300.0
2011-10-17 13:00:00	QQQ	ETF	57.2958	57.47	57.17	57.3001	4597573.0
2011-10-17 14:00:00	QQQ	ETF	57.3	57.34	56.9716	57.19	5223179.0
2011-10-17 15:00:00	QQQ	ETF	57.19	57.42	57.1	57.29	9801132.0
2011-10-17 16:00:00	QQQ	ETF	57.28	57.46	56.95	57.0	2682413.0
2011-10-17 17:00:00	QQQ	ETF	57.0	57.03	56.76	56.9	361458.0
2011-10-17 18:00:00	QQQ	ETF	56.92	57.04	56.9	57.01	55948.0
2011-10-17 19:00:00	QQQ	ETF	57.04	57.11	57.01	57.02	49651.0
2011-10-17 04:00:00	IWM	ETF	71.68	71.69	71.68	71.69	240.0
2011-10-17 05:00:00	IWM	ETF	71.72	71.72	71.51	71.51	11705.0
2011-10-17 06:00:00	IWM	ETF	71.37	71.42	71.12	71.12	19300.0
2011-10-17 07:00:00	IWM	ETF	71.11	71.11	70.69	70.8	602938.0
2011-10-17 08:00:00	IWM	ETF	70.8	71.02	70.46	70.51	2885522.0
2011-10-17 09:00:00	IWM	ETF	70.51	70.62	70.15	70.24	7212272.0
2011-10-17 10:00:00	IWM	ETF	70.24	70.28	69.7	69.82	10408693.0
2011-10-17 11:00:00	IWM	ETF	69.82	70.05	69.45	69.48	4439753.0
2011-10-17 12:00:00	IWM	ETF	69.47	69.49	69.2025	69.24	4527648.0
2011-10-17 13:00:00	IWM	ETF	69.24	69.39	68.99	69.22	5079225.0
2011-10-17 14:00:00	IWM	ETF	69.22	69.29	68.89	69.25	5093562.0
2011-10-17 15:00:00	IWM	ETF	69.25	69.45	68.63	68.93	11457029.0
2011-10-17 16:00:00	IWM	ETF	68.93	70.34	68.56	68.67	3549818.0
2011-10-17 17:00:00	IWM	ETF	68.7	68.73	68.42	68.55	111172.0
2011-10-17 18:00:00	IWM	ETF	68.63	68.66	68.52	68.56	12946.0
2011-10-17 19:00:00	IWM	ETF	68.66	68.72	68.61	68.61	9887.0
2011-10-17 05:00:00	DIA	ETF	116.78	116.78	116.55	116.55	700.0
2011-10-17 06:00:00	DIA	ETF	116.45	116.45	116.25	116.25	400.0

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

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