PREVIEW / etf_1hour / 2011-10-27

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-10-27.parquet
  size:    204 KB
  rows:    6,381

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-27 04:00:00	SPY	ETF	125.96	126.5	125.96	126.16	224529.0
2011-10-27 05:00:00	SPY	ETF	126.11	126.77	126.11	126.74	65290.0
2011-10-27 06:00:00	SPY	ETF	126.73	126.93	126.58	126.88	364847.0
2011-10-27 07:00:00	SPY	ETF	126.9	127.25	126.75	127.12	2313557.0
2011-10-27 08:00:00	SPY	ETF	127.1	127.51	125.44	127.33	9834477.0
2011-10-27 09:00:00	SPY	ETF	127.32	127.85	127.12	127.141	46375949.0
2011-10-27 10:00:00	SPY	ETF	127.14	127.24	126.61	127.135	50632522.0
2011-10-27 11:00:00	SPY	ETF	127.13	127.7	127.04	127.67	32190935.0
2011-10-27 12:00:00	SPY	ETF	127.67	128.08	127.66	127.79	31689940.0
2011-10-27 13:00:00	SPY	ETF	127.8	128.61	127.79	128.57	27736079.0
2011-10-27 14:00:00	SPY	ETF	128.56	128.93	128.35	128.68	37568603.0
2011-10-27 15:00:00	SPY	ETF	128.68	129.42	127.98	128.6	85777916.0
2011-10-27 16:00:00	SPY	ETF	128.59	128.85	124.3187	128.74	23865706.0
2011-10-27 17:00:00	SPY	ETF	128.75	128.9	124.3187	128.71	9939010.0
2011-10-27 18:00:00	SPY	ETF	128.73	128.76	128.53	128.66	655243.0
2011-10-27 19:00:00	SPY	ETF	128.66	128.92	128.66	128.86	161034.0
2011-10-27 04:00:00	QQQ	ETF	57.88	58.22	57.88	58.19	4825.0
2011-10-27 05:00:00	QQQ	ETF	58.2	58.3	58.1	58.3	900.0
2011-10-27 06:00:00	QQQ	ETF	58.3	58.35	58.22	58.34	21700.0
2011-10-27 07:00:00	QQQ	ETF	58.31	58.5	58.3	58.47	245858.0
2011-10-27 08:00:00	QQQ	ETF	58.47	58.55	58.37	58.45	3001137.0
2011-10-27 09:00:00	QQQ	ETF	58.46	58.725	58.42	58.42	13775287.0
2011-10-27 10:00:00	QQQ	ETF	58.42	58.45	58.03	58.28	13869290.0
2011-10-27 11:00:00	QQQ	ETF	58.28	58.52	58.15	58.49	8407121.0
2011-10-27 12:00:00	QQQ	ETF	58.496	58.69	58.496	58.52	5160521.0
2011-10-27 13:00:00	QQQ	ETF	58.53	59.04	58.53	59.04	6349040.0
2011-10-27 14:00:00	QQQ	ETF	59.04	59.12	58.89	58.9598	8724842.0
2011-10-27 15:00:00	QQQ	ETF	58.9507	59.2	58.64	58.85	15494425.0
2011-10-27 16:00:00	QQQ	ETF	58.85	58.92	58.7624	58.92	1693916.0
2011-10-27 17:00:00	QQQ	ETF	58.88	58.94	58.86	58.9	135116.0
2011-10-27 18:00:00	QQQ	ETF	58.9	58.92	58.86	58.86	16733.0
2011-10-27 19:00:00	QQQ	ETF	58.89	58.98	58.87	58.97	22078.0
2011-10-27 04:00:00	IWM	ETF	73.7	73.98	73.7	73.98	3079.0
2011-10-27 05:00:00	IWM	ETF	73.95	73.95	73.95	73.95	264.0
2011-10-27 06:00:00	IWM	ETF	74.15	74.28	74.15	74.26	9100.0
2011-10-27 07:00:00	IWM	ETF	74.25	74.8	74.18	74.78	340189.0
2011-10-27 08:00:00	IWM	ETF	74.76	75.06	74.18	75.0	2550052.0
2011-10-27 09:00:00	IWM	ETF	75.0	75.439	74.71	74.72	11195025.0
2011-10-27 10:00:00	IWM	ETF	74.7	75.14	74.49	74.9	14847843.0
2011-10-27 11:00:00	IWM	ETF	74.9	75.72	74.83	75.69	11769071.0
2011-10-27 12:00:00	IWM	ETF	75.68	76.18	75.68	75.99	13859653.0
2011-10-27 13:00:00	IWM	ETF	75.99	76.63	75.99	76.62	11363637.0
2011-10-27 14:00:00	IWM	ETF	76.62	76.86	76.26	76.68	16188042.0
2011-10-27 15:00:00	IWM	ETF	76.69	76.97	76.02	76.43	18383606.0
2011-10-27 16:00:00	IWM	ETF	76.42	76.63	72.6516	76.49	7566978.0
2011-10-27 17:00:00	IWM	ETF	76.5	76.56	76.47	76.54	19493.0
2011-10-27 18:00:00	IWM	ETF	76.59	76.61	76.4	76.4	1300.0
2011-10-27 19:00:00	IWM	ETF	74.67	76.56	74.55	76.56	1075638.0
2011-10-27 04:00:00	DIA	ETF	119.82	120.23	119.82	120.23	5800.0
2011-10-27 05:00:00	DIA	ETF	120.15	120.4	120.15	120.4	19500.0

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

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