PREVIEW / etf_1hour / 2011-09-27

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-09-27.parquet
  size:    188 KB
  rows:    5,833

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-27 04:00:00	SPY	ETF	116.7	117.69	116.7	117.54	32132.0
2011-09-27 05:00:00	SPY	ETF	117.62	117.9	117.53	117.8	41996.0
2011-09-27 06:00:00	SPY	ETF	117.78	118.0	117.63	117.97	245857.0
2011-09-27 07:00:00	SPY	ETF	118.0	118.52	117.83	118.3	1666005.0
2011-09-27 08:00:00	SPY	ETF	118.31	118.45	117.91	118.39	2574161.0
2011-09-27 09:00:00	SPY	ETF	118.38	118.95	118.18	118.84	38661561.0
2011-09-27 10:00:00	SPY	ETF	118.84	119.26	118.33	119.23	46302377.0
2011-09-27 11:00:00	SPY	ETF	119.24	119.26	118.66	118.89	25839747.0
2011-09-27 12:00:00	SPY	ETF	118.88	119.28	118.64	118.84	20891383.0
2011-09-27 13:00:00	SPY	ETF	118.84	119.4	118.72	119.3	20921890.0
2011-09-27 14:00:00	SPY	ETF	119.29	119.56	118.98	119.05	25328312.0
2011-09-27 15:00:00	SPY	ETF	119.05	119.051	116.84	117.55	90538338.0
2011-09-27 16:00:00	SPY	ETF	117.56	118.8844	116.2357	117.57	33851917.0
2011-09-27 17:00:00	SPY	ETF	117.55	117.69	117.44	117.56	203919.0
2011-09-27 18:00:00	SPY	ETF	117.55	117.6	117.35	117.39	305032.0
2011-09-27 19:00:00	SPY	ETF	117.38	117.56	117.34	117.42	217107.0
2011-09-27 04:00:00	QQQ	ETF	55.0	55.29	55.0	55.29	5235.0
2011-09-27 05:00:00	QQQ	ETF	55.32	55.37	55.29	55.37	3700.0
2011-09-27 06:00:00	QQQ	ETF	55.37	55.44	55.33	55.36	2688.0
2011-09-27 07:00:00	QQQ	ETF	55.41	55.73	55.4	55.57	397124.0
2011-09-27 08:00:00	QQQ	ETF	55.58	55.66	55.51	55.6	620017.0
2011-09-27 09:00:00	QQQ	ETF	55.6	55.76	55.35	55.68	10656722.0
2011-09-27 10:00:00	QQQ	ETF	55.66	55.97	55.36	55.95	12125543.0
2011-09-27 11:00:00	QQQ	ETF	55.96	55.97	55.63	55.721	7106880.0
2011-09-27 12:00:00	QQQ	ETF	55.73	55.99	55.59	55.74	6597894.0
2011-09-27 13:00:00	QQQ	ETF	55.74	56.15	55.67	56.0799	7535827.0
2011-09-27 14:00:00	QQQ	ETF	56.08	56.2	55.86	55.91	7255209.0
2011-09-27 15:00:00	QQQ	ETF	55.91	55.91	54.98	55.33	21805364.0
2011-09-27 16:00:00	QQQ	ETF	55.33	55.52	54.801	55.39	3446987.0
2011-09-27 17:00:00	QQQ	ETF	55.38	55.4	55.32	55.4	216685.0
2011-09-27 18:00:00	QQQ	ETF	55.4	55.41	55.29	55.3	124840.0
2011-09-27 19:00:00	QQQ	ETF	55.32	55.38	55.25	55.25	19274.0
2011-09-27 04:00:00	IWM	ETF	66.82	67.35	66.82	67.15	9537.0
2011-09-27 05:00:00	IWM	ETF	67.22	67.22	67.22	67.22	200.0
2011-09-27 06:00:00	IWM	ETF	67.37	67.37	67.37	67.37	500.0
2011-09-27 07:00:00	IWM	ETF	67.53	67.87	67.5	67.7	156074.0
2011-09-27 08:00:00	IWM	ETF	67.67	67.75	67.56	67.73	1015463.0
2011-09-27 09:00:00	IWM	ETF	67.73	68.21	67.55	68.16	11379650.0
2011-09-27 10:00:00	IWM	ETF	68.14	68.64	67.87	68.6	11778256.0
2011-09-27 11:00:00	IWM	ETF	68.6	68.68	68.35	68.56	10048124.0
2011-09-27 12:00:00	IWM	ETF	68.55	69.02	68.5	68.95	7990632.0
2011-09-27 13:00:00	IWM	ETF	68.97	69.21	68.82	69.12	5986064.0
2011-09-27 14:00:00	IWM	ETF	69.12	69.39	68.9	68.94	7752413.0
2011-09-27 15:00:00	IWM	ETF	68.93	68.945	67.27	67.77	22582370.0
2011-09-27 16:00:00	IWM	ETF	67.77	68.03	67.72	67.83	3276336.0
2011-09-27 17:00:00	IWM	ETF	67.85	67.85	67.75	67.8	26216.0
2011-09-27 18:00:00	IWM	ETF	67.83	67.83	67.69	67.69	13520.0
2011-09-27 19:00:00	IWM	ETF	67.69	67.82	67.67	67.8	28561.0
2011-09-27 06:00:00	DIA	ETF	111.45	111.65	111.05	111.05	3800.0
2011-09-27 07:00:00	DIA	ETF	111.89	112.15	111.57	112.15	13900.0

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

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