PREVIEW / etf_1hour / 2011-09-19

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-09-19.parquet
  size:    180 KB
  rows:    5,544

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-09-19 04:00:00	SPY	ETF	120.0	120.11	119.33	119.4	343531.0
2011-09-19 05:00:00	SPY	ETF	119.48	119.66	119.37	119.66	38413.0
2011-09-19 06:00:00	SPY	ETF	119.63	120.0	119.5	119.95	121456.0
2011-09-19 07:00:00	SPY	ETF	119.86	120.14	119.85	119.89	973682.0
2011-09-19 08:00:00	SPY	ETF	119.89	120.3	119.5	119.64	2769437.0
2011-09-19 09:00:00	SPY	ETF	119.64	119.77	118.81	118.87	34329976.0
2011-09-19 10:00:00	SPY	ETF	118.85	119.27	118.72	118.97	29468626.0
2011-09-19 11:00:00	SPY	ETF	118.98	119.925	118.96	119.625	30105742.0
2011-09-19 12:00:00	SPY	ETF	119.63	119.85	119.12	119.23	16357320.0
2011-09-19 13:00:00	SPY	ETF	119.23	119.5	119.02	119.47	13745736.0
2011-09-19 14:00:00	SPY	ETF	119.47	120.05	119.22	119.58	25000920.0
2011-09-19 15:00:00	SPY	ETF	119.575	120.93	119.39	120.32	64482135.0
2011-09-19 16:00:00	SPY	ETF	120.31	121.5132	119.67	120.34	20434109.0
2011-09-19 17:00:00	SPY	ETF	120.34	120.34	120.15	120.19	1167175.0
2011-09-19 18:00:00	SPY	ETF	120.22	120.34	119.27	119.29	1104487.0
2011-09-19 19:00:00	SPY	ETF	119.26	119.59	119.14	119.56	588473.0
2011-09-19 04:00:00	QQQ	ETF	55.98	55.98	55.69	55.69	8962.0
2011-09-19 05:00:00	QQQ	ETF	55.7	55.87	55.7	55.86	3250.0
2011-09-19 06:00:00	QQQ	ETF	55.83	55.96	55.78	55.96	8400.0
2011-09-19 07:00:00	QQQ	ETF	55.96	56.02	55.88	55.94	222039.0
2011-09-19 08:00:00	QQQ	ETF	55.91	55.96	55.85	55.86	466891.0
2011-09-19 09:00:00	QQQ	ETF	55.86	55.93	55.43	55.46	8041966.0
2011-09-19 10:00:00	QQQ	ETF	55.45	55.79	55.44	55.6898	7589716.0
2011-09-19 11:00:00	QQQ	ETF	55.69	56.46	55.6898	56.23	9809879.0
2011-09-19 12:00:00	QQQ	ETF	56.24	56.34	55.98	56.05	4806898.0
2011-09-19 13:00:00	QQQ	ETF	56.04	56.23	55.95	56.211	4404490.0
2011-09-19 14:00:00	QQQ	ETF	56.22	56.49	56.075	56.24	7343024.0
2011-09-19 15:00:00	QQQ	ETF	56.24	56.91	56.13	56.63	19479283.0
2011-09-19 16:00:00	QQQ	ETF	56.62	56.66	56.51	56.62	7331731.0
2011-09-19 17:00:00	QQQ	ETF	56.6	56.6	56.52	56.53	18666.0
2011-09-19 18:00:00	QQQ	ETF	56.55	56.61	56.26	56.26	70435.0
2011-09-19 19:00:00	QQQ	ETF	56.25	56.39	56.19	56.37	55523.0
2011-09-19 04:00:00	IWM	ETF	70.86	70.86	70.04	70.04	3550.0
2011-09-19 05:00:00	IWM	ETF	70.12	70.26	70.12	70.26	350.0
2011-09-19 06:00:00	IWM	ETF	70.27	70.41	70.27	70.41	2828.0
2011-09-19 07:00:00	IWM	ETF	70.4	70.59	70.4	70.45	42055.0
2011-09-19 08:00:00	IWM	ETF	70.41	70.5	70.3	70.3	338796.0
2011-09-19 09:00:00	IWM	ETF	70.3	70.38	69.47	69.51	10252535.0
2011-09-19 10:00:00	IWM	ETF	69.5	70.0	69.45	69.728	8746346.0
2011-09-19 11:00:00	IWM	ETF	69.73	70.66	69.71	70.44	6861442.0
2011-09-19 12:00:00	IWM	ETF	70.45	70.63	69.65	69.73	4826439.0
2011-09-19 13:00:00	IWM	ETF	69.73	70.03	69.59	70.0	4788130.0
2011-09-19 14:00:00	IWM	ETF	70.0	70.18	69.74	69.85	8174149.0
2011-09-19 15:00:00	IWM	ETF	69.85	71.01	69.75	70.28	18172838.0
2011-09-19 16:00:00	IWM	ETF	70.28	70.36	70.06	70.16	4937212.0
2011-09-19 17:00:00	IWM	ETF	70.16	70.16	70.04	70.05	21797.0
2011-09-19 18:00:00	IWM	ETF	70.1	70.12	69.75	69.75	38007.0
2011-09-19 19:00:00	IWM	ETF	69.7	69.73	69.56	69.73	12167.0
2011-09-19 07:00:00	DIA	ETF	113.65	113.75	113.55	113.55	5100.0
2011-09-19 08:00:00	DIA	ETF	113.83	113.83	113.33	113.34	120030.0

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

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